1-844-696-6465 (US)        +91 77600 44484        help@dezyre.com

unable to load hbase using sqoop



0
executed the below command sqoop import --connect dbc:mysql://192.168.59.312\retail_db --username root --password cloudera --table emp --hbase-table hemp --column-family pers --hbase-row-key id
--hbase-create-table.

getting below error

Error executing statement: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Can you please update what is the settings i have to do for loading hbase and verify the syntax of sqoop command?

1 Answer(s)


0

Hi RadhaKrishna,
Please use the following command:
sqoop import --connect jdbc:mysql://192.168.59.312/retail_db --username root -P --table emp --hbase-table hemp --column-family pers --hbase-row-key id
--hbase-create-table

You can also refer the following link:
http://www.dummies.com/how-to/content/importing-data-into-hbase-with-sqoop.html

Hope this helps.
Thanks.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password