-
Notifications
You must be signed in to change notification settings - Fork 1.7k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[Feature Request] Increase scan size limit for large queries #45729
Comments
Thx for you advice. Both big_query_scan_rows_limit and big_query_scan_bytes_limit are an estimation for big query, Can you tell how do you choose big_query_scan_bytes_limit rather than big_query_scan_rows_limit? |
For column storage, when I scan a large number of rows with few fields, the required resources are not significant, for example: select count (1) from t. If it is big_query_scan_rows_limit, then this SQL will be restricted. Therefore, I hope to adjust large queries based on scan size. |
Feature request
At present, there are three major query limitations for SR, but none of them fully meet our limitation requirements. We hope to limit them based on the size of the scan volume (scanbytes), which is more effective than scanning the number of rows.
##at present
big_query_cpu_second_limit
big_query_scan_rows_limit
big_query_mem_limit
##Describe the solution you'd like
add big_query_scan_bytes_limit ?
The text was updated successfully, but these errors were encountered: