[
https://issues.apache.org/jira/browse/AMBARI-8518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14232556#comment-14232556
]
Florian Barca commented on AMBARI-8518:
---------------------------------------
[~mahadev], [~sershe]: Apparently you are using SQL Server from the Linux HDP
stack. We didn't have a chance to test that scenario, primarily because we
didn't target cross-platform scenarios so far. Therefore, this issue is one of
the few potential issues that we need to fix in order to access SQL Server from
Linux machines. OOZIE needs that kind of fix too. Also, is HDP 2.0.6 the only
stack that needs to work in this scenario?
> 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
>
> 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)
