I want to query some files in a directory. Is there any way?

[yourenawo]

Describe the bug
There are 3000 parquet files named according to the timestamp in my directory. Now I just want to query some files, which can greatly reduce the query time.Thank you.

[andygrove]

Assuming that these files have the same or similar schema, then yes, you can just use the path to the directory rather than the path to an individual file.

[alamb]

Something like

CREATE EXTERNAL TABLE foo STORED AS PARQUET LOCATION '/my/directory';

[yourenawo]

thanks.