org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
来源:互联网 发布:java 获取日期 编辑:程序博客网 时间:2024/06/05 16:32
I set Hive hadoop on CentOS of VMware of Mac. And I set Mysql on Mac. When I use ‘schematool -dbType mysql -initSchema’ command I got error blow.
Then I checked my hive-site.xml
<property> <name>javax.jdo.option.ConnectionPassword</name> <value>Root@123</value> <description>password to use against metastore database</description> </property> <property> <name>javax.jdo.option.ConnectionUserName</name> <value>root</value> <description>Username to use against metastore database</description> </property> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://192.168.168.1:3306/hive6</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> <description>Driver class name for a JDBC metastore</description> </property>
On the Mysql server, I did the flush privileges below:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Root@123'; Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)
Still got same Error..
At last I found the reason because I installed Mysql with Homebrew.
If you installed MySQL from brew it really does only listen on the local interface by default. To fix that you need to edit /usr/local/etc/my.cnf and change the bind-address from 127.0.0.1 to *.
Then run brew services restart mysql
.
阅读全文
0 0
- org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
- org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state wo
- 「Hive元数据问题」hive.metastore.HiveMetaException: Failed to get schema version.
- 通过CM启动hive报错.org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver
- CDH5.11.0安装启动hive过程org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver
- 解决 Failed to get schema version when starting Hive Metastore Service
- Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
- ambari安装hive遭遇Failed to get schema version
- Hive报错:Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
- org.apache.hadoop.hive.metastore.api.InvalidOperationException cannot be cast to java.lang.RuntimeEx
- Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient错误解决方法
- Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMe
- FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.
- hive异常 show tables 无法使用 : Unable to instantiate rg.apache.hadoop.hive.metastore.HiveMetaStoreClient
- hive错误 show tables 无法使用 : Unable to instantiate rg.apache.hadoop.hive.metastore.HiveMetaStoreClient
- Hive-异常处理Hive Schema version 2.3.0 does not match metastore's schema version 1.2.0 Metastore is not
- Hive On Spark报错:Failed to execute spark task, org.apache.hadoop.hive.ql.metadata.HiveException
- Caused by: MetaException(message:Hive Schema version 2.1.0 does not match metastore's schema version
- 史上最全的架构师图谱
- 14. Longest Common Prefix.cpp
- html手机页面开发模板
- jQuery的callback参数
- 如何提高测试工作效率
- org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
- Java学习笔记—JDBC(连接sqlserver)的用法
- ubuntu14.04手动更换内核方法
- AngularJs案例 购物车主页面
- 安卓集成mob并分享微信还有和朋友圈,以及分享完成的回调
- HDU 4333 Revolving Digits
- TCP/IP协议分层结构趣味解读
- mysqldump工具使用帮助文档(mysql数据库备份)
- java 的HashMap底层数据结构