No rows affected (0 seconds)
0: jdbc:mysql://hive2-meta-1.ccqa5e4vmj6e.us-> /*!40101 SET character_set_client = utf8 /
No rows affected (0 seconds)
0: jdbc:mysql://hive2-meta-1.ccqa5e4vmj6e.us-> CREATE TABLE IF NOT EXISTS DATABASE_PARAMS
( DB_ID
bigint(20) NOT NULL, PARAM_KEY
varchar(180) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, PARAM_VALUE
varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (DB_ID
,PARAM_KEY
), KEY DATABASE_PARAMS_N49
(DB_ID
), CONSTRAINT DATABASE_PARAMS_FK1
FOREIGN KEY (DB_ID
) REFERENCES DBS
(DB_ID
) ) ENGINE=InnoDB DEFAULT CHARSET=latin1
No rows affected (0.004 seconds)
0: jdbc:mysql://hive2-meta-1.ccqa5e4vmj6e.us-> /!40101 SET character_set_client = @saved_cs_client */
No rows affected (0 seconds)
0: jdbc:mysql://hive2-meta-1.ccqa5e4vmj6e.us-> CREATE TABLE CTLGS
( CTLG_ID
BIGINT PRIMARY KEY, NAME
VARCHAR(256), DESC
VARCHAR(4000), LOCATION_URI
VARCHAR(4000) NOT NULL, UNIQUE KEY UNIQUE_CATALOG
(NAME
) ) ENGINE=InnoDB DEFAULT CHARSET=latin1
Error: (conn=560472) Table ‘CTLGS’ already exists (state=42S01,code=1050)
Closing: 0: jdbc:mysql://hive2-meta-1.ccqa5e4vmj6e.us-east-1.rds.amazonaws.com:3306/hivebaknew?createDatabaseIfNotExist=true
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent!
Underlying cause: java.io.IOException : Schema script failed, errorcode 2
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent!
at org.apache.hive.beeline.schematool.HiveSchemaToolTaskInit.execute(HiveSchemaToolTaskInit.java:66)
at org.apache.hive.beeline.schematool.HiveSchemaTool.main(HiveSchemaTool.java:353)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:323)
at org.apache.hadoop.util.RunJar.main(RunJar.java:236)
Caused by: java.io.IOException: Schema script failed, errorcode 2
at org.apache.hive.beeline.schematool.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:262)
at org.apache.hive.beeline.schematool.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:240)
at org.apache.hive.beeline.schematool.HiveSchemaToolTaskInit.execute(HiveSchemaToolTaskInit.java:62)
… 7 more
*** schemaTool failed ***
java.sql.SQLSyntaxErrorException: (conn=560236) Unknown column ‘B0.CTLG_NAME’ in ‘where clause’)
是因为hudi-utilities-bundle_2.11-0.7.0.jar 和 hive-standalone-metastore-3.1.0.jar依赖冲突导致,需要把hive/lib/hudi-utilities-bundle_2.11-0.7.0.jar 去掉,不然会默认采用hudi这个jar解析元数据的定义
安装hive3报表信息 Unknown column ‘B0.CTLG_NAME‘ in ‘where clause‘)
于 2023-07-21 12:03:03 首次发布