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/10/29 22:00:32 UTC
[GitHub] [arrow-datafusion] andygrove opened a new issue, #4027: Cannot query external table - TableScan replaced with EmptyExec
andygrove opened a new issue, #4027:
URL: https://github.com/apache/arrow-datafusion/issues/4027
**Describe the bug**
I am using the CLI to try and query a file. It shows that the file has no data but this is not the case.
**To Reproduce**
```
create external table partsupp (ps_partkey int, ps_suppkey int, ps_availqty int, ps_supplycost float, ps_comment varchar) stored as csv with delimiter '|' location '../benchmarks/data/partsupp.tbl';
❯ select count(*) from partsupp;
+-----------------+
| COUNT(UInt8(1)) |
+-----------------+
| 0 |
+-----------------+
1 row in set. Query took 0.001 seconds.
```
```
explain verbose select count(*) from partsupp;
```
```
| logical_plan | Projection: COUNT(UInt8(1)) |
| | Aggregate: groupBy=[[]], aggr=[[COUNT(UInt8(1))]] |
| | TableScan: partsupp projection=[ps_partkey] |
| initial_physical_plan | ProjectionExec: expr=[COUNT(UInt8(1))@0 as COUNT(UInt8(1))] |
| | AggregateExec: mode=Final, gby=[], aggr=[COUNT(UInt8(1))] |
| | AggregateExec: mode=Partial, gby=[], aggr=[COUNT(UInt8(1))] |
| | EmptyExec: produce_one_row=false
```
**Expected behavior**
A clear and concise description of what you expected to happen.
**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] tustvold commented on issue #4027: Cannot query external table - TableScan replaced with EmptyExec
Posted by GitBox <gi...@apache.org>.
tustvold commented on issue #4027:
URL: https://github.com/apache/arrow-datafusion/issues/4027#issuecomment-1296006116
Looks like a duplicate of https://github.com/apache/arrow-datafusion/issues/1736
--
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] andygrove closed issue #4027: Cannot query external table - TableScan replaced with EmptyExec
Posted by GitBox <gi...@apache.org>.
andygrove closed issue #4027: Cannot query external table - TableScan replaced with EmptyExec
URL: https://github.com/apache/arrow-datafusion/issues/4027
--
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