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 > >
