Hi Sameer, No, that wouldn't be expected. Can you share a unit test with us that repros this? Thanks, James
On Fri, Apr 25, 2014 at 5:30 PM, Sameer Babu K K <[email protected]>wrote: > 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 > > >
