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

[#1]

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?

[#2]

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

[#3]

@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

[#4]

@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;

[#5]

Not worked.

[#6]

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 /]#

[#7]

@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

[#8]

It was showing error mysql_secure_connection command not found