Edit

Share via

Set up your Hive LLAP connection

This article outlines the steps to create a Hive LLAP connection.

Supported authentication types

The Hive LLAP connector supports the following authentication types for copy and Dataflow Gen2 respectively.

Authentication type Copy Dataflow Gen2
Windows n/a √
Basic n/a √

Set up your connection for Dataflow Gen2

You can connect Dataflow Gen2 in Microsoft Fabric to Hive LLAP using Power Query connectors. Follow these steps to create your connection:

  1. Check capabilities to make sure your scenario is supported.
  2. Complete prerequisites for Hive LLAP.
  3. Get data in Fabric.
  4. Connect to Hive LLAP data.

Capabilities

  • Import
  • Direct Query (Power BI semantic models)
  • Thrift Transport Protocol
    • HTTP
    • Standard

Prerequisites

An Apache Hive LLAP username and password.

Get data

To get data in Data Factory:

  1. On the left side of Data Factory, select Workspaces.

  2. From your Data Factory workspace, select New > Dataflow Gen2 to create a new dataflow.

    Screenshot showing the workspace where you choose to create a new dataflow.

  3. In Power Query, either select Get data in the ribbon or select Get data from another source in the current view.

    Screenshot showing the Power Query workspace with the Get data option emphasized.

  4. In the Choose data source page, use Search to search for the name of the connector, or select View more on the right hand side the connector to see a list of all the connectors available in Power BI service.

    Screenshot of the Data Factory Choose data source page with the search box and the view more selection emphasized.

  5. If you choose to view more connectors, you can still use Search to search for the name of the connector, or choose a category to see a list of connectors associated with that category.

    Screenshot of the Data Factory Choose data source page displayed after selecting view more, with the list of connectors.

Connect to Hive LLAP data

To connect to the Apache Hive LLAP server:

  1. Select the Hive LLAP option in the Power Query - Choose data source page.

    Screenshot of the connect to data source page with all of the selections not yet filled in.

  2. Enter the URL to the Adobe Hive LLAP server. You can also enter an optional port number. Typically, the URL looks like http://[hostname]:[port number]. The components of the URL are:

    • The hostname (for example, hivellaphttp.southcentralus.contoso.com) is the hostname or IP address of the Apache Hive server.
    • The port number (for example, 10500) is the port number for the Apache Hive server. If the port number isn't specified, the default value is 10501 for the HTTP transport protocol and 10500 for the standard transport protocol.

  3. In Thrift Transport Protocol, select either Standard for TCP mode, or HTTP for HTTP mode.

  4. If necessary, select the name of your on-premises data gateway.

  5. If you're connecting to this Hive LLAP data for the first time, select the type of credentials for the connection in Authentication kind.

  6. Enter your credentials.

  7. Select Use Encrypted Connection if you want to use an encrypted connection, or clear the option if you want to use an unencrypted connection.

  8. Select Next to continue.

  9. In Navigator, select the data you require, then select Transform data to transform the data in the Power Query editor.

Set up your connection in a pipeline

Data Factory in Microsoft Fabric doesn't currently support Hive LLAP data in pipelines.

Related content

  • Last updated on