You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "huangxiaowei (JIRA)" <ji...@apache.org> on 2017/06/17 07:04:01 UTC

[jira] [Created] (PHOENIX-3956) NTH_VALUE(R.NAME,2) return null

huangxiaowei created PHOENIX-3956:
-------------------------------------

             Summary: 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.9.0


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



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