[jira] [Commented] (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 commented on KYLIN-4545: - 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)
[jira] [Commented] (KYLIN-4545) unable to load HiveMetaStore
[ https://issues.apache.org/jira/browse/KYLIN-4545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17211601#comment-17211601 ] Liubo commented on KYLIN-4545: -- I also had the same problem. My problem was caused by the spark3.0 deployed in the cluster, because spark contains hive-metastore-2.3.7.jar, which conflicts with hive-3.* in the cluster. So I modified the find-spark-dependency.sh script in the bin directory of kylin, tried to exclude hive-metastore-2.3.7.jar, and the problem was solved. > 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)
[jira] [Commented] (KYLIN-4545) unable to load HiveMetaStore
[ https://issues.apache.org/jira/browse/KYLIN-4545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17210793#comment-17210793 ] Pengfei Wang commented on KYLIN-4545: - I also have this problem, Is the problem solved? > 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)
[jira] [Commented] (KYLIN-4545) unable to load HiveMetaStore
[ 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)
[jira] [Commented] (KYLIN-4545) unable to load HiveMetaStore
[ https://issues.apache.org/jira/browse/KYLIN-4545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17127674#comment-17127674 ] Xiaoxiang Yu commented on KYLIN-4545: - Hi [~praveenece] , Kylin team has tested our binary for at least three Hadoop distributions(CDH/HDP/AWS EMR), Kylin did not claim it support or tested under the plain vanilla Hadoop used by you: 1. hadoop-3.2.0 2. hbase-2.2.0 3. hive-3.1.0 I am not sure I could fix this issue, but I think we can have a offline discussion by slack. This my email hit_la...@126.com. I think we can have a direct talk once you give me your email address. > 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)
[jira] [Commented] (KYLIN-4545) unable to load HiveMetaStore
[ https://issues.apache.org/jira/browse/KYLIN-4545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17126541#comment-17126541 ] praveenece commented on KYLIN-4545: --- When i give show tables in hive shell, i am getting my table(created external table) > 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)
[jira] [Commented] (KYLIN-4545) unable to load HiveMetaStore
[ https://issues.apache.org/jira/browse/KYLIN-4545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17125999#comment-17125999 ] Xiaoxiang Yu commented on KYLIN-4545: - Can you execute HQL such as "show tables" in hive CLI or beeline, I guess you hive metadata store is not in health state. > 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)