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 <[email protected]> Authored: Mon Apr 9 01:53:55 2018 +0000 Committer: Sandhya Sundaresan <[email protected]> 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;
