andygrove commented on issue #4763:
URL: https://github.com/apache/datafusion/issues/4763#issuecomment-2221599219
I just tried running TPC-DS with DataFusion 39 and these are the failing
queries currently:
```
Executing query 10 from ../../tpcds/queries-spark/q10.sql
Fail: This feature is not implemented: Physical plan does not support
logical expression Exists(Exists { subquery: <subquery>, negated: false })
Executing query 11 from ../../tpcds/queries-spark/q11.sql
Executing query 27 from ../../tpcds/queries-spark/q27.sql
Fail: External error: This feature is not implemented: physical plan is not
yet implemented for GROUPING aggregate function
Executing query 35 from ../../tpcds/queries-spark/q35.sql
Fail: Error during planning: Projections require unique expression names but
the expression "STDDEV(customer_demographics.cd_dep_count)" at position 6 and
"STDDEV(customer_demographics.cd_dep_count)" at position 7 have the same name.
Consider aliasing ("AS") one of them.
Executing query 36 from ../../tpcds/queries-spark/q36.sql
Fail: External error: External error: This feature is not implemented:
physical plan is not yet implemented for GROUPING aggregate function
Executing query 41 from ../../tpcds/queries-spark/q41.sql
Fail: check_analyzed_plan
caused by
Error during planning: Correlated column is not allowed in predicate:
item.i_manufact = outer_ref(i1.i_manufact) AND (item.i_category = Utf8("Women")
AND (item.i_color = Utf8("cream") OR item.i_color = Utf8("ghost")) AND
(item.i_units = Utf8("Ton") OR item.i_units = Utf8("Gross")) AND (item.i_size =
Utf8("economy") OR item.i_size = Utf8("small")) OR item.i_category =
Utf8("Women") AND (item.i_color = Utf8("midnight") OR item.i_color =
Utf8("burlywood")) AND (item.i_units = Utf8("Tsp") OR item.i_units =
Utf8("Bundle")) AND (item.i_size = Utf8("medium") OR item.i_size = Utf8("extra
large")) OR item.i_category = Utf8("Men") AND (item.i_color = Utf8("lavender")
OR item.i_color = Utf8("azure")) AND (item.i_units = Utf8("Each") OR
item.i_units = Utf8("Lb")) AND (item.i_size = Utf8("large") OR item.i_size =
Utf8("N/A")) OR item.i_category = Utf8("Men") AND (item.i_color =
Utf8("chocolate") OR item.i_color = Utf8("steel")) AND (item.i_units =
Utf8("N/A") OR item.i_units = Utf8("Dozen")) A
ND (item.i_size = Utf8("economy") OR item.i_size = Utf8("small"))) OR
item.i_manufact = outer_ref(i1.i_manufact) AND (item.i_category = Utf8("Women")
AND (item.i_color = Utf8("floral") OR item.i_color = Utf8("royal")) AND
(item.i_units = Utf8("Unknown") OR item.i_units = Utf8("Tbl")) AND (item.i_size
= Utf8("economy") OR item.i_size = Utf8("small")) OR item.i_category =
Utf8("Women") AND (item.i_color = Utf8("navy") OR item.i_color =
Utf8("forest")) AND (item.i_units = Utf8("Bunch") OR item.i_units =
Utf8("Dram")) AND (item.i_size = Utf8("medium") OR item.i_size = Utf8("extra
large")) OR item.i_category = Utf8("Men") AND (item.i_color = Utf8("cyan") OR
item.i_color = Utf8("indian")) AND (item.i_units = Utf8("Carton") OR
item.i_units = Utf8("Cup")) AND (item.i_size = Utf8("large") OR item.i_size =
Utf8("N/A")) OR item.i_category = Utf8("Men") AND (item.i_color = Utf8("coral")
OR item.i_color = Utf8("pale")) AND (item.i_units = Utf8("Pallet") OR
item.i_units = Utf8("Gram")) AND (item.
i_size = Utf8("economy") OR item.i_size = Utf8("small")))
Executing query 45 from ../../tpcds/queries-spark/q45.sql
Fail: This feature is not implemented: Physical plan does not support
logical expression InSubquery(InSubquery { expr: Column(Column { relation:
Some(Bare { table: "item" }), name: "i_item_id" }), subquery: <subquery>,
negated: false })
Executing query 70 from ../../tpcds/queries-spark/q70.sql
Fail: External error: External error: This feature is not implemented:
physical plan is not yet implemented for GROUPING aggregate function
Executing query 72 from ../../tpcds/queries-spark/q72.sql
Fail: type_coercion
caused by
Error during planning: Cannot coerce arithmetic expression Date32 + Int64 to
valid types
Executing query 74 from ../../tpcds/queries-spark/q74.sql
Fail: Error during planning: No function matches the given name and argument
types 'STDDEV(Decimal128(7, 2))'. You might need to add explicit type casts.
Candidate functions:
STDDEV(Int8/Int16/Int32/Int64/UInt8/UInt16/UInt32/UInt64/Float32/Float64)
Executing query 75 from ../../tpcds/queries-spark/q75.sql
Fail: External error: External error: External error: External error: Arrow
error: Invalid argument error: RowConverter column schema mismatch, expected
Int32 got Int64
Executing query 86 from ../../tpcds/queries-spark/q86.sql
Fail: External error: External error: This feature is not implemented:
physical plan is not yet implemented for GROUPING aggregate function
```
--
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]
