Hi Alicia, Issue is resolved after the changing the column qualifiers to uppercase. here is the response from one of the user Chandu.
------------------------------------------- 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 ------------------------------------------- Appreciate for your response. Thanks, Siva. On Thu, Feb 5, 2015 at 1:15 PM, Alicia Shu <[email protected]> wrote: > Data types are enforced by Phoenix. Hbase stores raw data. Can you use > ³Upsert² to insert data into the table and make sure type consistency? > Then see whether you will see data. > > Alicia > > On 2/5/15, 12:34 PM, "Siva" <[email protected]> wrote: > > >Hi Alicia, thanks for you response, but Data types in Hbase are always in > >Byte type.. how can we explicitly specify the type information for column > >qualifiers in Hbase? > > > >On Wed, Feb 4, 2015 at 4:33 PM, Alicia Shu <[email protected]> wrote: > > > >> Make sure the data types you created in Phoenix table are the same as > >> those types when you load the data from Hbase. > >> > >> Alicia > >> > >> On 2/4/15, 1:23 PM, "Siva" <[email protected]> wrote: > >> > >> >e the data from Hbase after > >> >data load when I query it, > >> > >> > >
