You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by nz...@apache.org on 2010/07/23 01:57:42 UTC
svn commit: r966909 [21/27] - in /hadoop/hive/trunk: ./ contrib/
data/warehouse/src/ hbase-handler/ hwi/ jdbc/ odbc/ ql/
ql/src/test/org/apache/hadoop/hive/ql/ ql/src/test/queries/clientnegative/
ql/src/test/queries/clientpositive/ ql/src/test/results/...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/loadpart1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/loadpart1.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/loadpart1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/loadpart1.q.out Thu Jul 22 23:57:29 2010
@@ -1,11 +1,3 @@
-PREHOOK: query: drop table hive_test_src
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table hive_test_src
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table hive_test_dst
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table hive_test_dst
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table hive_test_src ( col1 string ) stored as textfile
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table hive_test_src ( col1 string ) stored as textfile
@@ -33,11 +25,11 @@ POSTHOOK: Lineage: hive_test_dst PARTITI
PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_Part'
PREHOOK: type: QUERY
PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-18-27_161_4058867181423672724/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-40-08_582_5840765576374175576/10000
POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_Part'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-18-27_161_4058867181423672724/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-40-08_582_5840765576374175576/10000
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
1 test_part test_Part
2 test_part test_Part
@@ -57,20 +49,20 @@ POSTHOOK: Lineage: hive_test_dst PARTITI
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part'
PREHOOK: type: QUERY
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-18-32_005_7262990256756311796/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-40-11_329_4921545927597783630/10000
POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part'
POSTHOOK: type: QUERY
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-18-32_005_7262990256756311796/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-40-11_329_4921545927597783630/10000
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: select * from hive_test_dst where pcol1='test_part'
PREHOOK: type: QUERY
PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-18-32_055_1756029915176080993/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-40-11_375_7311986483705850817/10000
POSTHOOK: query: select * from hive_test_dst where pcol1='test_part'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-18-32_055_1756029915176080993/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-40-11_375_7311986483705850817/10000
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
1 test_part test_Part
@@ -81,31 +73,17 @@ POSTHOOK: Lineage: hive_test_dst PARTITI
6 test_part test_Part
PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part'
PREHOOK: type: QUERY
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-18-32_130_4753679815952473777/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-40-11_440_6906366422294316277/10000
POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part'
POSTHOOK: type: QUERY
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-18-32_130_4753679815952473777/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-40-11_440_6906366422294316277/10000
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: select * from hive_test_dst where pcol1='test_Part'
PREHOOK: type: QUERY
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-18-32_181_3514948387985518789/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-40-11_474_301584563410557410/10000
POSTHOOK: query: select * from hive_test_dst where pcol1='test_Part'
POSTHOOK: type: QUERY
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-18-32_181_3514948387985518789/10000
-POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
-POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
-PREHOOK: query: drop table hive_test_src
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table hive_test_src
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@hive_test_src
-POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
-POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
-PREHOOK: query: drop table hive_test_dst
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table hive_test_dst
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@hive_test_dst
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-40-11_474_301584563410557410/10000
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/loadpart_err.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/loadpart_err.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/loadpart_err.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/loadpart_err.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: DROP TABLE loadpart1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE loadpart1
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE loadpart1(a STRING, b STRING) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE loadpart1(a STRING, b STRING) PARTITIONED BY (ds STRING)
@@ -25,13 +21,8 @@ PREHOOK: query: SHOW PARTITIONS loadpart
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: SHOW PARTITIONS loadpart1
POSTHOOK: type: SHOWPARTITIONS
-FAILED: Error in semantic analysis: line 3:23 Invalid Path '../data1/files/kv1.txt': No files matching path file:/data/users/njain/hive5/hive5/data1/files/kv1.txt
+FAILED: Error in semantic analysis: line 3:23 Invalid Path '../data1/files/kv1.txt': No files matching path file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/data1/files/kv1.txt
PREHOOK: query: SHOW PARTITIONS loadpart1
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: SHOW PARTITIONS loadpart1
POSTHOOK: type: SHOWPARTITIONS
-PREHOOK: query: DROP TABLE loadpart1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE loadpart1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@loadpart1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/merge1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/merge1.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/merge1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/merge1.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: drop table dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest1
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table dest1(key int, val int)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table dest1(key int, val int)
@@ -98,7 +94,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-19-12_103_8509010210619285541/10000
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_13-01-35_891_8961223626140768169/10000
Stage: Stage-0
Move Operator
@@ -113,7 +109,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-19-12_103_8509010210619285541/10002
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_13-01-35_891_8961223626140768169/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -152,11 +148,11 @@ POSTHOOK: Lineage: dest1.val EXPRESSION
PREHOOK: query: select * from dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-19-16_584_5540363340401862209/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-01-38_782_3169792692854776166/10000
POSTHOOK: query: select * from dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-19-16_584_5540363340401862209/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-01-38_782_3169792692854776166/10000
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.val EXPRESSION [(src)src.null, ]
0 3
@@ -565,7 +561,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-19-26_073_2981993365400111398/10000
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_13-01-44_324_4141481189577468/10000
Stage: Stage-0
Move Operator
@@ -580,7 +576,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-19-26_073_2981993365400111398/10002
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_13-01-44_324_4141481189577468/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -670,7 +666,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-19-35_067_370016273932178726/10000
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_13-01-49_887_6167797302674604272/10000
Stage: Stage-0
Move Operator
@@ -685,7 +681,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-19-35_067_370016273932178726/10002
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_13-01-49_887_6167797302674604272/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -725,29 +721,3 @@ POSTHOOK: Lineage: test_src PARTITION(ds
POSTHOOK: Lineage: test_src PARTITION(ds=101).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: test_src PARTITION(ds=102).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: test_src PARTITION(ds=102).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: drop table test_src
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table test_src
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@test_src
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.key SIMPLE [(test_src)test_src.FieldSchema(name:ds, type:string, comment:null), ]
-POSTHOOK: Lineage: dest1.key SIMPLE [(test_src)test_src.FieldSchema(name:ds, type:string, comment:null), ]
-POSTHOOK: Lineage: dest1.val EXPRESSION [(src)src.null, ]
-POSTHOOK: Lineage: test_src PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: test_src PARTITION(ds=101).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: test_src PARTITION(ds=102).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: test_src PARTITION(ds=102).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: drop table dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.key SIMPLE [(test_src)test_src.FieldSchema(name:ds, type:string, comment:null), ]
-POSTHOOK: Lineage: dest1.key SIMPLE [(test_src)test_src.FieldSchema(name:ds, type:string, comment:null), ]
-POSTHOOK: Lineage: dest1.val EXPRESSION [(src)src.null, ]
-POSTHOOK: Lineage: test_src PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: test_src PARTITION(ds=101).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: test_src PARTITION(ds=102).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: test_src PARTITION(ds=102).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out Thu Jul 22 23:57:29 2010
@@ -1,11 +1,3 @@
-PREHOOK: query: drop table src_multi1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table src_multi1
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table src_multi2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table src_multi2
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table src_multi1 like src
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table src_multi1 like src
@@ -122,11 +114,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-18-34_250_2581601890579997147/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-21_712_5062335963199774462/10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-18-34_250_2581601890579997147/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-21_712_5062335963199774462/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -144,11 +136,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-18-38_695_3600146020464319543/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-24_226_5046921944761310383/10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-18-38_695_3600146020464319543/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-24_226_5046921944761310383/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -243,7 +235,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-18-43_573_8372259879569928385/10000
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-41-26_695_7647953576858754386/10000
Stage: Stage-0
Move Operator
@@ -258,7 +250,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-18-43_573_8372259879569928385/10004
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-41-26_695_7647953576858754386/10004
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -288,7 +280,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-18-43_573_8372259879569928385/10002
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-41-26_695_7647953576858754386/10002
Stage: Stage-1
Move Operator
@@ -303,7 +295,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-18-43_573_8372259879569928385/10005
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-41-26_695_7647953576858754386/10005
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -352,11 +344,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-18-49_456_7216820125442151889/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-29_398_374250277965899089/10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-18-49_456_7216820125442151889/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-29_398_374250277965899089/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -378,11 +370,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-18-53_629_1156332665615404428/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-31_972_5943245082125077624/10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-18-53_629_1156332665615404428/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-31_972_5943245082125077624/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -522,11 +514,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-03_446_7449215537744570078/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-37_232_5055054932535323703/10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-03_446_7449215537744570078/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-37_232_5055054932535323703/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -552,11 +544,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-09_158_6457821197220351304/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-39_724_5919666556486138657/10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-09_158_6457821197220351304/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-39_724_5919666556486138657/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -667,7 +659,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-14_113_8938827832591803037/10000
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-41-42_204_3144075225672991179/10000
Stage: Stage-0
Move Operator
@@ -682,7 +674,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-14_113_8938827832591803037/10004
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-41-42_204_3144075225672991179/10004
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -712,7 +704,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-14_113_8938827832591803037/10002
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-41-42_204_3144075225672991179/10002
Stage: Stage-1
Move Operator
@@ -727,7 +719,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-14_113_8938827832591803037/10005
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-41-42_204_3144075225672991179/10005
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -784,11 +776,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-19_486_1592932188566236916/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-44_892_3027065579813818242/10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-19_486_1592932188566236916/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-44_892_3027065579813818242/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -818,11 +810,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-23_513_9027380053403100599/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-47_356_9057856219474591094/10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-23_513_9027380053403100599/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-47_356_9057856219474591094/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -988,7 +980,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-27_834_3545130340055692875/10004
+ file:/tmp/jssarma/hive_2010-07-21_11-41-49_873_5452620989462977001/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -1076,11 +1068,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-37_004_7588365783973531047/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-55_158_3039517705245630432/10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-37_004_7588365783973531047/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-55_158_3039517705245630432/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1110,11 +1102,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-41_063_7955882570645843879/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-57_720_498471983118793979/10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-41_063_7955882570645843879/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-41-57_720_498471983118793979/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1285,7 +1277,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-44_979_7633672053254257151/10000
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-00_181_6805544255394938954/10000
Stage: Stage-0
Move Operator
@@ -1300,7 +1292,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-44_979_7633672053254257151/10004
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-00_181_6805544255394938954/10004
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -1326,7 +1318,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-44_979_7633672053254257151/10005
+ file:/tmp/jssarma/hive_2010-07-21_11-42-00_181_6805544255394938954/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -1373,7 +1365,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-44_979_7633672053254257151/10002
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-00_181_6805544255394938954/10002
Stage: Stage-1
Move Operator
@@ -1388,7 +1380,7 @@ STAGE PLANS:
Stage: Stage-7
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-44_979_7633672053254257151/10006
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-00_181_6805544255394938954/10006
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -1453,11 +1445,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-53_503_2476681795898723280/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-05_457_2938335370779332907/10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-53_503_2476681795898723280/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-05_457_2938335370779332907/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1491,11 +1483,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-57_919_4446429596950029445/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-07_979_1197234407834858516/10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-19-57_919_4446429596950029445/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-07_979_1197234407834858516/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1674,7 +1666,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-02_655_8851495220285705466/10004
+ file:/tmp/jssarma/hive_2010-07-21_11-42-10_540_8287802089011554187/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -1770,11 +1762,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-14_001_2137537666402080168/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-15_956_8233613409144913424/10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-14_001_2137537666402080168/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-15_956_8233613409144913424/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1812,11 +1804,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-18_582_608052595593605574/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-18_525_6028070244185370122/10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-18_582_608052595593605574/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-18_525_6028070244185370122/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2003,7 +1995,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-22_841_8682732744441489601/10000
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-21_003_5167136917621088373/10000
Stage: Stage-0
Move Operator
@@ -2018,7 +2010,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-22_841_8682732744441489601/10004
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-21_003_5167136917621088373/10004
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -2044,7 +2036,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-22_841_8682732744441489601/10005
+ file:/tmp/jssarma/hive_2010-07-21_11-42-21_003_5167136917621088373/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -2091,7 +2083,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-22_841_8682732744441489601/10002
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-21_003_5167136917621088373/10002
Stage: Stage-1
Move Operator
@@ -2106,7 +2098,7 @@ STAGE PLANS:
Stage: Stage-7
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-22_841_8682732744441489601/10006
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-21_003_5167136917621088373/10006
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -2179,11 +2171,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-32_932_5517499324893028633/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-26_240_3559046036845532/10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-32_932_5517499324893028633/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-26_240_3559046036845532/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2225,11 +2217,11 @@ POSTHOOK: Lineage: src_multi2.value SIMP
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-37_148_3376220707415365030/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-28_796_451544540094033007/10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-37_148_3376220707415365030/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-28_796_451544540094033007/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2495,11 +2487,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-45_663_5087600964304715840/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-34_097_7757454628091368486/10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-45_663_5087600964304715840/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-34_097_7757454628091368486/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2559,11 +2551,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-49_404_8405829546880992933/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-36_786_8996732990789151375/10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-49_404_8405829546880992933/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-36_786_8996732990789151375/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2788,7 +2780,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-53_509_6333015869581777161/10000
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-39_255_2282025271684185143/10000
Stage: Stage-0
Move Operator
@@ -2803,7 +2795,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-53_509_6333015869581777161/10004
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-39_255_2282025271684185143/10004
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -2833,7 +2825,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-53_509_6333015869581777161/10002
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-39_255_2282025271684185143/10002
Stage: Stage-1
Move Operator
@@ -2848,7 +2840,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-53_509_6333015869581777161/10005
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-39_255_2282025271684185143/10005
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -2929,11 +2921,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-58_931_9046309055063469540/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-42_021_1773614549788907879/10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-20-58_931_9046309055063469540/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-42_021_1773614549788907879/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -2997,11 +2989,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-02_917_8039712053222808218/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-44_498_2123904018906456758/10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-02_917_8039712053222808218/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-44_498_2123904018906456758/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -3303,11 +3295,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-26_449_7713657971977228391/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-49_805_7878050643299431709/10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-26_449_7713657971977228391/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-49_805_7878050643299431709/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -3375,11 +3367,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-30_393_5944254380728218238/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-52_268_1999896450202641016/10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-30_393_5944254380728218238/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-52_268_1999896450202641016/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -3620,7 +3612,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-34_989_7490461749283801722/10000
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-54_799_7180997344452135463/10000
Stage: Stage-0
Move Operator
@@ -3635,7 +3627,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-34_989_7490461749283801722/10004
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-54_799_7180997344452135463/10004
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -3665,7 +3657,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-34_989_7490461749283801722/10002
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-54_799_7180997344452135463/10002
Stage: Stage-1
Move Operator
@@ -3680,7 +3672,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-34_989_7490461749283801722/10005
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-42-54_799_7180997344452135463/10005
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -3769,11 +3761,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-40_465_8017594571024915624/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-57_592_4817069631526155036/10000
POSTHOOK: query: select * from src_multi1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-40_465_8017594571024915624/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-42-57_592_4817069631526155036/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -3845,11 +3837,11 @@ POSTHOOK: Lineage: src_multi2.value EXPR
PREHOOK: query: select * from src_multi2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-43_966_4724737620338694550/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-00_113_6879485217176937186/10000
POSTHOOK: query: select * from src_multi2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-21-43_966_4724737620338694550/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-00_113_6879485217176937186/10000
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/null_column.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/null_column.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/null_column.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/null_column.q.out Thu Jul 22 23:57:29 2010
@@ -1,15 +1,3 @@
-PREHOOK: query: drop table temp_null
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table temp_null
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table tt
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tt
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table tt_b
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tt_b
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table temp_null(a int) stored as textfile
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table temp_null(a int) stored as textfile
@@ -23,11 +11,11 @@ POSTHOOK: Output: default@temp_null
PREHOOK: query: select null, null from temp_null
PREHOOK: type: QUERY
PREHOOK: Input: default@temp_null
-PREHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-11-46_460_130526701412066561/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-29_063_5497458015896967287/10000
POSTHOOK: query: select null, null from temp_null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@temp_null
-POSTHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-11-46_460_130526701412066561/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-29_063_5497458015896967287/10000
NULL NULL
NULL NULL
NULL NULL
@@ -52,11 +40,11 @@ POSTHOOK: Lineage: tt.b SIMPLE []
PREHOOK: query: select * from tt
PREHOOK: type: QUERY
PREHOOK: Input: default@tt
-PREHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-11-54_210_4646908468388375810/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-34_033_7899160687995145341/10000
POSTHOOK: query: select * from tt
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tt
-POSTHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-11-54_210_4646908468388375810/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-34_033_7899160687995145341/10000
POSTHOOK: Lineage: tt.a EXPRESSION []
POSTHOOK: Lineage: tt.b SIMPLE []
NULL NULL
@@ -87,11 +75,11 @@ POSTHOOK: Lineage: tt_b.b EXPRESSION []
PREHOOK: query: select * from tt_b
PREHOOK: type: QUERY
PREHOOK: Input: default@tt_b
-PREHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-11-58_088_4831793622839318296/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-36_556_8509051297680496039/10000
POSTHOOK: query: select * from tt_b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tt_b
-POSTHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-11-58_088_4831793622839318296/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-36_556_8509051297680496039/10000
POSTHOOK: Lineage: tt.a EXPRESSION []
POSTHOOK: Lineage: tt.b SIMPLE []
POSTHOOK: Lineage: tt_b.a EXPRESSION []
@@ -120,14 +108,6 @@ POSTHOOK: Lineage: tt_b.b EXPRESSION []
\N\N
\N\N
\N\N
-PREHOOK: query: drop table temp_null2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table temp_null2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Lineage: tt.a EXPRESSION []
-POSTHOOK: Lineage: tt.b SIMPLE []
-POSTHOOK: Lineage: tt_b.a EXPRESSION []
-POSTHOOK: Lineage: tt_b.b EXPRESSION []
PREHOOK: query: create table temp_null2 (key string, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table temp_null2 (key string, value string) partitioned by (ds string)
@@ -154,11 +134,11 @@ POSTHOOK: Lineage: tt_b.b EXPRESSION []
PREHOOK: query: select * from temp_null2 where ds is not null
PREHOOK: type: QUERY
PREHOOK: Input: default@temp_null2@ds=2010-04-01
-PREHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-12-05_597_2273874996761576508/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-41_617_3166554512331390680/10000
POSTHOOK: query: select * from temp_null2 where ds is not null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@temp_null2@ds=2010-04-01
-POSTHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-12-05_597_2273874996761576508/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-41_617_3166554512331390680/10000
POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).key SIMPLE []
POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).value SIMPLE []
POSTHOOK: Lineage: tt.a EXPRESSION []
@@ -166,47 +146,3 @@ POSTHOOK: Lineage: tt.b SIMPLE []
POSTHOOK: Lineage: tt_b.a EXPRESSION []
POSTHOOK: Lineage: tt_b.b EXPRESSION []
1 NULL 2010-04-01
-PREHOOK: query: drop table tt
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tt
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tt
-POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).key SIMPLE []
-POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).value SIMPLE []
-POSTHOOK: Lineage: tt.a EXPRESSION []
-POSTHOOK: Lineage: tt.b SIMPLE []
-POSTHOOK: Lineage: tt_b.a EXPRESSION []
-POSTHOOK: Lineage: tt_b.b EXPRESSION []
-PREHOOK: query: drop table tt_b
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tt_b
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tt_b
-POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).key SIMPLE []
-POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).value SIMPLE []
-POSTHOOK: Lineage: tt.a EXPRESSION []
-POSTHOOK: Lineage: tt.b SIMPLE []
-POSTHOOK: Lineage: tt_b.a EXPRESSION []
-POSTHOOK: Lineage: tt_b.b EXPRESSION []
-PREHOOK: query: drop table temp_null
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table temp_null
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@temp_null
-POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).key SIMPLE []
-POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).value SIMPLE []
-POSTHOOK: Lineage: tt.a EXPRESSION []
-POSTHOOK: Lineage: tt.b SIMPLE []
-POSTHOOK: Lineage: tt_b.a EXPRESSION []
-POSTHOOK: Lineage: tt_b.b EXPRESSION []
-PREHOOK: query: drop table temp_null2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table temp_null2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@temp_null2
-POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).key SIMPLE []
-POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).value SIMPLE []
-POSTHOOK: Lineage: tt.a EXPRESSION []
-POSTHOOK: Lineage: tt.b SIMPLE []
-POSTHOOK: Lineage: tt_b.a EXPRESSION []
-POSTHOOK: Lineage: tt_b.b EXPRESSION []
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: DROP TABLE tstparttbl
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE tstparttbl
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
@@ -78,17 +74,13 @@ PREHOOK: query: select count(1) from tst
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl@ds=2008-04-08
PREHOOK: Input: default@tstparttbl@ds=2008-04-09
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/429292939/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-11_573_4565213151672229951/10000
POSTHOOK: query: select count(1) from tstparttbl
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl@ds=2008-04-08
POSTHOOK: Input: default@tstparttbl@ds=2008-04-09
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/429292939/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-11_573_4565213151672229951/10000
500
-PREHOOK: query: DROP TABLE tstparttbl2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE tstparttbl2
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
@@ -165,12 +157,12 @@ PREHOOK: query: select count(1) from tst
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl2@ds=2008-04-08
PREHOOK: Input: default@tstparttbl2@ds=2008-04-09
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/675788842/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-14_641_615139224470628595/10000
POSTHOOK: query: select count(1) from tstparttbl2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl2@ds=2008-04-08
POSTHOOK: Input: default@tstparttbl2@ds=2008-04-09
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/675788842/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-14_641_615139224470628595/10000
0
PREHOOK: query: DROP TABLE tstparttbl
PREHOOK: type: DROPTABLE
@@ -253,12 +245,12 @@ PREHOOK: query: select count(1) from tst
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl@ds=2008-04-08
PREHOOK: Input: default@tstparttbl@ds=2008-04-09
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1506435272/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-17_697_2205434267515314781/10000
POSTHOOK: query: select count(1) from tstparttbl
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl@ds=2008-04-08
POSTHOOK: Input: default@tstparttbl@ds=2008-04-09
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1506435272/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-17_697_2205434267515314781/10000
500
PREHOOK: query: DROP TABLE tstparttbl2
PREHOOK: type: DROPTABLE
@@ -341,20 +333,10 @@ PREHOOK: query: select count(1) from tst
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl2@ds=2008-04-08
PREHOOK: Input: default@tstparttbl2@ds=2008-04-09
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1727986109/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-20_708_4976141185424807073/10000
POSTHOOK: query: select count(1) from tstparttbl2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl2@ds=2008-04-08
POSTHOOK: Input: default@tstparttbl2@ds=2008-04-09
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1727986109/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-20_708_4976141185424807073/10000
0
-PREHOOK: query: DROP TABLE tstparttbl
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE tstparttbl
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tstparttbl
-PREHOOK: query: DROP TABLE tstparttbl2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE tstparttbl2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tstparttbl2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup5.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup5.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: DROP TABLE tstparttbl
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE tstparttbl
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
@@ -12,10 +8,6 @@ PREHOOK: type: LOAD
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2009-04-09')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@tstparttbl@ds=2009-04-09
-PREHOOK: query: DROP TABLE tstparttbl2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE tstparttbl2
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
@@ -131,7 +123,7 @@ PREHOOK: query: select u.* from
)u
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl2@ds=2009-04-09
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/379898854/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-39_608_1509511246265009929/10000
POSTHOOK: query: select u.* from
(
select key, value from tstparttbl x where x.ds='2009-04-05'
@@ -140,7 +132,7 @@ POSTHOOK: query: select u.* from
)u
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl2@ds=2009-04-09
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/379898854/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-39_608_1509511246265009929/10000
238 val_238
86 val_86
311 val_311
@@ -641,13 +633,3 @@ POSTHOOK: Output: file:/data/users/njain
400 val_400
200 val_200
97 val_97
-PREHOOK: query: DROP TABLE tstparttbl
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE tstparttbl
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tstparttbl
-PREHOOK: query: DROP TABLE tstparttbl2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE tstparttbl2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tstparttbl2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullinput.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullinput.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullinput.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullinput.q.out Thu Jul 22 23:57:29 2010
@@ -6,21 +6,16 @@ POSTHOOK: Output: default@tstnullinut
PREHOOK: query: select x.* from tstnullinut x
PREHOOK: type: QUERY
PREHOOK: Input: default@tstnullinut
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1976338873/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-42_572_4519312906185121533/10000
POSTHOOK: query: select x.* from tstnullinut x
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstnullinut
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1976338873/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-42_572_4519312906185121533/10000
PREHOOK: query: select x.a, count(1) from tstnullinut x group by x.a
PREHOOK: type: QUERY
PREHOOK: Input: default@tstnullinut
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1008263015/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-42_620_1570615621828082286/10000
POSTHOOK: query: select x.a, count(1) from tstnullinut x group by x.a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstnullinut
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1008263015/10000
-PREHOOK: query: drop table tstnullinut
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tstnullinut
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tstnullinut
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-42_620_1570615621828082286/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullinput2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullinput2.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullinput2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullinput2.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: drop table nulltbl
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table nulltbl
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table nulltbl(key int) partitioned by (ds string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table nulltbl(key int) partitioned by (ds string)
@@ -9,19 +5,14 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@nulltbl
PREHOOK: query: select key from nulltbl where ds='101'
PREHOOK: type: QUERY
-PREHOOK: Output: file:/data/users/njain/hive1/hive1/build/ql/tmp/1897224698/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-45_538_2037787558373086452/10000
POSTHOOK: query: select key from nulltbl where ds='101'
POSTHOOK: type: QUERY
-POSTHOOK: Output: file:/data/users/njain/hive1/hive1/build/ql/tmp/1897224698/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-45_538_2037787558373086452/10000
PREHOOK: query: select count(1) from nulltbl where ds='101'
PREHOOK: type: QUERY
-PREHOOK: Output: file:/data/users/njain/hive1/hive1/build/ql/tmp/1803910053/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-48_052_5788292989741758557/10000
POSTHOOK: query: select count(1) from nulltbl where ds='101'
POSTHOOK: type: QUERY
-POSTHOOK: Output: file:/data/users/njain/hive1/hive1/build/ql/tmp/1803910053/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-48_052_5788292989741758557/10000
0
-PREHOOK: query: drop table nulltbl
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table nulltbl
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@nulltbl
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullscript.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullscript.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullscript.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullscript.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: DROP TABLE nullscript
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE nullscript
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE nullscript(KEY STRING, VALUE STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE nullscript(KEY STRING, VALUE STRING) STORED AS TEXTFILE
@@ -62,11 +58,11 @@ STAGE PLANS:
PREHOOK: query: select transform(key) using '/bin/cat' as key1 from nullscript
PREHOOK: type: QUERY
PREHOOK: Input: default@nullscript
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/109237316/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-51_131_1687271560149359862/10000
POSTHOOK: query: select transform(key) using '/bin/cat' as key1 from nullscript
POSTHOOK: type: QUERY
POSTHOOK: Input: default@nullscript
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/109237316/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-51_131_1687271560149359862/10000
238
86
311
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: drop table partition_vs_table
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table partition_vs_table
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table partition_vs_table(key string, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table partition_vs_table(key string, value string) partitioned by (ds string)
@@ -43,13 +39,13 @@ order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_vs_table@ds=100
PREHOOK: Input: default@partition_vs_table@ds=101
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-23-19_287_8020563381793175788/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-45-18_342_8996179008267998708/10000
POSTHOOK: query: select key, value, newcol from partition_vs_table
order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_vs_table@ds=100
POSTHOOK: Input: default@partition_vs_table@ds=101
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-23-19_287_8020563381793175788/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-45-18_342_8996179008267998708/10000
POSTHOOK: Lineage: partition_vs_table PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_vs_table PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_vs_table PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1055,13 +1051,3 @@ POSTHOOK: Lineage: partition_vs_table PA
98 val_98 NULL
98 val_98 98
98 val_98 98
-PREHOOK: query: drop table partition_vs_table
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table partition_vs_table
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@partition_vs_table
-POSTHOOK: Lineage: partition_vs_table PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_vs_table PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_vs_table PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_vs_table PARTITION(ds=101).newcol SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_vs_table PARTITION(ds=101).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]