liu ming created TRAFODION-2119: ----------------------------------- Summary: create table report strange WARNING when using store by and allow_nullable_unique_key_constraint CQD Key: TRAFODION-2119 URL: https://issues.apache.org/jira/browse/TRAFODION-2119 Project: Apache Trafodion Issue Type: Bug Reporter: liu ming
cqd allow_nullable_unique_key_constraint 'on' ; create table T_RH_DZSP ( s_orgcode CHAR(12) character set utf8, s_applydate CHAR(8) character set utf8, s_packno varchar(8) character set utf8, s_trecode CHAR(10) character set utf8, s_trename varchar(60) character set utf8, s_taxorgcode varchar(12) character set utf8, s_paybnkno varchar(12) character set utf8, s_trano varchar(8) character set utf8, s_orimsgno CHAR(4) character set utf8, f_traamt numeric(18,2), s_payeropnbnkno varchar(12) character set utf8, payeropbkname varchar(60) character set utf8, s_handorgname varchar(200) character set utf8, s_payacct varchar(32) character set utf8, s_taxvouno varchar(20) character set utf8, s_billdate CHAR(8) character set utf8, s_taxpaycode varchar(20) character set utf8, s_taxpayname varchar(200) character set utf8, c_budgettype CHAR(1) character set utf8, c_trimflag CHAR(1) character set utf8, s_etpcode varchar(20) character set utf8, s_etpname varchar(200) character set utf8, s_etptype varchar(20) character set utf8, s_bdgsbtcode varchar(30) character set utf8, s_bdgsbtname varchar(60) character set utf8, s_limit CHAR(8) character set utf8, s_taxtypecode CHAR(10) character set utf8, s_taxkindname varchar(60) character set utf8, c_bdglevel CHAR(1) character set utf8, c_bdglevelname varchar(60) character set utf8, s_taxstartdate CHAR(8) character set utf8, s_taxenddate CHAR(8) character set utf8, s_astflag varchar(35) character set utf8, c_taxtype CHAR(1) character set utf8, s_acct CHAR(8) character set utf8, s_trastate CHAR(2) character set utf8, s_remark varchar(60) character set utf8, s_remark1 varchar(60) character set utf8, s_remark2 varchar(60) character set utf8, s_inputerid varchar(18) character set utf8, ts_sysupdate varchar(100) character set utf8, s_seq varchar(100) character set utf8 ) store by (S_APPLYDATE) salt using 48 partitions on (S_APPLYDATE) ATTRIBUTES ALIGNED FORMAT HBASE_OPTIONS ( DATA_BLOCK_ENCODING = 'FAST_DIFF', -- COMPRESSION = 'SNAPPY', MEMSTORE_FLUSH_SIZE = '1073741824' ); *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. --- SQL operation complete. >> -- This message was sent by Atlassian JIRA (v6.3.4#6332)