@ed day Regarding your query "Can anyone tell me how to check the Java use by HDP/Hive?" You can use the following command to find out which Java Binary it is using . Example: # ps -ef | grep ^hive hive 23474 1 0 Jun02 ? 00:45:46 /usr/jdk64/jdk1.7.0_67/bin/java -Xmx1024m -Dhdp.version=2.5.3.0-37 -Djava.net.preferIPv4Stack=true -Dhdp.version=2.5.3.0-37 -Dhadoop.log.dir=/var/log/hadoop/hive -Dhadoop.log.file=hadoop.log -Dhadoop.home.dir=/usr/hdp/2.5.3.0-37/hadoop -Dhadoop.id.str=hive -Dhadoop.root.logger=INFO,console.......... . Whatever Java binary path it shows , you can run the version command on it Example # /usr/jdk64/jdk1.7.0_67/bin/java -version java version "1.7.0_67" Java(TM) SE Runtime Environment (build 1.7.0_67-b01) Java HotSpot(TM) 64-Bit Server VM (build 24.65-b04, mixed mode) . Changing the java version can be achieved as mentioned in ; https://docs.hortonworks.com/HDPDocuments/Ambari-2.5.1.0/bk_ambari-administration/content/ch_changing_the_jdk_version_on_an_existing_cluster.html ... View more

@John Cleveland One thing i noticed in your command is the PATH of the student_data ... it has "user/admin" should not it be "/user/admin" (A slash is missing) ? LOAD 'user/admin/Pig_Data/student_data.txt' . Are you running the job using logged in user "vagrant" in that case it will try finding the file from the home directory of that user. Because we are specifying the path as "user/admin......" ... View more

@kotesh banoth Looks like you were earlier using OLD "Tech Preview" Zeppelin. . Please try to delete it completely and then start server again. You can delete the Zeppelin from Ambari Database. Step0). Stop Ambari Server. Take Zeppelin Notebook/interpreter backup. # ambari-server stop Step1). First Take a Latest DB Dump. (before making any DB change we should take a DB dump). Step2). Delete the Zepelin service complete from ambari DB using the following DB Queries: delete from hostcomponentstate where service_name = 'ZEPPELIN'; delete from hostcomponentdesiredstate where service_name = 'ZEPPELIN'; delete from servicecomponentdesiredstate where service_name = 'ZEPPELIN'; delete from servicedesiredstate where service_name = 'ZEPPELIN'; delete from alert_current where history_id in (select alert_id from alert_history where service_name = 'ZEPPELIN'); delete from alert_notice where history_id in (select alert_id from alert_history where service_name = 'ZEPPELIN'); delete from alert_history where service_name = 'ZEPPELIN'; delete from alert_grouping where definition_id in (select definition_id from alert_definition where service_name = 'ZEPPELIN'); delete from alert_history where alert_definition_id in (select definition_id from alert_definition where service_name = 'ZEPPELIN'); delete from alert_current where definition_id in (select definition_id from alert_definition where service_name = 'ZEPPELIN'); delete from alert_definition where service_name = 'ZEPPELIN'; delete from alert_group_target where group_id in ( select group_id from alert_group where service_name = 'ZEPPELIN'); delete from alert_group where service_name = 'ZEPPELIN'; delete from serviceconfighosts where service_config_id in (select service_config_id from serviceconfig where service_name = 'ZEPPELIN'); delete from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'ZEPPELIN'); delete from serviceconfig where service_name = 'ZEPPELIN'; delete from requestresourcefilter where service_name = 'ZEPPELIN'; delete from requestoperationlevel where service_name = 'ZEPPELIN'; delete from clusterservices where service_name ='ZEPPELIN'; delete from clusterconfig where type_name like 'zeppelin%'; delete from clusterconfigmapping where type_name like 'zeppelin%'; Step3). Start the Ambari Server. # ambari-server start . ... View more

@Rohit Sharma It's a bug reported here: Zeppelin view doesn't work with JDK 1.8_91+ : https://issues.apache.org/jira/browse/AMBARI-18918 Either downgrade the JDK or Better Upgrade Ambari to 2.5 Ambari 2.5.1 upgrade guide: https://docs.hortonworks.com/HDPDocuments/Ambari-2.5.1.0/bk_ambari-upgrade/content/upgrading_ambari.html ... View more

@Robin Dong 1. Are you running AMS in embedded mode or in external mode? 2. What are the errors you see in the ambari-metrics-collector.log file when you are trying to start it? 3. In your attached screenshot we see NameNode UI, HBaseMaster, NodeManager related critical alerts that might not be directly related to the AMS startup issue. But if in order to see what is going wrong we can take a look on those components logs as well. 4. Do you have sufficient memory on your Host where you are running these processes? # free -m # lsof -p $PID . 5. All the hosts are configured with correct FQDN ? Means the "hostname -f" command output should be resolvable from each clusternodes. # hostname -f . 6. Also can you please check if the Hostname & Port mentioned in the critical alert mentioned in the screen shot are opened or not? Or if there is any firewall issue that is blocking the port access. # telnet ip-172-31-1-92 $PORT . ... View more