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

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 <[EMAIL PROTECTED]> 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

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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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
>
>
>