Slide 31
Slide 31 text
CREATE EXTERNAL TABLE promotions_1 (id string,
received_at string, source_id string, source_ip string,
source_name string,measure string, instance string,
promotion_id string, company_id string, controller string,
action string)
stored by
'org.apache.hadoop.hive.dynamodb.DynamoDBStorageHan
dler'
TBLPROPERTIES ("dynamodb.table.name" =
"sh_promotions_latest",
"dynamodb.column.mapping" =
"id:id,received_at:received_at,source_id:source_id,source_i
p:source_ip,source_name:source_name,measure:measure,i
nstance:instance,promotion_id:promotion_id,company_id:c
ompany_id,controller:controller,action:action");
Sunday, April 27, 14