Re: Update operation on hive table using Join

2016-10-17 Thread Eugene Koifman
o:user@hive.apache.org>> Date: Monday, October 17, 2016 at 2:14 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: Update operation on hive table using Join Hi, Is there any way to update a Hive table with

Update operation on hive table using Join

2016-10-17 Thread Priyanka Raghuvanshi
Hi, Is there any way to update a Hive table with join. Following is the query : SQL query UPDATE _STCC_CurrentLocationMaPData set [Address]=replace(CL.cOut_Event_Description,,), [Latitude]=CL.fOut_latitude , [Longitude]=CL.fOut_longitude , [Speed] =CL.fOut_Speed, [dTimeStamp] =MV.dT