ENABLE_PHOTON

Applies to: check marked yes Databricks SQL

The ENABLE_PHOTON configuration parameter controls usage of the Photon vectorized query engine.

You can set this parameter at the session level using the SET statement.

Settings

Two settings are supported:

  • TRUE

    When set to TRUE Databricks SQL will use the Photon vectorized query engine wherever it applies.

  • FALSE

    When set to FALSE Databricks SQL does not use Photon.

System default

The system default for this parameter is TRUE.

Examples 

> SET enable_photon = false;