文件查询

-- 创建PARQUET文件外表
CREATE EXTERNAL TABLE file_test_parquet (id INT, name STRING, age INT)
USING PARQUET LOCATION 'cosn://<your_cos_bucket>/test_file/file_test_parquet'

-- 写入数据
INSERT INTO file_test_parquet VALUES (1,'Alice',25),(2,'Bob',30),(3,'Charlie',35)

-- 查询该文件路径
SELECT * FROM parquet.`cosn://<your_cos_bucket>/test_file/file_test_parquet`

-- COUNT on file-based table
SELECT COUNT(*) FROM file_test_parquet

--WHERE filter on file-based table
SELECT * FROM file_test_parquet WHERE age > 28