SOURCE $HIVE_HOME/scripts/metastore/upgrade/mysql/hive-schema-0.14.0.mysql.sql; ERROR:

0 votes

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

4 days ago in Big Data Hadoop by akhtar
• 1,440 points
17 views

1 answer to this question.

0 votes

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;
answered 4 days ago by MD
• 2,750 points

Related Questions In Big Data Hadoop

0 votes
1 answer

How to configure the metastore service to communicate with the MySQL database in Hive?

Hey, This step shows the configuration properties you ...READ MORE

answered May 29, 2019 in Big Data Hadoop by Gitika
• 25,830 points
70 views
0 votes
1 answer

Failed to upgrade the metastore in Hive?

Hey, If the problem you are having do the ...READ MORE

answered May 29, 2019 in Big Data Hadoop by Gitika
• 25,830 points
42 views
0 votes
1 answer

How to upgrade Apache Hadoop from 2.4.1 to 2.6.0?

If the downtime is not an issue, ...READ MORE

answered Sep 7, 2018 in Big Data Hadoop by Frankie
• 9,810 points
39 views
–1 vote
1 answer

How we can run spark SQL over hive tables in our cluster?

Open spark-shell. scala> import org.apache.spark.sql.hive._ scala> val hc = ...READ MORE

answered Dec 26, 2018 in Big Data Hadoop by Omkar
• 68,940 points
125 views
0 votes
1 answer

Update hdfs data before stroring in MySql

Yes, you can update the data before ...READ MORE

answered Jan 27, 2019 in Big Data Hadoop by Omkar
• 68,940 points
51 views
0 votes
1 answer

Using Hadoop for Data Analytics.

Yes, your approach is correct - you ...READ MORE

answered Sep 28, 2018 in Big Data Hadoop by Frankie
• 9,810 points
57 views
0 votes
1 answer

How to open MySql console in Ubuntu?

sudo service mysqld restart mysql -u <username> root ...READ MORE

answered Dec 14, 2018 in Big Data Hadoop by Omkar
• 68,940 points
226 views
0 votes
1 answer