Hi,
I went through the documentation and solved this problem. Sorry for posing
this without reading the documentation properly.
On Mon, Dec 13, 2010 at 1:22 PM, Saravanan Rajendran <
sarava...@julysystems.com> wrote:
> 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.
>
