discord9
68247fc9b1
fix: count_state use stat to eval&predicate w/out region ( #7116 )
...
* fix: count_state use stat to eval
Signed-off-by: discord9 <discord9@163.com >
* cleanup
Signed-off-by: discord9 <discord9@163.com >
* fix: use predicate without region
Signed-off-by: discord9 <discord9@163.com >
* test: diverge standalone/dist impl
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: discord9 <discord9@163.com >
2025-10-27 02:14:45 +00:00
dennis zhuang
d8563ba56d
feat: adds regex_extract function and more type tests ( #7107 )
...
* feat: adds format, regex_extract function and more type tests
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: forgot functions
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: forgot null type
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* test: forgot date type
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* feat: remove format function
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* test: update results after upgrading datafusion
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
---------
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-10-25 08:41:49 +00:00
Yingwen
4c70b4c31d
feat: store estimated series num in file meta ( #7126 )
...
* feat: add num_series to FileMeta
Signed-off-by: evenyag <realevenyag@gmail.com >
* feat: add SeriesEstimator to collect num_series
Signed-off-by: evenyag <realevenyag@gmail.com >
* fix: set num_series in compactor
Signed-off-by: evenyag <realevenyag@gmail.com >
* chore: print num_series in Debug for FileMeta
Signed-off-by: evenyag <realevenyag@gmail.com >
* style: fmt code
Signed-off-by: evenyag <realevenyag@gmail.com >
* style: fix clippy
Signed-off-by: evenyag <realevenyag@gmail.com >
* fix: increase series count when next ts <= last
Signed-off-by: evenyag <realevenyag@gmail.com >
* test: add tests for SeriesEstimator
Signed-off-by: evenyag <realevenyag@gmail.com >
* feat: add num_series to ssts_manifest table
Signed-off-by: evenyag <realevenyag@gmail.com >
* test: update sqlness tests
Signed-off-by: evenyag <realevenyag@gmail.com >
* test: fix metric engine list entry test
Signed-off-by: evenyag <realevenyag@gmail.com >
---------
Signed-off-by: evenyag <realevenyag@gmail.com >
2025-10-24 05:53:48 +00:00
zyy17
a0e6bcbeb3
feat: add cpu_usage_millicores and memory_usage_bytes in information_schema.cluster_info table. ( #7051 )
...
* refactor: add `hostname` in cluster_info table
Signed-off-by: zyy17 <zyylsxm@gmail.com >
* chore: update information schema result
Signed-off-by: zyy17 <zyylsxm@gmail.com >
* feat: enable zstd for bulk memtable encoded parts (#7045 )
feat: enable zstd in bulk memtable
Signed-off-by: evenyag <realevenyag@gmail.com >
* refactor: add `get_total_cpu_millicores()` / `get_total_cpu_cores()` / `get_total_memory_bytes()` / `get_total_memory_readable()` in common-stat
Signed-off-by: zyy17 <zyylsxm@gmail.com >
* feat: add `cpu_usage_millicores` and `memory_usage_bytes` in `information_schema.cluster_info` table
Signed-off-by: zyy17 <zyylsxm@gmail.com >
* fix: compile warning and integration test failed
Signed-off-by: zyy17 <zyylsxm@gmail.com >
* fix: integration test failed
Signed-off-by: zyy17 <zyylsxm@gmail.com >
* refactor: add `ResourceStat`
Signed-off-by: zyy17 <zyylsxm@gmail.com >
* refactor: apply code review comments
Signed-off-by: zyy17 <zyylsxm@gmail.com >
* chore: update greptime-proto
Signed-off-by: zyy17 <zyylsxm@gmail.com >
---------
Signed-off-by: zyy17 <zyylsxm@gmail.com >
Signed-off-by: evenyag <realevenyag@gmail.com >
Co-authored-by: Yingwen <realevenyag@gmail.com >
2025-10-24 03:12:45 +00:00
LFC
2f637a262e
chore: update datafusion to 50 ( #7076 )
...
* chore: update datafusion to 50
Signed-off-by: luofucong <luofc@foxmail.com >
* fix ci
Signed-off-by: luofucong <luofc@foxmail.com >
* fix: update datafusion_pg_catalog import
* chore: fix toml format
* chore: fix toml format again
* fix nextest
Signed-off-by: luofucong <luofc@foxmail.com >
* fix sqlness
Signed-off-by: luofucong <luofc@foxmail.com >
* chore: switch datafusion-orc to upstream tag
* fix sqlness
Signed-off-by: luofucong <luofc@foxmail.com >
* resolve PR comments
Signed-off-by: luofucong <luofc@foxmail.com >
---------
Signed-off-by: luofucong <luofc@foxmail.com >
Co-authored-by: Ning Sun <sunning@greptime.com >
2025-10-23 07:18:36 +00:00
discord9
a9a3e0b121
fix: prom ql logical plan use column index not name ( #7109 )
...
* feat: use index not col name
Signed-off-by: discord9 <discord9@163.com >
* fix: use name without qualifier&output schema fix
Signed-off-by: discord9 <discord9@163.com >
* proto
Signed-off-by: discord9 <discord9@163.com >
* refactor: resolve column name/index
Signed-off-by: discord9 <discord9@163.com >
* pcr
Signed-off-by: discord9 <discord9@163.com >
* chore: update proto
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-10-22 09:04:09 +00:00
Zhenchi
938d757523
feat: expose SST index metadata via information schema ( #7044 )
...
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
2025-10-20 11:59:16 +00:00
LFC
21532abf94
feat: new create table syntax for new json datatype ( #7103 )
...
* feat: new create table syntax for new json datatype
Signed-off-by: luofucong <luofc@foxmail.com >
* refactor: extract consts
* refactor: remove unused error variant
* fix tests
Signed-off-by: luofucong <luofc@foxmail.com >
* fix sqlness
Signed-off-by: luofucong <luofc@foxmail.com >
---------
Signed-off-by: luofucong <luofc@foxmail.com >
Co-authored-by: Ning Sun <sunning@greptime.com >
2025-10-17 05:22:29 +00:00
dennis zhuang
8a2371a05c
feat: supports large string ( #7097 )
...
* feat: supports large string
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: add doc for extract_string_vector_values
Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com >
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: refactor by cr comments
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: changes by cr comments
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* refactor: extract_string_vector_values
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* feat: remove large string type and refactor string vector
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: revert some changes
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* feat: adds large string type
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: impl default for StringSizeType
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: tests and test compatibility
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* test: update sqlness tests
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: remove panic
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
---------
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com >
2025-10-17 01:46:11 +00:00
zyy17
cf1b8392af
refactor!: unify the API of getting total cpu and memory ( #7049 )
...
* refactor: add `get_total_cpu_millicores()` / `get_total_cpu_cores()` / `get_total_memory_bytes()` / `get_total_memory_readable()` in common-stat
Signed-off-by: zyy17 <zyylsxm@gmail.com >
* tests: update sqlness test cases
Signed-off-by: zyy17 <zyylsxm@gmail.com >
---------
Signed-off-by: zyy17 <zyylsxm@gmail.com >
2025-10-16 12:41:34 +00:00
zyy17
6ab4672866
refactor: add peer_hostname field in information_schema.cluster_info table ( #7050 )
...
* refactor: add `hostname` in cluster_info table
Signed-off-by: zyy17 <zyylsxm@gmail.com >
* chore: update information schema result
Signed-off-by: zyy17 <zyylsxm@gmail.com >
* chore: apply code review comments
Signed-off-by: zyy17 <zyylsxm@gmail.com >
* chore: update greptime-proto
Signed-off-by: zyy17 <zyylsxm@gmail.com >
* chore: add the compatibility for old proto
Signed-off-by: zyy17 <zyylsxm@gmail.com >
---------
Signed-off-by: zyy17 <zyylsxm@gmail.com >
2025-10-16 06:02:47 +00:00
Alan Tang
8073e552df
feat: add updated_on to tablemeta with a default of created_on ( #7072 )
...
* feat: add updated_on to tablemeta with a default of created_on
Signed-off-by: Alan Tang <jmtangcs@gmail.com >
* feat: support the update_on on alter procedure
Signed-off-by: Alan Tang <jmtangcs@gmail.com >
* feat: add updated_on into information_schema.tables
Signed-off-by: Alan Tang <jmtangcs@gmail.com >
* fix: make sqlness happy
Signed-off-by: Alan Tang <jmtangcs@gmail.com >
* test: add test case for tablemeta update
Signed-off-by: Alan Tang <jmtangcs@gmail.com >
* fix: fix failing test for ALTER TABLE
Signed-off-by: Alan Tang <jmtangcs@gmail.com >
* feat: use created_on as default for updated_on when missing
Signed-off-by: Alan Tang <jmtangcs@gmail.com >
---------
Signed-off-by: Alan Tang <jmtangcs@gmail.com >
2025-10-15 11:12:27 +00:00
Ruihang Xia
aa98033e85
feat(parser): ALTER TABLE ... REPARTITION ... ( #7082 )
...
* initial impl
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* sqlness tests
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* tidy up
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2025-10-15 03:54:36 +00:00
discord9
ba034c5a9e
feat: explain custom statement ( #7058 )
...
* feat: explain tql cte
Signed-off-by: discord9 <discord9@163.com >
* chore: unused
Signed-off-by: discord9 <discord9@163.com >
* fix: analyze format
Signed-off-by: discord9 <discord9@163.com >
* Update src/sql/src/statements/statement.rs
Co-authored-by: Yingwen <realevenyag@gmail.com >
Signed-off-by: discord9 <discord9@163.com >
* test: sqlness
Signed-off-by: discord9 <discord9@163.com >
* pcr
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: discord9 <discord9@163.com >
Co-authored-by: Yingwen <realevenyag@gmail.com >
2025-10-11 06:27:51 +00:00
dennis zhuang
57d84b9de5
feat: supports value aliasing in TQL ( #7041 )
...
* feat: supports value aliasing in TQL
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: invalid checking
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: remove invalid checking
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* test: add explain test
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: improve parser
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* test: add explain TQL-CTE
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
---------
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-10-11 02:49:09 +00:00
LFC
243dbde3d5
refactor: rewrite some UDFs to DataFusion style (final part) ( #7023 )
...
Signed-off-by: luofucong <luofc@foxmail.com >
2025-09-26 09:24:29 +00:00
discord9
aca8b690d1
fix: step aggr merge phase not order nor filter ( #6998 )
...
* fix: not order
Signed-off-by: discord9 <discord9@163.com >
* test: redacted
Signed-off-by: discord9 <discord9@163.com >
* feat: fix up state wrapper
Signed-off-by: discord9 <discord9@163.com >
* df last_value state not as promised!
Signed-off-by: discord9 <discord9@163.com >
* fix?: could fix better
Signed-off-by: discord9 <discord9@163.com >
* test: unstable result
Signed-off-by: discord9 <discord9@163.com >
* fix: work around by fixing state
Signed-off-by: discord9 <discord9@163.com >
* chore: after rebase fix
Signed-off-by: discord9 <discord9@163.com >
* chore: finish some todo
Signed-off-by: discord9 <discord9@163.com >
* chore: per copilot
Signed-off-by: discord9 <discord9@163.com >
* refactor: not fix but just notify mismatch
Signed-off-by: discord9 <discord9@163.com >
* chore: warn -> debug state mismatch
Signed-off-by: discord9 <discord9@163.com >
* chore: refine error msg
Signed-off-by: discord9 <discord9@163.com >
* test: sqlness add last_value date_bin test
Signed-off-by: discord9 <discord9@163.com >
* ?: substrait order by decode failure
Signed-off-by: discord9 <discord9@163.com >
* unit test reproduce that
Signed-off-by: discord9 <discord9@163.com >
* feat: support state wrapper's order serde in substrait
Signed-off-by: discord9 <discord9@163.com >
* refactor: stuff
Signed-off-by: discord9 <discord9@163.com >
* test: standalone/distributed different exec
Signed-off-by: discord9 <discord9@163.com >
* fmt
Signed-off-by: discord9 <discord9@163.com >
* chore: per review
Signed-off-by: discord9 <discord9@163.com >
* refactor: closure
Signed-off-by: discord9 <discord9@163.com >
* test: first value order by
Signed-off-by: discord9 <discord9@163.com >
* refactor: per cr
Signed-off-by: discord9 <discord9@163.com >
* feat: ScanHint last_value last row selector
Signed-off-by: discord9 <discord9@163.com >
* docs: per cr
Signed-off-by: discord9 <discord9@163.com >
---------
Signed-off-by: discord9 <discord9@163.com >
2025-09-26 09:12:45 +00:00
dennis zhuang
17d16da483
feat: supports expression in TQL params ( #7014 )
...
* feat: supports expression in TQL params
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: by cr comments
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: comment
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: by cr comments
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
---------
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-09-26 03:43:50 +00:00
dennis zhuang
c6e5552f05
test: migrate aggregation tests from duckdb, part4 ( #6965 )
...
* test: migrate aggregation tests from duckdb, part4
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: tests
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: rename tests
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* fix: comments
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: ignore zero weights test
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
* chore: remove duplicated sql
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
---------
Signed-off-by: Dennis Zhuang <killme2008@gmail.com >
2025-09-25 08:00:17 +00:00
discord9
9c8ff1d8a0
fix: skip placeholder when partition columns ( #7020 )
...
Signed-off-by: discord9 <discord9@163.com >
2025-09-25 07:01:49 +00:00
Ning Sun
964dc254aa
feat: upgraded pg_catalog support ( #6918 )
...
* refactor: add datafusion-postgres dependency
* refactor: move and include pg_catalog udfs
* chore: update upstream
* feat: register table function pg_get_keywords
* feat: bridge CatalogInfo for our CatalogManager
Signed-off-by: Ning Sun <sunning@greptime.com >
* feat: convert pg_catalog table to our system table
* feat: bridge system catalog with datafusion-postgres
Signed-off-by: Ning Sun <sunning@greptime.com >
* feat: add more udfs
* feat: add compatibility rewriter to postgres handler
* fix: various fix
* fmt: fix
* fix: use functions from pg_catalog library
* fmt
* fix: sqlness runner
Signed-off-by: Ning Sun <sunning@greptime.com >
* test: adopt arrow 56.0 to 56.1 memory size change
* fix: add additional udfs
* chore: format
* refactor: return None when creating system table failed
Signed-off-by: Ning Sun <sunning@greptime.com >
* chore: provide safety comments about expect usage
---------
Signed-off-by: Ning Sun <sunning@greptime.com >
2025-09-25 04:05:34 +00:00
Lin Yihai
b5a8725582
feat(copy_to_csv): add date_format/timestamp_format/time_format. ( #6995 )
...
feat(copy_to_csv): add `date_format` and so on to `Copy ... to with` syntax
Signed-off-by: Yihai Lin <yihai-lin@foxmail.com >
2025-09-24 06:22:53 +00:00
Ruihang Xia
c7050831db
fix: match promql column reference in case sensitive way ( #7013 )
...
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2025-09-24 03:28:09 +00:00
Zhenchi
80c8ab42b0
feat: add ssts releated system table ( #6924 )
...
* feat: add InformationExtension.inspect_datanode for datanode inspection
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* aggregate results from all datanodes
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix fmt
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* feat: add ssts releated system table
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* update sst entry
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* address comments
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix sqlness
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix sqlness
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
---------
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
2025-09-23 11:06:00 +00:00
Ruihang Xia
078379816c
fix: incorrect timestamp resolution in information_schema.partitions table ( #7004 )
...
* fix: incorrect timestamp resolution in information_schema.partitions table
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* use second for all fields in partitions table
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update sqlness result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2025-09-23 06:13:10 +00:00
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
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
