[jira] [Created] (PHOENIX-3125) Support CREATE TABLE ... ASYNC to add empty key value through MR when mapping to existing HBase table

["James Taylor (JIRA)" <ji...@apache.org>]

James Taylor created PHOENIX-3125:
-------------------------------------

             Summary: Support CREATE TABLE ... ASYNC to add empty key value through MR when mapping to existing HBase table
                 Key: PHOENIX-3125
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3125
             Project: Phoenix
          Issue Type: Bug
            Reporter: James Taylor


Often times, when a Phoenix table is created to map to an existing HBase table that is large, the CREATE TABLE statement times out. This is because Phoenix needs to write an empty/marker KeyValue to every row (for the reason, see here[1]) which takes a while for larger tables.

We should support the ASYNC keyword at the end of the CREATE TABLE statement to allow a MR job to be used instead of our synchronous mechanism to prevent this timeout. We'd also need a status on the table which is set upon completion so that we know when we can start using it. I suppose we could overload the INDEX_STATUS column and eventually change it's name to just STATUS.

[1] https://phoenix.apache.org/faq.html#Why_empty_key_value



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)