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

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://\BACDASD;databaseName=dswFICO" \

--username user \

--password user \

--table hadoop_export \

--export-dir /tmp/sql_backup/part-m-00000 -m 1 --fields-terminated-by '\01'


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 .


Rising Star

Can you share the output error you are getting?

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.