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