如下两个sql,差别是第二个hotel_code in的列表少一个元素(如红框标注),但性能差别很大:
<http://apache-kylin.74782.x6.nabble.com/file/n8630/%E5%BE%AE%E4%BF%A1%E5%9B%BE%E7%89%87_20170803162007.png>
 
<http://apache-kylin.74782.x6.nabble.com/file/n8630/%E5%BE%AE%E4%BF%A1%E5%9B%BE%E7%89%87_20170803162100.png>
 

个人觉得是in的元素过多,转换成rowkey比较多,导致kylin直接对表进行全部扫描,如果想不管rowkey多少,始终想通过rowkey进行查询该如何做?


--
View this message in context: 
http://apache-kylin.74782.x6.nabble.com/sql-in-tp8630.html
Sent from the Apache Kylin mailing list archive at Nabble.com.

Reply via email to