[
https://issues.apache.org/jira/browse/AMBARI-8518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14232634#comment-14232634
]
Colman Madden commented on AMBARI-8518:
---------------------------------------
The database type option doesn't seem to actually do anything anyway from what
I can see, that field isn't even editable in this version of HDP.
It should be supported as currently you have databases in HSQL, Derby and
mysql. It makes sense to centralise the meta-store/databases to one place so
that the users have more visibility and control over whats actually happening
in the cluster. Cheers, Colman
> 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)
