-loading data in an array within a map
Bhaskar, Snehalata 2012-06-28, 11:50
I have created a table which has array within a map. I am using
hive> create table user_profiles
> userid string,
> friends array<string>,
> properties map<string, array<string>>
> ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' COLLECTION ITEMS
TERMINATED BY ':' MAP KEYS TERMINATED BY '#' LINES TERMINATED BY '\n'
> LOCATION '/user/sb25634/user_profiles_table';
Time taken: 0.794 seconds
But I am not able to load data properly in the array inside a map. I am
facing problem with the delimiters used in the file used for data
loading. Is there any way I can indicate the delimiters for array
Please help me.
Thanks and regards,
Confidential: This electronic message and all contents contain information from Syntel, Inc. which may be privileged, confidential or otherwise protected from disclosure. The information is intended to be for the addressee only. If you are not the addressee, any disclosure, copy, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify the sender immediately and destroy the original message and all copies.
Ruben de Vries 2012-06-28, 13:04