Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Re: Accessing sub column in hive


+
Sai Sai 2013-03-07, 11:54
+
Bennie Schut 2013-03-08, 08:09
+
bejoy_ks@... 2013-03-08, 12:35
Copy link to this message
-
Re: Accessing sub column in hive
I recognize this example ;)

You reference struct elements with the dot notation, as Bejoy said, map
elements with what you tried, deductions['Federal taxes'], and arrays by
index, starting from zero, subordinates[0].

On Fri, Mar 8, 2013 at 6:35 AM, <[EMAIL PROTECTED]> wrote:

> Hi Sai
>
>
> You can do it as
> Select address.country from employees;
>
> Regards
> Bejoy KS
>
> Sent from remote device, Please excuse typos
> ------------------------------
> *From: * Bennie Schut <[EMAIL PROTECTED]>
> *Date: *Fri, 8 Mar 2013 09:09:49 +0100
> *To: *[EMAIL PROTECTED]<[EMAIL PROTECTED]>; 'Sai Sai'<
> [EMAIL PROTECTED]>
> *ReplyTo: * [EMAIL PROTECTED]
> *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 don’t use
> float to store monetary values like salary. You will get rounding issues at
> some point in time when you do arithmetic on them. Considering you are
> using hadoop you probably have a lot of data so adding it all up will get
> you there really really fast.
> http://stackoverflow.com/questions/3730019/why-not-use-double-or-float-to-represent-currency
> ****
>
> ** **
>
> ** **
>
> *From:* Sai Sai [mailto:[EMAIL PROTECTED]]
> *Sent:* Thursday, March 07, 2013 12:54 PM
> *To:* [EMAIL PROTECTED]
> *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<STRING>,deductions   MAP<STRING,FLOAT>,address
> STRUCT<street:STRING, city:STRING, state:STRING, zip:INT, country:STRING>)
> ****
>
> ** **
>
> I would like to access/display country column from my address struct.****
>
> I have tried this:****
>
> ** **
>
> select address["country"] from employees;****
>
> ** **
>
> I get an error.****
>
> ** **
>
> Please help.****
>
> ** **
>
> Thanks****
>
> Sai****
>

--
*Dean Wampler, Ph.D.*
thinkbiganalytics.com
+1-312-339-1330
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB