1 Antwort
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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;
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor 3 Jahren
- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor einem Jahr