Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create external table aws_billing(
- InvoiceId string,
- PayerAccountId string,
- LinkedAccountId string,
- RecordType string,
- RecordID int,
- BillingPeriodStartDate string,
- BillingPeriodEndDate string,
- InvoiceDate string,
- PayerAccountName string,
- LinkedAccountName string,
- TaxationAddress string,
- PayerPONumber string,
- ProductCode string,
- ProductName string,
- SellerOfRecord string,
- UsageType string,
- Operation string,
- RateId int,
- ItemDescription string,
- UsageStartDate string,
- UsageEndDate string,
- UsageQuantity double,
- BlendedRate string,
- CurrencyCode string,
- CostBeforeTax double,
- Credits double,
- TaxAmount double,
- TaxType string,
- TotalCost double
- )
- partitioned by (year string, month string)
- row format serde 'com.bizo.hive.serde.csv.CSVSerde'
- stored as textfile
- location "s3://${awsBillingBucket}/partitioned/"
- ;
Add Comment
Please, Sign In to add comment