[jira] [Commented] (PHOENIX-4021) Remove CachingHTableFactory

[ https://issues.apache.org/jira/browse/PHOENIX-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086768#comment-16086768 ] James Taylor commented on PHOENIX-4021: --- Looks like ParallelWriterIndexCommitter would already use

[jira] [Updated] (PHOENIX-3947) Increase scan time out for partial index rebuild and retry only once

[ https://issues.apache.org/jira/browse/PHOENIX-3947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-3947: -- Fix Version/s: 4.11.1 4.12.0 > Increase scan time out for partial index

[jira] [Commented] (PHOENIX-4018) HashJoin may produce nulls for LHS table columns

[ https://issues.apache.org/jira/browse/PHOENIX-4018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086743#comment-16086743 ] Hadoop QA commented on PHOENIX-4018: {color:red}-1 overall{color}. Here are the results of testing

[jira] [Commented] (PHOENIX-4021) Remove CachingHTableFactory

[ https://issues.apache.org/jira/browse/PHOENIX-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086739#comment-16086739 ] Samarth Jain commented on PHOENIX-4021: --- Before we go down the route of caching an HConnection, it

[jira] [Commented] (PHOENIX-4021) Remove CachingHTableFactory

[ https://issues.apache.org/jira/browse/PHOENIX-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086736#comment-16086736 ] Samarth Jain commented on PHOENIX-4021: --- [~gjacoby] - one option for you would be to create a

[jira] [Updated] (PHOENIX-4021) Remove CachingHTableFactory

[ https://issues.apache.org/jira/browse/PHOENIX-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Geoffrey Jacoby updated PHOENIX-4021: - Attachment: PHOENIX-4021.patch Attaching this first draft patch for discussion. It

[jira] [Commented] (PHOENIX-4020) Lower our medium and high priority numbers below HBase meta priority

[ https://issues.apache.org/jira/browse/PHOENIX-4020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086714#comment-16086714 ] Samarth Jain commented on PHOENIX-4020: --- We have to be a little careful and make sure the change

[jira] [Commented] (PHOENIX-3995) Use medium priority for UPSERT SELECT distributed across cluster

[ https://issues.apache.org/jira/browse/PHOENIX-3995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086713#comment-16086713 ] Samarth Jain commented on PHOENIX-3995: --- Yes, that covers it. > Use medium priority for UPSERT

[jira] [Created] (PHOENIX-4023) Handle drop of shared index when UPDATE_CACHE_FREQUENCY is set

James Taylor created PHOENIX-4023: - Summary: Handle drop of shared index when UPDATE_CACHE_FREQUENCY is set Key: PHOENIX-4023 URL: https://issues.apache.org/jira/browse/PHOENIX-4023 Project: Phoenix

[jira] [Commented] (PHOENIX-4023) Handle drop of shared index when UPDATE_CACHE_FREQUENCY is set

[ https://issues.apache.org/jira/browse/PHOENIX-4023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086698#comment-16086698 ] James Taylor commented on PHOENIX-4023: --- Thoughts, [~lhofhansl], [~sukuna...@gmail.com]? > Handle

[jira] [Comment Edited] (PHOENIX-4023) Handle drop of shared index when UPDATE_CACHE_FREQUENCY is set

[ https://issues.apache.org/jira/browse/PHOENIX-4023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086698#comment-16086698 ] James Taylor edited comment on PHOENIX-4023 at 7/14/17 1:23 AM:

[jira] [Updated] (PHOENIX-3995) Use medium priority for UPSERT SELECT distributed across cluster

[ https://issues.apache.org/jira/browse/PHOENIX-3995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3995: -- Fix Version/s: 4.12.0 > Use medium priority for UPSERT SELECT distributed across cluster >

[jira] [Commented] (PHOENIX-3999) Optimize inner joins as SKIP-SCAN-JOIN when possible

[ https://issues.apache.org/jira/browse/PHOENIX-3999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086686#comment-16086686 ] James Taylor commented on PHOENIX-3999: --- Thanks for the response, [~maryannxue]! We have both

[jira] [Commented] (PHOENIX-4010) Hash Join cache may not be send to all regionservers when we have stale HBase meta cache

[ https://issues.apache.org/jira/browse/PHOENIX-4010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086677#comment-16086677 ] James Taylor commented on PHOENIX-4010: --- Thanks for the patch, [~an...@apache.org]. Looks good,

[jira] [Updated] (PHOENIX-4018) HashJoin may produce nulls for LHS table columns

[ https://issues.apache.org/jira/browse/PHOENIX-4018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov updated PHOENIX-4018: - Attachment: PHOENIX-4018-1.patch implemented the suggested fix. > HashJoin may produce

[jira] [Commented] (PHOENIX-3994) Index RPC priority still depends on the controller factory property in hbase-site.xml

[ https://issues.apache.org/jira/browse/PHOENIX-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086649#comment-16086649 ] Hudson commented on PHOENIX-3994: - FAILURE: Integrated in Jenkins build Phoenix-master #1686 (See

[jira] [Commented] (PHOENIX-4010) Hash Join cache may not be send to all regionservers when we have stale HBase meta cache

[ https://issues.apache.org/jira/browse/PHOENIX-4010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086629#comment-16086629 ] Sergey Soldatov commented on PHOENIX-4010: -- LGTM. Did some stress testing including killing and

[jira] [Commented] (PHOENIX-3994) Index RPC priority still depends on the controller factory property in hbase-site.xml

[ https://issues.apache.org/jira/browse/PHOENIX-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086602#comment-16086602 ] Samarth Jain commented on PHOENIX-3994: --- Yes, I did. Although, under the hood, HBaseConfiguration

[jira] [Commented] (PHOENIX-3948) Enable shorter time outs for server-side index writes

[ https://issues.apache.org/jira/browse/PHOENIX-3948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086595#comment-16086595 ] Samarth Jain commented on PHOENIX-3948: --- +1 > Enable shorter time outs for server-side index

[jira] [Commented] (PHOENIX-3948) Enable shorter time outs for server-side index writes

[ https://issues.apache.org/jira/browse/PHOENIX-3948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086591#comment-16086591 ] James Taylor commented on PHOENIX-3948: --- +1. Looks good! Thanks, [~vincentpoon]. > Enable shorter

[jira] [Commented] (PHOENIX-3948) Enable shorter time outs for server-side index writes

[ https://issues.apache.org/jira/browse/PHOENIX-3948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086586#comment-16086586 ] Geoffrey Jacoby commented on PHOENIX-3948: -- lgtm > Enable shorter time outs for server-side

[jira] [Commented] (PHOENIX-3997) UngroupedAggregateRegionObserver.commitBatchWithHTable() should not check the memstore size and wait for flush.

[ https://issues.apache.org/jira/browse/PHOENIX-3997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086557#comment-16086557 ] Hadoop QA commented on PHOENIX-3997: {color:red}-1 overall{color}. Here are the results of testing

[jira] [Commented] (PHOENIX-3807) Add server level metrics for secondary indexes

[ https://issues.apache.org/jira/browse/PHOENIX-3807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086550#comment-16086550 ] Vincent Poon commented on PHOENIX-3807: --- Apologies [~elserj], forgot about that and forgot to

[jira] [Updated] (PHOENIX-3948) Enable shorter time outs for server-side index writes

[ https://issues.apache.org/jira/browse/PHOENIX-3948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vincent Poon updated PHOENIX-3948: -- Attachment: PHOENIX-3948.master.v2.patch > Enable shorter time outs for server-side index

[jira] [Commented] (PHOENIX-3994) Index RPC priority still depends on the controller factory property in hbase-site.xml

[ https://issues.apache.org/jira/browse/PHOENIX-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086534#comment-16086534 ] James Taylor commented on PHOENIX-3994: --- >From Ted over on HBASE-18378: Have you tried this method

[jira] [Comment Edited] (PHOENIX-3994) Index RPC priority still depends on the controller factory property in hbase-site.xml

[ https://issues.apache.org/jira/browse/PHOENIX-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086534#comment-16086534 ] James Taylor edited comment on PHOENIX-3994 at 7/13/17 10:35 PM: - >From

[jira] [Commented] (PHOENIX-3807) Add server level metrics for secondary indexes

[ https://issues.apache.org/jira/browse/PHOENIX-3807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086486#comment-16086486 ] Josh Elser commented on PHOENIX-3807: - bq. Here's a patch which uses the HBase native metrics API.

[jira] [Created] (PHOENIX-4022) Add PhoenixMetricsLog interface that can be used to log metrics for queries and mutations.

Thomas D'Silva created PHOENIX-4022: --- Summary: Add PhoenixMetricsLog interface that can be used to log metrics for queries and mutations. Key: PHOENIX-4022 URL:

[jira] [Commented] (PHOENIX-3807) Add server level metrics for secondary indexes

[ https://issues.apache.org/jira/browse/PHOENIX-3807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086479#comment-16086479 ] Hadoop QA commented on PHOENIX-3807: {color:red}-1 overall{color}. Here are the results of testing

[jira] [Commented] (PHOENIX-4021) Remove CachingHTableFactory

[ https://issues.apache.org/jira/browse/PHOENIX-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086476#comment-16086476 ] Lars Hofhansl commented on PHOENIX-4021: Yep. Cache the (H)Connection and create HTable from

[jira] [Commented] (PHOENIX-3807) Add server level metrics for secondary indexes

[ https://issues.apache.org/jira/browse/PHOENIX-3807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086449#comment-16086449 ] Hadoop QA commented on PHOENIX-3807: {color:red}-1 overall{color}. Here are the results of testing

[jira] [Created] (PHOENIX-4021) Remove CachingHTableFactory

Geoffrey Jacoby created PHOENIX-4021: Summary: Remove CachingHTableFactory Key: PHOENIX-4021 URL: https://issues.apache.org/jira/browse/PHOENIX-4021 Project: Phoenix Issue Type: Bug

[jira] [Updated] (PHOENIX-3807) Add server level metrics for secondary indexes

[ https://issues.apache.org/jira/browse/PHOENIX-3807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Josh Elser updated PHOENIX-3807: Attachment: PHOENIX-3807.v2.patch v2 has the naming suggestions I made over v1. Attaching because

[jira] [Commented] (PHOENIX-3995) Use medium priority for UPSERT SELECT distributed across cluster

[ https://issues.apache.org/jira/browse/PHOENIX-3995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086359#comment-16086359 ] James Taylor commented on PHOENIX-3995: --- To support this, I believe now that we've got a

[jira] [Updated] (PHOENIX-3997) UngroupedAggregateRegionObserver.commitBatchWithHTable() should not check the memstore size and wait for flush.

[ https://issues.apache.org/jira/browse/PHOENIX-3997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Geoffrey Jacoby updated PHOENIX-3997: - Attachment: PHOENIX-3997-v3.patch >

[jira] [Updated] (PHOENIX-3807) Add server level metrics for secondary indexes

[ https://issues.apache.org/jira/browse/PHOENIX-3807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Josh Elser updated PHOENIX-3807: Fix Version/s: 4.12.0 > Add server level metrics for secondary indexes >

[jira] [Updated] (PHOENIX-4020) Lower our medium and high priority numbers below HBase meta priority

[ https://issues.apache.org/jira/browse/PHOENIX-4020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-4020: -- Summary: Lower our medium and high priority numbers below HBase meta priority (was: Lower

[jira] [Commented] (PHOENIX-4020) Lower our medium and high priority numbers below meta priority

[ https://issues.apache.org/jira/browse/PHOENIX-4020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086320#comment-16086320 ] James Taylor commented on PHOENIX-4020: --- This is an easy change for us and probably a good idea.

[jira] [Created] (PHOENIX-4020) Lower our medium and high priority numbers below meta priority

James Taylor created PHOENIX-4020: - Summary: Lower our medium and high priority numbers below meta priority Key: PHOENIX-4020 URL: https://issues.apache.org/jira/browse/PHOENIX-4020 Project: Phoenix

[jira] [Comment Edited] (PHOENIX-3947) Increase scan time out for partial index rebuild and retry only once

[ https://issues.apache.org/jira/browse/PHOENIX-3947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086312#comment-16086312 ] James Taylor edited comment on PHOENIX-3947 at 7/13/17 7:59 PM: +1 on

[jira] [Commented] (PHOENIX-3947) Increase scan time out for partial index rebuild and retry only once

[ https://issues.apache.org/jira/browse/PHOENIX-3947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086312#comment-16086312 ] James Taylor commented on PHOENIX-3947: --- +1 on the patch, [~samarthjain]. Nice job. I think the

[jira] [Commented] (PHOENIX-3994) Index RPC priority still depends on the controller factory property in hbase-site.xml

[ https://issues.apache.org/jira/browse/PHOENIX-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086263#comment-16086263 ] Samarth Jain commented on PHOENIX-3994: --- bq. One other question: shouldn't we be using the

[jira] [Commented] (PHOENIX-3994) Index RPC priority still depends on the controller factory property in hbase-site.xml

[ https://issues.apache.org/jira/browse/PHOENIX-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086260#comment-16086260 ] James Taylor commented on PHOENIX-3994: --- One other question: shouldn't we be using the coprocessor

[jira] [Updated] (PHOENIX-3994) Index RPC priority still depends on the controller factory property in hbase-site.xml

[ https://issues.apache.org/jira/browse/PHOENIX-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-3994: -- Attachment: PHOENIX-3994_v5.patch Filed HBASE-18378 to track the clone issue. Thanks for the

[jira] [Commented] (PHOENIX-4010) Hash Join cache may not be send to all regionservers when we have stale HBase meta cache

[ https://issues.apache.org/jira/browse/PHOENIX-4010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086255#comment-16086255 ] Hadoop QA commented on PHOENIX-4010: {color:red}-1 overall{color}. Here are the results of testing

[jira] [Updated] (PHOENIX-3947) Increase scan time out for partial index rebuild and retry only once

[ https://issues.apache.org/jira/browse/PHOENIX-3947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-3947: -- Attachment: PHOENIX-3947_v5.patch Patch with new test that asserts that if rebuild task fails

[jira] [Commented] (PHOENIX-3994) Index RPC priority still depends on the controller factory property in hbase-site.xml

[ https://issues.apache.org/jira/browse/PHOENIX-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086193#comment-16086193 ] James Taylor commented on PHOENIX-3994: --- Thanks for the updated patch, [~samarthjain]. Would you

[jira] [Updated] (PHOENIX-3947) Increase scan time out for partial index rebuild and retry only once

[ https://issues.apache.org/jira/browse/PHOENIX-3947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-3947: -- Attachment: PHOENIX-3947_v4.patch updated patch that addresses test failures in

[jira] [Commented] (PHOENIX-3994) Index RPC priority still depends on the controller factory property in hbase-site.xml

[ https://issues.apache.org/jira/browse/PHOENIX-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086062#comment-16086062 ] Vincent Poon commented on PHOENIX-3994: --- v4 patch lgtm, [~samarthjain] > Index RPC priority still

[jira] [Comment Edited] (PHOENIX-4010) Hash Join cache may not be send to all regionservers when we have stale HBase meta cache

[ https://issues.apache.org/jira/browse/PHOENIX-4010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086031#comment-16086031 ] Ankit Singhal edited comment on PHOENIX-4010 at 7/13/17 5:25 PM: -

[jira] [Updated] (PHOENIX-4010) Hash Join cache may not be send to all regionservers when we have stale HBase meta cache

[ https://issues.apache.org/jira/browse/PHOENIX-4010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-4010: --- Attachment: PHOENIX-4010_v1.patch Extended last patch with :- * Limit memory for hash join

[jira] [Comment Edited] (PHOENIX-4010) Hash Join cache may not be send to all regionservers when we have stale HBase meta cache

[ https://issues.apache.org/jira/browse/PHOENIX-4010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086031#comment-16086031 ] Ankit Singhal edited comment on PHOENIX-4010 at 7/13/17 5:21 PM: -

[jira] [Commented] (PHOENIX-4010) Hash Join cache may not be send to all regionservers when we have stale HBase meta cache

[ https://issues.apache.org/jira/browse/PHOENIX-4010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16085620#comment-16085620 ] Hadoop QA commented on PHOENIX-4010: {color:red}-1 overall{color}. Here are the results of testing

[jira] [Updated] (PHOENIX-3475) MetaData #getTables() API doesn't return view indexes

[ https://issues.apache.org/jira/browse/PHOENIX-3475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-3475: --- Fix Version/s: (was: 4.9.0) 4.12.0 > MetaData #getTables() API

[jira] [Updated] (PHOENIX-3956) NTH_VALUE(R.NAME,2) return null

[ https://issues.apache.org/jira/browse/PHOENIX-3956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-3956: --- Fix Version/s: (was: 4.9.0) 4.12.0 > NTH_VALUE(R.NAME,2) return null

[jira] [Updated] (PHOENIX-3454) ON DUPLICATE KEY construct doesn't work correctly when using lower case column names

[ https://issues.apache.org/jira/browse/PHOENIX-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-3454: --- Fix Version/s: (was: 4.9.0) 4.12.0 > ON DUPLICATE KEY construct

[jira] [Updated] (PHOENIX-3507) HBase secure wal log cash with Phoenix secondary index

[ https://issues.apache.org/jira/browse/PHOENIX-3507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-3507: --- Fix Version/s: (was: 4.9.0) 4.12.0 > HBase secure wal log cash with

[jira] [Updated] (PHOENIX-3655) Metrics for PQS

[ https://issues.apache.org/jira/browse/PHOENIX-3655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-3655: --- Fix Version/s: (was: 4.9.0) 4.12.0 > Metrics for PQS >

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

[ https://issues.apache.org/jira/browse/PHOENIX-3501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal resolved PHOENIX-3501. Resolution: Fixed > Push limit to server for distinct optimization >

[jira] [Resolved] (PHOENIX-3457) Adjust build settings in pom to improve consistency

[ https://issues.apache.org/jira/browse/PHOENIX-3457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal resolved PHOENIX-3457. Resolution: Fixed > Adjust build settings in pom to improve consistency >

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

[ https://issues.apache.org/jira/browse/PHOENIX-3501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16085533#comment-16085533 ] Ankit Singhal commented on PHOENIX-3501: [~giacomotaylor], if this is committed already in 4.9.0

Regarding addition of Qualifier Filters

Greetings ! HBase has this feature where all the columns ranging from minRange to maxRange can be extracted by specifying Qualifier Filters. Is there an existing feature in Apache Phoenix that can use this concept ? If not, is it feasible to add this feature to Phoenix ? How do we display tables

[jira] [Updated] (PHOENIX-3947) Increase scan time out for partial index rebuild and retry only once

[ https://issues.apache.org/jira/browse/PHOENIX-3947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-3947: -- Attachment: PHOENIX-3947_v3.patch [~jamestaylor], please review. > Increase scan time out