[jira] [Created] (PHOENIX-2125) ORDER BY on full PK on salted table does not work

["Brian Esserlieu (JIRA)" <ji...@apache.org>]

Brian Esserlieu created PHOENIX-2125:
----------------------------------------

             Summary: ORDER BY on full PK on salted table does not work
                 Key: PHOENIX-2125
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2125
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.5.0
            Reporter: Brian Esserlieu


Ordering by the full PK on a salted table does not work

REPRO:

--create a salted table with 2 pk fields
CREATE TABLE IF NOT EXISTS TEST_TABLE (
    PK1 CHAR(15) NOT NULL,
    PK2 CHAR(15) NOT NULL
    CONSTRAINT PK PRIMARY KEY
    (
        PK1,
        PK2
    )
) SALT_BUCKETS=16;

--insert data
UPSERT INTO TEST_TABLE (PK1, PK2) VALUES ('FOO','BAR1-oiwnefin');
UPSERT INTO TEST_TABLE (PK1, PK2) VALUES ('FOO','BAR2-qoosdfpin');
UPSERT INTO TEST_TABLE (PK1, PK2) VALUES ('FOO','BAR3*)&&)*(@)');
UPSERT INTO TEST_TABLE (PK1, PK2) VALUES ('FOO','BAR4      .');

--do a quick query to verify the data in field PK2 is not completely in order 
--	(salting + round robin should hopefully have thrown at least 2 rows out of order)
SELECT * FROM TEST_TABLE

--running this query, you can see that the rows are now properly ordered
SELECT * FROM TEST_TABLE ORDER BY PK2

--this query is logically identical to the previous SELECT statement with ordering,
-- but as you can see it's actually identical to the first SELECT statement (without ordering)
SELECT * FROM TEST_TABLE ORDER BY PK1, PK2

--clean up if you like
DROP TABLE IF EXISTS TEST_TABLE CASCADE;



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