[
https://issues.apache.org/jira/browse/PHOENIX-4139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16345299#comment-16345299
]
Csaba Skrabak edited comment on PHOENIX-4139 at 1/30/18 4:25 PM:
-----------------------------------------------------------------
[~jamestaylor], [^PHOENIX-4139_v2.patch] already has a kind of fix that makes
the test case pass. I think it would be nice to include this fix.
But still we should keep a Jira ticket open because the internal behavior of
the code is not as designed. I'm thinking of producing an error case but I did
not yet find one. I'll clone this ticket in case you would commit my current
fix and close. Then in the clone we can track the final solution.
was (Author: cskrabak):
[~jamestaylor], my v2 patch already has a kind of fix that makes the test case
pass. I think it would be nice to include this fix.
But still we should keep a Jira ticket open because the internal behavior of
the code is not as designed. I'm thinking of producing an error case but I did
not yet find one. I'll clone this ticket in case you would commit my current
fix and close. Then in the clone we can track the final solution.
> select distinct with identical aggregations return weird values
> ----------------------------------------------------------------
>
> Key: PHOENIX-4139
> URL: https://issues.apache.org/jira/browse/PHOENIX-4139
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.12.0
> Environment: minicluster
> Reporter: Csaba Skrabak
> Assignee: Csaba Skrabak
> Priority: Minor
> Fix For: 4.14.0
>
> Attachments: PHOENIX-4139.patch, PHOENIX-4139_v2.patch
>
>
> From sme-hbase hipchat room:
> Pulkit Bhardwaj·10:31
> i'm seeing a weird issue with phoenix, appreciate some thoughts
> Created a simple table in phoenix
> {noformat}
> 0: jdbc:phoenix:> create table test_select(nam VARCHAR(20), address
> VARCHAR(20), id BIGINT
> . . . . . . . . > constraint my_pk primary key (id));
> 0: jdbc:phoenix:> upsert into test_select (nam, address,id)
> values('pulkit','badaun',1);
> 0: jdbc:phoenix:> select * from test_select;
> +---------+----------+-----+
> | NAM | ADDRESS | ID |
> +---------+----------+-----+
> | pulkit | badaun | 1 |
> +---------+----------+-----+
> 0: jdbc:phoenix:> select distinct 'harshit' as "test_column", nam from
> test_select;
> +--------------+---------+
> | test_column | NAM |
> +--------------+---------+
> | harshit | pulkit |
> +--------------+---------+
> 0: jdbc:phoenix:> select distinct 'harshit' as "test_column", trim(nam),
> trim(nam) from test_select;
> +--------------+----------------+----------------+
> | test_column | TRIM(NAM) | TRIM(NAM) |
> +--------------+----------------+----------------+
> | harshit | pulkitpulkit | pulkitpulkit |
> +--------------+----------------+----------------+
> {noformat}
> When I apply a trim on the nam column and use it multiple times, the output
> has the cell data duplicated!
> {noformat}
> 0: jdbc:phoenix:> select distinct 'harshit' as "test_column", trim(nam),
> trim(nam), trim(nam) from test_select;
> +--------------+-----------------------+-----------------------+-----------------------+
> | test_column | TRIM(NAM) | TRIM(NAM) |
> TRIM(NAM) |
> +--------------+-----------------------+-----------------------+-----------------------+
> | harshit | pulkitpulkitpulkit | pulkitpulkitpulkit |
> pulkitpulkitpulkit |
> +--------------+-----------------------+-----------------------+-----------------------+
> {noformat}
> Wondering if someone has seen this before??
> One thing to note is, if I remove the —— distinct 'harshit' as "test_column"
> —— The issue is not seen
> {noformat}
> 0: jdbc:phoenix:> select trim(nam), trim(nam), trim(nam) from test_select;
> +------------+------------+------------+
> | TRIM(NAM) | TRIM(NAM) | TRIM(NAM) |
> +------------+------------+------------+
> | pulkit | pulkit | pulkit |
> +------------+------------+------------+
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
