hadoop-hdfs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From unmesha sreeveni <unmeshab...@gmail.com>
Subject Re: Fwd: Values getting duplicated in Hive table(Partitioned)
Date Tue, 18 Nov 2014 13:57:47 GMT
Thanks it worked.
On Nov 17, 2014 3:32 PM, "unmesha sreeveni" <unmeshabiju@gmail.com> wrote:

>
> ---------- Forwarded message ----------
> From: unmesha sreeveni <unmeshabiju@gmail.com>
> Date: Mon, Nov 17, 2014 at 10:49 AM
> Subject: Re: Values getting duplicated in Hive table(Partitioned)
> To: User - Hive <user@hive.apache.org>
>
>
> 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
>    '50000 ELSE salary END AS salary FROM Unm_Parti_Trail;
>
> What I tried to include in the query is , In partion with department = A,
> update employeeid =19 's salary with 50000
>
> Is that query statement wrong? and the replication is not affected to dept
> B and C.
> --
> *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/
>
>
>

Mime
View raw message