Re: Hive update operation

2016-09-01 Thread Db-Blog
qnum=t1.deal_number >> where t1.deal_number=mv.acqnum; >> >> OUTPUT: >> >> " FAILED: ParseException line 1:221 missing EOF at 'FROM' near 'bgps' " >> >> >> From: Mich Talebzadeh <mich.talebza...@gmail.com> >> Sent: 25 Au

Re: Fw: Hive update operation

2016-08-26 Thread Mich Talebzadeh
ber > where t1.deal_number=mv.acqnum; > > OUTPUT: > > " FAILED: ParseException line 1:221 missing EOF at 'FROM' near 'bgps' " > > > -- > *From:* Mich Talebzadeh <mich.talebza...@gmail.com> > *Sent:* 25 August 2016 21:41:51 &g

Re: Fw: Hive update operation

2016-08-25 Thread Mich Talebzadeh
tatus=T2.PinsStatus > > FROM table2 T2 > INNER JOIN table1 T1 on T2.AcqNum=T1.AccoNo > > Priyanka Raghuvanshi > -- > *From:* Mich Talebzadeh <mich.talebza...@gmail.com> > *Sent:* 24 August 2016 22:02:58 > *To:* user > *Subject:* Re: Fw:

Re: Fw: Hive update operation

2016-08-24 Thread Priyanka Raghuvanshi
ghuvanshi From: Mich Talebzadeh <mich.talebza...@gmail.com> Sent: 24 August 2016 22:02:58 To: user Subject: Re: Fw: Hive update operation have the underlying table to be updated been defined as transactional? can you give the update example? Dr Mich Talebzadeh L

Re: Fw: Hive update operation

2016-08-24 Thread Mich Talebzadeh
2 > *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 >

Fw: Hive update operation

2016-08-24 Thread Priyanka Raghuvanshi
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