[ https://issues.apache.org/jira/browse/TRAFODION-2952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liu ming resolved TRAFODION-2952. --------------------------------- Resolution: Fixed Fix Version/s: 2.4 > large amount of data will cause error in sequence generating > ------------------------------------------------------------ > > Key: TRAFODION-2952 > URL: https://issues.apache.org/jira/browse/TRAFODION-2952 > Project: Apache Trafodion > Issue Type: Bug > Reporter: liu ming > Assignee: liu ming > Priority: Major > Fix For: 2.4 > > > insert error > ** ERROR[1583] Sequence metadata could not be updated. > create table test1 > (id LARGEINT not null > ) primary key(id) > SALT USING 48 PARTITIONS > ATTRIBUTES ALIGNED FORMAT > HBASE_OPTIONS > ( > DATA_BLOCK_ENCODING = 'FAST_DIFF', > COMPRESSION = 'SNAPPY', > MEMSTORE_FLUSH_SIZE = '1073741824' > ); > create table test2 > (id LARGEINT not null > ) primary key(id) > SALT USING 48 PARTITIONS > ATTRIBUTES ALIGNED FORMAT > HBASE_OPTIONS > ( > DATA_BLOCK_ENCODING = 'FAST_DIFF', > COMPRESSION = 'SNAPPY', > MEMSTORE_FLUSH_SIZE = '1073741824' > ); > create sequence seq ; > alter sequence seq cache 20000; > upsert into test2 select seqnum(seq, next) from test1; > test1 table has about 4 billion rows. When error raised , next value of seq > is 5300001 > CREATE SEQUENCE TRAFODION.SEABASE.SEQ > START WITH 1 /* NEXT AVAILABLE VALUE 5300001 */ > INCREMENT BY 1 > MAXVALUE 9223372036854775806 > MINVALUE 1 > CACHE 20000 > NO CYCLE > LARGEINT > ; -- This message was sent by Atlassian JIRA (v7.6.3#76005)