[jira] [Assigned] (ARROW-11323) [Rust][DataFusion] ComputeError("concat requires input of at least one array")) with queries with ORDER BY or GROUP BY that return no

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

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

Andrew Lamb reassigned ARROW-11323:
-----------------------------------

    Assignee: Andrew Lamb

> [Rust][DataFusion] ComputeError("concat requires input of at least one array")) with queries with ORDER BY or GROUP BY that return no 
> --------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: ARROW-11323
>                 URL: https://issues.apache.org/jira/browse/ARROW-11323
>             Project: Apache Arrow
>          Issue Type: Bug
>            Reporter: Andrew Lamb
>            Assignee: Andrew Lamb
>            Priority: Major
>
> If you run a SQL query in datafusion which has predicates that produces no rows that also includes a GROUP BY or ORDER BY clause, you get the following error:
> Error of "ArrowError(ComputeError("concat requires input of at least one array"))"
> Here are two test cases that show the problem: https://github.com/apache/arrow/blob/master/rust/datafusion/src/execution/context.rs#L889
> {code}
>     #[tokio::test]
>     async fn sort_empty() -> Result<()> {
>         // The predicate on this query purposely generates no results
>         let results =
>             execute("SELECT c1, c2 FROM test WHERE c1 > 100000 ORDER BY c1 DESC, c2 ASC", 4).await?;
>         assert_eq!(results.len(), 0);
>         Ok(())
>     }
>     #[tokio::test]
>     async fn aggregate_empty() -> Result<()> {
>         // The predicate on this query purposely generates no results
>         let results = execute("SELECT SUM(c1), SUM(c2) FROM test where c1 > 100000", 4).await?;
>         assert_eq!(results.len(), 0);
>         Ok(())
>     }
> {code}



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