question Re: how to export file which field delimited by "^A " in Archives of Support Questions (Read Only)

how to export file which field delimited by "^A "

SACHINICHAKE09 — Fri, 16 Sep 2022 10:26:14 GMT

Hi There,

my file is "^A " delimted which i want to export using sqoop . do you know how can we handle such special charater .

Re: how to export file which field delimited by "^A "

vina — Mon, 20 Jun 2016 10:26:01 GMT

Can you try using '\' as '\^A'

Re: how to export file which field delimited by "^A "

SACHINICHAKE09 — Mon, 20 Jun 2016 10:41:56 GMT

It is not working.. pfb log for your refernece .

hduser@jgusbihdpmaster:/tmp$ sqoop export --connect jdbc:oracle:thin:olap7964/olap7964@192.168.2.135:1521:ORCLOBIA11G --username XXXXXXX --password XXXXXXX --export-dir /user/hive/warehouse/abc.db/sach_sport --table SACH_SPORT --fields-terminated-by '\^A' -m 1 Warning: /opt/cloudera/parcels/CDH-5.5.1-1.cdh5.5.1.p0.11/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. 16/06/20 03:37:39 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.5.1 16/06/20 03:37:39 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. Cannot understand character argument: \^A

Re: how to export file which field delimited by "^A "

vina — Mon, 20 Jun 2016 11:07:31 GMT

Can you try:

TERMINATED BY '\136'

Re: how to export file which field delimited by "^A "

Harsh J — Mon, 20 Jun 2016 11:09:41 GMT

The "^A" is a visual shell representation of the ASCII hexadecimal byte "01".

You can run your command as so, making use of the actual byte representation than a visual helper:

sqoop export --connect jdbc:oracle:thin:olap7964/olap7964@192.168.2.135:1521:ORCLOBIA11G --username XXXXXXX --password XXXXXXX --export-dir /user/hive/warehouse/abc.db/sach_sport --table SACH_SPORT --fields-terminated-by $'\x01' -m 1

Re: how to export file which field delimited by "^A "

SACHINICHAKE09 — Mon, 20 Jun 2016 11:10:01 GMT

Nope.. Same error..

Re: how to export file which field delimited by "^A "

SACHINICHAKE09 — Mon, 20 Jun 2016 11:13:46 GMT

yeah... its working..

i was able to find out its hex value (its control-v + control-a) character but was not applying '$' symbol.

Thank you so much .. 🙂

really appreciated..