TPC-H Query 2

[alamb]

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

{{Missing subquery support.}}

{{Full error:}}

{{Error: NotImplemented("Unsupported ast node Subquery(Query { with: None, body: Select(Select { distinct: false, top: None, projection: [UnnamedExpr(Function(Function { name: ObjectName([Ident { value: "min", quote_style: None }]), args: [Unnamed(Identifier(Ident { value: "ps_supplycost", quote_style: None }))], over: None, distinct: false }))], from: [TableWithJoins { relation: Table { name: ObjectName([Ident { value: "partsupp", quote_style: None }]), alias: None, args: [], with_hints: [] }, joins: [] }, TableWithJoins { relation: Table { name: ObjectName([Ident { value: "supplier", quote_style: None }]), alias: None, args: [], with_hints: [] }, joins: [] }, TableWithJoins { relation: Table { name: ObjectName([Ident { value: "nation", quote_style: None }]), alias: None, args: [], with_hints: [] }, joins: [] }, TableWithJoins { relation: Table { name: ObjectName([Ident { value: "region", quote_style: None }]), alias: None, args: [], with_hints: [] }, joins: [] }], selection: Some(BinaryOp { left: BinaryOp { left: BinaryOp { left: BinaryOp { left: BinaryOp { left: Identifier(Ident { value: "p_partkey", quote_style: None }), op: Eq, right: Identifier(Ident { value: "ps_partkey", quote_style: None }) }, op: And, right: BinaryOp { left: Identifier(Ident { value: "s_suppkey", quote_style: None }), op: Eq, right: Identifier(Ident { value: "ps_suppkey", quote_style: None }) } }, op: And, right: BinaryOp { left: Identifier(Ident { value: "s_nationkey", quote_style: None }), op: Eq, right: Identifier(Ident { value: "n_nationkey", quote_style: None }) } }, op: And, right: BinaryOp { left: Identifier(Ident { value: "n_regionkey", quote_style: None }), op: Eq, right: Identifier(Ident { value: "r_regionkey", quote_style: None }) } }, op: And, right: BinaryOp { left: Identifier(Ident { value: "r_name", quote_style: None }), op: Eq, right: Value(SingleQuotedString("EUROPE")) } }), group_by: [], having: None }), order_by: [], limit: None, offset: None, fetch: None }) in sqltorel")}}

[andygrove]

Latest failure:

Error: NotImplemented("Physical plan does not support logical expression (Subquery: Projection: #MIN(partsupp.ps_supplycost)
\n  Aggregate: groupBy=[[]], aggr=[[MIN(#partsupp.ps_supplycost)]]
\n    Filter: #part.p_partkey = #partsupp.ps_partkey AND #region.r_name = Utf8(\"EUROPE\")
\n      Inner Join: #nation.n_regionkey = #region.r_regionkey
\n        Inner Join: #supplier.s_nationkey = #nation.n_nationkey
\n          Inner Join: #partsupp.ps_suppkey = #supplier.s_suppkey
\n            TableScan: partsupp projection=None
\n            TableScan: supplier projection=None
\n          TableScan: nation projection=None
\n        TableScan: region projection=None)")

[avantgardnerio]

Resolved in this branch which I am getting ready for PR.

| -927.13   | Supplier#000003514 | UNITED KINGDOM | 150998    | Manufacturer#5 | 63uWeHPVfzygvwEivG                       | 33-482-787-8079 | y unusual asymptotes boost carefully. regular deposits above                                         |
| -963.79   | Supplier#000000065 | RUSSIA         | 20064     | Manufacturer#2 | BsAnHUmSFArppKrM                         | 32-444-835-2434 | l ideas wake carefully around the regular packages. furiously ruthless pinto bea                     |
| -970.28   | Supplier#000004677 | UNITED KINGDOM | 117143    | Manufacturer#1 | s,bn 4mYd5RWFDkY88z4VdzJ                 | 33-455-575-6387 |  foxes. furiously even requests haggle furiously excuses. slyly final dependencies haggle blithe     |
| -986.14   | Supplier#000003627 | FRANCE         | 103626    | Manufacturer#2 | 77,1uiRw rXybJh                          | 16-568-745-4062 | closely blithely regular dolphins. fluffi                                                            |
+-----------+--------------------+----------------+-----------+----------------+------------------------------------------+-----------------+------------------------------------------------------------------------------------------------------+
Query 2 iteration 2 took 7080.4 ms and returned 460 rows
Query 2 avg time: 7061.90 ms