Skip to content
Permalink
master
Go to file
Paul Crum First write-up
Latest commit c581131 Dec 11, 2017 History
0 contributors

Users who have contributed to this file

50 lines (49 sloc) 1.33 KB
CREATE EXTERNAL TABLE IF NOT EXISTS dltBillingData.utilization (
`InvoiceID` STRING,
`PayerAccountId` STRING,
`LinkedAccountId` STRING,
`RecordType` STRING,
`RecordId` STRING,
`ProductName` STRING,
`RateId` STRING,
`SubscriptionId` STRING,
`PricingPlanId` STRING,
`UsageType` STRING,
`Operation` STRING,
`AvailabilityZone` STRING,
`ReservedInstance` STRING,
`ItemDescription` STRING,
`UsageStartDate` STRING,
`UsageEndDate` STRING,
`UsageQuantity` STRING,
`BlendedRate` STRING,
`BlendedCost` STRING,
`UnBlendedRate` STRING,
`UnBlendedCost` STRING,
`ResourceId` STRING,
`user:Application` STRING,
`user:CA001` STRING,
`user:CostCode` STRING,
`user:CreationDate` STRING,
`user:Creator` STRING,
`user:Department` STRING,
`user:DeptCode` STRING,
`user:Environment` STRING,
`user:Location` STRING,
`user:Name` STRING,
`user:Organization` STRING,
`user:Owner` STRING,
`user:Product` STRING,
`user:Project` STRING,
`user:Purpose` STRING,
`user:ResponsibleParty` STRING,
`user:Role` STRING,
`user:Use` STRING
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
"separatorChar" = ",",
"quoteChar" = "\"",
"escapeChar" = "\\"
) LOCATION 's3://<aws-account-id>-dlt-utilization/<path-to-csv-files>'
TBLPROPERTIES ('has_encrypted_data'='false');
You can’t perform that action at this time.