Edward, Thanks, my error on the version 0.5, I was following GrepCode down the wrong path.
From: Edward Capriolo <edlinuxg...@gmail.com<mailto:edlinuxg...@gmail.com>> Reply-To: <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Sat, 18 Apr 2015 19:38:50 -0400 To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Subject: Re: Hive documentation update for isNull, isNotNull etc. "show functions" returns = < etc. I believe I added NVL (https://issues.apache.org/jira/browse/HIVE-2288) and hive also has coalesce. Even if you can access isNull as a function I think it might be more clear to just write the query as 'column IS NULL' that would be a more portable query. On Sat, Apr 18, 2015 at 6:26 PM, Moore, Douglas <douglas.mo...@thinkbiganalytics.com<mailto:douglas.mo...@thinkbiganalytics.com>> wrote: Dmitry &Lefty the Hive docs updated<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-ConditionalFunctions> NVL has been around since 0.5, maybe earlier. One day I may do a full audit (compare show functions vs. the documentation). - Douglas From: Lefty Leverenz <leftylever...@gmail.com<mailto:leftylever...@gmail.com>> Reply-To: <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Fri, 17 Apr 2015 19:19:47 -0400 To: <user@hive.apache.org<mailto:user@hive.apache.org>> Subject: Re: Hive documentation update for isNull, isNotNull etc. Hooray for updating the docs! Douglas, if you tell me your Confluence username I'll grant you write access to the wiki (see About This Wiki<https://cwiki.apache.org/confluence/display/Hive/AboutThisWiki#AboutThisWiki-Howtogetpermissiontoedit>). Thanks. -- Lefty On Fri, Apr 17, 2015 at 6:11 PM, Dmitry Tolpeko <dmtolp...@gmail.com<mailto:dmtolp...@gmail.com>> wrote: I also recently realized that NVL function is available, but not documented :( Dmitry Tolpeko -- PL/HQL - Procedural SQL-on-Hadoop - www.plhql.org<http://www.plhql.org> On Sat, Apr 18, 2015 at 12:22 AM, Moore, Douglas <douglas.mo...@thinkbiganalytics.com<mailto:douglas.mo...@thinkbiganalytics.com>> wrote: I'm having major trouble finding documentation on hive functions isNull and isNotNull. At first I was assuming the function just wasn't available, now I believe these functions are not documented. I believe that the LanguageManual+UDF#LanguageManualUDF-Built-inFunctions<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-Built-inFunctions> is the right wiki page: Interestingly, I found a HIVE-521 (resolved in 0.4) to be the first reference for isNull within JIRA. Is Lefty volunteering for this? If not I can make the edits if given permissions. Thanks Douglas
