phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "xuxc1120" <xuxc1...@vip.qq.com>
Subject 回复:Mapping HBase table in Phoenix
Date Wed, 11 Feb 2015 05:45:06 GMT
just as  you said,it has 2 families in your table:'cf1'and 'cf2', ‍
but you mapped "cf2"."address"  into the ‍view and you put "‍address" in 'cf1' family,so
you will get a NULL in the view.‍
xuxc.




------------------ 原始邮件 ------------------
发件人: "Siva";<sbhavanari@gmail.com>;
发送时间: 2015年2月11日(星期三) 凌晨4:46
收件人: "user"<user@phoenix.apache.org>; "dev"<dev@phoenix.apache.org>; 

主题: Mapping HBase table in Phoenix




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