文档首页/ 数据仓库服务 GaussDB(DWS)/ 工具指南/ DSC/ MySQL语法迁移/ 表（可选参数、操作）/ BLOCK_SIZE
更新时间：2024-06-29 GMT+08:00
查看PDF
分享

BLOCK_SIZE

在ADB中，指定列式存储中每个block存储的Value的个数，也是最小的IO单元。GaussDB(DWS)不支持该属性修改表定义信息，DSC迁移时会将该关键字删除。

输入示例

1
2
3
4
5
6
7
 
DROP TABLE IF EXISTS exists unsupport_parse_test;
CREATE TABLE `unsupport_parse_test` (
    `username` int,
    `update` timestamp not null default current_timestamp on update current_timestamp ,
     clustered key clustered_key(shopid ASC, datetype ASC)
)BLOCK_SIZE = 1024 index_ALL = 'y';
DROP TABLE IF EXISTS unsupport_parse_test;

输出示例

1
2
3
4
5
6
 
DROP TABLE IF EXISTS "public"."unsupport_parse_test";
CREATE TABLE "public"."unsupport_parse_test" (
  "username" INTEGER,
  "update" TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP
) WITH (ORIENTATION = ROW, COMPRESSION = NO) NOCOMPRESS DISTRIBUTE BY HASH ("username");
DROP TABLE IF EXISTS "public"."unsupport_parse_test";