Skip to main content

Apache Drill

The Apache Drill Connector provides access to non-relational data stores. Connections are made by selecting Apache Drill from the list of drivers in the list of connectors in the QlikView ODBC Connection dialog or the Qlik Sense Add data or Data load editor dialogs.

Apache Drill is a low-latency distributed query engine capable of querying large data sets from multiple data sources using SQL. Unlike a relational database, Apache Drill does not require centralized schema definitions. Apache Drill can query self-describing data as well as complex or multi-structured data. Apache Drill supports semi-structured or nested data types such as JSON.

Information noteIndustry-accepted best practices must be followed when using or allowing access through the ODBC Connector. Administrators must follow The Principle of Least Privilege when setting up source database privileges and permissions.

Supported offerings

  • Qlik Sense Desktop/Qlik Sense Mobile Client Managed
  • Qlik Sense Enterprise SaaS
  • QlikView (Requires separate installation)

Supported Apache Drill versions

The following versions are supported:

  • Up to 1.16.0

Supported Apache Drill data types

The following Apache Drill data types are supported by the Apache Drill Connector.

  • Any
  • Array

  • BigInt

  • Bit

  • Char

  • Date

  • DateTime

  • Float

  • Decimal9

  • Double

  • Int

  • Map

  • SmallInt

  • TinyInt

  • Time

  • Timetstamp

  • Varchar