sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abraham Elmahrek <...@cloudera.com>
Subject Re: Sqoop export id issues
Date Mon, 30 Sep 2013 02:13:11 GMT
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 <shengjie.min@gmail.com>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
>
>

Mime
View raw message