数据仓库服务 GAUSSDB(DWS)-表（Netezza）:大字段类型

时间：2024-10-26 11:41:18

大字段类型

行存储支持BLOB 和CLOB。列存储不支持BLOB，仅支持CLOB。

Netezza语法

迁移后语法

       
            CREATE TABLE  prod 
 ( 
      prod_no              number(6)      not null, 
      prod_name         national character varying(32)      not null, 
      prod_desc          clob, 
      prod_image        blob 
 ) 
 DISTRIBUTE ON (prod_no, prod_name) 
 ORGANIZE   ON (prod_no, prod_name) 
 ;

       
            CREATE TABLE  prod 
 ( 
      prod_no              number(6)      not null, 
      prod_name         national character varying(32)      not null, 
      prod_desc          clob, 
      prod_image       bytea 
 ) WITH(ORIENTATION=COLUMN) 
 DISTRIBUTE BY HASH (prod_no, prod_name) 
 /* ORGANIZE   ON (prod_no, prod_name) */ 
 ;