arrow_back Apache Hive 3.1.2 Installation on Linux Guide

29 days ago link more_vert
Raymond Raymond
articleArticles 546
imageDiagrams 49
codeCode 2
chat_bubble_outlineThreads 8
commentComments 250
loyaltyKontext Points 6005
#1737 Re: Apache Hive 3.1.2 Installation on Linux Guide
-dbType mysql

The command line needs to be consistent with config.  Can you change it to -dbtype derby?


person Yaroslav access_time 29 days ago
Re: Apache Hive 3.1.2 Installation on Linux Guide

Hello, thank you for such a good article.

But when I executed the command $HIVE_HOME/bin/schematool -dbType mysql -initSchema, I've got the following error:

SLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found binding in [jar:file:/home/yaroslav/Hadoop/apache-hive-3.1.2-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/home/yaroslav/Hadoop/hadoop-3.3.2/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: See for an explanation.SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]

Metastore connection URL:        jdbc:derby:;databaseName=metastore_db;create=true

Metastore Connection Driver :    org.apache.derby.jdbc.EmbeddedDriver

Metastore connection User:       APP

Starting metastore schema initialization to 3.1.0

Initialization script hive-schema-3.1.0.mysql.sql

Error: Syntax error: Encountered "<EOF>" at line 1, column 64. (state=42X01,code=30000)

org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !!

Underlying cause: : Schema script failed, errorcode 2

Use --verbose for detailed stacktrace.

*** schemaTool failed ***

I did everything according to the instructions, but hive tries to create derby metastore instead of MySQL. I will appreciate your help so much.

recommendMore from Kontext