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

Hope i explained ok.

Any thoughts on this problem?


Reply via email to