You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Colman Madden (JIRA)" <ji...@apache.org> on 2014/11/26 02:03:12 UTC
[jira] [Created] (HIVE-8968) Changing hive metastore to sql server
causes an error
Colman Madden created HIVE-8968:
-----------------------------------
Summary: Changing hive metastore to sql server causes an error
Key: HIVE-8968
URL: https://issues.apache.org/jira/browse/HIVE-8968
Project: Hive
Issue Type: Bug
Components: Build Infrastructure
Affects Versions: 0.13.0
Environment: HDP 2.1, On CentOS
Reporter: Colman Madden
Priority: Minor
Fix For: 0.14.0, 0.13.1
The following script does not cater for the microsoft JDBC driver
/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/params.py
It only caters for mysql, postgres and oracle drivers as below:
hive_jdbc_driver = config['configurations']['hive-site']['javax.jdo.option.ConnectionDriverName']
if hive_jdbc_driver == "com.mysql.jdbc.Driver":
jdbc_jar_name = "mysql-connector-java.jar"
elif hive_jdbc_driver == "org.postgresql.Driver":
jdbc_jar_name = "postgresql-jdbc.jar"
elif hive_jdbc_driver == "oracle.jdbc.driver.OracleDriver":
jdbc_jar_name = "ojdbc6.jar"
We needed to add in the following two lines in order to get it to work with the sql server JDBC:
elif hive_jdbc_driver == "com.microsoft.sqlserver.jdbc.SQLServerDriver":
jdbc_jar_name = "sqljdbc4.jar"
We have only implemented this on our own cluster and it appears to work without issue.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)