Can CREATE EXTERNAL TABLE support multiple files as input in the LOCATION section

[ndchandar]

Hello,
I wanted to check if we can allow multiple files as input when creating external tables. Looking at https://datafusion.apache.org/user-guide/sql/ddl.html#create-external-table and the test cases it seems the LOCATION field can be either a directory or a single file.

My use case is that I have a directory that has hundreds of parquet files. I need to take N of them (e.g 10, 20 etc.) to produce bigger sized compacted parquet file.

Regards
Dinesh

[Jefffrey]

We do have an open issue & PR for this feature:

• Support reading multiple parquet files via datafusion-cli #16303
• feat(cli): support external tables on multiple locations #17702