; '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
ubject: 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 don't use float
to store monetary values like salary. You will get rounding issues at some
point in time when you do ari
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