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";<[email protected]>; Send time: Wednesday, Apr 22, 2015 6:36 PM To: "user"<[email protected]>; 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";<[email protected]>; Send time: Wednesday, Apr 22, 2015 5:19 PM To: "user"<[email protected]>; 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,
