DynamoDB with Redshift, Data Pipeline, and MapReduce - DynamoDB Applied Design Patterns - page 195

TBLPROPERTIES ("dynamodb.table.name" = "uchit",
"dynamodb.column.mapping" =
"col1:givenname,col2:givenyear,col3:givendays");
INSERT OVERWRITE TABLE 'givenhiveTableName' SELECT *
FROM uchit_hdfs_import;