You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "MOHAMMED ISMAIL MISHAL VALEY (Jira)" <ji...@apache.org> on 2021/10/29 03:35:00 UTC

[jira] [Comment Edited] (KYLIN-5108) Unsupported Hive Metastore version (Unknown) -

    [ https://issues.apache.org/jira/browse/KYLIN-5108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17435756#comment-17435756 ] 

MOHAMMED ISMAIL MISHAL VALEY edited comment on KYLIN-5108 at 10/29/21, 3:34 AM:
--------------------------------------------------------------------------------

Metstore version issue is resolved by installing hive 2.3.7  or also by using same version 2.3.9 but in configuration setting 

$KYLIN_HOME/conf/kylin.properties

kylin.query.spark-conf.spark.sql.hive.metastore.version=2.3.7
kylin.engine.spark-conf.spark.sql.hive.metastore.version=2.3.7
kylin.engine.spark-conf.spark.sql.hive.metastore.jars=/etc/hadoop/spark/jars/*
kylin.query.spark-conf.spark.sql.hive.metastore.jars=/etc/hadoop/spark/jars/*

 


was (Author: mohammed.mishal):
Metstore version issue is resolved by installing hive 2.3.7 

> Unsupported Hive Metastore version (Unknown) - 
> -----------------------------------------------
>
>                 Key: KYLIN-5108
>                 URL: https://issues.apache.org/jira/browse/KYLIN-5108
>             Project: Kylin
>          Issue Type: Bug
>          Components: Client - CLI
>    Affects Versions: v4.0.0
>         Environment: Hive Version : Hive 2.3.9
> Spark version : 3.1.1
> Hadoop version : Hadoop 3.2.0
>            Reporter: MOHAMMED ISMAIL MISHAL VALEY
>            Priority: Blocker
>
> Hi Team 
> I am trying to install Kylin4 with EC2-S3 as mentioned in [doc.|https://kylin.apache.org/docs/install/deploy_without_hadoop.html]
> But I am facing the error as shown below.
> ERROR org.apache.kylin.engine.spark.application.SparkApplication - The spark job execute failed!
> java.lang.UnsupportedOperationException: Unsupported Hive Metastore version (Unknown). Please set spark.sql.hive.metastore.version with a valid version.
>  at org.apache.spark.sql.hive.client.IsolatedClientLoader$.hiveVersion(IsolatedClientLoader.scala:107) ~[spark-hive_2.12-3.1.1.jar:3.1.1]
>  
> I have followed the document as is and kylin is up and running but tables are not displayed in Insight tab after creating the Datasource and model. Also when i try to build the cube it throws the above error.
> Hive Version : Hive 2.3.9
> Spark version : 3.1.1
> Hadoop version : Hadoop 3.2.0
>  Kylin Version :{{apache-kylin-4.0.0}}
>  
> https://kylin.apache.org/docs/install/deploy_without_hadoop.html
>  
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)