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

2017-02-14 Thread chenglei (JIRA)
[ 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

2017-02-14 Thread chenglei (JIRA)
[ 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

2017-02-14 Thread chenglei (JIRA)
[ 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] [Updated] (PHOENIX-3670) KeyRange.intersect(List , List) is inefficient,especially for join dynamic filter

2017-02-14 Thread chenglei (JIRA)
[ 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] [Commented] (PHOENIX-3705) SkipScanFilter may repeatedly copy rowKey Columns to startKey

2017-03-01 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15891484#comment-15891484 ] chenglei commented on PHOENIX-3705: --- Thanks for review, [~jamestaylor],I will add more tests and

[jira] [Created] (PHOENIX-3705) SkipScanFilter may repeatedly copy rowKey Columns to startKey

2017-03-01 Thread chenglei (JIRA)
chenglei created PHOENIX-3705: - Summary: SkipScanFilter may repeatedly copy rowKey Columns to startKey Key: PHOENIX-3705 URL: https://issues.apache.org/jira/browse/PHOENIX-3705 Project: Phoenix

[jira] [Updated] (PHOENIX-3705) SkipScanFilter may repeatedly copy rowKey Columns to startKey

2017-03-01 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3705: -- Description: See following simple unit test first,the rowKey is composed of three PInteger

[jira] [Updated] (PHOENIX-3705) SkipScanFilter may repeatedly copy rowKey Columns to startKey

2017-03-01 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3705: -- Description: See following simple unit test first,the rowKey is composed of three PInteger

[jira] [Updated] (PHOENIX-3705) SkipScanFilter may repeatedly copy rowKey Columns to startKey

2017-03-01 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3705: -- Description: See following simple unit test first,the rowKey is composed of three PInteger

[jira] [Updated] (PHOENIX-3705) SkipScanFilter may repeatedly copy rowKey Columns to startKey

2017-03-01 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3705: -- Description: See following simple unit test first,the rowKey is composed of three PInteger

[jira] [Updated] (PHOENIX-3705) SkipScanFilter may repeatedly copy rowKey Columns to startKey

2017-03-01 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3705: -- Attachment: PHOENIX-3705_v1.patch > SkipScanFilter may repeatedly copy rowKey Columns to startKey >

[jira] [Commented] (PHOENIX-3705) SkipScanFilter may repeatedly copy rowKey Columns to startKey

2017-03-01 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15889941#comment-15889941 ] chenglei commented on PHOENIX-3705: --- I uploaded my first patch, please help me have a review. >

[jira] [Updated] (PHOENIX-3705) SkipScanFilter may repeatedly copy rowKey Columns to startKey

2017-03-01 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3705: -- Description: See following simple unit test first,the rowKey is composed of three PInteger

[jira] [Updated] (PHOENIX-3705) SkipScanFilter may repeatedly copy rowKey Columns to startKey

2017-03-01 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3705: -- Description: See following simple unit test first,the rowKey is composed of three PInteger

[jira] [Updated] (PHOENIX-3705) SkipScanFilter may repeatedly copy rowKey Columns to startKey

2017-03-01 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3705: -- Description: See following simple unit test first,the rowKey is composed of three PInteger

[jira] [Created] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-23 Thread chenglei (JIRA)
chenglei created PHOENIX-3199: - Summary: ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region Key: PHOENIX-3199 URL:

[jira] [Updated] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-23 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3199: -- Description: In the addServerCache method of org.apache.phoenix.cache.ServerCacheClient class,

[jira] [Updated] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-23 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3199: -- Description: In the addServerCache method of org.apache.phoenix.cache.ServerCacheClient class,

[jira] [Commented] (PHOENIX-2900) Unable to find hash cache once a salted table 's first region has split

2016-08-24 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2900?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15434489#comment-15434489 ] chenglei commented on PHOENIX-2900: --- I create a new issue

[jira] [Updated] (PHOENIX-3208) MutationState.toMutations method would throw a exception if multiple tables are upserted

2016-08-25 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3208: -- Attachment: PHOENIX-3208.patch > MutationState.toMutations method would throw a exception if multiple

[jira] [Created] (PHOENIX-3208) MutationState.toMutations method would throw a exception if multiple tables are upserted

2016-08-25 Thread chenglei (JIRA)
chenglei created PHOENIX-3208: - Summary: MutationState.toMutations method would throw a exception if multiple tables are upserted Key: PHOENIX-3208 URL: https://issues.apache.org/jira/browse/PHOENIX-3208

[jira] [Updated] (PHOENIX-3208) MutationState.toMutations method would throw a exception if multiple tables are upserted

2016-08-25 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3208: -- Description: MutationState.toMutations method is to return the current uncommitted table's

[jira] [Updated] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-23 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3199: -- Attachment: PHOENIX-3199.patch > ServerCacheClient would send cache to all regions unnecessarily once

[jira] [Updated] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-24 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3199: -- Attachment: (was: PHOENIX-3199.patch) > ServerCacheClient would send cache to all regions

[jira] [Updated] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-24 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3199: -- Attachment: PHOENIX-3199_v1.patch > ServerCacheClient would send cache to all regions unnecessarily

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649650#comment-15649650 ] chenglei edited comment on PHOENIX-3451 at 11/9/16 3:19 AM: I think the

[jira] [Commented] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649794#comment-15649794 ] chenglei commented on PHOENIX-3452: --- I think the problem is cause by the GroupByCompiler, when

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649807#comment-15649807 ] chenglei commented on PHOENIX-3451: --- It seems PHOENIX-3451 is ok in Phoenix4.8.0, I fixed the

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

2016-11-08 Thread chenglei (JIRA)
[ 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: It seems PHOENIX-3451 is ok in Phoenix4.8.0, I wrote the IT Test as

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649826#comment-15649826 ] chenglei edited comment on PHOENIX-3451 at 11/9/16 5:06 AM: I wrote the IT

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649826#comment-15649826 ] chenglei edited comment on PHOENIX-3451 at 11/9/16 5:06 AM: I wrote the IT

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

2016-11-08 Thread chenglei (JIRA)
[ 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: I wrote the IT Test as [~jpalmert] described, but It seems in 4.8.0 the

[jira] [Commented] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649922#comment-15649922 ] chenglei commented on PHOENIX-3452: --- [~jamestaylor],ok ,I will add more tests. > Secondary index and

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649650#comment-15649650 ] chenglei edited comment on PHOENIX-3451 at 11/9/16 3:58 AM: I think the

[jira] [Updated] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3452: -- Attachment: PHOENIX-3452_v1.patch > Secondary index and query using distinct: ORDER BY doesn't work

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

2016-11-08 Thread chenglei (JIRA)
[ 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: I think the problem is cause by the GroupByCompiler, when GroupBy.compile

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649886#comment-15649886 ] chenglei commented on PHOENIX-3451: --- If I remove the "MULTI_TENANT=TRUE" in the create table DDL as

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649886#comment-15649886 ] chenglei edited comment on PHOENIX-3451 at 11/9/16 5:45 AM: If I remove the

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

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

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

2016-11-08 Thread chenglei (JIRA)
[ 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_v1.patch) > Secondary index and query using distinct: LIMIT

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649826#comment-15649826 ] chenglei commented on PHOENIX-3451: --- I wrote the IT Test as [~jpalmert], but It seems in 4.8.0 the

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649650#comment-15649650 ] chenglei edited comment on PHOENIX-3451 at 11/9/16 3:10 AM: I think the

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649650#comment-15649650 ] chenglei commented on PHOENIX-3451: --- I think he problem is cause by the GroupByCompiler, when

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649650#comment-15649650 ] chenglei edited comment on PHOENIX-3451 at 11/9/16 3:10 AM: I think the

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649650#comment-15649650 ] chenglei edited comment on PHOENIX-3451 at 11/9/16 3:20 AM: I think the

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649650#comment-15649650 ] chenglei edited comment on PHOENIX-3451 at 11/9/16 3:53 AM: I think the

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

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649807#comment-15649807 ] chenglei edited comment on PHOENIX-3451 at 11/9/16 4:52 AM: It seems

[jira] [Commented] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15650093#comment-15650093 ] chenglei commented on PHOENIX-3452: --- [~jamestaylor], I updated my patch,enhanced my test cases

[jira] [Commented] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15650438#comment-15650438 ] chenglei commented on PHOENIX-3452: --- Ok,I will try some IT tests > Secondary index and query using

[jira] [Comment Edited] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15650438#comment-15650438 ] chenglei edited comment on PHOENIX-3452 at 11/9/16 2:46 PM:

[jira] [Comment Edited] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15650438#comment-15650438 ] chenglei edited comment on PHOENIX-3452 at 11/9/16 2:52 PM:

[jira] [Comment Edited] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15650438#comment-15650438 ] chenglei edited comment on PHOENIX-3452 at 11/9/16 2:32 PM: Ok,I will try

[jira] [Comment Edited] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15650438#comment-15650438 ] chenglei edited comment on PHOENIX-3452 at 11/9/16 2:55 PM:

[jira] [Comment Edited] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15650438#comment-15650438 ] chenglei edited comment on PHOENIX-3452 at 11/9/16 2:47 PM:

[jira] [Comment Edited] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15650438#comment-15650438 ] chenglei edited comment on PHOENIX-3452 at 11/9/16 2:45 PM:

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Attachment: (was: PHOENIX-3469_v1.patch) > Once a column in primary key or index is DESC, the

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Attachment: PHOENIX-3469_v1.patch > Once a column in primary key or index is DESC, the corresponding

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Attachment: PHOENIX-3469_v1.patch > Once a column in primary key or index is DESC, the corresponding

[jira] [Comment Edited] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15653112#comment-15653112 ] chenglei edited comment on PHOENIX-3452 at 11/10/16 7:29 AM: -

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Description: This problem can be reproduced as following: {code:borderStyle=solid} CREATE

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Description: This problem can be reproduced as following: {code:borderStyle=solid} CREATE

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Description: This problem can be reproduced as following: {code:borderStyle=solid} CREATE

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Description: This problem can be reproduced as following: {code:borderStyle=solid} CREATE

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Description: This problem can be reproduced as following: {code:borderStyle=solid} CREATE

[jira] [Created] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
chenglei created PHOENIX-3469: - Summary: Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly Key: PHOENIX-3469 URL:

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Description: This problem can be reproduced as following: {code:borderStyle=solid} CREATE

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Description: This problem can be reproduced as following: {code:borderStyle=solid} CREATE

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Description: This problem can be reproduced as following: {code:borderStyle=solid} CREATE

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Description: This problem can be reproduced as following: {code:borderStyle=solid} CREATE

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Description: This problem can be reproduced as following: {code:borderStyle=solid} CREATE

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Description: This problem can be reproduced as following: {code:borderStyle=solid} CREATE

[jira] [Commented] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-09 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15653112#comment-15653112 ] chenglei commented on PHOENIX-3452: --- [~jamestaylor], when I wrote my IT tests,I found another new

[jira] [Updated] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3452: -- Attachment: PHOENIX-3452_v2.patch > Secondary index and query using distinct: ORDER BY doesn't work

[jira] [Updated] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-08 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3452: -- Attachment: (was: PHOENIX-3452_v1.patch) > Secondary index and query using distinct: ORDER BY

[jira] [Commented] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-10 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655768#comment-15655768 ] chenglei commented on PHOENIX-3469: --- Yes, [~jamestaylor],existing tests indeed all pass with my patch

[jira] [Comment Edited] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-10 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655768#comment-15655768 ] chenglei edited comment on PHOENIX-3469 at 11/11/16 1:39 AM: - Yes,

[jira] [Commented] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-10 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655790#comment-15655790 ] chenglei commented on PHOENIX-3452: --- ok, [~jamestaylor],I will add tests soon. > Secondary index and

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

2016-11-11 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15656799#comment-15656799 ] chenglei commented on PHOENIX-3451: --- In order to remove the effect of MULTI_TENANT, I create a new

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

2016-11-11 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15656799#comment-15656799 ] chenglei edited comment on PHOENIX-3451 at 11/11/16 11:14 AM: --

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-11 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Attachment: (was: PHOENIX-3469_v1.patch) > Once a column in primary key or index is DESC, the

[jira] [Updated] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-11 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3469: -- Attachment: PHOENIX-3469_v2.patch > Once a column in primary key or index is DESC, the corresponding

[jira] [Commented] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-11 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15656833#comment-15656833 ] chenglei commented on PHOENIX-3469: --- [~jamestaylor], I uploaded my new patch, enhanced IT tests and

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

2016-11-11 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15656799#comment-15656799 ] chenglei edited comment on PHOENIX-3451 at 11/11/16 1:14 PM: -

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

2016-11-11 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15656799#comment-15656799 ] chenglei edited comment on PHOENIX-3451 at 11/11/16 1:14 PM: -

[jira] [Comment Edited] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-11 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15656833#comment-15656833 ] chenglei edited comment on PHOENIX-3469 at 11/11/16 1:25 PM: -

[jira] [Comment Edited] (PHOENIX-3469) Once a column in primary key or index is DESC, the corresponding order by NULLS LAST/NULLS FIRST may work incorrectly

2016-11-11 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15656833#comment-15656833 ] chenglei edited comment on PHOENIX-3469 at 11/11/16 1:24 PM: -

[jira] [Comment Edited] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-10 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649794#comment-15649794 ] chenglei edited comment on PHOENIX-3452 at 11/10/16 8:36 AM: - I think the

[jira] [Comment Edited] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-10 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649794#comment-15649794 ] chenglei edited comment on PHOENIX-3452 at 11/10/16 8:37 AM: - I think the

[jira] [Comment Edited] (PHOENIX-3452) Secondary index and query using distinct: ORDER BY doesn't work correctly

2016-11-10 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649794#comment-15649794 ] chenglei edited comment on PHOENIX-3452 at 11/10/16 8:43 AM: - I think the

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

2016-11-14 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15664118#comment-15664118 ] chenglei edited comment on PHOENIX-3451 at 11/14/16 3:01 PM: - This bug is

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

2016-11-14 Thread chenglei (JIRA)
[ 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

2016-11-14 Thread chenglei (JIRA)
[ 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

2016-11-14 Thread chenglei (JIRA)
[ 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

2016-11-14 Thread chenglei (JIRA)
[ 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] [Commented] (PHOENIX-3451) Secondary index and query using distinct: LIMIT doesn't return the first rows

2016-11-14 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15665874#comment-15665874 ] chenglei commented on PHOENIX-3451: --- [~jamestaylor], It seems you did not look at my uploaded

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

2016-11-14 Thread chenglei (JIRA)
[ 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: -

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

2016-11-14 Thread chenglei (JIRA)
[ 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:17 AM: -

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

2016-11-14 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15664118#comment-15664118 ] chenglei commented on PHOENIX-3451: --- This bug is caused by the OrderByCompiler,my analysis of this bug

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

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

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

2016-11-14 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15664118#comment-15664118 ] chenglei edited comment on PHOENIX-3451 at 11/14/16 3:00 PM: - This bug is

<    1   2   3   4   5   6   7   8   9   >