@iamfromsky  Thanks for sharing the details. ... View more

Generally a container which ends with 000001(example:container_XXX_XXXXXXXXXXXXX_XXXXXX_XX_000001) is the Application Master. Just cross-check whether you are checking the same to confirm it is an AM. ... View more

Q: Can I use CDH to get familiar with Hadoop, MapReduce, and so on?  If so, can you point me in the right direction, please?  Yes, you can please follow the below link to install CDH in VM, but I believe you need credentials to do it https://docs.cloudera.com/documentation/enterprise/latest/topics/installation.html   If you want to use Hortonworks you can use the below link to install a sandbox https://www.cloudera.com/tutorials/sandbox-deployment-and-install-guide.html ... View more

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

Hello @iamfromsky    Upon checking the shared logs I can see that one of your Nodemanager(dataware-14/10.39.58.19) is trying to connect a Nodemanager dataware-3 on port 1079 and it got failed with Connection timed out. You may need to check Nodemanager log of dataware-14, dataware-3 and active resource manager log around 2021-04-25 13:51:45 to find more insight.   The connection timed out could happen because of a couple of reasons and it is listed in https://cwiki.apache.org/confluence/display/HADOOP2/ConnectionRefused. It is highly recommended to cross-check all the steps mentioned in the link.   There is a high chance of network issues on these nodes. Please check with Linux admin team as well. ... 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