http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/load_dyn_part3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/load_dyn_part3.q.out b/ql/src/test/results/clientpositive/tez/load_dyn_part3.q.out deleted file mode 100644 index c238ea2..0000000 --- a/ql/src/test/results/clientpositive/tez/load_dyn_part3.q.out +++ /dev/null @@ -1,2137 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS - -show partitions srcpart -PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@srcpart -POSTHOOK: query: -- SORT_QUERY_RESULTS - -show partitions srcpart -POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@srcpart -ds=2008-04-08/hr=11 -ds=2008-04-08/hr=12 -ds=2008-04-09/hr=11 -ds=2008-04-09/hr=12 -PREHOOK: query: create table if not exists nzhang_part3 like srcpart -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@nzhang_part3 -POSTHOOK: query: create table if not exists nzhang_part3 like srcpart -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@nzhang_part3 -PREHOOK: query: describe extended nzhang_part3 -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@nzhang_part3 -POSTHOOK: query: describe extended nzhang_part3 -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@nzhang_part3 -key string default -value string default -ds string -hr string - -# Partition Information -# col_name data_type comment - -ds string -hr string - -#### A masked pattern was here #### -PREHOOK: query: explain -insert overwrite table nzhang_part3 partition (ds, hr) select key, value, ds, hr from srcpart where ds is not null and hr is not null -PREHOOK: type: QUERY -POSTHOOK: query: explain -insert overwrite table nzhang_part3 partition (ds, hr) select key, value, ds, hr from srcpart where ds is not null and hr is not null -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - Stage-3 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: srcpart - Statistics: Num rows: 2000 Data size: 1092000 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: key (type: string), value (type: string), ds (type: string), hr (type: string) - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 2000 Data size: 1092000 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 2000 Data size: 1092000 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.nzhang_part3 - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - partition: - ds - hr - replace: true - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.nzhang_part3 - - Stage: Stage-3 - Stats-Aggr Operator - -PREHOOK: query: insert overwrite table nzhang_part3 partition (ds, hr) select key, value, ds, hr from srcpart where ds is not null and hr is not null -PREHOOK: type: QUERY -PREHOOK: Input: default@srcpart -PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 -PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 -PREHOOK: Output: default@nzhang_part3 -POSTHOOK: query: insert overwrite table nzhang_part3 partition (ds, hr) select key, value, ds, hr from srcpart where ds is not null and hr is not null -POSTHOOK: type: QUERY -POSTHOOK: Input: default@srcpart -POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 -POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 -POSTHOOK: Output: default@nzhang_part3@ds=2008-04-08/hr=11 -POSTHOOK: Output: default@nzhang_part3@ds=2008-04-08/hr=12 -POSTHOOK: Output: default@nzhang_part3@ds=2008-04-09/hr=11 -POSTHOOK: Output: default@nzhang_part3@ds=2008-04-09/hr=12 -POSTHOOK: Lineage: nzhang_part3 PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part3 PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part3 PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part3 PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part3 PARTITION(ds=2008-04-09,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part3 PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part3 PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part3 PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: select * from nzhang_part3 where ds is not null and hr is not null -PREHOOK: type: QUERY -PREHOOK: Input: default@nzhang_part3 -PREHOOK: Input: default@nzhang_part3@ds=2008-04-08/hr=11 -PREHOOK: Input: default@nzhang_part3@ds=2008-04-08/hr=12 -PREHOOK: Input: default@nzhang_part3@ds=2008-04-09/hr=11 -PREHOOK: Input: default@nzhang_part3@ds=2008-04-09/hr=12 -#### A masked pattern was here #### -POSTHOOK: query: select * from nzhang_part3 where ds is not null and hr is not null -POSTHOOK: type: QUERY -POSTHOOK: Input: default@nzhang_part3 -POSTHOOK: Input: default@nzhang_part3@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@nzhang_part3@ds=2008-04-08/hr=12 -POSTHOOK: Input: default@nzhang_part3@ds=2008-04-09/hr=11 -POSTHOOK: Input: default@nzhang_part3@ds=2008-04-09/hr=12 -#### A masked pattern was here #### -0 val_0 2008-04-08 11 -0 val_0 2008-04-08 11 -0 val_0 2008-04-08 11 -0 val_0 2008-04-08 12 -0 val_0 2008-04-08 12 -0 val_0 2008-04-08 12 -0 val_0 2008-04-09 11 -0 val_0 2008-04-09 11 -0 val_0 2008-04-09 11 -0 val_0 2008-04-09 12 -0 val_0 2008-04-09 12 -0 val_0 2008-04-09 12 -10 val_10 2008-04-08 11 -10 val_10 2008-04-08 12 -10 val_10 2008-04-09 11 -10 val_10 2008-04-09 12 -100 val_100 2008-04-08 11 -100 val_100 2008-04-08 11 -100 val_100 2008-04-08 12 -100 val_100 2008-04-08 12 -100 val_100 2008-04-09 11 -100 val_100 2008-04-09 11 -100 val_100 2008-04-09 12 -100 val_100 2008-04-09 12 -103 val_103 2008-04-08 11 -103 val_103 2008-04-08 11 -103 val_103 2008-04-08 12 -103 val_103 2008-04-08 12 -103 val_103 2008-04-09 11 -103 val_103 2008-04-09 11 -103 val_103 2008-04-09 12 -103 val_103 2008-04-09 12 -104 val_104 2008-04-08 11 -104 val_104 2008-04-08 11 -104 val_104 2008-04-08 12 -104 val_104 2008-04-08 12 -104 val_104 2008-04-09 11 -104 val_104 2008-04-09 11 -104 val_104 2008-04-09 12 -104 val_104 2008-04-09 12 -105 val_105 2008-04-08 11 -105 val_105 2008-04-08 12 -105 val_105 2008-04-09 11 -105 val_105 2008-04-09 12 -11 val_11 2008-04-08 11 -11 val_11 2008-04-08 12 -11 val_11 2008-04-09 11 -11 val_11 2008-04-09 12 -111 val_111 2008-04-08 11 -111 val_111 2008-04-08 12 -111 val_111 2008-04-09 11 -111 val_111 2008-04-09 12 -113 val_113 2008-04-08 11 -113 val_113 2008-04-08 11 -113 val_113 2008-04-08 12 -113 val_113 2008-04-08 12 -113 val_113 2008-04-09 11 -113 val_113 2008-04-09 11 -113 val_113 2008-04-09 12 -113 val_113 2008-04-09 12 -114 val_114 2008-04-08 11 -114 val_114 2008-04-08 12 -114 val_114 2008-04-09 11 -114 val_114 2008-04-09 12 -116 val_116 2008-04-08 11 -116 val_116 2008-04-08 12 -116 val_116 2008-04-09 11 -116 val_116 2008-04-09 12 -118 val_118 2008-04-08 11 -118 val_118 2008-04-08 11 -118 val_118 2008-04-08 12 -118 val_118 2008-04-08 12 -118 val_118 2008-04-09 11 -118 val_118 2008-04-09 11 -118 val_118 2008-04-09 12 -118 val_118 2008-04-09 12 -119 val_119 2008-04-08 11 -119 val_119 2008-04-08 11 -119 val_119 2008-04-08 11 -119 val_119 2008-04-08 12 -119 val_119 2008-04-08 12 -119 val_119 2008-04-08 12 -119 val_119 2008-04-09 11 -119 val_119 2008-04-09 11 -119 val_119 2008-04-09 11 -119 val_119 2008-04-09 12 -119 val_119 2008-04-09 12 -119 val_119 2008-04-09 12 -12 val_12 2008-04-08 11 -12 val_12 2008-04-08 11 -12 val_12 2008-04-08 12 -12 val_12 2008-04-08 12 -12 val_12 2008-04-09 11 -12 val_12 2008-04-09 11 -12 val_12 2008-04-09 12 -12 val_12 2008-04-09 12 -120 val_120 2008-04-08 11 -120 val_120 2008-04-08 11 -120 val_120 2008-04-08 12 -120 val_120 2008-04-08 12 -120 val_120 2008-04-09 11 -120 val_120 2008-04-09 11 -120 val_120 2008-04-09 12 -120 val_120 2008-04-09 12 -125 val_125 2008-04-08 11 -125 val_125 2008-04-08 11 -125 val_125 2008-04-08 12 -125 val_125 2008-04-08 12 -125 val_125 2008-04-09 11 -125 val_125 2008-04-09 11 -125 val_125 2008-04-09 12 -125 val_125 2008-04-09 12 -126 val_126 2008-04-08 11 -126 val_126 2008-04-08 12 -126 val_126 2008-04-09 11 -126 val_126 2008-04-09 12 -128 val_128 2008-04-08 11 -128 val_128 2008-04-08 11 -128 val_128 2008-04-08 11 -128 val_128 2008-04-08 12 -128 val_128 2008-04-08 12 -128 val_128 2008-04-08 12 -128 val_128 2008-04-09 11 -128 val_128 2008-04-09 11 -128 val_128 2008-04-09 11 -128 val_128 2008-04-09 12 -128 val_128 2008-04-09 12 -128 val_128 2008-04-09 12 -129 val_129 2008-04-08 11 -129 val_129 2008-04-08 11 -129 val_129 2008-04-08 12 -129 val_129 2008-04-08 12 -129 val_129 2008-04-09 11 -129 val_129 2008-04-09 11 -129 val_129 2008-04-09 12 -129 val_129 2008-04-09 12 -131 val_131 2008-04-08 11 -131 val_131 2008-04-08 12 -131 val_131 2008-04-09 11 -131 val_131 2008-04-09 12 -133 val_133 2008-04-08 11 -133 val_133 2008-04-08 12 -133 val_133 2008-04-09 11 -133 val_133 2008-04-09 12 -134 val_134 2008-04-08 11 -134 val_134 2008-04-08 11 -134 val_134 2008-04-08 12 -134 val_134 2008-04-08 12 -134 val_134 2008-04-09 11 -134 val_134 2008-04-09 11 -134 val_134 2008-04-09 12 -134 val_134 2008-04-09 12 -136 val_136 2008-04-08 11 -136 val_136 2008-04-08 12 -136 val_136 2008-04-09 11 -136 val_136 2008-04-09 12 -137 val_137 2008-04-08 11 -137 val_137 2008-04-08 11 -137 val_137 2008-04-08 12 -137 val_137 2008-04-08 12 -137 val_137 2008-04-09 11 -137 val_137 2008-04-09 11 -137 val_137 2008-04-09 12 -137 val_137 2008-04-09 12 -138 val_138 2008-04-08 11 -138 val_138 2008-04-08 11 -138 val_138 2008-04-08 11 -138 val_138 2008-04-08 11 -138 val_138 2008-04-08 12 -138 val_138 2008-04-08 12 -138 val_138 2008-04-08 12 -138 val_138 2008-04-08 12 -138 val_138 2008-04-09 11 -138 val_138 2008-04-09 11 -138 val_138 2008-04-09 11 -138 val_138 2008-04-09 11 -138 val_138 2008-04-09 12 -138 val_138 2008-04-09 12 -138 val_138 2008-04-09 12 -138 val_138 2008-04-09 12 -143 val_143 2008-04-08 11 -143 val_143 2008-04-08 12 -143 val_143 2008-04-09 11 -143 val_143 2008-04-09 12 -145 val_145 2008-04-08 11 -145 val_145 2008-04-08 12 -145 val_145 2008-04-09 11 -145 val_145 2008-04-09 12 -146 val_146 2008-04-08 11 -146 val_146 2008-04-08 11 -146 val_146 2008-04-08 12 -146 val_146 2008-04-08 12 -146 val_146 2008-04-09 11 -146 val_146 2008-04-09 11 -146 val_146 2008-04-09 12 -146 val_146 2008-04-09 12 -149 val_149 2008-04-08 11 -149 val_149 2008-04-08 11 -149 val_149 2008-04-08 12 -149 val_149 2008-04-08 12 -149 val_149 2008-04-09 11 -149 val_149 2008-04-09 11 -149 val_149 2008-04-09 12 -149 val_149 2008-04-09 12 -15 val_15 2008-04-08 11 -15 val_15 2008-04-08 11 -15 val_15 2008-04-08 12 -15 val_15 2008-04-08 12 -15 val_15 2008-04-09 11 -15 val_15 2008-04-09 11 -15 val_15 2008-04-09 12 -15 val_15 2008-04-09 12 -150 val_150 2008-04-08 11 -150 val_150 2008-04-08 12 -150 val_150 2008-04-09 11 -150 val_150 2008-04-09 12 -152 val_152 2008-04-08 11 -152 val_152 2008-04-08 11 -152 val_152 2008-04-08 12 -152 val_152 2008-04-08 12 -152 val_152 2008-04-09 11 -152 val_152 2008-04-09 11 -152 val_152 2008-04-09 12 -152 val_152 2008-04-09 12 -153 val_153 2008-04-08 11 -153 val_153 2008-04-08 12 -153 val_153 2008-04-09 11 -153 val_153 2008-04-09 12 -155 val_155 2008-04-08 11 -155 val_155 2008-04-08 12 -155 val_155 2008-04-09 11 -155 val_155 2008-04-09 12 -156 val_156 2008-04-08 11 -156 val_156 2008-04-08 12 -156 val_156 2008-04-09 11 -156 val_156 2008-04-09 12 -157 val_157 2008-04-08 11 -157 val_157 2008-04-08 12 -157 val_157 2008-04-09 11 -157 val_157 2008-04-09 12 -158 val_158 2008-04-08 11 -158 val_158 2008-04-08 12 -158 val_158 2008-04-09 11 -158 val_158 2008-04-09 12 -160 val_160 2008-04-08 11 -160 val_160 2008-04-08 12 -160 val_160 2008-04-09 11 -160 val_160 2008-04-09 12 -162 val_162 2008-04-08 11 -162 val_162 2008-04-08 12 -162 val_162 2008-04-09 11 -162 val_162 2008-04-09 12 -163 val_163 2008-04-08 11 -163 val_163 2008-04-08 12 -163 val_163 2008-04-09 11 -163 val_163 2008-04-09 12 -164 val_164 2008-04-08 11 -164 val_164 2008-04-08 11 -164 val_164 2008-04-08 12 -164 val_164 2008-04-08 12 -164 val_164 2008-04-09 11 -164 val_164 2008-04-09 11 -164 val_164 2008-04-09 12 -164 val_164 2008-04-09 12 -165 val_165 2008-04-08 11 -165 val_165 2008-04-08 11 -165 val_165 2008-04-08 12 -165 val_165 2008-04-08 12 -165 val_165 2008-04-09 11 -165 val_165 2008-04-09 11 -165 val_165 2008-04-09 12 -165 val_165 2008-04-09 12 -166 val_166 2008-04-08 11 -166 val_166 2008-04-08 12 -166 val_166 2008-04-09 11 -166 val_166 2008-04-09 12 -167 val_167 2008-04-08 11 -167 val_167 2008-04-08 11 -167 val_167 2008-04-08 11 -167 val_167 2008-04-08 12 -167 val_167 2008-04-08 12 -167 val_167 2008-04-08 12 -167 val_167 2008-04-09 11 -167 val_167 2008-04-09 11 -167 val_167 2008-04-09 11 -167 val_167 2008-04-09 12 -167 val_167 2008-04-09 12 -167 val_167 2008-04-09 12 -168 val_168 2008-04-08 11 -168 val_168 2008-04-08 12 -168 val_168 2008-04-09 11 -168 val_168 2008-04-09 12 -169 val_169 2008-04-08 11 -169 val_169 2008-04-08 11 -169 val_169 2008-04-08 11 -169 val_169 2008-04-08 11 -169 val_169 2008-04-08 12 -169 val_169 2008-04-08 12 -169 val_169 2008-04-08 12 -169 val_169 2008-04-08 12 -169 val_169 2008-04-09 11 -169 val_169 2008-04-09 11 -169 val_169 2008-04-09 11 -169 val_169 2008-04-09 11 -169 val_169 2008-04-09 12 -169 val_169 2008-04-09 12 -169 val_169 2008-04-09 12 -169 val_169 2008-04-09 12 -17 val_17 2008-04-08 11 -17 val_17 2008-04-08 12 -17 val_17 2008-04-09 11 -17 val_17 2008-04-09 12 -170 val_170 2008-04-08 11 -170 val_170 2008-04-08 12 -170 val_170 2008-04-09 11 -170 val_170 2008-04-09 12 -172 val_172 2008-04-08 11 -172 val_172 2008-04-08 11 -172 val_172 2008-04-08 12 -172 val_172 2008-04-08 12 -172 val_172 2008-04-09 11 -172 val_172 2008-04-09 11 -172 val_172 2008-04-09 12 -172 val_172 2008-04-09 12 -174 val_174 2008-04-08 11 -174 val_174 2008-04-08 11 -174 val_174 2008-04-08 12 -174 val_174 2008-04-08 12 -174 val_174 2008-04-09 11 -174 val_174 2008-04-09 11 -174 val_174 2008-04-09 12 -174 val_174 2008-04-09 12 -175 val_175 2008-04-08 11 -175 val_175 2008-04-08 11 -175 val_175 2008-04-08 12 -175 val_175 2008-04-08 12 -175 val_175 2008-04-09 11 -175 val_175 2008-04-09 11 -175 val_175 2008-04-09 12 -175 val_175 2008-04-09 12 -176 val_176 2008-04-08 11 -176 val_176 2008-04-08 11 -176 val_176 2008-04-08 12 -176 val_176 2008-04-08 12 -176 val_176 2008-04-09 11 -176 val_176 2008-04-09 11 -176 val_176 2008-04-09 12 -176 val_176 2008-04-09 12 -177 val_177 2008-04-08 11 -177 val_177 2008-04-08 12 -177 val_177 2008-04-09 11 -177 val_177 2008-04-09 12 -178 val_178 2008-04-08 11 -178 val_178 2008-04-08 12 -178 val_178 2008-04-09 11 -178 val_178 2008-04-09 12 -179 val_179 2008-04-08 11 -179 val_179 2008-04-08 11 -179 val_179 2008-04-08 12 -179 val_179 2008-04-08 12 -179 val_179 2008-04-09 11 -179 val_179 2008-04-09 11 -179 val_179 2008-04-09 12 -179 val_179 2008-04-09 12 -18 val_18 2008-04-08 11 -18 val_18 2008-04-08 11 -18 val_18 2008-04-08 12 -18 val_18 2008-04-08 12 -18 val_18 2008-04-09 11 -18 val_18 2008-04-09 11 -18 val_18 2008-04-09 12 -18 val_18 2008-04-09 12 -180 val_180 2008-04-08 11 -180 val_180 2008-04-08 12 -180 val_180 2008-04-09 11 -180 val_180 2008-04-09 12 -181 val_181 2008-04-08 11 -181 val_181 2008-04-08 12 -181 val_181 2008-04-09 11 -181 val_181 2008-04-09 12 -183 val_183 2008-04-08 11 -183 val_183 2008-04-08 12 -183 val_183 2008-04-09 11 -183 val_183 2008-04-09 12 -186 val_186 2008-04-08 11 -186 val_186 2008-04-08 12 -186 val_186 2008-04-09 11 -186 val_186 2008-04-09 12 -187 val_187 2008-04-08 11 -187 val_187 2008-04-08 11 -187 val_187 2008-04-08 11 -187 val_187 2008-04-08 12 -187 val_187 2008-04-08 12 -187 val_187 2008-04-08 12 -187 val_187 2008-04-09 11 -187 val_187 2008-04-09 11 -187 val_187 2008-04-09 11 -187 val_187 2008-04-09 12 -187 val_187 2008-04-09 12 -187 val_187 2008-04-09 12 -189 val_189 2008-04-08 11 -189 val_189 2008-04-08 12 -189 val_189 2008-04-09 11 -189 val_189 2008-04-09 12 -19 val_19 2008-04-08 11 -19 val_19 2008-04-08 12 -19 val_19 2008-04-09 11 -19 val_19 2008-04-09 12 -190 val_190 2008-04-08 11 -190 val_190 2008-04-08 12 -190 val_190 2008-04-09 11 -190 val_190 2008-04-09 12 -191 val_191 2008-04-08 11 -191 val_191 2008-04-08 11 -191 val_191 2008-04-08 12 -191 val_191 2008-04-08 12 -191 val_191 2008-04-09 11 -191 val_191 2008-04-09 11 -191 val_191 2008-04-09 12 -191 val_191 2008-04-09 12 -192 val_192 2008-04-08 11 -192 val_192 2008-04-08 12 -192 val_192 2008-04-09 11 -192 val_192 2008-04-09 12 -193 val_193 2008-04-08 11 -193 val_193 2008-04-08 11 -193 val_193 2008-04-08 11 -193 val_193 2008-04-08 12 -193 val_193 2008-04-08 12 -193 val_193 2008-04-08 12 -193 val_193 2008-04-09 11 -193 val_193 2008-04-09 11 -193 val_193 2008-04-09 11 -193 val_193 2008-04-09 12 -193 val_193 2008-04-09 12 -193 val_193 2008-04-09 12 -194 val_194 2008-04-08 11 -194 val_194 2008-04-08 12 -194 val_194 2008-04-09 11 -194 val_194 2008-04-09 12 -195 val_195 2008-04-08 11 -195 val_195 2008-04-08 11 -195 val_195 2008-04-08 12 -195 val_195 2008-04-08 12 -195 val_195 2008-04-09 11 -195 val_195 2008-04-09 11 -195 val_195 2008-04-09 12 -195 val_195 2008-04-09 12 -196 val_196 2008-04-08 11 -196 val_196 2008-04-08 12 -196 val_196 2008-04-09 11 -196 val_196 2008-04-09 12 -197 val_197 2008-04-08 11 -197 val_197 2008-04-08 11 -197 val_197 2008-04-08 12 -197 val_197 2008-04-08 12 -197 val_197 2008-04-09 11 -197 val_197 2008-04-09 11 -197 val_197 2008-04-09 12 -197 val_197 2008-04-09 12 -199 val_199 2008-04-08 11 -199 val_199 2008-04-08 11 -199 val_199 2008-04-08 11 -199 val_199 2008-04-08 12 -199 val_199 2008-04-08 12 -199 val_199 2008-04-08 12 -199 val_199 2008-04-09 11 -199 val_199 2008-04-09 11 -199 val_199 2008-04-09 11 -199 val_199 2008-04-09 12 -199 val_199 2008-04-09 12 -199 val_199 2008-04-09 12 -2 val_2 2008-04-08 11 -2 val_2 2008-04-08 12 -2 val_2 2008-04-09 11 -2 val_2 2008-04-09 12 -20 val_20 2008-04-08 11 -20 val_20 2008-04-08 12 -20 val_20 2008-04-09 11 -20 val_20 2008-04-09 12 -200 val_200 2008-04-08 11 -200 val_200 2008-04-08 11 -200 val_200 2008-04-08 12 -200 val_200 2008-04-08 12 -200 val_200 2008-04-09 11 -200 val_200 2008-04-09 11 -200 val_200 2008-04-09 12 -200 val_200 2008-04-09 12 -201 val_201 2008-04-08 11 -201 val_201 2008-04-08 12 -201 val_201 2008-04-09 11 -201 val_201 2008-04-09 12 -202 val_202 2008-04-08 11 -202 val_202 2008-04-08 12 -202 val_202 2008-04-09 11 -202 val_202 2008-04-09 12 -203 val_203 2008-04-08 11 -203 val_203 2008-04-08 11 -203 val_203 2008-04-08 12 -203 val_203 2008-04-08 12 -203 val_203 2008-04-09 11 -203 val_203 2008-04-09 11 -203 val_203 2008-04-09 12 -203 val_203 2008-04-09 12 -205 val_205 2008-04-08 11 -205 val_205 2008-04-08 11 -205 val_205 2008-04-08 12 -205 val_205 2008-04-08 12 -205 val_205 2008-04-09 11 -205 val_205 2008-04-09 11 -205 val_205 2008-04-09 12 -205 val_205 2008-04-09 12 -207 val_207 2008-04-08 11 -207 val_207 2008-04-08 11 -207 val_207 2008-04-08 12 -207 val_207 2008-04-08 12 -207 val_207 2008-04-09 11 -207 val_207 2008-04-09 11 -207 val_207 2008-04-09 12 -207 val_207 2008-04-09 12 -208 val_208 2008-04-08 11 -208 val_208 2008-04-08 11 -208 val_208 2008-04-08 11 -208 val_208 2008-04-08 12 -208 val_208 2008-04-08 12 -208 val_208 2008-04-08 12 -208 val_208 2008-04-09 11 -208 val_208 2008-04-09 11 -208 val_208 2008-04-09 11 -208 val_208 2008-04-09 12 -208 val_208 2008-04-09 12 -208 val_208 2008-04-09 12 -209 val_209 2008-04-08 11 -209 val_209 2008-04-08 11 -209 val_209 2008-04-08 12 -209 val_209 2008-04-08 12 -209 val_209 2008-04-09 11 -209 val_209 2008-04-09 11 -209 val_209 2008-04-09 12 -209 val_209 2008-04-09 12 -213 val_213 2008-04-08 11 -213 val_213 2008-04-08 11 -213 val_213 2008-04-08 12 -213 val_213 2008-04-08 12 -213 val_213 2008-04-09 11 -213 val_213 2008-04-09 11 -213 val_213 2008-04-09 12 -213 val_213 2008-04-09 12 -214 val_214 2008-04-08 11 -214 val_214 2008-04-08 12 -214 val_214 2008-04-09 11 -214 val_214 2008-04-09 12 -216 val_216 2008-04-08 11 -216 val_216 2008-04-08 11 -216 val_216 2008-04-08 12 -216 val_216 2008-04-08 12 -216 val_216 2008-04-09 11 -216 val_216 2008-04-09 11 -216 val_216 2008-04-09 12 -216 val_216 2008-04-09 12 -217 val_217 2008-04-08 11 -217 val_217 2008-04-08 11 -217 val_217 2008-04-08 12 -217 val_217 2008-04-08 12 -217 val_217 2008-04-09 11 -217 val_217 2008-04-09 11 -217 val_217 2008-04-09 12 -217 val_217 2008-04-09 12 -218 val_218 2008-04-08 11 -218 val_218 2008-04-08 12 -218 val_218 2008-04-09 11 -218 val_218 2008-04-09 12 -219 val_219 2008-04-08 11 -219 val_219 2008-04-08 11 -219 val_219 2008-04-08 12 -219 val_219 2008-04-08 12 -219 val_219 2008-04-09 11 -219 val_219 2008-04-09 11 -219 val_219 2008-04-09 12 -219 val_219 2008-04-09 12 -221 val_221 2008-04-08 11 -221 val_221 2008-04-08 11 -221 val_221 2008-04-08 12 -221 val_221 2008-04-08 12 -221 val_221 2008-04-09 11 -221 val_221 2008-04-09 11 -221 val_221 2008-04-09 12 -221 val_221 2008-04-09 12 -222 val_222 2008-04-08 11 -222 val_222 2008-04-08 12 -222 val_222 2008-04-09 11 -222 val_222 2008-04-09 12 -223 val_223 2008-04-08 11 -223 val_223 2008-04-08 11 -223 val_223 2008-04-08 12 -223 val_223 2008-04-08 12 -223 val_223 2008-04-09 11 -223 val_223 2008-04-09 11 -223 val_223 2008-04-09 12 -223 val_223 2008-04-09 12 -224 val_224 2008-04-08 11 -224 val_224 2008-04-08 11 -224 val_224 2008-04-08 12 -224 val_224 2008-04-08 12 -224 val_224 2008-04-09 11 -224 val_224 2008-04-09 11 -224 val_224 2008-04-09 12 -224 val_224 2008-04-09 12 -226 val_226 2008-04-08 11 -226 val_226 2008-04-08 12 -226 val_226 2008-04-09 11 -226 val_226 2008-04-09 12 -228 val_228 2008-04-08 11 -228 val_228 2008-04-08 12 -228 val_228 2008-04-09 11 -228 val_228 2008-04-09 12 -229 val_229 2008-04-08 11 -229 val_229 2008-04-08 11 -229 val_229 2008-04-08 12 -229 val_229 2008-04-08 12 -229 val_229 2008-04-09 11 -229 val_229 2008-04-09 11 -229 val_229 2008-04-09 12 -229 val_229 2008-04-09 12 -230 val_230 2008-04-08 11 -230 val_230 2008-04-08 11 -230 val_230 2008-04-08 11 -230 val_230 2008-04-08 11 -230 val_230 2008-04-08 11 -230 val_230 2008-04-08 12 -230 val_230 2008-04-08 12 -230 val_230 2008-04-08 12 -230 val_230 2008-04-08 12 -230 val_230 2008-04-08 12 -230 val_230 2008-04-09 11 -230 val_230 2008-04-09 11 -230 val_230 2008-04-09 11 -230 val_230 2008-04-09 11 -230 val_230 2008-04-09 11 -230 val_230 2008-04-09 12 -230 val_230 2008-04-09 12 -230 val_230 2008-04-09 12 -230 val_230 2008-04-09 12 -230 val_230 2008-04-09 12 -233 val_233 2008-04-08 11 -233 val_233 2008-04-08 11 -233 val_233 2008-04-08 12 -233 val_233 2008-04-08 12 -233 val_233 2008-04-09 11 -233 val_233 2008-04-09 11 -233 val_233 2008-04-09 12 -233 val_233 2008-04-09 12 -235 val_235 2008-04-08 11 -235 val_235 2008-04-08 12 -235 val_235 2008-04-09 11 -235 val_235 2008-04-09 12 -237 val_237 2008-04-08 11 -237 val_237 2008-04-08 11 -237 val_237 2008-04-08 12 -237 val_237 2008-04-08 12 -237 val_237 2008-04-09 11 -237 val_237 2008-04-09 11 -237 val_237 2008-04-09 12 -237 val_237 2008-04-09 12 -238 val_238 2008-04-08 11 -238 val_238 2008-04-08 11 -238 val_238 2008-04-08 12 -238 val_238 2008-04-08 12 -238 val_238 2008-04-09 11 -238 val_238 2008-04-09 11 -238 val_238 2008-04-09 12 -238 val_238 2008-04-09 12 -239 val_239 2008-04-08 11 -239 val_239 2008-04-08 11 -239 val_239 2008-04-08 12 -239 val_239 2008-04-08 12 -239 val_239 2008-04-09 11 -239 val_239 2008-04-09 11 -239 val_239 2008-04-09 12 -239 val_239 2008-04-09 12 -24 val_24 2008-04-08 11 -24 val_24 2008-04-08 11 -24 val_24 2008-04-08 12 -24 val_24 2008-04-08 12 -24 val_24 2008-04-09 11 -24 val_24 2008-04-09 11 -24 val_24 2008-04-09 12 -24 val_24 2008-04-09 12 -241 val_241 2008-04-08 11 -241 val_241 2008-04-08 12 -241 val_241 2008-04-09 11 -241 val_241 2008-04-09 12 -242 val_242 2008-04-08 11 -242 val_242 2008-04-08 11 -242 val_242 2008-04-08 12 -242 val_242 2008-04-08 12 -242 val_242 2008-04-09 11 -242 val_242 2008-04-09 11 -242 val_242 2008-04-09 12 -242 val_242 2008-04-09 12 -244 val_244 2008-04-08 11 -244 val_244 2008-04-08 12 -244 val_244 2008-04-09 11 -244 val_244 2008-04-09 12 -247 val_247 2008-04-08 11 -247 val_247 2008-04-08 12 -247 val_247 2008-04-09 11 -247 val_247 2008-04-09 12 -248 val_248 2008-04-08 11 -248 val_248 2008-04-08 12 -248 val_248 2008-04-09 11 -248 val_248 2008-04-09 12 -249 val_249 2008-04-08 11 -249 val_249 2008-04-08 12 -249 val_249 2008-04-09 11 -249 val_249 2008-04-09 12 -252 val_252 2008-04-08 11 -252 val_252 2008-04-08 12 -252 val_252 2008-04-09 11 -252 val_252 2008-04-09 12 -255 val_255 2008-04-08 11 -255 val_255 2008-04-08 11 -255 val_255 2008-04-08 12 -255 val_255 2008-04-08 12 -255 val_255 2008-04-09 11 -255 val_255 2008-04-09 11 -255 val_255 2008-04-09 12 -255 val_255 2008-04-09 12 -256 val_256 2008-04-08 11 -256 val_256 2008-04-08 11 -256 val_256 2008-04-08 12 -256 val_256 2008-04-08 12 -256 val_256 2008-04-09 11 -256 val_256 2008-04-09 11 -256 val_256 2008-04-09 12 -256 val_256 2008-04-09 12 -257 val_257 2008-04-08 11 -257 val_257 2008-04-08 12 -257 val_257 2008-04-09 11 -257 val_257 2008-04-09 12 -258 val_258 2008-04-08 11 -258 val_258 2008-04-08 12 -258 val_258 2008-04-09 11 -258 val_258 2008-04-09 12 -26 val_26 2008-04-08 11 -26 val_26 2008-04-08 11 -26 val_26 2008-04-08 12 -26 val_26 2008-04-08 12 -26 val_26 2008-04-09 11 -26 val_26 2008-04-09 11 -26 val_26 2008-04-09 12 -26 val_26 2008-04-09 12 -260 val_260 2008-04-08 11 -260 val_260 2008-04-08 12 -260 val_260 2008-04-09 11 -260 val_260 2008-04-09 12 -262 val_262 2008-04-08 11 -262 val_262 2008-04-08 12 -262 val_262 2008-04-09 11 -262 val_262 2008-04-09 12 -263 val_263 2008-04-08 11 -263 val_263 2008-04-08 12 -263 val_263 2008-04-09 11 -263 val_263 2008-04-09 12 -265 val_265 2008-04-08 11 -265 val_265 2008-04-08 11 -265 val_265 2008-04-08 12 -265 val_265 2008-04-08 12 -265 val_265 2008-04-09 11 -265 val_265 2008-04-09 11 -265 val_265 2008-04-09 12 -265 val_265 2008-04-09 12 -266 val_266 2008-04-08 11 -266 val_266 2008-04-08 12 -266 val_266 2008-04-09 11 -266 val_266 2008-04-09 12 -27 val_27 2008-04-08 11 -27 val_27 2008-04-08 12 -27 val_27 2008-04-09 11 -27 val_27 2008-04-09 12 -272 val_272 2008-04-08 11 -272 val_272 2008-04-08 11 -272 val_272 2008-04-08 12 -272 val_272 2008-04-08 12 -272 val_272 2008-04-09 11 -272 val_272 2008-04-09 11 -272 val_272 2008-04-09 12 -272 val_272 2008-04-09 12 -273 val_273 2008-04-08 11 -273 val_273 2008-04-08 11 -273 val_273 2008-04-08 11 -273 val_273 2008-04-08 12 -273 val_273 2008-04-08 12 -273 val_273 2008-04-08 12 -273 val_273 2008-04-09 11 -273 val_273 2008-04-09 11 -273 val_273 2008-04-09 11 -273 val_273 2008-04-09 12 -273 val_273 2008-04-09 12 -273 val_273 2008-04-09 12 -274 val_274 2008-04-08 11 -274 val_274 2008-04-08 12 -274 val_274 2008-04-09 11 -274 val_274 2008-04-09 12 -275 val_275 2008-04-08 11 -275 val_275 2008-04-08 12 -275 val_275 2008-04-09 11 -275 val_275 2008-04-09 12 -277 val_277 2008-04-08 11 -277 val_277 2008-04-08 11 -277 val_277 2008-04-08 11 -277 val_277 2008-04-08 11 -277 val_277 2008-04-08 12 -277 val_277 2008-04-08 12 -277 val_277 2008-04-08 12 -277 val_277 2008-04-08 12 -277 val_277 2008-04-09 11 -277 val_277 2008-04-09 11 -277 val_277 2008-04-09 11 -277 val_277 2008-04-09 11 -277 val_277 2008-04-09 12 -277 val_277 2008-04-09 12 -277 val_277 2008-04-09 12 -277 val_277 2008-04-09 12 -278 val_278 2008-04-08 11 -278 val_278 2008-04-08 11 -278 val_278 2008-04-08 12 -278 val_278 2008-04-08 12 -278 val_278 2008-04-09 11 -278 val_278 2008-04-09 11 -278 val_278 2008-04-09 12 -278 val_278 2008-04-09 12 -28 val_28 2008-04-08 11 -28 val_28 2008-04-08 12 -28 val_28 2008-04-09 11 -28 val_28 2008-04-09 12 -280 val_280 2008-04-08 11 -280 val_280 2008-04-08 11 -280 val_280 2008-04-08 12 -280 val_280 2008-04-08 12 -280 val_280 2008-04-09 11 -280 val_280 2008-04-09 11 -280 val_280 2008-04-09 12 -280 val_280 2008-04-09 12 -281 val_281 2008-04-08 11 -281 val_281 2008-04-08 11 -281 val_281 2008-04-08 12 -281 val_281 2008-04-08 12 -281 val_281 2008-04-09 11 -281 val_281 2008-04-09 11 -281 val_281 2008-04-09 12 -281 val_281 2008-04-09 12 -282 val_282 2008-04-08 11 -282 val_282 2008-04-08 11 -282 val_282 2008-04-08 12 -282 val_282 2008-04-08 12 -282 val_282 2008-04-09 11 -282 val_282 2008-04-09 11 -282 val_282 2008-04-09 12 -282 val_282 2008-04-09 12 -283 val_283 2008-04-08 11 -283 val_283 2008-04-08 12 -283 val_283 2008-04-09 11 -283 val_283 2008-04-09 12 -284 val_284 2008-04-08 11 -284 val_284 2008-04-08 12 -284 val_284 2008-04-09 11 -284 val_284 2008-04-09 12 -285 val_285 2008-04-08 11 -285 val_285 2008-04-08 12 -285 val_285 2008-04-09 11 -285 val_285 2008-04-09 12 -286 val_286 2008-04-08 11 -286 val_286 2008-04-08 12 -286 val_286 2008-04-09 11 -286 val_286 2008-04-09 12 -287 val_287 2008-04-08 11 -287 val_287 2008-04-08 12 -287 val_287 2008-04-09 11 -287 val_287 2008-04-09 12 -288 val_288 2008-04-08 11 -288 val_288 2008-04-08 11 -288 val_288 2008-04-08 12 -288 val_288 2008-04-08 12 -288 val_288 2008-04-09 11 -288 val_288 2008-04-09 11 -288 val_288 2008-04-09 12 -288 val_288 2008-04-09 12 -289 val_289 2008-04-08 11 -289 val_289 2008-04-08 12 -289 val_289 2008-04-09 11 -289 val_289 2008-04-09 12 -291 val_291 2008-04-08 11 -291 val_291 2008-04-08 12 -291 val_291 2008-04-09 11 -291 val_291 2008-04-09 12 -292 val_292 2008-04-08 11 -292 val_292 2008-04-08 12 -292 val_292 2008-04-09 11 -292 val_292 2008-04-09 12 -296 val_296 2008-04-08 11 -296 val_296 2008-04-08 12 -296 val_296 2008-04-09 11 -296 val_296 2008-04-09 12 -298 val_298 2008-04-08 11 -298 val_298 2008-04-08 11 -298 val_298 2008-04-08 11 -298 val_298 2008-04-08 12 -298 val_298 2008-04-08 12 -298 val_298 2008-04-08 12 -298 val_298 2008-04-09 11 -298 val_298 2008-04-09 11 -298 val_298 2008-04-09 11 -298 val_298 2008-04-09 12 -298 val_298 2008-04-09 12 -298 val_298 2008-04-09 12 -30 val_30 2008-04-08 11 -30 val_30 2008-04-08 12 -30 val_30 2008-04-09 11 -30 val_30 2008-04-09 12 -302 val_302 2008-04-08 11 -302 val_302 2008-04-08 12 -302 val_302 2008-04-09 11 -302 val_302 2008-04-09 12 -305 val_305 2008-04-08 11 -305 val_305 2008-04-08 12 -305 val_305 2008-04-09 11 -305 val_305 2008-04-09 12 -306 val_306 2008-04-08 11 -306 val_306 2008-04-08 12 -306 val_306 2008-04-09 11 -306 val_306 2008-04-09 12 -307 val_307 2008-04-08 11 -307 val_307 2008-04-08 11 -307 val_307 2008-04-08 12 -307 val_307 2008-04-08 12 -307 val_307 2008-04-09 11 -307 val_307 2008-04-09 11 -307 val_307 2008-04-09 12 -307 val_307 2008-04-09 12 -308 val_308 2008-04-08 11 -308 val_308 2008-04-08 12 -308 val_308 2008-04-09 11 -308 val_308 2008-04-09 12 -309 val_309 2008-04-08 11 -309 val_309 2008-04-08 11 -309 val_309 2008-04-08 12 -309 val_309 2008-04-08 12 -309 val_309 2008-04-09 11 -309 val_309 2008-04-09 11 -309 val_309 2008-04-09 12 -309 val_309 2008-04-09 12 -310 val_310 2008-04-08 11 -310 val_310 2008-04-08 12 -310 val_310 2008-04-09 11 -310 val_310 2008-04-09 12 -311 val_311 2008-04-08 11 -311 val_311 2008-04-08 11 -311 val_311 2008-04-08 11 -311 val_311 2008-04-08 12 -311 val_311 2008-04-08 12 -311 val_311 2008-04-08 12 -311 val_311 2008-04-09 11 -311 val_311 2008-04-09 11 -311 val_311 2008-04-09 11 -311 val_311 2008-04-09 12 -311 val_311 2008-04-09 12 -311 val_311 2008-04-09 12 -315 val_315 2008-04-08 11 -315 val_315 2008-04-08 12 -315 val_315 2008-04-09 11 -315 val_315 2008-04-09 12 -316 val_316 2008-04-08 11 -316 val_316 2008-04-08 11 -316 val_316 2008-04-08 11 -316 val_316 2008-04-08 12 -316 val_316 2008-04-08 12 -316 val_316 2008-04-08 12 -316 val_316 2008-04-09 11 -316 val_316 2008-04-09 11 -316 val_316 2008-04-09 11 -316 val_316 2008-04-09 12 -316 val_316 2008-04-09 12 -316 val_316 2008-04-09 12 -317 val_317 2008-04-08 11 -317 val_317 2008-04-08 11 -317 val_317 2008-04-08 12 -317 val_317 2008-04-08 12 -317 val_317 2008-04-09 11 -317 val_317 2008-04-09 11 -317 val_317 2008-04-09 12 -317 val_317 2008-04-09 12 -318 val_318 2008-04-08 11 -318 val_318 2008-04-08 11 -318 val_318 2008-04-08 11 -318 val_318 2008-04-08 12 -318 val_318 2008-04-08 12 -318 val_318 2008-04-08 12 -318 val_318 2008-04-09 11 -318 val_318 2008-04-09 11 -318 val_318 2008-04-09 11 -318 val_318 2008-04-09 12 -318 val_318 2008-04-09 12 -318 val_318 2008-04-09 12 -321 val_321 2008-04-08 11 -321 val_321 2008-04-08 11 -321 val_321 2008-04-08 12 -321 val_321 2008-04-08 12 -321 val_321 2008-04-09 11 -321 val_321 2008-04-09 11 -321 val_321 2008-04-09 12 -321 val_321 2008-04-09 12 -322 val_322 2008-04-08 11 -322 val_322 2008-04-08 11 -322 val_322 2008-04-08 12 -322 val_322 2008-04-08 12 -322 val_322 2008-04-09 11 -322 val_322 2008-04-09 11 -322 val_322 2008-04-09 12 -322 val_322 2008-04-09 12 -323 val_323 2008-04-08 11 -323 val_323 2008-04-08 12 -323 val_323 2008-04-09 11 -323 val_323 2008-04-09 12 -325 val_325 2008-04-08 11 -325 val_325 2008-04-08 11 -325 val_325 2008-04-08 12 -325 val_325 2008-04-08 12 -325 val_325 2008-04-09 11 -325 val_325 2008-04-09 11 -325 val_325 2008-04-09 12 -325 val_325 2008-04-09 12 -327 val_327 2008-04-08 11 -327 val_327 2008-04-08 11 -327 val_327 2008-04-08 11 -327 val_327 2008-04-08 12 -327 val_327 2008-04-08 12 -327 val_327 2008-04-08 12 -327 val_327 2008-04-09 11 -327 val_327 2008-04-09 11 -327 val_327 2008-04-09 11 -327 val_327 2008-04-09 12 -327 val_327 2008-04-09 12 -327 val_327 2008-04-09 12 -33 val_33 2008-04-08 11 -33 val_33 2008-04-08 12 -33 val_33 2008-04-09 11 -33 val_33 2008-04-09 12 -331 val_331 2008-04-08 11 -331 val_331 2008-04-08 11 -331 val_331 2008-04-08 12 -331 val_331 2008-04-08 12 -331 val_331 2008-04-09 11 -331 val_331 2008-04-09 11 -331 val_331 2008-04-09 12 -331 val_331 2008-04-09 12 -332 val_332 2008-04-08 11 -332 val_332 2008-04-08 12 -332 val_332 2008-04-09 11 -332 val_332 2008-04-09 12 -333 val_333 2008-04-08 11 -333 val_333 2008-04-08 11 -333 val_333 2008-04-08 12 -333 val_333 2008-04-08 12 -333 val_333 2008-04-09 11 -333 val_333 2008-04-09 11 -333 val_333 2008-04-09 12 -333 val_333 2008-04-09 12 -335 val_335 2008-04-08 11 -335 val_335 2008-04-08 12 -335 val_335 2008-04-09 11 -335 val_335 2008-04-09 12 -336 val_336 2008-04-08 11 -336 val_336 2008-04-08 12 -336 val_336 2008-04-09 11 -336 val_336 2008-04-09 12 -338 val_338 2008-04-08 11 -338 val_338 2008-04-08 12 -338 val_338 2008-04-09 11 -338 val_338 2008-04-09 12 -339 val_339 2008-04-08 11 -339 val_339 2008-04-08 12 -339 val_339 2008-04-09 11 -339 val_339 2008-04-09 12 -34 val_34 2008-04-08 11 -34 val_34 2008-04-08 12 -34 val_34 2008-04-09 11 -34 val_34 2008-04-09 12 -341 val_341 2008-04-08 11 -341 val_341 2008-04-08 12 -341 val_341 2008-04-09 11 -341 val_341 2008-04-09 12 -342 val_342 2008-04-08 11 -342 val_342 2008-04-08 11 -342 val_342 2008-04-08 12 -342 val_342 2008-04-08 12 -342 val_342 2008-04-09 11 -342 val_342 2008-04-09 11 -342 val_342 2008-04-09 12 -342 val_342 2008-04-09 12 -344 val_344 2008-04-08 11 -344 val_344 2008-04-08 11 -344 val_344 2008-04-08 12 -344 val_344 2008-04-08 12 -344 val_344 2008-04-09 11 -344 val_344 2008-04-09 11 -344 val_344 2008-04-09 12 -344 val_344 2008-04-09 12 -345 val_345 2008-04-08 11 -345 val_345 2008-04-08 12 -345 val_345 2008-04-09 11 -345 val_345 2008-04-09 12 -348 val_348 2008-04-08 11 -348 val_348 2008-04-08 11 -348 val_348 2008-04-08 11 -348 val_348 2008-04-08 11 -348 val_348 2008-04-08 11 -348 val_348 2008-04-08 12 -348 val_348 2008-04-08 12 -348 val_348 2008-04-08 12 -348 val_348 2008-04-08 12 -348 val_348 2008-04-08 12 -348 val_348 2008-04-09 11 -348 val_348 2008-04-09 11 -348 val_348 2008-04-09 11 -348 val_348 2008-04-09 11 -348 val_348 2008-04-09 11 -348 val_348 2008-04-09 12 -348 val_348 2008-04-09 12 -348 val_348 2008-04-09 12 -348 val_348 2008-04-09 12 -348 val_348 2008-04-09 12 -35 val_35 2008-04-08 11 -35 val_35 2008-04-08 11 -35 val_35 2008-04-08 11 -35 val_35 2008-04-08 12 -35 val_35 2008-04-08 12 -35 val_35 2008-04-08 12 -35 val_35 2008-04-09 11 -35 val_35 2008-04-09 11 -35 val_35 2008-04-09 11 -35 val_35 2008-04-09 12 -35 val_35 2008-04-09 12 -35 val_35 2008-04-09 12 -351 val_351 2008-04-08 11 -351 val_351 2008-04-08 12 -351 val_351 2008-04-09 11 -351 val_351 2008-04-09 12 -353 val_353 2008-04-08 11 -353 val_353 2008-04-08 11 -353 val_353 2008-04-08 12 -353 val_353 2008-04-08 12 -353 val_353 2008-04-09 11 -353 val_353 2008-04-09 11 -353 val_353 2008-04-09 12 -353 val_353 2008-04-09 12 -356 val_356 2008-04-08 11 -356 val_356 2008-04-08 12 -356 val_356 2008-04-09 11 -356 val_356 2008-04-09 12 -360 val_360 2008-04-08 11 -360 val_360 2008-04-08 12 -360 val_360 2008-04-09 11 -360 val_360 2008-04-09 12 -362 val_362 2008-04-08 11 -362 val_362 2008-04-08 12 -362 val_362 2008-04-09 11 -362 val_362 2008-04-09 12 -364 val_364 2008-04-08 11 -364 val_364 2008-04-08 12 -364 val_364 2008-04-09 11 -364 val_364 2008-04-09 12 -365 val_365 2008-04-08 11 -365 val_365 2008-04-08 12 -365 val_365 2008-04-09 11 -365 val_365 2008-04-09 12 -366 val_366 2008-04-08 11 -366 val_366 2008-04-08 12 -366 val_366 2008-04-09 11 -366 val_366 2008-04-09 12 -367 val_367 2008-04-08 11 -367 val_367 2008-04-08 11 -367 val_367 2008-04-08 12 -367 val_367 2008-04-08 12 -367 val_367 2008-04-09 11 -367 val_367 2008-04-09 11 -367 val_367 2008-04-09 12 -367 val_367 2008-04-09 12 -368 val_368 2008-04-08 11 -368 val_368 2008-04-08 12 -368 val_368 2008-04-09 11 -368 val_368 2008-04-09 12 -369 val_369 2008-04-08 11 -369 val_369 2008-04-08 11 -369 val_369 2008-04-08 11 -369 val_369 2008-04-08 12 -369 val_369 2008-04-08 12 -369 val_369 2008-04-08 12 -369 val_369 2008-04-09 11 -369 val_369 2008-04-09 11 -369 val_369 2008-04-09 11 -369 val_369 2008-04-09 12 -369 val_369 2008-04-09 12 -369 val_369 2008-04-09 12 -37 val_37 2008-04-08 11 -37 val_37 2008-04-08 11 -37 val_37 2008-04-08 12 -37 val_37 2008-04-08 12 -37 val_37 2008-04-09 11 -37 val_37 2008-04-09 11 -37 val_37 2008-04-09 12 -37 val_37 2008-04-09 12 -373 val_373 2008-04-08 11 -373 val_373 2008-04-08 12 -373 val_373 2008-04-09 11 -373 val_373 2008-04-09 12 -374 val_374 2008-04-08 11 -374 val_374 2008-04-08 12 -374 val_374 2008-04-09 11 -374 val_374 2008-04-09 12 -375 val_375 2008-04-08 11 -375 val_375 2008-04-08 12 -375 val_375 2008-04-09 11 -375 val_375 2008-04-09 12 -377 val_377 2008-04-08 11 -377 val_377 2008-04-08 12 -377 val_377 2008-04-09 11 -377 val_377 2008-04-09 12 -378 val_378 2008-04-08 11 -378 val_378 2008-04-08 12 -378 val_378 2008-04-09 11 -378 val_378 2008-04-09 12 -379 val_379 2008-04-08 11 -379 val_379 2008-04-08 12 -379 val_379 2008-04-09 11 -379 val_379 2008-04-09 12 -382 val_382 2008-04-08 11 -382 val_382 2008-04-08 11 -382 val_382 2008-04-08 12 -382 val_382 2008-04-08 12 -382 val_382 2008-04-09 11 -382 val_382 2008-04-09 11 -382 val_382 2008-04-09 12 -382 val_382 2008-04-09 12 -384 val_384 2008-04-08 11 -384 val_384 2008-04-08 11 -384 val_384 2008-04-08 11 -384 val_384 2008-04-08 12 -384 val_384 2008-04-08 12 -384 val_384 2008-04-08 12 -384 val_384 2008-04-09 11 -384 val_384 2008-04-09 11 -384 val_384 2008-04-09 11 -384 val_384 2008-04-09 12 -384 val_384 2008-04-09 12 -384 val_384 2008-04-09 12 -386 val_386 2008-04-08 11 -386 val_386 2008-04-08 12 -386 val_386 2008-04-09 11 -386 val_386 2008-04-09 12 -389 val_389 2008-04-08 11 -389 val_389 2008-04-08 12 -389 val_389 2008-04-09 11 -389 val_389 2008-04-09 12 -392 val_392 2008-04-08 11 -392 val_392 2008-04-08 12 -392 val_392 2008-04-09 11 -392 val_392 2008-04-09 12 -393 val_393 2008-04-08 11 -393 val_393 2008-04-08 12 -393 val_393 2008-04-09 11 -393 val_393 2008-04-09 12 -394 val_394 2008-04-08 11 -394 val_394 2008-04-08 12 -394 val_394 2008-04-09 11 -394 val_394 2008-04-09 12 -395 val_395 2008-04-08 11 -395 val_395 2008-04-08 11 -395 val_395 2008-04-08 12 -395 val_395 2008-04-08 12 -395 val_395 2008-04-09 11 -395 val_395 2008-04-09 11 -395 val_395 2008-04-09 12 -395 val_395 2008-04-09 12 -396 val_396 2008-04-08 11 -396 val_396 2008-04-08 11 -396 val_396 2008-04-08 11 -396 val_396 2008-04-08 12 -396 val_396 2008-04-08 12 -396 val_396 2008-04-08 12 -396 val_396 2008-04-09 11 -396 val_396 2008-04-09 11 -396 val_396 2008-04-09 11 -396 val_396 2008-04-09 12 -396 val_396 2008-04-09 12 -396 val_396 2008-04-09 12 -397 val_397 2008-04-08 11 -397 val_397 2008-04-08 11 -397 val_397 2008-04-08 12 -397 val_397 2008-04-08 12 -397 val_397 2008-04-09 11 -397 val_397 2008-04-09 11 -397 val_397 2008-04-09 12 -397 val_397 2008-04-09 12 -399 val_399 2008-04-08 11 -399 val_399 2008-04-08 11 -399 val_399 2008-04-08 12 -399 val_399 2008-04-08 12 -399 val_399 2008-04-09 11 -399 val_399 2008-04-09 11 -399 val_399 2008-04-09 12 -399 val_399 2008-04-09 12 -4 val_4 2008-04-08 11 -4 val_4 2008-04-08 12 -4 val_4 2008-04-09 11 -4 val_4 2008-04-09 12 -400 val_400 2008-04-08 11 -400 val_400 2008-04-08 12 -400 val_400 2008-04-09 11 -400 val_400 2008-04-09 12 -401 val_401 2008-04-08 11 -401 val_401 2008-04-08 11 -401 val_401 2008-04-08 11 -401 val_401 2008-04-08 11 -401 val_401 2008-04-08 11 -401 val_401 2008-04-08 12 -401 val_401 2008-04-08 12 -401 val_401 2008-04-08 12 -401 val_401 2008-04-08 12 -401 val_401 2008-04-08 12 -401 val_401 2008-04-09 11 -401 val_401 2008-04-09 11 -401 val_401 2008-04-09 11 -401 val_401 2008-04-09 11 -401 val_401 2008-04-09 11 -401 val_401 2008-04-09 12 -401 val_401 2008-04-09 12 -401 val_401 2008-04-09 12 -401 val_401 2008-04-09 12 -401 val_401 2008-04-09 12 -402 val_402 2008-04-08 11 -402 val_402 2008-04-08 12 -402 val_402 2008-04-09 11 -402 val_402 2008-04-09 12 -403 val_403 2008-04-08 11 -403 val_403 2008-04-08 11 -403 val_403 2008-04-08 11 -403 val_403 2008-04-08 12 -403 val_403 2008-04-08 12 -403 val_403 2008-04-08 12 -403 val_403 2008-04-09 11 -403 val_403 2008-04-09 11 -403 val_403 2008-04-09 11 -403 val_403 2008-04-09 12 -403 val_403 2008-04-09 12 -403 val_403 2008-04-09 12 -404 val_404 2008-04-08 11 -404 val_404 2008-04-08 11 -404 val_404 2008-04-08 12 -404 val_404 2008-04-08 12 -404 val_404 2008-04-09 11 -404 val_404 2008-04-09 11 -404 val_404 2008-04-09 12 -404 val_404 2008-04-09 12 -406 val_406 2008-04-08 11 -406 val_406 2008-04-08 11 -406 val_406 2008-04-08 11 -406 val_406 2008-04-08 11 -406 val_406 2008-04-08 12 -406 val_406 2008-04-08 12 -406 val_406 2008-04-08 12 -406 val_406 2008-04-08 12 -406 val_406 2008-04-09 11 -406 val_406 2008-04-09 11 -406 val_406 2008-04-09 11 -406 val_406 2008-04-09 11 -406 val_406 2008-04-09 12 -406 val_406 2008-04-09 12 -406 val_406 2008-04-09 12 -406 val_406 2008-04-09 12 -407 val_407 2008-04-08 11 -407 val_407 2008-04-08 12 -407 val_407 2008-04-09 11 -407 val_407 2008-04-09 12 -409 val_409 2008-04-08 11 -409 val_409 2008-04-08 11 -409 val_409 2008-04-08 11 -409 val_409 2008-04-08 12 -409 val_409 2008-04-08 12 -409 val_409 2008-04-08 12 -409 val_409 2008-04-09 11 -409 val_409 2008-04-09 11 -409 val_409 2008-04-09 11 -409 val_409 2008-04-09 12 -409 val_409 2008-04-09 12 -409 val_409 2008-04-09 12 -41 val_41 2008-04-08 11 -41 val_41 2008-04-08 12 -41 val_41 2008-04-09 11 -41 val_41 2008-04-09 12 -411 val_411 2008-04-08 11 -411 val_411 2008-04-08 12 -411 val_411 2008-04-09 11 -411 val_411 2008-04-09 12 -413 val_413 2008-04-08 11 -413 val_413 2008-04-08 11 -413 val_413 2008-04-08 12 -413 val_413 2008-04-08 12 -413 val_413 2008-04-09 11 -413 val_413 2008-04-09 11 -413 val_413 2008-04-09 12 -413 val_413 2008-04-09 12 -414 val_414 2008-04-08 11 -414 val_414 2008-04-08 11 -414 val_414 2008-04-08 12 -414 val_414 2008-04-08 12 -414 val_414 2008-04-09 11 -414 val_414 2008-04-09 11 -414 val_414 2008-04-09 12 -414 val_414 2008-04-09 12 -417 val_417 2008-04-08 11 -417 val_417 2008-04-08 11 -417 val_417 2008-04-08 11 -417 val_417 2008-04-08 12 -417 val_417 2008-04-08 12 -417 val_417 2008-04-08 12 -417 val_417 2008-04-09 11 -417 val_417 2008-04-09 11 -417 val_417 2008-04-09 11 -417 val_417 2008-04-09 12 -417 val_417 2008-04-09 12 -417 val_417 2008-04-09 12 -418 val_418 2008-04-08 11 -418 val_418 2008-04-08 12 -418 val_418 2008-04-09 11 -418 val_418 2008-04-09 12 -419 val_419 2008-04-08 11 -419 val_419 2008-04-08 12 -419 val_419 2008-04-09 11 -419 val_419 2008-04-09 12 -42 val_42 2008-04-08 11 -42 val_42 2008-04-08 11 -42 val_42 2008-04-08 12 -42 val_42 2008-04-08 12 -42 val_42 2008-04-09 11 -42 val_42 2008-04-09 11 -42 val_42 2008-04-09 12 -42 val_42 2008-04-09 12 -421 val_421 2008-04-08 11 -421 val_421 2008-04-08 12 -421 val_421 2008-04-09 11 -421 val_421 2008-04-09 12 -424 val_424 2008-04-08 11 -424 val_424 2008-04-08 11 -424 val_424 2008-04-08 12 -424 val_424 2008-04-08 12 -424 val_424 2008-04-09 11 -424 val_424 2008-04-09 11 -424 val_424 2008-04-09 12 -424 val_424 2008-04-09 12 -427 val_427 2008-04-08 11 -427 val_427 2008-04-08 12 -427 val_427 2008-04-09 11 -427 val_427 2008-04-09 12 -429 val_429 2008-04-08 11 -429 val_429 2008-04-08 11 -429 val_429 2008-04-08 12 -429 val_429 2008-04-08 12 -429 val_429 2008-04-09 11 -429 val_429 2008-04-09 11 -429 val_429 2008-04-09 12 -429 val_429 2008-04-09 12 -43 val_43 2008-04-08 11 -43 val_43 2008-04-08 12 -43 val_43 2008-04-09 11 -43 val_43 2008-04-09 12 -430 val_430 2008-04-08 11 -430 val_430 2008-04-08 11 -430 val_430 2008-04-08 11 -430 val_430 2008-04-08 12 -430 val_430 2008-04-08 12 -430 val_430 2008-04-08 12 -430 val_430 2008-04-09 11 -430 val_430 2008-04-09 11 -430 val_430 2008-04-09 11 -430 val_430 2008-04-09 12 -430 val_430 2008-04-09 12 -430 val_430 2008-04-09 12 -431 val_431 2008-04-08 11 -431 val_431 2008-04-08 11 -431 val_431 2008-04-08 11 -431 val_431 2008-04-08 12 -431 val_431 2008-04-08 12 -431 val_431 2008-04-08 12 -431 val_431 2008-04-09 11 -431 val_431 2008-04-09 11 -431 val_431 2008-04-09 11 -431 val_431 2008-04-09 12 -431 val_431 2008-04-09 12 -431 val_431 2008-04-09 12 -432 val_432 2008-04-08 11 -432 val_432 2008-04-08 12 -432 val_432 2008-04-09 11 -432 val_432 2008-04-09 12 -435 val_435 2008-04-08 11 -435 val_435 2008-04-08 12 -435 val_435 2008-04-09 11 -435 val_435 2008-04-09 12 -436 val_436 2008-04-08 11 -436 val_436 2008-04-08 12 -436 val_436 2008-04-09 11 -436 val_436 2008-04-09 12 -437 val_437 2008-04-08 11 -437 val_437 2008-04-08 12 -437 val_437 2008-04-09 11 -437 val_437 2008-04-09 12 -438 val_438 2008-04-08 11 -438 val_438 2008-04-08 11 -438 val_438 2008-04-08 11 -438 val_438 2008-04-08 12 -438 val_438 2008-04-08 12 -438 val_438 2008-04-08 12 -438 val_438 2008-04-09 11 -438 val_438 2008-04-09 11 -438 val_438 2008-04-09 11 -438 val_438 2008-04-09 12 -438 val_438 2008-04-09 12 -438 val_438 2008-04-09 12 -439 val_439 2008-04-08 11 -439 val_439 2008-04-08 11 -439 val_439 2008-04-08 12 -439 val_439 2008-04-08 12 -439 val_439 2008-04-09 11 -439 val_439 2008-04-09 11 -439 val_439 2008-04-09 12 -439 val_439 2008-04-09 12 -44 val_44 2008-04-08 11 -44 val_44 2008-04-08 12 -44 val_44 2008-04-09 11 -44 val_44 2008-04-09 12 -443 val_443 2008-04-08 11 -443 val_443 2008-04-08 12 -443 val_443 2008-04-09 11 -443 val_443 2008-04-09 12 -444 val_444 2008-04-08 11 -444 val_444 2008-04-08 12 -444 val_444 2008-04-09 11 -444 val_444 2008-04-09 12 -446 val_446 2008-04-08 11 -446 val_446 2008-04-08 12 -446 val_446 2008-04-09 11 -446 val_446 2008-04-09 12 -448 val_448 2008-04-08 11 -448 val_448 2008-04-08 12 -448 val_448 2008-04-09 11 -448 val_448 2008-04-09 12 -449 val_449 2008-04-08 11 -449 val_449 2008-04-08 12 -449 val_449 2008-04-09 11 -449 val_449 2008-04-09 12 -452 val_452 2008-04-08 11 -452 val_452 2008-04-08 12 -452 val_452 2008-04-09 11 -452 val_452 2008-04-09 12 -453 val_453 2008-04-08 11 -453 val_453 2008-04-08 12 -453 val_453 2008-04-09 11 -453 val_453 2008-04-09 12 -454 val_454 2008-04-08 11 -454 val_454 2008-04-08 11 -454 val_454 2008-04-08 11 -454 val_454 2008-04-08 12 -454 val_454 2008-04-08 12 -454 val_454 2008-04-08 12 -454 val_454 2008-04-09 11 -454 val_454 2008-04-09 11 -454 val_454 2008-04-09 11 -454 val_454 2008-04-09 12 -454 val_454 2008-04-09 12 -454 val_454 2008-04-09 12 -455 val_455 2008-04-08 11 -455 val_455 2008-04-08 12 -455 val_455 2008-04-09 11 -455 val_455 2008-04-09 12 -457 val_457 2008-04-08 11 -457 val_457 2008-04-08 12 -457 val_457 2008-04-09 11 -457 val_457 2008-04-09 12 -458 val_458 2008-04-08 11 -458 val_458 2008-04-08 11 -458 val_458 2008-04-08 12 -458 val_458 2008-04-08 12 -458 val_458 2008-04-09 11 -458 val_458 2008-04-09 11 -458 val_458 2008-04-09 12 -458 val_458 2008-04-09 12 -459 val_459 2008-04-08 11 -459 val_459 2008-04-08 11 -459 val_459 2008-04-08 12 -459 val_459 2008-04-08 12 -459 val_459 2008-04-09 11 -459 val_459 2008-04-09 11 -459 val_459 2008-04-09 12 -459 val_459 2008-04-09 12 -460 val_460 2008-04-08 11 -460 val_460 2008-04-08 12 -460 val_460 2008-04-09 11 -460 val_460 2008-04-09 12 -462 val_462 2008-04-08 11 -462 val_462 2008-04-08 11 -462 val_462 2008-04-08 12 -462 val_462 2008-04-08 12 -462 val_462 2008-04-09 11 -462 val_462 2008-04-09 11 -462 val_462 2008-04-09 12 -462 val_462 2008-04-09 12 -463 val_463 2008-04-08 11 -463 val_463 2008-04-08 11 -463 val_463 2008-04-08 12 -463 val_463 2008-04-08 12 -463 val_463 2008-04-09 11 -463 val_463 2008-04-09 11 -463 val_463 2008-04-09 12 -463 val_463 2008-04-09 12 -466 val_466 2008-04-08 11 -466 val_466 2008-04-08 11 -466 val_466 2008-04-08 11 -466 val_466 2008-04-08 12 -466 val_466 2008-04-08 12 -466 val_466 2008-04-08 12 -466 val_466 2008-04-09 11 -466 val_466 2008-04-09 11 -466 val_466 2008-04-09 11 -466 val_466 2008-04-09 12 -466 val_466 2008-04-09 12 -466 val_466 2008-04-09 12 -467 val_467 2008-04-08 11 -467 val_467 2008-04-08 12 -467 val_467 2008-04-09 11 -467 val_467 2008-04-09 12 -468 val_468 2008-04-08 11 -468 val_468 2008-04-08 11 -468 val_468 2008-04-08 11 -468 val_468 2008-04-08 11 -468 val_468 2008-04-08 12 -468 val_468 2008-04-08 12 -468 val_468 2008-04-08 12 -468 val_468 2008-04-08 12 -468 val_468 2008-04-09 11 -468 val_468 2008-04-09 11 -468 val_468 2008-04-09 11 -468 val_468 2008-04-09 11 -468 val_468 2008-04-09 12 -468 val_468 2008-04-09 12 -468 val_468 2008-04-09 12 -468 val_468 2008-04-09 12 -469 val_469 2008-04-08 11 -469 val_469 2008-04-08 11 -469 val_469 2008-04-08 11 -469 val_469 2008-04-08 11 -469 val_469 2008-04-08 11 -469 val_469 2008-04-08 12 -469 val_469 2008-04-08 12 -469 val_469 2008-04-08 12 -469 val_469 2008-04-08 12 -469 val_469 2008-04-08 12 -469 val_469 2008-04-09 11 -469 val_469 2008-04-09 11 -469 val_469 2008-04-09 11 -469 val_469 2008-04-09 11 -469 val_469 2008-04-09 11 -469 val_469 2008-04-09 12 -469 val_469 2008-04-09 12 -469 val_469 2008-04-09 12 -469 val_469 2008-04-09 12 -469 val_469 2008-04-09 12 -47 val_47 2008-04-08 11 -47 val_47 2008-04-08 12 -47 val_47 2008-04-09 11 -47 val_47 2008-04-09 12 -470 val_470 2008-04-08 11 -470 val_470 2008-04-08 12 -470 val_470 2008-04-09 11 -470 val_470 2008-04-09 12 -472 val_472 2008-04-08 11 -472 val_472 2008-04-08 12 -472 val_472 2008-04-09 11 -472 val_472 2008-04-09 12 -475 val_475 2008-04-08 11 -475 val_475 2008-04-08 12 -475 val_475 2008-04-09 11 -475 val_475 2008-04-09 12 -477 val_477 2008-04-08 11 -477 val_477 2008-04-08 12 -477 val_477 2008-04-09 11 -477 val_477 2008-04-09 12 -478 val_478 2008-04-08 11 -478 val_478 2008-04-08 11 -478 val_478 2008-04-08 12 -478 val_478 2008-04-08 12 -478 val_478 2008-04-09 11 -478 val_478 2008-04-09 11 -478 val_478 2008-04-09 12 -478 val_478 2008-04-09 12 -479 val_479 2008-04-08 11 -479 val_479 2008-04-08 12 -479 val_479 2008-04-09 11 -479 val_479 2008-04-09 12 -480 val_480 2008-04-08 11 -480 val_480 2008-04-08 11 -480 val_480 2008-04-08 11 -480 val_480 2008-04-08 12 -480 val_480 2008-04-08 12 -480 val_480 2008-04-08 12 -480 val_480 2008-04-09 11 -480 val_480 2008-04-09 11 -480 val_480 2008-04-09 11 -480 val_480 2008-04-09 12 -480 val_480 2008-04-09 12 -480 val_480 2008-04-09 12 -481 val_481 2008-04-08 11 -481 val_481 2008-04-08 12 -481 val_481 2008-04-09 11 -481 val_481 2008-04-09 12 -482 val_482 2008-04-08 11 -482 val_482 2008-04-08 12 -482 val_482 2008-04-09 11 -482 val_482 2008-04-09 12 -483 val_483 2008-04-08 11 -483 val_483 2008-04-08 12 -483 val_483 2008-04-09 11 -483 val_483 2008-04-09 12 -484 val_484 2008-04-08 11 -484 val_484 2008-04-08 12 -484 val_484 2008-04-09 11 -484 val_484 2008-04-09 12 -485 val_485 2008-04-08 11 -485 val_485 2008-04-08 12 -485 val_485 2008-04-09 11 -485 val_485 2008-04-09 12 -487 val_487 2008-04-08 11 -487 val_487 2008-04-08 12 -487 val_487 2008-04-09 11 -487 val_487 2008-04-09 12 -489 val_489 2008-04-08 11 -489 val_489 2008-04-08 11 -489 val_489 2008-04-08 11 -489 val_489 2008-04-08 11 -489 val_489 2008-04-08 12 -489 val_489 2008-04-08 12 -489 val_489 2008-04-08 12 -489 val_489 2008-04-08 12 -489 val_489 2008-04-09 11 -489 val_489 2008-04-09 11 -489 val_489 2008-04-09 11 -489 val_489 2008-04-09 11 -489 val_489 2008-04-09 12 -489 val_489 2008-04-09 12 -489 val_489 2008-04-09 12 -489 val_489 2008-04-09 12 -490 val_490 2008-04-08 11 -490 val_490 2008-04-08 12 -490 val_490 2008-04-09 11 -490 val_490 2008-04-09 12 -491 val_491 2008-04-08 11 -491 val_491 2008-04-08 12 -491 val_491 2008-04-09 11 -491 val_491 2008-04-09 12 -492 val_492 2008-04-08 11 -492 val_492 2008-04-08 11 -492 val_492 2008-04-08 12 -492 val_492 2008-04-08 12 -492 val_492 2008-04-09 11 -492 val_492 2008-04-09 11 -492 val_492 2008-04-09 12 -492 val_492 2008-04-09 12 -493 val_493 2008-04-08 11 -493 val_493 2008-04-08 12 -493 val_493 2008-04-09 11 -493 val_493 2008-04-09 12 -494 val_494 2008-04-08 11 -494 val_494 2008-04-08 12 -494 val_494 2008-04-09 11 -494 val_494 2008-04-09 12 -495 val_495 2008-04-08 11 -495 val_495 2008-04-08 12 -495 val_495 2008-04-09 11 -495 val_495 2008-04-09 12 -496 val_496 2008-04-08 11 -496 val_496 2008-04-08 12 -496 val_496 2008-04-09 11 -496 val_496 2008-04-09 12 -497 val_497 2008-04-08 11 -497 val_497 2008-04-08 12 -497 val_497 2008-04-09 11 -497 val_497 2008-04-09 12 -498 val_498 2008-04-08 11 -498 val_498 2008-04-08 11 -498 val_498 2008-04-08 11 -498 val_498 2008-04-08 12 -498 val_498 2008-04-08 12 -498 val_498 2008-04-08 12 -498 val_498 2008-04-09 11 -498 val_498 2008-04-09 11 -498 val_498 2008-04-09 11 -498 val_498 2008-04-09 12 -498 val_498 2008-04-09 12 -498 val_498 2008-04-09 12 -5 val_5 2008-04-08 11 -5 val_5 2008-04-08 11 -5 val_5 2008-04-08 11 -5 val_5 2008-04-08 12 -5 val_5 2008-04-08 12 -5 val_5 2008-04-08 12 -5 val_5 2008-04-09 11 -5 val_5 2008-04-09 11 -5 val_5 2008-04-09 11 -5 val_5 2008-04-09 12 -5 val_5 2008-04-09 12 -5 val_5 2008-04-09 12 -51 val_51 2008-04-08 11 -51 val_51 2008-04-08 11 -51 val_51 2008-04-08 12 -51 val_51 2008-04-08 12 -51 val_51 2008-04-09 11 -51 val_51 2008-04-09 11 -51 val_51 2008-04-09 12 -51 val_51 2008-04-09 12 -53 val_53 2008-04-08 11 -53 val_53 2008-04-08 12 -53 val_53 2008-04-09 11 -53 val_53 2008-04-09 12 -54 val_54 2008-04-08 11 -54 val_54 2008-04-08 12 -54 val_54 2008-04-09 11 -54 val_54 2008-04-09 12 -57 val_57 2008-04-08 11 -57 val_57 2008-04-08 12 -57 val_57 2008-04-09 11 -57 val_57 2008-04-09 12 -58 val_58 2008-04-08 11 -58 val_58 2008-04-08 11 -58 val_58 2008-04-08 12 -58 val_58 2008-04-08 12 -58 val_58 2008-04-09 11 -58 val_58 2008-04-09 11 -58 val_58 2008-04-09 12 -58 val_58 2008-04-09 12 -64 val_64 2008-04-08 11 -64 val_64 2008-04-08 12 -64 val_64 2008-04-09 11 -64 val_64 2008-04-09 12 -65 val_65 2008-04-08 11 -65 val_65 2008-04-08 12 -65 val_65 2008-04-09 11 -65 val_65 2008-04-09 12 -66 val_66 2008-04-08 11 -66 val_66 2008-04-08 12 -66 val_66 2008-04-09 11 -66 val_66 2008-04-09 12 -67 val_67 2008-04-08 11 -67 val_67 2008-04-08 11 -67 val_67 2008-04-08 12 -67 val_67 2008-04-08 12 -67 val_67 2008-04-09 11 -67 val_67 2008-04-09 11 -67 val_67 2008-04-09 12 -67 val_67 2008-04-09 12 -69 val_69 2008-04-08 11 -69 val_69 2008-04-08 12 -69 val_69 2008-04-09 11 -69 val_69 2008-04-09 12 -70 val_70 2008-04-08 11 -70 val_70 2008-04-08 11 -70 val_70 2008-04-08 11 -70 val_70 2008-04-08 12 -70 val_70 2008-04-08 12 -70 val_70 2008-04-08 12 -70 val_70 2008-04-09 11 -70 val_70 2008-04-09 11 -70 val_70 2008-04-09 11 -70 val_70 2008-04-09 12 -70 val_70 2008-04-09 12 -70 val_70 2008-04-09 12 -72 val_72 2008-04-08 11 -72 val_72 2008-04-08 11 -72 val_72 2008-04-08 12 -72 val_72 2008-04-08 12 -72 val_72 2008-04-09 11 -72 val_72 2008-04-09 11 -72 val_72 2008-04-09 12 -72 val_72 2008-04-09 12 -74 val_74 2008-04-08 11 -74 val_74 2008-04-08 12 -74 val_74 2008-04-09 11 -74 val_74 2008-04-09 12 -76 val_76 2008-04-08 11 -76 val_76 2008-04-08 11 -76 val_76 2008-04-08 12 -76 val_76 2008-04-08 12 -76 val_76 2008-04-09 11 -76 val_76 2008-04-09 11 -76 val_76 2008-04-09 12 -76 val_76 2008-04-09 12 -77 val_77 2008-04-08 11 -77 val_77 2008-04-08 12 -77 val_77 2008-04-09 11 -77 val_77 2008-04-09 12 -78 val_78 2008-04-08 11 -78 val_78 2008-04-08 12 -78 val_78 2008-04-09 11 -78 val_78 2008-04-09 12 -8 val_8 2008-04-08 11 -8 val_8 2008-04-08 12 -8 val_8 2008-04-09 11 -8 val_8 2008-04-09 12 -80 val_80 2008-04-08 11 -80 val_80 2008-04-08 12 -80 val_80 2008-04-09 11 -80 val_80 2008-04-09 12 -82 val_82 2008-04-08 11 -82 val_82 2008-04-08 12 -82 val_82 2008-04-09 11 -82 val_82 2008-04-09 12 -83 val_83 2008-04-08 11 -83 val_83 2008-04-08 11 -83 val_83 2008-04-08 12 -83 val_83 2008-04-08 12 -83 val_83 2008-04-09 11 -83 val_83 2008-04-09 11 -83 val_83 2008-04-09 12 -83 val_83 2008-04-09 12 -84 val_84 2008-04-08 11 -84 val_84 2008-04-08 11 -84 val_84 2008-04-08 12 -84 val_84 2008-04-08 12 -84 val_84 2008-04-09 11 -84 val_84 2008-04-09 11 -84 val_84 2008-04-09 12 -84 val_84 2008-04-09 12 -85 val_85 2008-04-08 11 -85 val_85 2008-04-08 12 -85 val_85 2008-04-09 11 -85 val_85 2008-04-09 12 -86 val_86 2008-04-08 11 -86 val_86 2008-04-08 12 -86 val_86 2008-04-09 11 -86 val_86 2008-04-09 12 -87 val_87 2008-04-08 11 -87 val_87 2008-04-08 12 -87 val_87 2008-04-09 11 -87 val_87 2008-04-09 12 -9 val_9 2008-04-08 11 -9 val_9 2008-04-08 12 -9 val_9 2008-04-09 11 -9 val_9 2008-04-09 12 -90 val_90 2008-04-08 11 -90 val_90 2008-04-08 11 -90 val_90 2008-04-08 11 -90 val_90 2008-04-08 12 -90 val_90 2008-04-08 12 -90 val_90 2008-04-08 12 -90 val_90 2008-04-09 11 -90 val_90 2008-04-09 11 -90 val_90 2008-04-09 11 -90 val_90 2008-04-09 12 -90 val_90 2008-04-09 12 -90 val_90 2008-04-09 12 -92 val_92 2008-04-08 11 -92 val_92 2008-04-08 12 -92 val_92 2008-04-09 11 -92 val_92 2008-04-09 12 -95 val_95 2008-04-08 11 -95 val_95 2008-04-08 11 -95 val_95 2008-04-08 12 -95 val_95 2008-04-08 12 -95 val_95 2008-04-09 11 -95 val_95 2008-04-09 11 -95 val_95 2008-04-09 12 -95 val_95 2008-04-09 12 -96 val_96 2008-04-08 11 -96 val_96 2008-04-08 12 -96 val_96 2008-04-09 11 -96 val_96 2008-04-09 12 -97 val_97 2008-04-08 11 -97 val_97 2008-04-08 11 -97 val_97 2008-04-08 12 -97 val_97 2008-04-08 12 -97 val_97 2008-04-09 11 -97 val_97 2008-04-09 11 -97 val_97 2008-04-09 12 -97 val_97 2008-04-09 12 -98 val_98 2008-04-08 11 -98 val_98 2008-04-08 11 -98 val_98 2008-04-08 12 -98 val_98 2008-04-08 12 -98 val_98 2008-04-09 11 -98 val_98 2008-04-09 11 -98 val_98 2008-04-09 12 -98 val_98 2008-04-09 12
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/lvj_mapjoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/lvj_mapjoin.q.out b/ql/src/test/results/clientpositive/tez/lvj_mapjoin.q.out deleted file mode 100644 index b3407b2..0000000 --- a/ql/src/test/results/clientpositive/tez/lvj_mapjoin.q.out +++ /dev/null @@ -1,295 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS - -drop table sour1 -PREHOOK: type: DROPTABLE -POSTHOOK: query: -- SORT_QUERY_RESULTS - -drop table sour1 -POSTHOOK: type: DROPTABLE -PREHOOK: query: drop table sour2 -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table sour2 -POSTHOOK: type: DROPTABLE -PREHOOK: query: drop table expod1 -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table expod1 -POSTHOOK: type: DROPTABLE -PREHOOK: query: drop table expod2 -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table expod2 -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table sour1(id int, av1 string, av2 string, av3 string) row format delimited fields terminated by ',' -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@sour1 -POSTHOOK: query: create table sour1(id int, av1 string, av2 string, av3 string) row format delimited fields terminated by ',' -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@sour1 -PREHOOK: query: create table sour2(id int, bv1 string, bv2 string, bv3 string) row format delimited fields terminated by ',' -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@sour2 -POSTHOOK: query: create table sour2(id int, bv1 string, bv2 string, bv3 string) row format delimited fields terminated by ',' -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@sour2 -PREHOOK: query: load data local inpath '../../data/files/sour1.txt' into table sour1 -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@sour1 -POSTHOOK: query: load data local inpath '../../data/files/sour1.txt' into table sour1 -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@sour1 -PREHOOK: query: load data local inpath '../../data/files//sour2.txt' into table sour2 -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@sour2 -POSTHOOK: query: load data local inpath '../../data/files//sour2.txt' into table sour2 -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@sour2 -PREHOOK: query: create table expod1(aid int, av array<string>) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@expod1 -POSTHOOK: query: create table expod1(aid int, av array<string>) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@expod1 -PREHOOK: query: create table expod2(bid int, bv array<string>) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@expod2 -POSTHOOK: query: create table expod2(bid int, bv array<string>) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@expod2 -PREHOOK: query: insert overwrite table expod1 select id, array(av1,av2,av3) from sour1 -PREHOOK: type: QUERY -PREHOOK: Input: default@sour1 -PREHOOK: Output: default@expod1 -POSTHOOK: query: insert overwrite table expod1 select id, array(av1,av2,av3) from sour1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@sour1 -POSTHOOK: Output: default@expod1 -POSTHOOK: Lineage: expod1.aid SIMPLE [(sour1)sour1.FieldSchema(name:id, type:int, comment:null), ] -POSTHOOK: Lineage: expod1.av EXPRESSION [(sour1)sour1.FieldSchema(name:av1, type:string, comment:null), (sour1)sour1.FieldSchema(name:av2, type:string, comment:null), (sour1)sour1.FieldSchema(name:av3, type:string, comment:null), ] -PREHOOK: query: insert overwrite table expod2 select id, array(bv1,bv2,bv3) from sour2 -PREHOOK: type: QUERY -PREHOOK: Input: default@sour2 -PREHOOK: Output: default@expod2 -POSTHOOK: query: insert overwrite table expod2 select id, array(bv1,bv2,bv3) from sour2 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@sour2 -POSTHOOK: Output: default@expod2 -POSTHOOK: Lineage: expod2.bid SIMPLE [(sour2)sour2.FieldSchema(name:id, type:int, comment:null), ] -POSTHOOK: Lineage: expod2.bv EXPRESSION [(sour2)sour2.FieldSchema(name:bv1, type:string, comment:null), (sour2)sour2.FieldSchema(name:bv2, type:string, comment:null), (sour2)sour2.FieldSchema(name:bv3, type:string, comment:null), ] -PREHOOK: query: explain with sub1 as -(select aid, avalue from expod1 lateral view explode(av) avs as avalue ), -sub2 as -(select bid, bvalue from expod2 lateral view explode(bv) bvs as bvalue) -select sub1.aid, sub1.avalue, sub2.bvalue -from sub1,sub2 -where sub1.aid=sub2.bid -PREHOOK: type: QUERY -POSTHOOK: query: explain with sub1 as -(select aid, avalue from expod1 lateral view explode(av) avs as avalue ), -sub2 as -(select bid, bvalue from expod2 lateral view explode(bv) bvs as bvalue) -select sub1.aid, sub1.avalue, sub2.bvalue -from sub1,sub2 -where sub1.aid=sub2.bid -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 1 <- Map 2 (BROADCAST_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: expod1 - Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: aid is not null (type: boolean) - Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE - Lateral View Forward - Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: aid (type: int) - outputColumnNames: aid - Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE - Lateral View Join Operator - outputColumnNames: _col0, _col5 - Statistics: Num rows: 6 Data size: 78 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: int), _col5 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 6 Data size: 78 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 _col0 (type: int) - 1 _col0 (type: int) - outputColumnNames: _col0, _col1, _col2, _col3 - input vertices: - 1 Map 2 - Statistics: Num rows: 6 Data size: 85 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Filter Operator - predicate: (_col0 = _col2) (type: boolean) - Statistics: Num rows: 3 Data size: 42 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: int), _col1 (type: string), _col3 (type: string) - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 3 Data size: 42 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 3 Data size: 42 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - Select Operator - expressions: av (type: array<string>) - outputColumnNames: _col0 - Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE - UDTF Operator - Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE - function name: explode - Lateral View Join Operator - outputColumnNames: _col0, _col5 - Statistics: Num rows: 6 Data size: 78 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: int), _col5 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 6 Data size: 78 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 _col0 (type: int) - 1 _col0 (type: int) - outputColumnNames: _col0, _col1, _col2, _col3 - input vertices: - 1 Map 2 - Statistics: Num rows: 6 Data size: 85 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Filter Operator - predicate: (_col0 = _col2) (type: boolean) - Statistics: Num rows: 3 Data size: 42 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: int), _col1 (type: string), _col3 (type: string) - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 3 Data size: 42 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 3 Data size: 42 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - Map 2 - Map Operator Tree: - TableScan - alias: expod2 - Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: bid is not null (type: boolean) - Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE - Lateral View Forward - Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: bid (type: int) - outputColumnNames: bid - Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE - Lateral View Join Operator - outputColumnNames: _col0, _col5 - Statistics: Num rows: 6 Data size: 78 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: int), _col5 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 6 Data size: 78 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 6 Data size: 78 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: string) - Select Operator - expressions: bv (type: array<string>) - outputColumnNames: _col0 - Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE - UDTF Operator - Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE - function name: explode - Lateral View Join Operator - outputColumnNames: _col0, _col5 - Statistics: Num rows: 6 Data size: 78 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: int), _col5 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 6 Data size: 78 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 6 Data size: 78 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: string) - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: with sub1 as -(select aid, avalue from expod1 lateral view explode(av) avs as avalue ), -sub2 as -(select bid, bvalue from expod2 lateral view explode(bv) bvs as bvalue) -select sub1.aid, sub1.avalue, sub2.bvalue -from sub1,sub2 -where sub1.aid=sub2.bid -PREHOOK: type: QUERY -PREHOOK: Input: default@expod1 -PREHOOK: Input: default@expod2 -#### A masked pattern was here #### -POSTHOOK: query: with sub1 as -(select aid, avalue from expod1 lateral view explode(av) avs as avalue ), -sub2 as -(select bid, bvalue from expod2 lateral view explode(bv) bvs as bvalue) -select sub1.aid, sub1.avalue, sub2.bvalue -from sub1,sub2 -where sub1.aid=sub2.bid -POSTHOOK: type: QUERY -POSTHOOK: Input: default@expod1 -POSTHOOK: Input: default@expod2 -#### A masked pattern was here #### -1 a1 b1 -1 a1 b11 -1 a1 b111 -1 a11 b1 -1 a11 b11 -1 a11 b111 -1 a111 b1 -1 a111 b11 -1 a111 b111 -2 a2 b2 -2 a2 b22 -2 a2 b222 -2 a22 b2 -2 a22 b22 -2 a22 b222 -2 a222 b2 -2 a222 b22 -2 a222 b222 http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/mapjoin2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/mapjoin2.q.out b/ql/src/test/results/clientpositive/tez/mapjoin2.q.out deleted file mode 100644 index a7f7d15..0000000 --- a/ql/src/test/results/clientpositive/tez/mapjoin2.q.out +++ /dev/null @@ -1,95 +0,0 @@ -PREHOOK: query: create table tbl (n bigint, t string) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@tbl -POSTHOOK: query: create table tbl (n bigint, t string) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@tbl -PREHOOK: query: insert into tbl values (1, 'one') -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 -PREHOOK: Output: default@tbl -POSTHOOK: query: insert into tbl values (1, 'one') -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 -POSTHOOK: Output: default@tbl -POSTHOOK: Lineage: tbl.n EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: tbl.t SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -PREHOOK: query: insert into tbl values(2, 'two') -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 -PREHOOK: Output: default@tbl -POSTHOOK: query: insert into tbl values(2, 'two') -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 -POSTHOOK: Output: default@tbl -POSTHOOK: Lineage: tbl.n EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: tbl.t SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -Warning: Map Join MAPJOIN[13][bigTable=?] in task 'Map 1' is a cross product -PREHOOK: query: select a.n, a.t, isnull(b.n), isnull(b.t) from (select * from tbl where n = 1) a left outer join (select * from tbl where 1 = 2) b on a.n = b.n -PREHOOK: type: QUERY -PREHOOK: Input: default@tbl -#### A masked pattern was here #### -POSTHOOK: query: select a.n, a.t, isnull(b.n), isnull(b.t) from (select * from tbl where n = 1) a left outer join (select * from tbl where 1 = 2) b on a.n = b.n -POSTHOOK: type: QUERY -POSTHOOK: Input: default@tbl -#### A masked pattern was here #### -1 one true true -Warning: Map Join MAPJOIN[13][bigTable=?] in task 'Map 2' is a cross product -PREHOOK: query: select isnull(a.n), isnull(a.t), b.n, b.t from (select * from tbl where 2 = 1) a right outer join (select * from tbl where n = 2) b on a.n = b.n -PREHOOK: type: QUERY -PREHOOK: Input: default@tbl -#### A masked pattern was here #### -POSTHOOK: query: select isnull(a.n), isnull(a.t), b.n, b.t from (select * from tbl where 2 = 1) a right outer join (select * from tbl where n = 2) b on a.n = b.n -POSTHOOK: type: QUERY -POSTHOOK: Input: default@tbl -#### A masked pattern was here #### -true true 2 two -Warning: Shuffle Join MERGEJOIN[13][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: select isnull(a.n), isnull(a.t), isnull(b.n), isnull(b.t) from (select * from tbl where n = 1) a full outer join (select * from tbl where n = 2) b on a.n = b.n -PREHOOK: type: QUERY -PREHOOK: Input: default@tbl -#### A masked pattern was here #### -POSTHOOK: query: select isnull(a.n), isnull(a.t), isnull(b.n), isnull(b.t) from (select * from tbl where n = 1) a full outer join (select * from tbl where n = 2) b on a.n = b.n -POSTHOOK: type: QUERY -POSTHOOK: Input: default@tbl -#### A masked pattern was here #### -false false true true -true true false false -PREHOOK: query: select a.key, a.a_one, b.b_one, a.a_zero, b.b_zero from ( SELECT 11 key, 0 confuse_you, 1 a_one, 0 a_zero ) a join ( SELECT 11 key, 0 confuse_you, 1 b_one, 0 b_zero ) b on a.key = b.key -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -#### A masked pattern was here #### -POSTHOOK: query: select a.key, a.a_one, b.b_one, a.a_zero, b.b_zero from ( SELECT 11 key, 0 confuse_you, 1 a_one, 0 a_zero ) a join ( SELECT 11 key, 0 confuse_you, 1 b_one, 0 b_zero ) b on a.key = b.key -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -#### A masked pattern was here #### -11 1 1 0 0 -PREHOOK: query: select a.key, a.a_one, b.b_one, a.a_zero, b.b_zero from ( SELECT 11 key, 0 confuse_you, 1 a_one, 0 a_zero ) a left outer join ( SELECT 11 key, 0 confuse_you, 1 b_one, 0 b_zero ) b on a.key = b.key -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -#### A masked pattern was here #### -POSTHOOK: query: select a.key, a.a_one, b.b_one, a.a_zero, b.b_zero from ( SELECT 11 key, 0 confuse_you, 1 a_one, 0 a_zero ) a left outer join ( SELECT 11 key, 0 confuse_you, 1 b_one, 0 b_zero ) b on a.key = b.key -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -#### A masked pattern was here #### -11 1 1 0 0 -PREHOOK: query: select a.key, a.a_one, b.b_one, a.a_zero, b.b_zero from ( SELECT 11 key, 0 confuse_you, 1 a_one, 0 a_zero ) a right outer join ( SELECT 11 key, 0 confuse_you, 1 b_one, 0 b_zero ) b on a.key = b.key -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -#### A masked pattern was here #### -POSTHOOK: query: select a.key, a.a_one, b.b_one, a.a_zero, b.b_zero from ( SELECT 11 key, 0 confuse_you, 1 a_one, 0 a_zero ) a right outer join ( SELECT 11 key, 0 confuse_you, 1 b_one, 0 b_zero ) b on a.key = b.key -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -#### A masked pattern was here #### -11 1 1 0 0 -PREHOOK: query: select a.key, a.a_one, b.b_one, a.a_zero, b.b_zero from ( SELECT 11 key, 0 confuse_you, 1 a_one, 0 a_zero ) a full outer join ( SELECT 11 key, 0 confuse_you, 1 b_one, 0 b_zero ) b on a.key = b.key -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -#### A masked pattern was here #### -POSTHOOK: query: select a.key, a.a_one, b.b_one, a.a_zero, b.b_zero from ( SELECT 11 key, 0 confuse_you, 1 a_one, 0 a_zero ) a full outer join ( SELECT 11 key, 0 confuse_you, 1 b_one, 0 b_zero ) b on a.key = b.key -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -#### A masked pattern was here #### -11 1 1 0 0
