phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gokcen Iskender (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-5263) Provide an option to fully rebuild LOCAL indexes asynchronously through SQL
Date Mon, 29 Apr 2019 19:54:00 GMT
Gokcen Iskender created PHOENIX-5263:
----------------------------------------

             Summary: Provide an option to fully rebuild LOCAL indexes asynchronously through
SQL
                 Key: PHOENIX-5263
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5263
             Project: Phoenix
          Issue Type: Bug
            Reporter: Gokcen Iskender
            Assignee: Gokcen Iskender


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.

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message