Problem in HBase-Phoenix map

["G.S.Vijay Raajaa" <gs...@gmail.com>]

Hi,

    I created a simple table in HBase:

ROW                   COLUMN+CELL

 123                  column=cf:id, timestamp=1394264765505, value=id:123

 123                  column=cf:name, timestamp=1394264772000, value=vijay

*And I map it in Phoenix using:*

*create table "phoenix-map" (rowid VARCHAR PRIMARY KEY,"cf"."id"
VARCHAR,"cf"."name" VARCHAR)*

Now I find an unusual column qualifier entry added to the HBase table:

ROW                   COLUMN+CELL

* 123                  column=cf:_0, timestamp=1394264772000, value=  *

 123                  column=cf:id, timestamp=1394264765505, value=id:123

 123                  column=cf:name, timestamp=1394264772000, value=vijay

Kindly explain the context!!

Regards,
Vijay Raajaa G S

Re: Problem in HBase-Phoenix map

[Ravi Kiran <ma...@gmail.com>]

Hi Vijay,
   Phoenix adds one extra, empty-valued KeyValue to each row in your column
family to ensure queries return the correct results.
   You can read more about that at
http://phoenix.incubator.apache.org/language/index.html#create

Regards
Ravi.


On Sat, Mar 8, 2014 at 1:25 PM, G.S.Vijay Raajaa <gs...@gmail.com>wrote:

> Hi,
>
>     I created a simple table in HBase:
>
> ROW                   COLUMN+CELL
>
>  123                  column=cf:id, timestamp=1394264765505, value=id:123
>
>  123                  column=cf:name, timestamp=1394264772000, value=vijay
>
> *And I map it in Phoenix using:*
>
> *create table "phoenix-map" (rowid VARCHAR PRIMARY KEY,"cf"."id"
> VARCHAR,"cf"."name" VARCHAR)*
>
> Now I find an unusual column qualifier entry added to the HBase table:
>
> ROW                   COLUMN+CELL
>
> * 123                  column=cf:_0, timestamp=1394264772000, value=  *
>
>  123                  column=cf:id, timestamp=1394264765505, value=id:123
>
>  123                  column=cf:name, timestamp=1394264772000, value=vijay
>
> Kindly explain the context!!
>
> Regards,
> Vijay Raajaa G S
>