HUABASE supports the following data types.docx

1、HUABASE supports the following data typesHUABASE supports the following data types:INTEGERBOOLEANREAL / FLOATDOUBLEDATETIMETIMESTAMPBLOBCOBCHAR (0 - 2000)VARCHAR (0 - 2000)BINARY (0 - 4000)VARBINARY (0 - 4000)LONGVARCHARLONGVARBINARYNUMERIC DEF-SCHEMA-TABLE DEF_SCHEMA_USERSCOLUMNS:USER_ID INTEGERUSE

2、R_NAME VARCHAR(128)PASSWORD VARCHAR(128)USER_TYPE CHAR(1)PRIMARY_KEY:USER_IDDEF-SCHEMA-TABLE DEF_SCHEMA_TABLE_SPACESCOLUMNS:TABLE_SPACE_ID INTEGERTABLE_SPACE_NAME VARCHAR(128)META_DATA_BLOCK_ID LONGPRIMARY_KEY:TABLE_SPACE_IDDEF-SCHEMA-TABLE DEF_SDEF-SCHEMA-TABLECHEMA_DATA_FILESCOLUMNS:TABLE_SPACE_ID

3、 INTEGERFILE_INDEX INTEGERFILE_PATH VARCHAR(512)INI_CAPACITY VARCHAR(128)INC_CAPACITY VARCHAR(128)MAX_CAPACITY VARCHAR(128)PRIMARY_KEY:TABLE_SPACE_IDFILE_INDEXFOREIGN_KEY: tableSpaceIdFkTABLE_SPACE_ID referencesDEF_SCHEMA_TABLE_SPACESDEF-SCHEMA-TABLE DEF_SCHEMA_SCHEMASCOLUMNS:SCHEMA_ID INTEGERSCHEMA

4、_NAME VARCHAR(128)USER_ID INTEGERTABLE_SPACE_ID INTEGERMETA_DATA_BLOCK_ID LONGPRIMARY_KEY:SCHEMA_IDFOREIGN_KEY: userIdFkUSER_ID referencesDEF_SCHEMA_USERSFOREIGN_KEY: tableSpaceIdFkTABLE_SPACE_ID referencesDEF_SCHEMA_TABLE_SPACESDEF-SCHEMA-TABLE DEF_SCHEMA_DOMAINSCOLUMNS:SCHEMA_ID INTEGERDOMAIN_ID I

5、NTEGERDOMAIN_NAME VARCHAR(128)DOMAIN_DATA_TYPE VARBINARY(1024)DOMAIN_DEFAULT VARBINARY(1024)PRIMARY_KEY:SCHEMA_IDDOMAIN_IDFOREIGN_KEY: schemaIdFkSCHEMA_ID referencesDEF_SCHEMA_SCHEMASDEF-SCHEMA-TABLE DEF_SCHEMA_TABLESCOLUMNS:SCHEMA_ID INTEGERTABLE_ID INTEGERTABLE_NAME VARCHAR(128)COLUMN_ID INTEGERPR

6、IMARY_KEY:SCHEMA_IDTABLE_IDFOREIGN_KEY: schemaIdFkSCHEMA_ID referencesDEF_SCHEMA_SCHEMASDEF-SCHEMA-TABLE DEF_SCHEMA_TABLE_PARTITIONSCOLUMNS:SCHEMA_ID INTEGERTABLE_ID INTEGERPARTITION_ID INTEGERPARTITION_NAME VARCHAR(128)PARTITION_RULE VARBINARY(1024)TABLE_SPACE_ID INTEGERPRIMARY_KEY:SCHEMA_IDTABLE_I

7、DPARTITION_IDFOREIGN_KEY: tableIdFkSCHEMA_IDTABLE_ID referencesDEF_SCHEMA_TABLESFOREIGN_KEY: tableSpaceIdFkTABLE_SPACE_ID referencesDEF_SCHEMA_TABLE_SPACESDEF-SCHEMA-TABLE DEF_SCHEMA_TABLE_PARTITION_SEGMENTSCOLUMNS:SCHEMA_ID INTEGERTABLE_ID INTEGERPARTITION_ID INTEGERSEGMENT_ID INTEGERMETA_DATA_BLOC

