[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: PHOENIX-5272-4.1.3.patch > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.1.3.patch, PHOENIX-5272-4.x.patch, > PHOENIX-5272.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: (was: PHOENIX-5272.patch) > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch, PHOENIX-5272.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: PHOENIX-5272.patch > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch, PHOENIX-5272.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: PHOENIX-5272.patch > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch, PHOENIX-5272.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: PHOENIX-5272-4.x.patch > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: (was: PHOENIX-5272-4.x.patch) > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: (was: PHOENIX-5272.patch) > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: PHOENIX-5272-4.x.patch > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch, PHOENIX-5272.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: PHOENIX-5272.patch > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch, PHOENIX-5272.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: (was: PHOENIX-5272-4.x.patch) > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: (was: PHOENIX-5272.patch) > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: PHOENIX-5272.patch > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch, PHOENIX-5272.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: (was: PHOENIX-5272.patch) > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch, PHOENIX-5272.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: PHOENIX-5272.patch > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch, PHOENIX-5272.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: (was: PHOENIX-5272.patch) > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch, PHOENIX-5272.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: PHOENIX-5272.patch > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch, PHOENIX-5272.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Attachment: PHOENIX-5272-4.x.patch > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > Attachments: PHOENIX-5272-4.x.patch > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-5272) Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async
[ https://issues.apache.org/jira/browse/PHOENIX-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5272: - Description: This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so that we can delete all global indexes before rebuilding. This Jira is concentrated on ALTER INDEX REBUILD ALL sql syntax. (was: Currently if we run "ALTER INDEX ... REBUILD" , all the rows in the index are deleted and the index is rebuilt synchronously. "ALTER INEX ... REBUILD ASYNC" seems to be used for the IndexTool's partial rebuild option, rebuilding from ASYNC_REBUILD_TIMESTAMP (PHOENIX-2890) So it seems currently the only way to fully rebuild is the drop the index, and recreate it. This is burdensome as it requires have the schema DDL. We should have an option to fully rebuild asynchronously, that has the same semantics as dropping and recreating the index. A further advantage of this is we can maintain the splits of the index table while dropping its data. We are currently seeing issues where rebuilding a large table via a MR job results in hotspotting due to all data regions writing to the same index region at the start. ) > Support ALTER INDEX REBUILD ALL ASYNC to fully rebuild global indexes async > --- > > Key: PHOENIX-5272 > URL: https://issues.apache.org/jira/browse/PHOENIX-5272 > Project: Phoenix > Issue Type: Bug >Reporter: Gokcen Iskender >Assignee: Gokcen Iskender >Priority: Major > Fix For: 4.15.0, 5.1.0 > > > This Jira is part of PHOENIX-4703. On 4703, a flag to IndexTool is added so > that we can delete all global indexes before rebuilding. This Jira is > concentrated on ALTER INDEX REBUILD ALL sql syntax. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
