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)

Reply via email to