You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by pr...@apache.org on 2015/09/15 22:42:20 UTC
[14/51] [partial] hive git commit: HIVE-11776: LLAP: Generate golden
files for all MiniLlapCluster tests (Prasanth Jayachandran)
http://git-wip-us.apache.org/repos/asf/hive/blob/ace87818/ql/src/test/results/clientpositive/llap/load_dyn_part3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/load_dyn_part3.q.out b/ql/src/test/results/clientpositive/llap/load_dyn_part3.q.out
new file mode 100644
index 0000000..65a3037
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/load_dyn_part3.q.out
@@ -0,0 +1,2138 @@
+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: 21248 Basic stats: COMPLETE Column stats: NONE
+ 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: 21248 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
+ 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
+ Execution mode: llap
+
+ 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/ace87818/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out b/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out
new file mode 100644
index 0000000..03c2ebd
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out
@@ -0,0 +1,296 @@
+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
+ 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: 2 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ Lateral View Forward
+ Statistics: Num rows: 2 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: aid (type: int)
+ outputColumnNames: aid
+ Statistics: Num rows: 2 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ Lateral View Join Operator
+ outputColumnNames: _col0, _col5
+ Statistics: Num rows: 4 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: int), _col5 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 4 Data size: 52 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: 4 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+ HybridGraceHashJoin: true
+ Filter Operator
+ predicate: (_col0 = _col2) (type: boolean)
+ Statistics: Num rows: 2 Data size: 28 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: 2 Data size: 28 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 2 Data size: 28 Basic stats: COMPLETE Column stats: NONE
+ 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
+ Select Operator
+ expressions: av (type: array<string>)
+ outputColumnNames: _col0
+ Statistics: Num rows: 2 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ UDTF Operator
+ Statistics: Num rows: 2 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ function name: explode
+ Lateral View Join Operator
+ outputColumnNames: _col0, _col5
+ Statistics: Num rows: 4 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: int), _col5 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 4 Data size: 52 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: 4 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+ HybridGraceHashJoin: true
+ Filter Operator
+ predicate: (_col0 = _col2) (type: boolean)
+ Statistics: Num rows: 2 Data size: 28 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: 2 Data size: 28 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 2 Data size: 28 Basic stats: COMPLETE Column stats: NONE
+ 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
+ Execution mode: llap
+ 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: 2 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ Lateral View Forward
+ Statistics: Num rows: 2 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: bid (type: int)
+ outputColumnNames: bid
+ Statistics: Num rows: 2 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ Lateral View Join Operator
+ outputColumnNames: _col0, _col5
+ Statistics: Num rows: 4 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: int), _col5 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 4 Data size: 52 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: 4 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: string)
+ Select Operator
+ expressions: bv (type: array<string>)
+ outputColumnNames: _col0
+ Statistics: Num rows: 2 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ UDTF Operator
+ Statistics: Num rows: 2 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ function name: explode
+ Lateral View Join Operator
+ outputColumnNames: _col0, _col5
+ Statistics: Num rows: 4 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: int), _col5 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 4 Data size: 52 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: 4 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: string)
+ Execution mode: llap
+
+ 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/ace87818/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out b/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
new file mode 100644
index 0000000..98d9ceb
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
@@ -0,0 +1,393 @@
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE over1k(t tinyint,
+ si smallint,
+ i int,
+ b bigint,
+ f float,
+ d double,
+ bo boolean,
+ s string,
+ ts timestamp,
+ dec decimal(4,2),
+ bin binary)
+ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
+STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@over1k
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE over1k(t tinyint,
+ si smallint,
+ i int,
+ b bigint,
+ f float,
+ d double,
+ bo boolean,
+ s string,
+ ts timestamp,
+ dec decimal(4,2),
+ bin binary)
+ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
+STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@over1k
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/over1k' OVERWRITE INTO TABLE over1k
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@over1k
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/over1k' OVERWRITE INTO TABLE over1k
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@over1k
+PREHOOK: query: CREATE TABLE t1(dec decimal(4,2)) STORED AS ORC
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
+POSTHOOK: query: CREATE TABLE t1(dec decimal(4,2)) STORED AS ORC
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@t1
+PREHOOK: query: INSERT INTO TABLE t1 select dec from over1k
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over1k
+PREHOOK: Output: default@t1
+POSTHOOK: query: INSERT INTO TABLE t1 select dec from over1k
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over1k
+POSTHOOK: Output: default@t1
+POSTHOOK: Lineage: t1.dec SIMPLE [(over1k)over1k.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
+PREHOOK: query: CREATE TABLE t2(dec decimal(4,0)) STORED AS ORC
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t2
+POSTHOOK: query: CREATE TABLE t2(dec decimal(4,0)) STORED AS ORC
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@t2
+PREHOOK: query: INSERT INTO TABLE t2 select dec from over1k
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over1k
+PREHOOK: Output: default@t2
+POSTHOOK: query: INSERT INTO TABLE t2 select dec from over1k
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over1k
+POSTHOOK: Output: default@t2
+POSTHOOK: Lineage: t2.dec EXPRESSION [(over1k)over1k.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
+PREHOOK: query: explain
+select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec) order by t1.dec
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec) order by t1.dec
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Map 1 <- Map 3 (BROADCAST_EDGE)
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: t1
+ Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: dec is not null (type: boolean)
+ Statistics: Num rows: 525 Data size: 58800 Basic stats: COMPLETE Column stats: NONE
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ keys:
+ 0 dec (type: decimal(6,2))
+ 1 dec (type: decimal(6,2))
+ outputColumnNames: _col0, _col4
+ input vertices:
+ 1 Map 3
+ Statistics: Num rows: 577 Data size: 64680 Basic stats: COMPLETE Column stats: NONE
+ HybridGraceHashJoin: true
+ Select Operator
+ expressions: _col0 (type: decimal(4,2)), _col4 (type: decimal(4,0))
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 577 Data size: 64680 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: decimal(4,2))
+ sort order: +
+ Statistics: Num rows: 577 Data size: 64680 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: decimal(4,0))
+ Execution mode: llap
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: t2
+ Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: dec is not null (type: boolean)
+ Statistics: Num rows: 525 Data size: 58800 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: dec (type: decimal(6,2))
+ sort order: +
+ Map-reduce partition columns: dec (type: decimal(6,2))
+ Statistics: Num rows: 525 Data size: 58800 Basic stats: COMPLETE Column stats: NONE
+ value expressions: dec (type: decimal(4,0))
+ Execution mode: llap
+ Reducer 2
+ Execution mode: uber
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: decimal(4,2)), VALUE._col0 (type: decimal(4,0))
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 577 Data size: 64680 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 577 Data size: 64680 Basic stats: COMPLETE Column stats: NONE
+ 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
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec) order by t1.dec
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec) order by t1.dec
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+#### A masked pattern was here ####
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+45 45
+45 45
+45 45
+45 45
+45 45
+6 6
+6 6
+6 6
+6 6
+6 6
+6 6
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+79 79
+79 79
+79 79
+79 79
+79 79
+79 79
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec) order by t1.dec
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec) order by t1.dec
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+#### A masked pattern was here ####
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+45 45
+45 45
+45 45
+45 45
+45 45
+6 6
+6 6
+6 6
+6 6
+6 6
+6 6
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+79 79
+79 79
+79 79
+79 79
+79 79
+79 79
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9