What's the Kylin version? The many IN filter has been through a couple of optimizations. Want to make sure you are on latest code.
On Fri, Jan 8, 2016 at 4:37 AM, James Jones <[email protected]> wrote: > 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. >
