You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by za...@apache.org on 2021/11/05 14:28:27 UTC
[hive] branch master updated: HIVE-25591: Add ORDER BY in
jdbc_table tests to make results deterministic (addendum)
This is an automated email from the ASF dual-hosted git repository.
zabetak 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 c8c5d2b HIVE-25591: Add ORDER BY in jdbc_table tests to make results deterministic (addendum)
c8c5d2b is described below
commit c8c5d2bee7f357ab873d0f3366ae94624d9a73fe
Author: Stamatis Zampetakis <za...@gmail.com>
AuthorDate: Fri Nov 5 15:23:33 2021 +0100
HIVE-25591: Add ORDER BY in jdbc_table tests to make results deterministic (addendum)
---
ql/src/test/queries/clientpositive/jdbc_table_dml_postgres.q | 4 ++--
.../test/queries/clientpositive/jdbc_table_with_schema_oracle.q | 2 +-
.../test/queries/clientpositive/jdbc_table_with_schema_postgres.q | 2 +-
.../results/clientpositive/llap/jdbc_table_dml_postgres.q.out | 8 ++++----
.../clientpositive/llap/jdbc_table_with_schema_oracle.q.out | 4 ++--
.../clientpositive/llap/jdbc_table_with_schema_postgres.q.out | 4 ++--
6 files changed, 12 insertions(+), 12 deletions(-)
diff --git a/ql/src/test/queries/clientpositive/jdbc_table_dml_postgres.q b/ql/src/test/queries/clientpositive/jdbc_table_dml_postgres.q
index b224d06..bb0aef2 100644
--- a/ql/src/test/queries/clientpositive/jdbc_table_dml_postgres.q
+++ b/ql/src/test/queries/clientpositive/jdbc_table_dml_postgres.q
@@ -10,8 +10,8 @@ TBLPROPERTIES (
"hive.sql.dbcp.password" = "qtestpassword",
"hive.sql.table" = "country");
-SELECT * FROM country;
+SELECT * FROM country ORDER BY id;
EXPLAIN CBO INSERT INTO country VALUES (8, 'Hungary');
EXPLAIN INSERT INTO country VALUES (8, 'Hungary');
INSERT INTO country VALUES (8, 'Hungary');
-SELECT * FROM country;
+SELECT * FROM country ORDER BY id;
diff --git a/ql/src/test/queries/clientpositive/jdbc_table_with_schema_oracle.q b/ql/src/test/queries/clientpositive/jdbc_table_with_schema_oracle.q
index 805c066..17b0e36 100644
--- a/ql/src/test/queries/clientpositive/jdbc_table_with_schema_oracle.q
+++ b/ql/src/test/queries/clientpositive/jdbc_table_with_schema_oracle.q
@@ -54,4 +54,4 @@ SELECT COUNT(*) FROM country_2;
-- Test DML statements are working fine when accessing table in non-default schema
INSERT INTO country_2 VALUES (8, 'Hungary');
-SELECT * FROM country_2;
+SELECT * FROM country_2 ORDER BY id;
diff --git a/ql/src/test/queries/clientpositive/jdbc_table_with_schema_postgres.q b/ql/src/test/queries/clientpositive/jdbc_table_with_schema_postgres.q
index 17010a0..76162bd 100644
--- a/ql/src/test/queries/clientpositive/jdbc_table_with_schema_postgres.q
+++ b/ql/src/test/queries/clientpositive/jdbc_table_with_schema_postgres.q
@@ -36,7 +36,7 @@ SELECT COUNT(*) FROM country_1;
-- Test DML statements are working fine when accessing table in non-default schema
INSERT INTO country_1 VALUES (8, 'Hungary');
-SELECT * FROM country_1;
+SELECT * FROM country_1 ORDER BY id;
-- A user in Postgres can be assigned a default schema (aka. search_path). In that case specifying the
-- hive.sql.schema property is redundant.
diff --git a/ql/src/test/results/clientpositive/llap/jdbc_table_dml_postgres.q.out b/ql/src/test/results/clientpositive/llap/jdbc_table_dml_postgres.q.out
index 5628ab9..f2b380b 100644
--- a/ql/src/test/results/clientpositive/llap/jdbc_table_dml_postgres.q.out
+++ b/ql/src/test/results/clientpositive/llap/jdbc_table_dml_postgres.q.out
@@ -22,11 +22,11 @@ TBLPROPERTIES (
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@country
-PREHOOK: query: SELECT * FROM country
+PREHOOK: query: SELECT * FROM country ORDER BY id
PREHOOK: type: QUERY
PREHOOK: Input: default@country
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM country
+POSTHOOK: query: SELECT * FROM country ORDER BY id
POSTHOOK: type: QUERY
POSTHOOK: Input: default@country
#### A masked pattern was here ####
@@ -112,11 +112,11 @@ POSTHOOK: query: INSERT INTO country VALUES (8, 'Hungary')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@country
-PREHOOK: query: SELECT * FROM country
+PREHOOK: query: SELECT * FROM country ORDER BY id
PREHOOK: type: QUERY
PREHOOK: Input: default@country
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM country
+POSTHOOK: query: SELECT * FROM country ORDER BY id
POSTHOOK: type: QUERY
POSTHOOK: Input: default@country
#### A masked pattern was here ####
diff --git a/ql/src/test/results/clientpositive/llap/jdbc_table_with_schema_oracle.q.out b/ql/src/test/results/clientpositive/llap/jdbc_table_with_schema_oracle.q.out
index a980eee..fef7583 100644
--- a/ql/src/test/results/clientpositive/llap/jdbc_table_with_schema_oracle.q.out
+++ b/ql/src/test/results/clientpositive/llap/jdbc_table_with_schema_oracle.q.out
@@ -154,11 +154,11 @@ POSTHOOK: query: INSERT INTO country_2 VALUES (8, 'Hungary')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@country_2
-PREHOOK: query: SELECT * FROM country_2
+PREHOOK: query: SELECT * FROM country_2 ORDER BY id
PREHOOK: type: QUERY
PREHOOK: Input: default@country_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM country_2
+POSTHOOK: query: SELECT * FROM country_2 ORDER BY id
POSTHOOK: type: QUERY
POSTHOOK: Input: default@country_2
#### A masked pattern was here ####
diff --git a/ql/src/test/results/clientpositive/llap/jdbc_table_with_schema_postgres.q.out b/ql/src/test/results/clientpositive/llap/jdbc_table_with_schema_postgres.q.out
index 6de6607..411cb5e 100644
--- a/ql/src/test/results/clientpositive/llap/jdbc_table_with_schema_postgres.q.out
+++ b/ql/src/test/results/clientpositive/llap/jdbc_table_with_schema_postgres.q.out
@@ -102,11 +102,11 @@ POSTHOOK: query: INSERT INTO country_1 VALUES (8, 'Hungary')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@country_1
-PREHOOK: query: SELECT * FROM country_1
+PREHOOK: query: SELECT * FROM country_1 ORDER BY id
PREHOOK: type: QUERY
PREHOOK: Input: default@country_1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM country_1
+POSTHOOK: query: SELECT * FROM country_1 ORDER BY id
POSTHOOK: type: QUERY
POSTHOOK: Input: default@country_1
#### A masked pattern was here ####