phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chandu <>
Subject Re: Data loaded from Hbase is not visible in Phoenix
Date Thu, 05 Feb 2015 09:39:56 GMT
You have to double quotes to get correct mapping from phoenix to hbase
Try using the upper case letters for all column families & column names in
HBase & try the query again from phoenix.

Also, I faced similar issue when I created a index on phoenix table. It was
showing data till the point of creation of index. After that timestamp,
whatever the rows are inserted into Hbase are not reflected in phoenix
table on HDP2.2, but it was showing up in cloudera 5.2. However, index was
not updated when inserted through hbase in both the cases.


On 5 February 2015 at 05:20, Siva <> wrote:

> Hi Everyone,
> I created a table in Phoenix. I loaded the data through Hbase since I m
> facing issues with Phoenix loader. I could see the data from Hbase after
> data load when I query it, but when I query the same table in Phoenix  I
> don’t see any data, all the columns are being shown as NUL values.
> I understand that Hbase stores the data in Byte format, since I created
> the table in Phoenix and loaded it through HBase, how does phoenix
> interprets the data types. Could someone throw some light on whats
> happening behind the scenes?
> Thanks,
> Siva.


View raw message