[
https://issues.apache.org/jira/browse/TRAFODION-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
chenyunren resolved TRAFODION-2978.
-----------------------------------
Resolution: Fixed
> update statistics would hang for 100 billion rows table
> -------------------------------------------------------
>
> Key: TRAFODION-2978
> URL: https://issues.apache.org/jira/browse/TRAFODION-2978
> Project: Apache Trafodion
> Issue Type: Bug
> Environment: CentOS
> Reporter: chenyunren
> Assignee: chenyunren
> Priority: Major
>
> CREATE TABLE T1
> (
> C1 INT DEFAULT NULL NOT SERIALIZED
> , C2 INT DEFAULT NULL NOT SERIALIZED
> , C3 VARCHAR(100 CHARS) CHARACTER SET UTF8
> COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
> , C4 VARCHAR(100 CHARS) CHARACTER SET UTF8
> COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED
> , C5 LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
> NOT SERIALIZED
> , C6 LARGEINT DEFAULT NULL NOT SERIALIZED
> , C7 LARGEINT DEFAULT NULL NOT SERIALIZED
> , C8 DOUBLE PRECISION DEFAULT NULL NOT
> SERIALIZED
> , C9 LARGEINT DEFAULT NULL NOT SERIALIZED
> , C10 DOUBLE PRECISION DEFAULT NULL NOT
> SERIALIZED
> , C11 LARGEINT DEFAULT NULL NOT SERIALIZED
> , C12 LARGEINT DEFAULT NULL NOT SERIALIZED
> , C13 LARGEINT DEFAULT NULL NOT SERIALIZED
> , C14 DOUBLE PRECISION DEFAULT NULL NOT
> SERIALIZED
> , C15 DOUBLE PRECISION DEFAULT NULL NOT
> SERIALIZED
> , C16 LARGEINT DEFAULT NULL NOT SERIALIZED
> , C17 LARGEINT DEFAULT NULL NOT SERIALIZED
> , C18 DOUBLE PRECISION DEFAULT NULL NOT
> SERIALIZED
> , C19 LARGEINT DEFAULT NULL NOT SERIALIZED
> , C20 DOUBLE PRECISION DEFAULT NULL NOT
> SERIALIZED
> , C21 LARGEINT DEFAULT NULL NOT SERIALIZED
> , C22 DOUBLE PRECISION DEFAULT NULL NOT
> SERIALIZED
> , C23 LARGEINT DEFAULT NULL NOT SERIALIZED
> , C24 DOUBLE PRECISION DEFAULT NULL NOT
> SERIALIZED
> )
> STORE BY (C5 ASC, C3 ASC)
> SALT USING 10 PARTITIONS
> HBASE_OPTIONS
> (
> DATA_BLOCK_ENCODING = 'FAST_DIFF',
> MEMSTORE_FLUSH_SIZE = '1073741824'
> )
> ;
>
> just to run below sql
> update statistics for table T1 on every column, (C2, C3),(C1, C2, C3), (C1,
> C2, C3, C4) sample;
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
