LFC
cbe0cf4a74
refactor: rewrite some UDFs to DataFusion style (part 2) ( #6967 )
...
* refactor: rewrite some UDFs to DataFusion style (part 2)
Signed-off-by: luofucong <luofc@foxmail.com >
* deal with vector UDFs `(scalar, scalar)` situation, and try getting the scalar value reference everytime
Signed-off-by: luofucong <luofc@foxmail.com >
* reduce some vector literal parsing
Signed-off-by: luofucong <luofc@foxmail.com >
* fix ci
Signed-off-by: luofucong <luofc@foxmail.com >
---------
Signed-off-by: luofucong <luofc@foxmail.com >
2025-09-18 06:37:27 +00:00
discord9
85c1a91bae
feat: support SubqueryAlias pushdown ( #6963 )
...
* wip enforce dist requirement rewriter
Signed-off-by: discord9 <discord9@163.com >
* feat: enforce dist req
Signed-off-by: discord9 <discord9@163.com >
* test: sqlness result
Signed-off-by: discord9 <discord9@163.com >
* fix: double projection
Signed-off-by: discord9 <discord9@163.com >
* test: fix sqlness
Signed-off-by: discord9 <discord9@163.com >
* refactor: per review
Signed-off-by: discord9 <discord9@163.com >
* docs: use btree map
Signed-off-by: discord9 <discord9@163.com >
* test: sqlness explain&comment
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: discord9 <discord9@163.com >
2025-09-16 13:27:35 +00:00
dennis zhuang
6c066c1a4a
test: migrate join tests from duckdb, part3 ( #6881 )
...
* test: migrate join tests
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: update test results after rebasing main branch
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: unstable query sort results and natural_join test
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: count(*) with joining
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: unstable query sort results and style
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
---------
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-09-12 04:20:00 +00:00
LFC
9ab87e11a4
refactor: rewrite h3 functions to DataFusion style ( #6942 )
...
* refactor: rewrite h3 functions to DataFusion style
Signed-off-by: luofucong <luofc@foxmail.com >
* resolve PR comments
Signed-off-by: luofucong <luofc@foxmail.com >
---------
Signed-off-by: luofucong <luofc@foxmail.com >
2025-09-12 02:27:24 +00:00
dennis zhuang
49722951c6
fix: unstable query sort results ( #6944 )
...
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-09-10 20:41:10 +00:00
Ruihang Xia
c797d87210
fix: handle hash distribution properly ( #6943 )
...
* fix: handle hash distribution properly
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix clippy
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* Update src/query/src/optimizer/pass_distribution.rs
Co-authored-by: dennis zhuang <killme2008@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: dennis zhuang <killme2008@gmail.com >
2025-09-10 06:35:10 +00:00
Weny Xu
16febbd4c2
feat: add CPU, memory and node status info to cluster_info ( #6897 )
...
* feat: add CPU and memory info to `cluster_info`
Signed-off-by: WenyXu <wenymedia@gmail.com >
* feat: add `node_status` to `cluster_info` table
Signed-off-by: WenyXu <wenymedia@gmail.com >
* test: update sqlness
Signed-off-by: WenyXu <wenymedia@gmail.com >
* chore: apply suggestions
Signed-off-by: WenyXu <wenymedia@gmail.com >
* chore: update proto
Signed-off-by: WenyXu <wenymedia@gmail.com >
---------
Signed-off-by: WenyXu <wenymedia@gmail.com >
2025-09-08 08:59:34 +00:00
LFC
47384c7701
feat: support function alias ( #6917 )
...
* feat: udf alias
Signed-off-by: luofucong <luofc@foxmail.com >
* trying to fix sqlness
Signed-off-by: luofucong <luofc@foxmail.com >
* x
Signed-off-by: luofucong <luofc@foxmail.com >
---------
Signed-off-by: luofucong <luofc@foxmail.com >
2025-09-08 08:57:24 +00:00
Weny Xu
658d07bfc8
feat: add written_bytes_since_open column to region_statistics table ( #6904 )
...
* feat: add `write_bytes` column to `region_statistics` table
Signed-off-by: WenyXu <wenymedia@gmail.com >
* chore: update comments
Signed-off-by: WenyXu <wenymedia@gmail.com >
* chore: rename `write_bytes` to `written_bytes`
Signed-off-by: WenyXu <wenymedia@gmail.com >
* chore: rename `written_bytes` to `written_bytes_since_open`
Signed-off-by: WenyXu <wenymedia@gmail.com >
* chore: apply suggestions
Signed-off-by: WenyXu <wenymedia@gmail.com >
---------
Signed-off-by: WenyXu <wenymedia@gmail.com >
2025-09-05 07:27:30 +00:00
dennis zhuang
24e5c9f6da
test: migrate duckdb tests, part 1 ( #6870 )
...
* test: migrate duckdb tests
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: style
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* test: add more duckdb tests
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: stable order
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: simplfy comments
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: remove tests/cases/standalone/common/DUCKDB_MIGRATION_GUIDE.md
* fix: incorrect_sql.sql
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: integer flow test
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: integer flow test
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* docs: add todo
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
---------
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-09-05 06:10:14 +00:00
Ruihang Xia
4158afa618
fix: wrap tql cte in a subquery alias ( #6910 )
...
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2025-09-05 06:07:20 +00:00
dennis zhuang
8e7f2e92cc
test: adds approx_percentile_cont to range query test ( #6903 )
...
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-09-04 12:18:27 +00:00
dennis zhuang
9dbf6dd8d0
test: migrate duckdb tests part2, window functions ( #6875 )
...
* test: migrate window tests
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: blank line at the end
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
---------
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-09-03 06:55:47 +00:00
Weny Xu
7cf47ccf54
fix: initialize remote WAL regions with correct flushed entry IDs ( #6856 )
...
* fix: initialize remote WAL regions with correct flushed entry IDs
Signed-off-by: WenyXu <wenymedia@gmail.com >
* chore: add logs
Signed-off-by: WenyXu <wenymedia@gmail.com >
* fix: correct latest offset
Signed-off-by: WenyXu <wenymedia@gmail.com >
* fix: update sqlness
Signed-off-by: WenyXu <wenymedia@gmail.com >
* feat: add replay checkpoint to catchup request
Signed-off-by: WenyXu <wenymedia@gmail.com >
* chore: apply suggestions
Signed-off-by: WenyXu <wenymedia@gmail.com >
* chore: logs
Signed-off-by: WenyXu <wenymedia@gmail.com >
* chore: apply suggestions
Signed-off-by: WenyXu <wenymedia@gmail.com >
---------
Signed-off-by: WenyXu <wenymedia@gmail.com >
2025-09-03 04:00:02 +00:00
discord9
6a3791ab31
fix(flow): promql auto create table ( #6867 )
...
* fix: non aggr prom ql auto create table
Signed-off-by: discord9 <discord9@163.com >
* feat: val column use any name
Signed-off-by: discord9 <discord9@163.com >
* feat: check if it's tql src table
Signed-off-by: discord9 <discord9@163.com >
* test: check sink table is tql-able
Signed-off-by: discord9 <discord9@163.com >
* test: sqlness redacted
Signed-off-by: discord9 <discord9@163.com >
* fix: sql also handle no aggr case
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: discord9 <discord9@163.com >
2025-09-02 08:54:16 +00:00
Weny Xu
0e962844ac
fix: fix incorrect timestamp precision in information_schema.tables ( #6872 )
...
* fix: fix incorrect timestamp precision in information_schema.tables
Signed-off-by: WenyXu <wenymedia@gmail.com >
* fix: fix unit test
Signed-off-by: WenyXu <wenymedia@gmail.com >
---------
Signed-off-by: WenyXu <wenymedia@gmail.com >
2025-09-01 12:20:23 +00:00
dennis zhuang
1234911ed3
refactor: query config options ( #6781 )
...
* feat: refactor columnar and vector conversion
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* feat: initialize config options from query context
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: failure tests
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: revert ColumnarValue::try_from_vector
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
---------
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-09-01 07:00:26 +00:00
discord9
367a25af06
feat: flow prom ql auto sink table is also promql-able ( #6852 )
...
* feat: flow prom ql auto sink table is also promql-able
Signed-off-by: discord9 <discord9@163.com >
* fix: gen create table expr without aggr/projection outermost
Signed-off-by: discord9 <discord9@163.com >
* test: update non-aggr testcase
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: discord9 <discord9@163.com >
2025-08-29 12:16:03 +00:00
discord9
8452a9d579
feat(flow): add eval interval option ( #6623 )
...
* feat: add flow eval interval
Signed-off-by: discord9 <discord9@163.com >
* feat: tql flow must have eval interval
Signed-off-by: discord9 <discord9@163.com >
* chore: clippy
Signed-off-by: discord9 <discord9@163.com >
* test: update sqlness
Signed-off-by: discord9 <discord9@163.com >
* wip
Signed-off-by: discord9 <discord9@163.com >
* wip
Signed-off-by: discord9 <discord9@163.com >
* feat: check for now func
Signed-off-by: discord9 <discord9@163.com >
* refactor: use ms instead
Signed-off-by: discord9 <discord9@163.com >
* fix: not panic&proper simplifier
Signed-off-by: discord9 <discord9@163.com >
* test: update to fix
Signed-off-by: discord9 <discord9@163.com >
* feat: not allow month in interval
Signed-off-by: discord9 <discord9@163.com >
* test: update remov months
Signed-off-by: discord9 <discord9@163.com >
* refactor: per review
Signed-off-by: discord9 <discord9@163.com >
* chore: after rebase fix
Signed-off-by: discord9 <discord9@163.com >
* feat: use seconds and add to field instead
Signed-off-by: discord9 <discord9@163.com >
* chore: aft rebase fix
Signed-off-by: discord9 <discord9@163.com >
* fix: add check for month
Signed-off-by: discord9 <discord9@163.com >
* chore: fmt
Signed-off-by: discord9 <discord9@163.com >
* refactor: per review
Signed-off-by: discord9 <discord9@163.com >
* refactor: rm clone per review
Signed-off-by: discord9 <discord9@163.com >
* chore: update proto
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: discord9 <discord9@163.com >
2025-08-27 09:44:32 +00:00
Ruihang Xia
288f69a30f
fix: plan disorder from upgrading datafusion ( #6787 )
...
* fix: plan disorder from upgrading datafusion
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update sqlness
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update sqlness again
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2025-08-23 12:29:47 +00:00
Ruihang Xia
7e573e497c
feat: simplify more regex patterns in promql ( #6747 )
...
* feat: simplify more regex patterns in promql
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add sqlness cases
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update sqlness case
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2025-08-20 18:51:10 +00:00
Ruihang Xia
474a689309
feat: region prune part 2 ( #6752 )
...
* skeleton
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* get rule set
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* adjust style
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* adjust params
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* reuse collider
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* canonize
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* more robust predicate extractor
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* simplify predicate extractor's test and impl
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* unify import
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* simplification, remove unnecessary interfaces
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* handle partial referenced exprs
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* finalize predicate extractor
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* document region pruner
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* chore: reduce diff
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* simplify checker
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* refine overlapping check method
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* reduce diff
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* coerce types
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* remove unused errors
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix clippy
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* apply review comment
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* refactor use Bound
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* simplify hashmap
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* Apply suggestions from code review
Co-authored-by: Yingwen <realevenyag@gmail.com >
* sqlness tests
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* redact region id
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* test: update sqlness result after udpate datafusion
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
Signed-off-by: discord9 <discord9@163.com >
Co-authored-by: Yingwen <realevenyag@gmail.com >
Co-authored-by: discord9 <55937128+discord9@users.noreply.github.com >
Co-authored-by: discord9 <discord9@163.com >
2025-08-20 18:47:38 +00:00
LFC
05529387d9
refactor: use DataFusion's UDAF implementation directly ( #6776 )
...
* refactor: use DataFusion's UDAF implementation directly
Signed-off-by: luofucong <luofc@foxmail.com >
* remove: delete how-to guide for writing aggregate functions
Signed-off-by: luofucong <luofc@foxmail.com >
* fix ci
Signed-off-by: luofucong <luofc@foxmail.com >
* refactor: port json_encode_path to datafusion udaf
Signed-off-by: Ning Sun <sunning@greptime.com >
---------
Signed-off-by: luofucong <luofc@foxmail.com >
Signed-off-by: Ning Sun <sunning@greptime.com >
Co-authored-by: Ning Sun <sunning@greptime.com >
2025-08-20 08:25:00 +00:00
dennis zhuang
d6bc117408
refactor: refactor admin functions with async udf ( #6770 )
...
* refactor: use async udf for admin functions
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: sqlness test
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: code style
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: clippy
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: remove unused error
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: style
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: style
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: code style
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: apply suggestions
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: logical_metric_table test
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
---------
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-08-20 03:35:38 +00:00
yihong
7402320abc
fix: time() function should the same as behavior prometheus ( #6704 )
...
* fix: close issue_6701 phase 1 make it return now
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: tests
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: make tests stable
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: drop useless tests
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: address comments
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: close issue_6701 phase 1 make it return now
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: tests
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: make tests stable
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: drop useless tests
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: address comments
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: make time() real right
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: fix tests
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* add two sqlness cases
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* simplify impl
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
2025-08-20 03:05:21 +00:00
Ning Sun
bf191c5763
test: fix sqlness hash character count ( #6758 )
2025-08-18 11:06:05 +00:00
LFC
f9d2a89a0c
chore: update datafusion family ( #6675 )
...
* chore: update datafusion family
Signed-off-by: luofucong <luofc@foxmail.com >
* fix ci
Signed-off-by: luofucong <luofc@foxmail.com >
* use official otel-arrow-rust
Signed-off-by: luofucong <luofc@foxmail.com >
* rebase
Signed-off-by: luofucong <luofc@foxmail.com >
* use the official orc-rust
Signed-off-by: luofucong <luofc@foxmail.com >
* resolve PR comments
Signed-off-by: luofucong <luofc@foxmail.com >
* remove the empty lines
Signed-off-by: luofucong <luofc@foxmail.com >
* try following PR comments
Signed-off-by: luofucong <luofc@foxmail.com >
---------
Signed-off-by: luofucong <luofc@foxmail.com >
2025-08-15 12:41:49 +00:00
yihong
56f5ccf823
fix: support unknown for timestamp function ( #6708 )
...
* fix: support unknown for timestamp function
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: some sqlness now no error
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: make clippy happy
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: address comments
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: address comments
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
---------
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
2025-08-14 02:56:33 +00:00
Zhenchi
fb3b1d4866
feat: Store partition expr in RegionMetadata ( #6699 )
...
* wire partition.expr_json option constant and parsing
test(mito2): manifest roundtrip persists partition_expr JSON
test(mito2): create/open with partition.expr_json persists in manifest
docs: add comments for partition.expr_json option and RegionOptions.partition_expr
serde: include RegionOptions.partition_expr (skip if None)
test(mito2): doc intent and verify runtime backfill + persistence-after-alter for partition expr
add partition expr to create request
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* add create_with_partition_expr_persists_manifest
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* pass partition expr to create request
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* polish
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix sqlness
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix test
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* remove unused dep
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
---------
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
2025-08-13 22:05:37 +00:00
yihong
f0bec4940f
fix: two label_replace different from promql ( #6720 )
...
* fix: two label_replace different from promql
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: address comments
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
Co-authored-by: Jiachun Feng <jiachun_feng@proton.me >
* fix: another address
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
---------
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
Co-authored-by: Jiachun Feng <jiachun_feng@proton.me >
2025-08-13 06:27:49 +00:00
yihong
5eb491df12
fix: label_join should work with unknown ( #6714 )
...
* fix: label_join should work with unknown
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: address comments
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
Co-authored-by: Jiachun Feng <jiachun_feng@proton.me >
* fix: address forget comments
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
---------
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
Co-authored-by: Jiachun Feng <jiachun_feng@proton.me >
2025-08-13 03:45:40 +00:00
Ruihang Xia
2992e70393
fix: correct offset's symbol ( #6728 )
...
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2025-08-13 03:20:47 +00:00
Ruihang Xia
9ad9a7d2bc
feat: add all partition column to logical table automatically ( #6711 )
...
* feat: add all partition column to logical table automatically
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* sqlness test
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* simplify builder
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix clippy
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix request builder
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* test: update sqlness
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
Signed-off-by: discord9 <discord9@163.com >
Co-authored-by: discord9 <55937128+discord9@users.noreply.github.com >
Co-authored-by: discord9 <discord9@163.com >
2025-08-12 17:25:24 +00:00
discord9
f159fcf599
fix: metrics without physical partition columns query push down ( #6694 )
...
* fix: metrics no part cols
Signed-off-by: discord9 <discord9@163.com >
* chore: typos
Signed-off-by: discord9 <discord9@163.com >
* chore: clippy
Signed-off-by: discord9 <discord9@163.com >
* chore: rename stuff
Signed-off-by: discord9 <discord9@163.com >
* refactor: put partition rules in table
Signed-off-by: discord9 <discord9@163.com >
* more tests
Signed-off-by: discord9 <discord9@163.com >
* test: redact more
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: discord9 <discord9@163.com >
2025-08-12 02:51:38 +00:00
Ruihang Xia
3b1f172ab8
fix: TQL CTE parser take raw query string ( #6671 )
...
* take raw TQL part
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* more tests
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* sort sqlness result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add order by
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* more order by
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add comment back
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2025-08-08 06:22:56 +00:00
Ruihang Xia
309e9d978c
feat: support TQL CTE in planner ( #6645 )
...
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2025-08-06 04:07:38 +00:00
discord9
875207d26c
feat: register all aggregate function to auto step aggr fn ( #6596 )
...
* feat: support generic aggr push down
Signed-off-by: discord9 <discord9@163.com >
* typo
Signed-off-by: discord9 <discord9@163.com >
* fix: type ck in merge wrapper
Signed-off-by: discord9 <discord9@163.com >
* test: update sqlness
Signed-off-by: discord9 <discord9@163.com >
* feat: support all registried aggr func
Signed-off-by: discord9 <discord9@163.com >
* chore: per review
Signed-off-by: discord9 <discord9@163.com >
* chore: per review
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: discord9 <discord9@163.com >
2025-08-05 11:37:45 +00:00
discord9
1afa0afc67
feat: add partial truncate ( #6602 )
...
* feat: add partial truncate
Signed-off-by: discord9 <discord9@163.com >
* fix: per review
Signed-off-by: discord9 <discord9@163.com >
* feat: add proto partial truncate kind
Signed-off-by: discord9 <discord9@163.com >
* chore: clippy
Signed-off-by: discord9 <discord9@163.com >
* chore: update branched proto
Signed-off-by: discord9 <discord9@163.com >
* feat: grpc support truncate WIP sql support
Signed-off-by: discord9 <discord9@163.com >
* wip: parse truncate range
Signed-off-by: discord9 <discord9@163.com >
* feat: truncate by range
Signed-off-by: discord9 <discord9@163.com >
* fix: truncate range display
Signed-off-by: discord9 <discord9@163.com >
* chore: resolve todo
Signed-off-by: discord9 <discord9@163.com >
* refactor: per review
Signed-off-by: discord9 <discord9@163.com >
* test: more invalid parse
Signed-off-by: discord9 <discord9@163.com >
* chore: per review
Signed-off-by: discord9 <discord9@163.com >
* refactor: per review
Signed-off-by: discord9 <discord9@163.com >
* chore: unused
Signed-off-by: discord9 <discord9@163.com >
* chore: per review
Signed-off-by: discord9 <discord9@163.com >
* chore: update branch
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: discord9 <discord9@163.com >
2025-08-04 10:50:27 +00:00
Ruihang Xia
865ca44dbd
feat: absent function in PromQL ( #6618 )
...
* feat: absent function in PromQL
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* impl serde
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* sqlness test
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* ai suggests
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* resolve PR comments
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* comment out some tests
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2025-08-04 06:59:58 +00:00
Lin Yihai
b6cef77a5c
feat: add SET DEFAULT syntax ( #6421 )
...
* feat: add `SET DEFAULT` syntax
Signed-off-by: Yihai Lin <yihai-lin@foxmail.com >
* test: add `CURRENT_TIMESTAMP()` as default value for `SET DEFAULT` syntax
Signed-off-by: Yihai Lin <yihai-lin@foxmail.com >
* refactor: Make the error types more precise.
Signed-off-by: Yihai Lin <yihai-lin@foxmail.com >
* chore: a minor error display enchancement for `SET DEFAULT`
Signed-off-by: Yihai Lin <yihai-lin@foxmail.com >
* refactor: Using `MODIFY COLUMN` for `DROP/SET DEFUALT`
Signed-off-by: Yihai Lin <yihai-lin@foxmail.com >
* chore: update `greptime-proto`
Signed-off-by: Yihai Lin <yihai-lin@foxmail.com >
---------
Signed-off-by: Yihai Lin <yihai-lin@foxmail.com >
2025-07-29 06:41:02 +00:00
dennis zhuang
086777d938
feat: impl some promql scalar functions ( #6567 )
...
* feat: impl some promql scalar functions
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* feat: supports pi function
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: by cr comments
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: compile
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
---------
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-07-29 03:29:00 +00:00
dennis zhuang
052033d436
feat: supports more db options ( #6529 )
...
* feat: supports more db options
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: tests
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: use btree map for consistent results
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* feat: adds compaction keys into valid db options
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
---------
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-07-25 08:31:11 +00:00
yihong
61d83bc36b
fix: closee issue #6555 return empty result ( #6569 )
...
* fix: closee issue #6555 return empty result
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* fix: only start one instance one regrex sqlness test (#6570 )
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
* refactor: refactor partition mod to use PartitionExpr instead of PartitionDef (#6554 )
* refactor: refactor partition mod to use PartitionExpr instead of PartitionDef
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix snafu
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* Puts expression into PbPartition
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* address comments
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix compile
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* update proto
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* add serde test
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* add serde test
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
---------
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix: address comments
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
---------
Signed-off-by: yihong0618 <zouzou0208@gmail.com >
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
Co-authored-by: Zhenchi <zhongzc_arch@outlook.com >
2025-07-24 03:30:59 +00:00
discord9
8d71213ea6
fix: aggr group by all partition cols use partial commutative ( #6534 )
...
* fix: aggr group by all partition cols use partial commutative
Signed-off-by: discord9 <discord9@163.com >
* test: bugged case
Signed-off-by: discord9 <discord9@163.com >
* test: sqlness fix
Signed-off-by: discord9 <discord9@163.com >
* test: more redacted
Signed-off-by: discord9 <discord9@163.com >
* more cases
Signed-off-by: discord9 <discord9@163.com >
* even more test cases
Signed-off-by: discord9 <discord9@163.com >
* join testcase
Signed-off-by: discord9 <discord9@163.com >
* fix: column requirement added in correct location
Signed-off-by: discord9 <discord9@163.com >
* fix test
Signed-off-by: discord9 <discord9@163.com >
* chore: clippy
Signed-off-by: discord9 <discord9@163.com >
* track col reqs per stack
Signed-off-by: discord9 <discord9@163.com >
* fix: continue
Signed-off-by: discord9 <discord9@163.com >
* chore: clippy
Signed-off-by: discord9 <discord9@163.com >
* refactor: test mod
Signed-off-by: discord9 <discord9@163.com >
* test utils
Signed-off-by: discord9 <discord9@163.com >
* test: better test
Signed-off-by: discord9 <discord9@163.com >
* more testcases
Signed-off-by: discord9 <discord9@163.com >
* test limit push down
Signed-off-by: discord9 <discord9@163.com >
* more testcases
Signed-off-by: discord9 <discord9@163.com >
* more testcase
Signed-off-by: discord9 <discord9@163.com >
* more test
Signed-off-by: discord9 <discord9@163.com >
* chore: update sqlness
Signed-off-by: discord9 <discord9@163.com >
* chore: update commnets
Signed-off-by: discord9 <discord9@163.com >
* fix: check col reqs from bottom to upper
Signed-off-by: discord9 <discord9@163.com >
* chore: more comment
Signed-off-by: discord9 <discord9@163.com >
* docs: more todo
Signed-off-by: discord9 <discord9@163.com >
* chore: comments
Signed-off-by: discord9 <discord9@163.com >
* test: a new failing test that should be fixed
Signed-off-by: discord9 <discord9@163.com >
* fix: part col alias tracking
Signed-off-by: discord9 <discord9@163.com >
* chore: unused
Signed-off-by: discord9 <discord9@163.com >
* chore: clippy
Signed-off-by: discord9 <discord9@163.com >
* docs: comment
Signed-off-by: discord9 <discord9@163.com >
* mroe testcase
Signed-off-by: discord9 <discord9@163.com >
* more testcase for step/part aggr combine
Signed-off-by: discord9 <discord9@163.com >
* FIXME: a new bug
Signed-off-by: discord9 <discord9@163.com >
* literally unfixable
Signed-off-by: discord9 <discord9@163.com >
* chore: remove some debug print
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: discord9 <discord9@163.com >
2025-07-23 09:05:34 +00:00
Zhenchi
2298227e0c
refactor: refactor partition mod to use PartitionExpr instead of PartitionDef ( #6554 )
...
* refactor: refactor partition mod to use PartitionExpr instead of PartitionDef
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix snafu
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* Puts expression into PbPartition
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* address comments
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix compile
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* update proto
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* add serde test
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* add serde test
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
---------
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
2025-07-23 03:51:28 +00:00
discord9
6501b0b13c
feat: MergeScan print input ( #6563 )
...
* feat: MergeScan print input
Signed-off-by: discord9 <discord9@163.com >
* test: fix ut
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: discord9 <discord9@163.com >
2025-07-21 06:40:15 +00:00
dennis zhuang
78b1c6c554
feat: impl timestamp function for promql ( #6556 )
...
* feat: impl timestamp function for promql
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: style and typo
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: test
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* docs: update comments
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: comment
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
---------
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-07-21 03:46:41 +00:00
Yan Tingwang
efefddbc85
test: add sqlness test for max execution time ( #6517 )
...
* add sqlness test for max_execution_time
Signed-off-by: codephage. <tingwangyan2020@163.com >
* add Pre-line comments SQLNESS PROTOCOL MYSQL
Signed-off-by: codephage. <tingwangyan2020@163.com >
* fix(mysql): support max_execution_time variable
Co-authored-by: evenyag <realevenyag@gmail.com >
Signed-off-by: codephage. <tingwangyan2020@163.com >
* fix: test::test_check & sqlness test mysql
Signed-off-by: codephage. <tingwangyan2020@163.com >
* add sqlness test for max_execution_time
Signed-off-by: codephage. <tingwangyan2020@163.com >
* add Pre-line comments SQLNESS PROTOCOL MYSQL
Signed-off-by: codephage. <tingwangyan2020@163.com >
* fix(mysql): support max_execution_time variable
Co-authored-by: evenyag <realevenyag@gmail.com >
Signed-off-by: codephage. <tingwangyan2020@163.com >
* fix: test::test_check & sqlness test mysql
Signed-off-by: codephage. <tingwangyan2020@163.com >
* chore: Unify the sql style
Signed-off-by: codephage. <tingwangyan2020@163.com >
---------
Signed-off-by: codephage. <tingwangyan2020@163.com >
Co-authored-by: evenyag <realevenyag@gmail.com >
2025-07-18 12:18:14 +00:00
LFC
370d27587a
refactor: make greptimedb's tests ran as a submodule ( #6544 )
...
fix: failed to run a test when as a submodule
Signed-off-by: luofucong <luofc@foxmail.com >
2025-07-18 08:01:30 +00:00
Lei, HUANG
0cf25f7b05
feat: add sst file num in region stat ( #6537 )
...
* feat/add-sst-file-num-in-region-stat:
### Add SST File Count to Region Statistics
- **Enhancements**:
- Added `sst_num` to track the number of SST files in region statistics across multiple modules.
- Updated `RegionStat` and `RegionStatistic` structs in `datanode.rs` and `region_engine.rs` to include `sst_num`.
- Modified `MitoRegion` and `SstVersion` in `region.rs` and `version.rs` to compute and return the number of SST files.
- Adjusted test cases in `collect_leader_region_handler.rs`, `failure_handler.rs`, `region_lease_handler.rs`, and `weight_compute.rs` to initialize `sst_num`.
- Updated `get_region_statistic` in `utils.rs` to sum `sst_num` from metadata and data statistics.
Signed-off-by: Lei, HUANG <mrsatangel@gmail.com >
* feat/add-sst-file-num-in-region-stat:
Add `sst_num` to `region_statistics`
- Updated `region_statistics.rs` to include a new constant `SST_NUM` and added it to the schema and builder structures.
- Modified `information_schema.result` to reflect the addition of `sst_num` in the `region_statistics` table.
Signed-off-by: Lei, HUANG <mrsatangel@gmail.com >
---------
Signed-off-by: Lei, HUANG <mrsatangel@gmail.com >
2025-07-17 17:36:20 +00:00