Hive Version 2.1.1
Problem Description: collection items terminated values are inserted as Map Keys
Hive Table:
CREATE TABLE profiles(
id int,
name struct<first_name: string, middle_name: string, last_name: string>,
phone struct<home: string, office: string>,
address map<string,struct<streat:string, appartment:int, zip:string>>
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
COLLECTION ITEMS TERMINATED BY '-'
MAP KEYS TERMINATED BY '='
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;
Data:
1000,Suresh--S,1234567890-1234567890,home=Venkatapuram1-2020-500001
1001,Mahesh-X-M,1234567890-1234567890,home=Venkatapuram2-2021-500001
Data Load:
load data inpath '/handson/profiles_data.txt' overwrite into table profiles;
Actual data from select statement:
SELECT * FROM profiles;
1000
{"first_name":"Suresh","middle_name":"","last_name":"S"}
{"home":"1234567890","office":"1234567890"}
{"home":
{"streat":"Venkatapuram1",**"appartment":null,"zip":null},"2020":null,
"500001": null}
1001
{"first_name":"Mahesh","middle_name":"X","last_name":"M"}
{"home":"1234567890","office":"1234567890"}
{"home":
{"streat":"Venkatapuram2",**"appartment":null,"zip":null},"2021":null,
"500001": null}
Expected:
1000
{"first_name":"Suresh","middle_name":"","last_name":"S"}
{"home":"1234567890","office":"1234567890"}
{"home":{"streat":"Venkatapuram1",**"appartment":2020,"zip":"500001"}**}
1001
{"first_name":"Mahesh","middle_name":"X","last_name":"M"}
{"home":"1234567890","office":"1234567890"}
{"home": {"streat":"Venkatapuram2",**"appartment":2021,"zip":"500001"**}}
