CODEWITHSUNDEEP
mysqlhbasesqoop
Vimal Jain
Vimal Jain

Reputation: 577

Error while importing data from Mysql to Hbase using sqoop

I am trying to import data from Mysql to Hbase using sqoop. I am running following command.

sqoop import --connect jdbc:mysql://localhost/database --table users --columns "loginid,email" --username tester -P -m 8 --hbase-table hbaseTable --hbase-row-key user_id --column-family user_info --hbase-create-table

But i am getting below error :-

13/05/08 10:42:10 WARN hbase.ToStringPutTransformer: Could not insert row with null value for row-key column: user_id

please help here

Upvotes: 3

Views: 2000

Answers (2)

james.peng
james.peng

Reputation: 403

Your columns should be upper status, not seq_id but SEQ_ID.

I think sqoop considering it as a different column.which is null(Of course).

Upvotes: 1

Vimal Jain
Vimal Jain

Reputation: 577

Got the solution. I was not including my rowKey i.e. user_id in the columns list. After including it , it worked like a charm. Thanks..

Upvotes: 2

Related Questions