Trafodion

  1. Bug #1274962
  2. Comment #4

Comment 4 for bug 1274962

Revision history for this message
Ravisha Neelakanthappa (ravisha-neelakanthappa) wrote : Re: EXECUTE.BATCH hangs for a long time doing updates or deletes

Fix for bug 1329965 also fixes this bug.

With 1329965 fix, the plans looks like :
TRAFODION_VSBB_SCAN ======================= SEQ_NO 3 NO CHILDREN
TABLE_NAME ............... TBL500
REQUESTS_IN ............ 100
ROWS/REQUEST ............. 1
EST_OPER_COST ............ 0.03
EST_TOTAL_COST ........... 0.03
DESCRIPTION
  max_card_est ......... 100
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  scan_type .............. subset scan of table TRAFODION.HBASE.TBL500
  key_columns ............ _SALT_, CNT
  part_key_predicates .... (CNT = (__array3 RowsetArrayScan
                             \:_sys_rowset_index4)) and ("_SALT_" =
                             (HashDistPartHash(cast((__array3 RowsetArrayScan
                             \:_sys_rowset_index4))) Hash2Distrib cast(8)))
  begin_key .............. (_SALT_ = (HashDistPartHash(cast(cast((cast((__array
                             3 RowsetArrayScan \:_sys_rowset_index4)) /
                             cast(1000000))))) Hash2Distrib cast(8))),
                             (CNT = (__array3 RowsetArrayScan
                             \:_sys_rowset_index4))
  end_key ................ (_SALT_ = (HashDistPartHash(cast((__array3
                             RowsetArrayScan \:_sys_rowset_index4)))
                             Hash2Distrib cast(8))),
                             (CNT = (__array3 RowsetArrayScan
                            \:_sys_rowset_index4))

Without 1329965 fix, we get:
TRAFODION_SCAN ============================ SEQ_NO 3 NO CHILDREN
TABLE_NAME ............... TBL500
REQUESTS_IN ............ 100
ROWS/REQUEST ............. 1
EST_OPER_COST ............ 0.2
EST_TOTAL_COST ........... 0.2
DESCRIPTION
  max_card_est ......... 100
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  scan_type .............. subset scan of table TRAFODION.HBASE.TBL500
  key_columns ............ _SALT_, CNT
  executor_predicates .... (cast((cast(CNT) * cast(1000000))) = (__array3
                             RowsetArrayScan \:_sys_rowset_index4))
  part_key_predicates .... (CNT = (__array3 RowsetArrayScan
                             \:_sys_rowset_index4))
  begin_key .............. (_SALT_ = <min>), (CNT = (__array3 RowsetArrayScan
                             \:_sys_rowset_index4))
  end_key ................ (_SALT_ = <max>), (CNT = (__array3 RowsetArrayScan
                             \:_sys_rowset_index4))

I will close this bug as duplicate of 1329965 .