Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@phoenix.apache.org
Date: Tue, 29 Aug 2017 16:19:00 +0000 (UTC)
From: "Csaba Skrabak (JIRA)" <jira@apache.org>
To: dev@phoenix.apache.org
Message-ID: <JIRA.13098316.1504023493000.148058.1504023540258@Atlassian.JIRA>
In-Reply-To: <JIRA.13098316.1504023493000@Atlassian.JIRA>
References: <JIRA.13098316.1504023493000@Atlassian.JIRA> <JIRA.13098316.1504023493010@jira-lw-us.apache.org>
Subject: [jira] [Created] (PHOENIX-4139) select distinct with identical
 aggregations return weird values
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Tue, 29 Aug 2017 16:19:10 -0000

Csaba Skrabak created PHOENIX-4139:
--------------------------------------

             Summary: select distinct with identical aggregations return we=
ird values=20
                 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


From sme-hbase hipchat room:
Pulkit Bhardwaj=C2=B710: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;
+---------+----------+-----+
|=E2=80=82=E2=80=82 NAM=E2=80=82=E2=80=82 | ADDRESS=E2=80=82=E2=80=82| ID=
=E2=80=82=E2=80=82|
+---------+----------+-----+
| pulkit=E2=80=82=E2=80=82| badaun=E2=80=82=E2=80=82 | 1=E2=80=82=E2=80=82 =
|
+---------+----------+-----+


0: jdbc:phoenix:> select distinct 'harshit' as "test_column", nam from test=
_select;
+--------------+---------+
| test_column=E2=80=82=E2=80=82|=E2=80=82=E2=80=82 NAM=E2=80=82=E2=80=82 |
+--------------+---------+
| harshit=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82| pulkit=E2=
=80=82=E2=80=82|
+--------------+---------+


0: jdbc:phoenix:> select distinct 'harshit' as "test_column", trim(nam), tr=
im(nam) from test_select;
+--------------+----------------+----------------+
| test_column=E2=80=82=E2=80=82|=E2=80=82=E2=80=82 TRIM(NAM)=E2=80=82=E2=80=
=82=E2=80=82=E2=80=82|=E2=80=82=E2=80=82 TRIM(NAM)=E2=80=82=E2=80=82=E2=80=
=82=E2=80=82|
+--------------+----------------+----------------+
| harshit=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82| pulkitpulk=
it=E2=80=82=E2=80=82| pulkitpulkit=E2=80=82=E2=80=82|
+--------------+----------------+----------------+
{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), tr=
im(nam), trim(nam) from test_select;
+--------------+-----------------------+-----------------------+-----------=
------------+
| test_column=E2=80=82=E2=80=82|=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=
=82=E2=80=82 TRIM(NAM)=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=
=82 |=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82 TRIM(NAM)=E2=80=
=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82 |=E2=80=82=E2=80=82=E2=80=
=82=E2=80=82=E2=80=82=E2=80=82 TRIM(NAM)=E2=80=82=E2=80=82=E2=80=82=E2=80=
=82=E2=80=82=E2=80=82 |
+--------------+-----------------------+-----------------------+-----------=
------------+
| harshit=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82| pulkitpulk=
itpulkit=E2=80=82=E2=80=82| pulkitpulkitpulkit=E2=80=82=E2=80=82| pulkitpul=
kitpulkit=E2=80=82=E2=80=82|
+--------------+-----------------------+-----------------------+-----------=
------------+
{noformat}

Wondering if someone has seen this before??

One thing to note is, if I remove the =E2=80=94=E2=80=94 distinct 'harshit'=
 as "test_column" =E2=80=94=E2=80=94=E2=80=82=E2=80=82The issue is not seen
{noformat}
0: jdbc:phoenix:> select trim(nam), trim(nam), trim(nam) from test_select;
+------------+------------+------------+
| TRIM(NAM)=E2=80=82=E2=80=82| TRIM(NAM)=E2=80=82=E2=80=82| TRIM(NAM)=E2=80=
=82=E2=80=82|
+------------+------------+------------+
| pulkit=E2=80=82=E2=80=82=E2=80=82=E2=80=82 | pulkit=E2=80=82=E2=80=82=E2=
=80=82=E2=80=82 | pulkit=E2=80=82=E2=80=82=E2=80=82=E2=80=82 |
+------------+------------+------------+
{noformat}


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