[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-09 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Fix Version/s: 5.1.0

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 5.1.0, 4.16.0
>
> Attachments: PHOENIX-5932-4.x.001.patch, PHOENIX-5932-4.x.001.patch, 
> PHOENIX-5932-4.x.patch, PHOENIX-5932-master.patch, 
> PHOENIX-5932-wip-4.x.001.patch, PHOENIX-5932-wip-4.x.patch, 
> PHOENIX-5932-wip-master.001.patch, PHOENIX-5932-wip-master.patch
>
>  Time Spent: 2.5h
>  Remaining Estimate: 0h
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-09 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: PHOENIX-5932-4.x.001.patch

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-4.x.001.patch, PHOENIX-5932-4.x.001.patch, 
> PHOENIX-5932-4.x.patch, PHOENIX-5932-master.patch, 
> PHOENIX-5932-wip-4.x.001.patch, PHOENIX-5932-wip-4.x.patch, 
> PHOENIX-5932-wip-master.001.patch, PHOENIX-5932-wip-master.patch
>
>  Time Spent: 2h 20m
>  Remaining Estimate: 0h
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-08 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: PHOENIX-5932-master.patch

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-4.x.001.patch, PHOENIX-5932-4.x.patch, 
> PHOENIX-5932-master.patch, PHOENIX-5932-wip-4.x.001.patch, 
> PHOENIX-5932-wip-4.x.patch, PHOENIX-5932-wip-master.001.patch, 
> PHOENIX-5932-wip-master.patch
>
>  Time Spent: 2h
>  Remaining Estimate: 0h
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-08 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: PHOENIX-5932-4.x.001.patch

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-4.x.001.patch, PHOENIX-5932-4.x.patch, 
> PHOENIX-5932-wip-4.x.001.patch, PHOENIX-5932-wip-4.x.patch, 
> PHOENIX-5932-wip-master.001.patch, PHOENIX-5932-wip-master.patch
>
>  Time Spent: 2h
>  Remaining Estimate: 0h
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-08 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: (was: PHOENIX-5932-wip-4.x.001.patch)

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-4.x.patch, PHOENIX-5932-wip-4.x.001.patch, 
> PHOENIX-5932-wip-4.x.patch, PHOENIX-5932-wip-master.001.patch, 
> PHOENIX-5932-wip-master.patch
>
>  Time Spent: 2h
>  Remaining Estimate: 0h
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-04 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: (was: PHOENIX-5932-4.x.patch)

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-4.x.patch, PHOENIX-5932-wip-4.x.001.patch, 
> PHOENIX-5932-wip-4.x.001.patch, PHOENIX-5932-wip-4.x.patch, 
> PHOENIX-5932-wip-master.001.patch, PHOENIX-5932-wip-master.patch
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-04 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: PHOENIX-5932-4.x.patch

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-4.x.patch, PHOENIX-5932-wip-4.x.001.patch, 
> PHOENIX-5932-wip-4.x.001.patch, PHOENIX-5932-wip-4.x.patch, 
> PHOENIX-5932-wip-master.001.patch, PHOENIX-5932-wip-master.patch
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-04 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: PHOENIX-5932-4.x.patch

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-4.x.patch, PHOENIX-5932-wip-4.x.001.patch, 
> PHOENIX-5932-wip-4.x.001.patch, PHOENIX-5932-wip-4.x.patch, 
> PHOENIX-5932-wip-master.001.patch, PHOENIX-5932-wip-master.patch
>
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-03 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: PHOENIX-5932-wip-4.x.001.patch

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-wip-4.x.001.patch, 
> PHOENIX-5932-wip-4.x.001.patch, PHOENIX-5932-wip-4.x.patch, 
> PHOENIX-5932-wip-master.001.patch, PHOENIX-5932-wip-master.patch
>
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-03 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: (was: PHOENIX-5932-wip-4.x.patch)

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-wip-4.x.001.patch, 
> PHOENIX-5932-wip-4.x.001.patch, PHOENIX-5932-wip-4.x.patch, 
> PHOENIX-5932-wip-master.001.patch, PHOENIX-5932-wip-master.patch
>
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-02 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: PHOENIX-5932-wip-4.x.001.patch

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-wip-4.x.001.patch, 
> PHOENIX-5932-wip-4.x.patch, PHOENIX-5932-wip-4.x.patch, 
> PHOENIX-5932-wip-master.001.patch, PHOENIX-5932-wip-master.patch
>
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-02 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: PHOENIX-5932-wip-master.001.patch

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-wip-4.x.patch, PHOENIX-5932-wip-4.x.patch, 
> PHOENIX-5932-wip-master.001.patch, PHOENIX-5932-wip-master.patch
>
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-02 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: PHOENIX-5932-wip-4.x.patch

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-wip-4.x.patch, PHOENIX-5932-wip-4.x.patch, 
> PHOENIX-5932-wip-master.patch
>
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-01 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: PHOENIX-5932-wip-master.patch

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-wip-4.x.patch, PHOENIX-5932-wip-master.patch
>
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-01 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Issue Type: Bug  (was: Improvement)

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Fix For: 4.16.0
>
> Attachments: PHOENIX-5932-wip-4.x.patch
>
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-01 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Attachment: PHOENIX-5932-wip-4.x.patch

> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Improvement
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
> Attachments: PHOENIX-5932-wip-4.x.patch
>
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (PHOENIX-5932) View Index rebuild results in surplus rows from other view indexes

2020-06-01 Thread Abhishek Singh Chouhan (Jira)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Singh Chouhan updated PHOENIX-5932:

Description: 
Steps to reproduce
 # Create a table with PK as COL1, COL2
 # Create 2 views with different view constants on COL2. Also add other columns
 # Upsert rows into the views
 # Create indexes on the views. Rebuild will result in each view index having 
rows from other view also

This is because we set the filter on scan to null during rebuild 
[here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]

  was:
Steps to reproduce
 # Create a table with PK as COL1, COL2
 # Create 2 views with different view constants on COL2. Also add other columns
 # Upsert rows into the views
 # Create indexes on the views. Rebuild will result in each view index having 
rows from other view also

This is because we set the filter on scan to null during rebuild 
[here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]


> View Index rebuild results in surplus rows from other view indexes
> --
>
> Key: PHOENIX-5932
> URL: https://issues.apache.org/jira/browse/PHOENIX-5932
> Project: Phoenix
>  Issue Type: Improvement
>Affects Versions: 4.16.0
>Reporter: Abhishek Singh Chouhan
>Assignee: Abhishek Singh Chouhan
>Priority: Major
>
> Steps to reproduce
>  # Create a table with PK as COL1, COL2
>  # Create 2 views with different view constants on COL2. Also add other 
> columns
>  # Upsert rows into the views
>  # Create indexes on the views. Rebuild will result in each view index having 
> rows from other view also
> This is because we set the filter on scan to null during rebuild 
> [here|[https://github.com/apache/phoenix/blob/4.x/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java#L1084]]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)