Lei, HUANG
d275cdd570
feat: Support altering table TTL ( #4848 )
...
* feat/alter-ttl:
Update greptime-proto source and add ChangeTableOptions handling
- Change greptime-proto source repository and revision in Cargo.lock and Cargo.toml
- Implement handling for ChangeTableOptions in grpc-expr and meta modules
- Add support for parsing and applying region option changes in mito2
- Introduce new error type for invalid change table option requests
- Add humantime dependency to store-api
- Fix SQL syntax in tests for changing column types
* chore: remove write buffer size option handling since we don't support specifying write_buffer_size for single table or region
* persist ttl to manifest
* chore: add sqlness
* fix: sqlness
* fix: typo and toml format
* fix: tests
* update: change alter syntax
* feat/alter-ttl: Add Clone trait to RegionFlushRequest and remove redundant Default derive in region_request.rs.
* feat/alter-ttl: Refactor code to replace 'ChangeTableOption' with 'ChangeRegionOption' and handle TTL as a region option
• Rename ChangeTableOption to ChangeRegionOption across various files.
• Update AlterKind::ChangeTableOptions to AlterKind::ChangeRegionOptions.
• Modify TTL handling to treat '0d' as None for TTL in table options.
• Adjust related function names and comments to reflect the change from table to region options.
• Include test case updates to verify the new TTL handling behavior.
* chore: update format
* refactor: update region options in DatanodeTableValue
* feat/alter-ttl:
Remove TTL handling from RegionManifest and related structures
- Eliminate TTL fields from `RegionManifest`, `RegionChange`, and associated handling logic.
- Update tests and checksums to reflect removal of TTL.
- Refactor `RegionOpener` and `handle_alter` to adjust to TTL removal.
- Simplify `RegionChangeResult` by replacing `change` with `new_meta`.
* chore: fmt
* remove useless delete op
* feat/alter-ttl: Updated Cargo.lock and gRPC expression Cargo.toml to include store-api dependency. Refactored alter.rs to use ChangeOption from store-api instead of ChangeTableOptionRequest.
Adjusted error handling in error.rs to use MetadataError. Modified handle_alter.rs to handle TTL changes with ChangeOption. Simplified region_request.rs by replacing
ChangeRegionOption with ChangeOption and removing redundant code. Removed UnsupportedTableOptionChange error in table/src/error.rs. Updated metadata.rs to use ChangeOption for table
options. Removed ChangeTableOptionRequest enum and related conversion code from requests.rs.
* feat/alter-ttl: Update greptime-proto dependency to revision 53ab9a9553
* chore: format code
* chore: update greptime-proto
2024-10-30 04:39:48 +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
Ruihang Xia
b25a2b117e
feat: remove sql in error desc ( #4589 )
...
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2024-08-20 06:37:30 +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
Yingwen
65f8b72d34
feat: Implement RegionScanner for SeqScan ( #4060 )
...
* feat: ordered builder wip
* feat: impl RegionScanner for SeqScan
* feat: implement scan_partition and build_stream
* chore: return SeqScan as RegionScanner
* fix: group parts
* feat: split parts
* chore: reader metrics
* chore: metrics
* chore: remove unused codes
* chore: support holding a group of ranges in ScanPart
* feat: group ScanParts to ScanParts
* feat: impl SeqScanner again
* chore: observe build cost in ScannerMetrics
* chore: fix compiler warnings
* style: fix clippy
* docs: update config docs
* chore: forward DisplayAs to scanner
* test: update sqlness tests
* chore: update debug fmt
* chore: custom debug for timestamp
fix test compiling issue with common-macro when running
cargo nextest -p common-time
* chore: update debug format
* feat: update fmt for scan part
* chore: fix warning
* fix: sanitize parallelism
* feat: split parts
* test: fix config api test
* feat: update logs
* chore: Revert "chore: remove unused codes"
This reverts commit b548b30a01eeded59b1a0a8d89f9293ca63afc41.
* chore: Revert "docs: update config docs"
This reverts commit a7997e78d6ddcf635560574de8c1948c495bdd12.
* feat: each partition scan files in parallel
* test: fix config api test
* docs: fix typo
* chore: address comments, simplify tests
* feat: global semaphore
* feat: always spawn task
* chore: simplify default explain output format
* handle output partiton number is 0
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix typo
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
2024-06-12 08:21:30 +00:00
Kould
aba5e41799
feat: support ALTER TABLE ... MODIFY COLUMN ... ... ( #3796 )
...
* feat: support `ALTER COLUMN xxx TYPE xxx`
* fix: test `test_parse_alter_change_column_type`
* style: code fmt
* style: move to new test: `test_make_alter_column_type_region_request`
* style: simplify the code
* style: remove `v1::region::ChangeColumnType`
* resolve conflicts
* fix: test `test_make_alter_column_type_region_request`
* style: simplify the code
* rebase
* rebase
* rebase
* fix: `ALTER COLUMN ... TYPE` -> `MODIFY COLUMN`
* fix: `parser` -> `self.parser`
* Apply suggestions from code review
---------
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: WenyXu <wenymedia@gmail.com >
2024-04-30 03:13:33 +00:00
Yingwen
77fc1e6de0
fix: prune row groups correctly for columns with the same name ( #3802 )
...
* test: add prune test case
* fix: use latest region metadata to get column id
* test: sort output
2024-04-26 06:52:23 +00:00
Ruihang Xia
bf21527f18
fix: set is_time_index properly on updating physical table's schema ( #3770 )
...
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2024-04-22 12:37:25 +00:00
JeremyHi
58c7858cd4
feat: update physical table schema on alter logical tables ( #3585 )
...
* feat: update physical table schema on alter
* feat: alter logical table in sql path
* feat: invalidate cache step1
* feat: invalidate cache step2
* feat: invalidate cache step3
* feat: invalidate cache step4
* fix: failed ut
* fix: standalone cache invalidator
* feat: log the count of already finished
* feat: re-invalidate cache
* chore: by comment
* chore: Update src/common/meta/src/ddl/create_logical_tables.rs
---------
Co-authored-by: Yingwen <realevenyag@gmail.com >
2024-03-26 14:29:53 +00:00
Ruihang Xia
74565151e9
fix: update pk_cache in compat reader ( #3576 )
...
* fix: update pk_cache in compat reader
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add sqlness case
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update document
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add more sqlness case
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* avoid mysterious bug
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2024-03-26 08:31:00 +00:00
dennis zhuang
43ef0820c0
fix: SQL insertion and column default constraint aware of timezone ( #3266 )
...
* fix: missing timezone when parsing sql value to greptimedb value
* test: sql_value_to_value
* fix: column default constraint missing timezone
* test: column def default constraint with timezone
* test: adds sqlness test for default constraint aware of timezone
* fix: typo
* chore: comment
2024-01-30 09:15:38 +00:00
dennis zhuang
f9e7762c5b
fix: add new column as primary key can't work ( #2876 )
2023-12-05 11:07:53 +00:00
Ruihang Xia
92a9802343
feat: canonicalize all unquoted identifier to lowercase ( #2828 )
...
* feat: canonicalize all unquoted identifier to lowercase
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add more tests
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* test altering table
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* primary key declare
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix primary key declare
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* partition by and time index
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* remove redundent call to canonicalize
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-11-29 06:40:10 +00:00
Weny Xu
e42767d500
fix: fix name verifying ( #2825 )
2023-11-28 02:47:03 +00:00
Ruihang Xia
56fc77e573
fix: add missing error display message ( #2791 )
...
* fix: add missing error display message
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 >
2023-11-23 02:59:49 +00:00
JeremyHi
52ac093110
fix: drop table 0 rows affected ( #2515 )
2023-09-28 06:21:18 +00:00
Niwaka
f9351e4fb5
chore: add integration test for issue2437 ( #2481 )
2023-09-25 06:23:16 +00:00
Ruihang Xia
802229de87
fix: type cast bugs found by sqlness ( #2438 )
...
* update valid results
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* accomplish datatype
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* cast null
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix unit tests
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-09-19 08:20:41 +00:00
Yingwen
da54a0c139
fix: alter table procedure forgets to update next column id ( #2385 )
...
* feat: add more info to error messages
* feat: store next column id in procedure
* fix: update next column id for table info
* test: fix add col test
* chore: remove location from invalid request error
* test: update test
* test: fix test
2023-09-14 02:06:57 +00:00
dennis zhuang
b1599ad3a5
fix: can't adding new columns as primary key ( #2310 )
2023-09-12 07:57:15 -05:00
dennis zhuang
db89235474
feat: only allow timestamp type as time index ( #2281 )
...
* feat: only allow timestamp data type as time index
* test: update sqltest cases, todo: need some fixes
* fix: sqlness tests
* fix: forgot adding back cte test
* chore: style
2023-09-12 07:57:15 -05:00
JeremyHi
c02ac36ce8
feat: avoid confusion in desc table ( #2272 )
...
feat: Field to Column to aviod confusion in DESC TABLE
2023-08-28 11:50:33 +00:00
JeremyHi
de1daec680
feat: upgrade desc table output ( #2256 )
2023-08-25 06:52:22 +00:00
dennis zhuang
272f649b22
fix: some TODO in sqlness cases and refactor meta-client error ( #2207 )
...
* fix: some TODO in sqlness cases and refactor meta-client error
* fix: delete tests/cases/standalone/alter/drop_col_not_null_next.output
2023-08-18 10:09:11 +00:00
JeremyHi
24dc827ff9
feat: grpc handler result ( #2107 )
...
* feat: grpc handler inner result
* feat: ext header, x-greptime-err-code, x-greptime-err-msg
* fix: sqlness case
* chore: by comment
* fix: convert status to Error
2023-08-15 09:34:00 +00:00
JeremyHi
2ef0d06cdb
feat: status_code in response header ( #1982 )
...
* feat: status_code in response header
* chore: parese grpc response
* fix: sqlness failed
* chore: fix sqlness
2023-07-19 11:27:49 +00:00
fys
86adac1532
chore: reject table creation when partitions exceeds peer number ( #1654 )
...
* chore: table creation is rejected, when partition_num exceeds peer_num
* chore: modify no_active_datanode error msg
* fix: ut
* fix sqlness test and add limit for select peer in region_failover
* upgrade greptime-proto
* self cr
* fix: cargo sqlness
* chore: add table info in select ctx for failover
* fix sqlness
2023-06-01 09:05:17 +00:00
Zheming Li
5467ea496f
feat: Add column supports at first or after the existing columns ( #1621 )
...
* feat: Add column supports at first or after the existing columns
* Update src/common/query/Cargo.toml
---------
Co-authored-by: dennis zhuang <killme2008@gmail.com >
2023-06-01 02:13:00 +00:00
Ruihang Xia
b9db2cfd83
fix: support restart sqlness in distributed mode ( #1443 )
...
* fix: support restart sqlness in distributed mode
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* move alter_table case to common dir
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* is_standalone flag
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* Update tests/runner/src/env.rs
Co-authored-by: LFC <bayinamine@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: LFC <bayinamine@gmail.com >
2023-04-24 19:36:12 +08:00
LFC
9ad6c45913
test: Sqlness tests for distribute mode ( #979 )
...
* test: Sqlness tests for distribute mode
* ci
* fix: resolve PR comments
* fix: resolve PR comments
2023-02-14 10:24:09 +08:00