You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@sqoop.apache.org by Chalcy <ch...@gmail.com> on 2012/09/28 19:37:46 UTC

sqoop hbase create table

Hi,

I am looking for sample sqoop import command to import into hbase even when
the hbase table is not there.

The command I am using now is sqoop import --connect "blah connection"
--query "blah query" -m 1 --hbase-create-table --hbase-row-key mydbkey

If I have target-dir in there, then sqoop gets data into hdfs and no trace
of hbase action and no error as well.

I have been using sqoop in and out of hive successfully.

Thanks,
Chalcy

Re: sqoop hbase create table

Posted by Chalcy <ch...@gmail.com>.

Thanks! Alok.  It did work.  I had to add --column-family as well.

Cheers,
Chalcy :)

On Sat, Sep 29, 2012 at 11:22 AM, Alok Kumar <al...@gmail.com> wrote:

> try this
>
> sqoop import --connect "blah connection" --query "blah query" -m 1 *--hbase-table
> <hbase-table-to-be-created>* --hbase-create-table --hbase-row-key mydbkey
>
> with "--hbase-create-table" option, It expects --hbase-table <table-name>,
> sqoop will  create hbase table for you.
>
>
>
> On Fri, Sep 28, 2012 at 11:07 PM, Chalcy <ch...@gmail.com> wrote:
>
>>
>> Hi,
>>
>> I am looking for sample sqoop import command to import into hbase even
>> when the hbase table is not there.
>>
>> The command I am using now is sqoop import --connect "blah connection"
>> --query "blah query" -m 1 --hbase-create-table --hbase-row-key mydbkey
>>
>> If I have target-dir in there, then sqoop gets data into hdfs and no
>> trace of hbase action and no error as well.
>>
>> I have been using sqoop in and out of hive successfully.
>>
>> Thanks,
>> Chalcy
>>
>
>
> --
> Alok
>
>
>

Re: sqoop hbase create table

Posted by Alok Kumar <al...@gmail.com>.

try this

sqoop import --connect "blah connection" --query "blah query" -m 1
*--hbase-table
<hbase-table-to-be-created>* --hbase-create-table --hbase-row-key mydbkey

with "--hbase-create-table" option, It expects --hbase-table <table-name>,
sqoop will  create hbase table for you.


On Fri, Sep 28, 2012 at 11:07 PM, Chalcy <ch...@gmail.com> wrote:

>
> Hi,
>
> I am looking for sample sqoop import command to import into hbase even
> when the hbase table is not there.
>
> The command I am using now is sqoop import --connect "blah connection"
> --query "blah query" -m 1 --hbase-create-table --hbase-row-key mydbkey
>
> If I have target-dir in there, then sqoop gets data into hdfs and no trace
> of hbase action and no error as well.
>
> I have been using sqoop in and out of hive successfully.
>
> Thanks,
> Chalcy
>


-- 
Alok