1 回答
- 最新
- 投票最多
- 评论最多
3
Hello,
You can create an athena table for taking the input locations as all the s3 prefix. Something like this, refer create table in athena
CREATE EXTERNAL TABLE `test_table`(
...
)
ROW FORMAT ...
STORED AS INPUTFORMAT ...
OUTPUTFORMAT ...
LOCATION s3://bucketname/folder/
Once create the table, use CTAS to create another table to consolidate all the csv as single table output location like below, refer here for CTAS
CREATE TABLE ctas_csv_unpartitioned
WITH (
format = 'CSV',
external_location = 's3://xxxxxxxxxxxx/ctas_csv_unpartitioned/')
AS SELECT key1, name1, comment1
FROM test_table;
相关内容
- AWS 官方已更新 1 年前
- AWS 官方已更新 7 个月前
- AWS 官方已更新 1 年前