praveenece created KYLIN-4545: --------------------------------- Summary: unable to load HiveMetaStore Key: KYLIN-4545 URL: https://issues.apache.org/jira/browse/KYLIN-4545 Project: Kylin Issue Type: Test Components: Environment Affects Versions: v3.0.2 Environment: hadoop-3.2.0 hbase-2.2.0 hive-3.1.0 kylin-3.0.2-bin-hadoop3 Reporter: praveenece
We are using the below software to setup kylin environment. hadoop-3.2.0 hbase-2.2.0 hive-3.1.0 kylin-3.0.2-bin-hadoop3 After configuring everything getting *message: Caused by: javax.jdo.JDOException: Exception thrown when executing query : SELECT `A0`.`NAME` FROM `DBS` `A0` WHERE `A0`.`CATALOG_NAME` = ?* this error message. i have executed below query against hive Metastore to fix the issues. USE metastore; ALTER TABLE TBLS ADD REWRITE_ENABLED BIT(1) NOT NULL; UPDATE TBLS SET REWRITE_ENABLED=IS_REWRITE_ENABLED; ALTER TABLE DBS ADD CATALOG_NAME varchar(256) not Null; UPDATE DBS SET CATALOG_NAME=CTLG_NAME; After that i am able to see the hive tables in kylin model, but i am not able to Sync the tables. Getting the "can not get Hive TableMeta" error message. Please help us to fix the issues ASAP. -- This message was sent by Atlassian Jira (v8.3.4#803005)