[ARROW-9653] [Rust][DataFusion] Multi-column Group by: Invalid Argument Error

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0
• Component/s: Rust, Rust - DataFusion
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/25712
• Assignee: Andrew Lamb
• Reporter: Andrew Lamb
• Created: 05/Aug/20 12:45
• Updated: 11/Jan/23 08:08
• Resolved: 12/Aug/20 02:30

Description

Repro:

CREATE EXTERNAL TABLE repro(a INT, b INT)
STORED AS CSV
WITH HEADER ROW
LOCATION 'repro.csv';

The contents of repro.csv are as follows (also attached):

a,b
1,100
1,200
2,100
2,200
2,300

Then try to run the following query (to sum the values of a, grouped by b).

select sum(a), a, b from repro group by a, b;

Expected result: a table with three output columns: sum(a), a, and b

Actual result: An arrow error

> select sum(a), a, b from repro group by a, b;
ArrowError(InvalidArgumentError("number of columns(4) must match number of fields(3) in schema"))

Issue Links

• links to: GitHub Pull Request #7924