phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siva <sbhavan...@gmail.com>
Subject Re: Data loaded from Hbase is not visible in Phoenix
Date Thu, 05 Feb 2015 21:40:36 GMT
Hi Chandu,

Data is showing up after specifying all the qualifiers in uppercase as part
of bulk loading from Hbase. Thanks a lot for your help.

Thanks,
Siva.

On Thu, Feb 5, 2015 at 1:39 AM, Chandu <chandugunturi@gmail.com> wrote:

> You have to double quotes to get correct mapping from phoenix to hbase
> columns.
> 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.
>
> Thanks,
> Chandu.
>
> On 5 February 2015 at 05:20, Siva <sbhavanari@gmail.com> 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.
>>
>>
>
>
> --
> Cheers,
> Chandu.
>

Mime
View raw message