[jira] [Created] (PHOENIX-4878) Remove SharedTableState and replace with PTable

2018-08-28 Thread Thomas D'Silva (JIRA)
Thomas D'Silva created PHOENIX-4878: --- Summary: Remove SharedTableState and replace with PTable Key: PHOENIX-4878 URL: https://issues.apache.org/jira/browse/PHOENIX-4878 Project: Phoenix Iss

[jira] [Assigned] (PHOENIX-4872) BulkLoad has bug when loading on single-cell-array-with-offsets table.

2018-08-28 Thread Swaroopa Kadam (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam reassigned PHOENIX-4872: --- Assignee: Swaroopa Kadam > BulkLoad has bug when loading on single-cell-array-with

[jira] [Updated] (PHOENIX-3178) Row count incorrect for UPSERT SELECT when auto commit is false

2018-08-28 Thread Swaroopa Kadam (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam updated PHOENIX-3178: Attachment: (was: PHOENIX-3178-4.x-HBase-1.4.patch) > Row count incorrect for UPSERT

[jira] [Updated] (PHOENIX-3178) Row count incorrect for UPSERT SELECT when auto commit is false

2018-08-28 Thread Swaroopa Kadam (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam updated PHOENIX-3178: Attachment: (was: PHOENIX-3178.patch) > Row count incorrect for UPSERT SELECT when au

[jira] [Updated] (PHOENIX-4870) PQS metrics are not being logged when AutoCommit is set to true in LoggingPhoenixConnection

2018-08-28 Thread Swaroopa Kadam (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam updated PHOENIX-4870: Attachment: (was: PHOENIX-4870.patch) > PQS metrics are not being logged when AutoCom

[jira] [Updated] (PHOENIX-4870) PQS metrics are not being logged when AutoCommit is set to true in LoggingPhoenixConnection

2018-08-28 Thread Swaroopa Kadam (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam updated PHOENIX-4870: Attachment: (was: PHOENIX-4870-4.x-HBase-1.4.patch) > PQS metrics are not being logge

[jira] [Updated] (PHOENIX-4870) PQS metrics are not being logged when AutoCommit is set to true in LoggingPhoenixConnection

2018-08-28 Thread Swaroopa Kadam (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam updated PHOENIX-4870: Attachment: PHOENIX-4870-4.x-HBase-1.4.patch PHOENIX-4870.patch > PQS met

[jira] [Updated] (PHOENIX-4717) Document restrictions on adding primary key columns

2018-08-28 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-4717: Summary: Document restrictions on adding primary key columns (was: Document when a prima

[jira] [Updated] (PHOENIX-4717) Document when a primary column is allowed to be added

2018-08-28 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-4717: Description: For both views and tables 1. We allow nullable columns in the PK, but only i

[jira] [Created] (PHOENIX-4877) Consider Adding Developer Documentation for Phoenix Query Execution

2018-08-28 Thread Daniel Wong (JIRA)
Daniel Wong created PHOENIX-4877: Summary: Consider Adding Developer Documentation for Phoenix Query Execution Key: PHOENIX-4877 URL: https://issues.apache.org/jira/browse/PHOENIX-4877 Project: Phoeni

[jira] [Updated] (PHOENIX-3178) Row count incorrect for UPSERT SELECT when auto commit is false

2018-08-28 Thread Swaroopa Kadam (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam updated PHOENIX-3178: Attachment: PHOENIX-3178-4.x-HBase-1.4.patch PHOENIX-3178.patch > Row cou

[jira] [Updated] (PHOENIX-3178) Row count incorrect for UPSERT SELECT when auto commit is false

2018-08-28 Thread Swaroopa Kadam (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam updated PHOENIX-3178: Attachment: (was: PHOENIX-3178.patch) > Row count incorrect for UPSERT SELECT when au

[jira] [Updated] (PHOENIX-3178) Row count incorrect for UPSERT SELECT when auto commit is false

2018-08-28 Thread Swaroopa Kadam (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam updated PHOENIX-3178: Attachment: (was: PHOENIX-3178-master.patch) > Row count incorrect for UPSERT SELECT

[jira] [Updated] (PHOENIX-3178) Row count incorrect for UPSERT SELECT when auto commit is false

2018-08-28 Thread Swaroopa Kadam (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam updated PHOENIX-3178: Attachment: PHOENIX-3178.patch PHOENIX-3178-master.patch > Row count inco

[jira] [Updated] (PHOENIX-3178) Row count incorrect for UPSERT SELECT when auto commit is false

2018-08-28 Thread Swaroopa Kadam (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam updated PHOENIX-3178: Attachment: (was: PHOENIX-3178.patch) > Row count incorrect for UPSERT SELECT when au

Re: [DISCUSS] Suggestions for Phoenix from HBaseCon Asia notes

2018-08-28 Thread Andrew Purtell
On Tue, Aug 28, 2018 at 2:01 PM James Taylor wrote: > Glad to hear this was discussed at HBaseCon. The most common request I've > seen asked for is to be able to write Phoenix-compatible data from other, > non-Phoenix services/projects, mainly because row-by-row updates (even when > batched) can

Re: [DISCUSS] Suggestions for Phoenix from HBaseCon Asia notes

2018-08-28 Thread James Taylor
Glad to hear this was discussed at HBaseCon. The most common request I've seen asked for is to be able to write Phoenix-compatible data from other, non-Phoenix services/projects, mainly because row-by-row updates (even when batched) can be a bottleneck. This is not feasible by using low level const

[jira] [Resolved] (PHOENIX-2114) Implement PTable.getParentName() correctly for views

2018-08-28 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva resolved PHOENIX-2114. - Resolution: Fixed > Implement PTable.getParentName() correctly for views >

Re: [DISCUSS] EXPLAIN'ing what we do well (was Re: [DISCUSS] Suggestions for Phoenix from HBaseCon Asia notes)

2018-08-28 Thread James Taylor
Thomas' idea is a good one. From the EXPLAIN plan ResultSet, you can directly get an estimate of the number of bytes that will be scanned. Take a look at this [1] documentation. We need to implement PHOENIX-4735 too (so that things are setup well out-of-the-box). We could have a kind of guardrail c

Re: [DISCUSS] Suggestions for Phoenix from HBaseCon Asia notes

2018-08-28 Thread Andrew Purtell
On Mon, Aug 27, 2018 at 11:03 AM Josh Elser wrote: > 2. Can Phoenix be the de-facto schema for SQL on HBase? > > We've long asserted "if you have to ask how Phoenix serializes data, you > shouldn't be do it" (a nod that you have to write lots of code). What if > we turn that on its head? Could we

[jira] [Created] (PHOENIX-4876) Delete returns incorrect number of rows affected in some case

2018-08-28 Thread William Shen (JIRA)
William Shen created PHOENIX-4876: - Summary: Delete returns incorrect number of rows affected in some case Key: PHOENIX-4876 URL: https://issues.apache.org/jira/browse/PHOENIX-4876 Project: Phoenix

[jira] [Created] (PHOENIX-4875) Don't acquire a mutex while dropping a table and while creating a view

2018-08-28 Thread Thomas D'Silva (JIRA)
Thomas D'Silva created PHOENIX-4875: --- Summary: Don't acquire a mutex while dropping a table and while creating a view Key: PHOENIX-4875 URL: https://issues.apache.org/jira/browse/PHOENIX-4875 Projec

[jira] [Updated] (PHOENIX-4849) UPSERT SELECT fails with stale region boundary exception after a split

2018-08-28 Thread Lars Hofhansl (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lars Hofhansl updated PHOENIX-4849: --- Attachment: PHOENIX-4849-v3.patch > UPSERT SELECT fails with stale region boundary exceptio

[jira] [Reopened] (PHOENIX-4839) IndexHalfStoreFileReaderGenerator throws NullPointerException

2018-08-28 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva reopened PHOENIX-4839: - [~mnpoonia] The following two tests are failing with this patch, can you please take a loo

[jira] [Resolved] (PHOENIX-4873) Document missing time and timestamp formatting configuration properties

2018-08-28 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Josh Elser resolved PHOENIX-4873. - Resolution: Fixed > Document missing time and timestamp formatting configuration properties > -

[jira] [Updated] (PHOENIX-4873) Document missing time and timestamp formatting configuration properties

2018-08-28 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Josh Elser updated PHOENIX-4873: Attachment: PHOENIX-4873.diff > Document missing time and timestamp formatting configuration prop

[jira] [Created] (PHOENIX-4874) psql doesn't support date/time with values smaller than milliseconds

2018-08-28 Thread Josh Elser (JIRA)
Josh Elser created PHOENIX-4874: --- Summary: psql doesn't support date/time with values smaller than milliseconds Key: PHOENIX-4874 URL: https://issues.apache.org/jira/browse/PHOENIX-4874 Project: Phoenix

[jira] [Created] (PHOENIX-4873) Document missing time and timestamp formatting configuration properties

2018-08-28 Thread Josh Elser (JIRA)
Josh Elser created PHOENIX-4873: --- Summary: Document missing time and timestamp formatting configuration properties Key: PHOENIX-4873 URL: https://issues.apache.org/jira/browse/PHOENIX-4873 Project: Phoe

[jira] [Updated] (PHOENIX-4859) Using local index in where statement for join (only rhs table) query fails

2018-08-28 Thread Rajeshbabu Chintaguntla (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla updated PHOENIX-4859: - Attachment: PHOENIX-4859.patch > Using local index in where statement f

[jira] [Updated] (PHOENIX-4869) Empty row when using OFFSET + LIMIT

2018-08-28 Thread Gardella Juan Pablo (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gardella Juan Pablo updated PHOENIX-4869: - Description: I'm using [Phoenix shipped |https://docs.hortonworks.com/HDPDocum