ambari-dev mailing list archives

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

     [ https://issues.apache.org/jira/browse/AMBARI-8518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jayush Luniya resolved AMBARI-8518.
-----------------------------------
    Resolution: Invalid

This is not a supported 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
>         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