（4.1）数仓搭建之ODS层报错报错4.1

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:For direct MetaStore DB connections, we don’t support retries at the client level.)

（1）create database hive default character set latin1;
grant all on . to ‘hive’@’%’ identified by ‘hive’;
flush privileges;
登录所安装的数据库，我这里是centos7自带的mariadb数据库，登进去之后，
1、删除hive， drop database hive;
2、重新创建hive， create database hive;
3、将字符集UTF-8修改为 latin1， alter database hive character set latin1;

备注：删除表失败也可以这样通过这一系列操作来解决。（前提各种配置文件都正确

（2）[hadoop@hadoop102 /opt/module/hadoop-2.7.2/etc/hadoop]$vim core-site.xml

io.compression.codecs

org.apache.hadoop.io.compress.GzipCodec,
org.apache.hadoop.io.compress.DefaultCodec,
org.apache.hadoop.io.compress.BZip2Codec,
org.apache.hadoop.io.compress.SnappyCodec,
com.hadoop.compression.lzo.LzoCodec,
com.hadoop.compression.lzo.LzopCodec

io.compression.codec.lzo.class com.hadoop.compression.lzo.LzoCodec （3） hive.metastore.warehouse.dir /usr/hive/warehouse