alamb opened a new issue, #4580:
URL: https://github.com/apache/arrow-datafusion/issues/4580
**Is your feature request related to a problem or challenge? Please describe
what you are trying to do.**
I want to use datafusion-cli to quickly explore a parquet file with minimal
typing
Today I first have to type a verbose `CREATE EXTERNAL TABLE`... command
```sql
❯ CREATE EXTERNAL TABLE all_types_tiny_pages STORED AS PARQUET LOCATION
'./parquet-testing/data/alltypes_tiny_pages.parquet';
❯ select * from all_types_tiny_pages limit 10;
+-----+----------+-------------+--------------+---------+------------+-----------+--------------------+-----------------+------------+-------------------------+------+-------+
| id | bool_col | tinyint_col | smallint_col | int_col | bigint_col |
float_col | double_col | date_string_col | string_col | timestamp_col
| year | month |
+-----+----------+-------------+--------------+---------+------------+-----------+--------------------+-----------------+------------+-------------------------+------+-------+
| 122 | true | 2 | 2 | 2 | 20 | 2.2
| 20.2 | 01/13/09 | 2 |
2009-01-13T01:02:05.410 | 2009 | 1 |
| 123 | false | 3 | 3 | 3 | 30 | 3.3
| 30.299999999999997 | 01/13/09 | 3 |
2009-01-13T01:03:05.430 | 2009 | 1 |
| 124 | true | 4 | 4 | 4 | 40 | 4.4
| 40.4 | 01/13/09 | 4 |
2009-01-13T01:04:05.460 | 2009 | 1 |
| 125 | false | 5 | 5 | 5 | 50 | 5.5
| 50.5 | 01/13/09 | 5 |
2009-01-13T01:05:05.500 | 2009 | 1 |
| 126 | true | 6 | 6 | 6 | 60 | 6.6
| 60.599999999999994 | 01/13/09 | 6 |
2009-01-13T01:06:05.550 | 2009 | 1 |
| 127 | false | 7 | 7 | 7 | 70 | 7.7
| 70.7 | 01/13/09 | 7 |
2009-01-13T01:07:05.610 | 2009 | 1 |
| 128 | true | 8 | 8 | 8 | 80 | 8.8
| 80.8 | 01/13/09 | 8 |
2009-01-13T01:08:05.680 | 2009 | 1 |
| 129 | false | 9 | 9 | 9 | 90 | 9.9
| 90.89999999999999 | 01/13/09 | 9 |
2009-01-13T01:09:05.760 | 2009 | 1 |
| 130 | true | 0 | 0 | 0 | 0 | 0
| 0 | 01/14/09 | 0 |
2009-01-14T01:10:05.850 | 2009 | 1 |
| 131 | false | 1 | 1 | 1 | 10 | 1.1
| 10.1 | 01/14/09 | 1 |
2009-01-14T01:11:05.850 | 2009 | 1 |
+-----+----------+-------------+--------------+---------+------------+-----------+--------------------+-----------------+------------+-------------------------+------+-------+
10 rows in set. Query took 0.039 seconds.
```
**Describe the solution you'd like**
I would like to be able to select "directly" from the parquet file in duckdb
style
https://duckdb.org/docs/data/parquet.html
```sql
SELECT * FROM 'test.parquet';
```
**Describe alternatives you've considered**
We could also add the `read_parquet` UDF that duckdb (and I think
clickhouse) support: https://github.com/apache/arrow-datafusion/issues/3773
**Additional context**
Add any other context or screenshots about the feature request here.
--
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]
