[jira] [Created] (TRAFODION-413) LP Bug: 1336983 - update statistics doesn't generate stats for _SALT_ column

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-413:
------------------------------------

             Summary: LP Bug: 1336983 - update statistics doesn't generate stats for _SALT_ column
                 Key: TRAFODION-413
                 URL: https://issues.apache.org/jira/browse/TRAFODION-413
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Ravisha Neelakanthappa
            Assignee: Barry Fritchman
            Priority: Critical


>>create table shb1
+>  (uniq int not null,
+>   c10K int ,
+>   c1K   int,
+>   c100  int,
+>   c10   int,
+>   c1    int,
+>   primary key (uniq)
+>  ) salt using 4 partitions ;

--- SQL operation complete.

>>showstats for table shb1 on every column;

Histogram data for Table TRAFODION.HBASE.SHB1
Table ID: 64215260986250362

   Hist ID # Ints    Rowcount         UEC Colname(s)
========== ====== =========== =========== ===========================

No Histograms exist for the requested columns or groups


--- SQL operation complete.

>>
>>
>>upsert with no rollback
+>into shb1
+>select
+>0 + (1000 * x1000) + (100 * x100) + (10 * x10) +( 1 * x1),
+>0 + (1000 * x1000) + (100 * x100) + (10 * x10) + (1 * x1),
+>0 + (100 * x100) + (10 * x10) + (1 * x1),
+>0 + (10 * x10) + (1 * x1),
+>0 + (1 * x1),
+>0
+>from (values(0))t
+>transpose 0,1,2,3,4,5,6,7,8,9 as x1000
+>transpose 0,1,2,3,4,5,6,7,8,9 as x100
+>transpose 0,1,2,3,4,5,6,7,8,9 as x10
+>transpose 0,1,2,3,4,5,6,7,8,9 as x1
+>;

--- 10000 row(s) inserted.
>>
>>upsert using load into shb1 select
+>uniq+10000, c10K, c1K, c100, c10, c1
+>from shb1;

--- 10000 row(s) inserted.

>>update statistics for table shb1  on  uniq,c10K sample;

--- SQL operation complete.
>>
>>showstats for table shb1 on every column;

Histogram data for Table TRAFODION.HBASE.SHB1
Table ID: 64215260986250362

   Hist ID # Ints    Rowcount         UEC Colname(s)
========== ====== =========== =========== ===========================
 806944849     58       40000       40000 UNIQ
 806944844     55       40000        9948 C10K


--- SQL operation complete.
>>exit;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)