You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "David Wayne Birdsall (JIRA)" <ji...@apache.org> on 2015/11/04 21:01:27 UTC
[jira] [Assigned] (TRAFODION-1585) MDAM plan is not chosen unless
NJ is turned off
[ https://issues.apache.org/jira/browse/TRAFODION-1585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wayne Birdsall reassigned TRAFODION-1585:
-----------------------------------------------
Assignee: David Wayne Birdsall
> MDAM plan is not chosen unless NJ is turned off
> -----------------------------------------------
>
> Key: TRAFODION-1585
> URL: https://issues.apache.org/jira/browse/TRAFODION-1585
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Qifan Chen
> Assignee: David Wayne Birdsall
>
> MDAM is used in scan node #8 in the following plan.
> >explain options 'f' xx;
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> ---- ---- ---- -------------------- -------- -------------------- ---------
> 15 . 16 root 1.00E+000
> 14 7 15 hybrid_hash_join 1.00E+000
> 13 . 14 hash_partial_groupby 1.00E+000
> 12 . 13 esp_exchange 1:21(hash2) 1.00E+000
> 11 . 12 sort_partial_groupby 1.00E+000
> 10 . 11 hash_groupby 6.60E+004
> 9 . 10 hash_groupby 1.35E+005
> 8 . 9 esp_exchange 21(hash2):16(hash2) 1.40E+006
> . . 8 trafodion_scan OP 1.40E+006
> 6 . 7 sort_groupby 1.00E+000
> 5 . 6 hash_partial_groupby 3.09E+001
> 4 . 5 esp_exchange 1:21(hash2) 3.09E+001
> 3 . 4 hash_partial_groupby 3.09E+001
> 2 . 3 hash_groupby 1.35E+005
> 1 . 2 esp_exchange 21(hash2):16(hash2) 1.40E+006
> . . 1 trafodion_scan OP 1.40E+006
> The same MDAM scan is absent if CQD NESTED_JOINS 'off' is not used.
> TRAFODION_SCAN ============================ SEQ_NO 8 NO CHILDREN
> TABLE_NAME ............... P
> REQUESTS_IN .............. 1
> ROWS_OUT ......... 1,401,802
> EST_OPER_COST ............ 0.21
> EST_TOTAL_COST ........... 0.21
> DESCRIPTION
> max_card_est ........... 1.4018e+06
> fragment_id ............ 5
> parent_frag ............ 4
> fragment_type .......... esp
> scan_type .............. subset scan limited by mdam of table
> OP
> object_type ............ Trafodion
> cache_size ........ 10,000
> probes ................. 1
> rows_accessed .......... 1.4018e+06
> key_columns ............ _SALT_, SITE_ID, PANEL, DWD_ID
> executor_predicates .... (PANEL = '1') and (SITE_ID = 450)
> mdam_disjunct .......... (PANEL = '1') and (SITE_ID = 450) and (_SALT_
> >= (\:_sys_HostVarLoHashPart Hash2Distrib 64)) and
> (_SALT_ <= (\:_sys_HostVarHiHashPart Hash2Distrib
> 64))
> part_key_predicates .... (PANEL = '1' = PANEL) and (SITE_ID = 450
> = SITE_ID)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)