Skip to content

[KQP] Incomplete Filter expression in plan (TPC-H Q4) #10136

@Hor911

Description

@Hor911
┌─────────────────────────────────────────────────────────────────┬───────┬────────┬───────────┬───────────┬───────────┐
│ Operation                                                       │ A-Cpu │ A-Rows │ E-Cost    │ E-Rows    │ E-Size    │
├─────────────────────────────────────────────────────────────────┼───────┼────────┼───────────┼───────────┼───────────┤
│  -> ResultSet                                                   │       │        │           │           │           │
│    -> Sort (row.o_orderpriority)                                │       │        │           │           │           │
│      -> Aggregate (GroupBy: o.o_orderpriority, Aggregation: {_y │       │        │           │           │           │
│ ql_agg_0: SUM(_yql_agg_0,1)})                                   │       │        │           │           │           │
│        -> InnerJoin (Grace) (l.l_orderkey = o.o_orderkey)       │       │        │ 1.575e+10 │ 3.000e+09 │ 3.617e+10 │
│          -> Aggregate (GroupBy: l_orderkey, Aggregation: state) │       │        │           │           │           │
│            -> Filter (l_commitdate < )                          │       │        │ 0         │ 6.000e+09 │ 7.233e+10 │
│              -> TableFullScan (Table: dt64/column/tpch/s1000/li │       │        │ 0         │ 6.000e+09 │ 7.233e+10 │
│ neitem, Scan: Parallel, ReadRanges: ["l_orderkey (-∞, +∞)","l_l │       │        │           │           │           │
│ inenumber (-∞, +∞)"], ReadColumns: ["l_commitdate","l_orderkey" │       │        │           │           │           │
│ ,"l_receiptdate"])                                              │       │        │           │           │           │
│          -> Filter (o_orderdate >= "8825" And o_orderdate < App │       │        │ 0         │ 7.500e+08 │ 1.521e+10 │
│ ly)                                                             │       │        │           │           │           │
│            -> TableFullScan (Table: dt64/column/tpch/s1000/orde │       │        │ 0         │ 1.500e+09 │ 3.042e+10 │
│ rs, Scan: Parallel, ReadRanges: ["o_orderkey (-∞, +∞)"], ReadCo │       │        │           │           │           │
│ lumns: ["o_orderdate","o_orderkey","o_orderpriority"])          │       │        │           │           │           │
└─────────────────────────────────────────────────────────────────┴───────┴────────┴───────────┴───────────┴───────────┘
  • Filter (l_commitdate < ) is incorrect
  • Correct value seems to be Filter (l_commitdate < l_receiptdate)

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