CODEWITHSUNDEEP
clouderasqoopimpala
Akangsha Nirmale
Akangsha Nirmale

Reputation: 1

sqoop query to get sql server data into cloudera manager

sqoop import --connect 'jdbc:sqlserver://IP address;username=user;password=pswd;database=Master' --table [Person].[BusinessEntityContact] --target-dir /home/ubuntu/hdfs/dir is not working .

Reference:http://mapredit.blogspot.com/2011/10/sqoop-and-microsoft-sql-server.html [1]: https://i.sstatic.net/W5mBB.png

Upvotes: 0

Views: 1027

Answers (3)

Mohit
Mohit

Reputation: 1

Best way to check is using sqoop list-tables command, something as follows: sqoop list-tables -connect 'jdbc:sqlserver://IP address;username=user;password=pswd;database=Master' -username --password

Upvotes: 0

Sriram Chitturi
Sriram Chitturi

Reputation: 1

Nirmale can you try from your unix box to

curl http://131.107.174.121:1433

If you get "Empty reply from server" it is ok, or if you get an error like "couldn't connect to host", check with your SQL Server admin as to what port the SQL Server is listening on.

Upvotes: 0

Vasanth kumar
Vasanth kumar

Reputation: 21

In your error logs got SQLServerException and says "Connect timed out. Verify the connection properties.". Please check whether you have access from where you try run this command and also MSSQL port "1433". Then add number of maps "-m" in your command.

Upvotes: 0

Related Questions