Hi,
We are trying out phoenix to integrate our SQL Query Builder with HBase.
Created a table in HBase using the Phoenix driver and inserted some records to
fetch from the Query Builder. Most of the queries executed fine with some
changes in the dialect. But I couldn't get the following queries working:
select count(*) as count from t1 where t1.tat = 'test'
This query returns the count of all rows in table whether there is a match for
the filter or not.
select count(*) as count, t1.tat from t1 where t1.time1utc <=
TO_DATE('2014-04-29 05:02:35.768', 'yyyy-MM-dd HH:mm:ss.SSS') group by t1.tat;
This query returns returns proper results when there are rows matching the
filter but returns count of all rows in the table when there is no match.
I just want to check whether this is a known issue or something wrong with the
setup.
Best Regards,
Sameer
