Hi Robber,
Sqoop currently supports importing only into single column family. You can import data twice
using two different column families in each case and parameter --columns to filter only relevant
columns for given column family.
Jarcec
On Mon, May 20, 2013 at 09:42:14PM +0800, Robber Phex wrote:
> I have a table in mysql like this:
> +-------+-------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +-------+-------------+------+-----+---------+-------+
> | id | int(11) | NO | PRI | NULL | |
> | name | varchar(45) | YES | | NULL | |
> | age | int(11) | YES | | NULL | |
> | email | varchar(20) | YES | | NULL | |
> | title | varchar(10) | YES | | NULL | |
> +-------+-------------+------+-----+---------+-------+
> I want to export it to hbase by sqoop.
> I execute this:
> sqoop import --connect jdbc:mysql://h2/test --username testu --password
> testp \
> --table testtable --hbase-create-table --hbase-table hbasetable \
> --column-family name --column-family age --column-family email
> --column-family title \
> --hbase-row-key id
>
> I get full data in hbase, but I want custom row-family. Exactly I need
> transformation like this:
>
> HBase MySQL Columns
>
> row key <----------- id
> baseinfo <----------- name
> `-<--- age
> workinfo <----------- email
> `-<--- title
>
> Anyone have any idea?
>
> --
> Regards,
> RobberPhex
>
> About me: http://about.me/RobberPhex
|