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

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

Contributor

3823-capture.png

1 ACCEPTED SOLUTION

Rising Star

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

Rising Star

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

Contributor

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

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.

; ;