8、K_ID LONGPRIMARY_KEY:SCHEMA_IDTABLE_IDPARTITION_IDSEGMENT_IDFOREIGN_KEY: partitionNameFkSCHEMA_IDTABLE_IDPARTITION_ID referencesDEF_SCHEMA_TABLE_PARTITIONSDEF-SCHEMA-TABLE DEF_SCHEMA_VIEWSCOLUMNS:SCHEMA_ID INTEGERVIEW_ID INTEGERVIEW_NAME VARCHAR(128)VIEW_DEFINITION_TXT CLOBVIEW_DEFINITION_BIN BLOBCH

9、ECK_OPTION CHAR(1)PRIMARY_KEY:SCHEMA_IDVIEW_IDFOREIGN_KEY: schemaIdFkSCHEMA_ID referencesDEF_SCHEMA_SCHEMASDEF-SCHEMA-TABLE DEF_SCHEMA_COLUMNSCOLUMNS:SCHEMA_ID INTEGERTABLE_ID INTEGERCOLUMN_ID INTEGERCOLUMN_NAME VARCHAR(128)DOMAIN_ID INTEGERIS_SORT_INDEX BOOLEANCOLUMN_DEFAULT VARBINARY(1024)IS_NULLA

10、BLE BOOLEANIS_AUTO_INCREMENT BOOLEANPRIMARY_KEY:SCHEMA_IDTABLE_IDCOLUMN_IDFOREIGN_KEY: tableIdFkSCHEMA_IDTABLE_ID referencesDEF_SCHEMA_TABLESFOREIGN_KEY: domainIdFkSCHEMA_IDDOMAIN_ID referencesDEF_SCHEMA_DOMAINSDEF-SCHEMA-TABLE DEF_SCHEMA_TABLE_PARTITION_SEGMENT_COLUMNSCOLUMNS:SCHEMA_ID INTEGERTABLE

11、_ID INTEGERPARTITION_ID INTEGERSEGMENT_ID INTEGERCOLUMN_ID INTEGERVALUE_INDEX_META_DATA_BLOCK_ID LONGLINK_INDEX_META_DATA_BLOCK_ID LONGMETA_DATA_BLOCK_ID LONGPRIMARY_KEY:SCHEMA_IDTABLE_IDPARTITION_IDSEGMENT_IDCOLUMN_IDFOREIGN_KEY: partitionSegmentIdFkSCHEMA_IDTABLE_IDPARTITION_IDSEGMENT_ID reference

12、sDEF_SCHEMA_TABLE_PARTITION_SEGMENTSFOREIGN_KEY: columnIdFkSCHEMA_IDTABLE_IDCOLUMN_ID referencesDEF_SCHEMA_COLUMNSDEF-SCHEMA-TABLE DEF_SCHEMA_VIEW_TABLE_USAGESCOLUMNS:SCHEMA_ID INTEGERVIEW_ID INTEGERTABLE_ID INTEGERPRIMARY_KEY:SCHEMA_IDVIEW_IDTABLE_IDFOREIGN_KEY: tableIdFkSCHEMA_IDTABLE_ID reference

13、sDEF_SCHEMA_TABLESDEF-SCHEMA-TABLE DEF_SCHEMA_VIEW_COLUMN_USAGESCOLUMNS:SCHEMA_ID INTEGERVIEW_ID INTEGERTABLE_ID INTEGERCOLUMN_ID INTEGERPRIMARY_KEY:SCHEMA_IDVIEW_IDTABLE_IDCOLUMN_IDFOREIGN_KEY: viewIdFkSCHEMA_IDVIEW_ID referencesDEF_SCHEMA_VIEWSFOREIGN_KEY: columnIdFkSCHEMA_IDTABLE_IDCOLUMN_ID refe

14、rencesDEF_SCHEMA_COLUMNSDEF-SCHEMA-TABLE DEF_SCHEMA_KEY_TABLE_CONSTRAINTSCOLUMNS:SCHEMA_ID INTEGERTABLE_ID INTEGERCONSTRAINT_ID INTEGERCONSTRAINT_NAME VARCHAR(128)KEY_TYPE CHAR(1)IS_DEFERRABLE BOOLEANINITIALLY_DEFERRED BOOLEANPRIMARY_KEY:SCHEMA_IDTABLE_IDCONSTRAINT_IDFOREIGN_KEY: tableIdFkSCHEMA_IDT

