https://community.cloudera.com/t5/Archives-of-Support-Questions/import-tables-from-sqlserver-to-hbase-with-out-hbase-row-key/m-p/159004#M29061 <A rel="user" href="https://community.cloudera.com/users/7369/omkarmotoe.html" nodeid="7369">@omkar pathallapalli</A><P>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</P> Fri, 20 May 2016 18:21:04 GMT jyadav 2016-05-20T18:21:04Z https://community.cloudera.com/t5/Archives-of-Support-Questions/import-tables-from-sqlserver-to-hbase-with-out-hbase-row-key/m-p/159003#M29060 Fri, 20 May 2016 16:55:12 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/import-tables-from-sqlserver-to-hbase-with-out-hbase-row-key/m-p/159003#M29060 omkarmotoe 2016-05-20T16:55:12Z https://community.cloudera.com/t5/Archives-of-Support-Questions/import-tables-from-sqlserver-to-hbase-with-out-hbase-row-key/m-p/159004#M29061 <A rel="user" href="https://community.cloudera.com/users/7369/omkarmotoe.html" nodeid="7369">@omkar pathallapalli</A><P>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</P> Fri, 20 May 2016 18:21:04 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/import-tables-from-sqlserver-to-hbase-with-out-hbase-row-key/m-p/159004#M29061 jyadav 2016-05-20T18:21:04Z https://community.cloudera.com/t5/Archives-of-Support-Questions/import-tables-from-sqlserver-to-hbase-with-out-hbase-row-key/m-p/159005#M29062 <P>Hbase is a key value store so it will require any one col to be declared as row key.</P><P>can you share the schema of sqllserver and how you want it to look in hbase?</P> Fri, 20 May 2016 19:31:41 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/import-tables-from-sqlserver-to-hbase-with-out-hbase-row-key/m-p/159005#M29062 asinghal 2016-05-20T19:31:41Z https://community.cloudera.com/t5/Archives-of-Support-Questions/import-tables-from-sqlserver-to-hbase-with-out-hbase-row-key/m-p/159006#M29063 <P>Yes, sqoop considers <STRONG>split-by column(</STRONG>--split-by &lt;column-name&gt;<B>)</B> as the rowkey if --hbase-row-key is not specified.</P> Fri, 20 May 2016 19:35:13 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/import-tables-from-sqlserver-to-hbase-with-out-hbase-row-key/m-p/159006#M29063 asinghal 2016-05-20T19:35:13Z