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

[#1]

[#2 · Accepted solution]

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

[#3]

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

[#4]

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.

[#5]

This is a duplicate question. See here for more information: https://community.hortonworks.com/questions/30348/hi-i-am-able-to-list-the-databases-but-i-am-unable...