You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Eric Owhadi (JIRA)" <ji...@apache.org> on 2016/06/01 20:21:59 UTC
[jira] [Closed] (TRAFODION-2009) parallel scanner failing on
tpcds.store_sales table
[ https://issues.apache.org/jira/browse/TRAFODION-2009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eric Owhadi closed TRAFODION-2009.
----------------------------------
> 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
> Fix For: 2.1-incubating
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> 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)