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 <[email protected]>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 <[email protected]> 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 <[email protected] >> > 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 <[email protected] >>> > wrote: >>> >>>> Thanks Pankaj! >>>> >>>> >>>> >>>> *From:* Pankaj kr [mailto:[email protected]] >>>> *Sent:* Tuesday, April 08, 2014 12:50 AM >>>> >>>> *To:* [email protected] >>>> *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:[email protected]<[email protected]>] >>>> >>>> *Sent:* 07 April 2014 20:46 >>>> *To:* [email protected] >>>> *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:[email protected] <[email protected]>] >>>> *Sent:* Monday, April 07, 2014 9:15 AM >>>> *To:* [email protected] >>>> *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:[email protected]<[email protected]>] >>>> >>>> *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 >>>> >>> >>> >> >
