Skip to Content
0
Jun 04, 2013 at 01:49 AM

Problem with IMPORT FROM when file used SOH character as field delimiter - created using AWS HIVE

972 Views

Hi All,

I'm pressed with a nagging problem. I'm using AWS HIVE to output the results of a HIVE query to an output file that I'm going to load into SAP HANA. The problem is that HIVE output files using the SOH character ^A, \01, 0x01 as the field delimiter. I have no idea on how to specify this non-printable character in the IMPORT FROM statement. Here is an example:

IMPORT FROM CSV FILE '/wiki-data/year=2013/month=04/000000'

INTO "WIKIPEDIA"."pagecounts"

WITH RECORD DELIMITED BY '\n'

FIELD DELIMITED BY '\01'

I've tried using '^A', '\a', '\01', '0x01' and I'm stumped.

Any ideas?

Regards,

Bill