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

[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 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 
mailto:j...@salviol.com>> wrote:
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 column value 'B'. If our condition is where 
column4 = 'B', we dont get hit. But if we use some different condition e.g. 5th 
column for some other value we got hit for that row.
So query is like:
select c1, c4, c5  from TABLE1 where (c4 = 'B')) AND (c1 <= TO_DATE('22.09.2016 
17:15:59', 'dd.MM. HH:mm:ss'));

We checked if 4th column has value B in, and it is char and it is B. So it is 
really strange why we cannot use condition on 4th row and  get result.

Strange enough when we do select c1, c4, c5   from TABLE1; we get the row in 
question.

Hope i explained ok.

Any thoughts on this problem?


Regards
Jure

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

[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?
>
> 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 column value 'B'. If our condition is where
> column4 = 'B', we dont get hit. But if we use some different condition e.g.
> 5th column for some other value we got hit for that row.
>
> So query is like:
>
> select c1, c4, c5  from TABLE1 where (c4 = 'B')) AND (c1 <=
> TO_DATE('22.09.2016 17:15:59', 'dd.MM. HH:mm:ss'));
>
>
>
> We checked if 4th column has value B in, and it is char and it is B. So it
> is really strange why we cannot use condition on 4th row and  get result.
>
>
>
> Strange enough when we do select c1, c4, c5   from TABLE1; we get the row
> in question.
>
>
>
> Hope i explained ok.
>
>
>
> Any thoughts on this problem?
>
>
>
>
>
> Regards
>
> Jure
>
>
>
>
>
>