The example below works great
select column(s)
from table
where column in (val1,val2,val3,...val50)

However when I try to do something like:
select column(s)
from table
where column1 in (val1,val2,val3,...val50)
and column2 in (val1,val2)

I receive a value timeout exception.
*ScannerTimeoutException: 342556ms passed since the last invocation,
timeout is currently set to 60000*



When watching the kylin_query log I've noticed the query will work when I
see something like:

Scan hbase cubiod  exact match
Start: \x00 ....
Stop: \x00 ....
Fuzzy \x00 ...

When the second in operator is in use the Hbase scan doesn't display the
Fuzzy data.

Scan hbase table KYLIN_O03ZWB4DK9: cuboid exact match, from 57344 to 57344
Start: \x00\x00\x00\x00\x00\x00\xE0\x00\x04\x48\x30\xBB\x00\xB2     -
\x00\x00\x00\x00\x00\x00\xE0\x00\x04H0\xBB\x00\xB2
Stop:  \x00\x00\x00\x00\x00\x00\xE0\x00\x05\x36\x31\xAB\x03\x8D\x00 -
\x00\x00\x00\x00\x00\x00\xE0\x00\x0561\xAB\x03\x8D\x00

Then starts the next scan.

Reply via email to