[ARROW-11531] [Rust][DataFusion] TPC-H Query 18

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Component/s: Rust - DataFusion
• External issue URL: https://github.com/apache/arrow/issues/27406
• Assignee: Unassigned
• Reporter: Daniël Heres
• Created: 06/Feb/21 11:09
• Updated: 11/Jan/23 08:20
• Resolved: 26/Apr/21 13:28

Description

IN (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")