hadoop踩过的那些坑 之 hive篇

大神（LY）已经搭建好了hadoop生态圈，忍不住也想小试伸手进到ambari发现alert有错误告警，就想搞定它

这分明就是jdbc报错了，于是看hive日志

Could not create "increment"/"table" value-generation container hive.`SEQUENCE_TABLE` since autoCreate flags do not allow it.org.datanucleus.exceptions.NucleusUserException: Could not create "increment"/"table" value-generation container hive.`SEQUENCE_TABLE` since autoCreate flags do not allow it.        at org.datanucleus.store.rdbms.valuegenerator.TableGenerator.createRepository(TableGenerator.java:261)        at org.datanucleus.store.rdbms.valuegenerator.AbstractRDBMSGenerator.obtainGenerationBlock(AbstractRDBMSGenerator.java:162)        at org.datanucleus.store.valuegenerator.AbstractGenerator.obtainGenerationBlock(AbstractGenerator.java:197)

应该是Mysql配置的问题

于是配置Mysql

mysql> SET SESSION binlog_format = 'MIXED';mysql> SET GLOBAL binlog_format = 'MIXED';

ambari重启hiveserver2，alert报的错没了

端口查看，也起来了！

哇咔咔，妥妥的

还有个问题

果断Hive Metastore 重启

Alerts没有错误了，哇咔咔