TPC-H Query 21

[alamb]

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

Fails with error:

Error: NotImplemented("Unsupported compound identifier '["l1", "l_suppkey"]'")

[andygrove]

Latest failure:

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

[alamb]

Possibly fixed in #2451

[avantgardnerio]

This is the final subquery fixed. Dependent on #2843 . Fixed in this branch:

datafusion:

| Supplier#000003834 | 4       |
| Supplier#000005998 | 4       |
| Supplier#000009721 | 4       |
| Supplier#000006684 | 3       |
| Supplier#000007656 | 3       |
| Supplier#000008136 | 3       |
+--------------------+---------+
Query 21 iteration 0 took 161136.2 ms and returned 411 rows
Query 21 avg time: 161136.18 ms

postgres:

|Supplier#000003834|4      |
|Supplier#000005998|4      |
|Supplier#000009721|4      |
|Supplier#000006684|3      |
|Supplier#000007656|3      |
|Supplier#000008136|3      |
+------------------+-------+

PR for all the subquery fixes inbound shortly 🥳