AnsweredAssumed Answered

sqoop export hive to teradata

Question asked by ssoma on Feb 25, 2018
Latest reply on Feb 26, 2018 by ssoma
Branched to a new discussion

Hi,

 

I'm  trying to export hive external table data into teradata. when i run the export command below is the error i am getting, can some one please help on this issue.

 

Error: java.io.IOException: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.00.00.35] [Error 3706] [SQLState 42000] Syntax error: expected something between ')' and ','.

 

below are the table details.

hive table:

CREATE EXTERNAL TABLE mytab_load(field1 STRING, field2 STRING, field3 STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE
LOCATION '/maprfs;/../../mytab_load'

 

Sqoop Export:

sqoop export --driver com.teradata.jdbc.TeraDriver --connect "jdbc:teradata://localhost/database=dbname" --password "xxxx" --username "usser" --table "mytab_load" --num-mappers 1 --export-dir "/maprfs:/../../mytab_load" --input-fields-terminated-by '\t'

 

Thank You,

Suresh

Outcomes