开发者社区> 问答> 正文

OceanBase数据库请问是版本问题吗?

"OceanBase数据库CREATE TABLE LOG (
ID char(36) NOT NULL,
AREA char(512),
CODE char(512),
CREATE_TIME DATE,
RESULT_CNT NUMBER(8),
EXECUTE NUMBER(8),
ST_TIME NUMBER(20),
CR_DATE NUMBER(8),
CONSTRAINT API_EXECUTE_LOGErrorCode = 1064, SQLState = 42000, Details = You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'COMPRESS FOR ARCHIVE REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE' at line 11_OBPK_1658719598991103 PRIMARY KEY (ID)
) COMPRESS FOR ARCHIVE REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0;
以上OceanBase的建表语句报错如下:;
ErrorCode = 1064, SQLState = 42000, Details = You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'COMPRESS FOR ARCHIVE REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE' at line 11 请问是版本问题吗?"

展开
收起
闲o月 2024-06-01 22:24:50 37 0
来自:OceanBase
1 条回答
写回答
取消 提交回答
  • 2.2.77使用得是ora模式还是mysql模式? 你可以先修改下建表语句 327ce253ace25723600f7af88b9f620d.png 2.2.77是企业版 313是社区版 建表语句改改试试看 此回答整理自钉群:“[社区]技术答疑群OceanBase”

    2024-06-01 22:42:13
    赞同 展开评论 打赏
来源圈子
更多
收录在圈子:
+ 订阅
蚂蚁OceanBase数据库团队,用于OceanBase技术原理、运维经验和案例分享、对外交流。
问答排行榜
最热
最新

相关电子书

更多
开源HTAP OceanBase产品揭秘 立即下载
云数据库OceanBase 架构演进及在金融核心系统中的实践 立即下载
自研金融数据库OceanBase的创新之路 立即下载