jackwener commented on pull request #2039: URL: https://github.com/apache/arrow-datafusion/pull/2039#issuecomment-1073030007
Now it's fixed.
```sql
explain verbose select c1, c2 from test where c3 = true and c2 = 0.000001;
+-------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+
| plan_type | plan
|
+-------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+
| initial_logical_plan | Projection:
#test.c1, #test.c2
|
| | Filter: #test.c3
= Boolean(true) AND #test.c2 = Float64(0.000001)
|
| | TableScan:
test projection=None
|
| logical_plan after simplify_expressions | Projection:
#test.c1, #test.c2
|
| | Filter: #test.c3
AND #test.c2 = Float64(0.000001) AS test.c3 = Boolean(true) AND test.c2 =
Float64(0.000001) |
| | TableScan:
test projection=None
|
| logical_plan after eliminate_filter | SAME TEXT AS ABOVE
|
| logical_plan after common_sub_expression_eliminate | SAME TEXT AS ABOVE
|
| logical_plan after eliminate_limit | SAME TEXT AS ABOVE
|
| logical_plan after projection_push_down | Projection:
#test.c1, #test.c2
|
| | Filter: #test.c3
AND #test.c2 = Float64(0.000001) AS test.c3 = Boolean(true) AND test.c2 =
Float64(0.000001) |
| | TableScan:
test projection=Some([0, 1, 2])
|
| logical_plan after filter_push_down | Projection:
#test.c1, #test.c2
|
| | Filter: #test.c3
AND #test.c2 = Float64(0.000001)
|
| | TableScan:
test projection=Some([0, 1, 2]), filters=[#test.c3, #test.c2 =
Float64(0.000001)] |
| logical_plan after limit_push_down | SAME TEXT AS ABOVE
|
| logical_plan after SingleDistinctAggregationToGroupBy | SAME TEXT AS ABOVE
|
| logical_plan after ToApproxPerc | SAME TEXT AS ABOVE
|
| logical_plan after simplify_expressions | SAME TEXT AS ABOVE
|
| logical_plan after eliminate_filter | SAME TEXT AS ABOVE
|
| logical_plan after common_sub_expression_eliminate | SAME TEXT AS ABOVE
|
| logical_plan after eliminate_limit | SAME TEXT AS ABOVE
|
| logical_plan after projection_push_down | SAME TEXT AS ABOVE
|
| logical_plan after filter_push_down | SAME TEXT AS ABOVE
|
| logical_plan after limit_push_down | SAME TEXT AS ABOVE
|
| logical_plan after SingleDistinctAggregationToGroupBy | SAME TEXT AS ABOVE
|
| logical_plan after ToApproxPerc | SAME TEXT AS ABOVE
|
| logical_plan | Projection:
#test.c1, #test.c2
|
| | Filter: #test.c3
AND #test.c2 = Float64(0.000001)
|
| | TableScan:
test projection=Some([0, 1, 2]), filters=[#test.c3, #test.c2 =
Float64(0.000001)]
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscr...@arrow.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
