TPC-H Query 17

[alamb]

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

Subquery in (WHERE) expression support is missing.

{{Error: NotImplemented("Unsupported ast node Subquery(Query { with: None, body: Select(Select { distinct: false, top: None, projection: [UnnamedExpr(BinaryOp { left: Value(Number("0.2")), op: Multiply, right: Function(Function { name: ObjectName([Ident { value: "avg", quote_style: None }]), args: [Unnamed(Identifier(Ident { value: "l_quantity", quote_style: None }))], over: None, distinct: false }) })], from: [TableWithJoins { relation: Table { name: ObjectName([Ident { value: "lineitem", quote_style: None }]), alias: None, args: [], with_hints: [] }, joins: [] }], selection: Some(BinaryOp { left: Identifier(Ident { value: "l_partkey", quote_style: None }), op: Eq, right: Identifier(Ident { value: "p_partkey", quote_style: None }) }), 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: Float64(0.2) * #AVG(lineitem.l_quantity)\n  Aggregate: groupBy=[[]], aggr=[[AVG(#lineitem.l_quantity)]]\n    Filter: #lineitem.l_partkey = #part.p_partkey\n      TableScan: lineitem projection=None)")
t

[avantgardnerio]

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

+-------------------+
| avg_yearly        |
+-------------------+
| 348406.0542857141 |
+-------------------+
Query 17 iteration 2 took 91715.6 ms and returned 1 rows
Query 17 avg time: 92059.84 ms