gruuya opened a new issue, #11866: URL: https://github.com/apache/datafusion/issues/11866
### Is your feature request related to a problem or challenge? There's a substantial mismatch between the TPC-DS Q27 in DataFusion https://github.com/apache/datafusion/blob/117ab1b8c861f431b2d04443e2028ca16fafc57c/datafusion/core/tests/tpc-ds/27.sql#L3-L22 and DuckDB https://github.com/duckdb/duckdb/blob/main/extension/tpcds/dsdgen/queries/27.sql The base DF version is effectively just a CTE in DuckDB, with some additional non-trivial operations afterwards. ### Describe the solution you'd like Not sure which one is more up-to-date with the latest [spec](https://www.tpc.org/tpc_documents_current_versions/current_specifications5.asp), nor whether this warrants any changes at all. Potentially indicates that other tpc-ds queries need to be aligned too. ### Describe alternatives you've considered _No response_ ### Additional context We use DuckDB-generated TPC-H/DS queries for integration testing. -- 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]
