RE: Problems running queries (not same amount of results)

2016-09-22 Thread Jure Buble
Sorry it was my typo. No this was not an issue. But thanks for noticing. BR Jure From: Steve Terrell [mailto:sterr...@oculus360.us] Sent: Thursday, September 22, 2016 5:36 PM To: user@phoenix.apache.org Subject: Re: Problems running queries (not same amount of results) Could it be due to a

Re: Problems running queries (not same amount of results)

2016-09-22 Thread Steve Terrell
Could it be due to a mistake in your SQL? select c1, c4, c5 from TABLE1 where (c4 = 'B')*)* AND (c1 <= TO_DATE('22.09.2016 17:15:59', 'dd.MM. HH:mm:ss')); looks like an out of place ")". On Thu, Sep 22, 2016 at 4:10 AM, Jure Buble wrote: > Hi, > > Anyone faced same problems as we are? > >

Problems running queries (not same amount of results)

2016-09-22 Thread Jure Buble
Hi, Anyone faced same problems as we are? We are using phoenix 4.6 with hbase 1.1.2. We have multiple entries in table. When we run query on that table with condition for one of the columns in table, let's say for column 4, we don't get hit for that condition. E.g.: table row has under 4th colu