0 Replies Latest reply: Sep 22, 2017 11:40 AM by Sunil Kachappilly RSS

    How to enable Tez execution engine for Hive

    Sunil Kachappilly

      Hi,

       

      My app requires data load from Hive as the data source (IBM Big Insights).

      Natively, Qlik Sense uses MapReduce as the execution engine (by default), which is too slow and consumes too much resource on the backend.

       

      There is a standing need to use available config (environment variables) to switch the execution engine to Tez.

       

      While I already know the environment variable settings to be done prior to query execution, how do I run them from the Qlik load script?

       

      I attempted adding the set of 'SET' commands to do this, but as expected, Qlik Sense treated them as Qlik variables, and ended up having no impact in the execution engine, which still defaulted to MapReduce.

       

      Please help.