Re: exec.queue.enable in drill-embedded

2020-06-29 Thread Rafael Jaimes III
t; "RESOURCE ERROR: There is not enough heap memory to run this query using > > > the web interface." > > > The docker is serving remote clients through the REST API. > > > The queries are simple selects over tiny parquet files that are stored in > > > S3. &g

Re: exec.queue.enable in drill-embedded

2020-06-29 Thread Avner Levy
g out of heap memory errors: > > "RESOURCE ERROR: There is not enough heap memory to run this query using > > the web interface." > > The docker is serving remote clients through the REST API. > > The queries are simple selects over tiny parquet files that are st

Re: exec.queue.enable in drill-embedded

2020-06-28 Thread Paul Rogers
ough the REST API. > The queries are simple selects over tiny parquet files that are stored in > S3. > It is running on in 16GB container, configured with a heap of 8GB, and 8GB > direct memory. > I tried to use: > exec.queue.enable=true > exec.queue.large=1 > exec.que

Re: exec.queue.enable in drill-embedded

2020-06-28 Thread Rafael Jaimes III
mory to run this query using > the web interface." > The docker is serving remote clients through the REST API. > The queries are simple selects over tiny parquet files that are stored in > S3. > It is running on in 16GB container, configured with a heap of 8GB, and 8GB >

exec.queue.enable in drill-embedded

2020-06-28 Thread Avner Levy
ries are simple selects over tiny parquet files that are stored in S3. It is running on in 16GB container, configured with a heap of 8GB, and 8GB direct memory. I tried to use: exec.queue.enable=true exec.queue.large=1 exec.queue.small=1 and verified it was configured correctly, but I still see

Re: exec.queue.enable

2015-05-18 Thread Richard Shaw
effect of >> completely serialising all incoming queries? >> >> ALTER SYSTEM SET `exec.queue.enable`=true; >> ALTER SYSTEM SET `exec.queue.small`=1; >> ALTER SYSTEM SET `exec.queue.large`=1; >> >> >> Kind Regards, >> Richard >>

Re: exec.queue.enable

2015-05-13 Thread Kristine Hahn
15 at 2:51 PM, Richard Shaw wrote: > Thank you Kristine > > Please can you confirm the following would have the desired effect of > completely serialising all incoming queries? > > ALTER SYSTEM SET `exec.queue.enable`=true; > ALTER SYSTEM SET `exec.queue.small`

Re: exec.queue.enable

2015-05-13 Thread Richard Shaw
Thank you Kristine Please can you confirm the following would have the desired effect of completely serialising all incoming queries? ALTER SYSTEM SET `exec.queue.enable`=true; ALTER SYSTEM SET `exec.queue.small`=1; ALTER SYSTEM SET `exec.queue.large`=1; Kind Regards, Richard On

Re: exec.queue.enable

2015-04-30 Thread Kristine Hahn
Set options in sys.options to enable and manage query queuing, which is turned off by default. There are two types of queues: large and small. You configure a maximum number of queries that each queue allows by configuring the following options in the sys.options table: - exec.queue.large -

exec.queue.enable

2015-04-30 Thread Richard Shaw
I'd like to better understand queuing, if it's in fact possible to serialise incoming queries, especially where I have a very small Drill installation with limited resources. Thank you Kind Regards, Richard