# Query was cancelled planning time exceeded 60 seconds

**URL:** <https://community.dremio.com/t/query-was-cancelled-planning-time-exceeded-60-seconds/1241>\
**Category:** Uncategorized\
**Created:** [June 5, 2018, 10:21am UTC](https://community.dremio.com/t/query-was-cancelled-planning-time-exceeded-60-seconds/1241 "2018-06-05T10:21:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![richiesgr](https://avatars.discourse-cdn.com/v4/letter/r/e99b99/32.png) [@richiesgr](https://community.dremio.com/u/richiesgr)\
**Post date:** [June 5, 2018, 10:21am UTC](https://community.dremio.com/t/query-was-cancelled-planning-time-exceeded-60-seconds/1241/1 "2018-06-05T10:21:55Z")

</div>

Hi  
I get this

`Query was cancelled because planning time exceeded 60 seconds`

The data is parquet files partitioned by Date/Hour stored on S3 bucket.  
The problem occurs when I try to limit the data to specific period (date between)  
[5e92d1c0-a0a7-4813-8d37-3439ac8533e1.zip](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/1X/1bc5c9e273d8759d7a53c7a56925cb80ec94880a.zip) (4.4 KB)

So I can’t save the dataset  
What can I do ?

---

<div class="post-metadata">

**Author:** ![christy](https://avatars.discourse-cdn.com/v4/letter/c/e68b1a/32.png) [@christy](https://community.dremio.com/u/christy)\
**Post date:** [June 5, 2018, 3:54pm UTC](https://community.dremio.com/t/query-was-cancelled-planning-time-exceeded-60-seconds/1241/2 "2018-06-05T15:54:30Z")

</div>

Hey there,

We should be releasing a new version of Dremio soon… hopefully this should fix this issue.

I’ll keep you posted!

Christy

---

<div class="post-metadata">

**Author:** ![richiesgr](https://avatars.discourse-cdn.com/v4/letter/r/e99b99/32.png) [@richiesgr](https://community.dremio.com/u/richiesgr)\
**Post date:** [June 7, 2018, 12:50pm UTC](https://community.dremio.com/t/query-was-cancelled-planning-time-exceeded-60-seconds/1241/3 "2018-06-07T12:50:12Z")

</div>

Hi christy

We at [Fyber.com](http://Fyber.com) really interested by the product so I’ve removed the default timeout  
However some issues

- The ability to use really the queries on memory I got a pretty big cluster with 20 R4.4Xlarge each machine is about 122GB memory no matter what kind of data set I use **only a tiny fractional portion of the data go in memory**. With such cluster I was expected all the dataset in memory (I’ve configure dremio with heap of 16GB and DirectMemory to 80GB)
- In case of I get all the machine reading the data in parallel from S3 bucket how can I increase the reading data rate to reach the network bandwidth limits ?
- How to optimize the CPU to speed up the request after a lot of test making reflection the majority of the requests are simply never optimized because not cover by the reflection

Could you help me?

Thanks

---

<div class="post-metadata">

**Author:** ![kelly](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/kelly/32/11_2.png) [@kelly](https://community.dremio.com/u/kelly)\
**Post date:** [June 7, 2018, 4:36pm UTC](https://community.dremio.com/t/query-was-cancelled-planning-time-exceeded-60-seconds/1241/4 "2018-06-07T16:36:09Z")

</div>

Could you provide a query plan so we can take a closer look?

A few other questions:

1. how did you deployment Dremio? How many coordinators and executors?
2. what is the source data on S3?
3. how are you issuing queries? If through the SQL console, are you using Preview or Run?