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
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
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
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
>
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
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
>>
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`
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
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
-
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
10 matches
Mail list logo