Hi Jia Fan, did you check the if metastore started properly as well? On Dockerhub there is Hive version from 4.0, but as I see you tried to use 3.1.3.
Regards, Zoltan Ratkai On Sun, Sep 29, 2024 at 12:10 PM Jia Fan <fanjia1...@gmail.com> wrote: > Hi folks, > I followed the guide[1] to run docker with hive. > These are my shell command: > > ``` > [root@localhost ~]# docker run -d -p 9083:9083 --env > SERVICE_NAME=metastore --name metastore apache/hive:3.1.3 > b8674d57fa252258354b9795eb2098b020f7ea8987f519b51cc158196b3da35f > [root@localhost ~]# docker run -d -p 10000:10000 -p 10002:10002 --env > SERVICE_NAME=hiveserver2 --env > SERVICE_OPTS="-Dhive.metastore.uris=thrift://metastore:9083" --env > IS_RESUME="true" --name hiveserver2-standalone apache/hive:3.1.3 > 4478c26d41aab075da8b014dd0cb64c0ef6baec148872f761b697fc674edfc6b > ``` > > > The hive container seem like started properly. > But I can not start beeline with command: > > ``` > [root@localhost ~]# docker exec -it hiveserver2-standalone beeline -u > 'jdbc:hive2://localhost:10000/' > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/opt/hive/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/opt/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.25.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] > Connecting to jdbc:hive2://localhost:10000/ > 24/09/29 09:53:35 [main]: WARN jdbc.HiveConnection: Failed to connect to > localhost:10000 > Could not open connection to the HS2 server. Please check the server URI > and if the URI is correct, then ask the administrator to check the server > status. > Error: Could not open client transport with JDBC Uri: > jdbc:hive2://localhost:10000/: java.net.ConnectException: Connection > refused (Connection refused) (state=08S01,code=0) > Beeline version 3.1.3 by Apache Hive > [WARN] Failed to create directory: /home/hive/.beeline > No such file or directory > [root@localhost ~]# docker exec -it hiveserver2-standalone beeline -u > 'jdbc:hive2://localhost:10000/' > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/opt/hive/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/opt/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.25.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] > Connecting to jdbc:hive2://localhost:10000/ > 24/09/29 09:59:12 [main]: WARN jdbc.HiveConnection: Failed to connect to > localhost:10000 > Could not open connection to the HS2 server. Please check the server URI > and if the URI is correct, then ask the administrator to check the server > status. > Error: Could not open client transport with JDBC Uri: > jdbc:hive2://localhost:10000/: java.net.ConnectException: Connection > refused (Connection refused) (state=08S01,code=0) > Beeline version 3.1.3 by Apache Hive > [WARN] Failed to create directory: /home/hive/.beeline > No such file or directory > ``` > > Could you give me some help. Thanks. > > [1] https://hub.docker.com/r/apache/hive > > ________________________ > > > Jia Fan >
