Skip to main content

Apache Spark

Connections to an Apache Spark database are made by selecting Apache Spark 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.

The Apache Spark Connector is used for direct SQL and HiveQL access to Apache Hadoop/Spark distributions. The connector transforms an SQL query into the equivalent form in HiveQL and passes the query through to the database for processing.

Note: Industry-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 Spark versions

The followings database versions are supported:

  • 1.6 to 2.6.6

Supported Apache Spark data types

The following Apache SPARK data types are supported by the Apache Spark Connector.

  • BigInt
  • Boolean
  • Date
  • Decimal
  • Double
  • Float
  • Integer
  • SmallInt
  • String
  • Timestamp
  • TinyInt
  • Varchar