Support Questions
Find answers, ask questions, and share your expertise

Im trying to load the data from hive to ms sql server

Im trying to load the data from hive to ms sql server

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 .

1 REPLY 1
Highlighted

Re: Im trying to load the data from hive to ms sql server

Rising Star

Can you share the output error you are getting?