You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2020/05/03 17:16:37 UTC

[hive] branch master updated: HIVE-23321 : Tolerate in tests that metastore is not removing rows from the skewed_string_list_values table (Zoltan Haindrich via Ashutosh Chauhan)

This is an automated email from the ASF dual-hosted git repository.

hashutosh pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hive.git


The following commit(s) were added to refs/heads/master by this push:
     new b283bbd  HIVE-23321 : Tolerate in tests that metastore is not removing rows from the skewed_string_list_values table (Zoltan Haindrich via Ashutosh Chauhan)
b283bbd is described below

commit b283bbda0aa93f10e3a4418bef2534cbb510b5e5
Author: Zoltan Haindrich <ki...@rxd.hu>
AuthorDate: Sun May 3 10:15:58 2020 -0700

    HIVE-23321 : Tolerate in tests that metastore is not removing rows from the skewed_string_list_values table (Zoltan Haindrich via Ashutosh Chauhan)
    
    Signed-off-by: Ashutosh Chauhan <ha...@apache.org>
---
 ql/src/test/queries/clientpositive/sysdb.q          |  5 +++--
 ql/src/test/results/clientpositive/llap/sysdb.q.out | 10 ++++------
 2 files changed, 7 insertions(+), 8 deletions(-)

diff --git a/ql/src/test/queries/clientpositive/sysdb.q b/ql/src/test/queries/clientpositive/sysdb.q
index 2463ce6..c2201a9 100644
--- a/ql/src/test/queries/clientpositive/sysdb.q
+++ b/ql/src/test/queries/clientpositive/sysdb.q
@@ -81,9 +81,10 @@ select skewed_col_name from skewed_col_names order by skewed_col_name limit 5;
 
 select count(*) from skewed_col_value_loc_map;
 
-select count(*) from skewed_string_list;
+-- HIVE-23289: there are fallout in these tables from previous tests
+select * from skewed_string_list limit 0;
 
-select count(*) from skewed_string_list_values;
+select * from skewed_string_list_values limit 0;
 
 select count(*) from skewed_values;
 
diff --git a/ql/src/test/results/clientpositive/llap/sysdb.q.out b/ql/src/test/results/clientpositive/llap/sysdb.q.out
index 619c0d2..bffbedb 100644
--- a/ql/src/test/results/clientpositive/llap/sysdb.q.out
+++ b/ql/src/test/results/clientpositive/llap/sysdb.q.out
@@ -1228,24 +1228,22 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: sys@skewed_col_value_loc_map
 #### A masked pattern was here ####
 0
-PREHOOK: query: select count(*) from skewed_string_list
+PREHOOK: query: select * from skewed_string_list limit 0
 PREHOOK: type: QUERY
 PREHOOK: Input: sys@skewed_string_list
 #### A masked pattern was here ####
-POSTHOOK: query: select count(*) from skewed_string_list
+POSTHOOK: query: select * from skewed_string_list limit 0
 POSTHOOK: type: QUERY
 POSTHOOK: Input: sys@skewed_string_list
 #### A masked pattern was here ####
-3
-PREHOOK: query: select count(*) from skewed_string_list_values
+PREHOOK: query: select * from skewed_string_list_values limit 0
 PREHOOK: type: QUERY
 PREHOOK: Input: sys@skewed_string_list_values
 #### A masked pattern was here ####
-POSTHOOK: query: select count(*) from skewed_string_list_values
+POSTHOOK: query: select * from skewed_string_list_values limit 0
 POSTHOOK: type: QUERY
 POSTHOOK: Input: sys@skewed_string_list_values
 #### A masked pattern was here ####
-3
 PREHOOK: query: select count(*) from skewed_values
 PREHOOK: type: QUERY
 PREHOOK: Input: sys@skewed_values