You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by zs...@apache.org on 2008/09/20 01:56:35 UTC
svn commit: r697291 [20/31] - in /hadoop/core/trunk: ./
src/contrib/hive/cli/src/java/org/apache/hadoop/hive/cli/
src/contrib/hive/metastore/if/
src/contrib/hive/metastore/src/gen-javabean/org/apache/hadoop/hive/metastore/api/
src/contrib/hive/metastor...
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=697291&r1=697290&r2=697291&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 Fri Sep 19 16:56:30 2008
@@ -1,108 +1,110 @@
-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
-18 val_18 18 val_18
-18 val_18 18 val_18
-19 val_19 19 val_19
-NULL NULL 20 val_20
-NULL NULL 24 val_24
-NULL NULL 24 val_24
+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: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ File Output Operator
+ table:
+ name: dest1
+ serde: simple_meta
+ 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: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ tag: 1
+ key expressions:
+ expr: 0
+ type: string
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ # partition fields: 1
+ c:a:src1
+ Filter Operator
+ predicate:
+ expr: ((key > 10) and (key < 20))
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ tag: 0
+ key expressions:
+ expr: 0
+ type: string
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ # partition fields: 1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: simple_meta
+ 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
+18 val_18 18 val_18
+18 val_18 18 val_18
+19 val_19 19 val_19
+NULL NULL 20 val_20
+NULL NULL 24 val_24
+NULL NULL 24 val_24
+
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=697291&r1=697290&r2=697291&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 Fri Sep 19 16:56:30 2008
@@ -1,113 +1,115 @@
-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
-15 val_15 NULL NULL
-15 val_15 NULL NULL
-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
-19 val_19 19 val_19
-NULL NULL 20 val_20
-NULL NULL 24 val_24
-NULL NULL 24 val_24
+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: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ File Output Operator
+ table:
+ name: dest1
+ serde: simple_meta
+ 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: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ tag: 1
+ key expressions:
+ expr: 0
+ type: string
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ # partition fields: 1
+ c:a:src1
+ Filter Operator
+ predicate:
+ expr: ((key > 10) and (key < 20))
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ tag: 0
+ key expressions:
+ expr: 0
+ type: string
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ # partition fields: 1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: simple_meta
+ 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
+15 val_15 NULL NULL
+15 val_15 NULL NULL
+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
+19 val_19 19 val_19
+NULL NULL 20 val_20
+NULL NULL 24 val_24
+NULL NULL 24 val_24
+
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=697291&r1=697290&r2=697291&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 Fri Sep 19 16:56:30 2008
@@ -1,147 +1,149 @@
-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
-15 val_15 NULL NULL NULL NULL
-15 val_15 NULL NULL NULL NULL
-17 val_17 17 val_17 NULL NULL
-18 val_18 18 val_18 NULL NULL
-18 val_18 18 val_18 NULL NULL
-18 val_18 18 val_18 NULL NULL
-18 val_18 18 val_18 NULL NULL
-19 val_19 19 val_19 NULL NULL
-NULL NULL 20 val_20 NULL NULL
-NULL NULL 24 val_24 NULL NULL
-NULL NULL 24 val_24 NULL NULL
-NULL NULL 24 val_24 NULL NULL
-NULL NULL 24 val_24 NULL NULL
+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: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ expr: 4
+ type: string
+ expr: 5
+ type: string
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ expr: 4
+ type: string
+ expr: 5
+ type: string
+ File Output Operator
+ table:
+ name: dest1
+ serde: simple_meta
+ 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: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ tag: 1
+ key expressions:
+ expr: 0
+ type: string
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ # partition fields: 1
+ c:a:src1
+ Filter Operator
+ predicate:
+ expr: ((key > 10) and (key < 20))
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ tag: 0
+ key expressions:
+ expr: 0
+ type: string
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ # partition fields: 1
+ c:c:src3
+ Filter Operator
+ predicate:
+ expr: ((key > 20) and (key < 25))
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ tag: 2
+ key expressions:
+ expr: 0
+ type: string
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ # partition fields: 1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: simple_meta
+ 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
+15 val_15 NULL NULL NULL NULL
+15 val_15 NULL NULL NULL NULL
+17 val_17 17 val_17 NULL NULL
+18 val_18 18 val_18 NULL NULL
+18 val_18 18 val_18 NULL NULL
+18 val_18 18 val_18 NULL NULL
+18 val_18 18 val_18 NULL NULL
+19 val_19 19 val_19 NULL NULL
+NULL NULL 20 val_20 NULL NULL
+NULL NULL 24 val_24 NULL NULL
+NULL NULL 24 val_24 NULL NULL
+NULL NULL 24 val_24 NULL NULL
+NULL NULL 24 val_24 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=697291&r1=697290&r2=697291&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 Fri Sep 19 16:56:30 2008
@@ -1,108 +1,110 @@
-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
-15 val_15 NULL NULL
-15 val_15 NULL NULL
+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: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ Filter Operator
+ predicate:
+ expr: (2 is null and 0 is not null)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ File Output Operator
+ table:
+ name: dest1
+ serde: simple_meta
+ 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: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ tag: 1
+ key expressions:
+ expr: 0
+ type: string
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ # partition fields: 1
+ c:a:src1
+ Filter Operator
+ predicate:
+ expr: ((key > 10) and (key < 20))
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ tag: 0
+ key expressions:
+ expr: 0
+ type: string
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ # partition fields: 1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: simple_meta
+ 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
+15 val_15 NULL NULL
+15 val_15 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=697291&r1=697290&r2=697291&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 Fri Sep 19 16:56:30 2008
@@ -1,593 +1,597 @@
-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
-27 val_27 2008-04-08 11
-165 val_165 2008-04-08 11
-409 val_409 2008-04-08 11
-255 val_255 2008-04-08 11
-278 val_278 2008-04-08 11
-98 val_98 2008-04-08 11
-484 val_484 2008-04-08 11
-265 val_265 2008-04-08 11
-193 val_193 2008-04-08 11
-401 val_401 2008-04-08 11
-150 val_150 2008-04-08 11
-273 val_273 2008-04-08 11
-224 val_224 2008-04-08 11
-369 val_369 2008-04-08 11
-66 val_66 2008-04-08 11
-128 val_128 2008-04-08 11
-213 val_213 2008-04-08 11
-146 val_146 2008-04-08 11
-406 val_406 2008-04-08 11
-429 val_429 2008-04-08 11
-374 val_374 2008-04-08 11
-152 val_152 2008-04-08 11
-469 val_469 2008-04-08 11
-145 val_145 2008-04-08 11
-495 val_495 2008-04-08 11
-37 val_37 2008-04-08 11
-327 val_327 2008-04-08 11
-281 val_281 2008-04-08 11
-277 val_277 2008-04-08 11
-209 val_209 2008-04-08 11
-15 val_15 2008-04-08 11
-82 val_82 2008-04-08 11
-403 val_403 2008-04-08 11
-166 val_166 2008-04-08 11
-417 val_417 2008-04-08 11
-430 val_430 2008-04-08 11
-252 val_252 2008-04-08 11
-292 val_292 2008-04-08 11
-219 val_219 2008-04-08 11
-287 val_287 2008-04-08 11
-153 val_153 2008-04-08 11
-193 val_193 2008-04-08 11
-338 val_338 2008-04-08 11
-446 val_446 2008-04-08 11
-459 val_459 2008-04-08 11
-394 val_394 2008-04-08 11
-237 val_237 2008-04-08 11
-482 val_482 2008-04-08 11
-174 val_174 2008-04-08 11
-413 val_413 2008-04-08 11
-494 val_494 2008-04-08 11
-207 val_207 2008-04-08 11
-199 val_199 2008-04-08 11
-466 val_466 2008-04-08 11
-208 val_208 2008-04-08 11
-174 val_174 2008-04-08 11
-399 val_399 2008-04-08 11
-396 val_396 2008-04-08 11
-247 val_247 2008-04-08 11
-417 val_417 2008-04-08 11
-489 val_489 2008-04-08 11
-162 val_162 2008-04-08 11
-377 val_377 2008-04-08 11
-397 val_397 2008-04-08 11
-309 val_309 2008-04-08 11
-365 val_365 2008-04-08 11
-266 val_266 2008-04-08 11
-439 val_439 2008-04-08 11
-342 val_342 2008-04-08 11
-367 val_367 2008-04-08 11
-325 val_325 2008-04-08 11
-167 val_167 2008-04-08 11
-195 val_195 2008-04-08 11
-475 val_475 2008-04-08 11
-17 val_17 2008-04-08 11
-113 val_113 2008-04-08 11
-155 val_155 2008-04-08 11
-203 val_203 2008-04-08 11
-339 val_339 2008-04-08 11
-0 val_0 2008-04-08 11
-455 val_455 2008-04-08 11
-128 val_128 2008-04-08 11
-311 val_311 2008-04-08 11
-316 val_316 2008-04-08 11
-57 val_57 2008-04-08 11
-302 val_302 2008-04-08 11
-205 val_205 2008-04-08 11
-149 val_149 2008-04-08 11
-438 val_438 2008-04-08 11
-345 val_345 2008-04-08 11
-129 val_129 2008-04-08 11
-170 val_170 2008-04-08 11
-20 val_20 2008-04-08 11
-489 val_489 2008-04-08 11
-157 val_157 2008-04-08 11
-378 val_378 2008-04-08 11
-221 val_221 2008-04-08 11
-92 val_92 2008-04-08 11
-111 val_111 2008-04-08 11
-47 val_47 2008-04-08 11
-72 val_72 2008-04-08 11
-4 val_4 2008-04-08 11
-280 val_280 2008-04-08 11
-35 val_35 2008-04-08 11
-427 val_427 2008-04-08 11
-277 val_277 2008-04-08 11
-208 val_208 2008-04-08 11
-356 val_356 2008-04-08 11
-399 val_399 2008-04-08 11
-169 val_169 2008-04-08 11
-382 val_382 2008-04-08 11
-498 val_498 2008-04-08 11
-125 val_125 2008-04-08 11
-386 val_386 2008-04-08 11
-437 val_437 2008-04-08 11
-469 val_469 2008-04-08 11
-192 val_192 2008-04-08 11
-286 val_286 2008-04-08 11
-187 val_187 2008-04-08 11
-176 val_176 2008-04-08 11
-54 val_54 2008-04-08 11
-459 val_459 2008-04-08 11
-51 val_51 2008-04-08 11
-138 val_138 2008-04-08 11
-103 val_103 2008-04-08 11
-239 val_239 2008-04-08 11
-213 val_213 2008-04-08 11
-216 val_216 2008-04-08 11
-430 val_430 2008-04-08 11
-278 val_278 2008-04-08 11
-176 val_176 2008-04-08 11
-289 val_289 2008-04-08 11
-221 val_221 2008-04-08 11
-65 val_65 2008-04-08 11
-318 val_318 2008-04-08 11
-332 val_332 2008-04-08 11
-311 val_311 2008-04-08 11
-275 val_275 2008-04-08 11
-137 val_137 2008-04-08 11
-241 val_241 2008-04-08 11
-83 val_83 2008-04-08 11
-333 val_333 2008-04-08 11
-180 val_180 2008-04-08 11
-284 val_284 2008-04-08 11
-12 val_12 2008-04-08 11
-230 val_230 2008-04-08 11
-181 val_181 2008-04-08 11
-67 val_67 2008-04-08 11
-260 val_260 2008-04-08 11
-404 val_404 2008-04-08 11
-384 val_384 2008-04-08 11
-489 val_489 2008-04-08 11
-353 val_353 2008-04-08 11
-373 val_373 2008-04-08 11
-272 val_272 2008-04-08 11
-138 val_138 2008-04-08 11
-217 val_217 2008-04-08 11
-84 val_84 2008-04-08 11
-348 val_348 2008-04-08 11
-466 val_466 2008-04-08 11
-58 val_58 2008-04-08 11
-8 val_8 2008-04-08 11
-411 val_411 2008-04-08 11
-230 val_230 2008-04-08 11
-208 val_208 2008-04-08 11
-348 val_348 2008-04-08 11
-24 val_24 2008-04-08 11
-463 val_463 2008-04-08 11
-431 val_431 2008-04-08 11
-179 val_179 2008-04-08 11
-172 val_172 2008-04-08 11
-42 val_42 2008-04-08 11
-129 val_129 2008-04-08 11
-158 val_158 2008-04-08 11
-119 val_119 2008-04-08 11
-496 val_496 2008-04-08 11
-0 val_0 2008-04-08 11
-322 val_322 2008-04-08 11
-197 val_197 2008-04-08 11
-468 val_468 2008-04-08 11
-393 val_393 2008-04-08 11
-454 val_454 2008-04-08 11
-100 val_100 2008-04-08 11
-298 val_298 2008-04-08 11
-199 val_199 2008-04-08 11
-191 val_191 2008-04-08 11
-418 val_418 2008-04-08 11
-96 val_96 2008-04-08 11
-26 val_26 2008-04-08 11
-165 val_165 2008-04-08 11
-327 val_327 2008-04-08 11
-230 val_230 2008-04-08 11
-205 val_205 2008-04-08 11
-120 val_120 2008-04-08 11
-131 val_131 2008-04-08 11
-51 val_51 2008-04-08 11
-404 val_404 2008-04-08 11
-43 val_43 2008-04-08 11
-436 val_436 2008-04-08 11
-156 val_156 2008-04-08 11
-469 val_469 2008-04-08 11
-468 val_468 2008-04-08 11
-308 val_308 2008-04-08 11
-95 val_95 2008-04-08 11
-196 val_196 2008-04-08 11
-288 val_288 2008-04-08 11
-481 val_481 2008-04-08 11
-457 val_457 2008-04-08 11
-98 val_98 2008-04-08 11
-282 val_282 2008-04-08 11
-197 val_197 2008-04-08 11
-187 val_187 2008-04-08 11
-318 val_318 2008-04-08 11
-318 val_318 2008-04-08 11
-409 val_409 2008-04-08 11
-470 val_470 2008-04-08 11
-137 val_137 2008-04-08 11
-369 val_369 2008-04-08 11
-316 val_316 2008-04-08 11
-169 val_169 2008-04-08 11
-413 val_413 2008-04-08 11
-85 val_85 2008-04-08 11
-77 val_77 2008-04-08 11
-0 val_0 2008-04-08 11
-490 val_490 2008-04-08 11
-87 val_87 2008-04-08 11
-364 val_364 2008-04-08 11
-179 val_179 2008-04-08 11
-118 val_118 2008-04-08 11
-134 val_134 2008-04-08 11
-395 val_395 2008-04-08 11
-282 val_282 2008-04-08 11
-138 val_138 2008-04-08 11
-238 val_238 2008-04-08 11
-419 val_419 2008-04-08 11
-15 val_15 2008-04-08 11
-118 val_118 2008-04-08 11
-72 val_72 2008-04-08 11
-90 val_90 2008-04-08 11
-307 val_307 2008-04-08 11
-19 val_19 2008-04-08 11
-435 val_435 2008-04-08 11
-10 val_10 2008-04-08 11
-277 val_277 2008-04-08 11
-273 val_273 2008-04-08 11
-306 val_306 2008-04-08 11
-224 val_224 2008-04-08 11
-309 val_309 2008-04-08 11
-389 val_389 2008-04-08 11
-327 val_327 2008-04-08 11
-242 val_242 2008-04-08 11
-369 val_369 2008-04-08 11
-392 val_392 2008-04-08 11
-272 val_272 2008-04-08 11
-331 val_331 2008-04-08 11
-401 val_401 2008-04-08 11
-242 val_242 2008-04-08 11
-452 val_452 2008-04-08 11
-177 val_177 2008-04-08 11
-226 val_226 2008-04-08 11
-5 val_5 2008-04-08 11
-497 val_497 2008-04-08 11
-402 val_402 2008-04-08 11
-396 val_396 2008-04-08 11
-317 val_317 2008-04-08 11
-395 val_395 2008-04-08 11
-58 val_58 2008-04-08 11
-35 val_35 2008-04-08 11
-336 val_336 2008-04-08 11
-95 val_95 2008-04-08 11
-11 val_11 2008-04-08 11
-168 val_168 2008-04-08 11
-34 val_34 2008-04-08 11
-229 val_229 2008-04-08 11
-233 val_233 2008-04-08 11
-143 val_143 2008-04-08 11
-472 val_472 2008-04-08 11
-322 val_322 2008-04-08 11
-498 val_498 2008-04-08 11
-160 val_160 2008-04-08 11
-195 val_195 2008-04-08 11
-42 val_42 2008-04-08 11
-321 val_321 2008-04-08 11
-430 val_430 2008-04-08 11
-119 val_119 2008-04-08 11
-489 val_489 2008-04-08 11
-458 val_458 2008-04-08 11
-78 val_78 2008-04-08 11
-76 val_76 2008-04-08 11
-41 val_41 2008-04-08 11
-223 val_223 2008-04-08 11
-492 val_492 2008-04-08 11
-149 val_149 2008-04-08 11
-449 val_449 2008-04-08 11
-218 val_218 2008-04-08 11
-228 val_228 2008-04-08 11
-138 val_138 2008-04-08 11
-453 val_453 2008-04-08 11
-30 val_30 2008-04-08 11
-209 val_209 2008-04-08 11
-64 val_64 2008-04-08 11
-468 val_468 2008-04-08 11
-76 val_76 2008-04-08 11
-74 val_74 2008-04-08 11
-342 val_342 2008-04-08 11
-69 val_69 2008-04-08 11
-230 val_230 2008-04-08 11
-33 val_33 2008-04-08 11
-368 val_368 2008-04-08 11
-103 val_103 2008-04-08 11
-296 val_296 2008-04-08 11
-113 val_113 2008-04-08 11
-216 val_216 2008-04-08 11
-367 val_367 2008-04-08 11
-344 val_344 2008-04-08 11
-167 val_167 2008-04-08 11
-274 val_274 2008-04-08 11
-219 val_219 2008-04-08 11
-239 val_239 2008-04-08 11
-485 val_485 2008-04-08 11
-116 val_116 2008-04-08 11
-223 val_223 2008-04-08 11
-256 val_256 2008-04-08 11
-263 val_263 2008-04-08 11
-70 val_70 2008-04-08 11
-487 val_487 2008-04-08 11
-480 val_480 2008-04-08 11
-401 val_401 2008-04-08 11
-288 val_288 2008-04-08 11
-191 val_191 2008-04-08 11
-5 val_5 2008-04-08 11
-244 val_244 2008-04-08 11
-438 val_438 2008-04-08 11
-128 val_128 2008-04-08 11
-467 val_467 2008-04-08 11
-432 val_432 2008-04-08 11
-202 val_202 2008-04-08 11
-316 val_316 2008-04-08 11
-229 val_229 2008-04-08 11
-469 val_469 2008-04-08 11
-463 val_463 2008-04-08 11
-280 val_280 2008-04-08 11
-2 val_2 2008-04-08 11
-35 val_35 2008-04-08 11
-283 val_283 2008-04-08 11
-331 val_331 2008-04-08 11
-235 val_235 2008-04-08 11
-80 val_80 2008-04-08 11
-44 val_44 2008-04-08 11
-193 val_193 2008-04-08 11
-321 val_321 2008-04-08 11
-335 val_335 2008-04-08 11
-104 val_104 2008-04-08 11
-466 val_466 2008-04-08 11
-366 val_366 2008-04-08 11
-175 val_175 2008-04-08 11
-403 val_403 2008-04-08 11
-483 val_483 2008-04-08 11
-53 val_53 2008-04-08 11
-105 val_105 2008-04-08 11
-257 val_257 2008-04-08 11
-406 val_406 2008-04-08 11
-409 val_409 2008-04-08 11
-190 val_190 2008-04-08 11
-406 val_406 2008-04-08 11
-401 val_401 2008-04-08 11
-114 val_114 2008-04-08 11
-258 val_258 2008-04-08 11
-90 val_90 2008-04-08 11
-203 val_203 2008-04-08 11
-262 val_262 2008-04-08 11
-348 val_348 2008-04-08 11
-424 val_424 2008-04-08 11
-12 val_12 2008-04-08 11
-396 val_396 2008-04-08 11
-201 val_201 2008-04-08 11
-217 val_217 2008-04-08 11
-164 val_164 2008-04-08 11
-431 val_431 2008-04-08 11
-454 val_454 2008-04-08 11
-478 val_478 2008-04-08 11
-298 val_298 2008-04-08 11
-125 val_125 2008-04-08 11
-431 val_431 2008-04-08 11
-164 val_164 2008-04-08 11
-424 val_424 2008-04-08 11
-187 val_187 2008-04-08 11
-382 val_382 2008-04-08 11
-5 val_5 2008-04-08 11
-70 val_70 2008-04-08 11
-397 val_397 2008-04-08 11
-480 val_480 2008-04-08 11
-291 val_291 2008-04-08 11
-24 val_24 2008-04-08 11
-351 val_351 2008-04-08 11
-255 val_255 2008-04-08 11
-104 val_104 2008-04-08 11
-70 val_70 2008-04-08 11
-163 val_163 2008-04-08 11
-438 val_438 2008-04-08 11
-119 val_119 2008-04-08 11
-414 val_414 2008-04-08 11
-200 val_200 2008-04-08 11
-491 val_491 2008-04-08 11
-237 val_237 2008-04-08 11
-439 val_439 2008-04-08 11
-360 val_360 2008-04-08 11
-248 val_248 2008-04-08 11
-479 val_479 2008-04-08 11
-305 val_305 2008-04-08 11
-417 val_417 2008-04-08 11
-199 val_199 2008-04-08 11
-444 val_444 2008-04-08 11
-120 val_120 2008-04-08 11
-429 val_429 2008-04-08 11
-169 val_169 2008-04-08 11
-443 val_443 2008-04-08 11
-323 val_323 2008-04-08 11
-325 val_325 2008-04-08 11
-277 val_277 2008-04-08 11
-230 val_230 2008-04-08 11
-478 val_478 2008-04-08 11
-178 val_178 2008-04-08 11
-468 val_468 2008-04-08 11
-310 val_310 2008-04-08 11
-317 val_317 2008-04-08 11
-333 val_333 2008-04-08 11
-493 val_493 2008-04-08 11
-460 val_460 2008-04-08 11
-207 val_207 2008-04-08 11
-249 val_249 2008-04-08 11
-265 val_265 2008-04-08 11
-480 val_480 2008-04-08 11
-83 val_83 2008-04-08 11
-136 val_136 2008-04-08 11
-353 val_353 2008-04-08 11
-172 val_172 2008-04-08 11
-214 val_214 2008-04-08 11
-462 val_462 2008-04-08 11
-233 val_233 2008-04-08 11
-406 val_406 2008-04-08 11
-133 val_133 2008-04-08 11
-175 val_175 2008-04-08 11
-189 val_189 2008-04-08 11
-454 val_454 2008-04-08 11
-375 val_375 2008-04-08 11
-401 val_401 2008-04-08 11
-421 val_421 2008-04-08 11
-407 val_407 2008-04-08 11
-384 val_384 2008-04-08 11
-256 val_256 2008-04-08 11
-26 val_26 2008-04-08 11
-134 val_134 2008-04-08 11
-67 val_67 2008-04-08 11
-384 val_384 2008-04-08 11
-379 val_379 2008-04-08 11
-18 val_18 2008-04-08 11
-462 val_462 2008-04-08 11
-492 val_492 2008-04-08 11
-100 val_100 2008-04-08 11
-298 val_298 2008-04-08 11
-9 val_9 2008-04-08 11
-341 val_341 2008-04-08 11
-498 val_498 2008-04-08 11
-146 val_146 2008-04-08 11
-458 val_458 2008-04-08 11
-362 val_362 2008-04-08 11
-186 val_186 2008-04-08 11
-285 val_285 2008-04-08 11
-348 val_348 2008-04-08 11
-167 val_167 2008-04-08 11
-18 val_18 2008-04-08 11
-273 val_273 2008-04-08 11
-183 val_183 2008-04-08 11
-281 val_281 2008-04-08 11
-344 val_344 2008-04-08 11
-97 val_97 2008-04-08 11
-469 val_469 2008-04-08 11
-315 val_315 2008-04-08 11
-84 val_84 2008-04-08 11
-28 val_28 2008-04-08 11
-37 val_37 2008-04-08 11
-448 val_448 2008-04-08 11
-152 val_152 2008-04-08 11
-348 val_348 2008-04-08 11
-307 val_307 2008-04-08 11
-194 val_194 2008-04-08 11
-414 val_414 2008-04-08 11
-477 val_477 2008-04-08 11
-222 val_222 2008-04-08 11
-126 val_126 2008-04-08 11
-90 val_90 2008-04-08 11
-169 val_169 2008-04-08 11
-403 val_403 2008-04-08 11
-400 val_400 2008-04-08 11
-200 val_200 2008-04-08 11
-97 val_97 2008-04-08 11
+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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ Path -> Partition:
+ file:/data/zshao/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:/data/zshao/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: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ File Output Operator
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value,dt,hr
+ SORTBUCKETCOLSPREFIX TRUE
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ directory: /tmp/hive-zshao/640225297.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
+ SORTBUCKETCOLSPREFIX TRUE
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ source: /tmp/hive-zshao/640225297.10000.insclause-0
+
+
+238 val_238 2008-04-08 11
+86 val_86 2008-04-08 11
+311 val_311 2008-04-08 11
+27 val_27 2008-04-08 11
+165 val_165 2008-04-08 11
+409 val_409 2008-04-08 11
+255 val_255 2008-04-08 11
+278 val_278 2008-04-08 11
+98 val_98 2008-04-08 11
+484 val_484 2008-04-08 11
+265 val_265 2008-04-08 11
+193 val_193 2008-04-08 11
+401 val_401 2008-04-08 11
+150 val_150 2008-04-08 11
+273 val_273 2008-04-08 11
+224 val_224 2008-04-08 11
+369 val_369 2008-04-08 11
+66 val_66 2008-04-08 11
+128 val_128 2008-04-08 11
+213 val_213 2008-04-08 11
+146 val_146 2008-04-08 11
+406 val_406 2008-04-08 11
+429 val_429 2008-04-08 11
+374 val_374 2008-04-08 11
+152 val_152 2008-04-08 11
+469 val_469 2008-04-08 11
+145 val_145 2008-04-08 11
+495 val_495 2008-04-08 11
+37 val_37 2008-04-08 11
+327 val_327 2008-04-08 11
+281 val_281 2008-04-08 11
+277 val_277 2008-04-08 11
+209 val_209 2008-04-08 11
+15 val_15 2008-04-08 11
+82 val_82 2008-04-08 11
+403 val_403 2008-04-08 11
+166 val_166 2008-04-08 11
+417 val_417 2008-04-08 11
+430 val_430 2008-04-08 11
+252 val_252 2008-04-08 11
+292 val_292 2008-04-08 11
+219 val_219 2008-04-08 11
+287 val_287 2008-04-08 11
+153 val_153 2008-04-08 11
+193 val_193 2008-04-08 11
+338 val_338 2008-04-08 11
+446 val_446 2008-04-08 11
+459 val_459 2008-04-08 11
+394 val_394 2008-04-08 11
+237 val_237 2008-04-08 11
+482 val_482 2008-04-08 11
+174 val_174 2008-04-08 11
+413 val_413 2008-04-08 11
+494 val_494 2008-04-08 11
+207 val_207 2008-04-08 11
+199 val_199 2008-04-08 11
+466 val_466 2008-04-08 11
+208 val_208 2008-04-08 11
+174 val_174 2008-04-08 11
+399 val_399 2008-04-08 11
+396 val_396 2008-04-08 11
+247 val_247 2008-04-08 11
+417 val_417 2008-04-08 11
+489 val_489 2008-04-08 11
+162 val_162 2008-04-08 11
+377 val_377 2008-04-08 11
+397 val_397 2008-04-08 11
+309 val_309 2008-04-08 11
+365 val_365 2008-04-08 11
+266 val_266 2008-04-08 11
+439 val_439 2008-04-08 11
+342 val_342 2008-04-08 11
+367 val_367 2008-04-08 11
+325 val_325 2008-04-08 11
+167 val_167 2008-04-08 11
+195 val_195 2008-04-08 11
+475 val_475 2008-04-08 11
+17 val_17 2008-04-08 11
+113 val_113 2008-04-08 11
+155 val_155 2008-04-08 11
+203 val_203 2008-04-08 11
+339 val_339 2008-04-08 11
+0 val_0 2008-04-08 11
+455 val_455 2008-04-08 11
+128 val_128 2008-04-08 11
+311 val_311 2008-04-08 11
+316 val_316 2008-04-08 11
+57 val_57 2008-04-08 11
+302 val_302 2008-04-08 11
+205 val_205 2008-04-08 11
+149 val_149 2008-04-08 11
+438 val_438 2008-04-08 11
+345 val_345 2008-04-08 11
+129 val_129 2008-04-08 11
+170 val_170 2008-04-08 11
+20 val_20 2008-04-08 11
+489 val_489 2008-04-08 11
+157 val_157 2008-04-08 11
+378 val_378 2008-04-08 11
+221 val_221 2008-04-08 11
+92 val_92 2008-04-08 11
+111 val_111 2008-04-08 11
+47 val_47 2008-04-08 11
+72 val_72 2008-04-08 11
+4 val_4 2008-04-08 11
+280 val_280 2008-04-08 11
+35 val_35 2008-04-08 11
+427 val_427 2008-04-08 11
+277 val_277 2008-04-08 11
+208 val_208 2008-04-08 11
+356 val_356 2008-04-08 11
+399 val_399 2008-04-08 11
+169 val_169 2008-04-08 11
+382 val_382 2008-04-08 11
+498 val_498 2008-04-08 11
+125 val_125 2008-04-08 11
+386 val_386 2008-04-08 11
+437 val_437 2008-04-08 11
+469 val_469 2008-04-08 11
+192 val_192 2008-04-08 11
+286 val_286 2008-04-08 11
+187 val_187 2008-04-08 11
+176 val_176 2008-04-08 11
+54 val_54 2008-04-08 11
+459 val_459 2008-04-08 11
+51 val_51 2008-04-08 11
+138 val_138 2008-04-08 11
+103 val_103 2008-04-08 11
+239 val_239 2008-04-08 11
+213 val_213 2008-04-08 11
+216 val_216 2008-04-08 11
+430 val_430 2008-04-08 11
+278 val_278 2008-04-08 11
+176 val_176 2008-04-08 11
+289 val_289 2008-04-08 11
+221 val_221 2008-04-08 11
+65 val_65 2008-04-08 11
+318 val_318 2008-04-08 11
+332 val_332 2008-04-08 11
+311 val_311 2008-04-08 11
+275 val_275 2008-04-08 11
+137 val_137 2008-04-08 11
+241 val_241 2008-04-08 11
+83 val_83 2008-04-08 11
+333 val_333 2008-04-08 11
+180 val_180 2008-04-08 11
+284 val_284 2008-04-08 11
+12 val_12 2008-04-08 11
+230 val_230 2008-04-08 11
+181 val_181 2008-04-08 11
+67 val_67 2008-04-08 11
+260 val_260 2008-04-08 11
+404 val_404 2008-04-08 11
+384 val_384 2008-04-08 11
+489 val_489 2008-04-08 11
+353 val_353 2008-04-08 11
+373 val_373 2008-04-08 11
+272 val_272 2008-04-08 11
+138 val_138 2008-04-08 11
+217 val_217 2008-04-08 11
+84 val_84 2008-04-08 11
+348 val_348 2008-04-08 11
+466 val_466 2008-04-08 11
+58 val_58 2008-04-08 11
+8 val_8 2008-04-08 11
+411 val_411 2008-04-08 11
+230 val_230 2008-04-08 11
+208 val_208 2008-04-08 11
+348 val_348 2008-04-08 11
+24 val_24 2008-04-08 11
+463 val_463 2008-04-08 11
+431 val_431 2008-04-08 11
+179 val_179 2008-04-08 11
+172 val_172 2008-04-08 11
+42 val_42 2008-04-08 11
+129 val_129 2008-04-08 11
+158 val_158 2008-04-08 11
+119 val_119 2008-04-08 11
+496 val_496 2008-04-08 11
+0 val_0 2008-04-08 11
+322 val_322 2008-04-08 11
+197 val_197 2008-04-08 11
+468 val_468 2008-04-08 11
+393 val_393 2008-04-08 11
+454 val_454 2008-04-08 11
+100 val_100 2008-04-08 11
+298 val_298 2008-04-08 11
+199 val_199 2008-04-08 11
+191 val_191 2008-04-08 11
+418 val_418 2008-04-08 11
+96 val_96 2008-04-08 11
+26 val_26 2008-04-08 11
+165 val_165 2008-04-08 11
+327 val_327 2008-04-08 11
+230 val_230 2008-04-08 11
+205 val_205 2008-04-08 11
+120 val_120 2008-04-08 11
+131 val_131 2008-04-08 11
+51 val_51 2008-04-08 11
+404 val_404 2008-04-08 11
+43 val_43 2008-04-08 11
+436 val_436 2008-04-08 11
+156 val_156 2008-04-08 11
+469 val_469 2008-04-08 11
+468 val_468 2008-04-08 11
+308 val_308 2008-04-08 11
+95 val_95 2008-04-08 11
+196 val_196 2008-04-08 11
+288 val_288 2008-04-08 11
+481 val_481 2008-04-08 11
+457 val_457 2008-04-08 11
+98 val_98 2008-04-08 11
+282 val_282 2008-04-08 11
+197 val_197 2008-04-08 11
+187 val_187 2008-04-08 11
+318 val_318 2008-04-08 11
+318 val_318 2008-04-08 11
+409 val_409 2008-04-08 11
+470 val_470 2008-04-08 11
+137 val_137 2008-04-08 11
+369 val_369 2008-04-08 11
+316 val_316 2008-04-08 11
+169 val_169 2008-04-08 11
+413 val_413 2008-04-08 11
+85 val_85 2008-04-08 11
+77 val_77 2008-04-08 11
+0 val_0 2008-04-08 11
+490 val_490 2008-04-08 11
+87 val_87 2008-04-08 11
+364 val_364 2008-04-08 11
+179 val_179 2008-04-08 11
+118 val_118 2008-04-08 11
+134 val_134 2008-04-08 11
+395 val_395 2008-04-08 11
+282 val_282 2008-04-08 11
+138 val_138 2008-04-08 11
+238 val_238 2008-04-08 11
+419 val_419 2008-04-08 11
+15 val_15 2008-04-08 11
+118 val_118 2008-04-08 11
+72 val_72 2008-04-08 11
+90 val_90 2008-04-08 11
+307 val_307 2008-04-08 11
+19 val_19 2008-04-08 11
+435 val_435 2008-04-08 11
+10 val_10 2008-04-08 11
+277 val_277 2008-04-08 11
+273 val_273 2008-04-08 11
+306 val_306 2008-04-08 11
+224 val_224 2008-04-08 11
+309 val_309 2008-04-08 11
+389 val_389 2008-04-08 11
+327 val_327 2008-04-08 11
+242 val_242 2008-04-08 11
+369 val_369 2008-04-08 11
+392 val_392 2008-04-08 11
+272 val_272 2008-04-08 11
+331 val_331 2008-04-08 11
+401 val_401 2008-04-08 11
+242 val_242 2008-04-08 11
+452 val_452 2008-04-08 11
+177 val_177 2008-04-08 11
+226 val_226 2008-04-08 11
+5 val_5 2008-04-08 11
+497 val_497 2008-04-08 11
+402 val_402 2008-04-08 11
+396 val_396 2008-04-08 11
+317 val_317 2008-04-08 11
+395 val_395 2008-04-08 11
+58 val_58 2008-04-08 11
+35 val_35 2008-04-08 11
+336 val_336 2008-04-08 11
+95 val_95 2008-04-08 11
+11 val_11 2008-04-08 11
+168 val_168 2008-04-08 11
+34 val_34 2008-04-08 11
+229 val_229 2008-04-08 11
+233 val_233 2008-04-08 11
+143 val_143 2008-04-08 11
+472 val_472 2008-04-08 11
+322 val_322 2008-04-08 11
+498 val_498 2008-04-08 11
+160 val_160 2008-04-08 11
+195 val_195 2008-04-08 11
+42 val_42 2008-04-08 11
+321 val_321 2008-04-08 11
+430 val_430 2008-04-08 11
+119 val_119 2008-04-08 11
+489 val_489 2008-04-08 11
+458 val_458 2008-04-08 11
+78 val_78 2008-04-08 11
+76 val_76 2008-04-08 11
+41 val_41 2008-04-08 11
+223 val_223 2008-04-08 11
+492 val_492 2008-04-08 11
+149 val_149 2008-04-08 11
+449 val_449 2008-04-08 11
+218 val_218 2008-04-08 11
+228 val_228 2008-04-08 11
+138 val_138 2008-04-08 11
+453 val_453 2008-04-08 11
+30 val_30 2008-04-08 11
+209 val_209 2008-04-08 11
+64 val_64 2008-04-08 11
+468 val_468 2008-04-08 11
+76 val_76 2008-04-08 11
+74 val_74 2008-04-08 11
+342 val_342 2008-04-08 11
+69 val_69 2008-04-08 11
+230 val_230 2008-04-08 11
+33 val_33 2008-04-08 11
+368 val_368 2008-04-08 11
+103 val_103 2008-04-08 11
+296 val_296 2008-04-08 11
+113 val_113 2008-04-08 11
+216 val_216 2008-04-08 11
+367 val_367 2008-04-08 11
+344 val_344 2008-04-08 11
+167 val_167 2008-04-08 11
+274 val_274 2008-04-08 11
+219 val_219 2008-04-08 11
+239 val_239 2008-04-08 11
+485 val_485 2008-04-08 11
+116 val_116 2008-04-08 11
+223 val_223 2008-04-08 11
+256 val_256 2008-04-08 11
+263 val_263 2008-04-08 11
+70 val_70 2008-04-08 11
+487 val_487 2008-04-08 11
+480 val_480 2008-04-08 11
+401 val_401 2008-04-08 11
+288 val_288 2008-04-08 11
+191 val_191 2008-04-08 11
+5 val_5 2008-04-08 11
+244 val_244 2008-04-08 11
+438 val_438 2008-04-08 11
+128 val_128 2008-04-08 11
+467 val_467 2008-04-08 11
+432 val_432 2008-04-08 11
+202 val_202 2008-04-08 11
+316 val_316 2008-04-08 11
+229 val_229 2008-04-08 11
+469 val_469 2008-04-08 11
+463 val_463 2008-04-08 11
+280 val_280 2008-04-08 11
+2 val_2 2008-04-08 11
+35 val_35 2008-04-08 11
+283 val_283 2008-04-08 11
+331 val_331 2008-04-08 11
+235 val_235 2008-04-08 11
+80 val_80 2008-04-08 11
+44 val_44 2008-04-08 11
+193 val_193 2008-04-08 11
+321 val_321 2008-04-08 11
+335 val_335 2008-04-08 11
+104 val_104 2008-04-08 11
+466 val_466 2008-04-08 11
+366 val_366 2008-04-08 11
+175 val_175 2008-04-08 11
+403 val_403 2008-04-08 11
+483 val_483 2008-04-08 11
+53 val_53 2008-04-08 11
+105 val_105 2008-04-08 11
+257 val_257 2008-04-08 11
+406 val_406 2008-04-08 11
+409 val_409 2008-04-08 11
+190 val_190 2008-04-08 11
+406 val_406 2008-04-08 11
+401 val_401 2008-04-08 11
+114 val_114 2008-04-08 11
+258 val_258 2008-04-08 11
+90 val_90 2008-04-08 11
+203 val_203 2008-04-08 11
+262 val_262 2008-04-08 11
+348 val_348 2008-04-08 11
+424 val_424 2008-04-08 11
+12 val_12 2008-04-08 11
+396 val_396 2008-04-08 11
+201 val_201 2008-04-08 11
+217 val_217 2008-04-08 11
+164 val_164 2008-04-08 11
+431 val_431 2008-04-08 11
+454 val_454 2008-04-08 11
+478 val_478 2008-04-08 11
+298 val_298 2008-04-08 11
+125 val_125 2008-04-08 11
+431 val_431 2008-04-08 11
+164 val_164 2008-04-08 11
+424 val_424 2008-04-08 11
+187 val_187 2008-04-08 11
+382 val_382 2008-04-08 11
+5 val_5 2008-04-08 11
+70 val_70 2008-04-08 11
+397 val_397 2008-04-08 11
+480 val_480 2008-04-08 11
+291 val_291 2008-04-08 11
+24 val_24 2008-04-08 11
+351 val_351 2008-04-08 11
+255 val_255 2008-04-08 11
+104 val_104 2008-04-08 11
+70 val_70 2008-04-08 11
+163 val_163 2008-04-08 11
+438 val_438 2008-04-08 11
+119 val_119 2008-04-08 11
+414 val_414 2008-04-08 11
+200 val_200 2008-04-08 11
+491 val_491 2008-04-08 11
+237 val_237 2008-04-08 11
+439 val_439 2008-04-08 11
+360 val_360 2008-04-08 11
+248 val_248 2008-04-08 11
+479 val_479 2008-04-08 11
+305 val_305 2008-04-08 11
+417 val_417 2008-04-08 11
+199 val_199 2008-04-08 11
+444 val_444 2008-04-08 11
+120 val_120 2008-04-08 11
+429 val_429 2008-04-08 11
+169 val_169 2008-04-08 11
+443 val_443 2008-04-08 11
+323 val_323 2008-04-08 11
+325 val_325 2008-04-08 11
+277 val_277 2008-04-08 11
+230 val_230 2008-04-08 11
+478 val_478 2008-04-08 11
+178 val_178 2008-04-08 11
+468 val_468 2008-04-08 11
+310 val_310 2008-04-08 11
+317 val_317 2008-04-08 11
+333 val_333 2008-04-08 11
+493 val_493 2008-04-08 11
+460 val_460 2008-04-08 11
+207 val_207 2008-04-08 11
+249 val_249 2008-04-08 11
+265 val_265 2008-04-08 11
+480 val_480 2008-04-08 11
+83 val_83 2008-04-08 11
+136 val_136 2008-04-08 11
+353 val_353 2008-04-08 11
+172 val_172 2008-04-08 11
+214 val_214 2008-04-08 11
+462 val_462 2008-04-08 11
+233 val_233 2008-04-08 11
+406 val_406 2008-04-08 11
+133 val_133 2008-04-08 11
+175 val_175 2008-04-08 11
+189 val_189 2008-04-08 11
+454 val_454 2008-04-08 11
+375 val_375 2008-04-08 11
+401 val_401 2008-04-08 11
+421 val_421 2008-04-08 11
+407 val_407 2008-04-08 11
+384 val_384 2008-04-08 11
+256 val_256 2008-04-08 11
+26 val_26 2008-04-08 11
+134 val_134 2008-04-08 11
+67 val_67 2008-04-08 11
+384 val_384 2008-04-08 11
+379 val_379 2008-04-08 11
+18 val_18 2008-04-08 11
+462 val_462 2008-04-08 11
+492 val_492 2008-04-08 11
+100 val_100 2008-04-08 11
+298 val_298 2008-04-08 11
+9 val_9 2008-04-08 11
+341 val_341 2008-04-08 11
+498 val_498 2008-04-08 11
+146 val_146 2008-04-08 11
+458 val_458 2008-04-08 11
+362 val_362 2008-04-08 11
+186 val_186 2008-04-08 11
+285 val_285 2008-04-08 11
+348 val_348 2008-04-08 11
+167 val_167 2008-04-08 11
+18 val_18 2008-04-08 11
+273 val_273 2008-04-08 11
+183 val_183 2008-04-08 11
+281 val_281 2008-04-08 11
+344 val_344 2008-04-08 11
+97 val_97 2008-04-08 11
+469 val_469 2008-04-08 11
+315 val_315 2008-04-08 11
+84 val_84 2008-04-08 11
+28 val_28 2008-04-08 11
+37 val_37 2008-04-08 11
+448 val_448 2008-04-08 11
+152 val_152 2008-04-08 11
+348 val_348 2008-04-08 11
+307 val_307 2008-04-08 11
+194 val_194 2008-04-08 11
+414 val_414 2008-04-08 11
+477 val_477 2008-04-08 11
+222 val_222 2008-04-08 11
+126 val_126 2008-04-08 11
+90 val_90 2008-04-08 11
+169 val_169 2008-04-08 11
+403 val_403 2008-04-08 11
+400 val_400 2008-04-08 11
+200 val_200 2008-04-08 11
+97 val_97 2008-04-08 11
+