Skip to content

datafusion-cli: results of group by aggregation query not showing #8702

@Jefffrey

Description

@Jefffrey

Describe the bug

datafusion-cli isn't showing results for queries involving selecting count when group by.

To Reproduce

Given input file:

col1,col2
A,
B,b
C,c

Querying this file in datafusion-cli:

DataFusion CLI v34.0.0
❯ CREATE EXTERNAL TABLE kumachan STORED AS CSV WITH HEADER ROW LOCATION '/home/jeffrey/Downloads/kumachan.csv';
0 rows in set. Query took 0.029 seconds.

❯ select * from kumachan;
+------+------+
| col1 | col2 |
+------+------+
| A    |      |
| B    | b    |
| C    | c    |
+------+------+
3 rows in set. Query took 0.005 seconds.

❯ select count(*) from kumachan group by col1;
3 rows in set. Query took 0.010 seconds.

❯

Expected behavior

Should get results like:

+----------+
| COUNT(*) |
+----------+
| 1        |
| 1        |
| 1        |
+----------+

Additional context

No response

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingregressionSomething that used to work no longer does

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions