phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ankit Singhal (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-3956) NTH_VALUE(R.NAME,2) return null
Date Thu, 13 Jul 2017 11:01:00 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-3956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ankit Singhal updated PHOENIX-3956:
-----------------------------------
    Fix Version/s:     (was: 4.9.0)
                   4.12.0

> NTH_VALUE(R.NAME,2) return null
> -------------------------------
>
>                 Key: PHOENIX-3956
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3956
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.9.0
>         Environment: Linux localhost 4.4.0-21-generic #37-Ubuntu SMP Mon Apr 18 18:33:37
UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
>            Reporter: huangxiaowei
>            Priority: Critical
>             Fix For: 4.12.0
>
>   Original Estimate: 48h
>  Remaining Estimate: 48h
>
> hi,
> only one record retrun correctly, others is null
>  query SQL:
> select R.UID,NTH_VALUE(R.NAME,2) within group(order by R.TM ASC) E1 from BI_SERVER_EVENT
R group by R.UID;
> result:
> +---------------+------------+
> |      UID      |     E1     |
> +---------------+------------+
> | 1Fce4WlZKSfu  | face_reco  |
> | 43kFjO5uEpMH  |            |
> | 6xNt3lRQ9OGw  |            |
> | 9GNuyk7xZ1wo  |            |
> | B5Roytcudnwp  |            |
> | EmKHvrtnPbyp  |            |
> | Eohf9pKdgGU2  |            |
> | F2q564YZbApP  |            |
> | HskmMNGcYBrU  |            |
> | IyEbuzPocVHp  |            |
> | JPWkZ1bxVf07  |            |
> but the data is not null
> the data :
> 0: jdbc:phoenix:> select UID,count(NAME) from BI_SERVER_EVENT group by UID;
> +---------------+--------------+
> |      UID      | COUNT(NAME)  |
> +---------------+--------------+
> | 1Fce4WlZKSfu  | 7            |
> | 43kFjO5uEpMH  | 7            |
> | 6xNt3lRQ9OGw  | 7            |
> | 9GNuyk7xZ1wo  | 7            |
> | B5Roytcudnwp  | 7            |
> | EmKHvrtnPbyp  | 7            |
> | Eohf9pKdgGU2  | 7            |
> | F2q564YZbApP  | 7            |
> | HskmMNGcYBrU  | 7            |
> | IyEbuzPocVHp  | 7            |
> | JPWkZ1bxVf07  | 7            |
> | KeloBwCp2znx  | 7            |
> | LBn7jqesfr60  | 7            |
> | OCZ5Dmi2L60M  | 7            |



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message