stelios313 opened a new issue #8833: SQL query fails in semi join when using NOT IN with subquery URL: https://github.com/apache/incubator-druid/issues/8833 ### Affected Version 0.16.0 ### Description Executing an SQL query from UI, ``` SELECT dimension, SUM(totals) FROM datasource WHERE "__time" BETWEEN TIME_FORMAT(TIMESTAMPADD(DAY, -2,CURRENT_DATE), 'yyyy-MM-dd hh:mm:ss') AND TIME_FORMAT(TIMESTAMPADD(DAY, -1,CURRENT_DATE), 'yyyy-MM-dd hh:mm:ss') AND dimension NOT IN ( SELECT dimension from datasource1 WHERE d="example" ) GROUP BY dimension ``` Gets me: ``` Unknown exception / Cannot build plan for query: ``` followed by the original query. The exact same query works when i use IN keyword.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@druid.apache.org For additional commands, e-mail: commits-h...@druid.apache.org