phoenix系统创建语句

CREATE TABLE SYSTEM."CATALOG"(
    TENANT_ID VARCHAR NULL,
    TABLE_SCHEM VARCHAR NULL,
    TABLE_NAME VARCHAR NOT NULL,
    COLUMN_NAME VARCHAR NULL,
    COLUMN_FAMILY VARCHAR NULL,
    TABLE_SEQ_NUM BIGINT,
    TABLE_TYPE CHAR(1),
    PK_NAME VARCHAR,
    COLUMN_COUNT INTEGER,
    SALT_BUCKETS INTEGER,
    DATA_TABLE_NAME VARCHAR,
    INDEX_STATE CHAR(1),
    IMMUTABLE_ROWS BOOLEAN,
    VIEW_STATEMENT VARCHAR,
    DEFAULT_COLUMN_FAMILY VARCHAR,
    DISABLE_WAL BOOLEAN,
    MULTI_TENANT BOOLEAN,
    VIEW_TYPE UNSIGNED_TINYINT,
    VIEW_INDEX_ID SMALLINT,
    DATA_TYPE INTEGER,
    COLUMN_SIZE INTEGER,
    DECIMAL_DIGITS INTEGER,
    NULLABLE INTEGER,
    ORDINAL_POSITION INTEGER,
    SORT_ORDER INTEGER,
    ARRAY_SIZE INTEGER,
    VIEW_CONSTANT VARBINARY,
    IS_VIEW_REFERENCED BOOLEAN,
    KEY_SEQ SMALLINT,
    LINK_TYPE UNSIGNED_TINYINT,
    TYPE_NAME VARCHAR,
    REMARKS VARCHAR,
    SELF_REFERENCING_COL_NAME VARCHAR,
    REF_GENERATION VARCHAR,
    BUFFER_LENGTH INTEGER,
    NUM_PREC_RADIX INTEGER,
    COLUMN_DEF VARCHAR,
    SQL_DATA_TYPE INTEGER,
    SQL_DATETIME_SUB INTEGER,
    CHAR_OCTET_LENGTH INTEGER,
    IS_NULLABLE VARCHAR,
    SCOPE_CATALOG VARCHAR,
    SCOPE_SCHEMA VARCHAR,
    SCOPE_TABLE VARCHAR,
    SOURCE_DATA_TYPE SMALLINT,
    IS_AUTOINCREMENT VARCHAR,
    INDEX_TYPE UNSIGNED_TINYINT,
    INDEX_DISABLE_TIMESTAMP BIGINT,
    STORE_NULLS BOOLEAN,
    BASE_COLUMN_COUNT INTEGER,
    IS_ROW_TIMESTAMP BOOLEAN,
     TRANSACTIONAL BOOLEAN,
    UPDATE_CACHE_FREQUENCY BIGINT,
    IS_NAMESPACE_MAPPED BOOLEAN,
    AUTO_PARTITION_SEQ VARCHAR,
    APPEND_ONLY_SCHEMA BOOLEAN,
    CONSTRAINT pk PRIMARY KEY (TENANT_ID,TABLE_SCHEM,TABLE_NAME,COLUMN_NAME,COLUMN_FAMILY)
) VERSIONS=1000, KEEP_DELETED_CELLS=true,SPLIT_POLICY='org.apache.phoenix.schema.MetaDataSplitPolicy',TRANSACTIONAL=false


CREATE TABLE SYSTEM."STATS"(
    PHYSICAL_NAME VARCHAR NOT NULL,
    COLUMN_FAMILY VARCHAR NOT NULL,
    GUIDE_POST_KEY VARBINARY,
    GUIDE_POSTS_WIDTH BIGINT,
    LAST_STATS_UPDATE_TIME DATE,
     GUIDE_POSTS_ROW_COUNT BIGINT,
     CONSTRAINT pk PRIMARY KEY (PHYSICAL_NAME,COLUMN_FAMILY,GUIDE_POST_KEY)
) VERSIONS=1,KEEP_DELETED_CELLS=false,SPLIT_POLICY='org.apache.phoenix.schema.MetaDataSplitPolicy',TRANSACTIONAL=false


CREATE TABLE SYSTEM."FUNCTION"(
    TENANT_ID VARCHAR NULL,
    FUNCTION_NAME VARCHAR NOT NULL,
    NUM_ARGS INTEGER, 
    CLASS_NAME VARCHAR, 
    JAR_PATH  VARCHAR, 
    RETURN_TYPE VARCHAR, 
    TYPE VARCHAR, 
    ARG_POSITION VARBINARY, 
    IS_ARRAY BOOLEAN, 
    IS_CONSTANT BOOLEAN, 
    DEFAULT_VALUE VARCHAR, 
    MIN_VALUE VARCHAR, 
    MAX_VALUE VARCHAR, 
    CONSTRAINT pk PRIMARY KEY (TENANT_ID, FUNCTION_NAME, TYPE, ARG_POSITION)
) VERSIONS=1000,KEEP_DELETED_CELLS=true,SPLIT_POLICY='org.apache.phoenix.schema.MetaDataSplitPolicy',TRANSACTIONAL=false

 

如果，您认为阅读这篇博客让您有些收获，不妨点击一下右下角的【推荐】。
如果，您希望更容易地发现我的新博客，不妨点击一下左下角的【关注我】。
如果，您对我的博客所讲述的内容有兴趣，请继续关注我的后续博客，我是【刘超★ljc】。

本文版权归作者和博客园共有，禁止转载，否则保留追究法律责任的权利。