Support Questions

Find answers, ask questions, and share your expertise

Error while export data from HDFS to SQL Server table which has no primary key?

Explorer

I am using ambari.

I want to export data from HDFS to SQL Server .

I have Installed jdbc driver.

I have created table in SQL Server which has no primary key.

I execute this command,

sqoop export --connect "jdbc:sqlserver://localhost:1433;database=db_name;username=user_name;password =*****" --table table_name --export-dir /SqoopData/output -m 1

But it display message like "Error during export: Export job failed!".

15901-sperror.png

which parameter we should use in export command so that the data loaded into table(which has no primary key) successfully.

2 REPLIES 2

Explorer

@priyal patel

You can look at the application logs from the failed application. To fetch them run the following command as the user who ran the Sqoop command.

yarn logs -applicationId application_1496289796598_0013 > appln_logs.txt

appln_logs.txt would contain more details on the errors. Please post them here If you can't figure out.

Explorer

yarn logs -applicationId application_1496289796598_0013 > appln_logs.txt

yarn logs -applicationId application_1496289796598_0013

15926-sperror.png

15927-spe1.png

15928-spe2.png

15929-spe3.png

15930-spe4.png

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