Hi Drill Devs!
I have a question about the "output_batch_size" option. Is it safe to
change the scope of this parameter from system to both system and
session level? If not, what can happen?
The problem arose due to a performance issue in certain queries and
changing this option helps. But due to the fact that it is setted at
the system level, all executable queries began to absorb more memory
and as a result - out of memory issue. So, the solution to the problem
is to allow users to change this parameter at the session level to
affect only certain queries, without affecting all others at the
system.