下面是错误代码中所涉及的各表的建表语句：

transtbl

DROP TABLE IF EXISTS transtbl;
create table transtbl(a int, b int) clustered by (a) into 5 buckets stored as orc tblproperties('transactional'='true');

transtbl1

DROP TABLE IF EXISTS transtbl1;
create table transtbl1(a int, b int) clustered by (a) into 5 buckets stored as orc tblproperties('transactional'='true');

transtbl2

DROP TABLE IF EXISTS transtbl2;
create table transtbl2(a int, b int) clustered by (a) into 5 buckets stored as orc tblproperties('transactional'='true');

transtbl3

DROP TABLE IF EXISTS transtbl3;
create table transtbl3(a int, b int) clustered by (a) into 5 buckets stored as orc tblproperties('transactional'='true');

student_part

DROP TABLE IF EXISTS student_part;
create table student_part(student_id bigint, name string, date_of_birth string) partitioned by (class int,sex varchar(2)) clustered by (student_id) into 5 buckets stored as orc tblproperties('transactional'='true');

std_part

DROP TABLE IF EXISTS std_part;
CREATE TABLE std_part (id int) PARTITIONED BY (class INT, sex CHAR(2));

student_part1

DROP TABLE IF EXISTS student_part1;
create table student_part1(student_id bigint, name string, date_of_birth string) partitioned by (class int,sex varchar(2)) clustered by (student_id) into 5 buckets stored as orc tblproperties('transactional'='true');

student_part2

DROP TABLE IF EXISTS student_part2;
create table student_part2(student_id bigint, name string, date_of_birth string) partitioned by (class int,sex varchar(2)) clustered by (student_id) into 5 buckets stored as orc tblproperties('transactional'='true');

student_info

DROP TABLE IF EXISTS student_info;
create table student_info(student_id bigint, name string, date_of_birth string, class int, sex varchar(2))
clustered by (student_id) into 5 buckets stored as orc tblproperties('transactional'='true');
insert into table student_info values(1,'xingyu','92-03-25',1,'fe');

student

DROP TABLE IF EXISTS student;
create table student(id int, name string);

studentA

drop table if exists studentA;
create table studentA (id int, name string, class int);

studentB

drop table if exists studentB;
create table studentB (id int, name string, class int);

manager_employee_info

DROP TABLE IF EXISTS manager_employee_info;
create table manager_employee_info(manager_id int, name string, employee_id int);

t

drop table if exists t;
create table t(i int);

tt

drop table if exists tt;
create table tt(t int);

orc_tbl_1

DROP TABLE IF EXISTS orc_tb_1;
CREATE TABLE orc_tb_1 (a INT, b INT, c INT)
CLUSTERED BY (a) INTO 5 BUCKETS
STORED AS ORC
TBLPROPERTIES ('transactional' = 'true');

table_array2

drop table if exists table_array2;
CREATE TABLE table_array2(ids array<char(2)>, values array<int>);

user_info

drop table if exists user_info;
create table user_info (id int, name string) PARTITIONED BY (value INT);

user_name

drop table if exists user_name;
create table user_name(name string);

table_name

drop table if exists table_name;
create table table_name (name string) partitioned by (dt string);

employee

DROP TABLE IF EXISTS employee;
CREATE EXTERNAL TABLE employee ( 
   id int NOT NULL, 
   name string,
   age tinyint,
   degree string,
   onboard int 
)
CLUSTERED BY(id) INTO 5 BUCKETS STORED AS ORC
TBLPROPERTIES('transactional'='true')
LOG ERRORS INTO employee_error_table  
SEGMENT REJECT LIMIT 2 rows;

employee1

DROP TABLE IF EXISTS employee1;
CREATE EXTERNAL TABLE employee1 ( 
   id int NOT NULL, 
   name string,
   age tinyint,
   degree string,
   onboard int 
)
CLUSTERED BY(id) INTO 5 BUCKETS STORED AS ORC
TBLPROPERTIES('transactional'='true')
LOG ERRORS INTO employee_error_table1  
SEGMENT REJECT LIMIT 2 rows;

seq_student

drop sequence if exists seq_student;
create sequence seq_student increment by 1 start with 1 maxvalue 2 minvalue 0 cycle cache 10;

score_info

DROP TABLE IF EXISTS score_info;

create table score_info(student_id bigint, course_id bigint, score int);

course_info

DROP TABLE IF EXISTS course_info;

create table course_info(course_id bigint, name string);

transactions

drop table if exists transactions;
create table transactions (trans_id bigint, trans_type char(2), price float, amount int, trans_date date);

structtbl

drop table if exists structtbl;
create table structtbl(a struct<age:int, class:int>, b int);

ees_tbl

DROP TABLE IF EXISTS ees_tbl;
CREATE TABLE ees_tbl(key STRING, a INT) STORED AS ES;

part_hypertbl

DROP TABLE IF EXISTS part_hypertbl;
CREATE TABLE part_hypertbl(
   key int
   , a int
   , b int
) PARTITIONED BY (c int)
STORED AS HYPERDRIVE;