Member since
09-02-2018
6
Posts
0
Kudos Received
0
Solutions
09-08-2018
10:21 AM
Please run the below command sudo su hdfs hadoop fs -mkdir -p /user/ec2-user hdfs dfs -chown -R ec2-user:ec2-user /user/ec2-user getout from the HDFS login [ec2-user@ip-172-**-*-** ~]$ hive log4j:WARN No such property [maxFileSize] in org.apache.log4j.DailyRollingFileAppender. Logging initialized using configuration in file:/etc/hive/2.6.5.0-292/0/hive-log4j.properties hive>
... View more
09-07-2018
07:52 PM
Hi Geoffrey, @ Geoffrey Shelton Okot Thank you for your suggestion, I have already tried the above solution .In the log it is mentioned that it need gcc to install the metrics . When I am trying to install the gcc rpm ,it is asking for additional libraries ,which I am not able to find out . Please let me know if you know any easier way to install gcc in linux. p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000; background-color: #ffffff}
span.s1 {font-variant-ligatures: no-common-ligatures} --> Running transaction check ---> Package ambari-metrics-monitor.x86_64 0:2.6.2.2-1 will be installed --> Processing Dependency: gcc for package: ambari-metrics-monitor-2.6.2.2-1.x86_64 --> Finished Dependency Resolution 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
... View more
09-07-2018
01:13 PM
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
Labels:
09-05-2018
03:04 AM
@shu Are you using the same sandbox as me ?
... View more
09-05-2018
03:00 AM
Hi Shu, Thank you for your reply , I have copy and pasted your inputs and ddls ,however I am still getting the same 1 row count. I am using the HDP 2.6.5 sandbox. root@sandbox-hdp data]# sandbox-version
== Sandbox Information ==
Platform: hdp-security
Build date: 06-18-2018
Ambari version: 2.6.2.0-155
Hadoop version: Hadoop 2.7.3.2.6.5.0-292
OS: CentOS Linux release 7.5.1804 (Core)
I have no clue ,why this is happening.
... View more
09-04-2018
03:25 PM
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
Labels: