[GitHub] [druid] internaulte opened a new issue, #14215: Be able to define batchSize for SQL requests

["internaulte (via GitHub)" <gi...@apache.org>]

internaulte opened a new issue, #14215:
URL: https://github.com/apache/druid/issues/14215

   ### Motivation
   
   Currently, it is possible to do scan queries in both native and SQL queries.
   Nevertheless, it is possible to define batchSize only in native queries. In SQL queries the value is the default value, with no possibility to change its value.
   
   ### Proposed changes
   
   - SQL language:
   
   In SQL context parameters, allow to add a non mandatory `batchSize` parameter.
   This parameter is a positive Integer, similarly to the same parameter in native scan queries.
   Default value is 20480.
   During SQL query translation to native scan query, the `batchSize` parameter found in SQL context will be used in the generated native scan query for its batchSize parameter value.
   
   ### Rationale
   
   This feature allows users that generate complex druid queries On-the-fly from various parameters in their applications to avoid to have to handle both SQL and native query generation in their code, just to be able to handle scan queries which needs controlled batch size. 
   Dealing with both native and SQL query generation in code can leads to high complexity.
   
   ### Operational impact
   
   This should have no effect on existing clusters.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org