l1t1 opened a new issue, #10069:
URL: https://github.com/apache/arrow-datafusion/issues/10069
### Is your feature request related to a problem or challenge?
it is complex and slowly to use unnest().
### Describe the solution you'd like
it can run `select from generate_series()` as duckdb does.
### Describe alternatives you've considered
_No response_
### Additional context
```sql
D:\duckdb>datafusion-cli
DataFusion CLI v37.0.0
> select sum(a) from unnest(generate_series(1,1000000)) as t(a);
+--------------+
| SUM(t.a) |
+--------------+
| 500000500000 |
+--------------+
1 row(s) fetched.
Elapsed 3.648 seconds.
> select sum(a) from generate_series(1,1000000) as t(a);
Error during planning: table function 'generate_series' not found
>
D:\duckdb>duckdb011
v0.10.1 4a89d97db8
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D .timer on
D select sum(a) from unnest(generate_series(1,1000000)) as t(a);
┌──────────────┐
│ sum(a) │
│ int128 │
├──────────────┤
│ 500000500000 │
└──────────────┘
Run Time (s): real 0.854 user 0.859375 sys 0.078125
D select sum(a) from generate_series(1,1000000) as t(a);
┌──────────────┐
│ sum(a) │
│ int128 │
├──────────────┤
│ 500000500000 │
└──────────────┘
Run Time (s): real 0.033 user 0.015625 sys 0.000000
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
