hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: Hive documentation update for isNull, isNotNull etc.
Date Sat, 18 Apr 2015 23:38:50 GMT
"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> 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>
> 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 <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
>>
>>
>> On Sat, Apr 18, 2015 at 12:22 AM, Moore, Douglas <
>> 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