Hortonworks.com
  • Explore
    • All Tags
    • All Questions
    • All Articles
    • All Ideas
    • All Repos
    • All SKB
    • All Users
    • All Badges
    • Leaderboard
  • Create
    • Ask a question
    • Create Article
    • Post Idea
    • Add Repo
  • Tracks
    • All Tracks
    • Community Help
    • Cloud & Operations
    • CyberSecurity
    • Data Ingestion & Streaming
    • Data Processing
    • Data Science & Advanced Analytics
    • Design & Architecture
    • Governance & Lifecycle
    • Hadoop Core
    • Sandbox & Learning
    • Security
    • Solutions
  • Login
HCC Hortonworks Community Connection
  • Home /
  • Cloud & Operations /
avatar image

Idea by Massoud Mazar · Jan 26 at 03:49 AM · mssqlhive-metastorerestartupgrade

Restarting hive metastore during upgrade fails when using MSSQL JDBC driver

During upgrade, if Hive Metastore is using MSSQL server, the step which tries to restart metastore fails with this error:

resource_management.core.exceptions.ExecutionFailed: Execution of 'cp /usr/hdp/3.0.1.0-187/hive/lib/None /usr/hdp/3.1.0.0-78/hive/lib' returned 1. cp: cannot stat '/usr/hdp/3.0.1.0-187/hive/lib/None': No such file or directory

Workaround: Copy the JDBC driver manually and create a dummy file so script can continue:

sudo cp /usr/hdp/3.0.1.0-187/hive/lib/mssql-jdbc-7.0.0.jre8.jar /usr/hdp/3.1.0.0-78/hive/lib
sudo touch /usr/hdp/3.0.1.0-187/hive/lib/None
thub.nodes.view.add-new-comment

People who voted for this

0 Show 0
10 |6000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 5 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

No Comments

· Add your reply

Write a Comment

Up to 5 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Your Opinion Counts

Help us make things better. Share your great idea for improving Unity or vote for other people's.

Sign in to post a new idea

avatar image avatar image avatar image

Related Ideas

This website uses cookies for analytics, personalisation and advertising. To learn more or change your cookie settings, please read our Cookie Policy. By continuing to browse, you agree to our use of cookies.

HCC Guidelines | HCC FAQs | HCC Privacy Policy | Privacy Policy | Terms of Service

© 2011-2019 Hortonworks Inc. All Rights Reserved.

Hadoop, Falcon, Atlas, Sqoop, Flume, Kafka, Pig, Hive, HBase, Accumulo, Storm, Solr, Spark, Ranger, Knox, Ambari, ZooKeeper, Oozie and the Hadoop elephant logo are trademarks of the Apache Software Foundation.

  • Anonymous
  • Login
  • Create
  • Ask a question
  • Create Article
  • Post Idea
  • Add Repo
  • Create SupportKB
  • Tracks
  • Community Help
  • Cloud & Operations
  • CyberSecurity
  • Data Ingestion & Streaming
  • Data Processing
  • Data Science & Advanced Analytics
  • Design & Architecture
  • Governance & Lifecycle
  • Hadoop Core
  • Sandbox & Learning
  • Security
  • Solutions
  • Explore
  • All Tags
  • All Questions
  • All Articles
  • All Ideas
  • All Repos
  • All SKB
  • All Users
  • Leaderboard
  • All Badges