15、ABLE_ID referencesDEF_SCHEMA_TABLESDEF-SCHEMA-TABLE DEF_SCHEMA_CHECK_TABLE_CONSTRAINTSCOLUMNS:SCHEMA_ID INTEGERTABLE_ID INTEGERCONSTRAINT_ID INTEGERCONSTRAINT_NAME VARCHAR(128)CHECK_CLAUSE VARBINARY(1024)IS_DEFERRABLE BOOLEANINITIALLY_DEFERRED BOOLEANPRIMARY_KEY:SCHEMA_IDTABLE_IDCONSTRAINT_IDFOREIGN

16、_KEY: tableIdFkSCHEMA_IDTABLE_ID referencesDEF_SCHEMA_TABLESDEF-SCHEMA-TABLE DEF_SCHEMA_KEY_COLUMN_USAGESCOLUMNS:SCHEMA_ID INTEGERTABLE_ID INTEGERCONSTRAINT_ID INTEGERCOLUMN_ID INTEGERPRIMARY_KEY:SCHEMA_IDTABLE_IDCONSTRAINT_IDCOLUMN_IDFOREIGN_KEY: columnIdFkSCHEMA_IDTABLE_IDCOLUMN_ID referencesDEF_S

17、CHEMA_COLUMNSFOREIGN_KEY: constraintNameFkSCHEMA_IDTABLE_IDCONSTRAINT_ID referencesDEF_SCHEMA_KEY_TABLE_CONSTRAINTSDEF-SCHEMA-TABLE DEF_SCHEMA_REFERENTIAL_CONSTRAINTSCOLUMNS:SCHEMA_ID INTEGERTABLE_ID INTEGERCONSTRAINT_ID INTEGERCONSTRAINT_NAME VARCHAR(128)REF_TABLE_ID INTEGERREF_UNIQUE_CONSTRAINT_ID

18、 INTEGERMATCH_OPTION CHAR(1)UPDATE_RULE CHAR(1)DELETE_RULE CHAR(1)PRIMARY_KEY:SCHEMA_IDTABLE_IDCONSTRAINT_IDFOREIGN_KEY: uniqueConstraintIdFkSCHEMA_IDREF_TABLE_IDREF_UNIQUE_CONSTRAINT_ID referencesDEF_SCHEMA_KEY_TABLE_CONSTRAINTSDEF-SCHEMA-TABLE DEF_SCHEMA_CHECK_COLUMN_CONSTRAINTSCOLUMNS:SCHEMA_ID I

19、NTEGERTABLE_ID INTEGERCOLUMN_ID INTEGERCONSTRAINT_ID INTEGERCONSTRAINT_NAME VARCHAR(128)CHECK_CLAUSE VARBINARY(1024)IS_DEFERRABLE BOOLEANINITIALLY_DEFERRED BOOLEANPRIMARY_KEY:SCHEMA_IDTABLE_IDCOLUMN_IDCONSTRAINT_IDFOREIGN_KEY: tableIdFkSCHEMA_IDTABLE_IDCOLUMN_ID referencesDEF_SCHEMA_COLUMNSDEF-SCHEM

20、A-TABLE DEF_SCHEMA_CHECK_DOMAIN_CONSTRAINTSCOLUMNS:SCHEMA_ID INTEGERDOMAIN_ID INTEGERCONSTRAINT_ID INTEGERCONSTRAINT_NAME VARCHAR(128)CHECK_CLAUSE VARBINARY(1024)IS_DEFERRABLE BOOLEANINITIALLY_DEFERRED BOOLEANPRIMARY_KEY:SCHEMA_IDDOMAIN_IDCONSTRAINT_IDFOREIGN_KEY: tableIdFkSCHEMA_IDDOMAIN_ID referen

21、cesDEF_SCHEMA_DOMAINSDEF-SCHEMA-TABLE DEF_SCHEMA_CHECK_CONSTRAINTSCOLUMNS:SCHEMA_ID INTEGERCONSTRAINT_ID INTEGERCHECK_CLAUSE VARBINARY(1024)PRIMARY_KEY:SCHEMA_IDCONSTRAINT_IDFOREIGN_KEY: schemaIdFkSCHEMA_ID referencesDEF_SCHEMA_SCHEMASDEF-SCHEMA-TABLE DEF_SCHEMA_CHECK_TABLE_USAGESCOLUMNS:SCHEMA_ID I

