[KYLIN-4545] unable to load HiveMetaStore

• Type: Test
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: v3.0.2
• Component/s: Environment
• Environment: hadoop-3.2.0 ; hbase-2.2.0 ; hive-3.1.0 ; kylin-3.0.2-bin-hadoop3
• Assignee: Unassigned
• Reporter: praveenece
• Created: 04/Jun/20 14:01
• Updated: 10/Oct/20 10:04

Description

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.