Hi Samarth, Thank you for the information! Is there a Phoenix version compatible with HBase 0.96? I see that both 2 and 3 are compatible only with 0.94.x
Best Regards, Sameer On Monday, April 28, 2014 3:06 PM, Samarth Jain <[email protected]> wrote: Hi Sameer, As of now, Phoenix 4.x is compatible only with HBase 0.98 and beyond. Can you try with 0.98 HBase? I ran your tests on the latest Phoenix 4 and they all pass except for one. The failing test case has a bug and it should be: @Test public void countWithFilterAndGroupByWithNoMatch() throws Exception { Statement stmt = con.createStatement(); ResultSet rset = stmt .executeQuery("select count(*) as count, tat from t1 where time1utc <= TO_DATE('2012-04-21 05:02:35.768', 'yyyy-MM-dd HH:mm:ss.SSS') group by tat"); assertFalse(rset.next()); rset.close(); stmt.close(); } Thanks, Samarth On Fri, Apr 25, 2014 at 7:12 PM, Sameer Babu K K <[email protected]> wrote: Hi James, > >HBase vesion is 0.96.1.1-cdh5.0.0 and phoenix 4.0.0 > >Attached please find the test. I get strange results for group by with no >match test as it returns the same as with match. > >Best Regards, >Sameer > > > > > >On Friday, April 25, 2014 6:05 PM, James Taylor <[email protected]> wrote: > >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 >>> >>> >>> >>> >>> >> > > >
