ambari-dev mailing list archives

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

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

Mime
View raw message