; 'Sai Sai'<
> saigr...@yahoo.in>
> *ReplyTo: * user@hive.apache.org
> *Subject: *RE: Accessing sub column in hive
>
> Perhaps worth posting the error. Some might know what the error means.
>
> ** **
>
> Also a bit unrelated to hive but please do yourself a favor and
07, 2013 12:54 PM
To: user@hive.apache.org
Subject: Re: Accessing sub column in hive
I have a table created like this successfully:
CREATE TABLE IF NOT EXISTS employees (name STRING,salary FLOAT,subordinates
ARRAY,deductions MAP,address STRUCT)
I would like to access/display country column
user@hive.apache.org
Subject: Re: Accessing sub column in hive
I have a table created like this successfully:
CREATE TABLE IF NOT EXISTS employees (name STRING,salary FLOAT,subordinates
ARRAY,deductions MAP,address STRUCT)
I would like to access/display country column from my address struct.
I have tried
I have a table created like this successfully:
CREATE TABLE IF NOT EXISTS employees (name STRING,salary FLOAT,subordinates
ARRAY,deductions MAP,address STRUCT)
I would like to access/display country column from my address struct.
I have tried this:
select address["country"] from employees;
I
