Extensions
Multiple Files
To query all files under a specific directory, you can use a [glob pattern](#docs:data:multiple_files:overview::multi-file-reads-and-globs). For example:  
```sql
SELECT count(*) AS count
FROM 'hf://datasets/cais/mmlu/astronomy/*.parquet';
```  
| count |
|------:|
| 173   |  
By using glob patterns, you can efficiently handle large datasets and perform comprehensive queries across multiple files, simplifying your data inspections and processing tasks.
Here, you can see how you can look for questions that contain the word “planet” in astronomy:  
```sql
SELECT count(*) AS count
FROM 'hf://datasets/cais/mmlu/astronomy/*.parquet'
WHERE question LIKE '%planet%';
```  
| count |
|------:|
| 21    |