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'
WITH RECORD DELIMITED BY '\n'
FIELD DELIMITED BY '\01'
I've tried using '^A', '\a', '\01', '0x01' and I'm stumped.