Dong Jiang
Dong Jiang
+1, I have experience the same issue with 1.0.0
Is there any plan to implement some of the ideas discussed?
@gianm I attached two parquet files and ingestion json, also screenshot showing the two engines and result. I got the bug replicated with the data set on a docker 25.0...
To clarify, the sql-native engine has a breaking change, while the multi-stage engine produced the correct result. My guess is multi-stage materialized the intermediate result.
@gianm were you able to duplicate the issue?
@gianm did you get a chance to review this?
@gianm sorry for the late response, please find the SQL below [query.sql.gz](https://github.com/apache/druid/files/11629337/query.sql.gz)
Thanks, confirmed fixed. many thanks, @gianm