[ https://issues.apache.org/jira/browse/KYLIN-4545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17192084#comment-17192084 ]
han commented on KYLIN-4545: ---------------------------- 于大哥, 我也遇到了一模一样的问题, 也是外部表. 请问上面大哥的问题怎么解决的? 谢谢了. > 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 > Priority: Critical > > 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)