Hi there,
can someone help me figure out whats the problem on my sqoop command?
sqoop export --connect "jdbc:sqlserver://xx.xx.xxx.xx.\BACDASD;databaseName=dswFICO" \
--username user \
--password user \
--table hadoop_export \
--export-dir /tmp/sql_backup/part-m-00000 -m 1 --fields-terminated-by '\01'
note:
hadoop_export - this table is on ms sql server that will contain my exported data.
--export-dir /tmp/sql_backup/part-m-00000 - this is the file i imported from other ms sql server and i want this to be exported to hadoop_export table .