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

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

2016-11-18 Thread chenglei (JIRA)
[ 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] [Commented] (PHOENIX-3491) OrderBy can not be compiled out if GroupBy is not orderPreserving and OrderBy is reverse

2016-11-18 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15678332#comment-15678332 ] Hudson commented on PHOENIX-3491: - SUCCESS: Integrated in Jenkins build Phoenix-master #1507 (See

[jira] [Commented] (PHOENIX-3501) Push limit to server for distinct optimization

2016-11-18 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15678331#comment-15678331 ] Hudson commented on PHOENIX-3501: - SUCCESS: Integrated in Jenkins build Phoenix-master #1507 (See

[VOTE] Release of Apache Phoenix 4.9.0 RC5

2016-11-18 Thread James Taylor
Hello Everyone, This is a call for a vote on Apache Phoenix 4.9.0 RC5. This is the next minor release of Phoenix 4, compatible with Apache HBase 0.98, 1.1 & 1.2. The release includes both a source-only release and a convenience binary release for each supported HBase version. The previous RC was

Re: [jira] [Updated] (PHOENIX-3501) Push limit to server for distinct optimization

2016-11-18 Thread Samarth Jain
+1 On Fri, Nov 18, 2016 at 3:20 PM James Taylor (JIRA) wrote: > > [ > https://issues.apache.org/jira/browse/PHOENIX-3501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel > ] > > James Taylor updated PHOENIX-3501: > -- >

[jira] [Updated] (PHOENIX-3501) Push limit to server for distinct optimization

2016-11-18 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3501: -- Attachment: PHOENIX-3501.patch Please review, [~samarthjain]. > Push limit to server for

[jira] [Created] (PHOENIX-3501) Push limit to server for distinct optimization

2016-11-18 Thread James Taylor (JIRA)
James Taylor created PHOENIX-3501: - Summary: Push limit to server for distinct optimization Key: PHOENIX-3501 URL: https://issues.apache.org/jira/browse/PHOENIX-3501 Project: Phoenix Issue

[jira] [Commented] (PHOENIX-3484) Major compaction does not update statistics based on table specific GUIDE_POSTS_WIDTH

2016-11-18 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15678017#comment-15678017 ] Hudson commented on PHOENIX-3484: - SUCCESS: Integrated in Jenkins build Phoenix-master #1506 (See

Phoenix upgrade 4.6.1 to 4.8.1

2016-11-18 Thread Gangadari, Venkatesham
Hi, We are upgrading apache phoenix from 4.6.1 to 4.8.1. While connection is getting initialized, it's trying to upgrader system tables with missing columns related to 4.7 and 4.8. While altering SYSTEM.CATALOG to add the columns related to 4.7 and 4.8 we are facing the following issues. 1.

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

2016-11-18 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3491: -- Attachment: PHOENIX-3491_v2.patch > OrderBy can not be compiled out if GroupBy is not

[jira] [Resolved] (PHOENIX-3484) Major compaction does not update statistics based on table specific GUIDE_POSTS_WIDTH

2016-11-18 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-3484. --- Resolution: Fixed > Major compaction does not update statistics based on table specific >

[jira] [Commented] (PHOENIX-3484) Major compaction does not update statistics based on table specific GUIDE_POSTS_WIDTH

2016-11-18 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677786#comment-15677786 ] James Taylor commented on PHOENIX-3484: --- FYI - a little explanation. For the case of major

[jira] [Commented] (PHOENIX-3484) Major compaction does not update statistics based on table specific GUIDE_POSTS_WIDTH

2016-11-18 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677768#comment-15677768 ] Samarth Jain commented on PHOENIX-3484: --- +1, looks good. > Major compaction does not update

[jira] [Commented] (PHOENIX-3498) Query with index failed when query back to data table with desc PK column

2016-11-18 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3498?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677742#comment-15677742 ] Hudson commented on PHOENIX-3498: - SUCCESS: Integrated in Jenkins build Phoenix-master #1505 (See

[jira] [Updated] (PHOENIX-3484) Major compaction does not update statistics based on table specific GUIDE_POSTS_WIDTH

2016-11-18 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3484: -- Attachment: PHOENIX-3484.patch Please review, [~samarthjain]. > Major compaction does not

[jira] [Updated] (PHOENIX-3484) Major compaction does not update statistics based on table specific GUIDE_POSTS_WIDTH

2016-11-18 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3484: -- Fix Version/s: 4.9.0 > Major compaction does not update statistics based on table specific >

[jira] [Resolved] (PHOENIX-3498) Query with index failed when query back to data table with desc PK column

2016-11-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue resolved PHOENIX-3498. -- Resolution: Fixed > Query with index failed when query back to data table with desc PK column

[jira] [Commented] (PHOENIX-3497) Provide a work around for HBASE-17122

2016-11-18 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677413#comment-15677413 ] Hudson commented on PHOENIX-3497: - SUCCESS: Integrated in Jenkins build Phoenix-4.8-HBase-1.2 #64 (See

[jira] [Comment Edited] (PHOENIX-3498) Query with index failed when query back to data table with desc PK column

2016-11-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3498?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677392#comment-15677392 ] Maryann Xue edited comment on PHOENIX-3498 at 11/18/16 6:36 PM: +1 to

[jira] [Commented] (PHOENIX-3498) Query with index failed when query back to data table with desc PK column

2016-11-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3498?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677392#comment-15677392 ] Maryann Xue commented on PHOENIX-3498: -- +1 to the patch. Thank you very much for fixing this issue,

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

2016-11-18 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677357#comment-15677357 ] James Taylor commented on PHOENIX-3491: --- Really excellent work, [~comnetwork]. The tests are very

[jira] [Comment Edited] (PHOENIX-3497) Provide a work around for HBASE-17122

2016-11-18 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677317#comment-15677317 ] Samarth Jain edited comment on PHOENIX-3497 at 11/18/16 6:09 PM: - Filed

[jira] [Commented] (PHOENIX-3497) Provide a work around for HBASE-17122

2016-11-18 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677317#comment-15677317 ] Samarth Jain commented on PHOENIX-3497: --- Filed PHOENIX-3550 to address the flapper. > Provide a

[jira] [Created] (PHOENIX-3500) Fix flapping MutableIndexFailureIT

2016-11-18 Thread Samarth Jain (JIRA)
Samarth Jain created PHOENIX-3500: - Summary: Fix flapping MutableIndexFailureIT Key: PHOENIX-3500 URL: https://issues.apache.org/jira/browse/PHOENIX-3500 Project: Phoenix Issue Type: Bug

[jira] [Commented] (PHOENIX-3497) Provide a work around for HBASE-17122

2016-11-18 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677281#comment-15677281 ] James Taylor commented on PHOENIX-3497: --- Failing due to NamespaceNotFoundException:

[jira] [Commented] (PHOENIX-3497) Provide a work around for HBASE-17122

2016-11-18 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677215#comment-15677215 ] Hudson commented on PHOENIX-3497: - FAILURE: Integrated in Jenkins build Phoenix-master #1504 (See

[jira] [Commented] (PHOENIX-3495) Ignore NamespaceExistException when namespace mapping enabled

2016-11-18 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677081#comment-15677081 ] Ankit Singhal commented on PHOENIX-3495: Actually, the problem is that when CSVBulkLoadTool run

[jira] [Commented] (PHOENIX-3495) Ignore NamespaceExistException when namespace mapping enabled

2016-11-18 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677030#comment-15677030 ] Samarth Jain commented on PHOENIX-3495: --- I haven't committed the v2 patch yet. > Ignore

[jira] [Updated] (PHOENIX-3495) Ignore NamespaceExistException when namespace mapping enabled

2016-11-18 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-3495: -- Fix Version/s: (was: 4.8.2) (was: 4.9.0) > Ignore

[jira] [Commented] (PHOENIX-3495) Ignore NamespaceExistException when namespace mapping enabled

2016-11-18 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677014#comment-15677014 ] James Taylor commented on PHOENIX-3495: --- Thanks for the follow up, [~an...@apache.org]. Should

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

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

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

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

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

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

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

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

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

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

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

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

2016-11-18 Thread chenglei (JIRA)
[ 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] [Updated] (PHOENIX-3499) Enable null value for quote character for CSVBulkLoad tool

2016-11-18 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov updated PHOENIX-3499: - Attachment: PHOENIX-3499-1.patch Added support for null values for escape and quote

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

2016-11-18 Thread chenglei (JIRA)
[ 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] [Updated] (PHOENIX-3499) Enable null value for quote character for CSVBulkLoad tool

2016-11-18 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov updated PHOENIX-3499: - Summary: Enable null value for quote character for CSVBulkLoad tool (was: Enable null

[jira] [Updated] (PHOENIX-3499) Enable null value for quote character for CSVBulkLoad tool

2016-11-18 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov updated PHOENIX-3499: - Description: It's quite often that CSV data contains '"' character as part of the user

[jira] [Created] (PHOENIX-3499) Enable null value for escape character for CSVBulkLoad tool

2016-11-18 Thread Sergey Soldatov (JIRA)
Sergey Soldatov created PHOENIX-3499: Summary: Enable null value for escape character for CSVBulkLoad tool Key: PHOENIX-3499 URL: https://issues.apache.org/jira/browse/PHOENIX-3499 Project:

[jira] [Commented] (PHOENIX-3497) Provide a work around for HBASE-17122

2016-11-18 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15676415#comment-15676415 ] Hudson commented on PHOENIX-3497: - FAILURE: Integrated in Jenkins build Phoenix-4.8-HBase-1.2 #63 (See

[jira] [Commented] (PHOENIX-3495) Ignore NamespaceExistException when namespace mapping enabled

2016-11-18 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15676394#comment-15676394 ] Ankit Singhal commented on PHOENIX-3495: Yep, patch will certainly avoid race condition but I

[jira] [Commented] (PHOENIX-3497) Provide a work around for HBASE-17122

2016-11-18 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15676322#comment-15676322 ] Hudson commented on PHOENIX-3497: - FAILURE: Integrated in Jenkins build Phoenix-master #1503 (See