You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:19:22 UTC
[jira] [Created] (TRAFODION-998) LP Bug: 1420824 - Random
partitioned a single partitioned table for nested join with a salted table
Alice Chen created TRAFODION-998:
------------------------------------
Summary: LP Bug: 1420824 - Random partitioned a single partitioned table for nested join with a salted table
Key: TRAFODION-998
URL: https://issues.apache.org/jira/browse/TRAFODION-998
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Reporter: Qifan Chen
Assignee: Qifan Chen
Priority: Critical
This bug sends rows randomly from the single partitioned table to one of the partitions of the salted table for nested join. The result may not be correct.
Please refer to operator #2.
Plan:
>>explain options 'f' s1;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
14 . 15 root 5.87E+004
13 . 14 esp_exchange 1:8(hash2) 5.87E+004
12 . 13 hash_partial_groupby 5.87E+004
11 . 12 esp_exchange 8(hash2):8(hash2) 5.87E+004
10 . 11 hash_partial_groupby 5.87E+004
5 9 10 nested_join 5.87E+004
6 8 9 nested_join 7.63E+000
7 . 8 probe_cache 3.76E-001
. . 7 trafodion_scan BACKLOG_ITEM 3.76E-001
. . 6 trafodion_index_scan BACKLOG_ITEM 2.02E+001
2 4 5 nested_join 7.69E+003
3 . 4 probe_cache 3.33E-002
. . 3 trafodion_scan BACKLOG_HDR 3.33E-002
1 . 2 esp_exchange 8(hash2):1 1.58E+005
. . 1 trafodion_index_scan BACKLOG_HDR 1.58E+005
Plan details:
ESP_EXCHANGE ============================== SEQ_NO 2 ONLY CHILD 1
REQUESTS_IN .............. (not found)
ROWS_OUT ........... 158,901
EST_OPER_COST .... 1,117,526.12
EST_TOTAL_COST ... 8,816,918
DESCRIPTION
max_card_est ..... 231,072
fragment_id ............ 4
parent_frag ............ 3
fragment_type .......... esp
est_memory_per_cpu ..... 26 KB
buffer_size ....... 11,917
record_length ......... 60
parent_processes ....... 8
child_processes ........ 1
parent_partitioning_fun hash2 partitioned 8 ways on (randomNum)
seamonster_query ....... no
seamonster_exchange .... no
partitioning_expression (HashDistPartHash(cast(randomNum)) Hash2Distrib
scaledNumParts)
TRAFODION_INDEX_SCAN ====================== SEQ_NO 1 NO CHILDREN
TABLE_NAME ............... BACKLOG_HDR
REQUESTS_IN .............. (not found)
ROWS_OUT ........... 158,901
EST_OPER_COST .... 7,699,392
EST_TOTAL_COST ... 7,699,392
DESCRIPTION
max_card_est ..... 231,072
fragment_id ............ 4
parent_frag ............ 3
fragment_type .......... esp
scan_type .............. subset scan limited by mdam of index
TRAFODION.OSSDBA.TEST2(TRAFODION.OSSDBA.BACKLOG_HD
R)
object_type ............ Trafodion
cache_size ........ 10,000
probes ................. 1
rows_accessed .... 158,901
key_columns ............ TRAFODION.OSSDBA.TEST2.OM_SYSTEM,
TRAFODION.OSSDBA.TEST2.ORDER_TYPE_DESCR,
TRAFODION.OSSDBA.TEST2.ORDER_LOAD_DATE,
TRAFODION.OSSDBA.TEST2._SALT_,
TRAFODION.OSSDBA.TEST2.LEGACY_ORDER_NO
mdam_disjunct .......... (TRAFODION.OSSDBA.TEST2.ORDER_TYPE_DESCR = %('Trade
Order')) and (TRAFODION.OSSDBA.TEST2.ORDER_LOAD_DA
TE >= 2014-04-01 00:00:00) and
(TRAFODION.OSSDBA.TEST2.ORDER_LOAD_DATE <=
2014-07-31 00:00:00)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)