You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/08/26 21:59:20 UTC
[jira] [Commented] (PHOENIX-2793) Date-time functions on null dates
return no data
[ https://issues.apache.org/jira/browse/PHOENIX-2793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15439984#comment-15439984 ]
ASF GitHub Bot commented on PHOENIX-2793:
-----------------------------------------
GitHub user kliewkliew opened a pull request:
https://github.com/apache/phoenix/pull/201
PHOENIX-2793 Date-time functions on null dates return no data
I cannot reproduce the issue but I added a test case.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/kliewkliew/phoenix PHOENIX-2793
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/phoenix/pull/201.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #201
----
commit 6c9a3f928f31d373f1d7f25117fbffbdf3a6c246
Author: kliewkliew <kl...@users.noreply.github.com>
Date: 2016-08-24T16:55:21Z
PHOENIX-2793 Date-time functions on null dates return no data
----
> Date-time functions on null dates return no data
> ------------------------------------------------
>
> Key: PHOENIX-2793
> URL: https://issues.apache.org/jira/browse/PHOENIX-2793
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.4.0
> Environment: HDP 2.3.4
> Reporter: Kevin Liew
> Assignee: Kevin Liew
> Priority: Minor
> Labels: date, function, time, timestamp
>
> {code:sql}select month(at1.DATE_col5) from at1 where date_col5 is null{code}
> returns zero rows but should return one null row for each null row in at1.DATE_col5
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)