Hive Jdbc Driver Jar Download Hortonworks

DOWNLOAD Download music, movies, games, software and much more. Microsoft® Hive ODBC Driver provides HiveQL access from ODBC based applications to HDInsight Apache Hadoop Hive. Kodak All-in-One 3250 Driver; July 25, 2016 Home, Driver Teclado USB Windows 7. Use one of the following third party drivers: Hortonworks ODBC driver for Apache Hive; MapR Hive ODBC connector. (showing articles 661 to 680 of 5121) Browse the Latest Snapshot Browsing All Articles (5121 Articles). Please remove the old driver jar, from all hosts. This project is alternative to the JDBC driver that is bundled with the Apache Hive project. As a professional services, Solutions Architect, I guide organizations in architecting and developing enterprise grade business solutions and technology platforms based on Big Data, Machine Learning and Deep. @Thanu76 Could you please e-mail full IDE log to vasily. HiveDriver; Vidyasagar Gudapati. Use one of the following third party drivers: Hortonworks ODBC driver for Apache Hive; MapR Hive ODBC connector. jar; For Maven projects, use the following dependency setting:. Hive JDBC "uber" or "standalone" jar based on the latest Hortonworks Data Platform (HDP) - timveil/hive-jdbc-uber-jar. jar is specified in CLASSPATH. Click Manage Drivers. Connecting to Hive database can be done using Hive CLI or beeline from a command prompt and programmatically using a JDBC client. Connect to Hortonworks Hive via ODBC JDBC learn more about how DataDirect Drivers. I need to connect to Hive from Java program via JDBC. Hive JDBC driver is one of the widely used method to connect to HiveServer2. How to Connect to MS SQL Server via JDBC. Download Dec 14, 2014 · DOWNLOAD ===== Don’t Take Our Word For It Phish. Hive is basically a data warehouse tool to store and process the structured data residing on HDFS. close() and. This project is alternative to the JDBC driver that is bundled with the Apache Hive project. it is also expected that HDP platform is already configured with Kerberos and tested to work correctly. Search Search. jar entity is a link to the hive-jdbc--standalone. If you are using Centos then you can install it using the below command: $ sudo yum install hive-jdbc. For example, Kylin 2. but in odi last step ok KM IKM SQL to Hive-HBase-File (SQOOP) its giving below error. From a system that has Hive installed, download the following JAR files to each client machine:. ] data with Red Hat JBoss Data Virtualization (JDV). hivespark (country_id int, country_name string) insert into wh2. HiveDriver. JDBC Drivers. Only if you want to use the proprietary (Simba-based) JDBC drivers for Hive that Cloudera/Hortonworks provide, you will have to add then under File->Prereferences->KNIME->Databases. It is important to obtain the latest DataDirect Hive JDBC driver to benefit from known fixes and performance improvements. 5 for Cloudera Enterprise. It also enables you to write queries that join Oracle tables and Hive data, leverage robust Oracle Database security features, and take advantage of advanced SQL capabilities like analytic functions, JSON handling, and others. Install the 64 bits Hortonworks Hive ODBC Driver, you can download ODBC Driver from here. However, I could not find the JDBC driver itself (jar file) anywhere. Hive datasets are pointers to Hive tables already defined in the Hive metastore. This tool is designed to transfer and import data from a Relational Database Management System (RDBMS) into AWS – EMR Hadoop Distributed File System (HDFS), transform the data in Hadoop, and then export the data into a Data Warehouse (e. [1/7] ambari git commit: AMBARI-22671. MONGO JDBC DRIVER DOWNLOAD - Click here to download. jar library is a proxy driver. All logging dependencies have been filtered and bridged with SLF4J in this jar and Log4J has been included as the logging implementation. Motivation The HiveWarehouseConnector (HWC) is an open-source library which provides new interoperability capabilities between Hive and Spark. Step 1: Download and install a JDBC/ODBC driver For most BI tools, you need a JDBC or ODBC driver, according to the tool’s specification, to make a connection to Databricks clusters. Download pymssql module from here. Copy the JDBC URL for HiveServer: Click the clipboard icon. jar and hadoop-core*. 147 version from Amazon EMR. Download dbeaver-6. See this page for instructions on how to configure a DSN with this driver and use it to import data from Hive into Excel. jar to {icCube-install}/lib. Note: The Connection Wizard expects the JDBC 4. 0 and later, you can use the Hive 0. Get the JDBC driver jars for your Hive distro from your Hive server (asterisks indicate distribution-specific notations):. jr54220: replace hive jdbc driver with datadirect version 5. It is important to obtain the latest DataDirect Hive JDBC driver to benefit from known fixes and performance improvements. For customers who have standardized on Oracle, this. These two releases works with Hadoop 1. zip (where the 'X's are version numbers) from the download to get the driver jar file to deploy to your Agent(s). Explore real-time data! The Apache Hive JDBC Driver makes it easy to access live Hive data directly from any modern Java IDE. It also enables you to write queries that join Oracle tables and Hive data, leverage robust Oracle Database security features, and take advantage of advanced SQL capabilities like analytic functions, JSON handling, and others. Hive Architecture basically build up on three core component structure. I'm not entirely sure what the issue with this could be. Follow these steps to set up Oracle SQL Developer to work with Oracle Big Data Connectors. Under Hortonworks ODBC Driver for Apache Hive, download the driver for Windows (64-bit). There are known issues reported by IBM installing the IBM DB2 Data Server Driver on Windows 8. One option for connecting to HiveServer2 on Azure HDinsight cluster from a Java application would be using a JDBC-ODBC bridge. The link that you shared to migrate from Derby to MySQL seems to be too old (2013) and there are many changes and enhancements made in hive. When the connection is established you will see errors in the log console and might get a warning that the driver is not JDBC 3. 1 installed on mapr cluster. Download the SQL Server JDBC Driver 2. 2 on linux machine. The pentaho-hadoop-hive-jdbc-shim-xxx. Introduction. The following section describes setting up a JDBC client for HiveServer2 on Eclipse. Download a free, 30-day trial of the CData JDBC Driver for Hive and start working with your live Hive data in Google Data Fusion today. 3 has dropped support for Java 7 and now requires Java 8. Ask Question Asked 6 years, 2 org. Download presto-jdbc-322. 4 driver Fixes are available Download ISF roll-up 5 for InfoSphere Information Server Version 11. How to Connect to AS400 DB2 via Sqoop and Import the data into HDFS or Hive Hi, Today i got a requirement of importing the AS400 DB2 data into HDFS or in Hive tables. These two releases works with Hadoop 1. Download pymssql module from here. 0 para SQL Server, un controlador JDBC de tipo 4 que proporciona conectividad con bases de datos a través de las interfaces de programación de aplicaciones (API) estándar de JDBC disponibles en Java Platform, Enterprise Edition. Oracle Big Data SQL enables you to query Hive tables from the Oracle Database using the full power of Oracle SQL SELECT statements. jar; For Maven projects, use the following dependency setting:. Because the Apache Hive drivers are loaded dynamically, you must connect at least once to your distribution to see what version is listed within the About Aqua Data Studio > JDBC Drivers dialog. HiveServer2 use is recommended; the original HiveServer has several. A file called hive-jdbc-uber-x. The Hive Query Language is a subset of SQL-92. If you are installing the server on some other system. On a cluster node, navigate to /usr/hdp/current/hive-client/lib to locate the Hortonworks driver hive-jdbc. Skip the rest of the steps in this procedure and follow ODBC driver installation instructions. 3 or later, you must first configure the JAR files and configuration files from the HDP cluster, and then replace some of the JAR files with those from HDP 2. When testing the connection to an Apache Hive 1. 이름 필드에 Hive JDBC를 입력합니다. I am trying to connect the ataccama dq analyzer to hive. It is expected that the user has knowledge about Kerberos authentication and have gathered all the necessary configuration and keytabs before starting this exercise. Hive provides a mechanism to project structure onto this data and query the data using a SQL-like language called HiveQL. The Hortonworks Hive ODBC Driver efficiently transforms an application’s SQL query into the equivalent form in HiveQL. In the Name field, type Hive JDBC. I'm not entirely sure what the issue with this could be. Modify/Create the Hortonworks template with Kerberos property. sql file) provided with hive installation to create metastore tables. It also enables you to write queries that join Oracle tables and Hive data, leverage robust Oracle Database security features, and take advantage of advanced SQL capabilities like analytic functions, JSON handling, and others. You can use the Hive JDBC with Python Jaydebeapi open source module. 2 Get Plan The driver takes the help of query compiler that parses the query to check. Our JDBC driver can be easily used with all versions of SQL and across both 32-bit and 64-bit platforms. This document describes the JDBC client for the original Hive Server (sometimes called Thrift server or HiveServer1). These constructs return live BigQuery data that developers can work with directly from within the IDE. Use td-jdbc-(version)-jar-with-dependencies. HORTONWORKS HIVE JDBC DRIVER DOWNLOAD - Used by Kerberos authentication with TCP transport. Open the connection in Subject. 1 With dependencies Documentation Source code All Downloads are FREE. Apache Kylin Home. com, here you will find information about Operational Business Intelligence and Reporting Tools, Operational BI, Dashboard Reporting Software, Web Based Java Reporting Tools, Enterprise Reporting. jar hive-metastore-x. Add JDBC driver in SQL Developer. Open Control Panel, search for ODBC and open ODBC Data Source Administrator, in System DSN tab click Add, configure the data source as below, click OK. In this article we will show how to run reports on HBase using the open source Apache Phoenix JDBC driver. First, add this line to your /etc/hosts to point to your docker image:. Avoiding “add jar” to load custom SerDe when using Excel or Beeswax on Hortonworks Hadoop the Hortonworks Hive ODBC driver in Excel 2013 with Powerquery, and. If you want to use any other driver, contact Exasol support team. installing the jdbc drivers and check my post # 1. Refer to your database vendor-specific documentation to determine the main driver class. Anaconda Cloud. This project is alternative to the JDBC driver that is bundled with the Apache Hive project. Easily Build BI Applications with Open Source, Interactive SQL. The only thing you need to change is definitely the driver 🙂 jTDS JDBC allows you to connect to MS SQL Server and Sybase. Hive and Pig gives us a high level tool to perform analysis and transformations very efficiently for very large set of data. jar hive-jdbc-x. And if you are using Ubuntu, then use this: $ sudo apt-get install hive-jdbc. 13: do not set spark. Cloudera JDBC works but how sure if it is compatible with Hortonworks Hive. Connection String. MapR provides a downloadable Drill JDBC driver that you can use on all platforms to connect BI tools, such as SQuirreL and Spotfire, to Drill. It also enables you to write queries that join Oracle tables and Hive data, leverage robust Oracle Database security features, and take advantage of advanced SQL capabilities like analytic functions, JSON handling, and others. HiveServer2 use is recommended; the original HiveServer has several. This is the home page of UCanAccess, an open-source Java JDBC driver implementation that allows Java developers and JDBC client programs (e. If there are dependent jar files for any JDBC jar file, you have to provide path of those jar files in CLASSPATH shell or environment variable. Follow the steps below to load the driver JAR in DBeaver. Before running Hive, you need to create the /tmp folder and a separate Hive folder in HDFS. Next, select the JDBC Driver JAR files in the package. There seem to be a jar file for download from Cloudera, but it requires registration. 0 and later. hive-jdbc; Hive JDBC cloudera apache central pentaho-repo hortonworks How to exclude this artifact from Spring Boot JAR. This blog post was published on Hortonworks. ; Include the full path of the DataDirect Hive Driver (IShive. When you add the Db2 Big SQL service in Hortonworks Data Platform, the JDBC driver is automatically installed in the. In Impala 2. When connecting, skip building a list of all tables and columns for tab-completion of HiveQL statements true or build the list false. When using the JDBC jars for Hive 0. If the driver is not installed on your computer, Tableau displays a message in the connection dialog box with a link to the Driver Download page where you can find driver links and installation instructions. Microsoft Excel、MicroStrategy、QlikView、Tableau などの人気のビジネスインテリジェンスツールを Amazon EMR で使用して、データを調査しビジュアル化することができます。. For Ubuntu, this is as easy as pip install pymssql (See pip. 1 version, copy all jar files except log4j*. The pentaho-hadoop-hive-jdbc-shim-xxx. The information in this document demonstrates how to connect programmatically, and from the SQuirreL SQL client. Download the JDBC driver hive-jdbc from the driver archive. jar will be created in your target directory. This blog will show how to install the Oracle JDBC driver to the Streamsets External Library in a Cloudera Hadoop system. # yum-config-manager --enable epel. jar library is a proxy driver. Hadoop HIVE is one of those driver that have to be installed as needed. Here, we use the /user/hive/warehouse folder. In this case I'm pointing to Hive on my Hortonworks Sandbox. Simba’s Apache Hive ODBC and Hive JDBC Drivers with SQL Connector deliver direct SQL and HiveQL access to Apache Hadoop / Hive distributions. 2 and Hortonwork HiveServer2 (hive-0. jar driver files for connection to hive 2. These two releases works with Hadoop 1. 2 database with driver versions 0. 14, the following errors are received: XQE-DS-0006 Unable to logon to the data source. Download the JDBC driver hive-jdbc from the driver archive. If an application is Hive-aware, the Hortonworks Hive ODBC Driver is configurable to pass the query through. Hive and Pig gives us a high level tool to perform analysis and transformations very efficiently for very large set of data. We would like to show you a description here but the site won’t allow us. 150 version of the JDBC driver and running the Presto-Sandbox 0. The Hortonworks Hive ODBC Driver efficiently transforms an application's SQL query into the equivalent form in HiveQL. All logging dependencies have been filtered and bridged with SLF4J in this jar and Log4J has been included as the logging implementation. This can be achieved by using the ZooKeeper discovery mechanism to point the clients to the active Hive servers. pdf), Text File (. We strongly encourage using the specific Apache drivers from your Hadoop distro and version. zeppelin 0. get the VM; follow the installation guide. Download SQLite JDBC Driver. Download game java touch screen simulation Mar 16, 2011 · This video for F8 TV Hiphone 4, more details on kaylaelec/cheapest-f8tv-op Hot Spot Dual sim cards dual standby Quadband: GSM: 850/900 Jul 10, 2011 · Bagi pengguna ponsel touch screen inilah game java yang cocok untuk hp kalian. When the driver manager has searched the jar files, org. " Follow the instructions for the Windows driver. jar (JDBC 4. When using MySQL JDBC driver make sure mysql-connector-java-x. 0 and later. However, I could not find the JDBC driver itself (jar file) anywhere. If an application is Hive-aware, the Hortonworks Hive ODBC Driver is configurable to pass the query through. This article will explain how to use Arm Treasure Data with Pentaho Business Analytics using our JDBC driver. Step 1: Download and install a JDBC/ODBC driver. Add hive to the list of users at the bottom of the file (so it reads hive,ambari,mapred) Save and exit with :wq. Our JDBC driver can be easily used with all versions of SQL and across both 32-bit and 64-bit platforms. HiveDriver will be listed in the Driver Class field Close the Driver Manager Open Tools->Connection Wizard to create a new Hive connection and make sure the Hive driver entry is selected in the first pane and that correct Database details are specified in the last pane. Other versions of Hive or other release will obviously require newer or older. 2 on linux machine. To support HDP 2. If you are trying to connect to the Hive metastore, which I believe is running PostgreSQL in the Hortonworks Sandbox, then again, you're using the wrong JDBC driver, connection URL, query syntax, and server port information. After starting the CentOS VM with Hadoop you can create the Beeswax for Hive examples (via web app Hue), which are two tables: Then start the Hive service which is running on default port 10000: /usr/bin/hive --service hiveserver Don't forget to find out the IP address of your VM (call ifconfig. jar; For Maven projects, use the following dependency setting:. jar file to get the non-standalone version. These two releases works with Hadoop 1. Most of them support standard Hive JDBC driver which is used in DBeaver to communicate with the server. Apache Sqoop – An Introduction Hadoop as a platform gives us a framework to interact with data in parallel using powerful MapReduce framework. 1) On Hive create a simple table with an INT column and insert some data (I used SQuirreL Client with the Hortonworks JDBC driver): create table wh2. Simba’s Apache Hive ODBC and Hive JDBC Drivers with SQL Connector deliver direct SQL and HiveQL access to Apache Hadoop / Hive distributions. Download ODBC / JDBC Drivers. The Pirate Bay is the world's largest bittorrent tracker. HORTONWORKS HIVE JDBC DRIVER DOWNLOAD - Used by Kerberos authentication with TCP transport. Is the name of the JDBC driver, for example, org. 0 JDK you will build a version that supports the JDBC 3 specification. Open your SQL Developer, go to Tools -> Window, select the database section and Third Party JDBC Drivers, iteratively add the entries to select all 15 jar files as in the below screenshot. The Hive ODBC driver was developed with Thrift trunk version r790732, but the latest revision should also be fine. Modify/Create the Hortonworks template with Kerberos property. Configuration. Cloudera CDH Hive Odata, ODBC and JDBC drivers for fast, reliable, secure access to big data. The Hive Query Language is a subset of SQL-92. sql file) provided with hive installation to create metastore tables. HOL-Hive - Free download as PDF File (. They are based on Hive 1. The Hortonworks Hive ODBC Driver efficiently transforms an application’s SQL query into the equivalent form in HiveQL. MariaDB Connector/J 2. default option. Here is an example of how InfoCaptor connects with Clouder Impala. These constructs return live BigQuery data that developers can work with directly from within the IDE. The support for Apache HIVE 0. You will need to distribute all the driver jar files to each. As this is basically a JDBC call that is failing hence it will be really good to test the same using the oracle jdbc driver that you are using. Hive continues to expand support for analytics, reporting, and bilateral queries, and the community is striving to improve support along with many other aspects and use cases. HiveDriver` is in the hive-jdbc jar you downloaded by unzipping the jar, and checking that there is a. Download jdbc-postgresql. In Impala 2. you access to a working Impala and Hive instance without manually installing each of the components. After Unlock your Hadoop data with Hortonworks and Red Hat JBoss Data Virtualization episode, let’s continue the journey with another “Apache Hadoop” episode of the series: “Unlock your […. In this post, we’ll demonstrate one of the most. Refer to your database vendor-specific documentation to determine the main driver class. In this blog we’ll show how easy it is to hook Tableau up to Druid, but this works for any BI tool, Qlik, Spotfire, Microstrategy, Excel, you name it. ODBC Drivers Hortonworks Partners with Jethro Data to Deliver Interactive BI on Hadoop. IBI_CLASSPATH. HiveDriver` is in the hive-jdbc jar you downloaded by unzipping the jar, and checking that there is a. To set up LLAP (Hive Live Long and Process) support on a Hortonwork Hadoop 3 Cluster: Ensure that you have completed the update process. com, here you will find information about Operational Business Intelligence and Reporting Tools, Operational BI, Dashboard Reporting Software, Web Based Java Reporting Tools, Enterprise Reporting. We recommend downloading the respective JDBC drivers and committing them to the project so that they are always available when the project starts. jdbc you’re using and what JDBC driver JAR file you. For most BI tools, you need a JDBC or ODBC driver, according to the tool’s specification, to make a connection to Azure Databricks clusters. Download CData JDBC Driver for Apache Hive - SQL-based Access to Apache Hive from JDBC Driver. Defaults to true from Hive 2. Microsoft® Hive ODBC Driver provides HiveQL access from ODBC based applications to HDInsight Apache Hadoop Hive. Can anyone help with JDBC template for Kerberozied Impala and kerberozied Hive ? A bit urgent please. Hive JDBC and ODBC Drivers - Hortonworks Data Platform. You need to set write permission for these newly created folders as shown below:. jar file: Download the Oracle JDBC (OJDBC. 1 JDBC driver to KNIME (via File > Preferences > KNIME > Databases). jar hive-jdbc-x. Is it possible to use Zookeeper with the current (7. We chose Property Hive due to its ease of use. Control whether color is used for display. I add the jar files to the external JDBC driver path but the hive tab does not appear in the connection wizard. The name of the namespace is the. How are you executing your JDBC program? Can you verify that `org. Download a free, 30-day trial of the CData JDBC Driver for Hive and start working with your live Hive data in Google Data Fusion today. To support HDP 2. This blog post shows how our customers can benefit by using the Apache Sqoop tool. 08/12/2019; 7 minutes to read +4; In this article. with the driver jar files Hortonworks HDP 1. Click to create a new driver, and enter the Name: "Hortonworks Hive JDBC". You have an EXASolution database and want to connect it via JDBC to Hive for using EXAloader IMPORT/EXPORT statements. The "JDBC-Thin Driver Support for Encryption and Integrity" section in the Oracle JDBC developer's guide10 has more details. This driver is available for both 32 and 64 bit Windows platform. Zeppelin notebook with Cloudera. If you are installing the server on a node or an edge node of your Hadoop cluster, you can point to the hive-jdbc--standalone. Now, back to the cluster setup, select “Existing PostgreSQL Database” and make sure hive is set for the DB name, username, and password. Configuration. HORTONWORKS HIVE JDBC DRIVER DOWNLOAD - Learn more from our documentation. Before running Hive, you need to create the /tmp folder and a separate Hive folder in HDFS. The requirement is to load the text file into a hive table using Spark. Hive/HCatalog On the Hive Metastore machine, install the appropriate JDBC. This section provides quickstart instructions for making a simple connection to a SQL Server database by using the Microsoft JDBC Driver for SQL Server. In this post, we’ll demonstrate one of the most. Hive JDBC "uber" or "standalone" jar based on the latest Hortonworks Data Platform (HDP) - timveil/hive-jdbc-uber-jar. To use Postgres that is being used by Ambari-server for Oozie/Hive service, you need to install the jdbc driver package on the linux machine. in Hive or Amazon Redshift). Download the SQL Server JDBC Driver 2. When testing the connection to an Apache Hive 1. Note in the above Hive ODBC driver article that Hive ODBC driver uses SSL and certificate to authenticate with Azure Secure node and I am not sure if the JDBC driver has that type of support. jar and ojdbc5. I did some research and did not find correct. Quark JDBC Jar Configuration¶ Edit quark-config. OK, I Understand. 12 driver that was formerly the only choice is not compatible with Impala 2. Depending on the availability of suitable drivers for the appropriate platform you can leverage either protocols for your visualization purpose. For this reason, we will start with the latest stable 2. To create a connection to the Hive Thrift server, you first have to place the following sets of JAR. We may need to bump up the Hive version to support this. 1) First, if it exists, delete the driver previous version installed at your local maven repository, as an example, you may run the following command at a Unix terminal (Linux or Mac): rm -r ~/. Once the drivers are located in the project, Anaconda recommends using the RJDBC library to connect to Hive. JDBC drivers are Java library files with the extension. Similarly for other hashes (SHA512, SHA1, MD5 etc) which may be provided. To get the current version of your Hive driver: java -cp com. HiveDriver` is in the hive-jdbc jar you downloaded by unzipping the jar, and checking that there is a. These constructs return live Hive data that developers can work with directly from within the IDE. default option. These constructs return live Hive data that developers can work with directly from within the IDE. We are using CDH5. Once you download the jdbc driver, you will want to unzip it and copy the jar files from the Cloudera_ImpalaJDBC4_2. SAS® supports only Java 7 for SAS® 9. Downloading ODBC and JDBC drivers. Now, back to the cluster setup, select “Existing PostgreSQL Database” and make sure hive is set for the DB name, username, and password. When using the JDBC jars for Hive 0. This procedure assumes you are creating a new JDBC data source, and you need to install a new driver because the driver that the database requires is not available in the list of drivers. Environment: Cloudera CDH 5. 5 Hive 2 with 2. Download JAR files for hive-jdbc standalone With dependencies Documentation Source code All Downloads are FREE. SAP will support Hortonworks 2. This tool is designed to transfer and import data from a Relational Database Management System (RDBMS) into AWS – EMR Hadoop Distributed File System (HDFS), transform the data in Hadoop, and then export the data into a Data Warehouse (e. Create a JDBC Data Source for Hive Data. 0b1 Function 1 : To run select command in oracle and print result , we could store this in RDD or DF and use it further as well. Weka - JDBC Driver jar files. Apache Hive JDBC Drivers | Documentation 20. When the driver manager has searched the jar files, org. Control whether color is used for display. Download pymssql module from here. In my previous post, I made reference to the Twitter Big Data example for Microsoft StreamInsight (project page). Download the ODBC driver for Apache Hive from the Cloudera downloads page. Driver Name. Hive Clients 2. Ask Question Asked 6 years, 2 org. Installing a Presto VM Sandbox for HDP. I need to connect to Hive from Java program via JDBC. Hive and HBase. Apache Hive JDBC client drivers are not backwards compatible: newer client versions cannot connect to older Hive servers. Hive JDBC ドライバの使用. Please confirm if you are using Hortonworks 2. 3 kB each and 1. HiveDriver` is in the hive-jdbc jar you downloaded by unzipping the jar, and checking that there is a. Download the Apache Hive JDBC Drivers from the Apache Hive website that match the version of the server you are running in Amazon EMR. SAS/ACCESS uses the Hadoop Hive Server to read Hadoop data. For all other Hive versions, Azure Databricks recommends that you download the metastore JARs and set the configuration spark.