[
https://issues.apache.org/jira/browse/HIVE-8968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14230855#comment-14230855
]
Sergey Shelukhin commented on HIVE-8968:
----------------------------------------
This might be an Ambari issue. Let me check...
> 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)
