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 20:10:56 GMT
That's great,

Thank you.

Atte,


On Wed, Apr 9, 2014 at 12:55 PM, Ravi Kiran <maghamravikiran@gmail.com>wrote:

> Hi
>
>    You can override the behavior by setting the property *
> phoenix.schema.dropMetaData* to FALSE. For further reading,
> http://phoenix.incubator.apache.org/language/index.html#drop_table.
>
> Regards
> Ravi
>
>
> On Thu, Apr 10, 2014 at 1:06 AM, Kleiton Silva <kleiton.contato@gmail.com>wrote:
>
>> 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