phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kleiton Silva <kleiton.cont...@gmail.com>
Subject Re: Basic mapping to HBase table
Date Wed, 09 Apr 2014 18:57:53 GMT
It's work.

Result

 PK      a         b          c
 row1 value1   row2 value2  row3

 value3

Thank you very much Jerry.

Kleiton




On Wed, Apr 9, 2014 at 10:12 AM, Jerry Lam <chilinglam@gmail.com> wrote:

> you can try:
>
> CREATE table "test" ( pk VARCHAR PRIMARY KEY, "cf"."a" VARCHAR, ,
> "cf"."b" VARCHAR, "cf"."c" VARCHAR );
>
>
>
> On Wed, Apr 9, 2014 at 12:40 PM, Kleiton Silva <kleiton.contato@gmail.com>wrote:
>
>> Firas,
>>
>> I have the follow table in hbase:
>>
>> hbase(main):032:0> scan 'test'
>> ROW                      COLUMN+CELL
>>
>>  row1                    column=cf:a, timestamp=1397068853016,
>> value=value1
>>  row2                    column=cf:b, timestamp=1397068857098,
>> value=value2
>>  row3                    column=cf:c, timestamp=1397068861755,
>> value=value3
>>
>>
>> When a try to create table using Phoenix, use the command:
>>
>>  CREATE table "test" ( pk VARCHAR PRIMARY KEY, "cf"."val" VARCHAR );
>>
>>
>> The result is :
>>
>> *PK*          * val*
>>  row1        <null>  row2        <null>  row3         <null>
>>
>> Could you help me?
>>
>> Thank you.
>>
>> Kleiton
>>
>>
>> On Tue, Apr 8, 2014 at 6:19 AM, Firas Khasawneh <Firas.Khasawneh@sas.com>wrote:
>>
>>>  Thanks Pankaj!
>>>
>>>
>>>
>>> *From:* Pankaj kr [mailto:pankaj.kr@huawei.com]
>>> *Sent:* Tuesday, April 08, 2014 12:50 AM
>>>
>>> *To:* user@phoenix.incubator.apache.org
>>> *Subject:* RE: Basic mapping to HBase table
>>>
>>>
>>>
>>> Hi Firas,
>>>
>>>
>>>
>>>                 Phoenix doesn't work with Accumulo.
>>>
>>>
>>>
>>>
>>> Kindly check the below link for more details,
>>>
>>> http://phoenix.incubator.apache.org/
>>>
>>> Cheers,
>>>
>>> Pankaj
>>>
>>>
>>>
>>>
>>>
>>> *From:* Firas Khasawneh [mailto:Firas.Khasawneh@sas.com<Firas.Khasawneh@sas.com>]
>>>
>>> *Sent:* 07 April 2014 20:46
>>> *To:* user@phoenix.incubator.apache.org
>>> *Subject:* RE: Basic mapping to HBase table
>>>
>>>
>>>
>>> Hi all,
>>>
>>>
>>>
>>> Does phoenix work only with HBase or does it also work with Accumulo?
>>>
>>>
>>>
>>> Thanks,
>>>
>>> Firas
>>>
>>>
>>>
>>> *From:* Pankaj kr [mailto:pankaj.kr@huawei.com <pankaj.kr@huawei.com>]
>>> *Sent:* Monday, April 07, 2014 9:15 AM
>>> *To:* user@phoenix.incubator.apache.org
>>> *Subject:* RE: Basic mapping to HBase table
>>>
>>>
>>>
>>> Hi Daniel,
>>>
>>>
>>>
>>>                 You mapped the HBase table using the below statement,
>>>
>>>                                         CREATE VIEW "t1" ( pk VARCHAR
>>> PRIMARY KEY, "f1".val VARCHAR );
>>>
>>>                 By default, Phoenix sends characters in capital letter,
>>> so here second column of view is mapped to the qualifier "f1:VAL".
>>>
>>>
>>>
>>> But  you inserted records at HBase in "f1:val" instead of "f1:VAL" as,
>>>
>>> r1   column=f1:val, timestamp=1396558762590, value=a
>>>
>>>
>>>
>>>                 So NULL value is displayed in VAL column at Phoenix
>>> side.
>>>
>>>
>>>
>>> You can map as "f1"."val" to resolve this or insert records in "f1:VAL".
>>>
>>>
>>>
>>> Cheers,
>>>
>>> Pankaj
>>>
>>>
>>>
>>> *From:* Daniel Rodriguez [mailto:df.rodriguez143@gmail.com<df.rodriguez143@gmail.com>]
>>>
>>> *Sent:* 04 April 2014 06:18
>>> *To:* user
>>> *Subject:* Basic mapping to HBase table
>>>
>>>
>>>
>>> Hi all,
>>>
>>>
>>>
>>> I spent a couple of hours today trying phoenix for the first time, looks
>>> amazing.
>>>
>>>
>>>
>>> My final objective is to do SQL on a big hbase table that has a
>>> composite key, i decided to start slow and I was able to create a table on
>>> phoenix, upsert values and see them on hbase, but I am not able to do the
>>> oposite: map (using a view) values on an existing hbase to a phoenix table,
>>> i am always getting "null" values.
>>>
>>>
>>>
>>> Here is a basic example copied from the docs:
>>>
>>>
>>>
>>> HBASE:
>>>
>>> > create 't1', {NAME => 'f1', VERSIONS => 5}
>>>
>>>
>>>
>>> PHOENIX:
>>>
>>> > CREATE VIEW "t1" ( pk VARCHAR PRIMARY KEY, "f1".val VARCHAR );
>>> > select * from "t1";
>>> +------------+------------+
>>> |     PK     |    VAL     |
>>> +------------+------------+
>>> +------------+------------+
>>>
>>>
>>>
>>> Works fine since there is no data.
>>>
>>>
>>>
>>> I add data to hbase:
>>>
>>> > put 't1,'r1','f1','a'
>>>
>>> > scan 't1'
>>>
>>> ROW                                           COLUMN+CELL
>>>
>>>  r1                                           column=f1:,
>>> timestamp=1396558806334, value=a
>>>
>>>
>>>
>>> But if i try to select from phoenix i get only null values.:
>>>
>>> > select * from "t1";
>>>
>>> +------------+------------+
>>>
>>> |     PK     |    VAL     |
>>>
>>> +------------+------------+
>>>
>>> | r1         | null       |
>>>
>>> +------------+------------+
>>>
>>>
>>>
>>> I also tried to save it on an specific column in the column family:
>>>
>>>
>>>
>>> > scan 't1'
>>>
>>> ROW                                           COLUMN+CELL
>>>
>>>  r1                                           column=f1:,
>>> timestamp=1396558806334, value=a
>>>
>>>  r1                                           column=f1:val,
>>> timestamp=1396558762590, value=a
>>>
>>>
>>>
>>> I also tried to change from varchar to integer and insert numbers but i
>>> got the same result in both cases.
>>>
>>>
>>>
>>> I am using phoenix 2.2.0 on EMR.
>>>
>>>
>>>
>>> Any help you can give me is appreciated.
>>>
>>>
>>>
>>> Thanks,
>>>
>>> Daniel
>>>
>>
>>
>

Mime
View raw message