Author: namit
Date: Sat Jan 26 18:44:37 2013
New Revision: 1438942
URL: http://svn.apache.org/viewvc?rev=1438942&view=rev
Log:
HIVE-3912 table_access_keys_stats.q fails with hadoop 0.23
(Sushanth Sownyan via namit)
Modified:
hive/trunk/ql/src/test/queries/clientpositive/table_access_keys_stats.q
hive/trunk/ql/src/test/results/clientpositive/table_access_keys_stats.q.out
Modified:
hive/trunk/ql/src/test/queries/clientpositive/table_access_keys_stats.q
URL:
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/table_access_keys_stats.q?rev=1438942&r1=1438941&r2=1438942&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/table_access_keys_stats.q
(original)
+++ hive/trunk/ql/src/test/queries/clientpositive/table_access_keys_stats.q Sat
Jan 26 18:44:37 2013
@@ -44,10 +44,11 @@ JOIN
ON subq1.key = subq2.key;
SELECT * FROM
-(SELECT key, count(1) FROM T1 GROUP BY key) subq1
+(SELECT key, count(1) as c FROM T1 GROUP BY key) subq1
JOIN
-(SELECT key, val, count(1) FROM T1 GROUP BY key, val) subq2
-ON subq1.key = subq2.key;
+(SELECT key, val, count(1) as c FROM T1 GROUP BY key, val) subq2
+ON subq1.key = subq2.key
+ORDER BY subq1.key ASC, subq1.c ASC, subq2.key ASC, subq2.val ASC, subq2.c ASC;
-- constants from sub-queries should work fine
SELECT key, constant, val, count(1) from
@@ -74,7 +75,8 @@ INSERT OVERWRITE TABLE T3 SELECT key, su
-- simple joins
SELECT *
FROM T1 JOIN T2
-ON T1.key = t2.key;
+ON T1.key = t2.key
+ORDER BY T1.key ASC, T1.val ASC;
SELECT *
FROM T1 JOIN T2
Modified:
hive/trunk/ql/src/test/results/clientpositive/table_access_keys_stats.q.out
URL:
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/table_access_keys_stats.q.out?rev=1438942&r1=1438941&r2=1438942&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/table_access_keys_stats.q.out
(original)
+++ hive/trunk/ql/src/test/results/clientpositive/table_access_keys_stats.q.out
Sat Jan 26 18:44:37 2013
@@ -181,10 +181,11 @@ Keys:key
7 1 7 1
8 2 8 2
PREHOOK: query: SELECT * FROM
-(SELECT key, count(1) FROM T1 GROUP BY key) subq1
+(SELECT key, count(1) as c FROM T1 GROUP BY key) subq1
JOIN
-(SELECT key, val, count(1) FROM T1 GROUP BY key, val) subq2
+(SELECT key, val, count(1) as c FROM T1 GROUP BY key, val) subq2
ON subq1.key = subq2.key
+ORDER BY subq1.key ASC, subq1.c ASC, subq2.key ASC, subq2.val ASC, subq2.c ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
#### A masked pattern was here ####
@@ -263,6 +264,7 @@ PREHOOK: query: -- simple joins
SELECT *
FROM T1 JOIN T2
ON T1.key = t2.key
+ORDER BY T1.key ASC, T1.val ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
