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;
相關內容
- 已提問 1 年前
- 已提問 6 個月前
- AWS 官方已更新 7 個月前
- AWS 官方已更新 1 年前
- AWS 官方已更新 1 年前