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] [Created] (PHOENIX-1258) RegexpSubstrFunction is not useable with group by query
Date Wed, 17 Sep 2014 10:14:33 GMT
jay wong created PHOENIX-1258:
---------------------------------

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


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)



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

Mime
View raw message