http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b1498748/core/sql/regress/seabase/EXPECTED010 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED010 b/core/sql/regress/seabase/EXPECTED010 index d0662c3..a708caf 100644 --- a/core/sql/regress/seabase/EXPECTED010 +++ b/core/sql/regress/seabase/EXPECTED010 @@ -58,7 +58,7 @@ >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Thu Oct 19 22:12:21 2017 +-- Definition current Wed Dec 6 19:32:34 2017 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -71,7 +71,7 @@ >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Thu Oct 19 22:12:22 2017 +-- Definition current Wed Dec 6 19:32:35 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -90,7 +90,7 @@ >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Thu Oct 19 22:12:23 2017 +-- Definition current Wed Dec 6 19:32:36 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -221,7 +221,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211145371059 +PLAN_ID .................. 212379348758015068 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -263,7 +263,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333366849 + ObjectUIDs ............. 4521198292213504056 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -304,7 +304,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211145466061 +PLAN_ID .................. 212379348758110922 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -347,7 +347,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333366849 + ObjectUIDs ............. 4521198292213504056 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -387,7 +387,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211145557099 +PLAN_ID .................. 212379348758213608 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -429,7 +429,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333366849 + ObjectUIDs ............. 4521198292213504056 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -470,7 +470,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211144533319 +PLAN_ID .................. 212379348757142617 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -513,7 +513,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333366849 + ObjectUIDs ............. 4521198292213504056 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -815,7 +815,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212375211146540988 +PLAN_ID .................. 212379348759127331 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.08 STATEMENT ................ select * @@ -860,7 +860,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333367240 + ObjectUIDs ............. 4521198292213504650 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -894,7 +894,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212375211146661132 +PLAN_ID .................. 212379348759215586 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.11 STATEMENT ................ select * @@ -940,7 +940,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333367240 + ObjectUIDs ............. 4521198292213504650 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -975,7 +975,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212375211146790052 +PLAN_ID .................. 212379348759313359 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.11 STATEMENT ................ select * @@ -1020,7 +1020,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333367240 + ObjectUIDs ............. 4521198292213504650 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1055,7 +1055,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212375211146953887 +PLAN_ID .................. 212379348759473659 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.11 STATEMENT ................ delete from t010t2 @@ -1100,7 +1100,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333367240 + ObjectUIDs ............. 4521198292213504650 input_variables ........ %('a') @@ -1163,22 +1163,21 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212375211147208609 +PLAN_ID .................. 212379348759814355 ROWS_OUT ................. 2 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.06 STATEMENT ................ update t010t2 set d='upd' where a=4 and b in ('a', 'b') and c < 2; ------------------------------------------------------------------ NODE LISTING -ROOT ====================================== SEQ_NO 2 ONLY CHILD 1 +ROOT ====================================== SEQ_NO 4 ONLY CHILD 3 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.06 DESCRIPTION - olt_optimization ....... used est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB max_card_est ........... 2 fragment_id ............ 0 @@ -1209,26 +1208,64 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333367240 + ObjectUIDs ............. 4521198292213504650 input_variables ........ %('upd'), %(4) -TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN -TABLE_NAME ............... TRAFODION.SCH.T010T2 +TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 -EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.06 DESCRIPTION max_card_est ........... 2 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master - iud_type ............... trafodion_update TRAFODION.SCH.T010T2 + join_type .............. inner + join_method ............ in-order nested + + +TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN +TABLE_NAME ............... TRAFODION.SCH.T010T2 +REQUESTS_IN .............. 2 +ROWS/REQUEST ............. 1 +EST_OPER_COST ............ 0.06 +EST_TOTAL_COST ........... 0.06 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2 new_rec_expr ........... (D assign %('upd')) - predicate .............. (C < 2) and ((B = 'a') or (B = 'b')) - begin_key .............. (A = %(4)) and (B = '<min>') and (C = <min>) - end_key ................ (A = %(4)) and (B = '<max>') and (C = 2) + begin_key .............. (A = %(4)) and (B = B) and (C = C) + end_key ................ (A = %(4)) and (B = B) and (C = C) + + +TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN +TABLE_NAME ............... T010T2 +REQUESTS_IN .............. 1 +ROWS_OUT ................. 2 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + scan_type .............. subset scan of table TRAFODION.SCH.T010T2 + object_type ............ Trafodion + cache_size ........... 100 + cache_blocks ........... ON + small_scanner .......... ON + probes ................. 1 + rows_accessed ......... 10 + column_retrieved ....... #1:1,#1:2,#1:3 + key_columns ............ A, B, C + executor_predicates .... (C < 2) and (A = %(4)) and ((B = 'a') or (B = 'b')) + begin_key .............. (A = %(4)), (B = '<min>'), (C = <min>) + end_key ................ (A = %(4)), (B = '<max>'), (C = 2) --- SQL operation complete. >>explain y1; @@ -1236,7 +1273,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212375211147325266 +PLAN_ID .................. 212379348759940311 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.08 STATEMENT ................ select * @@ -1282,7 +1319,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333367240 + ObjectUIDs ............. 4521198292213504650 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -1316,7 +1353,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212375211147405399 +PLAN_ID .................. 212379348760022181 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.11 STATEMENT ................ select * @@ -1363,7 +1400,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333367240 + ObjectUIDs ............. 4521198292213504650 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1398,7 +1435,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212375211147531882 +PLAN_ID .................. 212379348760123492 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.11 STATEMENT ................ select * @@ -1444,7 +1481,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333367240 + ObjectUIDs ............. 4521198292213504650 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1479,7 +1516,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212375211147688049 +PLAN_ID .................. 212379348760263677 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.11 STATEMENT ................ delete from t010t2 @@ -1525,7 +1562,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333367240 + ObjectUIDs ............. 4521198292213504650 input_variables ........ %('a') @@ -1588,22 +1625,21 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212375211147942334 +PLAN_ID .................. 212379348760498788 ROWS_OUT ................. 2 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.06 STATEMENT ................ update t010t2 set d='uuu' where a=4 and b in ('a', 'b') and c < 2; ------------------------------------------------------------------ NODE LISTING -ROOT ====================================== SEQ_NO 2 ONLY CHILD 1 +ROOT ====================================== SEQ_NO 4 ONLY CHILD 3 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.06 DESCRIPTION - olt_optimization ....... used est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB max_card_est ........... 2 fragment_id ............ 0 @@ -1635,26 +1671,64 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333367240 + ObjectUIDs ............. 4521198292213504650 input_variables ........ %('uuu'), %(4) -TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN -TABLE_NAME ............... TRAFODION.SCH.T010T2 +TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 -EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.06 DESCRIPTION max_card_est ........... 2 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master - iud_type ............... trafodion_update TRAFODION.SCH.T010T2 + join_type .............. inner + join_method ............ in-order nested + + +TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN +TABLE_NAME ............... TRAFODION.SCH.T010T2 +REQUESTS_IN .............. 2 +ROWS/REQUEST ............. 1 +EST_OPER_COST ............ 0.06 +EST_TOTAL_COST ........... 0.06 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2 new_rec_expr ........... (D assign %('uuu')) - predicate .............. (C < 2) and ((B = 'a') or (B = 'b')) - begin_key .............. (A = %(4)) and (B = '<min>') and (C = <min>) - end_key ................ (A = %(4)) and (B = '<max>') and (C = 2) + begin_key .............. (A = %(4)) and (B = B) and (C = C) + end_key ................ (A = %(4)) and (B = B) and (C = C) + + +TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN +TABLE_NAME ............... T010T2 +REQUESTS_IN .............. 1 +ROWS_OUT ................. 2 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + scan_type .............. subset scan of table TRAFODION.SCH.T010T2 + object_type ............ Trafodion + cache_size ........... 100 + cache_blocks ........... ON + small_scanner .......... ON + probes ................. 1 + rows_accessed ......... 10 + column_retrieved ....... #1:1,#1:2,#1:3 + key_columns ............ A, B, C + executor_predicates .... (C < 2) and (A = %(4)) and ((B = 'a') or (B = 'b')) + begin_key .............. (A = %(4)), (B = '<min>'), (C = <min>) + end_key ................ (A = %(4)), (B = '<max>'), (C = 2) --- SQL operation complete. >> @@ -1812,7 +1886,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Thu Oct 19 22:12:54 2017 +-- Definition current Wed Dec 6 19:33:19 2017 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1825,7 +1899,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Thu Oct 19 22:12:54 2017 +-- Definition current Wed Dec 6 19:33:19 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -1844,7 +1918,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Thu Oct 19 22:12:54 2017 +-- Definition current Wed Dec 6 19:33:19 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -1975,7 +2049,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211176420764 +PLAN_ID .................. 212379348801469433 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -2017,7 +2091,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333370094 + ObjectUIDs ............. 4521198292213508833 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -2058,7 +2132,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211176519441 +PLAN_ID .................. 212379348801563832 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -2101,7 +2175,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333370094 + ObjectUIDs ............. 4521198292213508833 select_list ............ 1, '1' @@ -2140,7 +2214,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211176605130 +PLAN_ID .................. 212379348801653115 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -2182,7 +2256,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333370094 + ObjectUIDs ............. 4521198292213508833 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -2222,7 +2296,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211176696337 +PLAN_ID .................. 212379348801748346 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -2265,7 +2339,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333370094 + ObjectUIDs ............. 4521198292213508833 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -2528,7 +2602,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212375211179079242 +PLAN_ID .................. 212379348804047667 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2572,7 +2646,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333370450 + ObjectUIDs ............. 4521198292213509188 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -2607,7 +2681,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212375211179132421 +PLAN_ID .................. 212379348804095280 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2652,7 +2726,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333370450 + ObjectUIDs ............. 4521198292213509188 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -2700,7 +2774,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212375211179174633 +PLAN_ID .................. 212379348804139169 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2744,7 +2818,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333370450 + ObjectUIDs ............. 4521198292213509188 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -2783,7 +2857,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212375211179219489 +PLAN_ID .................. 212379348804180409 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -2827,7 +2901,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333370450 + ObjectUIDs ............. 4521198292213509188 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -2895,22 +2969,21 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212375211179343865 +PLAN_ID .................. 212379348804296539 ROWS_OUT ................. 2 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.01 STATEMENT ................ update t010t2 set d='upd' where a=4 and b in ('a', 'b') and c < 2; ------------------------------------------------------------------ NODE LISTING -ROOT ====================================== SEQ_NO 2 ONLY CHILD 1 +ROOT ====================================== SEQ_NO 4 ONLY CHILD 3 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.01 DESCRIPTION - olt_optimization ....... used est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB max_card_est ........... 2 fragment_id ............ 0 @@ -2941,29 +3014,67 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333370450 + ObjectUIDs ............. 4521198292213509188 -TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN -TABLE_NAME ............... TRAFODION.SCH.T010T2 +TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 -EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est ........... 2 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master - iud_type ............... trafodion_update TRAFODION.SCH.T010T2 + join_type .............. inner + join_method ............ in-order nested + + +TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN +TABLE_NAME ............... TRAFODION.SCH.T010T2 +REQUESTS_IN .............. 2 +ROWS/REQUEST ............. 1 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2 + new_rec_expr ........... (D assign 'upd') + begin_key .............. (A = 4) and (B = B) and (C = C) + end_key ................ (A = 4) and (B = B) and (C = C) + + +TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN +TABLE_NAME ............... T010T2 +REQUESTS_IN .............. 1 +ROWS_OUT ................. 2 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + scan_type .............. subset scan of table TRAFODION.SCH.T010T2 + object_type ............ Trafodion columns ................ all begin_keys(incl) ....... 4,a,-2147483648 end_keys(excl) ......... 4,a,2 columns ................ all begin_keys(incl) ....... 4,b,-2147483648 end_keys(excl) ......... 4,b,2 - new_rec_expr ........... (D assign 'upd') - predicate .............. (C < 2) + cache_size ........... 100 + cache_blocks ........... ON + small_scanner .......... ON + probes ................. 1 + rows_accessed ......... 10 + column_retrieved ....... #1:1,#1:2,#1:3 + key_columns ............ A, B, C + executor_predicates .... (A = cast(4)) --- SQL operation complete. >>explain y1; @@ -2971,7 +3082,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212375211179430092 +PLAN_ID .................. 212379348804397950 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -3016,7 +3127,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333370450 + ObjectUIDs ............. 4521198292213509188 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -3052,7 +3163,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212375211179477243 +PLAN_ID .................. 212379348804439860 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -3098,7 +3209,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333370450 + ObjectUIDs ............. 4521198292213509188 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -3135,7 +3246,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212375211179524021 +PLAN_ID .................. 212379348804483567 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -3180,7 +3291,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333370450 + ObjectUIDs ............. 4521198292213509188 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -3217,7 +3328,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212375211179568701 +PLAN_ID .................. 212379348804530956 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -3262,7 +3373,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333370450 + ObjectUIDs ............. 4521198292213509188 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -3327,22 +3438,21 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212375211179667464 +PLAN_ID .................. 212379348804641427 ROWS_OUT ................. 2 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.01 STATEMENT ................ update t010t2 set d='uuu' where a=4 and b in ('a', 'b') and c < 2; ------------------------------------------------------------------ NODE LISTING -ROOT ====================================== SEQ_NO 2 ONLY CHILD 1 +ROOT ====================================== SEQ_NO 4 ONLY CHILD 3 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.01 DESCRIPTION - olt_optimization ....... used est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB max_card_est ........... 2 fragment_id ............ 0 @@ -3374,26 +3484,65 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333370450 + ObjectUIDs ............. 4521198292213509188 -TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN -TABLE_NAME ............... TRAFODION.SCH.T010T2 +TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 -EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est ........... 2 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master - iud_type ............... trafodion_update TRAFODION.SCH.T010T2 + join_type .............. inner + join_method ............ in-order nested + + +TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN +TABLE_NAME ............... TRAFODION.SCH.T010T2 +REQUESTS_IN .............. 2 +ROWS/REQUEST ............. 1 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2 + new_rec_expr ........... (D assign 'uuu') + begin_key .............. (A = 4) and (B = B) and (C = C) + end_key ................ (A = 4) and (B = B) and (C = C) + + +TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN +TABLE_NAME ............... T010T2 +REQUESTS_IN .............. 1 +ROWS_OUT ................. 2 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + scan_type .............. subset scan of table TRAFODION.SCH.T010T2 + object_type ............ Trafodion columns ................ all begin_keys(incl) ....... 4,,-2147483648 end_keys(incl) ......... 4,??????????,2 - new_rec_expr ........... (D assign 'uuu') - predicate .............. ((B = 'a') or (B = 'b')) and (C < 2) + cache_size ........... 100 + cache_blocks ........... ON + small_scanner .......... ON + probes ................. 1 + rows_accessed ......... 10 + column_retrieved ....... #1:1,#1:2,#1:3 + key_columns ............ A, B, C + executor_predicates .... (A = cast(4)) and ((B = 'a') or (B = 'b')) and (C < + 2) --- SQL operation complete. >> @@ -3551,7 +3700,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Thu Oct 19 22:13:32 2017 +-- Definition current Wed Dec 6 19:33:54 2017 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -3564,7 +3713,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Thu Oct 19 22:13:32 2017 +-- Definition current Wed Dec 6 19:33:54 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -3583,7 +3732,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Thu Oct 19 22:13:32 2017 +-- Definition current Wed Dec 6 19:33:55 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -3714,7 +3863,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211214603886 +PLAN_ID .................. 212379348836829518 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -3756,7 +3905,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333373856 + ObjectUIDs ............. 4521198292213512245 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -3797,7 +3946,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211214727858 +PLAN_ID .................. 212379348836914056 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -3840,7 +3989,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333373856 + ObjectUIDs ............. 4521198292213512245 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -3880,7 +4029,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211214827240 +PLAN_ID .................. 212379348837015437 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -3922,7 +4071,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333373856 + ObjectUIDs ............. 4521198292213512245 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -3963,7 +4112,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211213767413 +PLAN_ID .................. 212379348836007827 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -4006,7 +4155,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333373856 + ObjectUIDs ............. 4521198292213512245 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -4270,7 +4419,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212375211217409963 +PLAN_ID .................. 212379348839526111 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4314,7 +4463,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333374241 + ObjectUIDs ............. 4521198292213512695 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -4350,7 +4499,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212375211217459964 +PLAN_ID .................. 212379348839573995 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4395,7 +4544,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333374241 + ObjectUIDs ............. 4521198292213512695 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4432,7 +4581,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212375211217505716 +PLAN_ID .................. 212379348839649101 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4476,7 +4625,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333374241 + ObjectUIDs ............. 4521198292213512695 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4513,7 +4662,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212375211217557562 +PLAN_ID .................. 212379348839729420 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -4557,7 +4706,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333374241 + ObjectUIDs ............. 4521198292213512695 input_variables ........ %('a') @@ -4622,22 +4771,21 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212375211217660993 +PLAN_ID .................. 212379348839892863 ROWS_OUT ................. 2 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.06 STATEMENT ................ update t010t2 set d='upd' where a=4 and b in ('a', 'b') and c < 2; ------------------------------------------------------------------ NODE LISTING -ROOT ====================================== SEQ_NO 2 ONLY CHILD 1 +ROOT ====================================== SEQ_NO 4 ONLY CHILD 3 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.06 DESCRIPTION - olt_optimization ....... used est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB max_card_est ........... 2 fragment_id ............ 0 @@ -4668,26 +4816,64 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5140439103333374241 + ObjectUIDs ............. 4521198292213512695 input_variables ........ %('upd'), %(4) -TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN -TABLE_NAME ............... TRAFODION.SCH.T010T2 +TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 -EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.06 DESCRIPTION max_card_est ........... 2 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master - iud_type ............... trafodion_update TRAFODION.SCH.T010T2 + join_type .............. inner + join_method ............ in-order nested + + +TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN +TABLE_NAME ............... TRAFODION.SCH.T010T2 +REQUESTS_IN .............. 2 +ROWS/REQUEST ............. 1 +EST_OPER_COST ............ 0.06 +EST_TOTAL_COST ........... 0.06 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2 new_rec_expr ........... (D assign %('upd')) - predicate .............. (C < 2) and ((B = 'a') or (B = 'b')) - begin_key .............. (A = %(4)) and (B = '<min>') and (C = <min>) - end_key ................ (A = %(4)) and (B = '<max>') and (C = 2) + begin_key .............. (A = %(4)) and (B = B) and (C = C) + end_key ................ (A = %(4)) and (B = B) and (C = C) + + +TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN +TABLE_NAME ............... T010T2 +REQUESTS_IN .............. 1 +ROWS_OUT ................. 2 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + scan_type .............. subset scan of table TRAFODION.SCH.T010T2 + object_type ............ Trafodion + cache_size ........... 100 + cache_blocks ........... ON + small_scanner .......... ON + probes ................. 1 + rows_accessed ......... 10 + column_retrieved ....... #1:1,#1:2,#1:3 + key_columns ............ A, B, C + executor_predicates .... (C < 2) and (A = %(4)) and ((B = 'a') or (B = 'b')) + begin_key .............. (A = %(4)), (B = '<min>'), (C = <min>) + end_key ................ (A = %(4)), (B = '<max>'), (C = 2) --- SQL operation complete. >>explain y1; @@ -4695,7 +4881,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212375211217753803 +PLAN_ID .................. 212379348840011934 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4740,7 +4926,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333374241 + ObjectUIDs ............. 4521198292213512695 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -4776,7 +4962,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212375211217802644 +PLAN_ID .................. 212379348840057206 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4822,7 +5008,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333374241 + ObjectUIDs ............. 4521198292213512695 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4859,7 +5045,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212375211217854498 +PLAN_ID .................. 212379348840109396 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4904,7 +5090,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333374241 + ObjectUIDs ............. 4521198292213512695 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4941,7 +5127,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212375211217910650 +PLAN_ID .................. 212379348840159610 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -4986,7 +5172,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333374241 + ObjectUIDs ............. 4521198292213512695 input_variables ........ %('a') @@ -5051,22 +5237,21 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212375211218041292 +PLAN_ID .................. 212379348840301376 ROWS_OUT ................. 2 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.06 STATEMENT ................ update t010t2 set d='uuu' where a=4 and b in ('a', 'b') and c < 2; ------------------------------------------------------------------ NODE LISTING -ROOT ====================================== SEQ_NO 2 ONLY CHILD 1 +ROOT ====================================== SEQ_NO 4 ONLY CHILD 3 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.06 DESCRIPTION - olt_optimization ....... used est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB max_card_est ........... 2 fragment_id ............ 0 @@ -5098,26 +5283,64 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333374241 + ObjectUIDs ............. 4521198292213512695 input_variables ........ %('uuu'), %(4) -TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN -TABLE_NAME ............... TRAFODION.SCH.T010T2 +TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 -EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.06 DESCRIPTION max_card_est ........... 2 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master - iud_type ............... trafodion_update TRAFODION.SCH.T010T2 + join_type .............. inner + join_method ............ in-order nested + + +TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN +TABLE_NAME ............... TRAFODION.SCH.T010T2 +REQUESTS_IN .............. 2 +ROWS/REQUEST ............. 1 +EST_OPER_COST ............ 0.06 +EST_TOTAL_COST ........... 0.06 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2 new_rec_expr ........... (D assign %('uuu')) - predicate .............. (C < 2) and ((B = 'a') or (B = 'b')) - begin_key .............. (A = %(4)) and (B = '<min>') and (C = <min>) - end_key ................ (A = %(4)) and (B = '<max>') and (C = 2) + begin_key .............. (A = %(4)) and (B = B) and (C = C) + end_key ................ (A = %(4)) and (B = B) and (C = C) + + +TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN +TABLE_NAME ............... T010T2 +REQUESTS_IN .............. 1 +ROWS_OUT ................. 2 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + scan_type .............. subset scan of table TRAFODION.SCH.T010T2 + object_type ............ Trafodion + cache_size ........... 100 + cache_blocks ........... ON + small_scanner .......... ON + probes ................. 1 + rows_accessed ......... 10 + column_retrieved ....... #1:1,#1:2,#1:3 + key_columns ............ A, B, C + executor_predicates .... (C < 2) and (A = %(4)) and ((B = 'a') or (B = 'b')) + begin_key .............. (A = %(4)), (B = '<min>'), (C = <min>) + end_key ................ (A = %(4)), (B = '<max>'), (C = 2) --- SQL operation complete. >> @@ -5275,7 +5498,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Thu Oct 19 22:14:04 2017 +-- Definition current Wed Dec 6 19:34:26 2017 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -5288,7 +5511,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Thu Oct 19 22:14:04 2017 +-- Definition current Wed Dec 6 19:34:26 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -5307,7 +5530,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Thu Oct 19 22:14:04 2017 +-- Definition current Wed Dec 6 19:34:26 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -5438,7 +5661,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211246332375 +PLAN_ID .................. 212379348868257922 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -5480,7 +5703,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333377111 + ObjectUIDs ............. 4521198292213515531 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -5521,7 +5744,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211246427100 +PLAN_ID .................. 212379348868363894 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -5564,7 +5787,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333377111 + ObjectUIDs ............. 4521198292213515531 select_list ............ 1, '1' @@ -5603,7 +5826,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211246514744 +PLAN_ID .................. 212379348868464952 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -5645,7 +5868,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333377111 + ObjectUIDs ............. 4521198292213515531 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -5685,7 +5908,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211246603784 +PLAN_ID .................. 212379348868560130 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -5728,7 +5951,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333377111 + ObjectUIDs ............. 4521198292213515531 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -6029,7 +6252,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212375211248914713 +PLAN_ID .................. 212379348870927172 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.08 STATEMENT ................ select * @@ -6074,7 +6297,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333377468 + ObjectUIDs ............. 4521198292213515889 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -6107,7 +6330,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212375211248990476 +PLAN_ID .................. 212379348871007882 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.11 STATEMENT ................ select * @@ -6153,7 +6376,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333377468 + ObjectUIDs ............. 4521198292213515889 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6187,7 +6410,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212375211249093605 +PLAN_ID .................. 212379348871109051 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.11 STATEMENT ................ select * @@ -6232,7 +6455,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333377468 + ObjectUIDs ............. 4521198292213515889 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6266,7 +6489,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212375211249243720 +PLAN_ID .................. 212379348871270890 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.11 STATEMENT ................ delete from t010t2 @@ -6311,7 +6534,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333377468 + ObjectUIDs ............. 4521198292213515889 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -6373,22 +6596,21 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212375211249478019 +PLAN_ID .................. 212379348871511759 ROWS_OUT ................. 2 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.01 STATEMENT ................ update t010t2 set d='upd' where a=4 and b in ('a', 'b') and c < 2; ------------------------------------------------------------------ NODE LISTING -ROOT ====================================== SEQ_NO 2 ONLY CHILD 1 +ROOT ====================================== SEQ_NO 4 ONLY CHILD 3 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.01 DESCRIPTION - olt_optimization ....... used est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB max_card_est ........... 2 fragment_id ............ 0 @@ -6419,29 +6641,65 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333377468 + ObjectUIDs ............. 4521198292213515889 -TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN -TABLE_NAME ............... TRAFODION.SCH.T010T2 +TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 -EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est ........... 2 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master - iud_type ............... trafodion_update TRAFODION.SCH.T010T2 - columns ................ all - begin_keys(incl) ....... 4,a,-2147483648 - end_keys(excl) ......... 4,a,2 - columns ................ all - begin_keys(incl) ....... 4,b,-2147483648 - end_keys(excl) ......... 4,b,2 + join_type .............. inner + join_method ............ in-order nested + + +TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN +TABLE_NAME ............... TRAFODION.SCH.T010T2 +REQUESTS_IN .............. 2 +ROWS/REQUEST ............. 1 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2 new_rec_expr ........... (D assign 'upd') - predicate .............. (C < 2) + begin_key .............. (A = 4) and (B = B) and (C = C) + end_key ................ (A = 4) and (B = B) and (C = C) + + +TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN +TABLE_NAME ............... T010T2 +REQUESTS_IN .............. 1 +ROWS_OUT ................. 2 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + scan_type .............. subset scan of table TRAFODION.SCH.T010T2 + object_type ............ Trafodion + columns ................ all + begin_keys(incl) ....... 4,,-2147483648 + end_keys(incl) ......... 4,??????????,2 + cache_size ........... 100 + cache_blocks ........... ON + small_scanner .......... ON + probes ................. 1 + rows_accessed ......... 10 + column_retrieved ....... #1:1,#1:2,#1:3 + key_columns ............ A, B, C + executor_predicates .... ((B = 'a') or (B = 'b')) and (C < 2) and (A = + cast(4)) --- SQL operation complete. >>explain y1; @@ -6449,7 +6707,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212375211249603770 +PLAN_ID .................. 212379348871620240 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.08 STATEMENT ................ select * @@ -6495,7 +6753,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333377468 + ObjectUIDs ............. 4521198292213515889 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -6528,7 +6786,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212375211249685191 +PLAN_ID .................. 212379348871688832 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.11 STATEMENT ................ select * @@ -6575,7 +6833,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333377468 + ObjectUIDs ............. 4521198292213515889 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6609,7 +6867,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212375211249786072 +PLAN_ID .................. 212379348871785317 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.11 STATEMENT ................ select * @@ -6655,7 +6913,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333377468 + ObjectUIDs ............. 4521198292213515889 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6689,7 +6947,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212375211249940535 +PLAN_ID .................. 212379348871935257 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.11 STATEMENT ................ delete from t010t2 @@ -6735,7 +6993,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333377468 + ObjectUIDs ............. 4521198292213515889 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -6797,22 +7055,21 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212375211250156714 +PLAN_ID .................. 212379348872142593 ROWS_OUT ................. 2 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.01 STATEMENT ................ update t010t2 set d='uuu' where a=4 and b in ('a', 'b') and c < 2; ------------------------------------------------------------------ NODE LISTING -ROOT ====================================== SEQ_NO 2 ONLY CHILD 1 +ROOT ====================================== SEQ_NO 4 ONLY CHILD 3 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.01 DESCRIPTION - olt_optimization ....... used est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB max_card_est ........... 2 fragment_id ............ 0 @@ -6844,26 +7101,65 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333377468 + ObjectUIDs ............. 4521198292213515889 -TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN -TABLE_NAME ............... TRAFODION.SCH.T010T2 +TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 -EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est ........... 2 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master - iud_type ............... trafodion_update TRAFODION.SCH.T010T2 + join_type .............. inner + join_method ............ in-order nested + + +TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN +TABLE_NAME ............... TRAFODION.SCH.T010T2 +REQUESTS_IN .............. 2 +ROWS/REQUEST ............. 1 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2 + new_rec_expr ........... (D assign 'uuu') + begin_key .............. (A = 4) and (B = B) and (C = C) + end_key ................ (A = 4) and (B = B) and (C = C) + + +TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN +TABLE_NAME ............... T010T2 +REQUESTS_IN .............. 1 +ROWS_OUT ................. 2 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + scan_type .............. subset scan of table TRAFODION.SCH.T010T2 + object_type ............ Trafodion columns ................ all begin_keys(incl) ....... 4,,-2147483648 end_keys(incl) ......... 4,??????????,2 - new_rec_expr ........... (D assign 'uuu') - predicate .............. ((B = 'a') or (B = 'b')) and (C < 2) + cache_size ........... 100 + cache_blocks ........... ON + small_scanner .......... ON + probes ................. 1 + rows_accessed ......... 10 + column_retrieved ....... #1:1,#1:2,#1:3 + key_columns ............ A, B, C + executor_predicates .... ((B = 'a') or (B = 'b')) and (C < 2) and (A = + cast(4)) --- SQL operation complete. >> @@ -7044,7 +7340,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Thu Oct 19 22:14:41 2017 +-- Definition current Wed Dec 6 19:35:08 2017 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -7057,7 +7353,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Thu Oct 19 22:14:41 2017 +-- Definition current Wed Dec 6 19:35:08 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -7076,7 +7372,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Thu Oct 19 22:14:42 2017 +-- Definition current Wed Dec 6 19:35:08 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -7207,7 +7503,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211283939586 +PLAN_ID .................. 212379348910114619 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -7249,7 +7545,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333380547 + ObjectUIDs ............. 4521198292213519441 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -7290,7 +7586,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211284071529 +PLAN_ID .................. 212379348910196043 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -7333,7 +7629,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333380547 + ObjectUIDs ............. 4521198292213519441 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -7373,7 +7669,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211284182877 +PLAN_ID .................. 212379348910294783 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -7415,7 +7711,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333380547 + ObjectUIDs ............. 4521198292213519441 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -7456,7 +7752,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212375211283074993 +PLAN_ID .................. 212379348909321835 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -7499,7 +7795,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333380547 + ObjectUIDs ............. 4521198292213519441 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -7801,7 +8097,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212375211286758015 +PLAN_ID .................. 212379348912742892 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.08 STATEMENT ................ select * @@ -7846,7 +8142,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333380976 + ObjectUIDs ............. 4521198292213519805 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -7880,7 +8176,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212375211286838992 +PLAN_ID .................. 212379348912824948 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.11 STATEMENT ................ select * @@ -7926,7 +8222,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333380976 + ObjectUIDs ............. 4521198292213519805 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -7961,7 +8257,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212375211286932222 +PLAN_ID .................. 212379348912933016 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.11 STATEMENT ................ select * @@ -8006,7 +8302,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333380976 + ObjectUIDs ............. 4521198292213519805 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -8041,7 +8337,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212375211287075899 +PLAN_ID .................. 212379348913060022 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.11 STATEMENT ................ delete from t010t2 @@ -8086,7 +8382,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333380976 + ObjectUIDs ............. 4521198292213519805 input_variables ........ %('a') @@ -8149,22 +8445,21 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212375211287292325 +PLAN_ID .................. 212379348913273694 ROWS_OUT ................. 2 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.06 STATEMENT ................ update t010t2 set d='upd' where a=4 and b in ('a', 'b') and c < 2; ------------------------------------------------------------------ NODE LISTING -ROOT ====================================== SEQ_NO 2 ONLY CHILD 1 +ROOT ====================================== SEQ_NO 4 ONLY CHILD 3 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.06 DESCRIPTION - olt_optimization ....... used est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB max_card_est ........... 2 fragment_id ............ 0 @@ -8195,26 +8490,64 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5140439103333380976 + ObjectUIDs ............. 4521198292213519805 input_variables ........ %('upd'), %(4) -TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN -TABLE_NAME ............... TRAFODION.SCH.T010T2 +TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 -EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.06 DESCRIPTION max_card_est ........... 2 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master + join_type .............. inner + join_method ............ in-order nested + + +TRAFODION_UPDATE ========================== SEQ_NO 2 NO CHILDREN +TABLE_NAME ............... TRAFODION.SCH.T010T2 +REQUESTS_IN .............. 2 +ROWS/REQUEST ............. 1 +EST_OPER_COST ............ 0.06 +EST_TOTAL_COST ........... 0.06 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master iud_type ............... trafodion_update TRAFODION.SCH.T010T2 new_rec_expr ........... (D assign %('upd')) - predicate .............. (C < 2) and ((B = 'a') or (B = 'b')) - begin_key .............. (A = %(4)) and (B = '<min>') and (C = <min>) - end_key ................ (A = %(4)) and (B = '<max>') and (C = 2) + begin_key .............. (A = %(4)) and (B = B) and (C = C) + end_key ................ (A = %(4)) and (B = B) and (C = C) + + +TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN +TABLE_NAME ............... T010T2 +REQUESTS_IN .............. 1 +ROWS_OUT ................. 2 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + scan_type .............. subset scan of table TRAFODION.SCH.T010T2 + object_type ............ Trafodion + cache_size ........... 100 + cache_blocks ........... ON + small_scanner .......... ON + probes ................. 1 + rows_accessed ......... 10 + column_retrieved ....... #1:1 + key_columns ............ A, B, C + executor_predicates .... (C < 2) and (A = %(4)) and ((B = 'a') or (B = 'b')) + begin_key .............. (A = %(4)), (B = '<min>'), (C = <min>) + end_key ................ (A = %(4)), (B = '<max>'), (C = 2) --- SQL operation complete. >>explain y1; @@ -8222,7 +8555,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212375211287404754 +PLAN_ID .................. 212379348913400087 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.08 STATEMENT ................ select * @@ -8268,7 +8601,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333380976 + ObjectUIDs ............. 4521198292213519805 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -8302,7 +8635,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212375211287492474 +PLAN_ID .................. 212379348913480479 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.11 STATEMENT ................ select * @@ -8349,7 +8682,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333380976 + ObjectUIDs ............. 4521198292213519805 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -8384,7 +8717,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212375211287598527 +PLAN_ID .................. 212379348913571313 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.11 STATEMENT ................ select * @@ -8430,7 +8763,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333380976 + ObjectUIDs ............. 4521198292213519805 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -8465,7 +8798,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212375211287756111 +PLAN_ID .................. 212379348913717936 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.11 STATEMENT ................ delete from t010t2 @@ -8511,7 +8844,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333380976 + ObjectUIDs ............. 4521198292213519805 input_variables ........ %('a') @@ -8574,22 +8907,21 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212375211287956918 +PLAN_ID .................. 212379348913944078 ROWS_OUT ................. 2 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.06 STATEMENT ................ update t010t2 set d='uuu' where a=4 and b in ('a', 'b') and c < 2; ------------------------------------------------------------------ NODE LISTING -ROOT ====================================== SEQ_NO 2 ONLY CHILD 1 +ROOT ====================================== SEQ_NO 4 ONLY CHILD 3 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_TOTAL_COST ........... 0.06 DESCRIPTION - olt_optimization ....... used est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB max_card_est ........... 2 fragment_id ............ 0 @@ -8621,26 +8953,64 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5140439103333380976 + ObjectUIDs ............. 4521198292213519805 input_variables ........ %('uuu'), %(4) -TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN -TABLE_NAME ............... TRAFODION.SCH.T010T2 +TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 REQUESTS_IN .............. 1 ROWS_OUT ................. 2 -EST_OPER_COST ............ 0 -EST_TOTAL_COST ........... 0 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.06 DESCRIPTION max_card_est ........... 2 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master + join_type .............. inner + join_method ............ in-order nested + + +TRAFODION_UPDATE ========================== SEQ_NO 2 NO CHILDREN +TABLE_NAME ............... TRAFODION.SCH.T010T2 +REQUESTS_IN .............. 2 +ROWS/REQUEST ............. 1 +EST_OPER_COST ............ 0.06 +EST_TOTAL_COST ........... 0.06 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master iud_type ............... trafodion_update TRAFODION.SCH.T010T2 new_rec_expr ........... (D assign %('uuu')) - predicate .............. (C < 2) and ((B = 'a') or (B = 'b')) - begin_key .............. (A = %(4)) and (B = '<min>') and (C = <min>) - end_key ................ (A = %(4)) and (B = '<max>') and (C = 2) + begin_key .............. (A = %(4)) and (B = B) and (C = C) + end_key ................ (A = %(4)) and (B = B) and (C = C) + + +TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN +TABLE_NAME ............... T010T2 +REQUESTS_IN .............. 1 +ROWS_OUT ................. 2 +EST_OPER_COST ............ 0.01 +EST_TOTAL_COST ........... 0.01 +DESCRIPTION + max_card_est .......... 50 + fragment_id ............ 0 + parent_frag ............ (none) + fragment_type .......... master + scan_type .............. subset scan of table TRAFODION.SCH.T010T2 + object_type ............ Trafodion + cache_size ........... 100 + cache_blocks ........... ON + small_scanner .......... ON + probes ................. 1 + rows_accessed ......... 10 + column_retrieved ....... #1:1 + key_columns ............ A, B, C + executor_predicates .... (C < 2) and (A = %(4)) and ((B = 'a') or (B = 'b')) + begin_key .............. (A = %(4)), (B = '<min>'), (C = <min>) + end_key ................ (A = %(4)), (B = '<max>'), (C = 2) --- SQL operation complete. >> @@ -8798,7 +9168,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Thu Oct 19 22:15:18 2017 +-- Definition current Wed Dec 6 19:35:43 2017 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -8811,7 +9181,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Thu Oct 19 22:15:19 2017 +-- Definition current Wed Dec 6 19:35:43 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -8830,7 +9200,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Thu Oct 19 22:15:19 2017 +-- Definition current Wed Dec 6 19:35:43 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -8961,7 +9331,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD -------------------------------------------------------
<TRUNCATED>
