Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Sqoop export id issues


Copy link to this message
-
Re: Sqoop export id issues
Hey There,

I'm not entirely sure, but I don't think that this can be changed. To keep
natural ordering, the row-keys would have to be left-padded with some
character (usually a 0).

What version of sqoop are you using?

-Abe
On Sat, Sep 28, 2013 at 10:13 PM, Shengjie Min <[EMAIL PROTECTED]>wrote:

> Hi guys,
>
> I have a mysql table like:
>
> user_id, user_name, user_address
>
> 1, alice, xxx
> 2, bob, nnn
> ....
> 10,
> 11,
> 12
> ...
> 20,
> 21,
> 22,
> ....
>
> after sqoop export to HBase using --split-by user_id, in my HBase, the
> sequence of rows looks differently.
>
> 1,
> 11,
> 12,
> 13,
> 14,
> ...
> 2,
> 21,
> 22,
> 23
> ...
> 3
>
> I think HBase rowkey is comparing byte value while sorting. How do I solve
> this issue, have HBase rowkey has the same order as the original table?
>
> All the best,
> Shengjie
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB