- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
import tables from sqlserver to hbase with out --hbase-row-key? is it possible??
- Labels:
-
Apache HBase
Created 05-20-2016 09:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Created 05-20-2016 12:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, sqoop considers split-by column(--split-by <column-name>) as the rowkey if --hbase-row-key is not specified.
Created 05-20-2016 11:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 05-20-2016 12:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Created 05-20-2016 12:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, sqoop considers split-by column(--split-by <column-name>) as the rowkey if --hbase-row-key is not specified.
