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

Feb 13, 2020 in Big Data Hadoop by akhtar
• 38,230 points
1,211 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 Feb 13, 2020 by MD
• 95,440 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
• 65,910 points
511 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 30, 2019 in Big Data Hadoop by Gitika
• 65,910 points
386 views
0 votes
0 answers
–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
• 69,210 points
1,106 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
• 69,210 points
560 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,830 points
499 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
• 69,210 points
2,273 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP