phoenix系统创建语句

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88

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】。

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