[jira] [Commented] (PHOENIX-4618) Optimize out order-by on sort-merge-join when possible

[ https://issues.apache.org/jira/browse/PHOENIX-4618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16795693#comment-16795693 ] Gerald Sangudi commented on PHOENIX-4618: - Ok, thanks [~comnetwork]. > Optimiz

[jira] [Commented] (PHOENIX-4618) Optimize out order-by on sort-merge-join when possible

[ https://issues.apache.org/jira/browse/PHOENIX-4618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16795537#comment-16795537 ] Gerald Sangudi commented on PHOENIX-4618: - Hi [~comnetwork], Does it work with

[jira] [Commented] (PHOENIX-4618) Optimize out order-by on sort-merge-join when possible

[ https://issues.apache.org/jira/browse/PHOENIX-4618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16795156#comment-16795156 ] Gerald Sangudi commented on PHOENIX-4618: - Does this change work with various f

[jira] [Comment Edited] (PHOENIX-4618) Optimize out order-by on sort-merge-join when possible

[ https://issues.apache.org/jira/browse/PHOENIX-4618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16795156#comment-16795156 ] Gerald Sangudi edited comment on PHOENIX-4618 at 3/18/19 4:15 PM: ---

[jira] [Comment Edited] (PHOENIX-4618) Optimize out order-by on sort-merge-join when possible

[ https://issues.apache.org/jira/browse/PHOENIX-4618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16795156#comment-16795156 ] Gerald Sangudi edited comment on PHOENIX-4618 at 3/18/19 4:14 PM: ---

[jira] [Commented] (PHOENIX-4757) composite key salt_buckets

[ https://issues.apache.org/jira/browse/PHOENIX-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16699354#comment-16699354 ] Gerald Sangudi commented on PHOENIX-4757: - Hi folks, I have started to prototyp

[jira] [Commented] (PHOENIX-4757) composite key salt_buckets

[ https://issues.apache.org/jira/browse/PHOENIX-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16694276#comment-16694276 ] Gerald Sangudi commented on PHOENIX-4757: - Indeed. Non-random id_2 will acceler

[jira] [Comment Edited] (PHOENIX-4757) composite key salt_buckets

[ https://issues.apache.org/jira/browse/PHOENIX-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16694250#comment-16694250 ] Gerald Sangudi edited comment on PHOENIX-4757 at 11/21/18 5:18 AM: --

[jira] [Commented] (PHOENIX-4757) composite key salt_buckets

[ https://issues.apache.org/jira/browse/PHOENIX-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16694250#comment-16694250 ] Gerald Sangudi commented on PHOENIX-4757: - [~tdsilva] - my understanding is tha

[jira] [Commented] (PHOENIX-4757) composite key salt_buckets

[ https://issues.apache.org/jira/browse/PHOENIX-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16693930#comment-16693930 ] Gerald Sangudi commented on PHOENIX-4757: - [~tdsilva] - wouldn't id_1 cause the

[jira] [Issue Comment Deleted] (PHOENIX-4757) composite key salt_buckets

[ https://issues.apache.org/jira/browse/PHOENIX-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gerald Sangudi updated PHOENIX-4757: Comment: was deleted (was: [~tdsilva] - id_1and id_2 are not constant. They are meaningfu

[jira] [Commented] (PHOENIX-4757) composite key salt_buckets

[ https://issues.apache.org/jira/browse/PHOENIX-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16693888#comment-16693888 ] Gerald Sangudi commented on PHOENIX-4757: - [~tdsilva] - id_1and id_2 are not co

[jira] [Commented] (PHOENIX-4757) composite key salt_buckets

[ https://issues.apache.org/jira/browse/PHOENIX-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16693889#comment-16693889 ] Gerald Sangudi commented on PHOENIX-4757: - [~tdsilva] - id_1and id_2 are not co

[jira] [Comment Edited] (PHOENIX-4757) composite key salt_buckets

[ https://issues.apache.org/jira/browse/PHOENIX-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16689953#comment-16689953 ] Gerald Sangudi edited comment on PHOENIX-4757 at 11/16/18 8:11 PM: --

[jira] [Commented] (PHOENIX-4757) composite key salt_buckets

[ https://issues.apache.org/jira/browse/PHOENIX-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16689953#comment-16689953 ] Gerald Sangudi commented on PHOENIX-4757: - [~jamestaylor] - re your questions--

[jira] [Commented] (PHOENIX-4757) composite key salt_buckets

[ https://issues.apache.org/jira/browse/PHOENIX-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16686892#comment-16686892 ] Gerald Sangudi commented on PHOENIX-4757: - [~jamestaylor] - I'm working through

[jira] [Commented] (PHOENIX-4757) composite key salt_buckets

[ https://issues.apache.org/jira/browse/PHOENIX-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16675727#comment-16675727 ] Gerald Sangudi commented on PHOENIX-4757: - [~lhofhansl], thanks for your questi

[jira] [Commented] (PHOENIX-4917) ClassCastException when projecting array elements in hash join

[ https://issues.apache.org/jira/browse/PHOENIX-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16637508#comment-16637508 ] Gerald Sangudi commented on PHOENIX-4917: - Thanks [~twdsi...@gmail.com]. I am u

[jira] [Commented] (PHOENIX-4917) ClassCastException when projecting array elements in hash join

[ https://issues.apache.org/jira/browse/PHOENIX-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16637429#comment-16637429 ] Gerald Sangudi commented on PHOENIX-4917: - [~twdsi...@gmail.com] - How do I con

[jira] [Commented] (PHOENIX-4917) ClassCastException when projecting array elements in hash join

[ https://issues.apache.org/jira/browse/PHOENIX-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16637296#comment-16637296 ] Gerald Sangudi commented on PHOENIX-4917: - [~twdsi...@gmail.com] I'm taking a l

[jira] [Commented] (PHOENIX-4917) ClassCastException when projecting array elements in hash join

[ https://issues.apache.org/jira/browse/PHOENIX-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16636115#comment-16636115 ] Gerald Sangudi commented on PHOENIX-4917: - [~twdsi...@gmail.com] There are mult

[jira] [Commented] (PHOENIX-4917) ClassCastException when projecting array elements in hash join

[ https://issues.apache.org/jira/browse/PHOENIX-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16634719#comment-16634719 ] Gerald Sangudi commented on PHOENIX-4917: - [~tdsilva] - am working on the test.

[jira] [Commented] (PHOENIX-4917) ClassCastException when projecting array elements in hash join

[ https://issues.apache.org/jira/browse/PHOENIX-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16632237#comment-16632237 ] Gerald Sangudi commented on PHOENIX-4917: - [~tdsilva] is it possible to get thi

[jira] [Commented] (PHOENIX-4917) ClassCastException when projecting array elements in hash join

[ https://issues.apache.org/jira/browse/PHOENIX-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16630853#comment-16630853 ] Gerald Sangudi commented on PHOENIX-4917: - Ok, will do. Can I do that as a sepa

[jira] [Commented] (PHOENIX-4917) ClassCastException when projecting array elements in hash join

[ https://issues.apache.org/jira/browse/PHOENIX-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16630819#comment-16630819 ] Gerald Sangudi commented on PHOENIX-4917: - The unit tests are already there: [

[jira] [Commented] (PHOENIX-4917) ClassCastException when projecting array elements in hash join

[ https://issues.apache.org/jira/browse/PHOENIX-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16630780#comment-16630780 ] Gerald Sangudi commented on PHOENIX-4917: - [~jamestaylor] [~twdsi...@gmail.com]

[jira] [Commented] (PHOENIX-4917) ClassCastException when projecting array elements in hash join

[ https://issues.apache.org/jira/browse/PHOENIX-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16624845#comment-16624845 ] Gerald Sangudi commented on PHOENIX-4917: - cc [~twdsi...@gmail.com] [~jamestayl

[jira] [Commented] (PHOENIX-4757) composite key salt_buckets

[ https://issues.apache.org/jira/browse/PHOENIX-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16614129#comment-16614129 ] Gerald Sangudi commented on PHOENIX-4757: - We have a similar requirement. From

[jira] [Commented] (PHOENIX-4791) Array elements are nullified with joins

[ https://issues.apache.org/jira/browse/PHOENIX-4791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16606188#comment-16606188 ] Gerald Sangudi commented on PHOENIX-4791: - Thank you [~tdsilva] for the review

[jira] [Commented] (PHOENIX-4791) Array elements are nullified with joins

[ https://issues.apache.org/jira/browse/PHOENIX-4791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16604947#comment-16604947 ] Gerald Sangudi commented on PHOENIX-4791: - Hi [~tdsilva] - all the line lengths

[jira] [Comment Edited] (PHOENIX-4791) Array elements are nullified with joins

[ https://issues.apache.org/jira/browse/PHOENIX-4791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16603730#comment-16603730 ] Gerald Sangudi edited comment on PHOENIX-4791 at 9/4/18 11:44 PM: ---

[jira] [Commented] (PHOENIX-4791) Array elements are nullified with joins

[ https://issues.apache.org/jira/browse/PHOENIX-4791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16603684#comment-16603684 ] Gerald Sangudi commented on PHOENIX-4791: - [~twdsi...@gmail.com] [~jamestaylor]

[jira] [Commented] (PHOENIX-4791) Array elements are nullified with joins

[ https://issues.apache.org/jira/browse/PHOENIX-4791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16597051#comment-16597051 ] Gerald Sangudi commented on PHOENIX-4791: -  Hi folks, Just another ping to req

[jira] [Commented] (PHOENIX-4791) Array elements are nullified with joins

[ https://issues.apache.org/jira/browse/PHOENIX-4791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16589579#comment-16589579 ] Gerald Sangudi commented on PHOENIX-4791: - Submitted PR [https://github.com/apa

[jira] [Commented] (PHOENIX-4791) Array elements are nullified with joins

[ https://issues.apache.org/jira/browse/PHOENIX-4791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16582893#comment-16582893 ] Gerald Sangudi commented on PHOENIX-4791: - [~jamestaylor] - Array element proje

[jira] [Commented] (PHOENIX-4791) Array elements are nullified with joins

[ https://issues.apache.org/jira/browse/PHOENIX-4791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16581954#comment-16581954 ] Gerald Sangudi commented on PHOENIX-4791: - I see. But the optimization to extra

[jira] [Commented] (PHOENIX-4791) Array elements are nullified with joins

[ https://issues.apache.org/jira/browse/PHOENIX-4791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16581930#comment-16581930 ] Gerald Sangudi commented on PHOENIX-4791: - Here's my hypothesis-- (1) the proj

[jira] [Commented] (PHOENIX-4791) Array elements are nullified with joins

[ https://issues.apache.org/jira/browse/PHOENIX-4791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16580709#comment-16580709 ] Gerald Sangudi commented on PHOENIX-4791: - I've found what might be a discrepan

[jira] [Commented] (PHOENIX-4751) Support client-side hash aggregation with SORT_MERGE_JOIN

[ https://issues.apache.org/jira/browse/PHOENIX-4751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16567755#comment-16567755 ] Gerald Sangudi commented on PHOENIX-4751: - Thank you [~tdsilva] for validating

[jira] [Commented] (PHOENIX-4751) Support client-side hash aggregation with SORT_MERGE_JOIN

[ https://issues.apache.org/jira/browse/PHOENIX-4751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16566217#comment-16566217 ] Gerald Sangudi commented on PHOENIX-4751: - [~tdsilva] - I uploaded a patch file