ssh maria_dev@xxx.xxx.xxx.xxx -p 2222 Enter password maria_dev ... View more

@Mukesh Kumar - Login to your Ambari DB. For example postgres then: # psql -U ambari ambari Password for user ambari: bigdata - Then run the following queries to completely remove the Zookeeper service from DB. delete from hostcomponentstate where service_name = 'ZOOKEEPER'; delete from hostcomponentdesiredstate where service_name = 'ZOOKEEPER'; delete from servicecomponentdesiredstate where service_name = 'ZOOKEEPER'; delete from servicedesiredstate where service_name = 'ZOOKEEPER'; delete from alert_current where history_id in (select alert_id from alert_history where service_name = 'ZOOKEEPER'); delete from alert_notice where history_id in (select alert_id from alert_history where service_name = 'ZOOKEEPER'); delete from alert_history where service_name = 'ZOOKEEPER'; delete from alert_grouping where definition_id in (select definition_id from alert_definition where service_name = 'ZOOKEEPER'); delete from alert_history where alert_definition_id in (select definition_id from alert_definition where service_name = 'ZOOKEEPER'); delete from alert_current where definition_id in (select definition_id from alert_definition where service_name = 'ZOOKEEPER'); delete from alert_definition where service_name = 'ZOOKEEPER'; delete from alert_group_target where group_id in ( select group_id from alert_group where service_name = 'ZOOKEEPER'); delete from alert_group where service_name = 'ZOOKEEPER'; delete from serviceconfighosts where service_config_id in (select service_config_id from serviceconfig where service_name = 'ZOOKEEPER'); delete from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'ZOOKEEPER'); delete from serviceconfig where service_name = 'ZOOKEEPER'; delete from requestresourcefilter where service_name = 'ZOOKEEPER'; delete from requestoperationlevel where service_name = 'ZOOKEEPER'; delete from clusterservices where service_name ='ZOOKEEPER'; delete from clusterconfig where type_name like 'zookeeper%'; delete from clusterconfigmapping where type_name like 'zookeeper%'; - Now restart ambari server: # ambari-server restart . Additionally the 500 error for the API call "POST method for API: /api/v1/stacks/HDP/versions/2.5/recommendations." indicates a DB inconsistency. So if it is a fresh cluster then or if you do not want to have any service installed to is and move to the very initial state of ambari installation then better to perform an ambari reset instead of deleting services from ambari UI (As we see you only have zookeeper installed there) # ambari-server reset . *NOTE:* It is always recommended to keep a DB dump as a backup before making any manual DB changes. ... View more

==> Dependency package issue required to set CentOS iso image to be mounted on repository server, and update the repo file, it required during the installation - yum install hadoop hadoop-hdfs hadoop-libhdfs hadoop-yarn hadoop-mapreduce hadoop-client openssl -mount -o loop /<CentOS iso file> /<mount directory> -Update the /etc/yum.repo.d/<CentOS.repo> file -yum repolist repolist show up with-out any issue, then re-try installation. ... View more

wget http://mooc.ttxit.com:8081/repository/maven-snapshots/org/apache/storm/storm-core/1.1.0-SNAPSHOT/storm-core-1.1.0-20170406.185336-1.jar -O ./storm-core-1.1.0-SNAPSHOT.jar mvn install:install-file -Dfile=./storm-core-1.1.0-SNAPSHOT.jar -DgroupId=org.apache.storm -DartifactId=storm-core -Dversion=1.1.0-SNAPSHOT -Dpackaging=jar ... View more

@Viswa Were you able to find the Zookeeper logs? ... View more

Login Ambari WI with admin/admin console. do the service check. 1) Hive :- Click on Hive service and do the Run Service Check . You will get exact error, what is issue and trouble shoot the Issue. 2) Smart Sense you can ignore . 3) Amabri-Metrics :- Click on Ambar-Metricks do the Run Service Check ... View more

@Vipin Rathor Wonderful article!!! I was facing this issue for quite sometime. I will implement the fix to see how it goes. ... View more

hello guys , please where can I modify the tweet , I got the same error with the same tweet (the sentiment analysis tutorial) ?? can't I find it by his id quickly and where? ... View more

Please note DB based auditing is NOT supported from Ranger 0.6 (HDP 2.5) ... View more

@pankaj kushwaha Making sure all the services are stopped and then doing a shutdown command from inside the host VM is your best bet at making sure nothing gets broken. ... View more