Re: Analytic functions in Lead & Lag in Hive

Hi Karthik, Thanks. But we are using Hive 0.10 version of Hive. Is there any alternative way available to implement this Lead / Lag functionality in Hive 0.10 version Regards Raviprasad On Fri, Nov 14, 2014 at 7:51 PM, Dhandapani, Karthik < karthik.dhandap...@cvscaremark.com> wrote: > Ravi, >

Re: Values getting duplicated in Hive table(Partitioned)

In non partitioned table I am getting the correct values. Is my update query wrong? 1. INSERT OVERWRITE TABLE Unm_Parti_Trail PARTITION (Department = 'A') SELECT employeeid,firstname,designation, CASE WHEN employeeid=19 THEN '5 ELSE salary END AS salary FROM Unm_Parti_Trail; What I

Re: Values getting duplicated in Hive table(Partitioned)

Can you check your select query to run on non partitioned tables. Check if it's giving correct values. Same as for dept. B On Nov 17, 2014 10:03 AM, "unmesha sreeveni" wrote: > ***I created a Hive table with *non*- *partitioned* and using select > query I inserted data into *Partioned* Hive tab

Re: Values getting duplicated in Hive table(Partitioned)

***I created a Hive table with *non*- *partitioned* and using select query I inserted data into *Partioned* Hive table. On Mon, Nov 17, 2014 at 10:00 AM, unmesha sreeveni wrote: > I created a Hive table with *partition* and inserted data into Partioned > Hive table. > > Refered site >

Re: Values getting duplicated in Hive table(Partitioned)

You need to check you query. Last one is. Column and data is replicated by your query only. On Nov 17, 2014 10:01 AM, "unmesha sreeveni" wrote: > I created a Hive table with *partition* and inserted data into Partioned > Hive table. > > Refered site >

Values getting duplicated in Hive table(Partitioned)

I created a Hive table with *partition* and inserted data into Partioned Hive table. Refered site 1. *Initially created one Non -partioned table and then using select query and loaded data into partioned tabl

Re: [ANNOUNCE] Apache Hive 0.14.0 Released

Great job! Congrats! Thanks, Zhuoluo (Clark) Yang 2014-11-13 8:55 GMT+08:00 Gunther Hagleitner : > The Apache Hive team is proud to announce the the release of Apache > Hive version 0.14.0. > > The Apache Hive (TM) data warehouse software facilitates querying and > managing large datasets residi

Fwd: load Hive veiw in Pig using HCatLoader

Hi, I'm trying to load Hive view into withing Pig script using org.apache.hive.hcatalog.pig.HCatLoader. I'm using Hortonworks HDP2.2 with hive-hcatalog-pig-adapter-0.14.0.2.2.0.0-1084.jar (I also tried HDP 2.1 with hive 0.13). Loading tables works perfectly. *My code is as following:* flat = LOAD