好久没有玩hive了上来就给我报错
查了下原因：官网给的例子，也是要求tblproperties(‘parquet.compression’=‘snappy’)属性，需要放在最后面
修改后的如下
create table if not exists default.student_tb_txt3(
s_no string comment '学号',
s_name string comment '姓名',
s_birth string comment '生日',
s_age bigint comment '年龄',
s_sex string comment '性别',
s_score bigint comment '综合能力得分',
s_desc string comment '自我介绍'
)row format delimited fields terminated by '\t'
location '/mnt/data/bigdata/hive/warehouse/student_tb_txt/'
tblproperties('parquet.compression'='snappy');
INFO : Starting task [Stage-0:DDL] in serial mode
INFO : Completed executing command(queryId=hive_20210712181440_5213b453-9963-4552-9833-11dd4b9c33bc); Time taken: 0.421 seconds
INFO : OK