[
https://issues.apache.org/jira/browse/AMBARI-8518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14232628#comment-14232628
]
Jayush Luniya commented on AMBARI-8518:
---------------------------------------
[~colmanmadden] [~sershe]
Using MS SQL Server for HIVE/OOZIE with HDP installation on Linux is not
supported. Infact from the Ambari UI, you should not be seeing the MS SQL
Server database type options being offered in the Ambari UI. I have attached
the Ambari UI snapshot from latest trunk.
> Changing hive metastore to sql server causes an error
> -----------------------------------------------------
>
> Key: AMBARI-8518
> URL: https://issues.apache.org/jira/browse/AMBARI-8518
> Project: Ambari
> Issue Type: Bug
> Environment: HDP 2.1, On CentOS
> Reporter: Colman Madden
> Priority: Minor
> Attachments: Screen Shot 2014-12-02 at 9.44.07 PM.png
>
>
> 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)
