i have query on external hive table with druid storage handler select * from testingddruid a where `__time` >= CURRENT_DATE() it is very slow to fetch result, but if i changed CURRENT_DATE() to string such as `__time` >= '2021-01-11' it is very fast. when i explain this query it shows that it is full query of druid segment interval as below: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: TableScan alias: a filterExpr: (__time >= TIMESTAMPLOCALTZ'2021-01-11 00:00:00.0 Asia/Phnom_Penh') (type: boolean) properties: druid.fieldNames __time,systemtime,domain,generation_time,nat_source_ip,source_ip,dest_ip,dest_country,http_connection,source_country,btyes,bytes_sent,bytes_receive,packets,packets_starttime druid.fieldTypes timestamp with local time zone,string,string,string,string,string,string,string,string,string,string,string,string,string,string druid.query.json {"queryType":"scan","dataSource":{"type":"table","name":"painternet"},"intervals":{"type":"LegacySegmentSpec","intervals":["1900-01-01T00:00:00.000Z/3000-01-01T00:00:00.000Z"]},"virtualColumns":[],"resultFormat":"compactedList","batchSize":20480,"limit":9223372036854775807,"filter":null,"columns":["__time","systemtime","domain","generation_time","nat_source_ip","source_ip","dest_ip","dest_country","http_connection","source_country","btyes","bytes_sent","bytes_receive","packets","packets_starttime"],"legacy":null,"context":null,"descending":false,"granularity":{"type":"all"}} druid.query.type scan GatherStats: false Filter Operator isSamplingPred: false predicate: (__time >= TIMESTAMPLOCALTZ'2021-01-11 00:00:00.0 Asia/Phnom_Penh') (type: boolean) Select Operator expressions: __time (type: timestamp with local time zone), systemtime (type: string), domain (type: string), generation_time (type: string), nat_source_ip (type: string), source_ip (type: string), dest_ip (type: string), dest_country (type: string), http_connection (type: string), source_country (type: string), btyes (type: string), bytes_sent (type: string), bytes_receive (type: string), packets (type: string), packets_starttime (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14 ListSink how to solve this problem?
... View more
