Re: SORT_MERGE_JOIN on non-leading key: server-side sorting

Thanks Maryann and James. I'll verify the RC as soon as it's available. Gerald On Thu, May 17, 2018 at 5:01 PM, James Taylor wrote: > Hi Gerald, > The fix for PHOENIX-4508 will appear in the 4.14.0 release which we're > working on now. We should have a second RC up

Re: SORT_MERGE_JOIN on non-leading key: server-side sorting

Hi Gerald, The fix for PHOENIX-4508 will appear in the 4.14.0 release which we're working on now. We should have a second RC up shortly that you can use to verify. The fix isn't in 4.13 since it was checked in after the release. Thanks, James On Thu, May 17, 2018 at 4:44 PM, Maryann Xue

Re: SORT_MERGE_JOIN on non-leading key: server-side sorting

Hey, this is a simple experiment I did based on an existing test case. Look for "query3". The test verifies that there is no "SERVER SORT" in the entire query plan (both salted and unsalted tables have been covered): @Test public void testBug4508() throws Exception { Properties props =

Re: SORT_MERGE_JOIN on non-leading key: server-side sorting

Hi Maryann, Would you mind sharing the EXPLAIN output you are getting? I'm not able to find a download for phoenix-4.13.2-HBase or 4.14.0-HBase. The *-cdh downloads do not work with Amazon EMR. I tried building against the 4.14.0-rc0 tag. This produced 4.14.0 for phoenix-core.jar, but all the