hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Moore, Douglas" <Douglas.Mo...@thinkbiganalytics.com>
Subject Re: Hive documentation update for isNull, isNotNull etc.
Date Sun, 19 Apr 2015 00:30:26 GMT
Edward,
Thanks, my error on the version 0.5, I was following GrepCode down the wrong path.

From: Edward Capriolo <edlinuxguru@gmail.com<mailto:edlinuxguru@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.Moore@thinkbiganalytics.com<mailto:Douglas.Moore@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 <leftyleverenz@gmail.com<mailto:leftyleverenz@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 <dmtolpeko@gmail.com<mailto:dmtolpeko@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.Moore@thinkbiganalytics.com<mailto:Douglas.Moore@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




Mime
View raw message