[jira] [Comment Edited] (PHOENIX-3689) Not determinist order by with limit

[ https://issues.apache.org/jira/browse/PHOENIX-3689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15882399#comment-15882399 ] chenglei edited comment on PHOENIX-3689 at 2/24/17 10:27 AM: - Thank your for

[jira] [Commented] (PHOENIX-3689) Not determinist order by with limit

[ https://issues.apache.org/jira/browse/PHOENIX-3689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15882399#comment-15882399 ] chenglei commented on PHOENIX-3689: --- Thank your for adding DDL,but it seems that the sql given before

[jira] [Commented] (PHOENIX-3689) Not determinist order by with limit

[ https://issues.apache.org/jira/browse/PHOENIX-3689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15881828#comment-15881828 ] chenglei commented on PHOENIX-3689: --- Could you please provide your table DDL and some sample data? so

[jira] [Commented] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15877706#comment-15877706 ] chenglei commented on PHOENIX-3578: --- [~jamestaylor], ok ,I will try to do it. > Incorrect query

[jira] [Commented] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15877651#comment-15877651 ] chenglei commented on PHOENIX-3578: --- [~maryannxue], thank you very much for review , yes , It is true

[jira] [Commented] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15876265#comment-15876265 ] chenglei commented on PHOENIX-3578: --- Actually the test had

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 10:25 AM: - This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 10:22 AM: - This issue is

[jira] [Commented] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875743#comment-15875743 ] chenglei commented on PHOENIX-3578: --- I uploaded my first patch, please help me have a review,thanks.

[jira] [Updated] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3578: -- Attachment: PHOENIX-3578_v1.patch > Incorrect query results when applying inner join and orderby desc

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:59 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:57 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:58 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:56 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:56 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:55 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:47 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:46 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:43 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:43 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:41 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:37 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:35 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:35 AM: This issue is

[jira] [Comment Edited] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei edited comment on PHOENIX-3578 at 2/21/17 9:30 AM: This issue is

[jira] [Commented] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875665#comment-15875665 ] chenglei commented on PHOENIX-3578: --- This issue is caused by the join dynamic filter, from following

[jira] [Updated] (PHOENIX-3670) KeyRange.intersect(List , List) is inefficient,especially for join dynamic filter

[ https://issues.apache.org/jira/browse/PHOENIX-3670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3670: -- Description: In my business system, there is a following join SQL(which is simplified), fact_table

[jira] [Comment Edited] (PHOENIX-3670) KeyRange.intersect(List , List) is inefficient,especially for join dynamic filter

[ https://issues.apache.org/jira/browse/PHOENIX-3670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15865978#comment-15865978 ] chenglei edited comment on PHOENIX-3670 at 2/14/17 3:43 PM: I uploaded my

[jira] [Comment Edited] (PHOENIX-3670) KeyRange.intersect(List , List) is inefficient,especially for join dynamic filter

[ https://issues.apache.org/jira/browse/PHOENIX-3670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15865978#comment-15865978 ] chenglei edited comment on PHOENIX-3670 at 2/14/17 3:44 PM: I uploaded my

[jira] [Commented] (PHOENIX-3670) KeyRange.intersect(List , List) is inefficient,especially for join dynamic filter

[ https://issues.apache.org/jira/browse/PHOENIX-3670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15865978#comment-15865978 ] chenglei commented on PHOENIX-3670: --- I uploaded my first patch, could someone help me review for this

[jira] [Updated] (PHOENIX-3670) KeyRange.intersect(List , List) is inefficient,especially for join dynamic filter

[ https://issues.apache.org/jira/browse/PHOENIX-3670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3670: -- Attachment: PHOENIX-3670_v1.patch > KeyRange.intersect(List , List) is inefficient,especially > for

[jira] [Updated] (PHOENIX-3670) KeyRange.intersect(List , List) is inefficient,especially for join dynamic filter

[ https://issues.apache.org/jira/browse/PHOENIX-3670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3670: -- Description: In my business system, there is a following join SQL(which is simplified), fact_table

[jira] [Updated] (PHOENIX-3670) KeyRange.intersect(List , List) is inefficient,especially for join dynamic filter

[ https://issues.apache.org/jira/browse/PHOENIX-3670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3670: -- Description: In my business system, there is a following join SQL(which is simplified), fact_table

[jira] [Updated] (PHOENIX-3670) KeyRange.intersect(List , List) is inefficient,especially for join dynamic filter

[ https://issues.apache.org/jira/browse/PHOENIX-3670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3670: -- Summary: KeyRange.intersect(List , List) is inefficient,especially for join dynamic filter (was:

[jira] [Created] (PHOENIX-3670) KeyRange.intersect(List , List ) is inefficient,especially for join dynamic filter

chenglei created PHOENIX-3670: - Summary: KeyRange.intersect(List , List ) is inefficient,especially for join dynamic filter Key: PHOENIX-3670 URL: https://issues.apache.org/jira/browse/PHOENIX-3670

[jira] [Commented] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15817695#comment-15817695 ] chenglei commented on PHOENIX-3578: --- It can also be reproduced under 4.9.0, it may be caused by the

[jira] [Comment Edited] (PHOENIX-3491) OrderBy can not be compiled out if GroupBy is not orderPreserving and OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787679#comment-15787679 ] chenglei edited comment on PHOENIX-3491 at 12/30/16 1:36 PM: -

[jira] [Comment Edited] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787647#comment-15787647 ] chenglei edited comment on PHOENIX-3453 at 12/30/16 1:34 PM: - I uploaded my

[jira] [Comment Edited] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787647#comment-15787647 ] chenglei edited comment on PHOENIX-3453 at 12/30/16 1:34 PM: - I uploaded my

[jira] [Commented] (PHOENIX-3491) OrderBy can not be compiled out if GroupBy is not orderPreserving and OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787679#comment-15787679 ] chenglei commented on PHOENIX-3491: --- [~jamestaylor],I noticed this patch was pushed to master branch

[jira] [Comment Edited] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787222#comment-15787222 ] chenglei edited comment on PHOENIX-3453 at 12/30/16 1:27 PM: - I wrote

[jira] [Comment Edited] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787222#comment-15787222 ] chenglei edited comment on PHOENIX-3453 at 12/30/16 1:24 PM: - I wrote

[jira] [Comment Edited] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787222#comment-15787222 ] chenglei edited comment on PHOENIX-3453 at 12/30/16 1:22 PM: - I wrote

[jira] [Commented] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787647#comment-15787647 ] chenglei commented on PHOENIX-3453: --- I uploaded my first patch,[~jamestaylor],please help me have a

[jira] [Updated] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3453: -- Attachment: PHOENIX-3453_v1.patch > Secondary index and query using distinct: Outer query results in

[jira] [Comment Edited] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787222#comment-15787222 ] chenglei edited comment on PHOENIX-3453 at 12/30/16 11:18 AM: -- I wrote

[jira] [Comment Edited] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787222#comment-15787222 ] chenglei edited comment on PHOENIX-3453 at 12/30/16 11:15 AM: -- I wrote

[jira] [Comment Edited] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787222#comment-15787222 ] chenglei edited comment on PHOENIX-3453 at 12/30/16 11:07 AM: -- I wrote

[jira] [Comment Edited] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787222#comment-15787222 ] chenglei edited comment on PHOENIX-3453 at 12/30/16 11:03 AM: -- I wrote

[jira] [Comment Edited] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787222#comment-15787222 ] chenglei edited comment on PHOENIX-3453 at 12/30/16 11:04 AM: -- I wrote

[jira] [Comment Edited] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787222#comment-15787222 ] chenglei edited comment on PHOENIX-3453 at 12/30/16 9:09 AM: - I wrote

[jira] [Commented] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787222#comment-15787222 ] chenglei commented on PHOENIX-3453: --- I wrote following test case to make this problem can be

[jira] [Comment Edited] (PHOENIX-3453) Secondary index and query using distinct: Outer query results in ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters

[ https://issues.apache.org/jira/browse/PHOENIX-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15787222#comment-15787222 ] chenglei edited comment on PHOENIX-3453 at 12/30/16 8:40 AM: - I wrote

[jira] [Comment Edited] (PHOENIX-3491) OrderBy can not be compiled out if GroupBy is not orderPreserving and OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15678453#comment-15678453 ] chenglei edited comment on PHOENIX-3491 at 11/19/16 3:11 AM: -

[jira] [Commented] (PHOENIX-3491) OrderBy can not be compiled out if GroupBy is not orderPreserving and OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15678453#comment-15678453 ] chenglei commented on PHOENIX-3491: --- [~jamestaylor],because I have time difference with you,sorry for

[jira] [Comment Edited] (PHOENIX-3491) OrderBy can not be compiled out if GroupBy is not orderPreserving and OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15676508#comment-15676508 ] chenglei edited comment on PHOENIX-3491 at 11/18/16 1:17 PM: - The OrderBy

[jira] [Comment Edited] (PHOENIX-3491) OrderBy can not be compiled out if GroupBy is not orderPreserving and OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15676508#comment-15676508 ] chenglei edited comment on PHOENIX-3491 at 11/18/16 1:16 PM: - The OrderBy

[jira] [Comment Edited] (PHOENIX-3491) OrderBy can not be compiled out if GroupBy is not orderPreserving and OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15676508#comment-15676508 ] chenglei edited comment on PHOENIX-3491 at 11/18/16 1:15 PM: - The OrderBy

[jira] [Updated] (PHOENIX-3491) OrderBy should be compiled out if GroupBy is not orderPreserving and OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3491: -- Summary: OrderBy should be compiled out if GroupBy is not orderPreserving and OrderBy is reverse

[jira] [Updated] (PHOENIX-3491) OrderBy can not be compiled out if GroupBy is not orderPreserving and OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3491: -- Summary: OrderBy can not be compiled out if GroupBy is not orderPreserving and OrderBy is reverse

[jira] [Comment Edited] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15676508#comment-15676508 ] chenglei edited comment on PHOENIX-3491 at 11/18/16 12:07 PM: -- The OrderBy

[jira] [Commented] (PHOENIX-3451) Incorrect determination of preservation of order for an aggregate query leads to incorrect query results

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15676576#comment-15676576 ] chenglei commented on PHOENIX-3451: --- [~jamestaylor], I filed a JIRA PHOENIX-3491 to remove the

[jira] [Updated] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3491: -- Attachment: (was: PHOENIX-3491_v1.patch) > OrderBy should be compiled out when GroupBy is not

[jira] [Updated] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3491: -- Attachment: PHOENIX-3491_v1.patch > OrderBy should be compiled out when GroupBy is not

[jira] [Updated] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3491: -- Attachment: PHOENIX-3491_v1.patch > OrderBy should be compiled out when GroupBy is not

[jira] [Comment Edited] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15676508#comment-15676508 ] chenglei edited comment on PHOENIX-3491 at 11/18/16 11:54 AM: -- The OrderBy

[jira] [Comment Edited] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15676508#comment-15676508 ] chenglei edited comment on PHOENIX-3491 at 11/18/16 11:24 AM: -- The OrderBy

[jira] [Commented] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15676508#comment-15676508 ] chenglei commented on PHOENIX-3491: --- The OrderBy could not be compiled out because the following code

[jira] [Assigned] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei reassigned PHOENIX-3491: - Assignee: chenglei > OrderBy should be compiled out when GroupBy is not orderPreserving but >

[jira] [Updated] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3491: -- Description: for the following table: {code:borderStyle=solid} CREATE TABLE ORDERBY_TEST

[jira] [Commented] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15672486#comment-15672486 ] chenglei commented on PHOENIX-3491: --- Just from PHOENIX-3451,but is irrelevant to PHOENIX-3451,so open

[jira] [Comment Edited] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15672486#comment-15672486 ] chenglei edited comment on PHOENIX-3491 at 11/17/16 2:51 AM: - Just from

[jira] [Updated] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3491: -- Summary: OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[jira] [Updated] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not orderPreserving but OrderBy is reverse

[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3491: -- Description: for the following table: {code:borderStyle=solid} CREATE TABLE ORDERBY_TEST

[jira] [Created] (PHOENIX-3491) OrderBy should be compiled out when GroupBy is not OrderPreserving but OrderBy is reverse

chenglei created PHOENIX-3491: - Summary: OrderBy should be compiled out when GroupBy is not OrderPreserving but OrderBy is reverse Key: PHOENIX-3491 URL: https://issues.apache.org/jira/browse/PHOENIX-3491

[jira] [Commented] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15670770#comment-15670770 ] chenglei commented on PHOENIX-3451: --- Thank you for feedback ,[~jamestaylor], yes, if those lines are

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15670234#comment-15670234 ] chenglei edited comment on PHOENIX-3451 at 11/16/16 2:49 PM: -

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15670234#comment-15670234 ] chenglei edited comment on PHOENIX-3451 at 11/16/16 2:49 PM: -

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15670234#comment-15670234 ] chenglei edited comment on PHOENIX-3451 at 11/16/16 2:48 PM: -

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15670234#comment-15670234 ] chenglei edited comment on PHOENIX-3451 at 11/16/16 2:46 PM: -

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15670234#comment-15670234 ] chenglei edited comment on PHOENIX-3451 at 11/16/16 2:38 PM: -

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15670234#comment-15670234 ] chenglei edited comment on PHOENIX-3451 at 11/16/16 11:44 AM: --

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15670234#comment-15670234 ] chenglei edited comment on PHOENIX-3451 at 11/16/16 11:41 AM: --

[jira] [Commented] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15670234#comment-15670234 ] chenglei commented on PHOENIX-3451: --- [~jamestaylor]，I have a problem with your patch: why did you

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15669252#comment-15669252 ] chenglei edited comment on PHOENIX-3451 at 11/16/16 3:39 AM: -

[jira] [Commented] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15669252#comment-15669252 ] chenglei commented on PHOENIX-3451: --- [~jamestaylor], thank your explanation, I had just make a new

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15667149#comment-15667149 ] chenglei edited comment on PHOENIX-3451 at 11/15/16 4:16 PM: -

[jira] [Updated] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3451: -- Attachment: (was: PHOENIX-3451.diff) > Secondary index and query using distinct: LIMIT doesn't

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15667149#comment-15667149 ] chenglei edited comment on PHOENIX-3451 at 11/15/16 1:37 PM: - @James Taylor,

[jira] [Commented] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15667149#comment-15667149 ] chenglei commented on PHOENIX-3451: --- @James Taylor, thank you for your suggestion, my patch indeed is

[jira] [Issue Comment Deleted] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3451: -- Comment: was deleted (was: [~jamestaylor].thank your for your suggestion, my considerations are as

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15666402#comment-15666402 ] chenglei edited comment on PHOENIX-3451 at 11/15/16 8:02 AM: -

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15666402#comment-15666402 ] chenglei edited comment on PHOENIX-3451 at 11/15/16 8:01 AM: -

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15666402#comment-15666402 ] chenglei edited comment on PHOENIX-3451 at 11/15/16 7:42 AM: -

[jira] [Commented] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15666402#comment-15666402 ] chenglei commented on PHOENIX-3451: --- [~jamestaylor].thank your for your suggestion, my considerations

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15665874#comment-15665874 ] chenglei edited comment on PHOENIX-3451 at 11/15/16 3:30 AM: -

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15665874#comment-15665874 ] chenglei edited comment on PHOENIX-3451 at 11/15/16 3:26 AM: -

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15665874#comment-15665874 ] chenglei edited comment on PHOENIX-3451 at 11/15/16 3:25 AM: -

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15665874#comment-15665874 ] chenglei edited comment on PHOENIX-3451 at 11/15/16 3:25 AM: -

[jira] [Comment Edited] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15665874#comment-15665874 ] chenglei edited comment on PHOENIX-3451 at 11/15/16 3:24 AM: -

<    1   2   3   4   5   6   7   8   9   10   >