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 <ngan...@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
> <mailto:user@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
