CODEWITHSUNDEEP
mysqlhadoophbasebigdatasqoop
Manideep Reddy N
Manideep Reddy N

Reputation: 23

Sqoop Syntax error, unexpected tIdentifier

I'm trying to load MySQL table to hbase using sqoop. I'm using the below command but it is showing unexpected tIdentifier error. Please help.

sqoop import --connect jdbc:mysql://localhost/manideep --username root --password cloudera --table sample --hbase-table H_LOAN --column-family CD --hbase-row-key id -m 1

Upvotes: 1

Views: 827

Answers (1)

Ajar
Ajar

Reputation: 162

Using the following command has worked for me to achieve hbase table import in Sgoop:

sqoop import --connect "jdbc:mysql://localhost/manideep" --username <username> --password ****** --table <mysql-table-name> --columns "column1,colmn2,column3" --hbase-table <hbase-table-name> --column-family <hbase-table-column-family> --hbase-row-key <row-key-column-name> -m 1

If the solution does not work, please post the exact issue (exception details) you have faced.

Upvotes: 0

Related Questions