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

Exporting data from DynamoDB to S3
Using the following command, s3://bucketname/path/subpath/ is a valid path
in your Amazon S3 bucket. Match the columns and data types in the CREATE command to
go with the values in your DynamoDB tables. Have a look at the following command:
CREATE EXTERNAL TABLE yourHiveTableName (col1 string, col2
bigint, col3 array<string>)
STORED BY
'org.apache.hadoop.hive.dynamodb.DynamoDBStorageHandler'
TBLPROPERTIES ("yourdynamodb.table.name" = "uchit",
"dynamodb.column.mapping" =
"col1:givenname,col2:givenyear,col3:givendays");
After that, you can provide the INSERT OVERWRITE command to write the data to an
external directory/folder.
INSERT OVERWRITE DIRECTORY 's3://bucketname/path/' SELECT *
FROM givenHiveTableName;