Hi experts, I recently installed hive2.3.8 and trying to enable LLAP. I am getting the below error. beeline> !connect jdbc:hive2://test01.domain.com:2181,test02.domain.com:2181,test03.domain.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2 Connecting to jdbc:hive2://test01.domain.com:2181,test02.domain.com:2181,test03.domain.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2 Enter username for jdbc:hive2://test01.domain.com:2181,test02.domain.com:2181,test03.domain.com:2181/: Enter password for jdbc:hive2://test01.domain.com:2181,test02.domain.com:2181,test03.domain.com:2181/: 21/03/24 20:34:01 [main]: INFO jdbc.HiveConnection: Connected to test02.domain.com:10500 21/03/24 20:34:01 [main]: WARN jdbc.HiveConnection: Failed to connect to test02.domain.com:10500 21/03/24 20:34:01 [main]: ERROR jdbc.Utils: Unable to read HiveServer2 configs from ZooKeeper Error: Could not open client transport for any of the Server URI's in ZooKeeper: Failed to open new session: java.lang.IllegalArgumentException: hive configuration hive.server2.thrift.resultset.default.fetch.size does not exists. (state=08S01,code=0) beeline>   Any help is much appreciated.   Thanks, ... View more

Hi experts, I am trying to upgrade my current hive version from 1.2 to 2.3.8. I am able to connect to hive via hiveserver2 but when I do "show databases", there are no databases showing up.   0: jdbc:hive2://test02.domain.com:100> show databases; +----------------+ | database_name | +----------------+ +----------------+ No rows selected (0.124 seconds) 0: jdbc:hive2://test02.domain.com:100>   When accessing the mysql database I can see the databases in hive. mysql> use hive; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from DBS; +-------+-----------------------+-------------------------------------------+---------+------------+------------+ | DB_ID | DESC | DB_LOCATION_URI | NAME | OWNER_NAME | OWNER_TYPE | +-------+-----------------------+-------------------------------------------+---------+------------+------------+ | 1 | Default Hive database | hdfs://test/apps/hive/warehouse | default | public | ROLE | | 6 | NULL | hdfs://test/apps/hive/warehouse/test.db | test | anonymous | USER | | 11 | NULL | hdfs://test/apps/hive/warehouse/test1.db | test1 | anonymous | USER | +-------+-----------------------+-------------------------------------------+---------+------------+------------+ 3 rows in set (0.00 sec)   I have already updated the mysql schema with the script provided. mysql> select * from VERSION; +--------+----------------+----------------------------+ | VER_ID | SCHEMA_VERSION | VERSION_COMMENT | +--------+----------------+----------------------------+ | 1 | 2.3.0 | Hive release version 2.3.0 | +--------+----------------+----------------------------+ 1 row in set (0.00 sec)   When I switch back to the older version of hive 1.2, I am able to see the databases via beeline/hiveserver2.   Can someone please let me know what I am missing? Any help is much appreciated. Thanks, ... View more

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, ... View more

Hi, Can someone please help me and let me know what I did wrong or am I missing something?   [root@sandbox ~]# yarn log -applicationId application_1614345689259_0002 Picked up _JAVA_OPTIONS: -Xmx2048m -XX:MaxPermSize=512m -Djava.awt.headless=true Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512m; support was removed in 8.0 Error: Could not find or load main class log [root@sandbox~]#     Thanks, ... View more

Hi, I was wondering if there is anyway to upgrade our HIVE from an existing HDP cluster? So we have deployed previously a HDP cluster, but the hortonworks public url is currently not accessible, so I was wondering if there was any other way to upgrade our HIVE.   Can someone help please point me in the right direction?   Thanks, ... View more