create user 'hive'@'%' identified by 'hive';
GRANT ALL PRIVILEGES ON*.* TO 'hive'@'%' Identified by 'hive';
使用mysql 存储 metastore 配置中注意三个问题
1.配置文件2005行<autho> ---></value>
2.hive.metastore.schema.verification ==>设置为false
就不会报错了
3.创建语句报错 specified key was too long。。。。
alter database hive character set latin1