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