"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> 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> > Reply-To: <user@hive.apache.org> > Date: Fri, 17 Apr 2015 19:19:47 -0400 > To: <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> > wrote: > >> 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 >>> >> >> >
