import tables from sqlserver to hbase with out --hbase-row-key? is it possible??

[#1]

@omkar pathallapalli

By default sqoop will look for primary key column in the source table and convert it as hbase key while importing into hbase but in case you don't have primary key in source table then you have to specify the column in --hbase-row-key

[#2]

Hbase is a key value store so it will require any one col to be declared as row key.

can you share the schema of sqllserver and how you want it to look in hbase?

[#3 · Accepted solution]

Yes, sqoop considers split-by column(--split-by <column-name>) as the rowkey if --hbase-row-key is not specified.