TPC-H Query 4

[alamb]

Note: migrated from original JIRA: https://issues.apache.org/jira/browse/ARROW-11521

Intervals expressions not yet supported.

See apache/arrow#9434

Error:

Error: NotImplemented("Unsupported Interval Expression with leading_field Some(Month)")

[andygrove]

Latest failures

DateIntervalExpr does not support IntervalYearMonth

Error: NotImplemented("Physical plan does not support logical expression EXISTS (Subquery: Projection: #lineitem.l_orderkey, #lineitem.l_partkey, #lineitem.l_suppkey, #lineitem.l_linenumber, #lineitem.l_quantity, #lineitem.l_extendedprice, #lineitem.l_discount, #lineitem.l_tax, #lineitem.l_returnflag, #lineitem.l_linestatus, #lineitem.l_shipdate, #lineitem.l_commitdate, #lineitem.l_receiptdate, #lineitem.l_shipinstruct, #lineitem.l_shipmode, #lineitem.l_comment\n  Filter: #lineitem.l_orderkey = #orders.o_orderkey AND #lineitem.l_commitdate < #lineitem.l_receiptdate\n    TableScan: lineitem projection=None)")
t

[avantgardnerio]

Resolved by PR #2813 & PR #2797

+-----------------+-------------+
| o_orderpriority | order_count |
+-----------------+-------------+
| 1-URGENT        | 10594       |
| 2-HIGH          | 10476       |
| 3-MEDIUM        | 10410       |
| 4-NOT SPECIFIED | 10556       |
| 5-LOW           | 10487       |
+-----------------+-------------+
Query 4 iteration 0 took 97773.2 ms and returned 5 rows
Query 4 avg time: 97773.16 ms