Support Questions
Find answers, ask questions, and share your expertise

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

Contributor
 
1 ACCEPTED SOLUTION

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

View solution in original post

3 REPLIES 3

@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

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?

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

; ;