Skip to content

Instantly share code, notes, and snippets.

@shrutib6161
Created July 31, 2019 23:18
hive> CREATE EXTERNAL TABLE twitter(hashtags string, language string, text string)
> STORED BY 'org.apache.hadoop.hive.dynamodb.DynamoDBStorageHandler'
> TBLPROPERTIES (
> "dynamodb.table.name" = "foxish-test-table",
> "dynamodb.column.mapping" = "hashtags:hashtags,language:language,text:text"
> );
WARNING: Configured write throughput of the dynamodb table foxish-test-table is less than the cluster map capacity. ClusterMapCapacity: 10 WriteThroughput: 5
WARNING: Writes to this table might result in a write outage on the table.
OK
Time taken: 2.567 seconds
hive> show tables;
OK
twitter
Time taken: 0.135 seconds, Fetched: 1 row(s)
hive> select hashtags, language from twitter limit 10;
OK
music km
music in
music th
music ja
music es
music en
music en
music en
music en
music ja
music en
Time taken: 0.197 seconds, Fetched: 10 row(s)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment