Skip to content

TPCH Queries break with StreamLookupJoin enabled #3162

Closed
@pavelvelikhov

Description

@pavelvelikhov

Seems like all queries that have a LookupJoin in TPCH will break.

Here are the first few that didn't work:

Q10, Q11

Here are the error messages:

Q10:
Status: GENERIC_ERROR
Issues:

: Error: Execution, code: 1060 :131:1: Error: At tuple, At tuple, At tuple :173:1: Error: At function: TopSort :131:1: Error: At function: FlatMap :151:5: Error: At function: Aggregate :119:15: Error: At function: FlatMap, At function: ExtractMembers, At function: DqJoin, At function: DqJoin : Error: Invalid join input type Struct<'.c.c_acctbal':Double?,'.c.c_address':String?,'.c.c_comment':String?,'.c.c_custkey':Int32?,'.c.c_name':String?,'.c.c_nationkey':Int32?,'.c.c_phone':String?,'.o.o_custkey':Int32?,'.o.o_orderkey':Int32?,'l.l_discount':Double?,'l.l_extendedprice':Double?,'l.l_orderkey':Int32?> :119:15: Error: Cannot parse left join input type: Struct<'.c.c_acctbal':Double?,'.c.c_address':String?,'.c.c_comment':String?,'.c.c_custkey':Int32?,'.c.c_name':String?,'.c.c_nationkey':Int32?,'.c.c_phone':String?,'.o.o_custkey':Int32?,'.o.o_orderkey':Int32?,'l.l_discount':Double?,'l.l_extendedprice':Double?,'l.l_orderkey':Int32?>

Q11:
Status: GENERIC_ERROR
Issues:

: Error: Execution, code: 1060 :99:1: Error: At tuple, At tuple, At tuple, At function: Sort, At function: FlatMap :107:16: Error: At function: EquiJoin :81:1: Error: At function: FlatMap :89:5: Error: At function: Aggregate :51:15: Error: At function: FlatMap, At function: ExtractMembers, At function: ExtractMembers, At function: ExtractMembers :51:15: Error: Member not found: ps.ps_availqty. Did you mean .ps.ps_availqty?

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions