About bandarusridhar1

VidyaSargur · ‎09-03-2023

@Ankita3087, Welcome to Cloudera Community. As this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.

tencentemr · ‎02-21-2023

Nice,works for me. chown -R hive.hive /tmp/hive same errors and my hive-tmp dir like this drwxr-xr-x 3 yarn yarn 19 Feb 15 17:22 hive

Kartik_Agarwal · ‎10-11-2021

To resolve the issue, import the Ambari certificates to the Ambari truststore. To import the Ambari certificates, do the following: STEP 1: Get certificate from ambari-server echo | openssl s_client -showcerts -connect <AMBARI_HOst>:<AMBARI_HTTPs_PORT> 2>&1 | sed --quiet '/-BEGIN CERTIFICATE-/,/-END CERTIFICATE-/p' > /tmp/ambari_certificate.cr STEP 2: Get path of ambari trustore and truststore password from Ambari properties cat /etc/ambari-server/conf/ambari.properties |grep truststore As per your ambari.properties below is the path and password :- ssl.trustStore.password=refer from ambari.property file ssl.trustStore.path=/etc/ambari-server/conf/ambari-server-truststore STEP 3: keytool -importcert -file /tmp/ambari_certificate.crt -keystore <keystore-path> STEP 4: ambari-server restart

VidyaSargur · ‎05-21-2021

Hi @Rajuambala as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.

BernaB · ‎08-11-2020

Hello AM47, To handle space in user/group name, HTML encode it: %20 for space. curl --insecure -u admin:<password> -H 'X-Requested-By: ambari' -X DELETE 'https://ambarihostname:8080/api/v1/groups/AB%20CD ' Regards. Rafa B.

oudaysaada · ‎04-02-2020

there are many repo for ambari and 2.7.5 is not paid prefer to download it directly from https://cwiki.apache.org/confluence/display/AMBARI/Installation+Guide+for+Ambari+2.7.5 or install 2.7.3 ambari repo for hdp 3.1.4 for ubuntu : http://www.olric.org/2019/09/install-single-node-hortonworks-data.html or https://docs.cloudera.com/HDPDocuments/Ambari-2.7.3.0/bk_ambari-installation/content/ch04s01s06.html for centos install this repo https://docs.cloudera.com/HDPDocuments/Ambari-2.7.3.0/bk_ambari-installation/content/download_the_ambari_repo_lnx7.html

csguna · ‎12-12-2019

Could you try performing the "Validate hivemetastore schema " from Cloudera manager - > Hive service then Let us know if you are able to create the same table.

picapitt · ‎05-23-2018

Thank you @Sridhar, I did shut down using Ambari, so I think I did graceful shutdown. I think three is minimum for datanode and I like to make sure it is working alone.

khanarshadazmat · ‎05-15-2018

Thanks @Kuldeep Kulkarni it worked for us as well.

bandarusridhar1 · ‎04-19-2018

With HIVE-13670 Till today we need to remember the complete Hive Connection String either you are using direct 1000 port or ZK connection string. After the above Jira we can optimize that by setting up the environment variable(/etc/profile) on the Edge nodes. export BEELINE_URL_HIVE="<jdbc url>" Example: export BEELINE_URL_HIVE="jdbc:hive2://<ZOOKEEPER QUORUM>/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" Now just type beeline -u HIVE Even we can setup multiple connection strings just by setting different naming connections like BEELINE_URL_BATCH, BEELIVE_URL_LLAP. Hope this helps you.

Online	Offline
Last Visited	‎04-28-2023 03:22 PM

Member Since	‎04-13-2016 05:38 PM
Last Visited	‎04-28-2023 03:22 PM
Posts	422
Kudos received	149

Cloudera Community

Re: yarn local cache on ssd

Re: Where to add timeout configuration for hive on...

Re: restrict user access to queues

Re: How create blueprint of existing cluster and h...

Re: Not able to run HDFS command

Re: How actually namenode HA QJM works?

Re: hiveserver2 not starting using ambari

Re: yarn queue manager error: Couldn't connect to ...

Re: Centralized DB for multiple hue servers

Re: Automate the Ambari LDAP sync

Re: Unable to access Ambari repo

Re: Unable to create Hive external table after del...

Re: HA is not working in case of 2 Datanode and 1 ...

Re: Unable to restrat standby Namenode

Easy way Hive Connection String Setup