You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by kr...@apache.org on 2022/01/06 08:38:00 UTC
[hive] branch master updated: HIVE-25818: Values query with order by position clause fails (Krisztian Kasa, reviewed by Zoltan Haindrich) - ADDENDUM: add test
This is an automated email from the ASF dual-hosted git repository.
krisztiankasa 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 ce7a125 HIVE-25818: Values query with order by position clause fails (Krisztian Kasa, reviewed by Zoltan Haindrich) - ADDENDUM: add test
ce7a125 is described below
commit ce7a1255a80082550f75f5798261d14a8ee84f6a
Author: Krisztian Kasa <kk...@cloudera.com>
AuthorDate: Thu Jan 6 09:37:37 2022 +0100
HIVE-25818: Values query with order by position clause fails (Krisztian Kasa, reviewed by Zoltan Haindrich) - ADDENDUM: add test
---
ql/src/test/queries/clientpositive/order_by_pos.q | 3 ++-
ql/src/test/results/clientpositive/llap/order_by_pos.q.out | 10 ++++++++++
2 files changed, 12 insertions(+), 1 deletion(-)
diff --git a/ql/src/test/queries/clientpositive/order_by_pos.q b/ql/src/test/queries/clientpositive/order_by_pos.q
index 738fbd5..4ba4a20 100644
--- a/ql/src/test/queries/clientpositive/order_by_pos.q
+++ b/ql/src/test/queries/clientpositive/order_by_pos.q
@@ -17,4 +17,5 @@ select * from t_n3 union select * from t_n3 order by 1, 2;
select * from (select a, count(a) from t_n3 group by a)subq order by 2, 1;
select * from (select a,b, count(*) from t_n3 group by a, b)subq order by 3, 2 desc, 1;
-
+
+values(1+1, 2, 5.0, 'a'), (-12, 2, 5.0, 'a'), (100, 2, 5.0, 'a') order by 1 limit 2;
diff --git a/ql/src/test/results/clientpositive/llap/order_by_pos.q.out b/ql/src/test/results/clientpositive/llap/order_by_pos.q.out
index 496e5b3..6ebb0ab 100644
--- a/ql/src/test/results/clientpositive/llap/order_by_pos.q.out
+++ b/ql/src/test/results/clientpositive/llap/order_by_pos.q.out
@@ -129,3 +129,13 @@ POSTHOOK: Input: default@t_n3
1 3 1
20 -100 1
1 2 2
+PREHOOK: query: values(1+1, 2, 5.0, 'a'), (-12, 2, 5.0, 'a'), (100, 2, 5.0, 'a') order by 1 limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: _dummy_database@_dummy_table
+#### A masked pattern was here ####
+POSTHOOK: query: values(1+1, 2, 5.0, 'a'), (-12, 2, 5.0, 'a'), (100, 2, 5.0, 'a') order by 1 limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: _dummy_database@_dummy_table
+#### A masked pattern was here ####
+-12 2 5 a
+2 2 5 a