You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Pengfei Wang (Jira)" <ji...@apache.org> on 2020/10/10 10:05:00 UTC
[jira] [Comment Edited] (KYLIN-4545) unable to load HiveMetaStore
[ https://issues.apache.org/jira/browse/KYLIN-4545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17211643#comment-17211643 ]
Pengfei Wang edited comment on KYLIN-4545 at 10/10/20, 10:04 AM:
-----------------------------------------------------------------
I got it! thank you!
was (Author: gobird):
How did you modify it ?
> 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)