Hi Team, I am trying to install Ambari 2.6.2.2 in Amazon ec2/RHEL-6.5_GA-x86_64-7-Hourly2 4node cluster . However during the deployment Grafana is failing to install, please find the below error . If anyone faced similar kind of issue please let me know . 1)It would be great if anyone can suggest the solution to this 2)Which RHEL OS is best suitable for Ambari 2.6.2.2/HDP 2.6.5 2018-09-06 23:51:10,332 - Skipping installation of existing package hdp-select 2018-09-06 23:51:10,336 - The repository with version 2.6.4.0-91 for this command has been marked as resolved. It will be used to report the version of the component which was installed 2018-09-06 23:51:10,338 - Skipping stack-select on AMBARI_METRICS because it does not exist in the stack-select package structure. 2018-09-06 23:51:10,675 - Using hadoop conf dir: /usr/hdp/current/hadoop-client/conf 2018-09-06 23:51:10,683 - checked_call['hostid'] {} 2018-09-06 23:51:10,701 - checked_call returned (0, '1facce0d') 2018-09-06 23:51:10,709 - Package['ambari-metrics-monitor'] {'retry_on_repo_unavailability': False, 'retry_count': 5} 2018-09-06 23:51:10,830 - Installing package ambari-metrics-monitor ('/usr/bin/yum -d 0 -e 0 -y install ambari-metrics-monitor') 2018-09-06 23:51:13,016 - Execution of '/usr/bin/yum -d 0 -e 0 -y install ambari-metrics-monitor' returned 1. Error: Package: ambari-metrics-monitor-2.6.2.2-1.x86_64 (ambari-2.6.2.2) Requires: gcc You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest 2018-09-06 23:51:13,017 - Failed to install package ambari-metrics-monitor. Executing '/usr/bin/yum clean metadata' 2018-09-06 23:51:13,245 - Retrying to install package ambari-metrics-monitor after 30 seconds 2018-09-06 23:51:48,539 - The repository with version 2.6.4.0-91 for this command has been marked as resolved. It will be used to report the version of the component which was installed 2018-09-06 23:51:48,541 - Skipping stack-select on AMBARI_METRICS because it does not exist in the stack-select package structure. Command failed after 1 tries Would appreciate a quick help. ... View more

Hi Team, I am trying to load below json data into hive table(using hdp 2.6.5 sandbox) ,however hive is only returning the first row , please suggest. {"user":{"userlocation":"Cinderford, Gloucestershire","id":230231618,"name":"Aimee","screenname":"Aimee_Cottle","geoenabled":true},"tweetmessage":"Gastroenteritis has pretty much killed me this week 😞 off work for a few days whilst I recover!","createddate":"2013-06-20T12:08:14","geolocation":null} {"user":{"userlocation":"Garena ID : NuraBlazee","id":635239939,"name":"Axyraf.","screenname":"Asyraf_Fauzi","geoenabled":false},"tweetmessage":"RT @abhigyantweets: Can't stop a natural disaster but so many lives in U'khand wouldn't have been lost if there was disaster preparedness. É","createddate":"2013-06-20T12:08:16","geolocation":null} {"user":{"userlocation":"Gemert,Netherlands","id":21418083,"name":"Ad van Steenbruggen","screenname":"torment00","geoenabled":true},"tweetmessage":"? Listening to 'The Constant' by 'Anthrax' from 'Worship Music","createddate":"2013-06-20T12:08:20","geolocation":null} Table structure-: set hive.support.sql11.reserved.keywords=false; CREATE EXTERNAL TABLE tweets ( user STRUCT <userlocation:STRING,id:INT,name:STRING,screenname:STRING,geoenabled:BOOLEAN>, tweetmessage STRING, createddate STRING, geolocation STRING ) ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe' LOCATION '/user/hive/data/'; query-: set hive.cli.print.header=true; hive> select user.screenname, user.name,tweetmessage,createddate from tweets ; OK Aimee_Cottle Aimee Gastroenteritis has pretty much killed me this week 😞 off work for a few days whilst I re cover! 2013-06-20T12:08:14 Kindly let me know , is there any way my query can fetch all the rows from the source Thanks in Advance Jatin ... View more