sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Venkat Ranganathan <vranganat...@hortonworks.com>
Subject Re: Not able to import data from "MYSQL table with composite key" to HBASE
Date Tue, 25 Jun 2013 14:57:44 GMT
The feature you referenced just got committed and will be part of Sqoop
1.4.4

Venkat


On Tue, Jun 25, 2013 at 5:39 AM, <shouvanik.haldar@accenture.com> wrote:

>  Hi,****
>
> ** **
>
> The requirement is:****
>
> ** **
>
> I have a MYSQL table with composite key :****
>
> ** **
>
> CREATE TABLE track(   album CHAR(10) NOT NULL,   dsk INTEGER NOT NULL,
> posn INTEGER NOT NULL,   song VARCHAR(255),   PRIMARY KEY (album, dsk,
> posn) );****
>
> ** **
>
> I browsed on GOOGLE and found out that SQOOP version 1.4.3 supports
> composite key ->
> http://www.mail-archive.com/dev@sqoop.apache.org/msg05109.html ****
>
> ** **
>
> After downloading the bundle->
> http://apache.spinellicreations.com/sqoop/1.4.3/ and installing it, I ran
> the sqoop command as below to achieve the same****
>
> ** **
>
> bin/sqoop import -connect jdbc:mysql://localhost/arijitdb --username user
> --table track --hbase-table track --column-family rating --hbase-row-key
> album,dsk,posn --hbase-create-table****
>
> ** **
>
> *But, *when I query the HBASE table, I find that indeed a table is
> created with name *track * but, there is no data inside.****
>
> ** **
>
> Can anybody please help?****
>
> ** **
>
> Regards,****
>
> Shouvanik****
>
> ** **
>
> ** **
>
> ------------------------------
> This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise confidential information. If you have
> received it in error, please notify the sender immediately and delete the
> original. Any other use of the e-mail by you is prohibited.
>
> Where allowed by local law, electronic communications with Accenture and
> its affiliates, including e-mail and instant messaging (including content),
> may be scanned by our systems for the purposes of information security and
> assessment of internal compliance with Accenture policy.
>
>
> ______________________________________________________________________________________
>
> www.accenture.com
>

Mime
View raw message