[ https://issues.apache.org/jira/browse/AMBARI-8518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sergey Shelukhin moved HIVE-8968 to AMBARI-8518: ------------------------------------------------ Tags: (was: hive metastore HDP) Component/s: (was: Build Infrastructure) Fix Version/s: (was: 0.13.1) (was: 0.14.0) Affects Version/s: (was: 0.13.0) Key: AMBARI-8518 (was: HIVE-8968) Project: Ambari (was: Hive) > 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)