I'm trying to sqoop import from Teradata using the below command
sqoop import --connect jdbc:teradata://xxx --username xxx-P
--query "SELECT TOP 1000 col,col2 from tble where 1=1 AND \$CONDITIONS"
--escaped-by ',' --fields-terminated-by ','
--target-dir /hadoop/dev/test -m1
Currently the data has , in the fields and is not escaped using --escaped-by parameter too.
Is there any other way?
Thanks,but the now the problem looks like it has \n characters within data and unable to escape them.
Because hive-import-drop-delims parameter is also not supported in Teradata.
Any suggestions ?