Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

When I am trying to add service Spark(from add services through Ambari UI) in HDF3.0.2 its not working properly.

Highlighted

When I am trying to add service Spark(from add services through Ambari UI) in HDF3.0.2 its not working properly.

 
8 REPLIES 8
Highlighted

Re: When I am trying to add service Spark(from add services through Ambari UI) in HDF3.0.2 its not working properly.

Hi @rutuja jagtap

Can you please give us more details on contexte and error?

HDF doesn't have Spark. Are you trying to install HDP and HDF with the same Ambari?

Highlighted

Re: When I am trying to add service Spark(from add services through Ambari UI) in HDF3.0.2 its not working properly.

As per attached image I am adding spark service , which is pre-configured but not started on HDF installation.

By adding Spark manually Hive Metastore is not starting.

I have attached screenshots of log file.

img-28022018-101932-0.png

img-28022018-112856-0.png

img-28022018-101703-0.png


spark-issue.png
Highlighted

Re: When I am trying to add service Spark(from add services through Ambari UI) in HDF3.0.2 its not working properly.

Mentor

@rutuja jagtap

Its an authorization problem could you run the below steps as root against the MySQL where FQDN is the hostname of in this case the sandbox

# Hive user setup

# mysql -u root -p 
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'localhost'; 
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%'; 
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'{FQDN}'; 
GRANT ALL PRIVILEGES ON hive.* TO 'hive'@'localhost' IDENTIFIED BY 'hive' WITH 
GRANT OPTION; GRANT ALL PRIVILEGES ON hive.* TO 'hive'@'{FQDN}' IDENTIFIED BY 'hive' WITH GRANT OPTION; 
FLUSH PRIVILEGES; quit;

Please revert

Re: When I am trying to add service Spark(from add services through Ambari UI) in HDF3.0.2 its not working properly.

@rutuja jagtap

To piggyback on what @Geoffrey Shelton Okot wrote, you'll need to set up a couple of things on MySQL. One is the Hive database, and the other is the Hive user and its permissions. The following should work:

# Once SSH'd in to the HDF sandbox:
# mysql -u -phortonworks1

CREATE DATABASE hive DEFAULT CHARACTER SET utf8;
CREATE USER 'hive'@'%' IDENTIFIED BY "$pass";
GRANT ALL PRIVILEGES ON hive.* TO 'hive'@'%' WITH GRANT OPTION;
commit;
quit;

Highlighted

Re: When I am trying to add service Spark(from add services through Ambari UI) in HDF3.0.2 its not working properly.

Not worked.


error.png
Highlighted

Re: When I am trying to add service Spark(from add services through Ambari UI) in HDF3.0.2 its not working properly.

I am getting following error

[root@sandbox-hdf /]# mysql -u root -p

Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[root@sandbox-hdf /]#

Highlighted

Re: When I am trying to add service Spark(from add services through Ambari UI) in HDF3.0.2 its not working properly.

Mentor

@rutuja jagtap

Here is how to change the MySQL root password

# mysql_secure_connection

Answer the questions as shown below:

Change the root password? [Y/n] <-- y
New password: <-- Enter a new MySQL root password
Re-enter new password: <-- Repeat the MySQL root password
Remove anonymous users? [Y/n] <-- y
Disallow root login remotely? [Y/n] <-- y
Remove test database and access to it? [Y/n] <-- y
Reload privilege tables now? [Y/n] <-- y


Hope that helps

Highlighted

Re: When I am trying to add service Spark(from add services through Ambari UI) in HDF3.0.2 its not working properly.

It was showing error mysql_secure_connection command not found

Don't have an account?
Coming from Hortonworks? Activate your account here