[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread twdsilva
Github user twdsilva commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206411967 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java --- @@ -3604,6 +3681,18 @@ public MutationState addColumn(PTable table,

[jira] [Updated] (PHOENIX-4822) The configuration "phoenix.query.dateFormatTimeZone" does't work on the client

2018-07-31 Thread Jaanai Zhang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jaanai Zhang updated PHOENIX-4822: -- Attachment: PHOENIX-4822_master.patch > The configuration "phoenix.query.dateFormatTimeZone"

[jira] [Updated] (PHOENIX-4822) The configuration "phoenix.query.dateFormatTimeZone" does't work on the client

2018-07-31 Thread Jaanai Zhang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jaanai Zhang updated PHOENIX-4822: -- Attachment: PHOENIX-4822_5.x-HBase-2.0.patch > The configuration

[GitHub] phoenix issue #318: Fixed Spelling.

2018-07-31 Thread jimmycasey
Github user jimmycasey commented on the issue: https://github.com/apache/phoenix/pull/318 Done: https://issues.apache.org/jira/browse/PHOENIX-4829 ---

[jira] [Created] (PHOENIX-4829) Fixed Spelling

2018-07-31 Thread Jimmy Casey (JIRA)
Jimmy Casey created PHOENIX-4829: Summary: Fixed Spelling Key: PHOENIX-4829 URL: https://issues.apache.org/jira/browse/PHOENIX-4829 Project: Phoenix Issue Type: Improvement

[jira] [Updated] (PHOENIX-4822) The configuration "phoenix.query.dateFormatTimeZone" does't work on the client

2018-07-31 Thread Jaanai Zhang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jaanai Zhang updated PHOENIX-4822: -- Attachment: PHOENIX-4822_master.patch PHOENIX-4822_4.14.0-HBase-1.4.patch >

[jira] [Updated] (PHOENIX-4822) The configuration "phoenix.query.dateFormatTimeZone" does't work on the client

2018-07-31 Thread Jaanai Zhang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jaanai Zhang updated PHOENIX-4822: -- Attachment: (was: PHOENIX-4822_master.patch) > The configuration

[GitHub] phoenix pull request #321: PHOENIX-4820 V3

2018-07-31 Thread comnetwork
GitHub user comnetwork opened a pull request: https://github.com/apache/phoenix/pull/321 PHOENIX-4820 V3 This patch is mainly for : 1. remove CoerceExpression in ExpressionUtil.IsColumnConstantExpressionVisitor, conside following sql: select a.av1 from

[jira] [Updated] (PHOENIX-4820) Optimize OrderBy for ClientAggregatePlan

2018-07-31 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-4820: -- Attachment: PHOENIX-4820-4.x-HBase-1.4-v2.patch > Optimize OrderBy for ClientAggregatePlan >

[GitHub] phoenix pull request #315: PHOENIX-3655 Global Phoenix Client Metrics for PQ...

2018-07-31 Thread joshelser
Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/315#discussion_r206598832 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/monitoring/GlobalPhoenixMetricsTestSink.java --- @@ -0,0 +1,57 @@ +/* + * Licensed to the

[GitHub] phoenix pull request #315: PHOENIX-3655 Global Phoenix Client Metrics for PQ...

2018-07-31 Thread joshelser
Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/315#discussion_r206595985 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/monitoring/PhoenixMetricsIT.java --- @@ -204,6 +230,45 @@ private static void resetGlobalMetrics()

[GitHub] phoenix pull request #315: PHOENIX-3655 Global Phoenix Client Metrics for PQ...

2018-07-31 Thread joshelser
Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/315#discussion_r206598160 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/monitoring/GlobalMetricRegistriesAdapter.java --- @@ -0,0 +1,167 @@ +/* + * Licensed to

[GitHub] phoenix pull request #315: PHOENIX-3655 Global Phoenix Client Metrics for PQ...

2018-07-31 Thread joshelser
Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/315#discussion_r206597366 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/monitoring/PhoenixMetricsIT.java --- @@ -204,6 +230,45 @@ private static void resetGlobalMetrics()

[GitHub] phoenix pull request #315: PHOENIX-3655 Global Phoenix Client Metrics for PQ...

2018-07-31 Thread joshelser
Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/315#discussion_r206598366 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/monitoring/GlobalMetricRegistriesAdapter.java --- @@ -0,0 +1,167 @@ +/* + * Licensed to

[GitHub] phoenix pull request #315: PHOENIX-3655 Global Phoenix Client Metrics for PQ...

2018-07-31 Thread joshelser
Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/315#discussion_r206598488 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/monitoring/PhoenixMetricsIT.java --- @@ -204,6 +230,45 @@ private static void resetGlobalMetrics()

[GitHub] phoenix pull request #315: PHOENIX-3655 Global Phoenix Client Metrics for PQ...

2018-07-31 Thread karanmehta93
Github user karanmehta93 commented on a diff in the pull request: https://github.com/apache/phoenix/pull/315#discussion_r206616222 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/monitoring/GlobalMetricRegistriesAdapter.java --- @@ -0,0 +1,167 @@ +/* + * Licensed

[GitHub] phoenix issue #315: PHOENIX-3655 Global Phoenix Client Metrics for PQS

2018-07-31 Thread karanmehta93
Github user karanmehta93 commented on the issue: https://github.com/apache/phoenix/pull/315 @joshelser I was trying out this patch with an internal PQS version. All these metrics are pushed to JMX and we monitor those via OpenTSDB tcollectors. I haven't done any perf-test here, but I

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

2018-07-31 Thread Gerald Sangudi (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gerald Sangudi updated PHOENIX-4751: Attachment: 0001-PHOENIX-4751-Implement-client-side-has.4.x-HBase-1.4.patch > Support

[GitHub] phoenix issue #315: PHOENIX-3655 Global Phoenix Client Metrics for PQS

2018-07-31 Thread joshelser
Github user joshelser commented on the issue: https://github.com/apache/phoenix/pull/315 > All these metrics are pushed to JMX and we monitor those via OpenTSDB tcollectors. Cool! I was just looking for a sanity check that you are seeing all of the metrics you expect coming

[GitHub] phoenix pull request #315: PHOENIX-3655 Global Phoenix Client Metrics for PQ...

2018-07-31 Thread joshelser
Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/315#discussion_r206638567 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/monitoring/GlobalMetricRegistriesAdapter.java --- @@ -0,0 +1,167 @@ +/* + * Licensed to

[GitHub] phoenix issue #298: PHOENIX-4666 Persistent subquery cache for hash joins

2018-07-31 Thread JamesRTaylor
Github user JamesRTaylor commented on the issue: https://github.com/apache/phoenix/pull/298 Looks really good to me. Nice work, @ortutay! Any further comments, @maryannxue? ---

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread twdsilva
Github user twdsilva commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206687510 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/BasePermissionsIT.java --- @@ -16,8 +16,29 @@ */ package

[GitHub] phoenix issue #298: PHOENIX-4666 Persistent subquery cache for hash joins

2018-07-31 Thread ortutay
persistent cache key, and thus is a way to force cache invalidation. You can do it on a daily basis, eg. 20180731=20180731, and this can also be used to pre-warm caches for upcoming days as well. I'm planning to make a blog post explaining SQ cache + how to rotate nonces once this change has been merged. ---

[GitHub] phoenix issue #313: PHOENIX-4799 Write cells using checkAndMutate to prevent...

2018-07-31 Thread twdsilva
Github user twdsilva commented on the issue: https://github.com/apache/phoenix/pull/313 @karanmehta93 or @ankitsinghal Can you please review the updated PR, thanks! ---

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread twdsilva
Github user twdsilva commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206688033 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/BasePermissionsIT.java --- @@ -82,6 +82,10 @@ static final String

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread twdsilva
Github user twdsilva commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206687937 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java --- @@ -2957,6 +3010,11 @@ MutationState dropTable(String schemaName,

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread twdsilva
Github user twdsilva commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206687568 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java --- @@ -1913,6 +1940,21 @@ private PTable

[GitHub] phoenix pull request #317: PHOENIX-3547 Supporting more number of indices pe...

2018-07-31 Thread m2je
Github user m2je commented on a diff in the pull request: https://github.com/apache/phoenix/pull/317#discussion_r206717705 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/index/IndexMaintainer.java --- @@ -1223,7 +1225,9 @@ public void readFields(DataInput input) throws

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread twdsilva
Github user twdsilva commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206737372 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java --- @@ -2723,13 +2712,10 @@ private void

[jira] [Created] (PHOENIX-4831) Move calls to SYSTEM.MUTEX on server

2018-07-31 Thread Ankit Singhal (JIRA)
Ankit Singhal created PHOENIX-4831: -- Summary: Move calls to SYSTEM.MUTEX on server Key: PHOENIX-4831 URL: https://issues.apache.org/jira/browse/PHOENIX-4831 Project: Phoenix Issue Type:

[GitHub] phoenix pull request #317: PHOENIX-3547 Supporting more number of indices pe...

2018-07-31 Thread m2je
Github user m2je commented on a diff in the pull request: https://github.com/apache/phoenix/pull/317#discussion_r206715551 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/iterate/ExplainTable.java --- @@ -204,14 +205,19 @@ private void appendPKColumnValue(StringBuilder

[GitHub] phoenix pull request #317: PHOENIX-3547 Supporting more number of indices pe...

2018-07-31 Thread m2je
Github user m2je commented on a diff in the pull request: https://github.com/apache/phoenix/pull/317#discussion_r206715609 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java --- @@ -1431,11 +1438,42 @@ private PTable

[GitHub] phoenix pull request #320: PHOENIX-4820

2018-07-31 Thread JamesRTaylor
Github user JamesRTaylor commented on a diff in the pull request: https://github.com/apache/phoenix/pull/320#discussion_r206715618 --- Diff: phoenix-core/src/test/java/org/apache/phoenix/compile/QueryCompilerTest.java --- @@ -2951,7 +2951,129 @@ public void

[GitHub] phoenix pull request #317: PHOENIX-3547 Supporting more number of indices pe...

2018-07-31 Thread m2je
Github user m2je commented on a diff in the pull request: https://github.com/apache/phoenix/pull/317#discussion_r206715585 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java --- @@ -2185,7 +2223,7 @@ public void createTable(RpcController

[GitHub] phoenix pull request #320: PHOENIX-4820

2018-07-31 Thread comnetwork
Github user comnetwork commented on a diff in the pull request: https://github.com/apache/phoenix/pull/320#discussion_r206739045 --- Diff: phoenix-core/src/test/java/org/apache/phoenix/compile/QueryCompilerTest.java --- @@ -2951,7 +2951,129 @@ public void

[GitHub] phoenix issue #320: PHOENIX-4820

2018-07-31 Thread JamesRTaylor
Github user JamesRTaylor commented on the issue: https://github.com/apache/phoenix/pull/320 Thanks for the earlier comment, @maryannxue. Do you think this approach is a good first step? Can you think of any cases where this approach will be problematic? ---

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread twdsilva
Github user twdsilva commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206737818 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/query/QueryConstants.java --- @@ -355,5 +355,19 @@ + "," + COLUMN_NAME +

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread ankitsinghal
Github user ankitsinghal commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206738342 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/query/QueryConstants.java --- @@ -355,5 +355,19 @@ + "," + COLUMN_NAME

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread ankitsinghal
Github user ankitsinghal commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206738423 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java --- @@ -2723,13 +2712,10 @@ private void

[GitHub] phoenix pull request #320: PHOENIX-4820

2018-07-31 Thread JamesRTaylor
Github user JamesRTaylor commented on a diff in the pull request: https://github.com/apache/phoenix/pull/320#discussion_r206717157 --- Diff: phoenix-core/src/test/java/org/apache/phoenix/compile/QueryCompilerTest.java --- @@ -2951,7 +2951,129 @@ public void

[jira] [Created] (PHOENIX-4830) order by primary key desc return wrong results

2018-07-31 Thread JieChen (JIRA)
JieChen created PHOENIX-4830: Summary: order by primary key desc return wrong results Key: PHOENIX-4830 URL: https://issues.apache.org/jira/browse/PHOENIX-4830 Project: Phoenix Issue Type: Bug

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread ankitsinghal
Github user ankitsinghal commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206736061 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java --- @@ -2723,13 +2712,10 @@ private void

[GitHub] phoenix issue #315: PHOENIX-3655 Global Phoenix Client Metrics for PQS

2018-07-31 Thread karanmehta93
Github user karanmehta93 commented on the issue: https://github.com/apache/phoenix/pull/315 @joshelser I think the only question pending in this PR is if we want JVMMetrics or not, which are crucial from PQS POV, otherwise not really for a regular client. We can discuss what approach

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread ankitsinghal
Github user ankitsinghal commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206735726 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/query/QueryConstants.java --- @@ -355,5 +355,19 @@ + "," + COLUMN_NAME

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread twdsilva
Github user twdsilva commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206737111 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/query/QueryConstants.java --- @@ -355,5 +355,19 @@ + "," + COLUMN_NAME +

[jira] [Updated] (PHOENIX-4765) Add server side config property to disallow metadata changes that require being propagated to children

2018-07-31 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-4765: --- Priority: Blocker (was: Major) > Add server side config property to disallow metadata

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread ankitsinghal
Github user ankitsinghal commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206741679 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/query/QueryConstants.java --- @@ -355,5 +355,19 @@ + "," + COLUMN_NAME

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread karanmehta93
Github user karanmehta93 commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206415547 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java --- @@ -1913,6 +1940,21 @@ private PTable

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread karanmehta93
Github user karanmehta93 commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206415970 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java --- @@ -2957,6 +3010,11 @@ MutationState dropTable(String

[jira] [Updated] (PHOENIX-4820) Optimize OrderBy for ClientAggregatePlan

2018-07-31 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-4820: -- Attachment: PHOENIX-4820-4.x-HBase-1.4.patch > Optimize OrderBy for ClientAggregatePlan >

[jira] [Updated] (PHOENIX-4820) Optimize OrderBy for ClientAggregatePlan

2018-07-31 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-4820: -- Attachment: (was: PHOENIX-4820_v1.patch) > Optimize OrderBy for ClientAggregatePlan >

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread karanmehta93
Github user karanmehta93 commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206414686 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java --- @@ -3410,17 +3405,10 @@ void

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread karanmehta93
Github user karanmehta93 commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206414419 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java --- @@ -2723,6 +2712,9 @@ private void

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread karanmehta93
Github user karanmehta93 commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206416912 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/BasePermissionsIT.java --- @@ -16,8 +16,29 @@ */ package

[GitHub] phoenix pull request #313: PHOENIX-4799 Write cells using checkAndMutate to ...

2018-07-31 Thread karanmehta93
Github user karanmehta93 commented on a diff in the pull request: https://github.com/apache/phoenix/pull/313#discussion_r206412733 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/BasePermissionsIT.java --- @@ -82,6 +82,10 @@ static final String

[jira] [Updated] (PHOENIX-4820) Optimize OrderBy for ClientAggregatePlan

2018-07-31 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-4820: -- Attachment: (was: PHOENIX-4820_v2.patch) > Optimize OrderBy for ClientAggregatePlan >