Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,102 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key) c1) (TOK_SELEXPR (TOK_COLREF src1 value) c2)) (TOK_WHERE (and (> (TOK_COLREF src1 key) 10) (< (TOK_COLREF src1 key) 20))))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src2 key) c3) (TOK_SELEXPR (TOK_COLREF src2 value) c4)) (TOK_WHERE (and (> (TOK_COLREF src2 key) 15) (< (TOK_COLREF src2 key) 25))))) b) (= (TOK_COLREF a c1) (TOK_COLREF b c3)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF a c1) c1) (TOK_SELEXPR (TOK_COLREF a c2) c2) (TOK_SELEXPR (TOK_COLREF b c3) c3) (TOK_SELEXPR (TOK_COLREF b c4) c4)))) c)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF c c1
)) (TOK_SELEXPR (TOK_COLREF c c2)) (TOK_SELEXPR (TOK_COLREF c c3)) (TOK_SELEXPR (TOK_COLREF c c4)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Reduce Operator Tree:
+ Join Operator
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ condition map:
+ Right Outer Join0 to 1
+ Select Operator
+ expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ expr: 2
+ type: class java.lang.String
+ expr: 3
+ type: class java.lang.String
+ Select Operator
+ expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ expr: 2
+ type: class java.lang.String
+ expr: 3
+ type: class java.lang.String
+ File Output Operator
+ table:
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ c:b:src2
+ Filter Operator
+ predicate:
+ expr: ((key > 15) and (key < 25))
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ Reduce Output Operator
+ tag: 1
+ key expressions:
+ expr: 0
+ type: class java.lang.String
+ value expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ # partition fields: 1
+ c:a:src1
+ Filter Operator
+ predicate:
+ expr: ((key > 10) and (key < 20))
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ Reduce Output Operator
+ tag: 0
+ key expressions:
+ expr: 0
+ type: class java.lang.String
+ value expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ # partition fields: 1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+
17 val_17 17 val_17
18 val_18 18 val_18
18 val_18 18 val_18
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,102 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key) c1) (TOK_SELEXPR (TOK_COLREF src1 value) c2)) (TOK_WHERE (and (> (TOK_COLREF src1 key) 10) (< (TOK_COLREF src1 key) 20))))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src2 key) c3) (TOK_SELEXPR (TOK_COLREF src2 value) c4)) (TOK_WHERE (and (> (TOK_COLREF src2 key) 15) (< (TOK_COLREF src2 key) 25))))) b) (= (TOK_COLREF a c1) (TOK_COLREF b c3)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF a c1) c1) (TOK_SELEXPR (TOK_COLREF a c2) c2) (TOK_SELEXPR (TOK_COLREF b c3) c3) (TOK_SELEXPR (TOK_COLREF b c4) c4)))) c)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF c c1)
) (TOK_SELEXPR (TOK_COLREF c c2)) (TOK_SELEXPR (TOK_COLREF c c3)) (TOK_SELEXPR (TOK_COLREF c c4)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Reduce Operator Tree:
+ Join Operator
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ condition map:
+ Outer Join 0 to 1
+ Select Operator
+ expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ expr: 2
+ type: class java.lang.String
+ expr: 3
+ type: class java.lang.String
+ Select Operator
+ expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ expr: 2
+ type: class java.lang.String
+ expr: 3
+ type: class java.lang.String
+ File Output Operator
+ table:
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ c:b:src2
+ Filter Operator
+ predicate:
+ expr: ((key > 15) and (key < 25))
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ Reduce Output Operator
+ tag: 1
+ key expressions:
+ expr: 0
+ type: class java.lang.String
+ value expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ # partition fields: 1
+ c:a:src1
+ Filter Operator
+ predicate:
+ expr: ((key > 10) and (key < 20))
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ Reduce Output Operator
+ tag: 0
+ key expressions:
+ expr: 0
+ type: class java.lang.String
+ value expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ # partition fields: 1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+
11 val_11 NULL NULL
12 val_12 NULL NULL
12 val_12 NULL NULL
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,134 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_FULLOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key) c1) (TOK_SELEXPR (TOK_COLREF src1 value) c2)) (TOK_WHERE (and (> (TOK_COLREF src1 key) 10) (< (TOK_COLREF src1 key) 20))))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src2 key) c3) (TOK_SELEXPR (TOK_COLREF src2 value) c4)) (TOK_WHERE (and (> (TOK_COLREF src2 key) 15) (< (TOK_COLREF src2 key) 25))))) b) (= (TOK_COLREF a c1) (TOK_COLREF b c3))) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src3)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src3 key) c5) (TOK_SELEXPR (TOK_COLREF src3 value) c6)) (TOK_WHERE (and (> (TOK_COLREF src3 key) 20) (< (TOK_COLREF src3 key) 25)))))
c) (= (TOK_COLREF a c1) (TOK_COLREF c c5)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF a c1) c1) (TOK_SELEXPR (TOK_COLREF a c2) c2) (TOK_SELEXPR (TOK_COLREF b c3) c3) (TOK_SELEXPR (TOK_COLREF b c4) c4) (TOK_SELEXPR (TOK_COLREF c c5) c5) (TOK_SELEXPR (TOK_COLREF c c6) c6)))) c)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF c c1)) (TOK_SELEXPR (TOK_COLREF c c2)) (TOK_SELEXPR (TOK_COLREF c c3)) (TOK_SELEXPR (TOK_COLREF c c4)) (TOK_SELEXPR (TOK_COLREF c c5)) (TOK_SELEXPR (TOK_COLREF c c6)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Reduce Operator Tree:
+ Join Operator
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ 2 {VALUE.0} {VALUE.1}
+ condition map:
+ Outer Join 0 to 1
+ Left Outer Join0 to 1
+ Select Operator
+ expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ expr: 2
+ type: class java.lang.String
+ expr: 3
+ type: class java.lang.String
+ expr: 4
+ type: class java.lang.String
+ expr: 5
+ type: class java.lang.String
+ Select Operator
+ expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ expr: 2
+ type: class java.lang.String
+ expr: 3
+ type: class java.lang.String
+ expr: 4
+ type: class java.lang.String
+ expr: 5
+ type: class java.lang.String
+ File Output Operator
+ table:
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ c:b:src2
+ Filter Operator
+ predicate:
+ expr: ((key > 15) and (key < 25))
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ Reduce Output Operator
+ tag: 1
+ key expressions:
+ expr: 0
+ type: class java.lang.String
+ value expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ # partition fields: 1
+ c:a:src1
+ Filter Operator
+ predicate:
+ expr: ((key > 10) and (key < 20))
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ Reduce Output Operator
+ tag: 0
+ key expressions:
+ expr: 0
+ type: class java.lang.String
+ value expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ # partition fields: 1
+ c:c:src3
+ Filter Operator
+ predicate:
+ expr: ((key > 20) and (key < 25))
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ Reduce Output Operator
+ tag: 2
+ key expressions:
+ expr: 0
+ type: class java.lang.String
+ value expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ # partition fields: 1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+
11 val_11 NULL NULL NULL NULL
12 val_12 NULL NULL NULL NULL
12 val_12 NULL NULL NULL NULL
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,106 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key) c1) (TOK_SELEXPR (TOK_COLREF src1 value) c2)) (TOK_WHERE (and (> (TOK_COLREF src1 key) 10) (< (TOK_COLREF src1 key) 20))))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src2 key) c3) (TOK_SELEXPR (TOK_COLREF src2 value) c4)) (TOK_WHERE (and (> (TOK_COLREF src2 key) 15) (< (TOK_COLREF src2 key) 25))))) b) (= (TOK_COLREF a c1) (TOK_COLREF b c3)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF a c1) c1) (TOK_SELEXPR (TOK_COLREF a c2) c2) (TOK_SELEXPR (TOK_COLREF b c3) c3) (TOK_SELEXPR (TOK_COLREF b c4) c4)))) c)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF c c1)
) (TOK_SELEXPR (TOK_COLREF c c2)) (TOK_SELEXPR (TOK_COLREF c c3)) (TOK_SELEXPR (TOK_COLREF c c4))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNULL (TOK_COLREF c c3)) (TOK_FUNCTION TOK_ISNOTNULL (TOK_COLREF c c1))))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Reduce Operator Tree:
+ Join Operator
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ condition map:
+ Left Outer Join0 to 1
+ Select Operator
+ expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ expr: 2
+ type: class java.lang.String
+ expr: 3
+ type: class java.lang.String
+ Filter Operator
+ predicate:
+ expr: (2 is null and 0 is not null)
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ expr: 2
+ type: class java.lang.String
+ expr: 3
+ type: class java.lang.String
+ File Output Operator
+ table:
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ c:b:src2
+ Filter Operator
+ predicate:
+ expr: ((key > 15) and (key < 25))
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ Reduce Output Operator
+ tag: 1
+ key expressions:
+ expr: 0
+ type: class java.lang.String
+ value expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ # partition fields: 1
+ c:a:src1
+ Filter Operator
+ predicate:
+ expr: ((key > 10) and (key < 20))
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ Reduce Output Operator
+ tag: 0
+ key expressions:
+ expr: 0
+ type: class java.lang.String
+ value expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ # partition fields: 1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+
11 val_11 NULL NULL
12 val_12 NULL NULL
12 val_12 NULL NULL
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,96 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcpart (TOK_TABLESAMPLE 1 1) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_WHERE (and (= (TOK_COLREF s ds) '2008-04-08') (= (TOK_COLREF s hr) '11')))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Path -> Alias:
+ file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ Path -> Partition:
+ file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ Partition
+
+ properties:
+ name srcpart
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ field_to_dimension
+ bucket_count -1
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart
+ name: srcpart
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ partition values:
+ ds 2008-04-08
+ hr 11
+ Alias -> Map Operator Tree:
+ s
+ Filter Operator
+ predicate:
+ expr: ((ds = '2008-04-08') and (hr = '11'))
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ expr: ds
+ type: class java.lang.String
+ expr: hr
+ type: class java.lang.String
+ File Output Operator
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value,dt,hr
+ field_to_dimension
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ directory: /tmp/hive-athusoo/950057386.10000.insclause-0
+ Needs Tagging:
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value,dt,hr
+ field_to_dimension
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ source: /tmp/hive-athusoo/950057386.10000.insclause-0
+
238 val_238 2008-04-08 11
86 val_86 2008-04-08 11
311 val_311 2008-04-08 11
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,84 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 2) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Path -> Alias:
+ file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
+ Path -> Partition:
+ file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
+ Partition
+
+ properties:
+ name srcbucket
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count 2
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ name: srcbucket
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ s
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ File Output Operator
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ directory: /tmp/hive-athusoo/447439878.10000.insclause-0
+ Needs Tagging:
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ source: /tmp/hive-athusoo/447439878.10000.insclause-0
+
238 val_238
86 val_86
311 val_311
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,88 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 2 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Path -> Alias:
+ file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Path -> Partition:
+ file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Partition
+
+ properties:
+ name srcbucket
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count 2
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ name: srcbucket
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ s
+ Filter Operator
+ predicate:
+ expr: (((default_sample_hashfn(key) & 2147483647) % 2) = 1)
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ File Output Operator
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ directory: /tmp/hive-athusoo/24880210.10000.insclause-0
+ Needs Tagging:
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ source: /tmp/hive-athusoo/24880210.10000.insclause-0
+
238 val_238
311 val_311
27 val_27
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,88 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 5 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Path -> Alias:
+ file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Path -> Partition:
+ file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Partition
+
+ properties:
+ name srcbucket
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count 2
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ name: srcbucket
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ s
+ Filter Operator
+ predicate:
+ expr: (((default_sample_hashfn(key) & 2147483647) % 5) = 1)
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ File Output Operator
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ directory: /tmp/hive-athusoo/238899095.10000.insclause-0
+ Needs Tagging:
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ source: /tmp/hive-athusoo/238899095.10000.insclause-0
+
165 val_165
255 val_255
278 val_278
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,88 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 4 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Path -> Alias:
+ file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Path -> Partition:
+ file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Partition
+
+ properties:
+ name srcbucket
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count 2
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ name: srcbucket
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ s
+ Filter Operator
+ predicate:
+ expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 1)
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ File Output Operator
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ directory: /tmp/hive-athusoo/288432544.10000.insclause-0
+ Needs Tagging:
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ source: /tmp/hive-athusoo/288432544.10000.insclause-0
+
27 val_27
409 val_409
265 val_265
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,92 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 4 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_WHERE (> (TOK_COLREF s key) 100))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Path -> Alias:
+ file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Path -> Partition:
+ file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Partition
+
+ properties:
+ name srcbucket
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count 2
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ name: srcbucket
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ s
+ Filter Operator
+ predicate:
+ expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 1)
+ type: class java.lang.Boolean
+ Filter Operator
+ predicate:
+ expr: (key > 100)
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ File Output Operator
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ directory: /tmp/hive-athusoo/631893552.10000.insclause-0
+ Needs Tagging:
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ source: /tmp/hive-athusoo/631893552.10000.insclause-0
+
409 val_409
265 val_265
401 val_401
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,42 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF src))) (TOK_WHERE (< (TOK_COLREF src key) 100)))) unioninput)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR '../../../../build/contrib/hive/ql/test/data/warehouse/union.out')) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF unioninput)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ unioninput:src
+ Filter Operator
+ predicate:
+ expr: (key < 100)
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ Select Operator
+ expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Move Operator
+ files:
+ destination: ../../../../build/contrib/hive/ql/test/data/warehouse/union.out
+ hdfs directory:
+
86val_86
27val_27
98val_98
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out Thu Sep 18 10:37:59 2008
@@ -1 +1,70 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (LIKE 'a' '%a%')) (TOK_SELEXPR (LIKE 'b' '%a%')) (TOK_SELEXPR (LIKE 'ab' '%a%')) (TOK_SELEXPR (LIKE 'ab' '%a_')) (TOK_SELEXPR (LIKE '%_' '\%\_')) (TOK_SELEXPR (LIKE 'ab' '\%\_')) (TOK_SELEXPR (LIKE 'ab' '_a%')) (TOK_SELEXPR (LIKE 'ab' 'a')) (TOK_SELEXPR (RLIKE '' '.*')) (TOK_SELEXPR (RLIKE 'a' '[ab]')) (TOK_SELEXPR (RLIKE '' '[ab]')) (TOK_SELEXPR (RLIKE 'hadoop' '[a-z]*')) (TOK_SELEXPR (RLIKE 'hadoop' 'o*')) (TOK_SELEXPR (TOK_FUNCTION REGEXP_REPLACE 'abc' 'b' 'c')) (TOK_SELEXPR (TOK_FUNCTION REGEXP_REPLACE 'abc' 'z' 'a')) (TOK_SELEXPR (TOK_FUNCTION REGEXP_REPLACE 'abbbb' 'bb' 'b')) (TOK_SELEXPR (TOK_FUNCTION REGEXP_REPLACE 'hadoop' '(.)[a-z]*' '$1ive'))) (TOK_WHERE (= (TOK_COLREF src key) 86))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ Filter Operator
+ predicate:
+ expr: (key = 86)
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: ('a' like '%a%')
+ type: class java.lang.Boolean
+ expr: ('b' like '%a%')
+ type: class java.lang.Boolean
+ expr: ('ab' like '%a%')
+ type: class java.lang.Boolean
+ expr: ('ab' like '%a_')
+ type: class java.lang.Boolean
+ expr: ('%_' like '\%\_')
+ type: class java.lang.Boolean
+ expr: ('ab' like '\%\_')
+ type: class java.lang.Boolean
+ expr: ('ab' like '_a%')
+ type: class java.lang.Boolean
+ expr: ('ab' like 'a')
+ type: class java.lang.Boolean
+ expr: ('' regexp '.*')
+ type: class java.lang.Boolean
+ expr: ('a' regexp '[ab]')
+ type: class java.lang.Boolean
+ expr: ('' regexp '[ab]')
+ type: class java.lang.Boolean
+ expr: ('hadoop' regexp '[a-z]*')
+ type: class java.lang.Boolean
+ expr: ('hadoop' regexp 'o*')
+ type: class java.lang.Boolean
+ expr: regexp_replace('abc', 'b', 'c')
+ type: class java.lang.String
+ expr: regexp_replace('abc', 'z', 'a')
+ type: class java.lang.String
+ expr: regexp_replace('abbbb', 'bb', 'b')
+ type: class java.lang.String
+ expr: regexp_replace('hadoop', '(.)[a-z]*', '$1ive')
+ type: class java.lang.String
+ File Output Operator
+ table:
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+
true false true true true false false false true true false true false acc abc abb hive
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,63 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (< (TOK_COLREF src key) 100)))) (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF src))) (TOK_WHERE (> (TOK_COLREF src key) 100))))) unioninput)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR '../../../../build/contrib/hive/ql/test/data/warehouse/union.out')) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF unioninput)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ null-subquery1:unioninput-subquery1:src
+ Filter Operator
+ predicate:
+ expr: (key < 100)
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ Select Operator
+ expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ null-subquery2:unioninput-subquery2:src
+ Filter Operator
+ predicate:
+ expr: (key > 100)
+ type: class java.lang.Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: class java.lang.String
+ expr: value
+ type: class java.lang.String
+ Select Operator
+ expressions:
+ expr: 0
+ type: class java.lang.String
+ expr: 1
+ type: class java.lang.String
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Move Operator
+ files:
+ destination: ../../../../build/contrib/hive/ql/test/data/warehouse/union.out
+ hdfs directory:
+
238val_238
86val_86
311val_311
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/plan/cast1.q.xml
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/plan/cast1.q.xml?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/plan/cast1.q.xml (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/plan/cast1.q.xml Thu Sep 18 10:37:59 2008
@@ -5,6 +5,9 @@
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.exec.MoveTask">
+ <void property="id">
+ <string>Stage-1</string>
+ </void>
<void property="parentTasks">
<object class="java.util.ArrayList">
<void method="add">
@@ -28,7 +31,7 @@
<boolean>true</boolean>
</void>
<void property="sourceDir">
- <string>/tmp/hive-zshao/548421058.10000.insclause-0</string>
+ <string>/tmp/hive-athusoo/387148964.10000.insclause-0</string>
</void>
<void property="table">
<object id="tableDesc0" class="org.apache.hadoop.hive.ql.plan.tableDesc">
@@ -78,7 +81,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/home/zshao/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1</string>
+ <string>file:/home/athusoo/apacheprojects/hadoop-core-trunk_ws3/build/contrib/hive/ql/test/data/warehouse/dest1</string>
</void>
</object>
</void>
@@ -100,6 +103,9 @@
</void>
</object>
</void>
+ <void property="id">
+ <string>Stage-2</string>
+ </void>
<void property="work">
<object class="org.apache.hadoop.hive.ql.plan.mapredWork">
<void property="aliasToWork">
@@ -122,7 +128,7 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc">
<void property="dirName">
- <string>/tmp/hive-zshao/548421058.10000.insclause-0</string>
+ <string>/tmp/hive-athusoo/387148964.10000.insclause-0</string>
</void>
<void property="tableInfo">
<object idref="tableDesc0"/>
@@ -702,7 +708,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/home/zshao/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/src</string>
+ <string>file:/home/athusoo/apacheprojects/hadoop-core-trunk_ws3/build/contrib/hive/ql/test/data/warehouse/src</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src</string>
@@ -714,7 +720,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/home/zshao/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/src</string>
+ <string>file:/home/athusoo/apacheprojects/hadoop-core-trunk_ws3/build/contrib/hive/ql/test/data/warehouse/src</string>
<object class="org.apache.hadoop.hive.ql.plan.partitionDesc">
<void property="partSpec">
<object class="java.util.LinkedHashMap"/>
@@ -767,7 +773,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/home/zshao/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/src</string>
+ <string>file:/home/athusoo/apacheprojects/hadoop-core-trunk_ws3/build/contrib/hive/ql/test/data/warehouse/src</string>
</void>
</object>
</void>
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/plan/groupby1.q.xml
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/plan/groupby1.q.xml?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/plan/groupby1.q.xml (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/plan/groupby1.q.xml Thu Sep 18 10:37:59 2008
@@ -9,6 +9,9 @@
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.exec.MoveTask">
+ <void property="id">
+ <string>Stage-1</string>
+ </void>
<void property="parentTasks">
<object class="java.util.ArrayList">
<void method="add">
@@ -32,7 +35,7 @@
<boolean>true</boolean>
</void>
<void property="sourceDir">
- <string>/tmp/hive-zshao/28228781.10000.insclause-0</string>
+ <string>/tmp/hive-athusoo/701551716.10000.insclause-0</string>
</void>
<void property="table">
<object id="tableDesc0" class="org.apache.hadoop.hive.ql.plan.tableDesc">
@@ -82,7 +85,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/home/zshao/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1</string>
+ <string>file:/home/athusoo/apacheprojects/hadoop-core-trunk_ws3/build/contrib/hive/ql/test/data/warehouse/dest1</string>
</void>
</object>
</void>
@@ -104,6 +107,9 @@
</void>
</object>
</void>
+ <void property="id">
+ <string>Stage-3</string>
+ </void>
<void property="parentTasks">
<object class="java.util.ArrayList">
<void method="add">
@@ -116,7 +122,7 @@
<void property="aliasToWork">
<object class="java.util.HashMap">
<void method="put">
- <string>/tmp/hive-zshao/28228781.10001</string>
+ <string>/tmp/hive-athusoo/701551716.10001</string>
<object class="org.apache.hadoop.hive.ql.exec.ReduceSinkOperator">
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.reduceSinkDesc">
@@ -191,10 +197,10 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>/tmp/hive-zshao/28228781.10001</string>
+ <string>/tmp/hive-athusoo/701551716.10001</string>
<object class="java.util.ArrayList">
<void method="add">
- <string>/tmp/hive-zshao/28228781.10001</string>
+ <string>/tmp/hive-athusoo/701551716.10001</string>
</void>
</object>
</void>
@@ -203,7 +209,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>/tmp/hive-zshao/28228781.10001</string>
+ <string>/tmp/hive-athusoo/701551716.10001</string>
<object class="org.apache.hadoop.hive.ql.plan.partitionDesc">
<void property="tableDesc">
<object id="tableDesc1" class="org.apache.hadoop.hive.ql.plan.tableDesc">
@@ -247,7 +253,7 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc">
<void property="dirName">
- <string>/tmp/hive-zshao/28228781.10000.insclause-0</string>
+ <string>/tmp/hive-athusoo/701551716.10000.insclause-0</string>
</void>
<void property="tableInfo">
<object idref="tableDesc0"/>
@@ -409,6 +415,9 @@
</void>
</object>
</void>
+ <void property="id">
+ <string>Stage-2</string>
+ </void>
<void property="work">
<object class="org.apache.hadoop.hive.ql.plan.mapredWork">
<void property="aliasToWork">
@@ -425,14 +434,7 @@
<void property="keyCols">
<object class="java.util.ArrayList">
<void method="add">
- <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc">
- <void property="column">
- <string>key</string>
- </void>
- <void property="typeInfo">
- <object id="TypeInfo1" class="org.apache.hadoop.hive.ql.parse.TypeInfo"/>
- </void>
- </object>
+ <object class="org.apache.hadoop.hive.ql.plan.exprNodeNullDesc"/>
</void>
</object>
</void>
@@ -445,6 +447,36 @@
<void property="valueCols">
<object class="java.util.ArrayList">
<void method="add">
+ <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc">
+ <void property="column">
+ <string>key</string>
+ </void>
+ <void property="typeInfo">
+ <object id="TypeInfo1" class="org.apache.hadoop.hive.ql.parse.TypeInfo"/>
+ </void>
+ </object>
+ </void>
+ <void method="add">
+ <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc">
+ <void property="column">
+ <string>value</string>
+ </void>
+ <void property="typeInfo">
+ <object id="TypeInfo2" class="org.apache.hadoop.hive.ql.parse.TypeInfo"/>
+ </void>
+ </object>
+ </void>
+ <void method="add">
+ <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc">
+ <void property="column">
+ <string>key</string>
+ </void>
+ <void property="typeInfo">
+ <object idref="TypeInfo1"/>
+ </void>
+ </object>
+ </void>
+ <void method="add">
<object class="org.apache.hadoop.hive.ql.plan.exprNodeFuncDesc">
<void property="UDFClass">
<class>org.apache.hadoop.hive.ql.udf.UDFSubstr</class>
@@ -470,7 +502,7 @@
<string>value</string>
</void>
<void property="typeInfo">
- <object id="TypeInfo2" class="org.apache.hadoop.hive.ql.parse.TypeInfo"/>
+ <object idref="TypeInfo2"/>
</void>
</object>
</void>
@@ -498,21 +530,41 @@
<void property="schema">
<object class="org.apache.hadoop.hive.ql.exec.RowSchema">
<void property="signature">
- <object class="java.util.Vector">
+ <object id="Vector1" class="java.util.Vector">
<void method="add">
<object class="org.apache.hadoop.hive.ql.exec.ColumnInfo">
<void property="internalName">
- <string>KEY.0</string>
+ <string>VALUE.0</string>
</void>
<void property="type">
- <object idref="TypeInfo0"/>
+ <object idref="TypeInfo1"/>
</void>
</object>
</void>
<void method="add">
<object class="org.apache.hadoop.hive.ql.exec.ColumnInfo">
<void property="internalName">
- <string>VALUE.0</string>
+ <string>VALUE.1</string>
+ </void>
+ <void property="type">
+ <object idref="TypeInfo2"/>
+ </void>
+ </object>
+ </void>
+ <void method="add">
+ <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo">
+ <void property="internalName">
+ <string>VALUE.2</string>
+ </void>
+ <void property="type">
+ <object idref="TypeInfo1"/>
+ </void>
+ </object>
+ </void>
+ <void method="add">
+ <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo">
+ <void property="internalName">
+ <string>VALUE.3</string>
</void>
<void property="type">
<object idref="TypeInfo0"/>
@@ -562,7 +614,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/home/zshao/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/src</string>
+ <string>file:/home/athusoo/apacheprojects/hadoop-core-trunk_ws3/build/contrib/hive/ql/test/data/warehouse/src</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src</string>
@@ -574,7 +626,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/home/zshao/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/src</string>
+ <string>file:/home/athusoo/apacheprojects/hadoop-core-trunk_ws3/build/contrib/hive/ql/test/data/warehouse/src</string>
<object class="org.apache.hadoop.hive.ql.plan.partitionDesc">
<void property="partSpec">
<object class="java.util.LinkedHashMap"/>
@@ -627,7 +679,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/home/zshao/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/src</string>
+ <string>file:/home/athusoo/apacheprojects/hadoop-core-trunk_ws3/build/contrib/hive/ql/test/data/warehouse/src</string>
</void>
</object>
</void>
@@ -644,42 +696,50 @@
</object>
</void>
<void property="reducer">
- <object class="org.apache.hadoop.hive.ql.exec.GroupByOperator">
+ <object class="org.apache.hadoop.hive.ql.exec.ForwardOperator">
<void property="childOperators">
<object class="java.util.ArrayList">
<void method="add">
- <object class="org.apache.hadoop.hive.ql.exec.FileSinkOperator">
- <void property="conf">
- <object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc">
- <void property="dirName">
- <string>/tmp/hive-zshao/28228781.10001</string>
- </void>
- <void property="tableInfo">
- <object idref="tableDesc1"/>
- </void>
- </object>
- </void>
- <void property="schema">
- <object id="RowSchema0" class="org.apache.hadoop.hive.ql.exec.RowSchema">
- <void property="signature">
- <object class="java.util.Vector">
- <void method="add">
- <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo">
- <void property="internalName">
- <string>0</string>
+ <object class="org.apache.hadoop.hive.ql.exec.GroupByOperator">
+ <void property="childOperators">
+ <object class="java.util.ArrayList">
+ <void method="add">
+ <object class="org.apache.hadoop.hive.ql.exec.FileSinkOperator">
+ <void property="conf">
+ <object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc">
+ <void property="dirName">
+ <string>/tmp/hive-athusoo/701551716.10001</string>
</void>
- <void property="type">
- <object idref="TypeInfo0"/>
+ <void property="tableInfo">
+ <object idref="tableDesc1"/>
</void>
</object>
</void>
- <void method="add">
- <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo">
- <void property="internalName">
- <string>1</string>
- </void>
- <void property="type">
- <object idref="TypeInfo0"/>
+ <void property="schema">
+ <object id="RowSchema0" class="org.apache.hadoop.hive.ql.exec.RowSchema">
+ <void property="signature">
+ <object class="java.util.Vector">
+ <void method="add">
+ <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo">
+ <void property="internalName">
+ <string>0</string>
+ </void>
+ <void property="type">
+ <object idref="TypeInfo1"/>
+ </void>
+ </object>
+ </void>
+ <void method="add">
+ <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo">
+ <void property="internalName">
+ <string>1</string>
+ </void>
+ <void property="type">
+ <object idref="TypeInfo0"/>
+ </void>
+ </object>
+ </void>
+ </object>
</void>
</object>
</void>
@@ -687,60 +747,67 @@
</void>
</object>
</void>
- </object>
- </void>
- </object>
- </void>
- <void property="conf">
- <object class="org.apache.hadoop.hive.ql.plan.groupByDesc">
- <void property="aggregators">
- <object class="java.util.ArrayList">
- <void method="add">
- <object class="org.apache.hadoop.hive.ql.plan.aggregationDesc">
- <void property="aggregationClass">
- <class>org.apache.hadoop.hive.ql.udf.UDAFSum</class>
+ <void property="conf">
+ <object class="org.apache.hadoop.hive.ql.plan.groupByDesc">
+ <void property="aggregators">
+ <object class="java.util.ArrayList">
+ <void method="add">
+ <object class="org.apache.hadoop.hive.ql.plan.aggregationDesc">
+ <void property="aggregationClass">
+ <class>org.apache.hadoop.hive.ql.udf.UDAFSum</class>
+ </void>
+ <void property="parameters">
+ <object class="java.util.ArrayList">
+ <void method="add">
+ <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc">
+ <void property="column">
+ <string>VALUE.3</string>
+ </void>
+ <void property="typeInfo">
+ <object idref="TypeInfo0"/>
+ </void>
+ </object>
+ </void>
+ </object>
+ </void>
+ </object>
+ </void>
+ </object>
</void>
- <void property="parameters">
+ <void property="keys">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc">
<void property="column">
- <string>VALUE.0</string>
+ <string>VALUE.2</string>
</void>
<void property="typeInfo">
- <object idref="TypeInfo0"/>
+ <object idref="TypeInfo1"/>
</void>
</object>
</void>
</object>
</void>
- </object>
- </void>
- </object>
- </void>
- <void property="keys">
- <object class="java.util.ArrayList">
- <void method="add">
- <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc">
- <void property="column">
- <string>KEY.0</string>
- </void>
- <void property="typeInfo">
- <object idref="TypeInfo0"/>
+ <void property="mode">
+ <object class="org.apache.hadoop.hive.ql.plan.groupByDesc$Mode" method="valueOf">
+ <string>PARTIAL1</string>
+ </object>
</void>
</object>
</void>
- </object>
- </void>
- <void property="mode">
- <object class="org.apache.hadoop.hive.ql.plan.groupByDesc$Mode" method="valueOf">
- <string>PARTIAL1</string>
+ <void property="schema">
+ <object idref="RowSchema0"/>
+ </void>
</object>
</void>
</object>
</void>
<void property="schema">
- <object idref="RowSchema0"/>
+ <object class="org.apache.hadoop.hive.ql.exec.RowSchema">
+ <void property="signature">
+ <object idref="Vector1"/>
+ </void>
+ </object>
</void>
</object>
</void>
|