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;