Kaifeng Zheng
4e9c251041
feat: add json_path_match udf ( #4864 )
...
* add json_path_match udf
* sql tests for json_path_match
* fix clippy & comment
* fix null value behavior
* added null tests
* adjust function's behavior on nulls
* update test cases
* fix null check of json
2024-10-25 03:13:34 +00:00
Ning Sun
bb8b54b5d3
feat: add some s2 geo functions ( #4823 )
...
* feat: add first batch of s2 functions
* refactor: update reusable code from main
* test: add sqlness tests for s2
* feat: add tostring function for s2
* Update src/common/function/src/scalars/geo/s2.rs
Co-authored-by: Lei, HUANG <6406592+v0y4g3r@users.noreply.github.com >
* Apply suggestions from code review
* one more change
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: Lei, HUANG <6406592+v0y4g3r@users.noreply.github.com >
2024-10-15 06:47:29 +00:00
Ning Sun
aaa9b32908
feat: add more h3 functions ( #4770 )
...
* feat: add more h3 grid functions
* feat: add more traversal functions
* refactor: update some function definitions
* style: format
* refactor: avoid creating slice in nested loop
* feat: ensure column number and length
* refactor: fix lint warnings
* refactor: merge main
* Apply suggestions from code review
Co-authored-by: LFC <990479+MichaelScofield@users.noreply.github.com >
* Update src/common/function/src/scalars/geo/h3.rs
Co-authored-by: LFC <990479+MichaelScofield@users.noreply.github.com >
* style: format
---------
Co-authored-by: LFC <990479+MichaelScofield@users.noreply.github.com >
2024-10-11 17:57:54 +00:00
Yohan Wal
288fdc3145
feat: json_path_exists udf ( #4807 )
...
* feat: json_path_exists udf
* chore: fix comments
* fix: caution when copy&paste QAQ
2024-10-10 14:15:34 +00:00
Ning Sun
19918928c5
feat: add function to aggregate path into a geojson path ( #4798 )
...
* feat: add geojson function to aggregate paths
* test: add sqlness results
* test: add sqlness
* refactor: corrected to aggregation function
* chore: update comments
* fix: make linter happy again
* refactor: rename to remove `geo` from `geojson` function name
The return type is not geojson at all. It's just compatible with geojson's
coordinates part and superset's deckgl path plugin.
2024-10-09 02:38:44 +00:00
Ning Sun
0f99218386
feat: list/array/timezone support for postgres output ( #4727 )
...
* feat: list/array support for postgres output
* fix: implement time zone support for postgrsql
* feat: add a geohash function that returns array
* fix: typo
* fix: lint warnings
* test: add sqlness test
* refactor: check resolution range before convert value
* fix: test result for sqlness
* feat: upgrade pgwire apis
2024-09-22 02:39:38 +00:00
Ning Sun
75c6fad1a3
feat: add more h3 scalar functions ( #4707 )
...
* feat: add more h3 scalar functions
* chore: comment up
2024-09-20 04:19:50 +00:00
Yohan Wal
f73fb82133
feat: add respective json_is UDFs for JSON type ( #4726 )
...
* feat: add respective json_is UDFs
* refactor: rename to_json to parse_json
* chore: happy clippy
* chore: some rename
* fix: small fixes
2024-09-18 11:07:30 +00:00
Yohan Wal
67fb3d003e
feat: add respective get_by_path UDFs for JSON type ( #4720 )
...
* feat: add respectiv get_by_path udf for json type
* Apply review comments
Co-authored-by: Weny Xu <wenymedia@gmail.com >
* fix: fix compile error
* refactor: change name of UDFs, add some tests
---------
Co-authored-by: Weny Xu <wenymedia@gmail.com >
2024-09-11 08:17:57 +00:00
Ning Sun
c22a398f59
fix: return version string based on request protocol ( #4680 )
...
* fix: return version string based on request protocol
* fix: resolve lint issue
2024-09-09 03:36:54 +00:00
Ning Sun
e476e36647
feat: add geohash and h3 as built-in functions ( #4656 )
...
* feat: add built-in functions h3 and geohash
* tests: add sqlness tests for geo functions
* doc: correct h3 comment
* fix: lint error
* fix: toml format
* refactor: address review comments
* test: add more sqlness cases
* Apply suggestions from code review
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
---------
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
2024-09-05 04:42:29 +00:00
dennis zhuang
63f2463273
feat!: impl admin command ( #4600 )
...
* feat: impl admin statement parser
* feat: introduce AsyncFunction and implements it for admin functions
* feat: execute admin functions
* fix: license header
* fix: panic in test
* chore: fixed by code review
2024-08-26 07:53:40 +00:00
dennis zhuang
0710e6ff36
fix: remove to_timezone function ( #4439 )
...
fix: remove to_timezone, it doesn't make sense
2024-07-26 07:40:07 +00:00
dennis zhuang
be3ea0fae7
feat: improve datafusion external error and mysql error ( #4362 )
...
* feat: improve datafusion external error and mysql error
* chore: address CR comments and fix tests
---------
Co-authored-by: evenyag <realevenyag@gmail.com >
2024-07-16 07:01:09 +00:00
tison
285ffc5850
fix: build info should use build time env var ( #4343 )
...
* fix: build info should use build time env var
Signed-off-by: tison <wander4096@gmail.com >
* catch up
Signed-off-by: tison <wander4096@gmail.com >
* fixup lifetime
Signed-off-by: tison <wander4096@gmail.com >
* fixup
Signed-off-by: tison <wander4096@gmail.com >
* fix more
Signed-off-by: tison <wander4096@gmail.com >
---------
Signed-off-by: tison <wander4096@gmail.com >
2024-07-12 03:08:30 +00:00
LFC
cc2f7efb98
chore: bump datafusion version to fix last_value regression ( #4169 )
...
* chore: bump datafusion version to fix `last_value` regression
* fix: resolve PR comments
* fix ci
2024-06-19 07:47:17 +00:00
LFC
314f2704d4
build(deps): update datafusion to latest and arrow to 51.0 ( #3661 )
...
* chore: update datafusion
* update sqlness case of time.sql
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix: adjust range query partition
* fix: hisogram incorrect result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix: ignore filter pushdown temporarily
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix: update limit sqlness result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix: histogram with wrong distribution
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix: update negative ordinal sqlness case
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* feat: bump df to cd7a00b
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* resolve conflicts
* ignore test_range_filter
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix promql exec panic
* fix "select count(*)" exec error
* re-enable the "test_range_filter" test since the filter push down seems not necessary to be removed
* fix: range query schema error
* update sqlness results
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* resolve conflicts
* update datafusion, again
* fix pyo3 compile error, and update some sqlness results
* update decimal sqlness cases
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix: promql literal
* fix udaf tests
* fix filter pushdown sqlness tests
* fix?: test_cast
* fix: rspy test fail due to datafusion `sin` signature change
* rebase main to see if there are any failed tests
* debug ci
* debug ci
* debug ci
* enforce input partition
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* debug ci
* fix ci
* fix ci
* debug ci
* debug ci
* debug ci
* fix sqlness
* feat: do not return error while creating a filter
* chore: remove array from error
* chore: replace todo with unimplemented
* Update src/flow/clippy.toml
Co-authored-by: Yingwen <realevenyag@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: WUJingdi <taylor-lagrange@qq.com >
Co-authored-by: discord9 <discord9@163.com >
Co-authored-by: evenyag <realevenyag@gmail.com >
Co-authored-by: tison <wander4096@gmail.com >
2024-04-18 12:07:18 +00:00
Eugene Tolbakov
18d676802a
feat(function): add timestamp epoch integer support for to_timezone ( #3620 )
...
* feat(function): add timestamp epoch integer support for to_timezone
* chore: fmt
2024-03-29 18:33:24 +00:00
tison
1255c1fc9e
feat: to_timezone function ( #3470 )
...
* feat: to_timezone function
Signed-off-by: tison <wander4096@gmail.com >
* impl Function for ToTimezoneFunction
Signed-off-by: tison <wander4096@gmail.com >
* add test
Signed-off-by: tison <wander4096@gmail.com >
* Add original authors
Co-authored-by: parkma99 <park-ma@hotmail.com >
Co-authored-by: Yingwen <realevenyag@gmail.com >
* fixup
Signed-off-by: tison <wander4096@gmail.com >
* address comments
Signed-off-by: tison <wander4096@gmail.com >
* add issue link
Signed-off-by: tison <wander4096@gmail.com >
* code refactor
Signed-off-by: tison <wander4096@gmail.com >
* further tidy
Signed-off-by: tison <wander4096@gmail.com >
---------
Signed-off-by: tison <wander4096@gmail.com >
Co-authored-by: parkma99 <park-ma@hotmail.com >
Co-authored-by: Yingwen <realevenyag@gmail.com >
2024-03-12 01:46:19 +00:00
Ruihang Xia
d8939eb891
feat: clamp function ( #3465 )
...
* basic impl
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add unit tests
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* a little type exercise
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add sqlness case
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2024-03-11 03:26:10 +00:00
dennis zhuang
4b36c285f1
feat: flush or compact table and region functions ( #3363 )
...
* feat: adds Requester to process table flush and compaction request
* feat: admin_fn macros for administration functions
* test: add query result
* feat: impl flush_region, flush_table, compact_region, and flush_region functions
* docs: add Arguments to admin_fn macro
* chore: apply suggestion
Co-authored-by: Zhenchi <zhongzc_arch@outlook.com >
* chore: apply suggestion
Co-authored-by: Zhenchi <zhongzc_arch@outlook.com >
* fix: group_requests_by_peer and adds log
* Update src/common/macro/src/admin_fn.rs
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
* feat: adds todo for spawan thread
* feat: rebase with main
---------
Co-authored-by: Zhenchi <zhongzc_arch@outlook.com >
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
2024-02-27 08:57:38 +00:00
Kould
578dd8f87a
feat: add isnull function ( #3360 )
...
* code fmt
* feat: add isnull function
* feat: add isnull function
2024-02-22 12:41:25 +00:00
tison
2a26c01412
fix: commit_short sqlness test case ( #3313 )
...
* ci: debug sqlness jobs
Signed-off-by: tison <wander4096@gmail.com >
* fix: commit_short test case
Signed-off-by: tison <wander4096@gmail.com >
* fixup! fix: commit_short test case
Signed-off-by: tison <wander4096@gmail.com >
* fixup! fixup! fix: commit_short test case
Signed-off-by: tison <wander4096@gmail.com >
* revert uploading
Signed-off-by: tison <wander4096@gmail.com >
---------
Signed-off-by: tison <wander4096@gmail.com >
2024-02-18 11:51:24 +00:00
dennis zhuang
204b9433b8
feat: adds date_format function ( #3167 )
...
* feat: adds date_format function
* fix: compile error
* chore: use system timezone for FunctionContext and EvalContext
* test: as_formatted_string
* test: sqlness test
* chore: rename function
2024-01-17 03:24:40 +00:00
Eugene Tolbakov
ca4d690424
feat: add modulo function ( #3147 )
...
* feat: add modulo function
* fix: address CR feedback
2024-01-13 00:24:25 +00:00
Ning Sun
b6033f62cd
refactor: implement version as built-in function and use fixed mysql version ( #3133 )
...
* refactor: implement version as built-in function
* test: add sqlness test for version()
2024-01-10 11:04:18 +00:00
Yue Deng
3d651522c2
feat: add build() function to return the database build info ( #2919 )
...
* feat: add build function and register it
build() function to return the database build info #2909
* refactor: fix typos and change code structure
* test: add test for build()
* refactor: cargo fmt and eliminate warnings
* Apply suggestions from code review
Co-authored-by: Weny Xu <wenymedia@gmail.com >
* refactor: move system.sql to a new directory
---------
Co-authored-by: Weny Xu <wenymedia@gmail.com >
2023-12-13 09:02:00 +00:00
dennis zhuang
43f32f4499
feat: impl date_add/date_sub functions ( #2881 )
...
* feat: adds date_add and date_sub function
* test: add date function
* fix: adds interval to date returns wrong result
* fix: header
* fix: typo
* fix: timestamp resolution
* fix: capacity
* chore: apply suggestion
* fix: wrong behavior when adding intervals to timestamp, date and datetime
* chore: remove unused error
* test: refactor and add some tests
2023-12-07 03:02:15 +00:00
Niwaka
04dbd835a1
feat: support greatest function ( #2490 )
...
* feat: support greatest function
* feat: make greatest take date_type as input
* fix: move sqlness test into common/function/time.sql
* fix: avoid using unwarp
* fix: use downcast
* refactor: simplify arrow cast
2023-09-28 10:25:09 +00:00
dennis zhuang
b81570b99a
feat: impl time type ( #1961 )
...
* chore: remove useless Option type in plugins (#1544 )
Co-authored-by: paomian <qtang@greptime.com >
* chore: remove useless Option type in plugins (#1544 )
Co-authored-by: paomian <qtang@greptime.com >
* chore: remove useless Option type in plugins (#1544 )
Co-authored-by: paomian <qtang@greptime.com >
* chore: remove useless Option type in plugins (#1544 )
Co-authored-by: paomian <qtang@greptime.com >
* feat: first commit for time type
* feat: impl time type
* fix: arrow vectors type conversion
* test: add time test
* test: adds more tests for time type
* chore: style
* fix: sqlness result
* Update src/common/time/src/time.rs
Co-authored-by: Lei, HUANG <6406592+v0y4g3r@users.noreply.github.com >
* chore: CR comments
---------
Co-authored-by: localhost <xpaomian@gmail.com >
Co-authored-by: paomian <qtang@greptime.com >
Co-authored-by: Lei, HUANG <6406592+v0y4g3r@users.noreply.github.com >
2023-07-18 02:55:28 +00:00
