You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Yue Zhang (Jira)" <ji...@apache.org> on 2024/03/08 08:57:00 UTC
[jira] [Commented] (HIVE-25041) During "schematool --verbose -dbType derby -initSchema" I'm getting "utocommit on" (with a missing ''a").
[ https://issues.apache.org/jira/browse/HIVE-25041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17824668#comment-17824668 ]
Yue Zhang commented on HIVE-25041:
----------------------------------
I have the same issue from schematool, after hours of searching, I find the configuration of vi-style in my ~/.inputrc affects the behavior of beeline, and schematool will call beeline to connect db.
.inputrc:
...
set editing-mode vi
set keymap vi-command
...
comment off these configuration, scheamtool will work correctly.
The first character 'a' in "autocommit on" is just the "append" command in vim.
More tests show that beeline, hive are affected by thest configuration.
> During "schematool --verbose -dbType derby -initSchema" I'm getting "utocommit on" (with a missing ''a").
> ---------------------------------------------------------------------------------------------------------
>
> Key: HIVE-25041
> URL: https://issues.apache.org/jira/browse/HIVE-25041
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Hive
> Affects Versions: 3.1.2
> Reporter: NOELLE MILTON VEGA
> Priority: Blocker
>
> Hello Friends:
> I'm issuing the below command, but am getting the exception shown. This is a *pseudo-distributed* mode setup of *HIVE* and *HADOOP* (simple), so I've edited a tiny few files (just following the vanilla instructions – nothing fancy).
> Yet somewhere it looks like there's a typo, perhaps in this file:
>
> {noformat}
> hive-schema-3.1.0.derby.sql{noformat}
>
> From the below, {color:#0747a6}*utocommit on*{color} looks like it should be {color:#0747a6}*autocommit on*{color}.
> {code:java}
> jdoe@fedora-33$ ${HIVE_HOME}/bin/schematool --verbose -dbType derby -initSchema
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in [jar:file:/opt/hadoop/hadoop.d/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in [jar:file:/opt/hadoop/hive.d/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
> SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
> 2021-04-20 21:09:57,605 INFO [main] conf.HiveConf (HiveConf.java:findConfigFile(187)) - Found configuration file file:/opt/hadoop/hive.d/conf/hive-site.xml
> 2021-04-20 21:09:58,013 INFO [main] tools.HiveSchemaHelper (HiveSchemaHelper.java:logAndPrintToStdout(117)) - Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
> Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
> 2021-04-20 21:09:58,014 INFO [main] tools.HiveSchemaHelper (HiveSchemaHelper.java:logAndPrintToStdout(117)) - Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver
> Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver
> 2021-04-20 21:09:58,014 INFO [main] tools.HiveSchemaHelper (HiveSchemaHelper.java:logAndPrintToStdout(117)) - Metastore connection User: APP
> Metastore connection User: APP
> Starting metastore schema initialization to 3.1.0
> Initialization script hive-schema-3.1.0.derby.sql
> Connecting to jdbc:derby:;databaseName=metastore_db;create=true
> Connected to: Apache Derby (version 10.14.1.0 - (1808820))
> Driver: Apache Derby Embedded JDBC Driver (version 10.14.1.0 - (1808820))
> Transaction isolation: TRANSACTION_READ_COMMITTED
> 0: jdbc:derby:> utocommit on
> Error: Syntax error: Encountered "utocommit" at line 1, column 1. (state=42X01,code=30000)
> Closing: 0: jdbc:derby:;databaseName=metastore_db;create=true
> org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !!
> Underlying cause: java.io.IOException : Schema script failed, errorcode 2
> org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !!
> at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:594)
> at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:567)
> at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1517)
> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.base/java.lang.reflect.Method.invoke(Method.java:566)
> at org.apache.hadoop.util.RunJar.run(RunJar.java:323)
> at org.apache.hadoop.util.RunJar.main(RunJar.java:236)
> Caused by: java.io.IOException: Schema script failed, errorcode 2
> at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:1226)
> at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:1204)
> at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:590)
> ... 8 more
> *** schemaTool failed ***{code}
>
> Versions are:
> {code:java}
> Hive......: v3.1.2
> Hadoop....: v3.3.0{code}
> Any ideas? Thank you.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)