Hortonworks Hive Connection String

If you use the Hive connection to run profiles on a Hadoop cluster, the Data Integration service executes only the environment SQL of the Hive connection. Open the Connection Wizard in the QuerySurge Admin view. ODBC element to connect your Logi application to a the datasource. This allows multiple connections from different users and clients per JDBC (remote and per Beeline) over Thrift. Learn how to setup and query data stored in various Azure data services using Apache Drill on the Data Science Virtual Machine using the familiar SQL interface. JDBC connections to an HDInsight cluster on Azure are made over port 443, and the traffic is secured using SSL. remote ZK connection string is not working but locally Kerberos connection string works. Set Up Hortonworks Hadoop with SQL Anywhere 4 The simplest installation process is to use VMware Player, and then open and import the provided file from the player. This is the default Hive Server 2 path for both Azure and local installs, and should not be changed unless you have explicitly customized this value in your Hive Server 2 configuration (this is not typical). The document is 5+ years old (2013), and we are now at 4. *If you're using Knox, make sure you're pointing to the right machine (ELB or gateway). 0 Unported License. Hi Can I use the latest version of Oracle SQL developer (or v4. 🙂 Cloudera CDH 4. To save your settings and close the dialog box, click OK. By default, the driver is configured to connect to a Hive Server 2 instance that requires User Name authentication, and the driver uses anonymous as the user name. This directive specifies the driver to be used for making JDBC connection with MySQL database. How to create hive connection to connect to Kerberized hive? 2. For a Java Logi application, use the Connection. Connection strings are stored in an encrypted form and can be decrypted by the currently logged-on Windows user only. on that, the first task is to demonstrate access VBA code can pass a parameter to SQL query using ADODB connection string. The name of the external. Data from Solr can be presented as a Hive table to be joined with other Hive tables, and data. hive-drop-import-delims not removing newline while using HCatalog in Sqoop. Here are the steps to configure the connection between HDP and Qlik Sense. I installed the Hortonworks Hive ODBC driver and created a connection in the Data sources. I tested it and it worked successfully. The Apache Hive Warehouse Connector (HWC) is a library that allows you to work more easily with Apache Spark and Apache Hive by supporting tasks such as moving data between Spark DataFrames and Hive tables, and also directing Spark streaming data into Hive tables. First of all I need to have a connection string to my instance of Hive and I can build it very easily in two ways:. In the Properties dialog, go to the Hive JDBC Connection Properties tab. Special characters in sess_var_list, hive_conf_list, hive_var_list parameter values should be encoded with URL encoding if needed. QlikView is a business intelligence tool that allows data to be discovered and visualized. QuerySurge Connection Wizard (using the Connection Extensibility option) 5a. 3天前 - 1、hiveserver2简介Hiveserver2简称hs2,它是一个允许多客户端并发连接的hive服务,客户端可通过jdbc、odbc方式去连接此服务操作hive。. This section describes the Hive SerDe and how to use it. Please note that SQL Workbench/J has no relation to the product MySQL Workbench which is maintained and owned by Oracle. Updated Kerberos configuration. Under Hortonworks ODBC Driver for Apache Hive, download the driver for Windows (64-bit). Waffle has dropped support for 1. For this article, the driver is used for Office Excel. Then do the following: Enter the name of server that hosts the database. Connection entries are stored in an encrypted form and can be decrypted by the currently logged-on Windows user only. I am able to connect to My Hive using Hortonworks hive odbc driver. hortonworks. 0, Storm 13/11/2016 03/12/2016 1,169 Words Leave a comment About Storm’s Nimbus This post describes Nimbus and shows how its use with single Nimbus in Storm cluster, as well as Nimbus H/A. 3) connected to an Oracle database, extracting records to HDFS. This video explains: 1. Changed Behavior. External Apache Hive Metastore. I am using NiFi 0. Perform the SQL queries like it was any other RDBMS system. User's Guide. val connectionString = ConnectionStringBuilder (EH_CONNECTION. 1 Release Notes. 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. NET/C# Apache or Hortonworks? you can reach the servers via your C# code using the appropriate connection strings. HortonworksInc. I have installed HDFS, MapReduce and YARN first and the need is to add Hive. o 64-bit HortonWorks Hive ODBC a Best Practices rules can be analyzed for the Hive provider once the user has created Provide a valid Hive connection string. Encryption is applied to electronic information in order to ensure its privacy and confidentiality. Document your code. Released 2017-10-20. 0" document. The String Describe Type connection option now allows you to describe string columns as SQL_WLONGVARCHAR or SQL_WVARCHAR. You can set it to – com. Data Footprint. In This Chapter. Go to Tools > Define ODBC Data Source 3. The following is the format of a DSN-less connection string for a standard connection to a Hive Server 2 instance. In a short time, Apache Storm became a standard for distributed real-time processing system that allows you to process a huge volume of data. Hive JDBC – Working with Hive in Embedded Mode and connection string you have to use for Hive in embedded mode: Game Analytics Hadoop HDFS Hive Hortonworks. (3 master servers, and 3 data nodes) but every - 368295. Connect to a Hadoop Database. 2, including Hive 1. PDS to use CatalogNameSpaceSQL. It is expected that the user has knowledge about Kerberos authentication and have gathered all the necessary configuration and keytabs before starting this exercise. To create a Data Source Name (DSN) Open the Data Source Administrator from the Start menu. Regards, Yuliana Gu. For example, an HDFS URI in an HA. The Cloudera ODBC Driver for Hive enables your enterprise users to access Hadoop data through Business Intelligence (BI) applications with ODBC support. Hi, Iam trying a simple transfer from a 3 fields table in MYSQL to Hortonworks HADOOP Defauld DB. A typical web. In the User DSN tab, click the Add button. Alert: Welcome to the Unified Cloudera Community. You can create and manage a Hive connection in the Administrator tool, Analyst tool, or the Developer tool. If the load balancer has set up connection timeout values, either check the connection frequently so that it never sits idle longer than the load balancer timeout value, or check the connection validity before using it and create a new one if the. If a value is specified for this setting, the driver delegates all operations against Hive to the specified user, rather than to the authenticated user for the connection. In creating a JDBC connection to Hive, SAS/ACCESS places the user ID and password that you provided in the JDBC connection string. Note: This option is applicable only when connecting to a Hive Server 2 instance that supports this feature. JDBC connection string syntax The JDBC connection string for connecting to a remote Hive client requires a host, port, and Hive database name, and can optionally specify a transport type and authentication. All the columns have the string, character varying data-type for Hive, Impala, Spark and Drill. session(spark). JDBC connections to an HDInsight cluster on Azure are made over port 443, and the traffic is secured using SSL. Hello, were you ever able to connect via JDBC connection? Out of the Azure environment I've done it as they did it in the book "Programming Hive" where it was shown how it was possible using Groovy, but as it was so similar (the syntax) I implemented it in my Java app and it worked. Getting Started With Apache Hive Software¶. When you configure AtScale to connect to your Hadoop environment, you must supply an HDFS URI connection string. When the connection is established you will see errors in the log. This allows multiple connections from different users and clients per JDBC (remote and per Beeline) over Thrift. Download and install the Microsoft Hive ODBC Driver version that matches the version of the application where you'll be using the ODBC driver. Typically, we think of protecting data as it rests or in motion. How to connect to Cloudera Impala 2. HortonworksInc. Create a new app by clicking Create new app. 0 Impala, and include supporting drivers and libraries for them. The following connection string shows the format to use for HDInsight:. We need to add principal to connection string if Kerberos authentication is enabled. On Windows systems, it can also connect via ODBC. com to point to the correct public IP address. If, however, I try to connect via Zookeeper then an exception is thrown:. Solved: I am trying to connect to Hive from Spark inside the map function like below String driver = "org. All the columns have the string, character varying data-type for Hive, Impala, Spark and Drill. It enables Business Intelligence (BI), analytics and reporting on Hadoop / Hive-based data. Apache Hive TM. you want to run a hive script, you can just run “hive -f ” command from any of the edge node, this command will directly trigger hive cli installed on that particular edge node and hive queries mentioned in the hql script will be executed. 10000 is the default Hive listening port. Hive provides a database query interface to Apache Hadoop. 05/08/2019; 4 minutes to read +3; In this article. Get the driver. To get the connection string – select the properties of the Hive Server. For example the following beeline-hs2-connection. Once this is installed and running, the provided IP address can be used to connect to the Hive server or access a Hadoop UI in a web browser. hortonworks. Figure 8: Hive ODBC Connections This approach provides two opportunities to enter the password (once when selecting the DSN name, and then again in the Connection tab itself). Set Up Hortonworks Hadoop with SQL Anywhere 4 The simplest installation process is to use VMware Player, and then open and import the provided file from the player. The other JDBC versions that are included in the package are not compatible with IBM Fluid Query. answered 31-05-2019 12:34:58 -0400 Hi Team, We are unable to connect to Hortonworks Hive using Kerberos Authentication. I made it work, after installing power bi it creates it's own service account and I need to change that to my windows service account with which I looged in and boom it worked all ok. The string functions in Hive are listed below: ASCII( string str ) The ASCII function converts the first character of the string into its numeric ascii value. The Cloudera ODBC and JDBC Drivers for Hive and Impala enable your enterprise users to access Hadoop data through Business Intelligence (BI) applications with ODBC/JDBC support. Using Native or Direct Database Connections. In this article, I will provide step by step "how to" instructions to use Kerberos authentication from Teiid to HDP platform. Hive Warehouse Connector supported types Hortonworks Docs » Data Platform 3. * Tried specifying the URL in couple of. Hortonworks Hive ODBC Driver with SQL Connector2. To get the connection string - select the properties of the Hive Server. // Here, we assume that the connection string from the Azure portal does not have the EntityPath part. How to Communicate to Hadoop via Hive using. You can use the MicroStrategy Big Data Engine to browse Hadoop files stored in a Hadoop Distributed File System (HDFS). Step 8 (Optional). NET or ODBC programming writing code for communicating with Hive should be very straightforward as overall concept as well as classes are exactly the same. the Host will be the Ip address of the Hive server, as specified in the Hortonworks vm (the Ip address used to access the web interface). It is expected that the user has knowledge about Kerberos authentication and have gathered all the necessary configuration and keytabs before starting this exercise. Use the following values and templates: Driver Class: org. CREATE TABLE weather (wban INT, date STRING, precip INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘,’ LOCATION ‘ /hive/data/weather’;. You will also see a short demo of Power BI Designer data cleanup features and the use of native Hive Query Language. This post will discuss a basic scenario in Hive: Dump some data from Oracle database, load to HDFS, and query the data using Hive. For details on how to install and use ODBC to connect to Hive, see Hive ODBC Connector. NET/C# Apache or Hortonworks? you can reach the servers via your C# code using the appropriate connection strings. This approach provides two opportunities to enter the password (once when selecting the DSN name, and then again in the Connection tab itself). Data Footprint. xml file (for example, save as core-site. To get the connection string – select the properties of the Hive Server. The String Describe Type connection option now allows you to describe string columns as SQL_WLONGVARCHAR or SQL_WVARCHAR. The Hive Warehouse Connector maps most Apache Hive types to Apache Spark types and vice versa, but there are a few exceptions that you must manage. However, Hive client was designed to be independent of unixODBC or any ODBC specific headers, allowing it to be used in any number of generic cases beyond ODBC. Hive ODBC Driver Downloads Hive JDBC Driver Downloads Impala ODBC Driver Downloads Impala JDBC Driver Downloads. I installed PyODBC and wrote the following code import os, sys,. Check out the Release History Notes for JDBC for Hortonworks Hive. Open sourced on GitHub, and became a top-level Apache project in May 2014. With the Hive driver defined, all that's left is to define the connection string. If an application is Hive-aware, the Hortonworks Hive ODBC Driver is configurable to pass the query through. Changed Behavior. Second, HiveServer2 brings connection concurrency to Hive. Interesting Scenario at a customer for Polybase Service. I'm trying to connect Visual Studio HDInsights Emulator to an Hortonworks 2. How to Connect Excel PowerPivot to Hive on Azure via HiveODBC. Pre-requisites to follow this Hive Tutorial. If I connect using the first (commented-out) connection string then the connection is established and usable later in the method. You can use the MicroStrategy Big Data Engine to browse Hadoop files stored in a Hadoop Distributed File System (HDFS). For example the following beeline-hs2-connection. When you configure AtScale to connect to your Hadoop environment, you must supply an HDFS URI connection string. Read this article for details about how QlikView was tested to integrate with and visualize data in Hortonworks Data Platform (HDP) on IBM POWER8. You may also have to customize the connection string if your cluster is using resource pools. 0, but they are still running HIVE 0. A Hive connection is a database type connection. net) with Hive database using Hortonworks hive odbc driver. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc. Driver or jdbc:mysql will let you connect to Hive. Creating Kerberos ticket cache file for authentication. 3天前 - 1、hiveserver2简介Hiveserver2简称hs2,它是一个允许多客户端并发连接的hive服务,客户端可通过jdbc、odbc方式去连接此服务操作hive。. As this relies on a JDBC connection string then theoretically you could use SQL Server for the metastore though I haven't had time to test. I was wondering if there is any way (configuration changes) with which I can improve performance for query through JDBC connection. See Hive wiki on Using JDBC to connect to Hive. Then do the following: Enter the name of server that hosts the database. Hortonworks Hive ODBC Driver setup screens; On Windows 7, launch the Qlik Sense application. Connection Window. Switch to the Machine Data Sources tab,. under [hive], the attributes for the data source should be specified. Microsoft® Hive ODBC Driver is a connector to Apache Hadoop Hive available as part of HDInsight clusters. 0 > 64-Bit ODBC Driver Manager On the User DSN tab click Add to open. TARGIT and Hadoop by Hortonworks 1 Introduction This paper is intended as a guide to those who want to experience TARGIT with Hadoop. *Did this content help you? Yes No Maybe * Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links. Connecting to Hadoop. Update the Hive database objects in DATABASE. An Azure customer @heikow10 is having issues setting up a Cloud Service odbc connection string to Hive registering Port on Azure Hortonworks cluster master. session(spark). com before the merger with Cloudera. config file. Oozie launcher is map only job which runs on Hadoop Cluster, for e. For both, Impala and Hive, JDBC4 drivers are the only supported version. A Hive connection is a database type connection. by, adding a new connection and using the ODBC DSN as normal. In this case you need to enter your password every time a connection to the database needs to be established. Not the right connection string for you? Start over in the connection string reference index. How to Connect Excel PowerPivot to Hive on Azure via HiveODBC. Or, to access authentication options for a DSN-less connection, open the Simba Hive ODBC Driver Configuration tool. Cloudera delivers an Enterprise Data Cloud for any data, anywhere, from the Edge to AI. Solved: I am trying to connect to Hive from Spark inside the map function like below String driver = "org. Former HCC members be sure to read and learn how to activate your account here. 0" document. by, adding a new connection and using the ODBC DSN as normal. This connector sample uses the Hive ODBC driver, and is based on the connector template. Select the Hive driver from the 'Driver' drop-down. When viewing the Engine logs we found the following log entry below , and obviously it has something to do with the performance counters. JDBC connection string syntax The JDBC connection string for connecting to a remote Hive client requires a host, port, and Hive database name, and can optionally specify a transport type and authentication. Specify the JDBC connection string You construct a JDBC URL to connect Hive to a BI tool. For tuning suggestions for the thrift server, refer to the blog post How to: Run Queries on Spark SQL using JDBC via Thrift Server. What happens if a failover occurs with the default connection string? If the connection string is the default one, on the event of a failover the jdbc connector has no idea there is a shadow master that can take over. Page7 WindowsDriver InstallingtheDriveronWindows On64-bitWindowsoperatingsystems,youcanexecuteboth32-and64-bitapplications. I installed the Hortonworks Hive ODBC driver and created a connection in the Data sources. All the columns have the string, character varying data-type for Hive, Impala, Spark and Drill. SQL-92 translation:. Apache Phoenix enables OLTP and operational analytics in Hadoop for low latency applications by combining the best of both worlds: the power of standard SQL and JDBC APIs with full ACID transaction capabilities and; the flexibility of late-bound, schema-on-read capabilities from the NoSQL world by leveraging HBase as its backing store. Setup hive2 and bigsql connection to BigInsights on Cloud. spark-llap / src / main / java / com / hortonworks / spark / sql / hive / llap / HiveWarehouseSessionImpl. The Cloudera ODBC and JDBC Drivers for Hive and Impala enable your enterprise users to access Hadoop data through Business Intelligence (BI) applications with ODBC/JDBC support. Hive provides a SQL-like interface to data stored in HDP. If the Hive sources and targets are on different clusters, the Data Integration Service does not execute the different environment SQL commands for the connections of the Hive source or target. 0) for Hadoop on a 64-node cluster based on CPA v2 for Big Data. Related topics. Can u please provide me the steps? and connection string. 3天前 - 1、hiveserver2简介Hiveserver2简称hs2,它是一个允许多客户端并发连接的hive服务,客户端可通过jdbc、odbc方式去连接此服务操作hive。. Hive and Pig gives us a high level tool to perform analysis and transformations very efficiently for very large set of data. Ensure that Hs2authmech is specified if the Hiveservertype is 2, to avoid connection issues. For a Java Logi application, use the Connection. Specify the JDBC connection string You construct a JDBC URL to connect Hive to a BI tool. JDBC connection string. If you are looking for MySQL Workbench support please contact Oracle. Apache Knox Gateway is a REST API Gateway that allows one to interact with a Hadoop cluster at a single access point; thus it can provide security and other critical administrative tasks. Hive JDBC – Working with Hive in Embedded Mode and connection string you have to use for Hive in embedded mode: Game Analytics Hadoop HDFS Hive Hortonworks. It was created as an internal project at Salesforce. This video explains: 1. Hello, were you ever able to connect via JDBC connection? Out of the Azure environment I've done it as they did it in the book "Programming Hive" where it was shown how it was possible using Groovy, but as it was so similar (the syntax) I implemented it in my Java app and it worked. To include data from an ODBC data provider, you must have a dataset that is based on a report data source of type ODBC. If connection works fine in UDL file, please copy the generated connection string and use it connect to Hive data soucre in Power BI desktop. Though not recommended, you can still download and install the older stage libraries as. QlikView supports Hadoop environments as a data source. Introduction. Select the Connection Extensibility option in the Data Source dropdown. Azure Databricks can also initialize an empty database as a metastore, by setting specific options in the Spark configuration. For details on how to install and use ODBC to connect to Hive, see Hive ODBC Connector. Covers all topics related to Teradata database connectivity, including the use of client technologies such JDBC, ODBC,. By clicking Sign up, you are giving your consent to Microsoft for the Power BI newsletter program to provide you the exclusive news, surveys, tips and advice and other information for getting the most out of Power BI. Hi, I am not able to use PutHiveQL when accessing Hive on HDInsight. 0 ; MapR version 6. The Driver maps SQL to HiveQL, enabling direct standard SQL-92 access to Apache Hive. This API has been defined to encourage similarity between the Python modules that are used to access databases. Oracle Instant Client. Each machine that. The Hive ODBC Driver is a powerful tool that allows you to connect with Apache Hive, directly from any applications that support ODBC connectivity. 0 Unported License. The public gateway that the clusters sit behind redirects the traffic to the port that HiveServer2 is actually listening on. On Windows systems, it can also connect via ODBC. This demo walks you through the steps required to setup Simba Hive ODBC driver and connect Microsoft Power BI Designer to Hive data source. I tested it and it worked successfully. Oracle Instant Client. Queries, including joins, are translated from SQL to HiveQL. The other JDBC versions that are included in the package are not compatible with IBM Fluid Query. The document is 5+ years old (2013), and we are now at 4. I had adequate database permissions, but found that the "connection" was problematic. By doing this, we hope to achieve a consistency leading to more easily understood modules, code that is generally more portable across databases, and a broader reach of database connectivity from Python. Also, the driver now. If the Hive sources and targets are on different clusters, the Data Integration Service does not execute the different environment SQL commands for the connections of the Hive source or target. Select Hortonworks and Hive connection service. How to connect to Cloudera Impala 2. SAS/ACCESS can access Hadoop data through a JDBC connection to a HiveServer2 service. Use the Hive connection to access Hive data. Known issues. WD Fusion Plugin: Hive Metastore 1. Notice the lack of a username and password in the connection string. One of the things I'm frequently. Cloudera delivers an Enterprise Data Cloud for any data, anywhere, from the Edge to AI. Since I don't want to have a duplicate copy of the table with fewer columns on my hadoop server I have two choices for import: 1) use a view to filter out the columns or 2) use a query to filter out the columns. The Driver maps SQL to HiveQL, enabling direct standard SQL-92 access to Apache Hive. Hive and Pig gives us a high level tool to perform analysis and transformations very efficiently for very large set of data. Read this article for details about how MicroStrategy Desktop was tested to integrate with and visualize data in Hortonworks Data Platform (HDP) on IBM POWER8. JDBC element. Architecture Diagram. Connecting to Hadoop. SAS/ACCESS uses the Hadoop Hive Server to read Hadoop data. Using Hive¶ Hive is an open source data warehouse project for queries and data analysis. When the connection is established, the main window of the Aginity Workbench application, Query Analyzer, opens. For all developers who have at least some experience with ADO. Hive Warehouse Connector supported types Hortonworks Docs » Data Platform 3. We will support Hiveserver2 (which supports Kerberos) with SAS 9. One way or another after setting up connection string the following steps in my code are: 1) Opening a connection to Hive. When installing Hive, Pig and Tez follow with it whether you want it or not. Tableau is a business intelligence tool that allows data to be discovered and visualized. Hortonworks Connector for Teradata Mar 30, 2015 a new partitioned or non-partitioned Hive table created by the connector. xml file, and sets up the connection string to use multiple HDFS hosts. Learn the Basics of Hive Hadoop. Please note that SQL Workbench/J has no relation to the product MySQL Workbench which is maintained and owned by Oracle. 1 Release Notes. You construct a JDBC URL to connect Hive to a BI tool. In the previous tutorial, we used Pig, which is a scripting language with a focus on dataflows. TARGIT and Hadoop by Hortonworks 1 Introduction This paper is intended as a guide to those who want to experience TARGIT with Hadoop. I've learned the 'servicename' in the connection string should be Hive, i saw this in some other applications documentation. Hive ODBC Driver Downloads Hive JDBC Driver Downloads Impala ODBC Driver Downloads Impala JDBC Driver Downloads. City that never sleeps, meet the world's first enterprise data cloud. (3 master servers, and 3 data nodes) but every - 368295. On destination database information in Package/Publish information, paste the connection string you copied from. Create a new app by clicking Create new app. 0 Impala, and include supporting drivers and libraries for them. Page7 WindowsDriver InstallingtheDriveronWindows On64-bitWindowsoperatingsystems,youcanexecuteboth32-and64-bitapplications. You can set it to – com. Hi all, can you please help me in the steps to connect C# application (asp. Unable to connect to Hortonworks Hive using Kerberos. net) with Hive database using Hortonworks hive odbc driver. Defining a new Datasource with AQT. Besides, please test connection to ODBC driver using UDL file. Third, the Hive CLI command could be deprecated in the future, this is discussed within the Hive Developer Community. The current code uses the Microsoft Hive ODBC driver, but was also tested with the Hortonworks Hive ODBC driver. Typically, we think of protecting data as it rests or in motion. You do not have permission to access the location where the data source is stored. You can connect to a multitude of different data sources in Power BI Desktop, using built-in data connectors that range from Access databases to Zendesk resources, as shown in the Get Data window. Block blobs are the default kind of blob and are good for most big-data use cases, like input data for Hive, Pig, analytical map-reduce jobs etc. Read this article for details about how Tableau Desktop was tested to integrate with and visualize data in Hortonworks Data Platform (HDP) on IBM POWER8. On destination database information in Package/Publish information, paste the connection string you copied from. Unable to connect to Hortonworks Hive using Kerberos. Here is an example. JDBC (Java Database Connectivity) format provides generic non-spatial access to a wide number of database formats through JDBC drivers - analagous to ODBC connectors. Examples of connecting to kerberos hive in JDBC. Choosing the right hardware setup for ones Hadoop cluster is an individual decision based on needs and budget. Enhancements & New Features. How to create hive connection to connect to Kerberized hive? 2. This demo walks you through the steps required to setup Simba Hive ODBC driver and connect Microsoft Power BI Designer to Hive data source. NET provider for Hive but this is where ODBC middle-ware API plays a part. while executing query sometimes we are getting '. 0 datasource using Hive 0. @Ajay Rawal. In my examples, I’m using a distribution of Hadoop based on the Hortonworks Data Platform (HDP). 10/08/2019; 7 minutes to read; In this article. I had adequate database permissions, but found that the "connection" was problematic.