Skip to content

Instantly share code, notes, and snippets.

@harrigan

harrigan/dynamo_experiment_initialize.hql

Created March 8, 2013 14:06
Show Gist options
  • Save harrigan/5116637 to your computer and use it in GitHub Desktop.
Save harrigan/5116637 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. harrigan created this gist Mar 8, 2013.
    6 changes: 6 additions & 0 deletions dynamo_experiment_initialize.hql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,6 @@
    CREATE EXTERNAL TABLE myData (appId BIGINT, ts BIGINT)
    STORED BY 'org.apache.hadoop.hive.dynamodb.DynamoDBStorageHandler' TBLPROPERTIES (
    'dynamodb.table.name' = 'myData',
    'dynamodb.column.mapping' = 'appId:appId,ts:ts',
    'dynamodb.throughput.read.percent' = '1.0'
    );