Skip to main content

Posts

Showing posts from August, 2019

Hive(EMR) and DynamoDB Integration

Follow below steps to move data from Hive to Dynamo DB. Source link:  https://docs.amazonaws.cn/en_us/amazondynamodb/latest/developerguide/EMRforDynamoDB.html Below is just a quick summary from the above documentation link. 1. Create a hive table. (Ignore this step if hive table is already created) CREATE TABLE hive_features     (feature_id             BIGINT,     feature_name            STRING ,     feature_class           STRING ,     state_alpha             STRING,     prim_lat_dec            DOUBLE ,     prim_long_dec           DOUBLE ,     elev_in_ft              BIGINT)     ROW FORMAT DELIMITED     FIELDS TERMINATED BY '|'     LINES TERMIN...