[jira] [Created] (AMBARI-5327) Hive start fails on centos5

["Dmytro Sen (JIRA)" <ji...@apache.org>]

Dmytro Sen created AMBARI-5327:
----------------------------------

             Summary: Hive start fails on centos5
                 Key: AMBARI-5327
                 URL: https://issues.apache.org/jira/browse/AMBARI-5327
             Project: Ambari
          Issue Type: Bug
          Components: controller
    Affects Versions: 1.5.1
         Environment: CentOS5
            Reporter: Dmytro Sen
            Assignee: Dmytro Sen
             Fix For: 1.5.1


{noformat}
2014-04-02 13:18:58,284 - Error while executing command 'start':
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 95, in execute
    method(env)
  File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive_metastore.py", line 42, in start
    self.configure(env) # FOR SECURITY
  File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive_metastore.py", line 37, in configure
    hive(name='metastore')
  File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive.py", line 94, in hive
    not_if = check_schema_created_cmd
  File "/usr/lib/python2.6/site-packages/resource_management/core/base.py", line 148, in __init__
    self.env.run()
  File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 149, in run
    self.run_action(resource, action)
  File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 115, in run_action
    provider_action()
  File "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py", line 239, in action_run
    raise ex
Fail: Execution of '/usr/lib/hive/bin/schematool -initSchema -dbType mysql -userName hive -passWord asd' returned 1. Metastore connection URL:	 jdbc:mysql://c5901.ambari.apache.org/hive?createDatabaseIfNotExist=true
Metastore Connection Driver :	 com.mysql.jdbc.Driver
Metastore connection User:	 hive
Starting metastore schema initialization to 0.13.0
Initialization script hive-schema-0.13.0.mysql.sql
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING HASH' at line 1 (state=42000,code=1064)
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !!
*** schemaTool failed ***
{noformat}

MySQL version:
{noformat}
[root@c5901 ~]# rpm -qa | grep mysql
mysql-connector-java-5.1.12-2.el5
mysql-server-5.0.95-5.el5_9
mysql-5.0.95-5.el5_9
{noformat}

HDP 2.1



--
This message was sent by Atlassian JIRA
(v6.2#6252)