You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by mg...@apache.org on 2020/04/20 09:53:54 UTC
[hive] branch master updated: HIVE-23245 Ensure result order for
partition_date.q partition_timestamp.q queries (Miklos Gergely,
reviewed by Laszlo Bodor)
This is an automated email from the ASF dual-hosted git repository.
mgergely 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 7b6bacb HIVE-23245 Ensure result order for partition_date.q partition_timestamp.q queries (Miklos Gergely, reviewed by Laszlo Bodor)
7b6bacb is described below
commit 7b6bacb3e3f9f47e7d6e702d23cf2c909842b993
Author: miklosgergely <mg...@cloudera.com>
AuthorDate: Mon Apr 20 00:22:50 2020 +0200
HIVE-23245 Ensure result order for partition_date.q partition_timestamp.q queries (Miklos Gergely, reviewed by Laszlo Bodor)
---
ql/src/test/queries/clientpositive/partition_date.q | 2 +-
ql/src/test/queries/clientpositive/partition_timestamp.q | 2 +-
ql/src/test/queries/clientpositive/temp_table_partition_date.q | 2 +-
ql/src/test/queries/clientpositive/temp_table_partition_timestamp.q | 2 +-
ql/src/test/results/clientpositive/llap/partition_date.q.out | 4 ++--
ql/src/test/results/clientpositive/llap/partition_timestamp.q.out | 4 ++--
.../test/results/clientpositive/llap/temp_table_partition_date.q.out | 4 ++--
.../results/clientpositive/llap/temp_table_partition_timestamp.q.out | 4 ++--
8 files changed, 12 insertions(+), 12 deletions(-)
diff --git a/ql/src/test/queries/clientpositive/partition_date.q b/ql/src/test/queries/clientpositive/partition_date.q
index 3d131d8..1f16d74 100644
--- a/ql/src/test/queries/clientpositive/partition_date.q
+++ b/ql/src/test/queries/clientpositive/partition_date.q
@@ -16,7 +16,7 @@ insert overwrite table partition_date_1 partition(dt='2013-08-08', region= '10')
select * from src tablesample (11 rows);
-select distinct dt from partition_date_1;
+select distinct dt from partition_date_1 order by dt;
select * from partition_date_1 where dt = '2000-01-01' and region = '2' order by key,value;
-- 15
diff --git a/ql/src/test/queries/clientpositive/partition_timestamp.q b/ql/src/test/queries/clientpositive/partition_timestamp.q
index 17c164a..55fbca1 100644
--- a/ql/src/test/queries/clientpositive/partition_timestamp.q
+++ b/ql/src/test/queries/clientpositive/partition_timestamp.q
@@ -15,7 +15,7 @@ insert overwrite table partition_timestamp_1 partition(dt='2001-01-01 02:00:00',
insert overwrite table partition_timestamp_1 partition(dt='2001-01-01 03:00:00', region= '10')
select * from src tablesample (11 rows);
-select distinct dt from partition_timestamp_1;
+select distinct dt from partition_timestamp_1 order by dt;
select * from partition_timestamp_1 where dt = '2000-01-01 01:00:00' and region = '2' order by key,value;
-- 10
diff --git a/ql/src/test/queries/clientpositive/temp_table_partition_date.q b/ql/src/test/queries/clientpositive/temp_table_partition_date.q
index 6f3fd0a..bd85039 100644
--- a/ql/src/test/queries/clientpositive/temp_table_partition_date.q
+++ b/ql/src/test/queries/clientpositive/temp_table_partition_date.q
@@ -16,7 +16,7 @@ insert overwrite table partition_date_1_temp partition(dt='2013-08-08', region=
select * from src tablesample (11 rows);
-select distinct dt from partition_date_1_temp;
+select distinct dt from partition_date_1_temp order by dt;
select * from partition_date_1_temp where dt = '2000-01-01' and region = '2' order by key,value;
-- 15
diff --git a/ql/src/test/queries/clientpositive/temp_table_partition_timestamp.q b/ql/src/test/queries/clientpositive/temp_table_partition_timestamp.q
index 09d4417..ea36e80 100644
--- a/ql/src/test/queries/clientpositive/temp_table_partition_timestamp.q
+++ b/ql/src/test/queries/clientpositive/temp_table_partition_timestamp.q
@@ -15,7 +15,7 @@ insert overwrite table partition_timestamp_1_temp partition(dt='2001-01-01 02:00
insert overwrite table partition_timestamp_1_temp partition(dt='2001-01-01 03:00:00', region= '10')
select * from src tablesample (11 rows);
-select distinct dt from partition_timestamp_1_temp;
+select distinct dt from partition_timestamp_1_temp order by dt;
select * from partition_timestamp_1_temp where dt = '2000-01-01 01:00:00' and region = '2' order by key,value;
-- 10
diff --git a/ql/src/test/results/clientpositive/llap/partition_date.q.out b/ql/src/test/results/clientpositive/llap/partition_date.q.out
index bbb8a04..caa1163 100644
--- a/ql/src/test/results/clientpositive/llap/partition_date.q.out
+++ b/ql/src/test/results/clientpositive/llap/partition_date.q.out
@@ -70,7 +70,7 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@partition_date_1@dt=2013-08-08/region=10
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select distinct dt from partition_date_1
+PREHOOK: query: select distinct dt from partition_date_1 order by dt
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_date_1
PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
@@ -79,7 +79,7 @@ PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=10
PREHOOK: Input: default@partition_date_1@dt=2013-12-10/region=2020-20-20
#### A masked pattern was here ####
-POSTHOOK: query: select distinct dt from partition_date_1
+POSTHOOK: query: select distinct dt from partition_date_1 order by dt
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_date_1
POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
diff --git a/ql/src/test/results/clientpositive/llap/partition_timestamp.q.out b/ql/src/test/results/clientpositive/llap/partition_timestamp.q.out
index a80ed2b..e716280 100644
--- a/ql/src/test/results/clientpositive/llap/partition_timestamp.q.out
+++ b/ql/src/test/results/clientpositive/llap/partition_timestamp.q.out
@@ -70,7 +70,7 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@partition_timestamp_1@dt=2001-01-01 03%3A00%3A00/region=10
POSTHOOK: Lineage: partition_timestamp_1 PARTITION(dt=2001-01-01 03:00:00,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_timestamp_1 PARTITION(dt=2001-01-01 03:00:00,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select distinct dt from partition_timestamp_1
+PREHOOK: query: select distinct dt from partition_timestamp_1 order by dt
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_timestamp_1
PREHOOK: Input: default@partition_timestamp_1@dt=2000-01-01 01%3A00%3A00/region=1
@@ -79,7 +79,7 @@ PREHOOK: Input: default@partition_timestamp_1@dt=2001-01-01 01%3A00%3A00/region=
PREHOOK: Input: default@partition_timestamp_1@dt=2001-01-01 02%3A00%3A00/region=1
PREHOOK: Input: default@partition_timestamp_1@dt=2001-01-01 03%3A00%3A00/region=10
#### A masked pattern was here ####
-POSTHOOK: query: select distinct dt from partition_timestamp_1
+POSTHOOK: query: select distinct dt from partition_timestamp_1 order by dt
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_timestamp_1
POSTHOOK: Input: default@partition_timestamp_1@dt=2000-01-01 01%3A00%3A00/region=1
diff --git a/ql/src/test/results/clientpositive/llap/temp_table_partition_date.q.out b/ql/src/test/results/clientpositive/llap/temp_table_partition_date.q.out
index ff07eb7..713f66a 100644
--- a/ql/src/test/results/clientpositive/llap/temp_table_partition_date.q.out
+++ b/ql/src/test/results/clientpositive/llap/temp_table_partition_date.q.out
@@ -70,7 +70,7 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@partition_date_1_temp@dt=2013-08-08/region=10
POSTHOOK: Lineage: partition_date_1_temp PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1_temp PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select distinct dt from partition_date_1_temp
+PREHOOK: query: select distinct dt from partition_date_1_temp order by dt
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_date_1_temp
PREHOOK: Input: default@partition_date_1_temp@dt=2000-01-01/region=1
@@ -79,7 +79,7 @@ PREHOOK: Input: default@partition_date_1_temp@dt=2013-08-08/region=1
PREHOOK: Input: default@partition_date_1_temp@dt=2013-08-08/region=10
PREHOOK: Input: default@partition_date_1_temp@dt=2013-12-10/region=2020-20-20
#### A masked pattern was here ####
-POSTHOOK: query: select distinct dt from partition_date_1_temp
+POSTHOOK: query: select distinct dt from partition_date_1_temp order by dt
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_date_1_temp
POSTHOOK: Input: default@partition_date_1_temp@dt=2000-01-01/region=1
diff --git a/ql/src/test/results/clientpositive/llap/temp_table_partition_timestamp.q.out b/ql/src/test/results/clientpositive/llap/temp_table_partition_timestamp.q.out
index 7f04b5f..6ca9192 100644
--- a/ql/src/test/results/clientpositive/llap/temp_table_partition_timestamp.q.out
+++ b/ql/src/test/results/clientpositive/llap/temp_table_partition_timestamp.q.out
@@ -70,7 +70,7 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@partition_timestamp_1_temp@dt=2001-01-01 03%3A00%3A00/region=10
POSTHOOK: Lineage: partition_timestamp_1_temp PARTITION(dt=2001-01-01 03:00:00,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_timestamp_1_temp PARTITION(dt=2001-01-01 03:00:00,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select distinct dt from partition_timestamp_1_temp
+PREHOOK: query: select distinct dt from partition_timestamp_1_temp order by dt
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_timestamp_1_temp
PREHOOK: Input: default@partition_timestamp_1_temp@dt=2000-01-01 01%3A00%3A00/region=1
@@ -79,7 +79,7 @@ PREHOOK: Input: default@partition_timestamp_1_temp@dt=2001-01-01 01%3A00%3A00/re
PREHOOK: Input: default@partition_timestamp_1_temp@dt=2001-01-01 02%3A00%3A00/region=1
PREHOOK: Input: default@partition_timestamp_1_temp@dt=2001-01-01 03%3A00%3A00/region=10
#### A masked pattern was here ####
-POSTHOOK: query: select distinct dt from partition_timestamp_1_temp
+POSTHOOK: query: select distinct dt from partition_timestamp_1_temp order by dt
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_timestamp_1_temp
POSTHOOK: Input: default@partition_timestamp_1_temp@dt=2000-01-01 01%3A00%3A00/region=1