hive - How to run HiveSQL with DynamoDB local -


as title, have installed dynamodb local , hivesql on ubuntu successfully. when run hive query in command line create table as

create external table hive_productcatalog  (id string,title string)  stored 'org.apache.hadoop.hive.dynamodb.dynamodbstoragehandler'  tblproperties (  "dynamodb.table.name" = "productcatalog",  "dynamodb.column.mapping" = "id:id,title:title");

then got error

failed exception org.apache.hadoop.hive.ql.metadata.hiveexception: error in loading storage handler.org.apache.hadoop.hive.dynamodb.dynamodbstoragehandler failed: execution error, return code 1 org.apache.hadoop.hive.ql.exec.ddltask

i took on google did not find library dynamodbstoragehandler class put lib folder of hive.

the dynamodbstoragehandler made available customers running hive queries on ami provisioned emr jobs. instead, may consider setting dynamodb.endpoint host have dynamodb local running on. way may able use dynamodb local backend hive queries.


Comments

Popular posts from this blog

gcc - MinGW's ld cannot perform PE operations on non PE output file -

timeout - Handshake_timeout on RabbitMQ using python and pika from remote vm -

c# - Search and Add Comment with OpenXML for Word -