Hive No enum constant org.apache.hadoop.hive.ql.io.orc.CompressionKind.snappy

No enum constant org.apache.hadoop.hive.ql.io.orc.CompressionKind.snappy

建表 

drop table if exists `conf_base_source`;
create table if not exists `conf_base_source`  (
  `id` int comment 'id',
  `source_name` string comment '媒体名称',
  `add_time` string comment '添加时间'
) comment '媒体表' 
row format delimited fields terminated by '\t' 
stored as orc
location 'hdfs://BigdataCluster/user/hive/warehouse/hw_data.db/conf/conf_hw_base_source'
tblproperties ("orc.compress"="snappy");

Spark向Hive写入数据报错

Caused by: java.lang.IllegalArgumentException: No enum constant org.apache.hadoop.hive.ql.io.orc.CompressionKind.snappy

解决：

修改 snappy 为大写

tblproperties ("orc.compress"="SNAPPY");