Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Rising Star
 
1 ACCEPTED SOLUTION

avatar

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

avatar
Super Guru
@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

avatar

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?

avatar

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