[ 
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)

Reply via email to