[jira] [Closed] (ARROW-12339) [Rust][DataFusion] COUNT DISTINCT does not support for `Boolean`

["Andrew Lamb (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ARROW-12339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrew Lamb closed ARROW-12339.
-------------------------------
    Resolution: Invalid

> [Rust][DataFusion] COUNT DISTINCT does not support for `Boolean`
> ----------------------------------------------------------------
>
>                 Key: ARROW-12339
>                 URL: https://issues.apache.org/jira/browse/ARROW-12339
>             Project: Apache Arrow
>          Issue Type: Improvement
>          Components: Rust - DataFusion
>            Reporter: Andrew Lamb
>            Priority: Major
>
> If you try to run a `COUNT (DISTINCT ..)` query on a boolean column you get the following panic:
> thread 'tokio-runtime-worker' panicked at 'Unexpected DataType for list', datafusion/src/scalar.rs:342:22
> While there is unlikely to be a big usecase for this, it would be nice for completeness sake. At the very least we should add a proper error message rather than a panic
> Reproducer:
> {code}
> echo "true" > /tmp/foo.csv
>  ./target/debug/datafusion-cli
> > CREATE EXTERNAL TABLE t (a boolean) STORED AS CSV LOCATION '/tmp/foo.csv';
> 0 rows in set. Query took 0 seconds.
> > select count(distinct a) from t;
> thread 'tokio-runtime-worker' panicked at 'Unexpected DataType for list', datafusion/src/scalar.rs:342:22
> note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace
> ArrowError(ExternalError(Canceled))
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)