OceanBase动态分区技术

OceanBase 技术问题
#1

请问OceanBase社区版目前支持动态创建分区吗？

1 个赞
#3

偿试一下

#4

试了一下，不支持，社区版本为oceanbase-all-in-one-4.3.5_bp2_hf1_20250527.el7.x86_64.tar.gz

obclient(app_test@my_tenant_htap)[dbtest]> CREATE TABLE test_tbl1 (col1 INT, col2 DATETIME)
→ DYNAMIC_PARTITION_POLICY(
→ ENABLE = true,
→ TIME_UNIT = ‘hour’,
→ PRECREATE_TIME = ‘3 hour’,
→ EXPIRE_TIME = ‘1 day’,
→ TIME_ZONE = ‘+8:00’,
→ BIGINT_PRECISION = ‘none’
→ )
→ PARTITION BY RANGE COLUMNS (col2)(
→ PARTITION P0 VALUES LESS THAN (‘2025-04-15 13:30:00’)
→ );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'DYNAMIC_PARTITION_POLICY(
ENABLE = true,
TIME_UNIT = ‘hour’,
’ at line 2
obclient(app_test@my_tenant_htap)[dbtest]>

1 个赞
#5

官方能给个确认信息吗？

#6

文档上说要 MANAGE_DYNAMIC_PARTITION 程序包

#8

https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000002978411
435bp2支持该功能了

#9

@辞霜 这个435bp2指的是企业版吧？ 我的社区版本是

/ob_app/admin/oceanbase/bin/observer -V
observer (OceanBase_CE 4.3.5.0)

REVISION: 100000202024123117-5d6cb5cbc3f7c1ab6eb22e40abec8e160a8764d5
BUILD_BRANCH: HEAD
BUILD_TIME: Dec 31 2024 17:35:01
BUILD_FLAGS: RelWithDebInfo
BUILD_INFO:

Copyright (c) 2011-present OceanBase Inc.

#10

社区版同样支持，可以去下载中心下载后升级新版本体验，版本号为V4.3.5_CE_BP2

#11

社区版做做测试就行了 :thinking: