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] [Commented] (PHOENIX-1258) RegexpSubstrFunction is not useable with group by query
Date Thu, 18 Sep 2014 02:05:33 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-1258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14138395#comment-14138395
] 

jay wong commented on PHOENIX-1258:
-----------------------------------

[~gabriel.reid]
yes. override readFields will be a better way.

But why the test case I named it GroupByWithFunctionIT. 

It's because of that only query use RegexpSubstrFunction ,the result is all right.

the bad case is query with both group by and function. 

as It set into scan attribute which key named UNORDERED_GROUP_BY_EXPRESSIONS.

So It is a group by test. I think



> 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