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
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 1 | next ›
Discussion Overview
groupdev @
categorieshive, hadoop
postedNov 26, '14 at 1:03a
activeNov 26, '14 at 1:03a

1 user in discussion

Colman Madden (JIRA): 1 post



site design / logo © 2022 Grokbase