You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/09/27 07:57:29 UTC
[GitHub] [arrow-datafusion] HaoYang670 opened a new issue, #3624: The expression `col(a) / scalar(1)` is not optimized.
HaoYang670 opened a new issue, #3624:
URL: https://github.com/apache/arrow-datafusion/issues/3624
**Describe the bug**
A clear and concise description of what the bug is.
**To Reproduce**
Steps to reproduce the behavior:
On datafusion-cli:
```sql
❯ create table t as select 3 as a;
0 rows in set. Query took 0.003 seconds.
❯ select a / 1.0 from t;
+------------------+
| t.a / Float64(1) |
+------------------+
| 3 |
+------------------+
1 row in set. Query took 0.004 seconds.
❯ explain select a / 1.0 from t;
+---------------+-------------------------------------------------+
| plan_type | plan |
+---------------+-------------------------------------------------+
| logical_plan | Projection: #t.a AS t.a / Float64(1) |
| | TableScan: t projection=[a] |
| physical_plan | ProjectionExec: expr=[a@0 as t.a / Float64(1)] |
| | MemoryExec: partitions=1, partition_sizes=[1] |
| | |
+---------------+-------------------------------------------------+
2 rows in set. Query took 0.004 seconds.
```
**Expected behavior**
A clear and concise description of what you expected to happen.
The expression `col(a) / 1` should be optimized to `col(a)`
**Additional context**
Add any other context about the problem here.
--
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-unsubscribe@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] alamb closed issue #3624: The expression `col(a) / null` is not optimized.
Posted by GitBox <gi...@apache.org>.
alamb closed issue #3624: The expression `col(a) / null` is not optimized.
URL: https://github.com/apache/arrow-datafusion/issues/3624
--
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-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] HaoYang670 commented on issue #3624: The expression `col(a) / scalar(1)` is not optimized.
Posted by GitBox <gi...@apache.org>.
HaoYang670 commented on issue #3624:
URL: https://github.com/apache/arrow-datafusion/issues/3624#issuecomment-1259130896
Sorry, my mistake.
--
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-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] HaoYang670 closed issue #3624: The expression `col(a) / scalar(1)` is not optimized.
Posted by GitBox <gi...@apache.org>.
HaoYang670 closed issue #3624: The expression `col(a) / scalar(1)` is not optimized.
URL: https://github.com/apache/arrow-datafusion/issues/3624
--
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-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org