Also, what version of Phoenix and HBase are you using?
On Fri, Apr 25, 2014 at 6:04 PM, James Taylor <[email protected]>wrote: > 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 >> >> >> >
