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)
