# Dremio jobs taking too long to planning

**URL:** <https://community.dremio.com/t/dremio-jobs-taking-too-long-to-planning/3009>\
**Category:** Uncategorized\
**Created:** [March 18, 2019, 2:35pm UTC](https://community.dremio.com/t/dremio-jobs-taking-too-long-to-planning/3009 "2019-03-18T14:35:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paulo\_Vasconcellos](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/paulo_vasconcellos/32/972_2.png) [@Paulo\_Vasconcellos](https://community.dremio.com/u/Paulo_Vasconcellos)\
**Post date:** [March 18, 2019, 2:35pm UTC](https://community.dremio.com/t/dremio-jobs-taking-too-long-to-planning/3009/1 "2019-03-18T14:35:51Z")

</div>

Hi everyone.  
Some of my jobs is taking too long to planning. In the past, I had this problem, which was solved by disabling the support key “planner.experimental.pclean\_logical”. However, I’m facing this problem with this job too.

Error: Query was cancelled because planning time exceeded 60 seconds

Attached to this thread is my profile. I’m using Dremio 3.1.0.  
[048a95cc-d082-4e80-9baa-ba963c483625.zip](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/2/294626404f50226694b53a9ff05deb0e2d9fe4a3.zip) (1.0 MB)

---

<div class="post-metadata">

**Author:** ![Paulo\_Vasconcellos](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/paulo_vasconcellos/32/972_2.png) [@Paulo\_Vasconcellos](https://community.dremio.com/u/Paulo_Vasconcellos)\
**Post date:** [March 18, 2019, 3:14pm UTC](https://community.dremio.com/t/dremio-jobs-taking-too-long-to-planning/3009/2 "2019-03-18T15:14:28Z")

</div>

My query contains a “not equal to” condition. I’ve noticed that when I remove this condition, my query works. However, I need to use this condition, but if I let it, the planning error appears.

---

<div class="post-metadata">

**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\
**Post date:** [March 18, 2019, 8:51pm UTC](https://community.dremio.com/t/dremio-jobs-taking-too-long-to-planning/3009/3 "2019-03-18T20:51:01Z")

</div>

Hi @Paulo_Vasconcellos,

It looks like you have over 20 reflections considered for this query. We are making some changes to the query planner that will likely help in this scenario that will be available in a near-future release. In the mean time, can you enter the following key in Admin-\>Support and **disable** it?

`accelerator.enable_multijoin`

… and try re-running the query?

---

<div class="post-metadata">

**Author:** ![Paulo\_Vasconcellos](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/paulo_vasconcellos/32/972_2.png) [@Paulo\_Vasconcellos](https://community.dremio.com/u/Paulo_Vasconcellos)\
**Post date:** [March 19, 2019, 2:04pm UTC](https://community.dremio.com/t/dremio-jobs-taking-too-long-to-planning/3009/4 "2019-03-19T14:04:40Z")

</div>

Hi @ben! It worked like a charm. 🙂  
Thank you very much

---

<div class="post-metadata">

**Author:** ![allan.sene](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/allan.sene/32/144_2.png) [@allan.sene](https://community.dremio.com/u/allan.sene)\
**Post date:** [October 7, 2019, 9:36pm UTC](https://community.dremio.com/t/dremio-jobs-taking-too-long-to-planning/3009/5 "2019-10-07T21:36:32Z")

</div>

Same issue here. The query plan takes too long to process. Even with those support keys enabled:

 ![image%20(12)](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/b/b1f146dd43a74d028a1ae11d59755ed638a5442b.png)

 ![image%20(13)](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/d/d9af3f4e9557f295cb694c13b92f160dc4351b96.jpeg) [db03d651-e3aa-47d6-ae1c-a5c7ed80c53b.zip|attachment][db03d651-e3aa-47d6-ae1c-a5c7ed80c53b.zip](https://community.dremio.com/uploads/short-url/yYQoJTslkqSptgyqawDf6FR3xbB.zip) (98.4 KB)