Member since
02-03-2016
123
Posts
23
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
3832 | 04-13-2017 08:09 AM |
10-31-2016
01:58 PM
Hi @Kuldeep Kulkarni.....we are selecting new MySQL instance while adding the Hive service so MySQL is not pre-configured. We have deleted the service from Ambari as Hive services are having issues.
... View more
10-31-2016
01:32 PM
adding the snapshot of ambari-alerts.log ambari-alerts.jpg
... View more
10-31-2016
01:24 PM
Hi, Ambari server log snippet below and 3306 port is open. 31 Oct 2016 18:52:09,307 INFO [ambari-client-thread-23] AbstractProviderModule:953 - Current Metrics collector Host : null
31 Oct 2016 18:52:09,308 INFO [ambari-client-thread-23] AbstractProviderModule:958 - New Metrics collector Host : nn.tcsgegdc.com
31 Oct 2016 18:52:10,792 INFO [ambari-heartbeat-processor-0] ServiceComponentHostImpl:1067 - Host role transitioned to a new state, serviceComponentName=HCAT, hostName=dn2.tcsgegdc.com, oldState=INSTALLING, currentState=INSTALLED
31 Oct 2016 18:52:13,741 ERROR [ambari-heartbeat-processor-0] HeartbeatProcessor:554 - Operation failed - may be retried. Service component host: HIVE_CLIENT, host: dn2.tcsgegdc.com Action id 83-0 and Task id 384
31 Oct 2016 18:52:13,753 INFO [ambari-heartbeat-processor-0] ServiceComponentHostImpl:1067 - Host role transitioned to a new state, serviceComponentName=HIVE_CLIENT, hostName=dn2.tcsgegdc.com, oldState=INSTALLING, currentState=INSTALL_FAILED
31 Oct 2016 18:52:13,796 INFO [ambari-heartbeat-processor-0] ServiceComponentHostImpl:1067 - Host role transitioned to a new state, serviceComponentName=HIVE_METASTORE, hostName=dn2.tcsgegdc.com, oldState=INSTALLING, currentState=INSTALLED
31 Oct 2016 18:52:14,593 WARN [ambari-action-scheduler] ActionScheduler:415 - HIVE_CLIENT failed, request 83 will be aborted
31 Oct 2016 18:52:14,593 ERROR [ambari-action-scheduler] ActionScheduler:428 - Operation completely failed, aborting request id: 83
31 Oct 2016 18:52:14,606 INFO [ambari-action-scheduler] ServiceComponentHostImpl:1067 - Host role transitioned to a new state, serviceComponentName=HIVE_SERVER, hostName=dn2.tcsgegdc.com, oldState=INSTALLING, currentState=INSTALL_FAILED
31 Oct 2016 18:52:14,614 INFO [ambari-action-scheduler] ServiceComponentHostImpl:1067 - Host role transitioned to a new state, serviceComponentName=MYSQL_SERVER, hostName=dn2.tcsgegdc.com, oldState=INSTALLING, currentState=INSTALL_FAILED
31 Oct 2016 18:52:14,623 INFO [ambari-action-scheduler] ServiceComponentHostImpl:1067 - Host role transitioned to a new state, serviceComponentName=WEBHCAT_SERVER, hostName=dn2.tcsgegdc.com, oldState=INSTALLING, currentState=INSTALL_FAILED
31 Oct 2016 18:52:14,632 INFO [ambari-action-scheduler] ActionDBAccessorImpl:218 - Aborting command. Hostname dn2.tcsgegdc.com role HIVE_SERVER requestId null taskId 386 stageId null
31 Oct 2016 18:52:14,632 INFO [ambari-action-scheduler] ActionDBAccessorImpl:218 - Aborting command. Hostname dn2.tcsgegdc.com role MYSQL_SERVER requestId null taskId 387 stageId null
31 Oct 2016 18:52:14,632 INFO [ambari-action-scheduler] ActionDBAccessorImpl:218 - Aborting command. Hostname dn2.tcsgegdc.com role WEBHCAT_SERVER requestId null taskId 388 stageId null
31 Oct 2016 18:52:14,747 INFO [ambari-heartbeat-processor-0] HeartbeatProcessor:626 - Security of service component HCAT of service HIVE of cluster TCSGEINTERNALCLUSTER has changed from UNSECURED to UNKNOWN on host dn2.tcsgegdc.com
... View more
10-31-2016
01:13 PM
Please note that all the pre-requisites like SSH setup, THP disable, SELinux disable, iptables disable have been done in all the nodes in the cluster.
... View more
10-31-2016
01:09 PM
Hi Team, We have set up a 3 node HDP 2.5 cluster using CentOS 6.5. When we are trying to add the Hive service from Ambari in that cluster we are receiving connection refused error (error happening in all the 3 nodes). However, we have successfully added other services without any issues. Please note that while adding service we are selecting New MySQL database, there is no existing MySQL database in that cluster. Need your help to address the issue. Error stack given below which came under "Hive Client Install" while adding the Hive service. Traceback (most recent call last):
File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_client.py", line 68, in <module>
HiveClient().execute()
File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 280, in execute
method(env)
File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_client.py", line 35, in install
self.configure(env)
File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_client.py", line 43, in configure
hive(name='client')
File "/usr/lib/python2.6/site-packages/ambari_commons/os_family_impl.py", line 89, in thunk
return fn(*args, **kwargs)
File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive.py", line 282, in hive
mode = 0644,
File "/usr/lib/python2.6/site-packages/resource_management/core/base.py", line 155, in __init__
self.env.run()
File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 160, in run
self.run_action(resource, action)
File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 124, in run_action
provider_action()
File "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py", line 123, in action_create
content = self._get_content()
File "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py", line 160, in _get_content
return content()
File "/usr/lib/python2.6/site-packages/resource_management/core/source.py", line 51, in __call__
return self.get_content()
File "/usr/lib/python2.6/site-packages/resource_management/core/source.py", line 193, in get_content
web_file = opener.open(req)
File "/usr/lib64/python2.6/urllib2.py", line 391, in open
response = self._open(req, data)
File "/usr/lib64/python2.6/urllib2.py", line 409, in _open
'_open', req)
File "/usr/lib64/python2.6/urllib2.py", line 369, in _call_chain
result = func(*args)
File "/usr/lib64/python2.6/urllib2.py", line 1190, in http_open
return self.do_open(httplib.HTTPConnection, req)
File "/usr/lib64/python2.6/urllib2.py", line 1165, in do_open
raise URLError(err)
urllib2.URLError: <urlopen error [Errno 111] Connection refused>
... View more
Labels:
02-19-2016
01:48 PM
1 Kudo
Hi @Artem Ervits facing same issue after using --driver in the sqoop command. Currently downloading the latest jar file. Shall we go ahead and replace the old one with this new one? Command used: sqoop import --connect jdbc:mysql://3.209.124.206:3306/test --username trucker1 --password trucker --table DRIVERS -m 1 --driver com.mysql.jdbc.Driver --target-dir demo$1 --hive-import --hive-table hortondrivers$1
... View more
02-19-2016
01:41 PM
1 Kudo
Thanks @Artem Ervits. I can see the current version is mysql-connector-java-5.1.17-6.el6.noarch. Downloading the latest version from mysql site. Will let you know the results if the latest jar works or not.
... View more
02-19-2016
01:33 PM
1 Kudo
With HDp 2.3.4.0 sqoop of version 1.4.6.2.3 comes. My sql jar file was downloaded through yum during cluster set up. However, downloading the latest jar file frm https://dev.mysql.com/downloads/file/?id=13520. Will let you know if this jar file works or not.
... View more
02-19-2016
01:21 PM
Jar is already at the mentioned path. Screenshot has been attached. sqoop-lib.jpg
... View more
02-19-2016
01:19 PM
1 Kudo
Hi @Neeraj Sabharwal & @Artem Ervits thanks for your points but the jar is already at the mentioned path. Attaching the screenshot. sqoop-lib.jpg
... View more
- « Previous
- Next »