Re: Hive Query :: Implementing case statement
i overlooked one thing and for completeness we should make note of it here.
select a.* from TABLE_SQL a join NEW_BALS b on (a.key=b.key) where
b.NEW_BALANCE is null
select a.* from TABLE_SQL a *LEFT OUTER* join NEW_BALS b on
(a.key=b.key) where b.NEW_BALANCE is null
This takes care of the rows where code != 1 and code != 2.
But you knew that!
On Wed, Feb 19, 2014 at 8:33 PM, yogesh dhari <[EMAIL PROTECTED]> wrote: