You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2010/08/29 08:53:19 UTC
svn commit: r990499 [13/17] - in /hadoop/hive/trunk: ./
hbase-handler/src/test/results/ ql/src/test/org/apache/hadoop/hive/ql/hooks/
ql/src/test/results/clientpositive/
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join_nulls.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join_nulls.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join_nulls.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join_nulls.q.out Sun Aug 29 06:53:17 2010
@@ -23,11 +23,11 @@ POSTHOOK: Output: default@myinput1
PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-17_243_2644277693400732372/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-02-48_124_7015383824487148614/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-17_243_2644277693400732372/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-02-48_124_7015383824487148614/-mr-10000
NULL 35 NULL 35
NULL 35 48 NULL
NULL 35 100 100
@@ -40,11 +40,11 @@ NULL 35 100 100
PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-19_784_5319048142201987096/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-02-51_137_5392106147060915386/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-19_784_5319048142201987096/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-02-51_137_5392106147060915386/-mr-10000
NULL 35 NULL 35
NULL 35 48 NULL
NULL 35 100 100
@@ -57,11 +57,11 @@ NULL 35 100 100
PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-22_077_1127144305944050770/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-02-54_114_1931885903904719968/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-22_077_1127144305944050770/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-02-54_114_1931885903904719968/-mr-10000
NULL 35 NULL 35
NULL 35 48 NULL
NULL 35 100 100
@@ -74,106 +74,106 @@ NULL 35 100 100
PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-24_424_3529043878133127087/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-02-57_092_6147186374641397090/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-24_424_3529043878133127087/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-02-57_092_6147186374641397090/-mr-10000
100 100 100 100
PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-26_755_1023724496806721215/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-00_166_3374165725343302038/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-26_755_1023724496806721215/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-00_166_3374165725343302038/-mr-10000
48 NULL 48 NULL
100 100 100 100
PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-29_041_5563395763782073560/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-03_313_6675493236971514079/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-29_041_5563395763782073560/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-03_313_6675493236971514079/-mr-10000
NULL 35 NULL 35
100 100 100 100
PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-31_315_7618449693784281411/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-06_385_8124137130909821070/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-31_315_7618449693784281411/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-06_385_8124137130909821070/-mr-10000
NULL 35 NULL NULL
48 NULL NULL NULL
100 100 100 100
PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-33_682_9012862787524525556/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-09_467_5872921360456775671/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-33_682_9012862787524525556/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-09_467_5872921360456775671/-mr-10000
48 NULL NULL NULL
NULL 35 NULL 35
100 100 100 100
PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-35_913_1368787467713976651/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-12_616_374281490034878641/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-35_913_1368787467713976651/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-12_616_374281490034878641/-mr-10000
NULL 35 NULL NULL
48 NULL 48 NULL
100 100 100 100
PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-38_139_507910550329126296/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-15_826_7832828975838305207/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-38_139_507910550329126296/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-15_826_7832828975838305207/-mr-10000
NULL NULL 48 NULL
NULL NULL NULL 35
100 100 100 100
PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-40_380_5752206579111501535/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-18_990_932824536088686525/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-40_380_5752206579111501535/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-18_990_932824536088686525/-mr-10000
NULL NULL NULL 35
48 NULL 48 NULL
100 100 100 100
PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-42_711_7203915333997653053/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-22_127_7819363622946760351/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-42_711_7203915333997653053/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-22_127_7819363622946760351/-mr-10000
NULL NULL 48 NULL
NULL 35 NULL 35
100 100 100 100
PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-45_005_2097190139910462757/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-25_224_8317788697567724783/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-45_005_2097190139910462757/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-25_224_8317788697567724783/-mr-10000
NULL 35 NULL NULL
NULL NULL 48 NULL
NULL NULL NULL 35
@@ -182,11 +182,11 @@ NULL NULL NULL 35
PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-47_257_7323115616296556466/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-28_320_6340316978542429365/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-47_257_7323115616296556466/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-28_320_6340316978542429365/-mr-10000
NULL 35 NULL NULL
NULL NULL NULL 35
48 NULL 48 NULL
@@ -194,11 +194,11 @@ NULL NULL NULL 35
PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-49_511_2835828582770697326/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-31_394_8318002319095939201/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-49_511_2835828582770697326/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-31_394_8318002319095939201/-mr-10000
48 NULL NULL NULL
NULL NULL 48 NULL
NULL 35 NULL 35
@@ -206,44 +206,44 @@ NULL 35 NULL 35
PREHOOK: query: SELECT * from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value)
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-51_722_5486518368735387317/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-34_512_1005205187544184747/-mr-10000
POSTHOOK: query: SELECT * from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-51_722_5486518368735387317/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-34_512_1005205187544184747/-mr-10000
NULL NULL NULL NULL 48 NULL
NULL 35 NULL 35 NULL 35
100 100 100 100 100 100
PREHOOK: query: SELECT * from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value)
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-54_007_6526115910610177518/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-37_711_6340949506772786686/-mr-10000
POSTHOOK: query: SELECT * from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-54_007_6526115910610177518/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-37_711_6340949506772786686/-mr-10000
NULL NULL 48 NULL NULL NULL
NULL 35 NULL 35 NULL 35
100 100 100 100 100 100
PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-56_301_1180499696568055707/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-40_948_2794890176126244018/-mr-10000
POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-02-56_301_1180499696568055707/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-40_948_2794890176126244018/-mr-10000
NULL NULL NULL NULL 48 NULL
NULL 35 NULL 35 NULL 35
100 100 100 100 100 100
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-00_784_8177108597645959542/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-46_973_5529249160800115819/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-00_784_8177108597645959542/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-46_973_5529249160800115819/-mr-10000
NULL 35 NULL 35
48 NULL NULL 35
100 100 NULL 35
@@ -256,124 +256,124 @@ NULL 35 100 100
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-02_995_5954257082995484423/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-49_963_1000428859740736851/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-02_995_5954257082995484423/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-49_963_1000428859740736851/-mr-10000
100 100 100 100
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-05_179_893551064505374226/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-52_943_6089957004261811143/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-05_179_893551064505374226/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-52_943_6089957004261811143/-mr-10000
48 NULL 48 NULL
100 100 100 100
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-07_429_2356564524660274058/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-55_914_2591780807247412588/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-07_429_2356564524660274058/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-55_914_2591780807247412588/-mr-10000
NULL 35 NULL 35
100 100 100 100
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-09_626_7027313822877080506/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-58_880_4987797610511570601/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-09_626_7027313822877080506/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-03-58_880_4987797610511570601/-mr-10000
100 100 100 100
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-11_809_1536686550822126228/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-01_842_9018417136841199963/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-11_809_1536686550822126228/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-01_842_9018417136841199963/-mr-10000
48 NULL 48 NULL
100 100 100 100
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-14_070_2576009303176359392/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-04_825_5836817454953993059/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-14_070_2576009303176359392/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-04_825_5836817454953993059/-mr-10000
NULL 35 NULL 35
100 100 100 100
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-16_258_3601408426081449535/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-07_804_5966018968689338722/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-16_258_3601408426081449535/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-07_804_5966018968689338722/-mr-10000
NULL 35 NULL NULL
48 NULL NULL NULL
100 100 100 100
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-18_463_6253242788418262785/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-10_784_2095633421816713692/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-18_463_6253242788418262785/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-10_784_2095633421816713692/-mr-10000
NULL 35 NULL NULL
48 NULL 48 NULL
100 100 100 100
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-20_654_6218349195280704470/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-13_756_806948691912832873/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-20_654_6218349195280704470/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-13_756_806948691912832873/-mr-10000
NULL 35 NULL 35
48 NULL NULL NULL
100 100 100 100
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-22_924_6570219390510773741/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-16_720_3478071990295891514/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-22_924_6570219390510773741/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-16_720_3478071990295891514/-mr-10000
NULL NULL NULL 35
NULL NULL 48 NULL
100 100 100 100
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-25_161_1733690523870724803/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-19_692_9213491013813899575/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-25_161_1733690523870724803/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-19_692_9213491013813899575/-mr-10000
NULL NULL NULL 35
48 NULL 48 NULL
100 100 100 100
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-27_372_7774596545760682849/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-22_674_3153813260067204961/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-27_372_7774596545760682849/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-22_674_3153813260067204961/-mr-10000
NULL 35 NULL 35
NULL NULL 48 NULL
100 100 100 100
@@ -410,11 +410,11 @@ POSTHOOK: Output: default@smb_input2
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key ORDER BY a.key
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-30_243_4546985922226107164/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-28_378_3637991343439427870/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key ORDER BY a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-30_243_4546985922226107164/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-28_378_3637991343439427870/-mr-10000
48 NULL 48 NULL
100 100 100 100
148 NULL 148 NULL
@@ -422,11 +422,11 @@ POSTHOOK: Output: file:/tmp/amarsri/hive
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input1 b ON a.key = b.key ORDER BY b.key, b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-34_575_8944309786058146271/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-34_285_4680092571717814403/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input1 b ON a.key = b.key ORDER BY b.key, b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-34_575_8944309786058146271/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-34_285_4680092571717814403/-mr-10000
NULL NULL NULL 35
NULL NULL NULL 135
48 NULL 48 NULL
@@ -436,11 +436,11 @@ NULL NULL NULL 135
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key ORDER BY a.key
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-38_873_5820673626777323488/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-40_182_8403671338047239743/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key ORDER BY a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-38_873_5820673626777323488/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-40_182_8403671338047239743/-mr-10000
48 NULL 48 NULL
100 100 100 100
148 NULL 148 NULL
@@ -448,11 +448,11 @@ POSTHOOK: Output: file:/tmp/amarsri/hive
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input1 b ON a.key = b.key ORDER BY a.key, a.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-43_139_2148561557873278612/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-46_000_1719051160596831618/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input1 b ON a.key = b.key ORDER BY a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-43_139_2148561557873278612/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-46_000_1719051160596831618/-mr-10000
NULL 35 NULL NULL
NULL 135 NULL NULL
48 NULL 48 NULL
@@ -461,38 +461,38 @@ NULL 135 NULL NULL
200 200 200 200
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value ORDER BY a.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_input2
PREHOOK: Input: default@smb_input1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-47_455_7725011320735873205/-mr-10000
+PREHOOK: Input: default@smb_input2
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-51_827_8844085800766914508/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value ORDER BY a.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_input2
POSTHOOK: Input: default@smb_input1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-47_455_7725011320735873205/-mr-10000
+POSTHOOK: Input: default@smb_input2
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-51_827_8844085800766914508/-mr-10000
100 100 100 100
200 200 200 200
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value ORDER BY a.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_input2
PREHOOK: Input: default@smb_input1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-51_797_1660829853063165698/-mr-10000
+PREHOOK: Input: default@smb_input2
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-57_811_3661181644538537663/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value ORDER BY a.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_input2
POSTHOOK: Input: default@smb_input1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-51_797_1660829853063165698/-mr-10000
+POSTHOOK: Input: default@smb_input2
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-04-57_811_3661181644538537663/-mr-10000
100 100 100 100
200 200 200 200
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input2 b ON a.key = b.value ORDER BY a.key, a.value
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_input2
PREHOOK: Input: default@smb_input1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-56_206_1650617190450676746/-mr-10000
+PREHOOK: Input: default@smb_input2
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-04_807_559648882758842098/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input2 b ON a.key = b.value ORDER BY a.key, a.value
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_input2
POSTHOOK: Input: default@smb_input1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-03-56_206_1650617190450676746/-mr-10000
+POSTHOOK: Input: default@smb_input2
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-04_807_559648882758842098/-mr-10000
NULL 35 NULL NULL
NULL 135 NULL NULL
48 NULL NULL NULL
@@ -501,14 +501,14 @@ NULL 135 NULL NULL
200 200 200 200
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input2 b ON a.key = b.value ORDER BY b.key, b.value
PREHOOK: type: QUERY
-PREHOOK: Input: default@smb_input2
PREHOOK: Input: default@smb_input1
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-04-00_563_760559040118626904/-mr-10000
+PREHOOK: Input: default@smb_input2
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-10_696_6790164286167579949/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input2 b ON a.key = b.value ORDER BY b.key, b.value
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@smb_input2
POSTHOOK: Input: default@smb_input1
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-04-00_563_760559040118626904/-mr-10000
+POSTHOOK: Input: default@smb_input2
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-10_696_6790164286167579949/-mr-10000
NULL NULL NULL 35
NULL NULL NULL 135
NULL NULL 48 NULL
@@ -518,11 +518,11 @@ NULL NULL 148 NULL
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value ORDER BY a.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input2
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-04-04_862_4725133242101166020/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-17_104_7087439589570631019/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value ORDER BY a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input2
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-04-04_862_4725133242101166020/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-17_104_7087439589570631019/-mr-10000
NULL 35 NULL 35
100 100 100 100
NULL 135 NULL 135
@@ -530,11 +530,11 @@ NULL 135 NULL 135
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a RIGHT OUTER JOIN smb_input2 b ON a.value = b.value ORDER BY b.key, b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input2
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-04-09_224_8780642004670528896/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-23_036_5666167509100823043/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a RIGHT OUTER JOIN smb_input2 b ON a.value = b.value ORDER BY b.key, b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input2
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-04-09_224_8780642004670528896/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-23_036_5666167509100823043/-mr-10000
NULL 35 NULL 35
NULL 135 NULL 135
NULL NULL 48 NULL
@@ -544,11 +544,11 @@ NULL NULL 148 NULL
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value ORDER BY a.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input2
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-04-13_547_7917315032596933463/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-28_862_6813009729308463908/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value ORDER BY a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input2
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-04-13_547_7917315032596933463/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-28_862_6813009729308463908/-mr-10000
NULL 35 NULL 35
100 100 100 100
NULL 135 NULL 135
@@ -556,11 +556,11 @@ NULL 135 NULL 135
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a LEFT OUTER JOIN smb_input2 b ON a.value = b.value ORDER BY a.key, a.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input2
-PREHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-04-17_843_48387701327028385/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-34_699_7855850081093628587/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a LEFT OUTER JOIN smb_input2 b ON a.value = b.value ORDER BY a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input2
-POSTHOOK: Output: file:/tmp/amarsri/hive_2010-08-23_23-04-17_843_48387701327028385/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-34_699_7855850081093628587/-mr-10000
NULL 35 NULL 35
NULL 135 NULL 135
48 NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join_rc.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join_rc.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join_rc.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join_rc.q.out Sun Aug 29 06:53:17 2010
@@ -114,15 +114,15 @@ STAGE PLANS:
PREHOOK: query: select join_rc1.key, join_rc2.value
FROM join_rc1 JOIN join_rc2 ON join_rc1.key = join_rc2.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@join_rc2
PREHOOK: Input: default@join_rc1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-02-49_005_2982007273012088026/-mr-10000
+PREHOOK: Input: default@join_rc2
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-48_562_272409638263559506/-mr-10000
POSTHOOK: query: select join_rc1.key, join_rc2.value
FROM join_rc1 JOIN join_rc2 ON join_rc1.key = join_rc2.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@join_rc2
POSTHOOK: Input: default@join_rc1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-02-49_005_2982007273012088026/-mr-10000
+POSTHOOK: Input: default@join_rc2
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-48_562_272409638263559506/-mr-10000
POSTHOOK: Lineage: join_rc1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: join_rc1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: join_rc2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join_reorder.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join_reorder.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join_reorder.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join_reorder.q.out Sun Aug 29 06:53:17 2010
@@ -191,13 +191,13 @@ SELECT a.key, a.val, c.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-02-55_951_7421942426050978131/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-55_909_642870158604473859/-mr-10000
POSTHOOK: query: FROM T1 a JOIN src c ON c.key+1=a.key
SELECT a.key, a.val, c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-02-55_951_7421942426050978131/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-55_909_642870158604473859/-mr-10000
1 11 0
1 11 0
1 11 0
@@ -207,13 +207,13 @@ SELECT /*+ STREAMTABLE(a) */ a.key, a.va
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-00_878_7390588821971448332/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-59_174_1281139540816451802/-mr-10000
POSTHOOK: query: FROM T1 a JOIN src c ON c.key+1=a.key
SELECT /*+ STREAMTABLE(a) */ a.key, a.val, c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-00_878_7390588821971448332/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-05-59_174_1281139540816451802/-mr-10000
1 11 0
1 11 0
1 11 0
@@ -497,19 +497,19 @@ PREHOOK: query: FROM T1 a
RIGHT OUTER JOIN T3 c ON (c.val = a.val)
SELECT a.key, b.key, a.val, c.val
PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Input: default@t1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-07_262_9113480534666709881/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-02_681_8146804917511289759/-mr-10000
POSTHOOK: query: FROM T1 a
LEFT OUTER JOIN T2 b ON (b.key=a.key)
RIGHT OUTER JOIN T3 c ON (c.val = a.val)
SELECT a.key, b.key, a.val, c.val
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-07_262_9113480534666709881/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-02_681_8146804917511289759/-mr-10000
2 2 12 12
NULL NULL NULL 14
NULL NULL NULL 16
@@ -519,19 +519,19 @@ PREHOOK: query: FROM T1 a
RIGHT OUTER JOIN T3 c ON (c.val = a.val)
SELECT /*+ STREAMTABLE(a) */ a.key, b.key, a.val, c.val
PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Input: default@t1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-15_685_7005957441622210859/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-09_002_2308842085626596627/-mr-10000
POSTHOOK: query: FROM T1 a
LEFT OUTER JOIN T2 b ON (b.key=a.key)
RIGHT OUTER JOIN T3 c ON (c.val = a.val)
SELECT /*+ STREAMTABLE(a) */ a.key, b.key, a.val, c.val
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-15_685_7005957441622210859/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-09_002_2308842085626596627/-mr-10000
2 2 12 12
NULL NULL NULL 14
NULL NULL NULL 16
@@ -766,20 +766,20 @@ PREHOOK: query: FROM UNIQUEJOIN
PRESERVE T3 c (c.key, c.val)
SELECT a.key, b.key, c.key
PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Input: default@t1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-24_689_644851301802156755/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-15_440_3508804411194375153/-mr-10000
POSTHOOK: query: FROM UNIQUEJOIN
PRESERVE T1 a (a.key, a.val),
PRESERVE T2 b (b.key, b.val),
PRESERVE T3 c (c.key, c.val)
SELECT a.key, b.key, c.key
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-24_689_644851301802156755/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-15_440_3508804411194375153/-mr-10000
1 NULL NULL
2 NULL 2
NULL 2 NULL
@@ -797,20 +797,20 @@ PREHOOK: query: FROM UNIQUEJOIN
PRESERVE T3 c (c.key, c.val)
SELECT /*+ STREAMTABLE(b) */ a.key, b.key, c.key
PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Input: default@t1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-30_651_4057662598234428262/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-20_053_2355797831193656267/-mr-10000
POSTHOOK: query: FROM UNIQUEJOIN
PRESERVE T1 a (a.key, a.val),
PRESERVE T2 b (b.key, b.val),
PRESERVE T3 c (c.key, c.val)
SELECT /*+ STREAMTABLE(b) */ a.key, b.key, c.key
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-30_651_4057662598234428262/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-20_053_2355797831193656267/-mr-10000
1 NULL NULL
2 NULL 2
NULL 2 NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join_reorder2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join_reorder2.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join_reorder2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join_reorder2.q.out Sun Aug 29 06:53:17 2010
@@ -178,21 +178,21 @@ FROM T1 a JOIN T2 b ON a.key = b.key
JOIN T3 c ON b.key = c.key
JOIN T4 d ON c.key = d.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@t4
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Input: default@t1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-39_475_5061641210355834290/-mr-10000
+PREHOOK: Input: default@t4
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-28_530_6753349918845883529/-mr-10000
POSTHOOK: query: SELECT /*+ STREAMTABLE(a) */ *
FROM T1 a JOIN T2 b ON a.key = b.key
JOIN T3 c ON b.key = c.key
JOIN T4 d ON c.key = d.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t4
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-39_475_5061641210355834290/-mr-10000
+POSTHOOK: Input: default@t4
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-28_530_6753349918845883529/-mr-10000
2 12 2 22 2 12 2 12
PREHOOK: query: EXPLAIN
SELECT /*+ STREAMTABLE(a) */ *
@@ -411,19 +411,19 @@ FROM T1 a JOIN T2 b ON a.key = b.key
JOIN T3 c ON a.val = c.val
JOIN T4 d ON a.key + 1 = d.key + 1
PREHOOK: type: QUERY
-PREHOOK: Input: default@t4
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Input: default@t1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-45_374_8957410892146875864/-mr-10000
+PREHOOK: Input: default@t4
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-33_450_777508846599090366/-mr-10000
POSTHOOK: query: SELECT /*+ STREAMTABLE(a) */ *
FROM T1 a JOIN T2 b ON a.key = b.key
JOIN T3 c ON a.val = c.val
JOIN T4 d ON a.key + 1 = d.key + 1
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t4
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-03-45_374_8957410892146875864/-mr-10000
+POSTHOOK: Input: default@t4
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-33_450_777508846599090366/-mr-10000
2 22 2 12 2 12 2 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join_reorder3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join_reorder3.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join_reorder3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join_reorder3.q.out Sun Aug 29 06:53:17 2010
@@ -178,21 +178,21 @@ FROM T1 a JOIN T2 b ON a.key = b.key
JOIN T3 c ON b.key = c.key
JOIN T4 d ON c.key = d.key
PREHOOK: type: QUERY
-PREHOOK: Input: default@t4
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Input: default@t1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-04-05_136_4804665682309466152/-mr-10000
+PREHOOK: Input: default@t4
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-46_655_1849254422797768428/-mr-10000
POSTHOOK: query: SELECT /*+ STREAMTABLE(a,c) */ *
FROM T1 a JOIN T2 b ON a.key = b.key
JOIN T3 c ON b.key = c.key
JOIN T4 d ON c.key = d.key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t4
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-04-05_136_4804665682309466152/-mr-10000
+POSTHOOK: Input: default@t4
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-46_655_1849254422797768428/-mr-10000
2 12 2 22 2 12 2 12
PREHOOK: query: EXPLAIN
SELECT /*+ STREAMTABLE(a,c) */ *
@@ -411,19 +411,19 @@ FROM T1 a JOIN T2 b ON a.key = b.key
JOIN T3 c ON a.val = c.val
JOIN T4 d ON a.key + 1 = d.key + 1
PREHOOK: type: QUERY
-PREHOOK: Input: default@t4
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Input: default@t1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-04-10_594_441778213826699504/-mr-10000
+PREHOOK: Input: default@t4
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-51_531_8070318925118385343/-mr-10000
POSTHOOK: query: SELECT /*+ STREAMTABLE(a,c) */ *
FROM T1 a JOIN T2 b ON a.key = b.key
JOIN T3 c ON a.val = c.val
JOIN T4 d ON a.key + 1 = d.key + 1
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t4
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-04-10_594_441778213826699504/-mr-10000
+POSTHOOK: Input: default@t4
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-06-51_531_8070318925118385343/-mr-10000
2 22 2 12 2 12 2 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out Sun Aug 29 06:53:17 2010
@@ -101,7 +101,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/nzhang/hive_2010-08-17_22-55-14_712_8459267361465490341/-mr-10002
+ file:/tmp/jsichi/hive_2010-08-26_16-08-08_217_4989832071586172776/-mr-10002
Union
Select Operator
expressions:
@@ -125,7 +125,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_l1
- file:/tmp/nzhang/hive_2010-08-17_22-55-14_712_8459267361465490341/-mr-10004
+ file:/tmp/jsichi/hive_2010-08-26_16-08-08_217_4989832071586172776/-mr-10004
Union
Select Operator
expressions:
@@ -157,7 +157,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-55-14_712_8459267361465490341/-ext-10000
+ destination: pfile:/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_16-08-08_217_4989832071586172776/-ext-10000
Stage: Stage-0
Move Operator
@@ -172,7 +172,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-17_22-55-14_712_8459267361465490341/-ext-10003
+ pfile:/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_16-08-08_217_4989832071586172776/-ext-10003
File Output Operator
compressed: false
GlobalTableId: 0
@@ -251,8 +251,8 @@ FROM (SELECT t1.key, p1.value
LEFT OUTER JOIN src p2
ON (t2.key = p2.key)) j
PREHOOK: type: QUERY
-PREHOOK: Input: default@src1
PREHOOK: Input: default@src
+PREHOOK: Input: default@src1
PREHOOK: Output: default@dest_l1
POSTHOOK: query: INSERT OVERWRITE TABLE dest_l1
SELECT j.*
@@ -266,8 +266,8 @@ FROM (SELECT t1.key, p1.value
LEFT OUTER JOIN src p2
ON (t2.key = p2.key)) j
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src1
POSTHOOK: Input: default@src
+POSTHOOK: Input: default@src1
POSTHOOK: Output: default@dest_l1
POSTHOOK: Lineage: dest_l1.key EXPRESSION [(src1)t1.FieldSchema(name:key, type:string, comment:default), (src1)t2.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_l1.value EXPRESSION [(src)p2.FieldSchema(name:value, type:string, comment:default), (src)p1.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out_0.17
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out_0.17?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out_0.17 (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out_0.17 Sun Aug 29 06:53:17 2010
@@ -101,7 +101,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-06-07_217_8924431315853651638/-mr-10002
+ file:/tmp/jsichi/hive_2010-08-27_14-01-08_880_5138753499787161938/-mr-10002
Union
Select Operator
expressions:
@@ -125,7 +125,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_l1
- file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-07-29_13-06-07_217_8924431315853651638/-mr-10004
+ file:/tmp/jsichi/hive_2010-08-27_14-01-08_880_5138753499787161938/-mr-10004
Union
Select Operator
expressions:
@@ -157,7 +157,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/scratchdir/hive_2010-07-29_13-06-07_217_8924431315853651638/-ext-10000
+ destination: pfile:/data/users/jsichi/open/commit-trunk/build/ql/scratchdir/hive_2010-08-27_14-01-08_880_5138753499787161938/-ext-10000
Stage: Stage-0
Move Operator
@@ -172,7 +172,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/scratchdir/hive_2010-07-29_13-06-07_217_8924431315853651638/-ext-10003
+ pfile:/data/users/jsichi/open/commit-trunk/build/ql/scratchdir/hive_2010-08-27_14-01-08_880_5138753499787161938/-ext-10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -264,8 +264,8 @@ FROM (SELECT t1.key, p1.value
LEFT OUTER JOIN src p2
ON (t2.key = p2.key)) j
PREHOOK: type: QUERY
-PREHOOK: Input: default@src1
PREHOOK: Input: default@src
+PREHOOK: Input: default@src1
PREHOOK: Output: default@dest_l1
POSTHOOK: query: INSERT OVERWRITE TABLE dest_l1
SELECT j.*
@@ -279,8 +279,8 @@ FROM (SELECT t1.key, p1.value
LEFT OUTER JOIN src p2
ON (t2.key = p2.key)) j
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src1
POSTHOOK: Input: default@src
+POSTHOOK: Input: default@src1
POSTHOOK: Output: default@dest_l1
POSTHOOK: Lineage: dest_l1.key EXPRESSION [(src1)t1.FieldSchema(name:key, type:string, comment:default), (src1)t2.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_l1.value EXPRESSION [(src)p2.FieldSchema(name:value, type:string, comment:default), (src)p1.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part1.q.out?rev=990499&r1=990498&r2=990499&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part1.q.out Sun Aug 29 06:53:17 2010
@@ -25,7 +25,7 @@ value string default
ds string
hr string
-Detailed Table Information Table(tableName:nzhang_part1, dbName:default, owner:null, createTime:1282245001, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/nzhang_part1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=1282245001}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:nzhang_part1, dbName:default, owner:null, createTime:1282864103, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/nzhang_part1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=1282864103}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: explain
from srcpart
insert overwrite table nzhang_part1 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08'
@@ -109,7 +109,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-19_12-10-01_577_4226133645559107864/-ext-10000
+ destination: pfile:/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_16-08-24_132_8350648338748839361/-ext-10000
Stage: Stage-0
Move Operator
@@ -127,7 +127,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-19_12-10-01_577_4226133645559107864/-ext-10004
+ pfile:/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_16-08-24_132_8350648338748839361/-ext-10004
File Output Operator
compressed: false
GlobalTableId: 0
@@ -144,7 +144,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-19_12-10-01_577_4226133645559107864/-ext-10002
+ destination: pfile:/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_16-08-24_132_8350648338748839361/-ext-10002
Stage: Stage-1
Move Operator
@@ -162,7 +162,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-08-19_12-10-01_577_4226133645559107864/-ext-10005
+ pfile:/data/users/jsichi/open/hive-trunk/build/ql/scratchdir/hive_2010-08-26_16-08-24_132_8350648338748839361/-ext-10005
File Output Operator
compressed: false
GlobalTableId: 0
@@ -189,10 +189,10 @@ POSTHOOK: Input: default@srcpart@ds=2008
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: default@nzhang_part2@ds=2008-12-31/hr=11
-POSTHOOK: Output: default@nzhang_part2@ds=2008-12-31/hr=12
POSTHOOK: Output: default@nzhang_part1@ds=2008-04-08/hr=11
POSTHOOK: Output: default@nzhang_part1@ds=2008-04-08/hr=12
+POSTHOOK: Output: default@nzhang_part2@ds=2008-12-31/hr=11
+POSTHOOK: Output: default@nzhang_part2@ds=2008-12-31/hr=12
POSTHOOK: Lineage: nzhang_part1 PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part1 PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part1 PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -233,12 +233,12 @@ PREHOOK: query: select * from nzhang_par
PREHOOK: type: QUERY
PREHOOK: Input: default@nzhang_part1@ds=2008-04-08/hr=11
PREHOOK: Input: default@nzhang_part1@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-19_12-10-12_450_5318045926499588659/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-08-33_285_7916313488954403803/-mr-10000
POSTHOOK: query: select * from nzhang_part1 where ds is not null and hr is not null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@nzhang_part1@ds=2008-04-08/hr=11
POSTHOOK: Input: default@nzhang_part1@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-19_12-10-12_450_5318045926499588659/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-08-33_285_7916313488954403803/-mr-10000
POSTHOOK: Lineage: nzhang_part1 PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part1 PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part1 PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -1251,12 +1251,12 @@ PREHOOK: query: select * from nzhang_par
PREHOOK: type: QUERY
PREHOOK: Input: default@nzhang_part2@ds=2008-12-31/hr=11
PREHOOK: Input: default@nzhang_part2@ds=2008-12-31/hr=12
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-19_12-10-12_966_4486180906903303996/-mr-10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-08-33_856_4074078546892062221/-mr-10000
POSTHOOK: query: select * from nzhang_part2 where ds is not null and hr is not null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@nzhang_part2@ds=2008-12-31/hr=11
POSTHOOK: Input: default@nzhang_part2@ds=2008-12-31/hr=12
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-19_12-10-12_966_4486180906903303996/-mr-10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-26_16-08-33_856_4074078546892062221/-mr-10000
POSTHOOK: Lineage: nzhang_part1 PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part1 PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part1 PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]