[ https://issues.apache.org/jira/browse/TRAFODION-2009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15297190#comment-15297190 ]
Eric Owhadi commented on TRAFODION-2009: ---------------------------------------- set severity to minor because parallel_scanner is experimental feature disabled by default. > 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 > 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)