ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Colman Madden (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMBARI-8518) Changing hive metastore to sql server causes an error
Date Wed, 03 Dec 2014 05:59:12 GMT

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

Mime
View raw message