***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 <unmeshab...@gmail.com> wrote: > I created a Hive table with *partition* and inserted data into Partioned > Hive table. > > Refered site > <https://blog.safaribooksonline.com/2012/12/03/tip-partitioning-data-in-hive/> > > 1. > > *Initially created one Non -partioned table and then using select > query and loaded data into partioned table. Is there an alternate way?* > 2. > > *By following above link my partioned table contains duplicate values. > Below are the setps* > > This is my Sample employee dataset:link1 <http://pastebin.com/tVh16Yxt> > > I tried the following queries: link2 <http://pastebin.com/U2yykWpy> > > But after updating a value in Hive table,the values are getting duplicated. > > 7 Nirmal Tech 12000 A > 7 Nirmal Tech 12000 B > > Nirmal is placed in Department *A* only > , > but it is duplicated to department *B*. > > And Once I update a column value in middle I am getting NULL values > displayed,while updating last column it is fine. > > Am I doing any thing wrong. > Please suggest.-- > *Thanks & Regards * > > > *Unmesha Sreeveni U.B* > *Hadoop, Bigdata Developer* > *Centre for Cyber Security | Amrita Vishwa Vidyapeetham* > http://www.unmeshasreeveni.blogspot.in/ > > > -- *Thanks & Regards * *Unmesha Sreeveni U.B* *Hadoop, Bigdata Developer* *Centre for Cyber Security | Amrita Vishwa Vidyapeetham* http://www.unmeshasreeveni.blogspot.in/
