I also recently realized that NVL function is available, but not documented :(
Dmitry Tolpeko -- PL/HQL - Procedural SQL-on-Hadoop - www.plhql.org On Sat, Apr 18, 2015 at 12:22 AM, Moore, Douglas < 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 >