Hive, mail # user - Re: Hive Query :: Implementing case statement - 2014-02-20, 05:16
 Search Hadoop and all its subprojects:

Switch to Threaded View
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:
 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB