You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ambari.apache.org by guxiaobo1982 <gu...@qq.com> on 2015/04/22 11:19:07 UTC
Ambari 2.0 can't start hive metastore
Hi,
I am trying to install a single node cluster with Ambari 2.0, but the metastore service can't be created with the following error:
Fail: Execution of 'export HIVE_CONF_DIR=/etc/hive/conf.server ; /usr/hdp/current/hive-metastore/bin/schematool -initSchema -dbType mysql -userName hive -passWord [PROTECTED]' returned 1. Metastore connection URL: jdbc:mysql://lix2.bh.com/hive?createDatabaseIfNotExist=true Metastore Connection Driver : com.mysql.jdbc.Driver Metastore connection User: hive org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version. *** schemaTool failed ***I tried to execute the exact command on command line, but with the same error, any solution for this?export HIVE_CONF_DIR=/etc/hive/conf.server ; /usr/hdp/current/hive-metastore/bin/schematool -initSchema -dbType mysql -userName hive -passWord [PROTECTED]Regards,
Re: Ambari 2.0 can't start hive metastore
Posted by guxiaobo1982 <gu...@qq.com>.
I fixed the problem myself, I should specify the mysql jdbc driver path at ambari setup command, that is a big change not mentioned in the document.
ambari-server setup --jdbc-db=mysql --jdbc-driver=/path/to/mysql/driver.jar
------------------ Original ------------------
From: "guxiaobo1982";<gu...@qq.com>;
Send time: Wednesday, Apr 22, 2015 6:36 PM
To: "user"<us...@ambari.apache.org>;
Subject: Re: Ambari 2.0 can't start hive metastore
This is what I got at the terminal:
[root@lix2 xiaobogu]# export HIVE_CONF_DIR=/etc/hive/conf.server ; /usr/hdp/current/hive-metastore/bin/schematool -initSchema -dbType mysql -userName hive -passWord hive
Metastore connection URL: jdbc:mysql://lix2.bh.com/hive?createDatabaseIfNotExist=true
Metastore Connection Driver : com.mysql.jdbc.Driver
Metastore connection User: hive
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
*** schemaTool failed ***
------------------ Original ------------------
From: "guxiaobo1982";<gu...@qq.com>;
Send time: Wednesday, Apr 22, 2015 5:19 PM
To: "user"<us...@ambari.apache.org>;
Subject: Ambari 2.0 can't start hive metastore
Hi,
I am trying to install a single node cluster with Ambari 2.0, but the metastore service can't be created with the following error:
Fail: Execution of 'export HIVE_CONF_DIR=/etc/hive/conf.server ; /usr/hdp/current/hive-metastore/bin/schematool -initSchema -dbType mysql -userName hive -passWord [PROTECTED]' returned 1. Metastore connection URL: jdbc:mysql://lix2.bh.com/hive?createDatabaseIfNotExist=true Metastore Connection Driver : com.mysql.jdbc.Driver Metastore connection User: hive org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version. *** schemaTool failed ***I tried to execute the exact command on command line, but with the same error, any solution for this?export HIVE_CONF_DIR=/etc/hive/conf.server ; /usr/hdp/current/hive-metastore/bin/schematool -initSchema -dbType mysql -userName hive -passWord [PROTECTED]Regards,
Re: Ambari 2.0 can't start hive metastore
Posted by guxiaobo1982 <gu...@qq.com>.
This is what I got at the terminal:
[root@lix2 xiaobogu]# export HIVE_CONF_DIR=/etc/hive/conf.server ; /usr/hdp/current/hive-metastore/bin/schematool -initSchema -dbType mysql -userName hive -passWord hive
Metastore connection URL: jdbc:mysql://lix2.bh.com/hive?createDatabaseIfNotExist=true
Metastore Connection Driver : com.mysql.jdbc.Driver
Metastore connection User: hive
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
*** schemaTool failed ***
------------------ Original ------------------
From: "guxiaobo1982";<gu...@qq.com>;
Send time: Wednesday, Apr 22, 2015 5:19 PM
To: "user"<us...@ambari.apache.org>;
Subject: Ambari 2.0 can't start hive metastore
Hi,
I am trying to install a single node cluster with Ambari 2.0, but the metastore service can't be created with the following error:
Fail: Execution of 'export HIVE_CONF_DIR=/etc/hive/conf.server ; /usr/hdp/current/hive-metastore/bin/schematool -initSchema -dbType mysql -userName hive -passWord [PROTECTED]' returned 1. Metastore connection URL: jdbc:mysql://lix2.bh.com/hive?createDatabaseIfNotExist=true Metastore Connection Driver : com.mysql.jdbc.Driver Metastore connection User: hive org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version. *** schemaTool failed ***I tried to execute the exact command on command line, but with the same error, any solution for this?export HIVE_CONF_DIR=/etc/hive/conf.server ; /usr/hdp/current/hive-metastore/bin/schematool -initSchema -dbType mysql -userName hive -passWord [PROTECTED]Regards,