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 19:36:40 GMT
Another question, in this case is possible drop table without delete table
in Hbase?

Thank you

Atte.,


On Wed, Apr 9, 2014 at 11:57 AM, Kleiton Silva <kleiton.contato@gmail.com>wrote:

> 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