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 2013/12/09 15:24:07 UTC
svn commit: r1549580 [2/11] - in /hive/trunk:
contrib/src/test/results/clientnegative/
contrib/src/test/results/clientpositive/
hbase-handler/src/test/results/positive/
ql/src/java/org/apache/hadoop/hive/ql/ ql/src/test/results/clientnegative/
ql/src/t...
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_partition_coltype.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_partition_coltype.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_partition_coltype.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_partition_coltype.q.out Mon Dec 9 14:23:53 2013
@@ -225,7 +225,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from alter_coltype where dt = 100
PREHOOK: type: QUERY
PREHOOK: Input: default@alter_coltype
@@ -435,7 +434,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- validate partition key column predicate on two different partition column data type
-- can still work.
select count(*) from alter_coltype where ts = 3.0 and dt=10
@@ -691,7 +689,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- query where multiple partition values (of different datatypes) are being selected
select key, value, dt, ts from alter_coltype where dt is not null
PREHOOK: type: QUERY
@@ -989,7 +986,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from alter_coltype where ts = 3.0
PREHOOK: type: QUERY
PREHOOK: Input: default@alter_coltype
@@ -1257,7 +1253,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: desc alter_coltype
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc alter_coltype
Modified: hive/trunk/ql/src/test/results/clientpositive/ambiguous_col.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ambiguous_col.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ambiguous_col.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ambiguous_col.q.out Mon Dec 9 14:23:53 2013
@@ -84,7 +84,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- DOT
explain select * from (select a.key, a.`[k].*` from (select * from src) a join (select * from src1) b on (a.key = b.key)) t
PREHOOK: type: QUERY
@@ -165,7 +164,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- EXPRESSION
explain select * from (select a.key, a.key from (select * from src) a join (select * from src1) b on (a.key = b.key)) t
PREHOOK: type: QUERY
@@ -246,4 +244,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_filter.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_filter.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_filter.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_filter.q.out Mon Dec 9 14:23:53 2013
@@ -85,7 +85,6 @@ STAGE PLANS:
numRows: 8 dataSize: 796 basicStatsState: COMPLETE colStatsState: NONE
ListSink
-
PREHOOK: query: -- column stats are not COMPLETE, so stats are not updated
-- numRows: 8 rawDataSize: 796
explain extended select * from loc_orc where state='OH'
@@ -211,7 +210,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: analyze table loc_orc compute statistics for columns state,locid,zip,year
PREHOOK: type: QUERY
PREHOOK: Input: default@loc_orc
@@ -349,7 +347,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- not equals comparison shouldn't affect number of rows
-- numRows: 8 rawDataSize: 804
explain extended select * from loc_orc where state!='OH'
@@ -475,7 +472,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain extended select * from loc_orc where state<>'OH'
PREHOOK: type: QUERY
POSTHOOK: query: explain extended select * from loc_orc where state<>'OH'
@@ -597,7 +593,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- nulls are treated as constant equality comparison
-- numRows: 1 rawDataSize: 102
explain extended select * from loc_orc where zip is null
@@ -723,7 +718,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 1 rawDataSize: 102
explain extended select * from loc_orc where !(zip is not null)
PREHOOK: type: QUERY
@@ -847,7 +841,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- not nulls are treated as inverse of nulls
-- numRows: 7 rawDataSize: 702
explain extended select * from loc_orc where zip is not null
@@ -973,7 +966,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 7 rawDataSize: 702
explain extended select * from loc_orc where !(zip is null)
PREHOOK: type: QUERY
@@ -1097,7 +1089,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- NOT evaluation. true will pass all rows, false will not pass any rows
-- numRows: 8 rawDataSize: 804
explain extended select * from loc_orc where !false
@@ -1223,7 +1214,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 0 rawDataSize: 0
explain extended select * from loc_orc where !true
PREHOOK: type: QUERY
@@ -1347,7 +1337,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- OR evaluation. 1 row for OH and 1 row for CA
-- numRows: 2 rawDataSize: 204
explain extended select * from loc_orc where state='OH' or state='CA'
@@ -1473,7 +1462,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- AND evaluation. cascadingly apply rules. 8/2 = 4/2 = 2
-- numRows: 2 rawDataSize: 204
explain extended select * from loc_orc where year=2001 and year is null
@@ -1599,7 +1587,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 1 rawDataSize: 102
explain extended select * from loc_orc where year=2001 and state='OH' and state='FL'
PREHOOK: type: QUERY
@@ -1723,7 +1710,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- AND and OR together. left expr will yield 1 row and right will yield 1 row
-- numRows: 3 rawDataSize: 306
explain extended select * from loc_orc where (year=2001 and year is null) or (state='CA')
@@ -1849,7 +1835,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- AND and OR together. left expr will yield 8 rows and right will yield 1 row
-- numRows: 1 rawDataSize: 102
explain extended select * from loc_orc where (year=2001 or year is null) and (state='CA')
@@ -1975,7 +1960,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- all inequality conditions rows/3 is the rules
-- numRows: 2 rawDataSize: 204
explain extended select * from loc_orc where locid < 30
@@ -2101,7 +2085,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain extended select * from loc_orc where locid > 30
PREHOOK: type: QUERY
POSTHOOK: query: explain extended select * from loc_orc where locid > 30
@@ -2223,7 +2206,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain extended select * from loc_orc where locid <= 30
PREHOOK: type: QUERY
POSTHOOK: query: explain extended select * from loc_orc where locid <= 30
@@ -2345,7 +2327,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain extended select * from loc_orc where locid >= 30
PREHOOK: type: QUERY
POSTHOOK: query: explain extended select * from loc_orc where locid >= 30
@@ -2467,4 +2448,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_groupby.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_groupby.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_groupby.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_groupby.q.out Mon Dec 9 14:23:53 2013
@@ -85,7 +85,6 @@ STAGE PLANS:
numRows: 8 dataSize: 796 basicStatsState: COMPLETE colStatsState: NONE
ListSink
-
PREHOOK: query: -- partial column stats
analyze table loc_orc compute statistics for columns state
PREHOOK: type: QUERY
@@ -388,7 +387,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: analyze table loc_orc compute statistics for columns state,locid,zip,year
PREHOOK: type: QUERY
PREHOOK: Input: default@loc_orc
@@ -553,7 +551,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- map-side GBY: numRows: 8
-- reduce-side GBY: numRows: 4
explain extended select state,locid from loc_orc group by state,locid
@@ -716,7 +713,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- map-side GBY numRows: 32 reduce-side GBY numRows: 16
explain extended select state,locid from loc_orc group by state,locid with cube
PREHOOK: type: QUERY
@@ -885,7 +881,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- map-side GBY numRows: 24 reduce-side GBY numRows: 12
explain extended select state,locid from loc_orc group by state,locid with rollup
PREHOOK: type: QUERY
@@ -1054,7 +1049,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- map-side GBY numRows: 8 reduce-side GBY numRows: 4
explain extended select state,locid from loc_orc group by state,locid grouping sets((state))
PREHOOK: type: QUERY
@@ -1223,7 +1217,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- map-side GBY numRows: 16 reduce-side GBY numRows: 8
explain extended select state,locid from loc_orc group by state,locid grouping sets((state),(locid))
PREHOOK: type: QUERY
@@ -1392,7 +1385,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- map-side GBY numRows: 24 reduce-side GBY numRows: 12
explain extended select state,locid from loc_orc group by state,locid grouping sets((state),(locid),())
PREHOOK: type: QUERY
@@ -1561,7 +1553,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- map-side GBY numRows: 32 reduce-side GBY numRows: 16
explain extended select state,locid from loc_orc group by state,locid grouping sets((state,locid),(state),(locid),())
PREHOOK: type: QUERY
@@ -1730,7 +1721,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- map-side GBY: numRows: 80 (map-side will not do any reduction)
-- reduce-side GBY: numRows: 2 Reason: numDistinct of year is 2. numRows = min(80/2, 2)
explain extended select year from loc_orc group by year
@@ -1881,7 +1871,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- map-side GBY numRows: 320 reduce-side GBY numRows: 42 Reason: numDistinct of state and locid are 6,7 resp. numRows = min(320/2, 6*7)
explain extended select state,locid from loc_orc group by state,locid with cube
PREHOOK: type: QUERY
@@ -2050,4 +2039,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_join.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_join.q.out Mon Dec 9 14:23:53 2013
@@ -421,7 +421,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- 3 way join
-- Expected output rows: 4
-- Reason: #rows = (6*4*6)/max(3,6)*max(6,3)
@@ -669,7 +668,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- Expected output rows: 5
-- Reason: #rows = (6*4*8)/max(3,6)*max(6,6)
explain extended select * from emp_orc e join dept_orc d on (e.deptid = d.deptid) join loc_orc l on (e.deptid = l.locid)
@@ -968,7 +966,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- join keys of different types
-- Expected output rows: 4
-- Reason: #rows = (6*4*8)/max(3,6)*max(6,7)
@@ -1269,7 +1266,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- multi-attribute join
-- Expected output rows: 0
-- Reason: #rows = (6*4)/max(3,6)*max(7,5)
@@ -1497,7 +1493,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- 3 way and multi-attribute join
-- Expected output rows: 0
-- Reason: #rows = (6*4*8)/max(3,6)*max(7,5)*max(3,6)*max(7,7)
@@ -1810,4 +1805,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_limit.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_limit.q.out Mon Dec 9 14:23:53 2013
@@ -97,7 +97,6 @@ STAGE PLANS:
numRows: 8 dataSize: 796 basicStatsState: COMPLETE colStatsState: COMPLETE
ListSink
-
PREHOOK: query: -- numRows: 4 rawDataSize: 396
explain extended select * from loc_orc limit 4
PREHOOK: type: QUERY
@@ -142,7 +141,6 @@ STAGE PLANS:
numRows: 4 dataSize: 396 basicStatsState: COMPLETE colStatsState: COMPLETE
ListSink
-
PREHOOK: query: -- greater than the available number of rows
-- numRows: 8 rawDataSize: 796
explain extended select * from loc_orc limit 16
@@ -189,7 +187,6 @@ STAGE PLANS:
numRows: 8 dataSize: 796 basicStatsState: COMPLETE colStatsState: COMPLETE
ListSink
-
PREHOOK: query: -- numRows: 0 rawDataSize: 0
explain extended select * from loc_orc limit 0
PREHOOK: type: QUERY
@@ -234,4 +231,3 @@ STAGE PLANS:
numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
ListSink
-
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_part.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_part.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_part.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_part.q.out Mon Dec 9 14:23:53 2013
@@ -69,7 +69,6 @@ STAGE PLANS:
numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
ListSink
-
PREHOOK: query: insert overwrite table loc_orc partition(year) select * from loc_staging
PREHOOK: type: QUERY
PREHOOK: Input: default@loc_staging
@@ -211,7 +210,6 @@ STAGE PLANS:
numRows: 5 dataSize: 727 basicStatsState: COMPLETE colStatsState: NONE
ListSink
-
PREHOOK: query: -- partition level analyze statistics for specific parition
analyze table loc_orc partition(year=2001) compute statistics
PREHOOK: type: QUERY
@@ -315,7 +313,6 @@ STAGE PLANS:
numRows: 2 dataSize: 325 basicStatsState: COMPLETE colStatsState: NONE
ListSink
-
PREHOOK: query: -- basicStatState: PARTIAL colStatState: NONE
explain extended select * from loc_orc
PREHOOK: type: QUERY
@@ -438,7 +435,6 @@ STAGE PLANS:
numRows: 9 dataSize: 727 basicStatsState: COMPLETE colStatsState: NONE
ListSink
-
PREHOOK: query: -- basicStatState: COMPLETE colStatState: NONE
explain extended select * from loc_orc where year=2001
PREHOOK: type: QUERY
@@ -522,7 +518,6 @@ STAGE PLANS:
numRows: 7 dataSize: 402 basicStatsState: COMPLETE colStatsState: NONE
ListSink
-
PREHOOK: query: -- partition level analyze statistics for all partitions
analyze table loc_orc partition(year) compute statistics
PREHOOK: type: QUERY
@@ -630,7 +625,6 @@ STAGE PLANS:
numRows: 1 dataSize: 325 basicStatsState: COMPLETE colStatsState: NONE
ListSink
-
PREHOOK: query: -- basicStatState: COMPLETE colStatState: NONE
explain extended select * from loc_orc
PREHOOK: type: QUERY
@@ -753,7 +747,6 @@ STAGE PLANS:
numRows: 8 dataSize: 727 basicStatsState: COMPLETE colStatsState: NONE
ListSink
-
PREHOOK: query: -- basicStatState: COMPLETE colStatState: NONE
explain extended select * from loc_orc where year=2001 or year='__HIVE_DEFAULT_PARTITION__'
PREHOOK: type: QUERY
@@ -876,7 +869,6 @@ STAGE PLANS:
numRows: 8 dataSize: 727 basicStatsState: COMPLETE colStatsState: NONE
ListSink
-
PREHOOK: query: -- both partitions will be pruned
-- basicStatState: NONE colStatState: NONE
explain extended select * from loc_orc where year=2001 and year='__HIVE_DEFAULT_PARTITION__'
@@ -929,7 +921,6 @@ STAGE PLANS:
numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
ListSink
-
PREHOOK: query: -- partition level partial column statistics
analyze table loc_orc partition(year=2001) compute statistics for columns state,locid
PREHOOK: type: QUERY
@@ -1099,7 +1090,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- basicStatState: COMPLETE colStatState: PARTIAL
explain extended select state from loc_orc
PREHOOK: type: QUERY
@@ -1251,7 +1241,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- column statistics for __HIVE_DEFAULT_PARTITION__ is not supported yet. Hence colStatState reports PARTIAL
-- basicStatState: COMPLETE colStatState: PARTIAL
explain extended select state,locid from loc_orc
@@ -1407,7 +1396,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- basicStatState: COMPLETE colStatState: COMPLETE
explain extended select state,locid from loc_orc where year=2001
PREHOOK: type: QUERY
@@ -1519,7 +1507,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- basicStatState: COMPLETE colStatState: NONE
explain extended select state,locid from loc_orc where year!=2001
PREHOOK: type: QUERY
@@ -1638,7 +1625,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- basicStatState: COMPLETE colStatState: PARTIAL
explain extended select * from loc_orc
PREHOOK: type: QUERY
@@ -1761,7 +1747,6 @@ STAGE PLANS:
numRows: 8 dataSize: 727 basicStatsState: COMPLETE colStatsState: PARTIAL
ListSink
-
PREHOOK: query: -- This is to test filter expression evaluation on partition column
-- numRows: 2 dataSize: 8 basicStatState: COMPLETE colStatState: COMPLETE
explain extended select locid from loc_orc where locid>0 and year=2001
@@ -1880,7 +1865,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain extended select locid,year from loc_orc where locid>0 and year=2001
PREHOOK: type: QUERY
POSTHOOK: query: explain extended select locid,year from loc_orc where locid>0 and year=2001
@@ -1997,7 +1981,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain extended select * from (select locid,year from loc_orc) test where locid>0 and year=2001
PREHOOK: type: QUERY
POSTHOOK: query: explain extended select * from (select locid,year from loc_orc) test where locid>0 and year=2001
@@ -2114,4 +2097,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_select.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_select.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_select.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_select.q.out Mon Dec 9 14:23:53 2013
@@ -155,7 +155,6 @@ STAGE PLANS:
numRows: 2 dataSize: 1686 basicStatsState: COMPLETE colStatsState: NONE
ListSink
-
PREHOOK: query: -- statistics for complex types are not supported yet
analyze table alltypes_orc compute statistics for columns bo1, ti1, si1, i1, bi1, f1, d1, s1, vc1
PREHOOK: type: QUERY
@@ -255,7 +254,6 @@ STAGE PLANS:
numRows: 2 dataSize: 1686 basicStatsState: COMPLETE colStatsState: PARTIAL
ListSink
-
PREHOOK: query: -- numRows: 2 rawDataSize: 8
explain extended select bo1 from alltypes_orc
PREHOOK: type: QUERY
@@ -381,7 +379,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- col alias renaming
-- numRows: 2 rawDataSize: 8
explain extended select i1 as int1 from alltypes_orc
@@ -509,7 +506,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 174
explain extended select s1 from alltypes_orc
PREHOOK: type: QUERY
@@ -635,7 +631,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- column statistics for complex types unsupported and so statistics will not be updated
-- numRows: 2 rawDataSize: 1514
explain extended select m1 from alltypes_orc
@@ -763,7 +758,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 246
explain extended select bo1, ti1, si1, i1, bi1, f1, d1,s1 from alltypes_orc
PREHOOK: type: QUERY
@@ -903,7 +897,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 0
explain extended select null from alltypes_orc
PREHOOK: type: QUERY
@@ -1029,7 +1022,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 8
explain extended select 11 from alltypes_orc
PREHOOK: type: QUERY
@@ -1155,7 +1147,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 16
explain extended select 11L from alltypes_orc
PREHOOK: type: QUERY
@@ -1281,7 +1272,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 16
explain extended select 11.0 from alltypes_orc
PREHOOK: type: QUERY
@@ -1407,7 +1397,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 178
explain extended select "hello" from alltypes_orc
PREHOOK: type: QUERY
@@ -1533,7 +1522,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain extended select cast("hello" as char(5)) from alltypes_orc
PREHOOK: type: QUERY
POSTHOOK: query: explain extended select cast("hello" as char(5)) from alltypes_orc
@@ -1657,7 +1645,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain extended select cast("hello" as varchar(5)) from alltypes_orc
PREHOOK: type: QUERY
POSTHOOK: query: explain extended select cast("hello" as varchar(5)) from alltypes_orc
@@ -1781,7 +1768,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 96
explain extended select unbase64("0xe23") from alltypes_orc
PREHOOK: type: QUERY
@@ -1907,7 +1893,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 16
explain extended select cast("1" as TINYINT), cast("20" as SMALLINT) from alltypes_orc
PREHOOK: type: QUERY
@@ -2035,7 +2020,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 80
explain extended select cast("1970-12-31 15:59:58.174" as TIMESTAMP) from alltypes_orc
PREHOOK: type: QUERY
@@ -2161,7 +2145,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 112
explain extended select cast("1970-12-31 15:59:58.174" as DATE) from alltypes_orc
PREHOOK: type: QUERY
@@ -2287,7 +2270,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 224
explain extended select cast("58.174" as DECIMAL) from alltypes_orc
PREHOOK: type: QUERY
@@ -2413,7 +2395,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 112
explain extended select array(1,2,3) from alltypes_orc
PREHOOK: type: QUERY
@@ -2539,7 +2520,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 1508
explain extended select str_to_map("a=1 b=2 c=3", " ", "=") from alltypes_orc
PREHOOK: type: QUERY
@@ -2665,7 +2645,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 112
explain extended select NAMED_STRUCT("a", 11, "b", 11) from alltypes_orc
PREHOOK: type: QUERY
@@ -2791,7 +2770,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 2 rawDataSize: 250
explain extended select CREATE_UNION(0, "hello") from alltypes_orc
PREHOOK: type: QUERY
@@ -2917,7 +2895,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- COUNT(*) is projected as new column. It is not projected as GenericUDF and so datasize estimate will be based on number of rows
-- numRows: 1 rawDataSize: 8
explain extended select count(*) from alltypes_orc
@@ -3074,7 +3051,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- COUNT(1) is projected as new column. It is not projected as GenericUDF and so datasize estimate will be based on number of rows
-- numRows: 1 rawDataSize: 8
explain extended select count(1) from alltypes_orc
@@ -3231,7 +3207,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- column statistics for complex column types will be missing. data size will be calculated from available column statistics
-- numRows: 2 rawDataSize: 254
explain extended select *,11 from alltypes_orc
@@ -3389,7 +3364,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- subquery selects
-- inner select - numRows: 2 rawDataSize: 8
-- outer select - numRows: 2 rawDataSize: 8
@@ -3545,7 +3519,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- inner select - numRows: 2 rawDataSize: 16
-- outer select - numRows: 2 rawDataSize: 8
explain extended select i1 from (select i1,11 from alltypes_orc limit 10) temp
@@ -3703,7 +3676,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- inner select - numRows: 2 rawDataSize: 16
-- outer select - numRows: 2 rawDataSize: 186
explain extended select i1,"hello" from (select i1,11 from alltypes_orc limit 10) temp
@@ -3863,7 +3835,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- inner select - numRows: 2 rawDataSize: 24
-- outer select - numRows: 2 rawDataSize: 16
explain extended select x from (select i1,11.0 as x from alltypes_orc limit 10) temp
@@ -4021,7 +3992,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- inner select - numRows: 2 rawDataSize: 104
-- outer select - numRows: 2 rawDataSize: 186
explain extended select x,"hello" from (select i1 as x, unbase64("0xe23") as ub from alltypes_orc limit 10) temp
@@ -4181,7 +4151,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- inner select - numRows: 2 rawDataSize: 186
-- middle select - numRows: 2 rawDataSize: 178
-- outer select - numRows: 2 rawDataSize: 194
@@ -4419,7 +4388,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- This test is for FILTER operator where filter expression is a boolean column
-- numRows: 2 rawDataSize: 8
explain extended select bo1 from alltypes_orc where bo1
@@ -4554,7 +4522,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 0 rawDataSize: 0
explain extended select bo1 from alltypes_orc where !bo1
PREHOOK: type: QUERY
@@ -4687,4 +4654,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_table.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_table.q.out Mon Dec 9 14:23:53 2013
@@ -55,7 +55,6 @@ STAGE PLANS:
numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
ListSink
-
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/emp.txt' OVERWRITE INTO TABLE emp_staging
PREHOOK: type: LOAD
PREHOOK: Output: default@emp_staging
@@ -111,7 +110,6 @@ STAGE PLANS:
numRows: 3 dataSize: 349 basicStatsState: COMPLETE colStatsState: NONE
ListSink
-
PREHOOK: query: -- table level analyze statistics
analyze table emp_orc compute statistics
PREHOOK: type: QUERY
@@ -159,7 +157,6 @@ STAGE PLANS:
numRows: 6 dataSize: 349 basicStatsState: COMPLETE colStatsState: NONE
ListSink
-
PREHOOK: query: -- column level partial statistics
analyze table emp_orc compute statistics for columns deptid
PREHOOK: type: QUERY
@@ -207,7 +204,6 @@ STAGE PLANS:
numRows: 6 dataSize: 349 basicStatsState: COMPLETE colStatsState: PARTIAL
ListSink
-
PREHOOK: query: -- all selected columns have statistics
-- basicStatState: COMPLETE colStatState: COMPLETE
explain extended select deptid from emp_orc
@@ -318,7 +314,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- column level complete statistics
analyze table emp_orc compute statistics for columns lastname,deptid
PREHOOK: type: QUERY
@@ -366,7 +361,6 @@ STAGE PLANS:
numRows: 6 dataSize: 349 basicStatsState: COMPLETE colStatsState: COMPLETE
ListSink
-
PREHOOK: query: -- basicStatState: COMPLETE colStatState: COMPLETE
explain extended select lastname from emp_orc
PREHOOK: type: QUERY
@@ -475,7 +469,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- basicStatState: COMPLETE colStatState: COMPLETE
explain extended select deptid from emp_orc
PREHOOK: type: QUERY
@@ -584,7 +577,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- basicStatState: COMPLETE colStatState: COMPLETE
explain extended select lastname,deptid from emp_orc
PREHOOK: type: QUERY
@@ -695,4 +687,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_union.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_union.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_union.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_union.q.out Mon Dec 9 14:23:53 2013
@@ -166,7 +166,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 16 rawDataSize: 1376
explain extended select * from (select state from loc_orc union all select state from loc_orc) tmp
PREHOOK: type: QUERY
@@ -332,7 +331,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 8 rawDataSize: 796
explain extended select * from loc_orc
PREHOOK: type: QUERY
@@ -374,7 +372,6 @@ STAGE PLANS:
numRows: 8 dataSize: 796 basicStatsState: COMPLETE colStatsState: COMPLETE
ListSink
-
PREHOOK: query: -- numRows: 16 rawDataSize: 1592
explain extended select * from (select * from loc_orc union all select * from loc_orc) tmp
PREHOOK: type: QUERY
@@ -564,7 +561,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: create database test
PREHOOK: type: CREATEDATABASE
POSTHOOK: query: create database test
@@ -909,7 +905,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- numRows: 16 rawDataSize: 1376
explain extended select * from (select state from test.loc_staging union all select state from test.loc_orc) temp
PREHOOK: type: QUERY
@@ -1124,4 +1119,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out Mon Dec 9 14:23:53 2013
@@ -298,7 +298,6 @@ PREHOOK: type: SHOW_ROLE_GRANT
POSTHOOK: query: show role grant user hive_test_user
POSTHOOK: type: SHOW_ROLE_GRANT
role name:src_role
-role name:src_role
PREHOOK: query: --column grant to role
grant select(key) on table src_autho_test to role src_role
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_5.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_5.q.out Mon Dec 9 14:23:53 2013
@@ -51,7 +51,6 @@ PREHOOK: type: SHOW_ROLE_GRANT
POSTHOOK: query: SHOW ROLE GRANT USER hive_test_user
POSTHOOK: type: SHOW_ROLE_GRANT
role name:db_test_role
-role name:db_test_role
PREHOOK: query: GRANT drop ON DATABASE test_db TO ROLE db_test_role
PREHOOK: type: GRANT_PRIVILEGE
POSTHOOK: query: GRANT drop ON DATABASE test_db TO ROLE db_test_role
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join0.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join0.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join0.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join0.q.out Mon Dec 9 14:23:53 2013
@@ -186,7 +186,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select sum(hash(a.k1,a.v1,a.k2, a.v2))
from (
SELECT src1.key as k1, src1.value as v1,
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join1.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join1.q.out Mon Dec 9 14:23:53 2013
@@ -90,7 +90,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join10.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join10.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join10.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join10.q.out Mon Dec 9 14:23:53 2013
@@ -118,7 +118,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: FROM
(SELECT src.* FROM src) x
JOIN
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join11.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join11.q.out Mon Dec 9 14:23:53 2013
@@ -126,7 +126,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT sum(hash(src1.c1, src2.c4))
FROM
(SELECT src.key as c1, src.value as c2 from src) src1
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join12.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join12.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join12.q.out Mon Dec 9 14:23:53 2013
@@ -163,7 +163,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT sum(hash(src1.c1, src2.c4))
FROM
(SELECT src.key as c1, src.value as c2 from src) src1
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join13.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join13.q.out Mon Dec 9 14:23:53 2013
@@ -168,7 +168,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT sum(hash(src1.c1, src2.c4))
FROM
(SELECT src.key as c1, src.value as c2 from src) src1
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join14_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join14_hadoop20.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join14_hadoop20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join14_hadoop20.q.out Mon Dec 9 14:23:53 2013
@@ -102,7 +102,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src JOIN srcpart ON src.key = srcpart.key AND srcpart.ds = '2008-04-08' and src.key > 100
INSERT OVERWRITE TABLE dest1 SELECT src.key, srcpart.value
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join15.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join15.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join15.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join15.q.out Mon Dec 9 14:23:53 2013
@@ -158,7 +158,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select sum(hash(a.k1,a.v1,a.k2, a.v2))
from (
SELECT src1.key as k1, src1.value as v1, src2.key as k2, src2.value as v2
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join16.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join16.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join16.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join16.q.out Mon Dec 9 14:23:53 2013
@@ -121,7 +121,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT sum(hash(subq.key, tab.value))
FROM
(select a.key, a.value from src a where a.key > 10 ) subq
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join17.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join17.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join17.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join17.q.out Mon Dec 9 14:23:53 2013
@@ -94,7 +94,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest1 SELECT src1.*, src2.*
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join18.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join18.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join18.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join18.q.out Mon Dec 9 14:23:53 2013
@@ -261,7 +261,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT sum(hash(a.key, a.value, b.key, b.value))
FROM
(
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join18_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join18_multi_distinct.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join18_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join18_multi_distinct.q.out Mon Dec 9 14:23:53 2013
@@ -273,7 +273,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT sum(hash(a.key, a.value, b.key, b.value1, b.value2))
FROM
(
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join19.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join19.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join19.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join19.q.out Mon Dec 9 14:23:53 2013
@@ -92,7 +92,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest1 SELECT src1.key, src2.value
where (src1.ds = '2008-04-08' or src1.ds = '2008-04-09' )and (src1.hr = '12' or src1.hr = '11')
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join2.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join2.q.out Mon Dec 9 14:23:53 2013
@@ -117,7 +117,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key + src2.key = src3.key)
INSERT OVERWRITE TABLE dest_j2 SELECT src1.key, src3.value
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join20.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join20.q.out Mon Dec 9 14:23:53 2013
@@ -216,7 +216,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select sum(hash(a.k1,a.v1,a.k2,a.v2,a.k3,a.v3))
from (
SELECT src1.key as k1, src1.value as v1, src2.key as k2, src2.value as v2 , src3.key as k3, src3.value as v3
@@ -454,7 +453,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select sum(hash(a.k1,a.v1,a.k2,a.v2,a.k3,a.v3))
from (
SELECT src1.key as k1, src1.value as v1, src2.key as k2, src2.value as v2 , src3.key as k3, src3.value as v3
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join21.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join21.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join21.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join21.q.out Mon Dec 9 14:23:53 2013
@@ -149,7 +149,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join22.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join22.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join22.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join22.q.out Mon Dec 9 14:23:53 2013
@@ -128,7 +128,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT sum(hash(src5.src1_value)) FROM (SELECT src3.*, src4.value as src4_value, src4.key as src4_key FROM src src4 JOIN (SELECT src2.*, src1.key as src1_key, src1.value as src1_value FROM src src1 JOIN src src2 ON src1.key = src2.key) src3 ON src3.src1_key = src4.key) src5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join23.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join23.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join23.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join23.q.out Mon Dec 9 14:23:53 2013
@@ -107,7 +107,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join24.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join24.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join24.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join24.q.out Mon Dec 9 14:23:53 2013
@@ -113,7 +113,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT sum(a.cnt) FROM tst1 a JOIN tst1 b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@tst1
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join26.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join26.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join26.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join26.q.out Mon Dec 9 14:23:53 2013
@@ -126,7 +126,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: INSERT OVERWRITE TABLE dest_j1
SELECT x.key, count(1) FROM src1 x JOIN src y ON (x.key = y.key) group by x.key
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join27.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join27.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join27.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join27.q.out Mon Dec 9 14:23:53 2013
@@ -235,7 +235,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT count(1)
FROM
(
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join28.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join28.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join28.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join28.q.out Mon Dec 9 14:23:53 2013
@@ -149,7 +149,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain
SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
@@ -305,7 +304,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain
SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
@@ -461,7 +459,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain
SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
@@ -613,4 +610,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join29.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join29.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join29.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join29.q.out Mon Dec 9 14:23:53 2013
@@ -149,7 +149,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -813,7 +812,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -1477,7 +1475,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -2149,7 +2146,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -2817,7 +2813,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -2981,7 +2976,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -3645,7 +3639,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -3813,7 +3806,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -3991,7 +3983,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join3.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join3.q.out Mon Dec 9 14:23:53 2013
@@ -112,7 +112,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key = src3.key)
INSERT OVERWRITE TABLE dest1 SELECT src1.key, src3.value
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join30.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join30.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join30.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join30.q.out Mon Dec 9 14:23:53 2013
@@ -588,7 +588,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: FROM
(SELECT src.* FROM src sort by key) x
LEFT OUTER JOIN
@@ -863,7 +862,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: FROM
(SELECT src.* FROM src sort by key) x
RIGHT OUTER JOIN
@@ -1377,7 +1375,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: FROM
(SELECT src.* FROM src sort by key) x
JOIN
@@ -1815,7 +1812,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: FROM
(SELECT src.* FROM src sort by key) x
JOIN
@@ -2171,7 +2167,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: FROM
(SELECT src.* FROM src sort by key) x
LEFT OUTER JOIN
@@ -2527,7 +2522,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: FROM
(SELECT src.* FROM src sort by key) x
LEFT OUTER JOIN
@@ -2883,7 +2877,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: FROM
(SELECT src.* FROM src sort by key) x
RIGHT OUTER JOIN
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join31.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join31.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join31.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join31.q.out Mon Dec 9 14:23:53 2013
@@ -410,7 +410,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: FROM
(SELECT src.* FROM src sort by key) x
RIGHT OUTER JOIN
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join32.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join32.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join32.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join32.q.out Mon Dec 9 14:23:53 2013
@@ -130,7 +130,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select s.name, count(distinct registration)
from studenttab10k s join votertab10k v
on (s.name = v.name)
@@ -256,7 +255,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select s.name, count(distinct registration)
from studenttab10k_smb s join votertab10k_smb v
on (s.name = v.name)
@@ -394,7 +392,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select s.name, count(distinct registration)
from studenttab10k_smb s join votertab10k_smb v
on (s.name = v.name)
@@ -554,7 +551,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select s.name, count(distinct registration)
from studenttab10k_part s join votertab10k_part v
on (s.name = v.name)
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join4.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join4.q.out Mon Dec 9 14:23:53 2013
@@ -138,7 +138,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM (
FROM
(
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join5.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join5.q.out Mon Dec 9 14:23:53 2013
@@ -138,7 +138,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM (
FROM
(
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join6.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join6.q.out Mon Dec 9 14:23:53 2013
@@ -143,7 +143,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM (
FROM
(
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join7.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join7.q.out Mon Dec 9 14:23:53 2013
@@ -187,7 +187,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM (
FROM
(
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join8.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join8.q.out Mon Dec 9 14:23:53 2013
@@ -142,7 +142,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM (
FROM
(
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join9.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join9.q.out Mon Dec 9 14:23:53 2013
@@ -90,7 +90,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest1 SELECT src1.key, src2.value where src1.ds = '2008-04-08' and src1.hr = '12'
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out Mon Dec 9 14:23:53 2013
@@ -668,7 +668,6 @@ STAGE PLANS:
Fetch Operator
limit: 5
-
PREHOOK: query: SELECT
`dim_pay_date`.`date`
, `deal`.`dealid`
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out Mon Dec 9 14:23:53 2013
@@ -112,7 +112,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from (
select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key
) subq1
@@ -271,7 +270,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(
select key, count(*) from
@@ -589,7 +587,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select src1.key, src1.cnt1, src2.cnt1 from
(
select key, count(*) as cnt1 from
@@ -733,7 +730,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key as key, a.value as value from tbl1 a where key < 6) subq1
join
@@ -860,7 +856,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(
select * from
@@ -1011,7 +1006,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(
select * from
@@ -1152,7 +1146,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key as key, concat(a.value, a.value) as value from tbl1 a where key < 8) subq1
join
@@ -1302,7 +1295,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key +1 as key, concat(a.value, a.value) as value from tbl1 a) subq1
join
@@ -1415,7 +1407,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key as key, a.value as value from tbl1 a where key < 6) subq1
join tbl2 a on subq1.key = a.key
@@ -1537,7 +1528,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key as key, a.value as value from tbl1 a where key < 6) subq1
join
@@ -1672,7 +1662,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from (
select subq2.key as key, subq2.value as value1, b.value as value2 from
(
@@ -1941,7 +1930,6 @@ STAGE PLANS:
hdfs directory: true
#### A masked pattern was here ####
-
PREHOOK: query: from (
select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key
) subq1
@@ -2284,7 +2272,6 @@ STAGE PLANS:
Stage: Stage-9
Stats-Aggr Operator
-
PREHOOK: query: from (
select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key
) subq1
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out Mon Dec 9 14:23:53 2013
@@ -256,7 +256,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_small a JOIN bucket_big b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -451,7 +450,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -1233,7 +1231,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_10.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_10.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_10.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_10.q.out Mon Dec 9 14:23:53 2013
@@ -234,7 +234,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(
select * from
@@ -441,7 +440,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key as key, count(*) as value from tbl1 a where key < 6 group by a.key) subq1
join
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out Mon Dec 9 14:23:53 2013
@@ -374,7 +374,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_small a JOIN bucket_big b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -699,7 +698,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_small a JOIN bucket_big b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -984,7 +982,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select /*+ mapjoin(a) */ count(*) FROM bucket_small a JOIN bucket_big b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out Mon Dec 9 14:23:53 2013
@@ -592,7 +592,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_small a JOIN bucket_medium b ON a.key = b.key JOIN bucket_big c ON c.key = b.key JOIN bucket_medium d ON c.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_13.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_13.q.out Mon Dec 9 14:23:53 2013
@@ -167,7 +167,6 @@ STAGE PLANS:
Stage: Stage-4
Stats-Aggr Operator
-
PREHOOK: query: from (
SELECT a.key key1, a.value value1, b.key key2, b.value value2
FROM tbl1 a JOIN tbl2 b
@@ -397,7 +396,6 @@ STAGE PLANS:
Stage: Stage-4
Stats-Aggr Operator
-
PREHOOK: query: from (
SELECT a.key key1, a.value value1, b.key key2, b.value value2
FROM tbl1 a JOIN tbl2 b
@@ -643,7 +641,6 @@ STAGE PLANS:
Stage: Stage-4
Stats-Aggr Operator
-
PREHOOK: query: from (
SELECT a.key key1, a.value value1, b.key key2, b.value value2
FROM tbl1 a JOIN tbl2 b
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out Mon Dec 9 14:23:53 2013
@@ -182,7 +182,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM tbl1 a LEFT OUTER JOIN tbl2 b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl1
@@ -366,7 +365,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM tbl1 a RIGHT OUTER JOIN tbl2 b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl1
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out Mon Dec 9 14:23:53 2013
@@ -180,7 +180,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain
select count(*) FROM tbl1 a RIGHT OUTER JOIN tbl2 b ON a.key = b.key
PREHOOK: type: QUERY
@@ -331,4 +330,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out Mon Dec 9 14:23:53 2013
@@ -240,7 +240,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -1024,7 +1023,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out Mon Dec 9 14:23:53 2013
@@ -195,7 +195,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_small a JOIN bucket_big b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -345,7 +344,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -1079,7 +1077,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out Mon Dec 9 14:23:53 2013
@@ -207,7 +207,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_small a JOIN bucket_big b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -357,7 +356,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -1091,7 +1089,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out Mon Dec 9 14:23:53 2013
@@ -182,7 +182,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_small a JOIN bucket_big b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -328,7 +327,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -836,7 +834,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out Mon Dec 9 14:23:53 2013
@@ -202,7 +202,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM tbl1 a JOIN tbl2 b ON a.key = b.key join src c on c.value = a.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -348,7 +347,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM tbl1 a JOIN tbl2 b ON a.key = b.key join src d on d.value = a.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -494,7 +492,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM tbl1 a JOIN tbl2 b ON a.key = b.key join src h on h.value = a.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -876,7 +873,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM tbl1 a JOIN tbl2 b ON a.key = b.key join src c on c.key = a.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -977,7 +973,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM tbl1 a JOIN tbl2 b ON a.key = b.key join tbl3 c on c.key = a.key
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl1
@@ -1119,7 +1114,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM tbl1 a JOIN tbl2 b ON a.key = b.key join tbl4 c on c.value = a.value
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl1
@@ -1261,7 +1255,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM tbl1 a JOIN tbl2 b ON a.key = b.key join src c on c.value = a.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -1643,7 +1636,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM tbl1 a JOIN tbl2 b ON a.key = b.key join src c on c.key = a.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -2036,7 +2028,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM tbl1 a JOIN tbl2 b ON a.key = b.key join tbl3 c on c.key = a.key
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl1
@@ -2178,7 +2169,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM tbl1 a JOIN tbl2 b ON a.key = b.key join tbl4 c on c.value = a.value
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl1
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out Mon Dec 9 14:23:53 2013
@@ -265,7 +265,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_small a JOIN bucket_big b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -462,7 +461,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -1375,7 +1373,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out Mon Dec 9 14:23:53 2013
@@ -265,7 +265,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_small a JOIN bucket_big b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -462,7 +461,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
@@ -1377,7 +1375,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) FROM bucket_big a JOIN bucket_small b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out Mon Dec 9 14:23:53 2013
@@ -112,7 +112,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from (
select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key
) subq1
@@ -264,7 +263,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select key, count(*) from
(
select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key
@@ -434,7 +432,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(
select key, count(*) from
@@ -870,7 +867,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select src1.key, src1.cnt1, src2.cnt1 from
(
select key, count(*) as cnt1 from
@@ -1014,7 +1010,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key as key, a.value as value from tbl1 a where key < 6) subq1
join
@@ -1141,7 +1136,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(
select * from
@@ -1292,7 +1286,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(
select * from
@@ -1433,7 +1426,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key as key, concat(a.value, a.value) as value from tbl1 a where key < 8) subq1
join
@@ -1574,7 +1566,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key +1 as key, concat(a.value, a.value) as value from tbl1 a) subq1
join
@@ -1687,7 +1678,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key as key, a.value as value from tbl1 a where key < 6) subq1
join tbl2 a on subq1.key = a.key
@@ -1789,7 +1779,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from tbl1 a
join
(select a.key as key, a.value as value from tbl2 a where key < 6) subq1
@@ -1913,7 +1902,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key as key, a.value as value from tbl1 a where key < 6) subq1
join
@@ -2048,7 +2036,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from (
select subq2.key as key, subq2.value as value1, b.value as value2 from
(
@@ -2314,7 +2301,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from (
select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key
) subq1
@@ -2656,7 +2642,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select key, count(*) from
(
select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key
@@ -3016,7 +3001,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(
select key, count(*) from
@@ -3832,7 +3816,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select src1.key, src1.cnt1, src2.cnt1 from
(
select key, count(*) as cnt1 from
@@ -4164,7 +4147,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key as key, a.value as value from tbl1 a where key < 6) subq1
join
@@ -4461,7 +4443,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(
select * from
@@ -4800,7 +4781,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(
select * from
@@ -5129,7 +5109,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key as key, concat(a.value, a.value) as value from tbl1 a where key < 8) subq1
join
@@ -5412,7 +5391,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key as key, a.value as value from tbl1 a where key < 6) subq1
join tbl2 a on subq1.key = a.key
@@ -5684,7 +5662,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from tbl1 a
join
(select a.key as key, a.value as value from tbl2 a where key < 6) subq1
@@ -6181,7 +6158,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from
(select a.key as key, a.value as value from tbl1 a where key < 6) subq1
join
@@ -6486,7 +6462,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from (
select subq2.key as key, subq2.value as value1, b.value as value2 from
(
Modified: hive/trunk/ql/src/test/results/clientpositive/binary_output_format.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/binary_output_format.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/binary_output_format.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/binary_output_format.q.out Mon Dec 9 14:23:53 2013
@@ -353,7 +353,6 @@ STAGE PLANS:
hdfs directory: true
#### A masked pattern was here ####
-
PREHOOK: query: INSERT OVERWRITE TABLE dest1
SELECT TRANSFORM(*)
USING 'cat'
Modified: hive/trunk/ql/src/test/results/clientpositive/binarysortable_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/binarysortable_1.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/binarysortable_1.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/binarysortable_1.q.out Mon Dec 9 14:23:53 2013 differ