封存hive的metastore

保存hive的metastore
首先安装mysql，见：
http://running.iteye.com/blog/910277

修改字符集为latin1
13.修改my.cnf

set global binlog_format='MIXED';

READ-COMMITTED需要把bin-log以mixed方式来记录
否则进入hive，会如下错误
FAILED: Error in metadata: javax.jdo.JDOException: Couldnt obtain a new sequence (unique id) : Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'

查看更多 下一篇