xp_replace(t2.cout_event_description,'''''''',''''),latitude=t2.latitude,longitude=t2.longitude
>> ,speed =t2.speed,dtimestamp =mv.dtimestamp,reg_no=t2.registration,gpsstate
>> = t2.bgps FROM default.maxvalues mv, table2 t2 IN
timestamp AND mv.acqnum=t2.acqnum
> INNER JOIN table1 t1 on mv.acqnum=t1.deal_number
> where t1.deal_number=mv.acqnum;
>
> OUTPUT:
>
> " FAILED: ParseException line 1:221 missing EOF at 'FROM' near 'bgps' "
>
>
>
F at 'FROM' near 'bgps' "
____
From: Mich Talebzadeh
Sent: 25 August 2016 21:41:51
To: user
Subject: Re: Fw: Hive update operation
Him
What is your current RDBMS and are these SQL the ones used in RDBMS?
Have you tried them
har) + ' KMPH ['+ isnull(T1.AccountNo,'')
> +'];'+ isnull(T2.ChassisNumber,'') +';'+ isnull(replace(T2.OwnerName,'''','')
> ,'') +';'+ isnull(T2.clmn1,''),
> Status=T2.PinsStatus
#x27;') +'];'+
isnull(T2.ChassisNumber,'') +';'+ isnull(replace(T2.OwnerName,'''','') ,'')
+';'+ isnull(T2.clmn1,''),
Status=T2.PinsStatus
FROM table2 T2
INNER JOIN table1 T1 on T2.AcqNum=T1.AccoNo
Priyanka Raghuv
no case be liable for any monetary damages arising from
such loss, damage or destruction.
On 24 August 2016 at 14:50, Priyanka Raghuvanshi
wrote:
>
>
>
> --
> *From:* Priyanka Raghuvanshi
> *Sent:* 24 August 2016 19:12
> *To:* user@hive.apa
From: Priyanka Raghuvanshi
Sent: 24 August 2016 19:12
To: user@hive.apache.org
Subject: Hive update operation
Hi,
Is it possible to update a table(ORC) using join or column of another
table(ORC)?
Kind Regards,
Priyanka Raghuvanshi