文档首页 > > 工具指南> DSC SQL语法迁移工具> SQL语法迁移参考> Netezza语法迁移> Index

Index

分享
更新时间: 2020/04/21 GMT+08:00

Unique Index

行存表支持唯一索引,列存表不支持。

Netezza语法

迁移后语法

CREATE TABLE  prod
(
     prod_no              number(6)      not null    unique,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
)
DISTRIBUTE ON (prod_no)
ORGANIZE   ON (prod_no, prod_name)
;
----------
CREATE TABLE  prod
(
     prod_no              number(6)      not null     
     CONSTRAINT UQ_prod unique,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
)
DISTRIBUTE ON (prod_no)
ORGANIZE   ON (prod_no, prod_name)
;
----------
CREATE TABLE  prod
(
     prod_no              number(6)      not null    PRIMARY KEY,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
)
DISTRIBUTE ON (prod_no)
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,
     constraint          uq_prod    UNIQUE (prod_no)
)
DISTRIBUTE ON (prod_no)
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
)
DISTRIBUTE ON (prod_no)
ORGANIZE   ON (prod_no, prod_name)
;
ALTER TABLE prod
    ADD constraint          uq_prod    UNIQUE (prod_no);
CREATE TABLE  prod
(
     prod_no              number(6)      not null   /* unique */,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
) WITH(ORIENTATION=COLUMN)
DISTRIBUTE BY HASH (prod_no)
/* ORGANIZE   ON (prod_no, prod_name) */
;
----------
CREATE TABLE  prod
(
     prod_no              number(6)      not null   
  /* CONSTRAINT UQ_prod unique */,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
) WITH(ORIENTATION=COLUMN)
DISTRIBUTE BY HASH (prod_no)
/* ORGANIZE   ON (prod_no, prod_name) */
;
----------
CREATE TABLE  prod
(
     prod_no              number(6)      not null   /* PRIMARY KEY */,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
) WITH(ORIENTATION=COLUMN)
DISTRIBUTE BY HASH (prod_no)
/* 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  /*,
    constraint          uq_prod    UNIQUE (prod_no)  */
) WITH(ORIENTATION=COLUMN)
DISTRIBUTE BY HASH (prod_no)
/* 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
)
DISTRIBUTE BY HASH (prod_no)
/*ORGANIZE   ON (prod_no, prod_name)*/
;
/*
ALTER TABLE prod
    ADD constraint          uq_prod    UNIQUE (prod_no);
*/

仅适用于COLUMN store。对于ROW存储,不应注释“唯一索引”。

分享:

    相关文档

    相关产品

文档是否有解决您的问题?

提交成功!

非常感谢您的反馈,我们会继续努力做到更好!

反馈提交失败,请稍后再试!

*必选

请至少选择或填写一项反馈信息

字符长度不能超过200

提交反馈 取消

如您有其它疑问,您也可以通过华为云社区问答频道来与我们联系探讨

智能客服提问云社区提问