【异常】ERROR main:com.cloudera.enterprise.dbutil.SqlFileRunner: Exception while executing ddl scripts. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ROLES' already exists

1 详细异常

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161

2019-10-11 10:33:55,865 INFO main:com.cloudera.server.cmf.Main: ================================================================================ 2019-10-11 10:33:55,884 INFO main:com.cloudera.server.cmf.Main: Starting SCM Server. JVM Args: [-Dlog4j.configuration=file:/opt/cloudera-manager/cm-5.16.1/etc/cloudera-scm-server/log4j.properties, -Dfile.encoding=UTF-8, -Dcmf.root.logger=INFO,LOGFILE, -Dcmf.log.dir=/opt/cloudera-manager/cm-5.16.1/log/cloudera-scm-server, -Dcmf.log.file=cloudera-scm-server.log, -Dcmf.jetty.threshhold=WARN, -Dcmf.schema.dir=/opt/cloudera-manager/cm-5.16.1/share/cmf/schema, -Djava.awt.headless=true, -Djava.net.preferIPv4Stack=true, -Dpython.home=/opt/cloudera-manager/cm-5.16.1/share/cmf/python, -XX:+UseConcMarkSweepGC, -XX:+UseParNewGC, -XX:+HeapDumpOnOutOfMemoryError, -Xmx2G, -XX:MaxPermSize=256m, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=/tmp, -XX:OnOutOfMemoryError=kill -9 %p], Args: [], Version: 5.16.1 (#1 built by jenkins on 20181120-1809 git: 6a13b87a6fcdf4afad6d4474a68a9434b24d6c67) 2019-10-11 10:33:55,965 INFO main:org.mortbay.log: Logging to org.slf4j.impl.Log4jLoggerAdapter(org.mortbay.log) via org.mortbay.log.Slf4jLog 2019-10-11 10:33:56,042 INFO main:org.springframework.context.support.ClassPathXmlApplicationContext: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@646d64ab: startup date [Fri Oct 11 10:33:56 CST 2019]; root of context hierarchy 2019-10-11 10:33:56,083 INFO main:org.springframework.beans.factory.xml.XmlBeanDefinitionReader: Loading XML bean definitions from class path resource [webapp/WEB-INF/spring/beanRefFactory.xml] 2019-10-11 10:33:56,334 INFO main:org.springframework.beans.factory.support.DefaultListableBeanFactory: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@3590fc5b: defining beans [bootstrapContext,rootContext]; root of factory hierarchy 2019-10-11 10:33:56,361 INFO main:org.springframework.context.support.GenericApplicationContext: Refreshing org.springframework.context.support.GenericApplicationContext@43bc63a3: startup date [Fri Oct 11 10:33:56 CST 2019]; root of context hierarchy 2019-10-11 10:33:56,365 INFO main:org.springframework.beans.factory.support.DefaultListableBeanFactory: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@2362f559: defining beans [commandLineConfigurationBean,entityManagerFactoryBean,com.cloudera.server.cmf.TrialState,com.cloudera.server.cmf.TrialManager,com.cloudera.cmf.crypto.LicenseLoader]; root of factory hierarchy 2019-10-11 10:33:56,427 INFO main:com.cloudera.enterprise.CommonMain: Reading database properties from /opt/cloudera-manager/cm-5.16.1/etc/cloudera-scm-server/db.properties 2019-10-11 10:33:56,433 INFO main:com.cloudera.enterprise.CommonMain: Statistics not enabled, c3p0 JMX disabled 2019-10-11 10:33:56,585 INFO main:org.hibernate.annotations.common.Version: HCANN000001: Hibernate Commons Annotations {4.0.2.Final} 2019-10-11 10:33:56,591 INFO main:org.hibernate.Version: HHH000412: Hibernate Core {4.2.2.Final} 2019-10-11 10:33:56,597 INFO main:org.hibernate.cfg.Environment: HHH000206: hibernate.properties not found 2019-10-11 10:33:56,601 INFO main:org.hibernate.cfg.Environment: HHH000021: Bytecode provider name : javassist 2019-10-11 10:33:57,464 INFO main:org.hibernate.cfg.Configuration: HHH000221: Reading mappings from resource: cmf.hbm.xml 2019-10-11 10:33:57,664 INFO main:org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator: HHH000130: Instantiating explicit connection provider: org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider 2019-10-11 10:33:57,664 INFO main:org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider: HHH010002: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://bd01.getngo.com/hive?useUnicode=true&characterEncoding=UTF-8 2019-10-11 10:33:57,665 INFO main:org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider: HHH000046: Connection properties: {user=scm, password=****, autocommit=true, release_mode=auto} 2019-10-11 10:33:57,665 INFO main:org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider: HHH000006: Autocommit mode: true 2019-10-11 10:33:57,682 INFO main:com.mchange.v2.log.MLog: MLog clients using log4j logging. 2019-10-11 10:33:57,816 INFO main:com.mchange.v2.c3p0.C3P0Registry: Initializing c3p0-0.9.1.1 [built 15-March-2007 01:32:31; debug? true; trace: 10] 2019-10-11 10:33:57,850 INFO main:org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider: HHH000149: JDBC isolation level: READ_COMMITTED 2019-10-11 10:33:57,877 INFO main:com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource: Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@8e8ee06d [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@570dac23 [ acquireIncrement -> 3, acquireRetryAttempts -> 5, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 2u89i1a51f8kmvj18delbc|1fdf1c5, idleConnectionTestPeriod -> 300, initialPoolSize -> 3, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 50, maxStatements -> 2500, maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@eb66451e [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 2u89i1a51f8kmvj18delbc|6dee4f1b, jdbcUrl -> jdbc:mysql://bd01.getngo.com/hive?useUnicode=true&characterEncoding=UTF-8, properties -> {user=******, password=******, autocommit=true, release_mode=auto} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 2u89i1a51f8kmvj18delbc|2dca0d64, numHelperThreads -> 3 ] 2019-10-11 10:33:58,109 INFO main:org.hibernate.dialect.Dialect: HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2019-10-11 10:33:58,118 INFO main:org.hibernate.engine.jdbc.internal.LobCreatorBuilder: HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException 2019-10-11 10:33:58,251 INFO main:org.hibernate.engine.transaction.internal.TransactionFactoryInitiator: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory 2019-10-11 10:33:58,258 INFO main:org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory: HHH000397: Using ASTQueryTranslatorFactory 2019-10-11 10:33:58,363 INFO main:org.hibernate.cache.spi.UpdateTimestampsCache: HHH000250: Starting update timestamps cache at region: org.hibernate.cache.spi.UpdateTimestampsCache 2019-10-11 10:33:58,364 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.spi.UpdateTimestampsCache]; using defaults. 2019-10-11 10:33:58,370 INFO main:org.hibernate.cache.internal.StandardQueryCache: HHH000248: Starting query cache at region: org.hibernate.cache.internal.StandardQueryCache 2019-10-11 10:33:58,373 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.internal.StandardQueryCache]; using defaults. 2019-10-11 10:33:58,402 INFO main:org.hibernate.validator.internal.util.Version: HV000001: Hibernate Validator 5.0.1.Final 2019-10-11 10:33:59,533 INFO main:com.cloudera.enterprise.CommonMain: Statistics not enabled, JMX will not be registered 2019-10-11 10:33:59,650 INFO main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: MYSQL database engine and table mapping: {InnoDB=[NEXT_COMPACTION_QUEUE_ID, NUCLEUS_TABLES, SERDE_PARAMS, FUNCS, SKEWED_COL_VALUE_LOC_MAP, TYPES, PART_PRIVS, PARTITION_EVENTS, CDS, DBS, DATABASE_PARAMS, SD_PARAMS, PARTITIONS, SDS, ROLE_MAP, SERDES, TBL_PRIVS, TXN_COMPONENTS, COLUMNS_V2, COMPLETED_TXN_COMPONENTS, NOTIFICATION_LOG, PARTITION_KEY_VALS, SKEWED_VALUES, ROLES, PART_COL_PRIVS, HIVE_LOCKS, GLOBAL_PRIVS, PARTITION_PARAMS, TABLE_PARAMS, COMPACTION_QUEUE, PART_COL_STATS, SKEWED_STRING_LIST_VALUES, METASTORE_DB_PROPERTIES, TBLS, DELEGATION_TOKENS, DB_PRIVS, NEXT_TXN_ID, TBL_COL_PRIVS, NEXT_LOCK_ID, SORT_COLS, MASTER_KEYS, SEQUENCE_TABLE, INDEX_PARAMS, PARTITION_KEYS, TXNS, TYPE_FIELDS, TAB_COL_STATS, IDXS, FUNC_RU, BUCKETING_COLS, SKEWED_STRING_LIST, VERSION, SKEWED_COL_NAMES, CM_VERSION, NOTIFICATION_SEQUENCE]} 2019-10-11 10:33:59,668 INFO main:com.cloudera.enterprise.dbutil.DbUtil: Schema version table doesn't exist. 2019-10-11 10:33:59,682 INFO main:com.cloudera.enterprise.dbutil.DbUtil: Schema version table doesn't exist. 2019-10-11 10:33:59,684 INFO main:com.cloudera.enterprise.dbutil.DbUtil: Current database schema version: 0 2019-10-11 10:34:00,610 FATAL main:org.hsqldb.cmdline.SqlFile: SQL Error at 'UTF-8' line 84: "create table ROLES (     ROLE_ID bigint not null,     NAME varchar(255) not null unique,     HOST_ID bigint,     ROLE_TYPE varchar(255),     CONFIGURED_STATUS varchar(255),     STATUS varchar(255),     SERVICE_ID bigint,     primary key (ROLE_ID) ) engine=InnoDB" Table 'ROLES' already exists 2019-10-11 10:34:00,612 FATAL main:org.hsqldb.cmdline.SqlFile: Rolling back SQL transaction. 2019-10-11 10:34:00,613 ERROR main:com.cloudera.enterprise.dbutil.SqlFileRunner: Exception while executing ddl scripts. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ROLES' already exists     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)     at com.mysql.jdbc.Util.getInstance(Util.java:386)     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2814)     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2763)     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:896)     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)     at org.hsqldb.cmdline.SqlFile.processSQL(Unknown Source)     at org.hsqldb.cmdline.SqlFile.scanpass(Unknown Source)     at org.hsqldb.cmdline.SqlFile.execute(Unknown Source)     at com.cloudera.enterprise.dbutil.SqlFileRunner.runSqlFile(SqlFileRunner.java:68)     at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlStringRunner.run(SqlScriptRunnerFactory.java:211)     at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlScriptRunnerComposite.run(SqlScriptRunnerFactory.java:139)     at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlScriptRunnerComposite.run(SqlScriptRunnerFactory.java:139)     at com.cloudera.enterprise.dbutil.DbUtil.runScripts(DbUtil.java:449)     at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchemaInternal(DbUtil.java:389)     at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchema(DbUtil.java:359)     at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchema(DbUtil.java:335)     at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkSchemaDoUpgrade(EntityManagerFactoryBean.java:350)     at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:128)     at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:65)     at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)     at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)     at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1440)     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:247)     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)     at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:616)     at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)     at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)     at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)     at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)     at com.cloudera.server.cmf.Main.bootstrapSpringContext(Main.java:393)     at com.cloudera.server.cmf.Main.<init>(Main.java:243)     at com.cloudera.server.cmf.Main.main(Main.java:216) 2019-10-11 10:34:00,618 ERROR main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: Unable to upgrade schema to latest version. java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ROLES' already exists     at com.cloudera.enterprise.dbutil.SqlFileRunner.runSqlFile(SqlFileRunner.java:86)     at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlStringRunner.run(SqlScriptRunnerFactory.java:211)     at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlScriptRunnerComposite.run(SqlScriptRunnerFactory.java:139)     at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlScriptRunnerComposite.run(SqlScriptRunnerFactory.java:139)     at com.cloudera.enterprise.dbutil.DbUtil.runScripts(DbUtil.java:449)     at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchemaInternal(DbUtil.java:389)     at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchema(DbUtil.java:359)     at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchema(DbUtil.java:335)     at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkSchemaDoUpgrade(EntityManagerFactoryBean.java:350)     at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:128)     at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:65)     at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)     at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)     at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1440)     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:247)     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)     at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:616)     at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)     at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)     at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)     at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)     at com.cloudera.server.cmf.Main.bootstrapSpringContext(Main.java:393)     at com.cloudera.server.cmf.Main.<init>(Main.java:243)     at com.cloudera.server.cmf.Main.main(Main.java:216) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ROLES' already exists     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)     at com.mysql.jdbc.Util.getInstance(Util.java:386)     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2814)     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2763)     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:896)     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)     at org.hsqldb.cmdline.SqlFile.processSQL(Unknown Source)     at org.hsqldb.cmdline.SqlFile.scanpass(Unknown Source)     at org.hsqldb.cmdline.SqlFile.execute(Unknown Source)     at com.cloudera.enterprise.dbutil.SqlFileRunner.runSqlFile(SqlFileRunner.java:68)     ... 33 more

　　

2 解决办法

 

 

找到原因了，原来是我的my.cnfsql_mode设置成了sql_mode='ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,PIPES_AS_CONCAT,ANSI_QUOTES'

导致CDH运行sql的时候报错

 

注释掉重启就OK。