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
>
>
>
>
>
>
>
