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

Posted to user@phoenix.apache.org by manya cancerian <ma...@gmail.com> on 2016/01/28 13:26:19 UTC

Fwd: Using Sqoop to load HBase tables , Data not visible via Phoenix

Looking for some help in the following scenario -

- I have created on Phoenix table which created underneath HBase table.

- Then used sqoop command to move data from relational database database
table (Teradata) to underneath HBase table successfully

- I can view the data through HBase but it is not visible in Phoenix table.

What i missing here ?

Regards
Manya

Re: Using Sqoop to load HBase tables , Data not visible via Phoenix

Posted by Ravi Kiran <ma...@gmail.com>.

Hi Manya,
  We are working with the Sqoop team to have our patch[1] that enables data
imports to Phoenix table directly.  In the mean time,   you can apply the
patch to Sqoop 1.4.6 source and give it a try.

Please do let us know how it goes .

[1] https://issues.apache.org/jira/browse/SQOOP-2649

Regards
Ravi

On Thu, Jan 28, 2016 at 4:42 AM, rafa <ra...@gmail.com> wrote:

> Hi Manya,
>
> see this thread:
>
>
> http://mail-archives.apache.org/mod_mbox/incubator-phoenix-user/201512.mbox/%3CCAOnY4Jd6u9T8-Ce2Lp54CbH_a8zj41FVc=iXT=z8hp8-mxvhiw@mail.gmail.com%3E
>
>
> http://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table
>
> regards,
> rafa
>
>
> On Thu, Jan 28, 2016 at 1:26 PM, manya cancerian <manyacancerian@gmail.com
> > wrote:
>
>>
>>
>>
>> Looking for some help in the following scenario -
>>
>> - I have created on Phoenix table which created underneath HBase table.
>>
>> - Then used sqoop command to move data from relational database database
>> table (Teradata) to underneath HBase table successfully
>>
>> - I can view the data through HBase but it is not visible in Phoenix
>> table.
>>
>> What i missing here ?
>>
>> Regards
>> Manya
>>
>>
>>
>>
>>
>

Re: Using Sqoop to load HBase tables , Data not visible via Phoenix

Posted by rafa <ra...@gmail.com>.

Hi Manya,

see this thread:

http://mail-archives.apache.org/mod_mbox/incubator-phoenix-user/201512.mbox/%3CCAOnY4Jd6u9T8-Ce2Lp54CbH_a8zj41FVc=iXT=z8hp8-mxvhiw@mail.gmail.com%3E

http://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table

regards,
rafa


On Thu, Jan 28, 2016 at 1:26 PM, manya cancerian <ma...@gmail.com>
wrote:

>
>
>
> Looking for some help in the following scenario -
>
> - I have created on Phoenix table which created underneath HBase table.
>
> - Then used sqoop command to move data from relational database database
> table (Teradata) to underneath HBase table successfully
>
> - I can view the data through HBase but it is not visible in Phoenix table.
>
> What i missing here ?
>
> Regards
> Manya
>
>
>
>
>