phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siva <sbhavan...@gmail.com>
Subject Mapping HBase table in Phoenix
Date Tue, 10 Feb 2015 20:46:45 GMT
Hi Everyone,



When I map a table in Phoenix from Hbase which has two column families, I
could not able to see the data for 2nd column family from Phoenix.



Hbase:



create 'tab_2_cf', 'cf1', 'cf2'



put 'tab_2_cf', 'r1', 'cf1:name', 'asdf'



put 'tab_2_cf', 'r1', 'cf1:address', 'CALIF'



>From Phoenix:



create view "tab_2_cf"(pk varchar primary key, "cf1"."name" varchar,
"cf2"."address" varchar);



queried the table from phoenix, data is being shown as NULL for Column
address.



0: jdbc:phoenix:172.31.45.176:2181:/hbase> select * from "tab_2_cf";

+------------+------------+------------+

|     PK     |    name    |  *address*   |

+------------+------------+------------+

| r1         | asdf       | null       |

+------------+------------+------------+



Any help on this?



Thanks,

Siva.

Mime
View raw message