Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

Rising Star

Can you share the output error you are getting?

Don't have an account?
Coming from Hortonworks? Activate your account here