kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yout na <youtn...@gmail.com>
Subject Function in SQL did not trigger predicate pushdown
Date Mon, 09 Sep 2019 16:27:32 GMT
Hi
    I write a SQL like :
        select column_1, column_2, count(*) from table where column_date =
CURRENT_DATE() group by column_1, column_2;
    I think this SQL will trigger predicate pushdown at CURRENT_DATE(),
 but when I see then log, I think it did not.
   The following is the picture of log:
[image: image.png]
  when set a clearly date in sql the log is :
[image: image.png]
 date 2019-09-08 is current_date() -1 and the current_date log is :
[image: image.png]
 Because the current_date() cube is not build so total scan is 0.

The kylin Version is : 3.0.0-alpha2

Mime
View raw message