Support Questions
Find answers, ask questions, and share your expertise

Beeline hiveserver2 Error: java.io.IOException: Packet len67108864 is out of range!

Solved Go to solution

Beeline hiveserver2 Error: java.io.IOException: Packet len67108864 is out of range!

Contributor

Hi,

Can someone please tell me what this error means when trying to connect to hiveserver2 via beeline and how to solve this?

 

[root@test1 ~]# beeline
Beeline version 1.2.1000.2.6.1.0-129 by Apache Hive
beeline> !connect jdbc:hive2://test.domain.com:10000/test;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
Connecting to jdbc:hive2://test.domain.com:10000/test;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
Enter username for jdbc:hive2://test.com:10000/test;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2: name
Enter password for jdbc:hive2://test.domain.com:10000/test;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2: ******************
21/03/01 10:16:28 [main-SendThread(test.com:10000)]: WARN zookeeper.ClientCnxn: Session 0x0 for server test.domain.com/10.49.0.42:10000, unexpected error, closing socket connection and attempting reconnect
java.io.IOException: Packet len67108864 is out of range!
at org.apache.zookeeper.ClientCnxnSocket.readLength(ClientCnxnSocket.java:112)
at org.apache.zookeeper.ClientCnxnSocketNIO.doIO(ClientCnxnSocketNIO.java:79)
at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:366)
at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1125)

 

 

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Beeline hiveserver2 Error: java.io.IOException: Packet len67108864 is out of range!

Master Collaborator

@ryu You should increase the jute buffer for client and server both. For example  -Djute.maxbuffer=100000000 in hive-env. The value is just an example, in short you have to bump up the value from the current value. Check the same for ZK as well. 


Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

View solution in original post

1 REPLY 1

Re: Beeline hiveserver2 Error: java.io.IOException: Packet len67108864 is out of range!

Master Collaborator

@ryu You should increase the jute buffer for client and server both. For example  -Djute.maxbuffer=100000000 in hive-env. The value is just an example, in short you have to bump up the value from the current value. Check the same for ZK as well. 


Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

View solution in original post