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,
