Hi Shengjie, this is expected behaviour when the column used for row key is not added to the column data. You need to set property sqoop.hbase.add.row.key if you need to repeat such column's value inside the data as well, for example:
sqoop import -Dsqoop.hbase.add.row.key=true --connect ...
Jarcec
On Sun, Sep 22, 2013 at 05:46:03PM +0800, Shengjie Min wrote:
> Hi guys,
>
> I have a mysql table looks like:
>
> Mebmer_ID <- primary key
> Member_Name
> Member_Type
>
> I ran the command below:
>
> ./bin/sqoop import --connect jdbc:mysql://${ip}/testdb -username root
> -password blabla --query 'SELECT * from member where Member_ID < 5 AND
> $CONDITIONS' --split-by Member_ID --hbase-create-table --hbase-table member
> --column-family i
>
> But after import, I see hbase table looks like:
> rowkey - row : 1
> Columns - Member_name=bla, Member_Type=bla
>
> Note that Sqoop turned my Member_ID to Rowkey which is expected. But in my
> columns, I am seeing all the other fields except Member_ID. Is there anyway
> I can have Member_ID as my rowkey,also in Column Family, having the
> Member_ID column included as well?
>
> Shengjie
signature.asc
Description: Digital signature
