[jira] [Created] (PHOENIX-4806) make PhoenixStorageHander using only unmanaged tables

["Sergey Soldatov (JIRA)" <ji...@apache.org>]

Sergey Soldatov created PHOENIX-4806:
----------------------------------------

             Summary: make PhoenixStorageHander using only unmanaged tables
                 Key: PHOENIX-4806
                 URL: https://issues.apache.org/jira/browse/PHOENIX-4806
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.14.0, 5.0.0
            Reporter: Sergey Soldatov
            Assignee: Sergey Soldatov


For managed table Hive is heavily using internal statistic which is not updated properly when data is changing from outside. So all custom storage handlers are moving to the schema when only unmanaged (external) tables are using.
The suggested lifecycle:
1) All tables should be created with external keyword
2) if Phoenix table doesn't exist, we create a new one and add a flag that it should be deleted on drop table from hive
3) If Phoenix table exists, no changes in the existing behavior.

Some of the storage handlers that are part of Hive distribution are already using this schema. Others are in progress.

FYI [~elserj]



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