1 Answer
- Newest
- Most votes
- Most comments
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;
Relevant content
- Accepted Answerasked 9 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 18 days ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 9 months ago