Hello @pauljoshiva    You can enable a secure connection between Hiveserver2/Hiveserver2Interactive and Client using SSL and you can find the step-by-step instructions in the below link.   https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.4/configuring-wire-encryption/content/enable_ssl_on_hiveserver2.html   I do not think there is an option to use the PFX file between HS2/HSI and Client. ... View more

Unless your upgrade is finalized you can roll back    https://docs.cloudera.com/documentation/enterprise/upgrade/topics/ug_cdh_upgrade.html#concept_cfj_tdb_x2b https://docs.cloudera.com/documentation/enterprise/upgrade/topics/install_rollback.html#concept_sfz_lqm_y2b ... View more

0: jdbc:hive2://test.domain.com:218> select * from test.student; Error: Error running query: java.lang.AbstractMethodError: org.apache.ranger.authorization.hive.authorizer.RangerHiveAuthorizer.needTransform()Z (state=,code=0) > You may need to check the HS2 logs at the time of issue to figure out the root cause. Is ranger is up and running and the user who is executing the query has enough privilege to list?   0: jdbc:hive2://test.domain.com:218> create table studenta (name STRING); Error: org.apache.hive.service.cli.HiveSQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Exception thrown when executing query : SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS `NUCLEUS_TYPE`,`A0`.`CREATE_TIME`,`A0`.`LAST_ACCESS_TIME`,`A0`.`OWNER`,`A0`.`RETENTION`,`A0`.`IS_REWRITE_ENABLED`,`A0`.`TBL_NAME`,`A0`.`TBL_TYPE`,`A0`.`TBL_ID` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` WHERE `A0`.`TBL_NAME` = ? AND `B0`.`NAME` = ?) > The similar issue had discussed here, it should help you. https://community.cloudera.com/t5/Support-Questions/Error-while-running-query-on-HIVE/td-p/47089 ... View more

Hello @ryu    Good Day. To test/compare Hiveserver2Interactive(LLAP) vs Hiveserver2 you would be required to bring up the LLAP service.   I would say the best place to start implementing LLAP is from below article https://community.hortonworks.com/content/kbentry/149486/llap-sizing-and-setup.html   Please check the below links to get more insight into LLAP https://community.hortonworks.com/content/kbentry/149894/llap-a-one-page-architecture-overview.html https://community.hortonworks.com/content/kbentry/149892/llap-troubleshooting-and-debugging.html https://community.hortonworks.com/content/kbentry/149896/llap-debugging-overview-logs-uis-etc.html https://community.hortonworks.com/content/kbentry/149900/investigating-when-the-queries-on-llap-are-slow-or.html https://community.hortonworks.com/content/kbentry/149901/investigating-llap-cache-hit-rate.html https://community.hortonworks.com/content/kbentry/149998/map-join-memory-sizing-for-llap.html https://community.hortonworks.com/content/kbentry/170868/running-llap-on-specific-nodes-using-yarn-node-lab.html https://community.cloudera.com/t5/Community-Articles/LLAP-debugging-overview-logs-UIs-etc/ta-p/247445 https://community.cloudera.com/t5/Community-Articles/LLAP-sizing-and-setup/ta-p/247425   Thanks Rajkumar ... View more

Adding to Jagadeesan comment.    You can run disk balancer command to balance the disk space across your cluster.   If you are using a multinode hadoop cluster you can follow link - https://hadoop.apache.org/docs/r3.0.0/hadoop-project-dist/hadoop-hdfs/HDFSDiskbalancer.html    or if it is a single node cluster or to balance disk load with in a single data node use the following link - https://blog.cloudera.com/how-to-use-the-new-hdfs-intra-datanode-disk-balancer-in-apache-hadoop/   Let's Hadoop Rajkumar.M ... View more