Apache Drill:如何查询S3存储桶中的所有文件？

<configuration>
  <property>
    <name>fs.s3.impl</name>
    <value>org.apache.hadoop.fs.s3a.S3AFileSystem</value>
  </property>
  <property>
    <name>fs.s3a.access.key</name>
    <value>YOUR_ACCESS_KEY</value>
  </property>
  <property>
    <name>fs.s3a.secret.key</name>
    <value>YOUR_SECRET_KEY</value>
  </property>
  <property>
    <name>fs.s3a.endpoint</name>
    <value>s3.amazonaws.com</value>
  </property>
</configuration>

CREATE OR REPLACE TABLE dfs.s3.`your-bucket-name` AS FILEFORMAT PARQUET LOCATION 's3a://your-bucket-name/';

SELECT * FROM dfs.s3.`your-bucket-name`;

SELECT * FROM dfs.s3.`your-bucket-name` WHERE PATH LIKE 'folder_name/%';

CREATE OR REPLACE TABLE dfs.s3.`your-bucket-name` AS FILEFORMAT CSV LOCATION 's3a://your-bucket-name/';