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 2009/08/11 04:06:32 UTC
svn commit: r802976 [8/17] - in /hadoop/hive/trunk: ./
common/src/java/org/apache/hadoop/hive/conf/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/lib/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/...
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out?rev=802976&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out Tue Aug 11 02:06:23 2009
@@ -0,0 +1,430 @@
+query: EXPLAIN EXTENDED
+ FROM
+ src a
+ FULL OUTER JOIN
+ srcpart b
+ ON (a.key = b.key AND b.ds = '2008-04-08')
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_TABREF src a) (TOK_TABREF srcpart b) (AND (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)) (= (. (TOK_TABLE_OR_COL b) ds) '2008-04-08')))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) value))) (TOK_WHERE (AND (AND (AND (> (. (TOK_TABLE_OR_COL a) key) 10) (< (. (TOK_TABLE_OR_COL a) key) 20)) (> (. (TOK_TABLE_OR_COL b) key) 15)) (< (. (TOK_TABLE_OR_COL b) key) 25)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ b
+ TableScan
+ alias: b
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: (ds = '2008-04-08')
+ type: boolean
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: (ds = '2008-04-08')
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ a
+ TableScan
+ alias: a
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Needs Tagging: true
+ Path -> Alias:
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ Path -> Partition:
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 11
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ columns.types string:string
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: srcpart
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 12
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ columns.types string:string
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: srcpart
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ Partition
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name src
+ columns.types string:string
+ serialization.ddl struct src { string key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: src
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Outer Join 0 to 1
+ condition expressions:
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: ((((UDFToDouble(_col0) > UDFToDouble(10)) and (UDFToDouble(_col0) < UDFToDouble(20))) and (UDFToDouble(_col2) > UDFToDouble(15))) and (UDFToDouble(_col2) < UDFToDouble(25)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/520891215/10001
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ columns _col0,_col1,_col2,_col3
+ serialization.format 1
+ columns.types string:string:string:string
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+query: FROM
+ src a
+ FULL OUTER JOIN
+ srcpart b
+ ON (a.key = b.key AND b.ds = '2008-04-08')
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
+Input: default/srcpart/ds=2008-04-08/hr=11
+Input: default/srcpart/ds=2008-04-08/hr=12
+Input: default/src
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/630976667/10000
+17 val_17 17 val_17
+17 val_17 17 val_17
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+19 val_19 19 val_19
+19 val_19 19 val_19
+query: EXPLAIN EXTENDED
+ FROM
+ src a
+ FULL OUTER JOIN
+ srcpart b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08'
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_TABREF src a) (TOK_TABREF srcpart b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) value))) (TOK_WHERE (AND (AND (AND (AND (> (. (TOK_TABLE_OR_COL a) key) 10) (< (. (TOK_TABLE_OR_COL a) key) 20)) (> (. (TOK_TABLE_OR_COL b) key) 15)) (< (. (TOK_TABLE_OR_COL b) key) 25)) (= (. (TOK_TABLE_OR_COL b) ds) '2008-04-08')))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ b
+ TableScan
+ alias: b
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ a
+ TableScan
+ alias: a
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Needs Tagging: true
+ Path -> Alias:
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ Path -> Partition:
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 11
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ columns.types string:string
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: srcpart
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 12
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ columns.types string:string
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: srcpart
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ Partition
+ partition values:
+ ds 2008-04-09
+ hr 11
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ columns.types string:string
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: srcpart
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ Partition
+ partition values:
+ ds 2008-04-09
+ hr 12
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ columns.types string:string
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: srcpart
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ Partition
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name src
+ columns.types string:string
+ serialization.ddl struct src { string key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: src
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Outer Join 0 to 1
+ condition expressions:
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: (((((UDFToDouble(_col0) > UDFToDouble(10)) and (UDFToDouble(_col0) < UDFToDouble(20))) and (UDFToDouble(_col2) > UDFToDouble(15))) and (UDFToDouble(_col2) < UDFToDouble(25))) and (_col4 = '2008-04-08'))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1312771848/10001
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ columns _col0,_col1,_col2,_col3
+ serialization.format 1
+ columns.types string:string:string:string
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+query: FROM
+ src a
+ FULL OUTER JOIN
+ srcpart b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08'
+Input: default/srcpart/ds=2008-04-08/hr=11
+Input: default/srcpart/ds=2008-04-08/hr=12
+Input: default/srcpart/ds=2008-04-09/hr=11
+Input: default/srcpart/ds=2008-04-09/hr=12
+Input: default/src
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2067779225/10000
+17 val_17 17 val_17
+17 val_17 17 val_17
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+19 val_19 19 val_19
+19 val_19 19 val_19
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd1.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd1.q.out Tue Aug 11 02:06:23 2009
@@ -12,6 +12,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (key > '2')
@@ -39,7 +41,7 @@
query: SELECT src.key as c3 from src where src.key > '2'
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1708124764/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1622609719/10000
238
86
311
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out Tue Aug 11 02:06:23 2009
@@ -12,6 +12,8 @@
Map Reduce
Alias -> Map Operator Tree:
x
+ TableScan
+ alias: x
Filter Operator
predicate:
expr: (UDFToDouble(key) = UDFToDouble(10))
@@ -57,7 +59,7 @@
query: SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/146577013/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/661923183/10000
10 val_10
query: EXPLAIN
SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
@@ -74,6 +76,8 @@
Map Reduce
Alias -> Map Operator Tree:
y
+ TableScan
+ alias: y
Reduce Output Operator
key expressions:
expr: key
@@ -87,6 +91,8 @@
expr: key
type: string
x
+ TableScan
+ alias: x
Filter Operator
predicate:
expr: (UDFToDouble(key) = UDFToDouble(20))
@@ -136,7 +142,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1806574549/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/610411732/10002
Reduce Output Operator
key expressions:
expr: _col1
@@ -169,5 +175,5 @@
query: SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/484426586/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/235995833/10000
20 val_20 20
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src1
+ TableScan
+ alias: src1
Select Operator
expressions:
expr: (UDFToDouble(4) + null)
@@ -48,10 +50,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1808398705/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/194859935/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1179440766/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1903200653/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -93,7 +95,7 @@
Output: default/ppd_constant_expr
query: SELECT ppd_constant_expr.* FROM ppd_constant_expr
Input: default/ppd_constant_expr
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/2078786594/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/869842043/10000
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src1:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: ((value > 'val_10') and (value > 'val_200'))
@@ -92,7 +94,7 @@
(SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1
WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400')
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/485117888/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1347130772/10000
val_201
val_202
val_203
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out Tue Aug 11 02:06:23 2009
@@ -17,6 +17,8 @@
Map Reduce
Alias -> Map Operator Tree:
src1:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: ((value > 'val_10') and (value > 'val_200'))
@@ -97,7 +99,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1032558559/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1187596438/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -144,7 +146,7 @@
WHERE src1.c1 > 'val_200' AND (src1.c2 > 30 OR src1.c1 < 'val_400')
GROUP BY src1.c2
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/502393484/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/825792285/10000
val_4 1
val_399 2
val_396 3
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out Tue Aug 11 02:06:23 2009
@@ -20,6 +20,8 @@
Map Reduce
Alias -> Map Operator Tree:
src2:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: ((key > '2') and (key <> '4'))
@@ -46,6 +48,8 @@
expr: _col0
type: string
src1:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (((key > '1') and (key < '400')) and ((key > '20') and ((value < 'val_50') or (key > '2'))))
@@ -114,7 +118,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/119836077/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1620295142/10002
Reduce Output Operator
key expressions:
expr: _col0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out Tue Aug 11 02:06:23 2009
@@ -18,6 +18,8 @@
Map Reduce
Alias -> Map Operator Tree:
src2:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: ((key > '2') and (key <> '4'))
@@ -48,6 +50,8 @@
expr: _col1
type: string
src1:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (((key > '1') and (key < '400')) and ((key > '20') and ((value < 'val_50') or (key > '2'))))
@@ -120,7 +124,7 @@
ON src1.c1 = src2.c3 AND src1.c1 < '400'
WHERE src1.c1 > '20' and (src1.c2 < 'val_50' or src1.c1 > '2') and (src2.c3 > '50' or src1.c1 < '50') and (src2.c3 <> '4')
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/694942086/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1128518264/10000
200 val_200
200 val_200
200 val_200
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out Tue Aug 11 02:06:23 2009
@@ -22,6 +22,8 @@
Map Reduce
Alias -> Map Operator Tree:
src2:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: ((key <> '305') and (key <> '14'))
@@ -52,6 +54,8 @@
expr: _col1
type: string
src1:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (((key <> '302') and (key < '400')) and ((key <> '311') and ((value <> 'val_50') or (key > '1'))))
@@ -123,6 +127,8 @@
expr: _col1
type: string
src3:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: ((key <> '306') and (sqrt(UDFToDouble(key)) <> UDFToDouble(13)))
@@ -192,7 +198,7 @@
ON src1.c2 = src3.c6
WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13)
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_3/build/ql/tmp/637459314/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1783863777/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out Tue Aug 11 02:06:23 2009
@@ -21,6 +21,8 @@
Map Reduce
Alias -> Map Operator Tree:
src2:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: ((key <> '12') and (key <> '4'))
@@ -51,6 +53,8 @@
expr: _col1
type: string
src1:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (((key <> '11') and (key < '400')) and ((key > '0') and ((value <> 'val_500') or (key > '1'))))
@@ -85,6 +89,8 @@
expr: _col1
type: string
src3:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: ((key <> '13') and (key <> '1'))
@@ -154,7 +160,7 @@
ON src1.c1 = src3.c5
WHERE src1.c1 > '0' and (src1.c2 <> 'val_500' or src1.c1 > '1') and (src2.c3 > '10' or src1.c1 <> '10') and (src2.c3 <> '4') and (src3.c5 <> '1')
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_3/build/ql/tmp/47779120/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1265462406/10000
100 val_100
100 val_100
100 val_100
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out Tue Aug 11 02:06:23 2009
@@ -25,6 +25,8 @@
Map Reduce
Alias -> Map Operator Tree:
b
+ TableScan
+ alias: b
Reduce Output Operator
key expressions:
expr: key
@@ -35,6 +37,8 @@
type: string
tag: 1
a
+ TableScan
+ alias: a
Reduce Output Operator
key expressions:
expr: key
@@ -199,7 +203,7 @@
Output: ../build/ql/test/data/warehouse/mi4.out
query: SELECT mi1.* FROM mi1
Input: default/mi1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/613202794/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1662084677/10000
0 val_0
0 val_0
0 val_0
@@ -350,7 +354,7 @@
98 val_98
query: SELECT mi2.* FROM mi2
Input: default/mi2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/574876580/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1663619015/10000
100 val_100
100 val_100
100 val_100
@@ -564,7 +568,7 @@
199 val_199
query: SELECT mi3.* FROM mi3
Input: default/mi3/ds=2008-04-08/hr=12
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1848936782/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/660410600/10000
200 2008-04-08 12
200 2008-04-08 12
200 2008-04-08 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out Tue Aug 11 02:06:23 2009
@@ -18,6 +18,8 @@
Map Reduce
Alias -> Map Operator Tree:
b
+ TableScan
+ alias: b
Reduce Output Operator
key expressions:
expr: key
@@ -33,6 +35,8 @@
expr: value
type: string
a
+ TableScan
+ alias: a
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
@@ -94,7 +98,7 @@
SELECT a.key, a.value, b.key, b.value
WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_3/build/ql/tmp/1086203746/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1157143291/10000
17 val_17 17 val_17
18 val_18 18 val_18
18 val_18 18 val_18
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join2.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join2.q.out Tue Aug 11 02:06:23 2009
@@ -18,6 +18,8 @@
Map Reduce
Alias -> Map Operator Tree:
b
+ TableScan
+ alias: b
Filter Operator
predicate:
expr: ((key > '15') and (key < '25'))
@@ -37,6 +39,8 @@
expr: value
type: string
a
+ TableScan
+ alias: a
Reduce Output Operator
key expressions:
expr: key
@@ -94,7 +98,7 @@
SELECT a.key, a.value, b.key, b.value
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_3/build/ql/tmp/1070507636/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1625042104/10000
150 val_150 150 val_150
152 val_152 152 val_152
152 val_152 152 val_152
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join3.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join3.q.out Tue Aug 11 02:06:23 2009
@@ -18,6 +18,8 @@
Map Reduce
Alias -> Map Operator Tree:
b
+ TableScan
+ alias: b
Reduce Output Operator
key expressions:
expr: key
@@ -33,6 +35,8 @@
expr: value
type: string
a
+ TableScan
+ alias: a
Reduce Output Operator
key expressions:
expr: key
@@ -90,7 +94,7 @@
SELECT a.key, a.value, b.key, b.value
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_3/build/ql/tmp/339488441/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1232779923/10000
150 val_150 150 val_150
152 val_152 152 val_152
152 val_152 152 val_152
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out Tue Aug 11 02:06:23 2009
@@ -21,6 +21,8 @@
Map Reduce
Alias -> Map Operator Tree:
b
+ TableScan
+ alias: b
Reduce Output Operator
key expressions:
expr: key
@@ -36,6 +38,8 @@
expr: value
type: string
c
+ TableScan
+ alias: c
Reduce Output Operator
key expressions:
expr: key
@@ -49,6 +53,8 @@
expr: key
type: string
a
+ TableScan
+ alias: a
Reduce Output Operator
key expressions:
expr: key
@@ -113,7 +119,7 @@
SELECT a.key, a.value, b.key, b.value, c.key
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/298031004/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1848803718/10000
150 val_150 150 val_150 150
152 val_152 152 val_152 152
152 val_152 152 val_152 152
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_random.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_random.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_random.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_random.q.out Tue Aug 11 02:06:23 2009
@@ -18,6 +18,8 @@
Map Reduce
Alias -> Map Operator Tree:
src2:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (key > '2')
@@ -46,6 +48,8 @@
expr: _col1
type: string
src1:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out Tue Aug 11 02:06:23 2009
@@ -18,6 +18,8 @@
Map Reduce
Alias -> Map Operator Tree:
tmap:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -77,7 +79,7 @@
) tmap
SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1793530445/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/683513848/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out Tue Aug 11 02:06:23 2009
@@ -23,6 +23,8 @@
Map Reduce
Alias -> Map Operator Tree:
b
+ TableScan
+ alias: b
Filter Operator
predicate:
expr: (ds = '2008-04-08')
@@ -46,6 +48,8 @@
expr: hr
type: string
a
+ TableScan
+ alias: a
Filter Operator
predicate:
expr: ((ds = '2008-04-08') and CASE (key) WHEN ('27') THEN (true) WHEN ('38') THEN (false) ELSE (null) END)
@@ -109,7 +113,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/600222764/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/331138227/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -174,7 +178,7 @@
ORDER BY a.key, a.value, a.ds, a.hr, b.key, b.value, b.ds, b.hr
Input: default/srcpart/ds=2008-04-08/hr=11
Input: default/srcpart/ds=2008-04-08/hr=12
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/178170122/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1976930760/10000
27 val_27 2008-04-08 11 27 val_27 2008-04-08 11
27 val_27 2008-04-08 11 27 val_27 2008-04-08 12
27 val_27 2008-04-08 12 27 val_27 2008-04-08 11
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_union.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_union.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_union.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_union.q.out Tue Aug 11 02:06:23 2009
@@ -18,6 +18,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unioned_query-subquery1:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: ((key < '100') and ((key > '4') and (value > 'val_4')))
@@ -52,6 +54,8 @@
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
null-subquery2:unioned_query-subquery2:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: ((key > '150') and ((key > '4') and (value > 'val_4')))
@@ -99,7 +103,7 @@
SELECT unioned_query.*
WHERE key > '4' and value > 'val_4'
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1644693517/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1828690205/10000
86 val_86
409 val_409
98 val_98
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: ((UDFToDouble(key) >= UDFToDouble(200)) and (UDFToDouble(key) < UDFToDouble(300)))
@@ -52,10 +54,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/801828487/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/963537398/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1251238086/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/319542195/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -105,6 +107,8 @@
Map Reduce
Alias -> Map Operator Tree:
int
+ TableScan
+ alias: int
Filter Operator
predicate:
expr: (table = '2008-04-08')
@@ -140,7 +144,7 @@
Output: default/dest1/table=2008-04-08
query: SELECT `int`.`location`, `int`.`type`, `int`.`table` FROM dest1 `int` WHERE `int`.`table` = '2008-04-08'
Input: default/dest1/table=2008-04-08
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1856384847/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1560089475/10000
238 val_238 2008-04-08
255 val_255 2008-04-08
278 val_278 2008-04-08
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/quote2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/quote2.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/quote2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/quote2.q.out Tue Aug 11 02:06:23 2009
@@ -24,6 +24,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: 'abc'
@@ -92,5 +94,5 @@
FROM src
LIMIT 1
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1644354823/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1457515970/10000
abc abc abc' abc" abc\ abc\ abc\' abc\" abc\\ abc\\ abc\\' abc\\" abc\\\ abc\\\ abc""""\ abc''''\ awk '{print NR"\t"$0}' tab tab tab tab
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out Tue Aug 11 02:06:23 2009
@@ -12,7 +12,10 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Filter Operator
+ isSamplingPred: false
predicate:
expr: (rand(UDFToLong(1)) < 0.1)
type: boolean
@@ -26,7 +29,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/tmp/1509492939/10001
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/972674441/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -36,9 +39,9 @@
columns.types string:string
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/src
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/src
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -53,7 +56,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/src
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
@@ -64,7 +67,7 @@
query: select * from src where rand(1) < 0.1
Input: default/src
-Output: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/tmp/1647273851/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1925118619/10000
409 val_409
429 val_429
209 val_209
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out Tue Aug 11 02:06:23 2009
@@ -17,7 +17,10 @@
Map Reduce
Alias -> Map Operator Tree:
a
+ TableScan
+ alias: a
Filter Operator
+ isSamplingPred: false
predicate:
expr: ((rand(UDFToLong(1)) < 0.1) and (ds = '2008-04-08'))
type: boolean
@@ -35,7 +38,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1095666226/10002
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/297745997/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -49,15 +52,15 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/tmptable
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/tmptable
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -76,10 +79,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -98,7 +101,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
@@ -108,11 +111,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1095666226/10002
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/329704235/10000
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/297745997/10002
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1082152634/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1095666226/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/297745997/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -130,9 +133,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1095666226/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/297745997/10002
Path -> Partition:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1095666226/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/297745997/10002
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -147,7 +150,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/tmptable
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/tmptable
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
Reduce Operator Tree:
@@ -155,7 +158,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/329704235/10000
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1082152634/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -168,7 +171,7 @@
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/tmptable
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/tmptable
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
@@ -177,7 +180,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/329704235/10000
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1082152634/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -191,10 +194,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/tmptable
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/tmptable
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- tmp directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/329704235/10001
+ tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1082152634/10001
query: insert overwrite table tmptable
@@ -204,7 +207,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key,x.value,x.ds,x.hr
Input: default/tmptable
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/960645476/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1193259672/10000
103 val_103 2008-04-08 11
103 val_103 2008-04-08 12
133 val_133 2008-04-08 11
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out Tue Aug 11 02:06:23 2009
@@ -13,7 +13,10 @@
Map Reduce
Alias -> Map Operator Tree:
a
+ TableScan
+ alias: a
Filter Operator
+ isSamplingPred: false
predicate:
expr: ((((rand(UDFToLong(1)) < 0.1) and (ds = '2008-04-08')) and not ((UDFToDouble(key) > UDFToDouble(50)) or (UDFToDouble(key) < UDFToDouble(10)))) and (hr like '%2'))
type: boolean
@@ -31,7 +34,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/1921119763/10001
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/330469412/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -41,9 +44,9 @@
columns.types string:string:string:string
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -62,7 +65,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
@@ -73,7 +76,7 @@
query: select a.* from srcpart a where rand(1) < 0.1 and a.ds = '2008-04-08' and not(key > 50 or key < 10) and a.hr like '%2'
Input: default/srcpart/ds=2008-04-08/hr=12
-Output: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/353265726/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1434721309/10000
42 val_42 2008-04-08 12
44 val_44 2008-04-08 12
26 val_26 2008-04-08 12
@@ -93,11 +96,15 @@
Map Reduce
Alias -> Map Operator Tree:
a
+ TableScan
+ alias: a
Filter Operator
+ isSamplingPred: false
predicate:
expr: (((ds = '2008-04-08') and not ((UDFToDouble(key) > UDFToDouble(50)) or (UDFToDouble(key) < UDFToDouble(10)))) and (hr like '%2'))
type: boolean
Filter Operator
+ isSamplingPred: false
predicate:
expr: (((ds = '2008-04-08') and not ((UDFToDouble(key) > UDFToDouble(50)) or (UDFToDouble(key) < UDFToDouble(10)))) and (hr like '%2'))
type: boolean
@@ -115,7 +122,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/140562086/10001
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1155307823/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -125,9 +132,9 @@
columns.types string:string:string:string
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -146,7 +153,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
@@ -157,7 +164,7 @@
query: select a.* from srcpart a where a.ds = '2008-04-08' and not(key > 50 or key < 10) and a.hr like '%2'
Input: default/srcpart/ds=2008-04-08/hr=12
-Output: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/671022462/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2074930969/10000
27 val_27 2008-04-08 12
37 val_37 2008-04-08 12
15 val_15 2008-04-08 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out Tue Aug 11 02:06:23 2009
@@ -26,6 +26,8 @@
Map Reduce
Alias -> Map Operator Tree:
srcpart
+ TableScan
+ alias: srcpart
Select Operator
expressions:
expr: ds
@@ -59,6 +61,8 @@
Map Reduce
Alias -> Map Operator Tree:
srcpart
+ TableScan
+ alias: srcpart
Select Operator
expressions:
expr: ds
@@ -93,6 +97,8 @@
Map Reduce
Alias -> Map Operator Tree:
b
+ TableScan
+ alias: b
Reduce Output Operator
key expressions:
expr: key
@@ -112,6 +118,8 @@
expr: hr
type: string
a
+ TableScan
+ alias: a
Reduce Output Operator
key expressions:
expr: key
@@ -178,6 +186,8 @@
Map Reduce
Alias -> Map Operator Tree:
b
+ TableScan
+ alias: b
Reduce Output Operator
key expressions:
expr: key
@@ -201,6 +211,8 @@
expr: hr
type: string
a
+ TableScan
+ alias: a
Filter Operator
predicate:
expr: (UDFToDouble(key) = UDFToDouble(103))
@@ -251,7 +263,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1981087431/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2084085197/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -286,7 +298,7 @@
Input: default/srcpart/ds=2008-04-08/hr=12
Input: default/srcpart/ds=2008-04-09/hr=11
Input: default/srcpart/ds=2008-04-09/hr=12
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/142920230/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/701163717/10000
2008-04-08 11
2008-04-08 11
2008-04-08 11
@@ -317,6 +329,8 @@
Map Reduce
Alias -> Map Operator Tree:
srcpart
+ TableScan
+ alias: srcpart
Select Operator
expressions:
expr: key
@@ -348,6 +362,8 @@
Map Reduce
Alias -> Map Operator Tree:
srcpart
+ TableScan
+ alias: srcpart
Select Operator
expressions:
expr: ds
@@ -379,6 +395,8 @@
Map Reduce
Alias -> Map Operator Tree:
srcpart
+ TableScan
+ alias: srcpart
Select Operator
expressions:
expr: key
@@ -414,6 +432,8 @@
Map Reduce
Alias -> Map Operator Tree:
srcpart
+ TableScan
+ alias: srcpart
Select Operator
expressions:
expr: key
@@ -454,7 +474,7 @@
Input: default/srcpart/ds=2008-04-08/hr=12
Input: default/srcpart/ds=2008-04-09/hr=11
Input: default/srcpart/ds=2008-04-09/hr=12
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/116029619/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/27970835/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out Tue Aug 11 02:06:23 2009
@@ -18,6 +18,8 @@
Map Reduce
Alias -> Map Operator Tree:
tmap:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -54,9 +56,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/src
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/src
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -71,12 +73,13 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/src
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
Extract
Filter Operator
+ isSamplingPred: false
predicate:
expr: (UDFToDouble(_col0) < UDFToDouble(100))
type: boolean
@@ -90,7 +93,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/tmp/692408203/10001
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/522106028/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -103,7 +106,6 @@
Fetch Operator
limit: -1
-
query: FROM (
FROM src
SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
@@ -112,7 +114,7 @@
) tmap
SELECT tmap.key, regexp_extract(tmap.value, 'val_(\\d+\\t\\d+)',1) WHERE tmap.key < 100
Input: default/src
-Output: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/tmp/136730416/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1714962148/10000
0 0 3
0 0 3
0 0 3
@@ -217,6 +219,8 @@
Map Reduce
Alias -> Map Operator Tree:
tmap:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -253,9 +257,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/src
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/src
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -270,12 +274,13 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/src
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
Extract
Filter Operator
+ isSamplingPred: false
predicate:
expr: (UDFToDouble(_col0) < UDFToDouble(100))
type: boolean
@@ -289,7 +294,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/tmp/1786530675/10001
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1763826161/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -302,7 +307,6 @@
Fetch Operator
limit: -1
-
query: FROM (
FROM src
SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
@@ -311,7 +315,7 @@
) tmap
SELECT tmap.key, regexp_extract(tmap.value, 'val_(\\d+\\t\\d+)') WHERE tmap.key < 100
Input: default/src
-Output: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/tmp/1351305244/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1100247728/10000
0 0 3
0 0 3
0 0 3