Hi,
I am new to Hive, I am trying to use struct data type. I am able to create
table successfully. I would like to know how to give the data format for the
strct data type to avail this facility.
My table strcture is
create table audittrail (status string, page struct < name : string,
id string >, action string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;
My sample data is "Add" {"name":"test", "id":"100"} "Added"
When i do select page.name if giving me the result as {"name":"test",
"id":"100"}
If i query the data i am not able to get the struct data properly. Is this
format is correct. I went through the samples provided on the net but i
could not solve my problem, Please help in solving this problem.
Thanks in Advance.
