[jira] [Created] (TRAFODION-2009) parallel scanner failing on tpcds.store_sales table

["Eric Owhadi (JIRA)" <ji...@apache.org>]

Eric Owhadi created TRAFODION-2009:
--------------------------------------

             Summary: parallel scanner failing on tpcds.store_sales table
                 Key: TRAFODION-2009
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2009
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
    Affects Versions: 2.1-incubating
         Environment: on dev workstation
            Reporter: Eric Owhadi
            Assignee: Eric Owhadi
            Priority: Minor


CREATE TABLE TRAFODION.SEABASE.STORE_SALES
  (
    SS_SOLD_DATE_SK                  INT DEFAULT NULL NOT SERIALIZED
  , SS_ITEM_SK                       INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
      SERIALIZED
  , SS_TICKET_NUMBER                 INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
      SERIALIZED
  , SS_SOLD_TIME_SK                  INT DEFAULT NULL NOT SERIALIZED
  , SS_CUSTOMER_SK                   INT DEFAULT NULL NOT SERIALIZED
  , SS_CDEMO_SK                      INT DEFAULT NULL NOT SERIALIZED
  , SS_HDEMO_SK                      INT DEFAULT NULL NOT SERIALIZED
  , SS_ADDR_SK                       INT DEFAULT NULL NOT SERIALIZED
  , SS_STORE_SK                      INT DEFAULT NULL NOT SERIALIZED
  , SS_PROMO_SK                      INT DEFAULT NULL NOT SERIALIZED
  , SS_QUANTITY                      INT DEFAULT NULL NOT SERIALIZED
  , SS_WHOLESALE_COST                REAL DEFAULT NULL NOT SERIALIZED
  , SS_LIST_PRICE                    REAL DEFAULT NULL NOT SERIALIZED
  , SS_SALES_PRICE                   REAL DEFAULT NULL NOT SERIALIZED
  , SS_EXT_DISCOUNT_AMT              REAL DEFAULT NULL NOT SERIALIZED
  , SS_EXT_SALES_PRICE               REAL DEFAULT NULL NOT SERIALIZED
  , SS_EXT_WHOLESALE_COST            REAL DEFAULT NULL NOT SERIALIZED
  , SS_EXT_LIST_PRICE                REAL DEFAULT NULL NOT SERIALIZED
  , SS_EXT_TAX                       REAL DEFAULT NULL NOT SERIALIZED
  , SS_COUPON_AMT                    REAL DEFAULT NULL NOT SERIALIZED
  , SS_NET_PAID                      REAL DEFAULT NULL NOT SERIALIZED
  , SS_NET_PAID_INC_TAX              REAL DEFAULT NULL NOT SERIALIZED
  , SS_NET_PROFIT                    REAL DEFAULT NULL NOT SERIALIZED
  , PRIMARY KEY (SS_SOLD_DATE_SK ASC, SS_ITEM_SK ASC, SS_TICKET_NUMBER ASC)
  )
  SALT USING 8 PARTITIONS
       ON (SS_ITEM_SK, SS_TICKET_NUMBER)
 ATTRIBUTES ALIGNED FORMAT
  HBASE_OPTIONS
  (
    DATA_BLOCK_ENCODING = 'FAST_DIFF',
    BLOCKSIZE = '131072'
  )
;

load into store_sales select
   SS_SOLD_DATE_SK 
  , SS_ITEM_SK       
  , SS_TICKET_NUMBER
  , SS_SOLD_TIME_SK
  , SS_CUSTOMER_SK 
  , SS_CDEMO_SK  
  , SS_HDEMO_SK    
  , SS_ADDR_SK    
  , SS_STORE_SK   
  , SS_PROMO_SK  
  , SS_QUANTITY     
  , SS_WHOLESALE_COST  
  , SS_LIST_PRICE   
  , SS_SALES_PRICE  
  , SS_EXT_DISCOUNT_AMT  
  , SS_EXT_SALES_PRICE  
  , SS_EXT_WHOLESALE_COST   
  , SS_EXT_LIST_PRICE    
  , SS_EXT_TAX       
  , SS_COUPON_AMT    
  , SS_NET_PAID      
  , SS_NET_PAID_INC_TAX  
  , SS_NET_PROFIT     
from hive.hive.store_sales;

set statistics on;
cqd parallel_num_esps '1';
cqd hbase_dop_parallel_scanner '1.0';
prepare xx from select count(*) from store_sales where ss_customer_sk between 1000 and 20000;
execute xx;

the result will return wrong count.




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