Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

hi, i am able to list the databases but i am unable to import a table from database iam getting the error i have given like this sqoop import jdbe:sqlserver;//xxx.xxx.xx.xx:1433/sample --table TEST--username uname --password pwd -m 1

avatar
Rising Star

3823-capture.png

1 ACCEPTED SOLUTION

avatar
Expert Contributor

Can you please provide the jdbc connection string ? Are you giving something like this : jdbc:sqlserver://xx.xx.x.xxx:1433;databaseName=Test

View solution in original post

4 REPLIES 4

avatar
Expert Contributor

Can you please provide the jdbc connection string ? Are you giving something like this : jdbc:sqlserver://xx.xx.x.xxx:1433;databaseName=Test

avatar
Rising Star

i have given like this sqoop import jdbe:sqlserver;//xxx.xxx.xx.xx:1433/sample --table TEST--username uname --password pwd -m 1

avatar
Guru

As @nyadav pointed out, you need to use the URL as jdbc:sqlserver://xx.xx.x.xxx:1433;databaseName=sample instead of the way that you are entereing for SQL Server. List databases worked since you haven't used a database in the jdbc URL there.

avatar