You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Joe Lin via user <us...@hive.apache.org> on 2023/01/03 17:41:41 UTC
Hive 4.0.0-alpha-2 + Hadoop 3.3.1. Can't start beeline. Need help
I downloaded Hive 4.0.0-alpha-2 tar.gz and install along with with Hadoop 3.3 on Ubuntu 22.04.
I followed the instruction in the “Getting started guide” till running HiveServer2 and Beeline (https://cwiki.apache.org/confluence/display/Hive//GettingStarted#GettingStarted-RunningHiveServer2andBeeline.1).
I have two problems and could not get beeline too talk to hiveserver2.
When I started hive servers the below is what shown on the console. There’s no error. But I see no process binding on TCP port 10000 using “netstat".
So when I started beeline with
$HIVE_HOME/bin/beeline -u jdbc:hive2://localhost:10000
It errors out with:
Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: java.net.ConnectException: Connection refused (state=08S01,code=0)
I then tried with
$HIVE_HOME/bin/beeline -u jdbc:hive2://
It errors out with
Connecting to jdbc:hive2://
23/01/03 09:39:10 [main]: WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
Hive Session ID = 19274fb7-07af-42a5-8e52-d42815ddbbeb
java.lang.ExceptionInInitializerError
Connection is already closed.
Thanks for any help.
====== hiveserver2 output
mango@kawaii:~$ $HIVE_HOME/bin/hiveserver2
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
2023-01-03 09:33:22: Starting HiveServer2
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
Hive Session ID = ab6cd9b8-f56d-4f5e-a809-bdc862d29c57
Re: Hive 4.0.0-alpha-2 + Hadoop 3.3.1. Can't start beeline. Need help
Posted by Joe Lin via user <us...@hive.apache.org>.
Sorry the log level was not set to debug in my previous email. After setting to debug level, here’s the console output of hiveserver2.
mango@kawaii:~$ $HIVE_HOME/bin/hiveserver2
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
2023-01-04 09:35:35: Starting HiveServer2
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
2023-01-04 09:35:36,547 main DEBUG Apache Log4j Core 2.18.0 initializing configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@66d3eec0
2023-01-04 09:35:36,583 main DEBUG Took 0.026941 seconds to load 7 plugins from package org.apache.hadoop.hive.ql.log
2023-01-04 09:35:36,583 main DEBUG PluginManager 'Core' found 140 plugins
2023-01-04 09:35:36,584 main DEBUG PluginManager 'Level' found 0 plugins
2023-01-04 09:35:36,587 main DEBUG Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property].
2023-01-04 09:35:36,600 main DEBUG PluginManager 'TypeConverter' found 26 plugins
2023-01-04 09:35:36,609 main DEBUG createProperty(name="hive.log.dir", value="${sys:java.io.tmpdir}/${sys:user.name}", Configuration(HiveLog4j2))
2023-01-04 09:35:36,614 main DEBUG Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property].
2023-01-04 09:35:36,615 main DEBUG createProperty(name="hive.log.file", value="hive.log", Configuration(HiveLog4j2))
2023-01-04 09:35:36,615 main DEBUG Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property].
2023-01-04 09:35:36,616 main DEBUG createProperty(name="hive.log.level", value="DEBUG", Configuration(HiveLog4j2))
2023-01-04 09:35:36,616 main DEBUG Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property].
2023-01-04 09:35:36,616 main DEBUG createProperty(name="hive.perflogger.log.level", value="INFO", Configuration(HiveLog4j2))
2023-01-04 09:35:36,617 main DEBUG Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property].
2023-01-04 09:35:36,617 main DEBUG createProperty(name="hive.root.logger", value="DRFA", Configuration(HiveLog4j2))
2023-01-04 09:35:36,617 main DEBUG Building Plugin[name=properties, class=org.apache.logging.log4j.core.config.PropertiesPlugin].
2023-01-04 09:35:36,620 main DEBUG configureSubstitutor(={hive.log.dir=/tmp/mango, hive.log.file=hive.log, hive.log.level=DEBUG, hive.perflogger.log.level=INFO, hive.root.logger=DRFA}, Configuration(HiveLog4j2))
2023-01-04 09:35:36,622 main DEBUG PluginManager 'Lookup' found 17 plugins
2023-01-04 09:35:36,622 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:36,634 main DEBUG LoggerConfig$Builder(additivity="null", level="WARN", levelAndRefs="null", name="org.apache.zookeeper.server.NIOServerCnxn", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:36,635 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:36,636 main DEBUG LoggerConfig$Builder(additivity="null", level="WARN", levelAndRefs="null", name="org.apache.zookeeper.ClientCnxnSocketNIO", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:36,636 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:36,637 main DEBUG LoggerConfig$Builder(additivity="null", level="ERROR", levelAndRefs="null", name="DataNucleus", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:36,637 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:36,638 main DEBUG LoggerConfig$Builder(additivity="null", level="ERROR", levelAndRefs="null", name="Datastore", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:36,638 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:36,638 main DEBUG LoggerConfig$Builder(additivity="null", level="ERROR", levelAndRefs="null", name="JPOX", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:36,638 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:36,639 main DEBUG LoggerConfig$Builder(additivity="null", level="INFO", levelAndRefs="null", name="org.apache.hadoop.hive.ql.log.PerfLogger", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:36,639 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:36,640 main DEBUG LoggerConfig$Builder(additivity="null", level="INFO", levelAndRefs="null", name="com.amazonaws", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:36,640 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:36,640 main DEBUG LoggerConfig$Builder(additivity="null", level="INFO", levelAndRefs="null", name="org.apache.http", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:36,640 main DEBUG Building Plugin[name=AppenderRef, class=org.apache.logging.log4j.core.config.AppenderRef].
2023-01-04 09:35:36,641 main DEBUG createAppenderRef(ref="DRFA", level="null", Filter=null)
2023-01-04 09:35:36,642 main DEBUG Building Plugin[name=root, class=org.apache.logging.log4j.core.config.LoggerConfig$RootLogger].
2023-01-04 09:35:36,646 main DEBUG LoggerConfig$RootLogger$Builder(additivity="null", level="DEBUG", levelAndRefs="null", includeLocation="null", ={DRFA}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:36,646 main DEBUG Building Plugin[name=loggers, class=org.apache.logging.log4j.core.config.LoggersPlugin].
2023-01-04 09:35:36,647 main DEBUG createLoggers(={org.apache.zookeeper.server.NIOServerCnxn, org.apache.zookeeper.ClientCnxnSocketNIO, DataNucleus, Datastore, JPOX, org.apache.hadoop.hive.ql.log.PerfLogger, com.amazonaws, org.apache.http, root})
2023-01-04 09:35:36,647 main DEBUG Building Plugin[name=layout, class=org.apache.logging.log4j.core.layout.PatternLayout].
2023-01-04 09:35:36,649 main DEBUG PatternLayout$Builder(pattern="%d{ISO8601} %5p [%t] %c{2}: %m%n", PatternSelector=null, Configuration(HiveLog4j2), Replace=null, charset="null", alwaysWriteExceptions="null", disableAnsi="null", noConsoleNoAnsi="null", header="null", footer="null")
2023-01-04 09:35:36,649 main DEBUG PluginManager 'Converter' found 48 plugins
2023-01-04 09:35:36,657 main DEBUG Building Plugin[name=appender, class=org.apache.logging.log4j.core.appender.ConsoleAppender].
2023-01-04 09:35:36,661 main DEBUG ConsoleAppender$Builder(target="SYSTEM_ERR", follow="null", direct="null", bufferedIo="null", bufferSize="null", immediateFlush="null", ignoreExceptions="null", PatternLayout(%d{ISO8601} %5p [%t] %c{2}: %m%n), name="console", Configuration(HiveLog4j2), Filter=null, ={})
2023-01-04 09:35:36,664 main DEBUG Starting OutputStreamManager SYSTEM_ERR.false.false
2023-01-04 09:35:36,664 main DEBUG Building Plugin[name=layout, class=org.apache.logging.log4j.core.layout.PatternLayout].
2023-01-04 09:35:36,665 main DEBUG PatternLayout$Builder(pattern="%d{ISO8601} %5p [%t] %c{2}: %m%n", PatternSelector=null, Configuration(HiveLog4j2), Replace=null, charset="null", alwaysWriteExceptions="null", disableAnsi="null", noConsoleNoAnsi="null", header="null", footer="null")
2023-01-04 09:35:36,665 main DEBUG Building Plugin[name=TimeBasedTriggeringPolicy, class=org.apache.logging.log4j.core.appender.rolling.TimeBasedTriggeringPolicy].
2023-01-04 09:35:36,668 main DEBUG TimeBasedTriggeringPolicy$Builder(interval="1", modulate="true", maxRandomDelay="null")
2023-01-04 09:35:36,668 main DEBUG Building Plugin[name=Policies, class=org.apache.logging.log4j.core.appender.rolling.CompositeTriggeringPolicy].
2023-01-04 09:35:36,669 main DEBUG createPolicy(={TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=true)})
2023-01-04 09:35:36,669 main DEBUG Building Plugin[name=DefaultRolloverStrategy, class=org.apache.logging.log4j.core.appender.rolling.DefaultRolloverStrategy].
2023-01-04 09:35:36,672 main DEBUG DefaultRolloverStrategy$Builder(max="30", min="null", fileIndex="null", compressionLevel="null", ={}, stopCustomActionsOnError="null", tempCompressedFilePattern="null", Configuration(HiveLog4j2))
2023-01-04 09:35:36,672 main DEBUG Building Plugin[name=appender, class=org.apache.logging.log4j.core.appender.RollingRandomAccessFileAppender].
2023-01-04 09:35:36,676 main DEBUG RollingRandomAccessFileAppender$Builder(fileName="/tmp/mango/hive.log", filePattern="/tmp/mango/hive.log.%d{yyyy-MM-dd}", append="null", Policies(CompositeTriggeringPolicy(policies=[TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=true)])), DefaultRolloverStrategy(DefaultRolloverStrategy(min=1, max=30, useMax=true)), advertise="null", advertiseURI="null", filePermissions="null", fileOwner="null", fileGroup="null", bufferedIo="null", bufferSize="null", immediateFlush="null", ignoreExceptions="null", PatternLayout(%d{ISO8601} %5p [%t] %c{2}: %m%n), name="DRFA", Configuration(HiveLog4j2), Filter=null, ={})
2023-01-04 09:35:36,680 main DEBUG Starting RollingRandomAccessFileManager /tmp/mango/hive.log
2023-01-04 09:35:36,682 main DEBUG PluginManager 'FileConverter' found 3 plugins
2023-01-04 09:35:36,685 main DEBUG Setting prev file time to 2023-01-04T09:35:35.698-0800
2023-01-04 09:35:36,686 main DEBUG Initializing triggering policy CompositeTriggeringPolicy(policies=[TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=true)])
2023-01-04 09:35:36,686 main DEBUG Initializing triggering policy TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=true)
2023-01-04 09:35:36,686 main DEBUG Building Plugin[name=appenders, class=org.apache.logging.log4j.core.config.AppendersPlugin].
2023-01-04 09:35:36,687 main DEBUG createAppenders(={console, DRFA})
2023-01-04 09:35:36,688 main DEBUG Configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@66d3eec0 initialized
2023-01-04 09:35:36,688 main DEBUG Starting configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@66d3eec0
2023-01-04 09:35:36,688 main DEBUG Started configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@66d3eec0 OK.
2023-01-04 09:35:36,689 main DEBUG Shutting down OutputStreamManager SYSTEM_OUT.false.false-1
2023-01-04 09:35:36,689 main DEBUG OutputStream closed
2023-01-04 09:35:36,689 main DEBUG Shut down OutputStreamManager SYSTEM_OUT.false.false-1, all resources released: true
2023-01-04 09:35:36,690 main DEBUG Appender DefaultConsole-1 stopped with status true
2023-01-04 09:35:36,690 main DEBUG Stopped org.apache.logging.log4j.core.config.DefaultConfiguration@45c7e403 OK
2023-01-04 09:35:36,787 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29
2023-01-04 09:35:36,789 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=StatusLogger
2023-01-04 09:35:36,790 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=ContextSelector
2023-01-04 09:35:36,791 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=org.apache.hadoop.hive.ql.log.PerfLogger
2023-01-04 09:35:36,791 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=
2023-01-04 09:35:36,792 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=com.amazonaws
2023-01-04 09:35:36,792 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=DataNucleus
2023-01-04 09:35:36,792 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=Datastore
2023-01-04 09:35:36,793 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=org.apache.zookeeper.ClientCnxnSocketNIO
2023-01-04 09:35:36,793 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=org.apache.zookeeper.server.NIOServerCnxn
2023-01-04 09:35:36,793 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=JPOX
2023-01-04 09:35:36,793 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=org.apache.http
2023-01-04 09:35:36,794 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Appenders,name=console
2023-01-04 09:35:36,795 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Appenders,name=DRFA
2023-01-04 09:35:36,797 main DEBUG org.apache.logging.log4j.core.util.SystemClock supports precise timestamps.
2023-01-04 09:35:36,797 main DEBUG Reconfiguration complete for context[name=7a4f0f29] at URI /home/mango/tools/apache-hive-4.0.0-alpha-2-bin/conf/hive-log4j2.properties (org.apache.logging.log4j.core.LoggerContext@1339e7aa) with optional ClassLoader: null
2023-01-04 09:35:36,797 main DEBUG Shutdown hook enabled. Registering a new one.
2023-01-04 09:35:36,798 main DEBUG LoggerContext[name=7a4f0f29, org.apache.logging.log4j.core.LoggerContext@1339e7aa] started OK.
2023-01-04 09:35:36,903 main DEBUG AsyncLogger.ThreadNameStrategy=UNCACHED (user specified null, default is UNCACHED)
2023-01-04 09:35:36,904 main DEBUG org.apache.logging.log4j.core.util.SystemClock supports precise timestamps.
2023-01-04 09:35:37,324 main DEBUG Using ShutdownCallbackRegistry class org.apache.logging.log4j.core.util.DefaultShutdownCallbackRegistry
2023-01-04 09:35:37,327 main DEBUG PluginManager 'Lookup' found 17 plugins
2023-01-04 09:35:37,330 main DEBUG PluginManager 'Converter' found 48 plugins
2023-01-04 09:35:37,330 main DEBUG Starting OutputStreamManager SYSTEM_OUT.false.false-2
2023-01-04 09:35:37,333 main DEBUG Using configurationFactory org.apache.logging.log4j.core.config.ConfigurationFactory$Factory@4837595f
2023-01-04 09:35:37,335 main DEBUG PluginManager 'Lookup' found 17 plugins
2023-01-04 09:35:37,337 main DEBUG Starting LoggerContext[name=AsyncContext@7a4f0f29] from configuration at file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/conf/hive-log4j2.properties
2023-01-04 09:35:37,339 main DEBUG No AsyncWaitStrategyFactory was configured in the configuration, using default factory...
2023-01-04 09:35:37,395 main DEBUG [AsyncContext@7a4f0f29] Starting AsyncLogger disruptor for this context with ringbufferSize=262144, waitStrategy=TimeoutBlockingWaitStrategy, exceptionHandler=org.apache.logging.log4j.core.async.AsyncLoggerDefaultExceptionHandler@5fa05212...
2023-01-04 09:35:37,396 main DEBUG Starting LoggerContext[name=AsyncContext@7a4f0f29, org.apache.logging.log4j.core.async.AsyncLoggerContext@5c09d180] with configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@23aae55...
2023-01-04 09:35:37,396 main DEBUG Shutdown hook enabled. Registering a new one.
2023-01-04 09:35:37,397 main DEBUG Apache Log4j Core 2.18.0 initializing configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@23aae55
2023-01-04 09:35:37,397 main DEBUG PluginManager 'Core' found 140 plugins
2023-01-04 09:35:37,397 main DEBUG PluginManager 'Level' found 0 plugins
2023-01-04 09:35:37,398 main DEBUG Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property].
2023-01-04 09:35:37,399 main DEBUG createProperty(name="hive.log.dir", value="${sys:java.io.tmpdir}/${sys:user.name}", Configuration(HiveLog4j2))
2023-01-04 09:35:37,399 main DEBUG Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property].
2023-01-04 09:35:37,399 main DEBUG createProperty(name="hive.log.file", value="hive.log", Configuration(HiveLog4j2))
2023-01-04 09:35:37,400 main DEBUG Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property].
2023-01-04 09:35:37,400 main DEBUG createProperty(name="hive.log.level", value="DEBUG", Configuration(HiveLog4j2))
2023-01-04 09:35:37,400 main DEBUG Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property].
2023-01-04 09:35:37,401 main DEBUG createProperty(name="hive.perflogger.log.level", value="INFO", Configuration(HiveLog4j2))
2023-01-04 09:35:37,401 main DEBUG Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property].
2023-01-04 09:35:37,401 main DEBUG createProperty(name="hive.root.logger", value="DRFA", Configuration(HiveLog4j2))
2023-01-04 09:35:37,402 main DEBUG Building Plugin[name=properties, class=org.apache.logging.log4j.core.config.PropertiesPlugin].
2023-01-04 09:35:37,402 main DEBUG configureSubstitutor(={hive.log.dir=/tmp/mango, hive.log.file=hive.log, hive.log.level=DEBUG, hive.perflogger.log.level=INFO, hive.root.logger=DRFA}, Configuration(HiveLog4j2))
2023-01-04 09:35:37,402 main DEBUG PluginManager 'Lookup' found 17 plugins
2023-01-04 09:35:37,403 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:37,403 main DEBUG LoggerConfig$Builder(additivity="null", level="WARN", levelAndRefs="null", name="org.apache.zookeeper.server.NIOServerCnxn", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:37,403 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:37,404 main DEBUG LoggerConfig$Builder(additivity="null", level="WARN", levelAndRefs="null", name="org.apache.zookeeper.ClientCnxnSocketNIO", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:37,404 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:37,405 main DEBUG LoggerConfig$Builder(additivity="null", level="ERROR", levelAndRefs="null", name="DataNucleus", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:37,405 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:37,406 main DEBUG LoggerConfig$Builder(additivity="null", level="ERROR", levelAndRefs="null", name="Datastore", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:37,406 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:37,407 main DEBUG LoggerConfig$Builder(additivity="null", level="ERROR", levelAndRefs="null", name="JPOX", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:37,407 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:37,408 main DEBUG LoggerConfig$Builder(additivity="null", level="INFO", levelAndRefs="null", name="org.apache.hadoop.hive.ql.log.PerfLogger", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:37,408 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:37,408 main DEBUG LoggerConfig$Builder(additivity="null", level="INFO", levelAndRefs="null", name="com.amazonaws", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:37,409 main DEBUG Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig].
2023-01-04 09:35:37,410 main DEBUG LoggerConfig$Builder(additivity="null", level="INFO", levelAndRefs="null", name="org.apache.http", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:37,410 main DEBUG Building Plugin[name=AppenderRef, class=org.apache.logging.log4j.core.config.AppenderRef].
2023-01-04 09:35:37,410 main DEBUG createAppenderRef(ref="DRFA", level="null", Filter=null)
2023-01-04 09:35:37,411 main DEBUG Building Plugin[name=root, class=org.apache.logging.log4j.core.config.LoggerConfig$RootLogger].
2023-01-04 09:35:37,411 main DEBUG LoggerConfig$RootLogger$Builder(additivity="null", level="DEBUG", levelAndRefs="null", includeLocation="null", ={DRFA}, ={}, Configuration(HiveLog4j2), Filter=null)
2023-01-04 09:35:37,411 main DEBUG Building Plugin[name=loggers, class=org.apache.logging.log4j.core.config.LoggersPlugin].
2023-01-04 09:35:37,412 main DEBUG createLoggers(={org.apache.zookeeper.server.NIOServerCnxn, org.apache.zookeeper.ClientCnxnSocketNIO, DataNucleus, Datastore, JPOX, org.apache.hadoop.hive.ql.log.PerfLogger, com.amazonaws, org.apache.http, root})
2023-01-04 09:35:37,412 main DEBUG Building Plugin[name=layout, class=org.apache.logging.log4j.core.layout.PatternLayout].
2023-01-04 09:35:37,412 main DEBUG PatternLayout$Builder(pattern="%d{ISO8601} %5p [%t] %c{2}: %m%n", PatternSelector=null, Configuration(HiveLog4j2), Replace=null, charset="null", alwaysWriteExceptions="null", disableAnsi="null", noConsoleNoAnsi="null", header="null", footer="null")
2023-01-04 09:35:37,413 main DEBUG PluginManager 'Converter' found 48 plugins
2023-01-04 09:35:37,413 main DEBUG Building Plugin[name=appender, class=org.apache.logging.log4j.core.appender.ConsoleAppender].
2023-01-04 09:35:37,414 main DEBUG ConsoleAppender$Builder(target="SYSTEM_ERR", follow="null", direct="null", bufferedIo="null", bufferSize="null", immediateFlush="null", ignoreExceptions="null", PatternLayout(%d{ISO8601} %5p [%t] %c{2}: %m%n), name="console", Configuration(HiveLog4j2), Filter=null, ={})
2023-01-04 09:35:37,418 main DEBUG Building Plugin[name=layout, class=org.apache.logging.log4j.core.layout.PatternLayout].
2023-01-04 09:35:37,418 main DEBUG PatternLayout$Builder(pattern="%d{ISO8601} %5p [%t] %c{2}: %m%n", PatternSelector=null, Configuration(HiveLog4j2), Replace=null, charset="null", alwaysWriteExceptions="null", disableAnsi="null", noConsoleNoAnsi="null", header="null", footer="null")
2023-01-04 09:35:37,419 main DEBUG Building Plugin[name=TimeBasedTriggeringPolicy, class=org.apache.logging.log4j.core.appender.rolling.TimeBasedTriggeringPolicy].
2023-01-04 09:35:37,419 main DEBUG TimeBasedTriggeringPolicy$Builder(interval="1", modulate="true", maxRandomDelay="null")
2023-01-04 09:35:37,420 main DEBUG Building Plugin[name=Policies, class=org.apache.logging.log4j.core.appender.rolling.CompositeTriggeringPolicy].
2023-01-04 09:35:37,420 main DEBUG createPolicy(={TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=true)})
2023-01-04 09:35:37,420 main DEBUG Building Plugin[name=DefaultRolloverStrategy, class=org.apache.logging.log4j.core.appender.rolling.DefaultRolloverStrategy].
2023-01-04 09:35:37,421 main DEBUG DefaultRolloverStrategy$Builder(max="30", min="null", fileIndex="null", compressionLevel="null", ={}, stopCustomActionsOnError="null", tempCompressedFilePattern="null", Configuration(HiveLog4j2))
2023-01-04 09:35:37,421 main DEBUG Building Plugin[name=appender, class=org.apache.logging.log4j.core.appender.RollingRandomAccessFileAppender].
2023-01-04 09:35:37,422 main DEBUG RollingRandomAccessFileAppender$Builder(fileName="/tmp/mango/hive.log", filePattern="/tmp/mango/hive.log.%d{yyyy-MM-dd}", append="null", Policies(CompositeTriggeringPolicy(policies=[TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=true)])), DefaultRolloverStrategy(DefaultRolloverStrategy(min=1, max=30, useMax=true)), advertise="null", advertiseURI="null", filePermissions="null", fileOwner="null", fileGroup="null", bufferedIo="null", bufferSize="null", immediateFlush="null", ignoreExceptions="null", PatternLayout(%d{ISO8601} %5p [%t] %c{2}: %m%n), name="DRFA", Configuration(HiveLog4j2), Filter=null, ={})
2023-01-04 09:35:37,422 main DEBUG PluginManager 'FileConverter' found 3 plugins
2023-01-04 09:35:37,422 main DEBUG Initializing triggering policy TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=true)
2023-01-04 09:35:37,423 main DEBUG Building Plugin[name=appenders, class=org.apache.logging.log4j.core.config.AppendersPlugin].
2023-01-04 09:35:37,423 main DEBUG createAppenders(={console, DRFA})
2023-01-04 09:35:37,423 main DEBUG Configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@23aae55 initialized
2023-01-04 09:35:37,423 main DEBUG Starting configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@23aae55
2023-01-04 09:35:37,423 main DEBUG Started configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@23aae55 OK.
2023-01-04 09:35:37,424 main DEBUG Shutting down OutputStreamManager SYSTEM_OUT.false.false-2
2023-01-04 09:35:37,424 main DEBUG OutputStream closed
2023-01-04 09:35:37,424 main DEBUG Shut down OutputStreamManager SYSTEM_OUT.false.false-2, all resources released: true
2023-01-04 09:35:37,424 main DEBUG Appender DefaultConsole-2 stopped with status true
2023-01-04 09:35:37,424 main DEBUG Stopped org.apache.logging.log4j.core.config.DefaultConfiguration@2fb68ec6 OK
2023-01-04 09:35:37,425 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29
2023-01-04 09:35:37,426 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=StatusLogger
2023-01-04 09:35:37,426 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=ContextSelector
2023-01-04 09:35:37,426 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=org.apache.hadoop.hive.ql.log.PerfLogger
2023-01-04 09:35:37,426 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=
2023-01-04 09:35:37,426 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=com.amazonaws
2023-01-04 09:35:37,427 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=DataNucleus
2023-01-04 09:35:37,427 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=Datastore
2023-01-04 09:35:37,427 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=org.apache.zookeeper.ClientCnxnSocketNIO
2023-01-04 09:35:37,427 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=org.apache.zookeeper.server.NIOServerCnxn
2023-01-04 09:35:37,427 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=JPOX
2023-01-04 09:35:37,428 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Loggers,name=org.apache.http
2023-01-04 09:35:37,428 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Appenders,name=console
2023-01-04 09:35:37,428 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a4f0f29,component=Appenders,name=DRFA
2023-01-04 09:35:37,429 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29
2023-01-04 09:35:37,430 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=AsyncLoggerRingBuffer
2023-01-04 09:35:37,430 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=StatusLogger
2023-01-04 09:35:37,431 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=ContextSelector
2023-01-04 09:35:37,431 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=Loggers,name=org.apache.hadoop.hive.ql.log.PerfLogger
2023-01-04 09:35:37,431 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=Loggers,name=
2023-01-04 09:35:37,431 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=Loggers,name=com.amazonaws
2023-01-04 09:35:37,432 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=Loggers,name=DataNucleus
2023-01-04 09:35:37,432 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=Loggers,name=Datastore
2023-01-04 09:35:37,432 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=Loggers,name=org.apache.zookeeper.ClientCnxnSocketNIO
2023-01-04 09:35:37,432 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=Loggers,name=org.apache.zookeeper.server.NIOServerCnxn
2023-01-04 09:35:37,433 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=Loggers,name=JPOX
2023-01-04 09:35:37,433 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=Loggers,name=org.apache.http
2023-01-04 09:35:37,433 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=Appenders,name=console
2023-01-04 09:35:37,433 main DEBUG Registering MBean org.apache.logging.log4j2:type=AsyncContext@7a4f0f29,component=Appenders,name=DRFA
2023-01-04 09:35:37,433 main DEBUG LoggerContext[name=AsyncContext@7a4f0f29, org.apache.logging.log4j.core.async.AsyncLoggerContext@5c09d180] started OK with configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@23aae55.
2023-01-04 09:35:37,440 main DEBUG org.apache.logging.log4j.core.util.SystemClock supports precise timestamps.
2023-01-04 09:35:37,440 main DEBUG AsyncLogger.ThreadNameStrategy=UNCACHED (user specified null, default is UNCACHED)
Hive Session ID = f66867f6-9256-4728-9e90-233d1b09ce31
> On Jan 4, 2023, at 9:32 AM, Joe Lin <gu...@yahoo.com> wrote:
>
> I turned the root logger in conf/log level to debug and see only the following in /tmp/{user}/hive.log
>
> 2023-01-04T09:23:08,223 INFO [main] conf.HiveConf: Found configuration file file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/conf/hive-site.xml
> 2023-01-04T09:23:08,613 INFO [main] server.HiveServer2: STARTUP_MSG:
> /************************************************************
> STARTUP_MSG: Starting HiveServer2
> STARTUP_MSG: host = kawaii/127.0.1.1
> STARTUP_MSG: args = [-H]
> STARTUP_MSG: version = 4.0.0-alpha-2
>
> And the console still showing no error.
>
> ango@kawaii:~/tools/apache-hive-4.0.0-alpha-2-bin$ $HIVE_HOME/bin/hiveserver2
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
> 2023-01-04 09:28:45: Starting HiveServer2
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
> Hive Session ID = 7acfd08c-2ef5-40a3-866d-a938d5b53fbe
> Hive Session ID = 1be57fe4-1bd4-4819-8aad-9966cba51049
> Hive Session ID = cf7b52e0-37f1-4323-a625-c44229b60d6b
>
> Does hiveserver2 have some detail log somewhere else?
>
> Thanks.
>
>> On Jan 3, 2023, at 8:21 PM, Naveen Gangam <ng...@cloudera.com> wrote:
>>
>> Hi Jon,
>> Could you please attach the full hiveserver logfile please?
>>
>> Thank you
>>
>> On Tue, Jan 3, 2023 at 12:42 PM Joe Lin via user <user@hive.apache.org <ma...@hive.apache.org>> wrote:
>>> I downloaded Hive 4.0.0-alpha-2 tar.gz and install along with with Hadoop 3.3 on Ubuntu 22.04.
>>>
>>> I followed the instruction in the “Getting started guide” till running HiveServer2 and Beeline (https://cwiki.apache.org/confluence/display/Hive//GettingStarted#GettingStarted-RunningHiveServer2andBeeline.1).
>>>
>>> I have two problems and could not get beeline too talk to hiveserver2.
>>>
>>> When I started hive servers the below is what shown on the console. There’s no error. But I see no process binding on TCP port 10000 using “netstat".
>>>
>>> So when I started beeline with
>>> $HIVE_HOME/bin/beeline -u jdbc:hive2://localhost:10000
>>>
>>> It errors out with:
>>> Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: java.net.ConnectException: Connection refused (state=08S01,code=0)
>>>
>>> I then tried with
>>> $HIVE_HOME/bin/beeline -u jdbc:hive2://
>>>
>>> It errors out with
>>> Connecting to jdbc:hive2://
>>> 23/01/03 09:39:10 [main]: WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
>>> Hive Session ID = 19274fb7-07af-42a5-8e52-d42815ddbbeb
>>> java.lang.ExceptionInInitializerError
>>> Connection is already closed.
>>>
>>> Thanks for any help.
>>>
>>>
>>>
>>>
>>>
>>> ====== hiveserver2 output
>>> mango@kawaii:~$ $HIVE_HOME/bin/hiveserver2
>>> SLF4J: Class path contains multiple SLF4J bindings.
>>> SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>>> SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
>>> SLF4J: Class path contains multiple SLF4J bindings.
>>> SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>>> SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
>>> 2023-01-03 09:33:22: Starting HiveServer2
>>> SLF4J: Class path contains multiple SLF4J bindings.
>>> SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>>> SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
>>> Hive Session ID = ab6cd9b8-f56d-4f5e-a809-bdc862d29c57
>
Re: Hive 4.0.0-alpha-2 + Hadoop 3.3.1. Can't start beeline. Need help
Posted by Joe Lin via user <us...@hive.apache.org>.
I turned the root logger in conf/log level to debug and see only the following in /tmp/{user}/hive.log
2023-01-04T09:23:08,223 INFO [main] conf.HiveConf: Found configuration file file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/conf/hive-site.xml
2023-01-04T09:23:08,613 INFO [main] server.HiveServer2: STARTUP_MSG:
/************************************************************
STARTUP_MSG: Starting HiveServer2
STARTUP_MSG: host = kawaii/127.0.1.1
STARTUP_MSG: args = [-H]
STARTUP_MSG: version = 4.0.0-alpha-2
And the console still showing no error.
ango@kawaii:~/tools/apache-hive-4.0.0-alpha-2-bin$ $HIVE_HOME/bin/hiveserver2
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
2023-01-04 09:28:45: Starting HiveServer2
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
Hive Session ID = 7acfd08c-2ef5-40a3-866d-a938d5b53fbe
Hive Session ID = 1be57fe4-1bd4-4819-8aad-9966cba51049
Hive Session ID = cf7b52e0-37f1-4323-a625-c44229b60d6b
Does hiveserver2 have some detail log somewhere else?
Thanks.
> On Jan 3, 2023, at 8:21 PM, Naveen Gangam <ng...@cloudera.com> wrote:
>
> Hi Jon,
> Could you please attach the full hiveserver logfile please?
>
> Thank you
>
> On Tue, Jan 3, 2023 at 12:42 PM Joe Lin via user <user@hive.apache.org <ma...@hive.apache.org>> wrote:
>> I downloaded Hive 4.0.0-alpha-2 tar.gz and install along with with Hadoop 3.3 on Ubuntu 22.04.
>>
>> I followed the instruction in the “Getting started guide” till running HiveServer2 and Beeline (https://cwiki.apache.org/confluence/display/Hive//GettingStarted#GettingStarted-RunningHiveServer2andBeeline.1).
>>
>> I have two problems and could not get beeline too talk to hiveserver2.
>>
>> When I started hive servers the below is what shown on the console. There’s no error. But I see no process binding on TCP port 10000 using “netstat".
>>
>> So when I started beeline with
>> $HIVE_HOME/bin/beeline -u jdbc:hive2://localhost:10000
>>
>> It errors out with:
>> Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: java.net.ConnectException: Connection refused (state=08S01,code=0)
>>
>> I then tried with
>> $HIVE_HOME/bin/beeline -u jdbc:hive2://
>>
>> It errors out with
>> Connecting to jdbc:hive2://
>> 23/01/03 09:39:10 [main]: WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
>> Hive Session ID = 19274fb7-07af-42a5-8e52-d42815ddbbeb
>> java.lang.ExceptionInInitializerError
>> Connection is already closed.
>>
>> Thanks for any help.
>>
>>
>>
>>
>>
>> ====== hiveserver2 output
>> mango@kawaii:~$ $HIVE_HOME/bin/hiveserver2
>> SLF4J: Class path contains multiple SLF4J bindings.
>> SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>> SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
>> SLF4J: Class path contains multiple SLF4J bindings.
>> SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>> SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
>> 2023-01-03 09:33:22: Starting HiveServer2
>> SLF4J: Class path contains multiple SLF4J bindings.
>> SLF4J: Found binding in [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>> SLF4J: Found binding in [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
>> Hive Session ID = ab6cd9b8-f56d-4f5e-a809-bdc862d29c57
Re: Hive 4.0.0-alpha-2 + Hadoop 3.3.1. Can't start beeline. Need help
Posted by Naveen Gangam <ng...@cloudera.com>.
Hi Jon,
Could you please attach the full hiveserver logfile please?
Thank you
On Tue, Jan 3, 2023 at 12:42 PM Joe Lin via user <us...@hive.apache.org>
wrote:
> I downloaded Hive 4.0.0-alpha-2 tar.gz and install along with with Hadoop
> 3.3 on Ubuntu 22.04.
>
> I followed the instruction in the “Getting started guide” till running
> HiveServer2 and Beeline (
> https://cwiki.apache.org/confluence/display/Hive//GettingStarted#GettingStarted-RunningHiveServer2andBeeline.1
> ).
>
> I have two problems and could not get beeline too talk to hiveserver2.
>
> When I started hive servers the below is what shown on the console.
> There’s no error. But I see no process binding on TCP port 10000 using
> “netstat".
>
> So when I started beeline with
>
> $HIVE_HOME/bin/beeline -u jdbc:hive2://localhost:10000
>
>
> It errors out with:
>
> Error: Could not open client transport with JDBC Uri:
> jdbc:hive2://localhost:10000: java.net.ConnectException: Connection refused
> (state=08S01,code=0)
>
> I then tried with
>
> $HIVE_HOME/bin/beeline -u jdbc:hive2://
>
>
> It errors out with
>
> Connecting to jdbc:hive2://
>
> 23/01/03 09:39:10 [main]: WARN util.NativeCodeLoader: Unable to load
> native-hadoop library for your platform... using builtin-java classes where
> applicable
>
> Hive Session ID = 19274fb7-07af-42a5-8e52-d42815ddbbeb
>
> java.lang.ExceptionInInitializerError
>
> Connection is already closed.
>
> Thanks for any help.
>
>
>
>
>
> ====== hiveserver2 output
>
> mango@kawaii:~$ $HIVE_HOME/bin/hiveserver2
>
> SLF4J: Class path contains multiple SLF4J bindings.
>
> SLF4J: Found binding in
> [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>
> SLF4J: Found binding in
> [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
>
> SLF4J: Class path contains multiple SLF4J bindings.
>
> SLF4J: Found binding in
> [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>
> SLF4J: Found binding in
> [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
>
> 2023-01-03 09:33:22: Starting HiveServer2
>
> SLF4J: Class path contains multiple SLF4J bindings.
>
> SLF4J: Found binding in
> [jar:file:/home/mango/tools/apache-hive-4.0.0-alpha-2-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>
> SLF4J: Found binding in
> [jar:file:/home/mango/tools/hadoop-3.3.1/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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.apache.logging.slf4j.Log4jLoggerFactory]
>
> Hive Session ID = ab6cd9b8-f56d-4f5e-a809-bdc862d29c57
>