CREATE TABLE "CDR"."CIS_ASSAY_SPEC_DETAIL" ( "PLA_BRANCH_CODE" VARCHAR2(12) NOT NULL ENABLE, "ID" VARCHAR2(32) NOT NULL ENABLE, "IS_EME" VARCHAR2(4) NOT NULL ENABLE, "REQUEST_NO" VARCHAR2(32) NOT NULL ENABLE, "SPEC_TYPE" VARCHAR2(16) NOT NULL ENABLE, "SEQ" VARCHAR2(4) NOT NULL ENABLE, "ORDER_ID" VARCHAR2(16), "APPA_ID" VARCHAR2(16), "IS_VALID" VARCHAR2(4), "CREATE_TIME" DATE, "MODIFY_TIME" DATE, "OLD_ROWID" VARCHAR2(64), "BUSINESS_SYSTEM_ID" NUMBER(9,0), CONSTRAINT "CIS_ASSAY_SPEC_DETAIL_R01" PRIMARY KEY ("PLA_BRANCH_CODE", "ID", "IS_EME", "REQUEST_NO", "SPEC_TYPE", "SEQ", "BUSINESS_SYSTEM_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CDR" ENABLE ) 转为hive版本
时间: 2023-07-19 10:55:16 浏览: 58
CREATE TABLE CDR.CIS_ASSAY_SPEC_DETAIL (
PLA_BRANCH_CODE STRING NOT NULL,
ID STRING NOT NULL,
IS_EME STRING NOT NULL,
REQUEST_NO STRING NOT NULL,
SPEC_TYPE STRING NOT NULL,
SEQ STRING NOT NULL,
ORDER_ID STRING,
APPA_ID STRING,
IS_VALID STRING,
CREATE_TIME TIMESTAMP,
MODIFY_TIME TIMESTAMP,
OLD_ROWID STRING,
BUSINESS_SYSTEM_ID BIGINT
)
PARTITIONED BY (dt STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\001'
STORED AS ORC
LOCATION '/user/hive/warehouse/CDR.db/CIS_ASSAY_SPEC_DETAIL';