[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=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)
[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=17127674#comment-17127674 ] Xiaoxiang Yu edited comment on KYLIN-4545 at 6/7/20, 2:46 PM: -- Hi [~praveenece] , Kylin team has tested its binary for at least three Hadoop distributions(CDH/HDP/AWS EMR), and Kylin did not claim it support or work under the different kind of 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 if I could fix this issue but I think I can have a try. Maybe we can have a offline discussion by some IM tools(slack is my favourite way) . This my email hit_la...@126.com. I think we can have a direct talk once you give me your email address in slack. was (Author: hit_lacus): 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] [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=17126541#comment-17126541 ] praveenece edited comment on KYLIN-4545 at 6/5/20, 4:39 PM: When we give show tables in hive shell, we are getting tables(created external table). we are using MariaDB(version -10.0.38) as Hive metadata store, not using MySQL database. is this may be a reason for the issues or what is the compatibility version of Mariadb for kylin 3.0.0. We are able to run group by query in Hive(actual data present in Hbase). Please help us to resolve the issues. was (Author: praveenece): When i give show tables in hive shell, i am getting my table(created external table). Hive metadata stored in Mariadb. I am able to run group by query in Hive(actual data present in Hbase). Please help us to resolve the issues. > 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] [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=17126541#comment-17126541 ] praveenece edited comment on KYLIN-4545 at 6/5/20, 8:36 AM: When i give show tables in hive shell, i am getting my table(created external table). Hive metadata stored in Mariadb. I am able to run group by query in Hive(actual data present in Hbase). Please help us to resolve the issues. was (Author: praveenece): When i give show tables in hive shell, i am getting my table(created external table). I am able to run group by query in Hive(actual data present in Hbase). Please help us to resolve the issues. > 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] [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=17126541#comment-17126541 ] praveenece edited comment on KYLIN-4545 at 6/5/20, 8:36 AM: When i give show tables in hive shell, i am getting my table(created external table). I am able to run group by query in Hive(actual data present in Hbase). Please help us to resolve the issues. was (Author: praveenece): 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)
