Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

QlikView not using TEZ ?

Solved Go to solution

QlikView not using TEZ ?

New Contributor

Hi,

we have seen that only more complex (case, count,...) SELECT statements from Qlikview are being executed via TEZ.

All settings in Ambari are set to use TEZ by default.

Is this a Hortonworks issue?

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: QlikView not using TEZ ?

New Contributor

i wanted to let you know the result of our analysis:

Qlik will use TEZ which considerably speeds up the request times - IF the SQL-statement is sufficiently complex! (i.e. use a count or sum command - as a dummy)

5 REPLIES 5

Re: QlikView not using TEZ ?

Super Guru
@Daniel Scheiner

In HDP, we have hive.execution.engine set to TEZ by default, hence all the complex queries gets executed via TEZ.

If you want, you can modify this property to 'mr'.

Hope this information helps.

Re: QlikView not using TEZ ?

New Contributor

hive.execution.engine already is TEZ - we do not want MR due to its very very poor performance...

the problem appears to be with Qlik...

Re: QlikView not using TEZ ?

@Daniel Scheiner

QlikView override the execution engine at the runtime. It uses a cost-based optimizer and based on its stats running the query with MR makes more sense. Reach to you QlikView support to learn the reasoning.

If this response helped, please vote and accept it as a best answer.

Highlighted

Re: QlikView not using TEZ ?

New Contributor

i wanted to let you know the result of our analysis:

Qlik will use TEZ which considerably speeds up the request times - IF the SQL-statement is sufficiently complex! (i.e. use a count or sum command - as a dummy)

Re: QlikView not using TEZ ?

@Daniel Scheiner

See my response from Nov 11 at 05:21 PM. It states the same, Cost Based Optimizer decides to use Tez for those queries where Tez can deliver faster that MR.