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.

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