Hello Stephen ,
Yes, actully I have used Left Outer Join instead of Join, there were left
outer joins in RDBMS Query instead of join.
Thanks again :)
On Thu, Feb 20, 2014 at 10:45 AM, Stephen Sprague wrote:
> Hi Yogesh,
>
> i overlooked one thing and for completeness we should make note of it
Hi Yogesh,
i overlooked one thing and for completeness we should make note of it here.
change:
-- non-intersected rows
select a.* from TABLE_SQL a join NEW_BALS b on (a.key=b.key) where
b.NEW_BALANCE is null
to
-- non-intersected rows
select a.* from TABLE_SQL a *LEFT OUTER* join NEW_BAL
Thanks a lot Stephen Sprague :) :)
It worked.. , just to remove the " ; " from here, bcoz it was throuig
sub query systax error...
create table NEW_BALS as
select * from (
select b.prev as NEW_BALANCE, a.key from TABLE_SQL a join TABLE_SQL_2 b on
(a.key=b.key) where a.code='1';
UNION ALL
sel
maybe consider something along these lines. nb. not tested.
-- temp table holding new balances + key
create table NEW_BALS as
select * from (
select b.prev as NEW_BALANCE, a.key from TABLE_SQL a join TABLE_SQL_2
b on (a.key=b.key) where a.code='1';
UNION ALL
select b.prev as N
If key is unique, you might overwrite values by using hbase handler.
2014-02-18 22:05 GMT+09:00 yogesh dhari :
> Yes, Hive does not provide update statement, I am just looking for the
> work arround it, how to implement it
>
>
>
>
>
> On Tue, Feb 18, 2014 at 6:27 PM, Peter Marron <
> peter.mar..
Yes, Hive does not provide update statement, I am just looking for the work
arround it, how to implement it
On Tue, Feb 18, 2014 at 6:27 PM, Peter Marron <
peter.mar...@trilliumsoftware.com> wrote:
> From https://cwiki.apache.org/confluence/display/Hive/Home
>
>
>
> "Hive is not designed for
>From https://cwiki.apache.org/confluence/display/Hive/Home
"Hive is not designed for OLTP workloads and does not offer real-time queries
or row-level updates."
As far as I am aware "UPDATE" isn't even in the Hive DML.
Z
Peter Marron
Senior Developer
Trillium Software, A Harte Hanks Company
Th