22、NTEGERCONSTRAINT_ID INTEGERTABLE_ID INTEGERPRIMARY_KEY:SCHEMA_IDCONSTRAINT_IDTABLE_IDFOREIGN_KEY: constraintIdFkSCHEMA_IDCONSTRAINT_ID referencesDEF_SCHEMA_CHECK_CONSTRAINTSFOREIGN_KEY: tableIdFkSCHEMA_IDTABLE_ID referencesDEF_SCHEMA_TABLESDEF-SCHEMA-TABLE DEF_SCHEMA_CHECK_COLUMN_USAGESCOLUMNS:SCHEM

23、A_ID INTEGERCONSTRAINT_ID INTEGERTABLE_ID INTEGERCOLUMN_ID INTEGERPRIMARY_KEY:SCHEMA_IDCONSTRAINT_IDTABLE_IDCOLUMN_IDFOREIGN_KEY: constraintIdFkSCHEMA_IDCONSTRAINT_ID referencesDEF_SCHEMA_CHECK_CONSTRAINTSFOREIGN_KEY: columnNameFkSCHEMA_IDTABLE_IDCOLUMN_ID referencesDEF_SCHEMA_COLUMNSDEF-SCHEMA-TABL

24、E DEF_SCHEMA_ASSERTONSCOLUMNS:SCHEMA_ID INTEGERCONSTRAINT_ID INTEGERIS_DEFERRABLE BOOLEANINITIALLY_DEFERRED BOOLEANPRIMARY_KEY:SCHEMA_IDCONSTRAINT_IDFOREIGN_KEY: constrainIdFkSCHEMA_IDCONSTRAINT_ID referencesDEF_SCHEMA_CHECK_CONSTRAINTSDEF-SCHEMA-TABLE DEF_SCHEMA_TABLE_PRIVILEGESCOLUMNS:GRANTOR INTE

25、GERGRANTEE INTEGERSCHEMA_ID INTEGERTABLE_ID INTEGERPRIVILEGE_TYPE CHAR(1) / SELECT, INSERT, DELETE, UPDATEREFERENCESIS_GRANTABLE BOOLEANPRIMARY_KEY:GRANTORGRANTEESCHEMA_IDTABLE_IDPRIVILEGE_TYPEFOREIGN_KEY: tableIdFkSCHEMA_IDTABLE_ID referencesDEF_SCHEMA_TABLESFOREIGN_KEY: grantorFkGRANTOR references

26、DEF_SCHEMA_USERSFOREIGN_KEY: granteeFkGRANTEE referencesDEF_SCHEMA_USERSDEF-SCHEMA-TABLE DEF_SCHEMA_COLUMN_PRIVILEGESCOLUMNS:GRANTOR INTEGERGRANTEE INTEGERSCHEMA_ID INTEGERTABLE_ID INTEGERCOLUMN_ID INTEGERPRIVILEGE_TYPE VARCHAR(128)IS_GRANTABLE BOOLEANPRIMARY_KEY:GRANTORGRANTEESCHEMA_IDTABLE_IDCOLUM

27、N_IDPRIVILEGE_TYPEFOREIGN_KEY: columnIdFkSCHEMA_IDTABLE_IDCOLUMN_ID referencesDEF_SCHEMA_COLUMNSFOREIGN_KEY: grantorFkGRANTOR referencesDEF_SCHEMA_USERSFOREIGN_KEY: granteeFkGRANTEE referencesDEF_SCHEMA_USERSDEF-SCHEMA-TABLE DEF_SCHEMA_COLUMN_SEQUENCESCOLUMNS:SCHEMA_ID INTEGERTABLE_ID INTEGERCOLUMN_

28、ID INTEGERSEQUENCE_ID LONGPRIMARY_KEY:SCHEMA_IDTABLE_IDCOLUMN_IDSEQUENCE_IDFOREIGN_KEY: columnIdFkSCHEMA_IDTABLE_IDCOLUMN_ID referencesDEF_SCHEMA_COLUMNSDEF-SCHEMA-TABLE DEF_SCHEMA_SEQUENCESCOLUMNS:SEQUENCE_ID LONGSEQUENCE_NAME VARCHAR(128)SEQUENCE_CACHE INTEGERSEQUENCE_DATA_BLOCK_ID LONGPRIMARY_KEY:SEQUENCE_ID