-- A typical wrong case
CREATE SCHEMA CREATE_TBL_INIT_TD_CHECK;

DROP TABLE IF EXISTS CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_1;
CREATE TABLE CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_1
(
ID NUMBER(20) NOT NULL,
VARCHAR2_1 VARCHAR2(40)
)WITH(INIT_TD=10, STORAGE_TYPE=ASTORE);

DROP TABLE IF EXISTS CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_2;
CREATE TABLE CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_2
(
ID NUMBER(20) NOT NULL,
VARCHAR2_1 VARCHAR2(40)
)WITH(INIT_TD=10, ORIENTATION=COLUMN);

DROP TABLE IF EXISTS CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_3;
CREATE TABLE CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_3
(
ID NUMBER(20) NOT NULL,
VARCHAR2_1 VARCHAR2(40)
)WITH(INIT_TD=10, ORIENTATION=ROW);

-- right cases
DROP TABLE IF EXISTS CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_4;
CREATE TABLE CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_4
(
ID NUMBER(20) NOT NULL,
VARCHAR2_1 VARCHAR2(40)
)WITH(ORIENTATION=ROW,STORAGE_TYPE=USTORE, INIT_TD=10);

DROP TABLE IF EXISTS CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_5;
CREATE TABLE CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_5
(
ID NUMBER(20) not null,
VARCHAR2_1 VARCHAR2(40)
)with(INIT_TD=10,STORAGE_TYPE=USTORE);

set enable_default_ustore_table = on;
DROP TABLE IF EXISTS CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_7;
CREATE TABLE CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_7
(
ID NUMBER(20) not null,
VARCHAR2_1 VARCHAR2(40)
)with(INIT_TD=10);

set enable_default_ustore_table = off;
DROP TABLE IF EXISTS CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_6;
CREATE TABLE CREATE_TBL_INIT_TD_CHECK.T_INIT_TD_6
(
ID NUMBER(20) not null,
VARCHAR2_1 VARCHAR2(40)
)with(INIT_TD=10);
DROP SCHEMA CREATE_TBL_INIT_TD_CHECK CASCADE;

CREATE TABLE TEST_ORC_TBL(A INT, B INT, PRIMARY KEY(A,B)) WITH (hashbucket=on, orientation=orc);
DROP TABLE IF EXISTS TEST_ORC_TBL;
CREATE TABLE TEST_row_TBL(A INT, B INT, PRIMARY KEY(A,B)) WITH (orientation=row);
DROP TABLE IF EXISTS TEST_ROW_TBL;
CREATE TABLE TEST_COLUMN_TBL(A INT, B INT, PRIMARY KEY(A,B)) WITH (orientation=column);
DROP TABLE IF EXISTS TEST_COLUMN_TBL;
CREATE TABLE TEST_TIMESERIES_TBL(A INT, B INT, PRIMARY KEY(A,B)) WITH (orientation=timeseries);
DROP TABLE IF EXISTS TEST_TIMESERIES_TBL;