Comments (2)
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?
from starrocks.
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.
from starrocks.
Related Issues (20)
- [Performance] v3.3 out of box performance comparison HOT 2
- Support iceberg table compaction HOT 5
- Branch 3.3 commit `2b87854d` could not build using flag `--without-starcache` HOT 2
- [Crash] BE Crash during compaction
- Restoring backup from GCS result in error
- benchmark: add StarRocks to duckdblabs/db-benchmark
- 元数据改进-标识自增列及生成列
- regexp_extract: Invalid regex expression HOT 2
- get query info by queryid HOT 2
- auto bucket policy optimization
- 开箱盲查以及SQL解析能否优化 HOT 3
- The latest version of JDBC catalog does not cache metadata or data, resulting in slow queries. Do you have plans to address these two features
- The materialized view has four base tables, one of which is empty, resulting in the failure to rewrite the materialized view. HOT 1
- Using RFC3339 values in WHERE clause is very slow HOT 1
- 存算分离缓存盘主键存储能否优化清理策略 HOT 2
- Iceberg metadata statistic collector will frequently call IcebergTable.getUUID which may cost much cpu time under many scenes
- Support iceberg metadata table
- query information_schema.partitions_meta failed after manual COMPACT
- In shared data mode, when the Partitioned Prefix feature is enabled, the S3 storage path of the table is displayed incorrectly HOT 2
- Support Generic Aggregate Function State
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from starrocks.