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> 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 >
