question Re: 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 in Archives of Support Questions (Read Only)

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

omkarmotoe — Mon, 19 Aug 2019 10:27:06 GMT

Re: 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

nyadav — Fri, 29 Apr 2016 14:21:08 GMT

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

Re: 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

omkarmotoe — Fri, 29 Apr 2016 14:36:27 GMT

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

Re: 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

SQLShaw — Fri, 29 Apr 2016 18:54:35 GMT

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-1.html

Re: 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

ravi1 — Fri, 29 Apr 2016 20:08:11 GMT

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.