Phoenix is not sorting by row key when merging results across multiples region servers

[#1]

I'm running Phoenix in a cluster with 3 region servers and salting the row key specifying the property "SALT_BUCKETS" = 3 when creating the table.

When querying the table I expect the resulting scan to be return ordered by row key but when merging the results across the different RSs but I'm getting a mixed merge rather a sort merge.

I could add an "order by" clause by row key and it solves the issue but it implies to know the row key in advance and adding every time I run a query.

I have also tried setting the property 'phoenix.query.rowKeyOrderSaltedTable' to true in hbase-site.xml as Phoenix documentation suggests but it does not make any difference.

Is there any better way to resolve that rather than appending an "order by" clause to the query??

Using Phoenix 4.4 and HDP 2.4.2

[#2 · Accepted solution]

"phoenix.query.rowKeyOrderSaltedTable" is the client property, can you make sure hbase-site.xml is in the classpath of your application/sqlline.

[#3]

I'm using sqlline.py as phoenix client and it includes "/etc/hbase/conf" in phoenix_class_path, hbase-site.xml file is there with "phoenix.query.rowKeyOrderSaltedTable" to true

[#4]

would you mind try again by setting this phoenix.query.force.rowkeyorder to true too. as phoenix.query.rowKeyOrderSaltedTable got deprecated with phoenix.query.force.rowkeyorder in some release.

[#5]

That one did the job! Now I'm getting the results in the right order and I can see the "CLIENT MERGE SORT" in the query plan explanation.

Thanks!