SOURCE HIVE HOME scripts metastore upgrade mysql hive-schema-0 14 0 mysql sql ERROR

Question

Hello everyone,

I tried to connect mysql database with hive. But it shows the below error.

SOURCE $HIVE_HOME/scripts/metastore/upgrade/mysql/hive-schema-0.14.0.mysql.sql;
ERROR:
Failed to open file '$HIVE_HOME/scripts/metastore/upgrade/mysql/hive-schema-0.14.0.mysql.sql', error: 2

Can someone tell me what I am doing wrong?
Thank You

Answer 1

Hi@akhtar,

I think mysql is not able to read the .bashrc file. So change your HIVE_HOME with path. Then try once it will work.

$  SOURCE $ (path of HIVE_HOME)/scripts/metastore/upgrade/mysql/hive-schema-0.14.0.mysql.sql;