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.

MySQL issue- Installation hive on the master secondary server

MySQL issue- Installation hive on the master secondary server

Rising Star

Hi,

I'm installing HDP2.6 in our small cluster : (two master nodes, one Ambari server and some slave nodes) . During Hive configuration and setting mysql connection , which is trying to connect to separate MYSQL server, i keep getting mysql.jar file error.

On the Ambri server, i can confirm that

hive-schema-0.13.0.mysql.sql under "/var/lib/ambari-server/resources/stacks/HDP/2.1/services/HIVE/etc" exit with the right permission and also under both master secondary server and Ambari server the "mysql-connector-java.jar" is exist under "/usr/share/java" with the right permission.

From both Ambari and Master node, i can connect to the mysql server.

I restart Ambari server also after adding the jars but still not luck.

Could you please advise what did i miss?

Thanks

SJ

2 REPLIES 2
Highlighted

Re: MySQL issue- Installation hive on the master secondary server

Super Mentor

@Sanaz Janbakhsh

Can you please share the exact error that you see?

Highlighted

Re: MySQL issue- Installation hive on the master secondary server

Mentor

@Sanaz Janbakhsh

HDP 2.6 uses InnoDB and NOT MyISAM can you validate using the below script

select engine 
from   information_schema.tables 
where  table_schema = 'schema_name'
   and table_name = 'table_name' 

You can change between storage engines using alter table:

alter table the_table engine = InnoDB;

Unfortunately the storage engine is specified per table. If you want to change it, you'd have to alter the table there is no alter database option.

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