Month: December 2020

Using the Athena Batch Partition Insert Job Type

So we’ve got our raw data in s3: And we have an Athena table over this data: The Athena query statement used to create this table: CREATE EXTERNAL TABLE invoices (invoiceid int,customerid int,billtocustomerid int,orderid int,deliverymethodid int,contactpersonid int,accountspersonid int,salespersonpersonid int,packedbypersonid int,invoicedate date,customerpurchaseordernumber string,iscreditnote int,totaldryitems int,totalchilleritems int,deliveryrun string,runposition string,confirmeddeliverytime timestamp,confirmedreceivedby string,lasteditedby int,lasteditedwhen timestamp)ROW FORMAT DELIMITEDFIELDS TERMINATED BY …

Using the Athena Batch Partition Insert Job Type Read More »