hive 以like方式建表(携带表结构)

hive建表语句：

CREATE TABLE hive_ttt_999(
id bigint COMMENT 'ID，主键',
name string COMMENT '姓名',
address string COMMENT '地址',
mobile string COMMENT '手机号',
other_info string COMMENT '其他信息',
tenant_id string COMMENT '租户ID',
created_by string COMMENT '创建者',
created_time string COMMENT '创建时间',
updated_time string COMMENT '更新时间',
updated_by string COMMENT '更新者',
version bigint COMMENT '版本号，乐观锁',
is_deleted bigint COMMENT '是否删除')
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
'field.delim'='|',
'serialization.format'='|')
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
'hdfs://nameservice1/user/hive/warehouse/ttt.db/hive_ttt_999'
TBLPROPERTIES (
'transient_lastDdlTime'='1629364931')
创建表：(以hive_ttt_999为模板)

use ttt;
create table burrowsTest_0 like hive_ttt_999;

用此脚本实现批量打印所需建表/删表语句
num = 3200
target_table = 'dct_test_from'

for x in range(800, num):
print(f'create table hive_ttt_{x} like {target_table};')
#print(f'drop table hive_ttt_{x};')
#print(f"create index hive_ttt_index_{x} on table hive_ttt_{x}(id) as 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' with deferred rebuild;")

给hive表建索引

create index index_01 on table hive_ttt_999(id) as 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' with deferred rebuild;