Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-4545

unable to load HiveMetaStore

    XMLWordPrintableJSON

Details

    • Test
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • v3.0.2
    • None
    • Environment
    • None
    • hadoop-3.2.0
      hbase-2.2.0
      hive-3.1.0
      kylin-3.0.2-bin-hadoop3

    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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            praveenece praveenece
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated: