Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive Query :: Implementing case statement


Copy link to this message
-
Re: Hive Query :: Implementing case statement
Hi Yogesh,

i overlooked one thing and for completeness we should make note of it here.

change:

   select a.* from TABLE_SQL a join NEW_BALS b on (a.key=b.key) where
b.NEW_BALANCE is null

to

   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: