stamboli opened a new issue, #16179: URL: https://github.com/apache/druid/issues/16179
### Affected Version 29.0.0 ### Description [SampleSaleData.csv](https://github.com/apache/druid/files/14670155/SampleSaleData.csv) [SampleSaleData.json](https://github.com/apache/druid/files/14670164/SampleSaleData.json) [environment.txt](https://github.com/apache/druid/files/14670195/environment.txt) : Environment file attaching here as txt as no extension file was not allowed - Steps to reproduce the problem - Upload given csv file, for reference even environment file and durid load spec is provided - Run below unconditional join (simplified to best that could reproduce issue) query either run with cross join (same issue if left join with dummy join condition as '10'='10' used) to work with 25.0.0 but stopped working with 29.0.0 SELECT "numr"."Brand Name" AS "Brand Name", "numr"."Units" AS "Brand Units", "denom"."Units" AS "Total Units" FROM ( SELECT "SampleSaleData"."Brand Name" AS "Brand Name", SUM("SampleSaleData"."Units") AS "Units" FROM SampleSaleData "SampleSaleData" GROUP BY "SampleSaleData"."Brand Name" ) "numr" CROSS JOIN ( SELECT SUM("SampleSaleData"."Units") AS "Units" FROM SampleSaleData "SampleSaleData" GROUP BY TIME_PARSE('2022-01-05T00:00:00.000Z') ) "denom" GROUP BY "numr"."Brand Name", "numr"."Units", "denom"."Units" ORDER BY "Brand Name" ASC - The error message or stack traces encountered. Providing more context, such as nearby log messages or even entire logs, can be helpful. Error: INVALID_INPUT (ADMIN) Query could not be planned. A possible reason is [SQL query requires ordering a table by non-time column [[Brand Name]], which is not supported.] - Any debugging that you have already done This works when there are valid condition for join, this gives issue only when unconditional join for instance below slightly modified query with valid join condition across two queries works fine SELECT "numr"."Country" AS "Country", "numr"."Brand Name" AS "Brand Name", "numr"."Units" AS "Brand Units", "denom"."Units" AS "Total Units" FROM ( SELECT "SampleSaleData"."Country" AS "Country", "SampleSaleData"."Brand Name" AS "Brand Name", SUM("SampleSaleData"."Units") AS "Units" FROM SampleSaleData "SampleSaleData" GROUP BY "SampleSaleData"."Country", "SampleSaleData"."Brand Name" ) "numr" LEFT JOIN ( SELECT "SampleSaleData"."Country" AS "Country", SUM("SampleSaleData"."Units") AS "Units" FROM SampleSaleData "SampleSaleData" GROUP BY "SampleSaleData"."Country", TIME_PARSE('2022-01-05T00:00:00.000Z') ) "denom" ON "numr"."Country"="denom"."Country" GROUP BY "numr"."Country", "numr"."Brand Name", "numr"."Units", "denom"."Units" ORDER BY "Brand Name" ASC -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
