[ARROW-9382] [Rust] [DataFusion] Can not group by boolean columns (add boolean to valid keys of groupBy)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Component/s: Rust - DataFusion
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/17263
• Assignee: Unassigned
• Reporter: Jorge Leitão
• Created: 09/Jul/20 05:48
• Updated: 11/Jan/23 08:06
• Resolved: 26/Apr/21 13:18

Description

Currently we do not support boolean columns on groupBy.

Here is a reproducer:

alamb@MacBook-Pro:~/Software/arrow/rust$ echo "false" > /tmp/foo.csv
alamb@MacBook-Pro:~/Software/arrow/rust$ cargo run --bin datafusion-cli
    Finished dev [unoptimized + debuginfo] target(s) in 0.14s
     Running `target/debug/datafusion-cli`
> create external table test(c1 boolean) stored as CSV location '/tmp/foo.csv';
0 rows in set. Query took 0 seconds.
> select count(c1), c1 from test group by c1;
ArrowError(ExternalError(ExecutionError("Unsupported GROUP BY data type")))

The expected result is

1, false

Issue Links

• links to: GitHub Pull Request #7687