Repository: trafodion
Updated Branches:
  refs/heads/master 6ca1d0f14 -> 7984e6901


Fix for regression failure for hive/TEST017


Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/8b7593ca
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/8b7593ca
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/8b7593ca

Branch: refs/heads/master
Commit: 8b7593ca0bde1601381d4c8b116f51b86e0dbf85
Parents: 6ca1d0f
Author: Sandhya Sundaresan <sand...@apache.org>
Authored: Mon Apr 9 01:53:55 2018 +0000
Committer: Sandhya Sundaresan <sand...@apache.org>
Committed: Mon Apr 9 02:09:53 2018 +0000

----------------------------------------------------------------------
 core/sql/regress/hive/EXPECTED017 | 15 ++++++++++++---
 core/sql/regress/hive/TEST017     |  7 ++++---
 2 files changed, 16 insertions(+), 6 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/trafodion/blob/8b7593ca/core/sql/regress/hive/EXPECTED017
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED017 
b/core/sql/regress/hive/EXPECTED017
index c32b437..2123cb3 100644
--- a/core/sql/regress/hive/EXPECTED017
+++ b/core/sql/regress/hive/EXPECTED017
@@ -826,7 +826,9 @@ B@           B            C            (EXPR)
 >>create index T017TTCIDXb on T017TTC (b) HBASE_OPTIONS (DATA_BLOCK_ENCODING = 
 >>'FAST_DIFF', COMPRESSION = 'GZ') SALT LIKE TABLE;
 
 --- SQL operation complete.
->>
+>>cqd traf_reload_natable_cache 'ON';
+
+--- SQL operation complete.
 >>select * from table (index_table T017TTCIDXb) order by "_SALT_@","B@","A";
 
 _SALT_@     B@           A          
@@ -960,7 +962,9 @@ LC   RC   OP   OPERATOR              OPT       DESCRIPTION  
         CARD
 .    .    1    trafodion_index_scan            T017TTCIDXB           1.00E+002
 
 --- SQL operation complete.
->>
+>>cqd traf_reload_natable_cache reset;
+
+--- SQL operation complete.
 >>
 >>drop  index T017TTCIDXb;
 
@@ -969,7 +973,9 @@ LC   RC   OP   OPERATOR              OPT       DESCRIPTION  
         CARD
 >>create index T017TTCIDXb on T017TTC (b);
 
 --- SQL operation complete.
->>
+>>cqd traf_reload_natable_cache 'ON';
+
+--- SQL operation complete.
 >>select * from table (index_table T017TTCIDXb) order by "B@","_SALT_","A";
 
 B@           _SALT_      A          
@@ -1101,6 +1107,9 @@ LC   RC   OP   OPERATOR              OPT       
DESCRIPTION           CARD
 .    .    1    trafodion_index_scan            T017TTCIDXB           1.00E+002
 
 --- SQL operation complete.
+>>cqd traf_reload_natable_cache reset;
+
+--- SQL operation complete.
 >>
 >>
 >>

http://git-wip-us.apache.org/repos/asf/trafodion/blob/8b7593ca/core/sql/regress/hive/TEST017
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/TEST017 b/core/sql/regress/hive/TEST017
index 1c23926..f98c170 100644
--- a/core/sql/regress/hive/TEST017
+++ b/core/sql/regress/hive/TEST017
@@ -227,22 +227,23 @@ select count(*) from table(index_table a5iraey10);
 drop  index T017TTCIDXb;
 
 create index T017TTCIDXb on T017TTC (b) HBASE_OPTIONS (DATA_BLOCK_ENCODING = 
'FAST_DIFF', COMPRESSION = 'GZ') SALT LIKE TABLE;
-
+cqd traf_reload_natable_cache 'ON';
 select * from table (index_table T017TTCIDXb) order by "_SALT_@","B@","A";
 
 explain options 'f' Load transform into table(index_table  T017TTCIDXb ) 
select "_SALT_","B","A" from T017TTC for read uncommitted access;
 
 explain options 'f' Load transform into table(index_table  T017TTCIDXb ) 
select "_SALT_","B","A" from T017TTC <<+ cardinality 10e1 >> for read 
uncommitted access;
-
+cqd traf_reload_natable_cache reset;
 
 drop  index T017TTCIDXb;
 
 create index T017TTCIDXb on T017TTC (b);
-
+cqd traf_reload_natable_cache 'ON';
 select * from table (index_table T017TTCIDXb) order by "B@","_SALT_","A";
 
 explain options 'f' Load transform into table(index_table  T017TTCIDXb ) 
select "B","_SALT_","A" from T017TTC for read uncommitted access;
 
 explain options 'f' Load transform into table(index_table  T017TTCIDXb ) 
select "B","_SALT_","A" from T017TTC <<+ cardinality 10e1 >> for read 
uncommitted access;
+cqd traf_reload_natable_cache reset;
 
 

Reply via email to