phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jay wong (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-1258) RegexpSubstrFunction is not useable with group by query
Date Wed, 17 Sep 2014 10:37:33 GMT

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

jay wong updated PHOENIX-1258:
------------------------------
    Attachment: regex_substr_func_group.patch

the patch only include RegexpSubstrFunction

maybe other fuction alse have some problem with group by query

> RegexpSubstrFunction is not useable with group by query 
> --------------------------------------------------------
>
>                 Key: PHOENIX-1258
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1258
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 3.1
>            Reporter: jay wong
>            Assignee: jay wong
>             Fix For: 3.1
>
>         Attachments: regex_substr_func_group.patch
>
>
> 0: jdbc:phoenix:10.232.98.99:/hbase-phoenix-l> select gmt subgmt from test_salt1 limit
2;
> |   SUBGMT   |
> | asdfasf?fas |
> | basdfasf?fas |
> 2 rows selected (0.071 seconds)
> 0: jdbc:phoenix:10.232.98.99:/hbase-phoenix-l> select REGEXP_SUBSTR(gmt, '[^\\?]+')
subgmt from test_salt1 limit 2;
> |   SUBGMT   |
> | asdfasf    |
> | basdfasf   |
> 2 rows selected (0.07 seconds)
> 0: jdbc:phoenix:10.232.98.99:/hbase-phoenix-l> select REGEXP_SUBSTR(gmt, '[^\\?]+')
subgmt,sum(int_A) from test_salt1 group by subgmt;
> |   SUBGMT   | SUM(A.INT_A) |
> | null       | 17498        |
> 1 row selected (0.082 seconds)
> the group by result is not expected
> below result is expected
> |SUBGMT	|SUM(A.INT_A)|
> | asdfasf    |   8342 |
> | basdfasf   | 5449 |



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message