comphead opened a new issue, #16429:
URL: https://github.com/apache/datafusion/issues/16429
### Is your feature request related to a problem or challenge?
I'm finding slightly confusing how to output the schema of particular query,
the workaround I use is
```
> create table t1 as select map_extract(map([1], ['a']), 1)[1];
0 row(s) fetched.
Elapsed 0.011 seconds.
> describe t1;
+---------------------------------------------------------------------------------+-----------+-------------+
| column_name
| data_type | is_nullable |
+---------------------------------------------------------------------------------+-----------+-------------+
|
map_extract(map(make_array(Int64(1)),make_array(Utf8("a"))),Int64(1))[Int64(1)]
| Utf8 | NO |
+---------------------------------------------------------------------------------+-----------+-------------+
1 row(s) fetched.
Elapsed 0.001 seconds.
```
it would be more clear to use something like in duck db
```
D describe select map_extract(map([1], ['a']), 1)[1];
┌────────────────────────────────────────────────────────────────────┬─────────────┬─────────┬─────────┬─────────┬─────────┐
│ column_name │
column_type │ null │ key │ default │ extra │
│ varchar │
varchar │ varchar │ varchar │ varchar │ varchar │
├────────────────────────────────────────────────────────────────────┼─────────────┼─────────┼─────────┼─────────┼─────────┤
│ map_extract("map"(main.list_value(1), main.list_value('a')), 1)[1] │
VARCHAR │ YES │ │ │ │
└────────────────────────────────────────────────────────────────────┴─────────────┴─────────┴─────────┴─────────┴─────────┘
D
```
### Describe the solution you'd like
_No response_
### Describe alternatives you've considered
_No response_
### Additional context
_No response_
--
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: github-unsubscr...@datafusion.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
