I have a table which has highly nested json which i create with .
CREATE EXTERNAL TABLE table1 (item map<string,string>) STORED BY
'org.apache.hadoop.hive.dynamodb.DynamoDBStorageHandler' TBLPROPERTIES ("
dynamodb.table.name" = "...");
I have to have it be a map<string,string> table because it is highly nested
json.
I have another table which just contains newline delimited json which i
mount with
CREATE EXTERNAL TABLE table2 ( json_blob string) LOCATION '....';
So I want to be able to load table1 with table2 data but :
INSERT OVERWRITE TABLE table1 select str_to_map(json_blob) from table2
limit 1;
But that maps to
{"key":{},"value":{"_col0":{random oozes of data
What do I do!
--
Alex Newman sent this from a small glass rectangle at 4045076749
