hadoop-hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From na...@apache.org
Subject svn commit: r934241 [13/16] - in /hadoop/hive/trunk: ./ common/src/java/org/apache/hadoop/hive/common/ common/src/java/org/apache/hadoop/hive/conf/ conf/ metastore/src/java/org/apache/hadoop/hive/metastore/ ql/src/java/org/apache/hadoop/hive/ql/exec/ q...
Date Wed, 14 Apr 2010 23:36:09 GMT
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part9.q.out?rev=934241&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part9.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part9.q.out Wed Apr 14 23:36:07 2010
@@ -0,0 +1,1140 @@
+PREHOOK: query: show partitions srcpart
+PREHOOK: type: SHOWPARTITIONS
+POSTHOOK: query: show partitions srcpart
+POSTHOOK: type: SHOWPARTITIONS
+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: drop table nzhang_part9
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table nzhang_part9
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table if not exists nzhang_part9 like srcpart
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table if not exists nzhang_part9 like srcpart
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@nzhang_part9
+PREHOOK: query: describe extended nzhang_part9
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe extended nzhang_part9
+POSTHOOK: type: DESCTABLE
+key	string	default
+value	string	default
+ds	string	
+hr	string	
+	 	 
+Detailed Table Information	Table(tableName:nzhang_part9, dbName:default, owner:null, createTime:1271267721, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/nzhang_part9, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], parameters:{EXTERNAL=FALSE,transient_lastDdlTime=1271267721}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
+PREHOOK: query: explain
+from srcpart
+insert overwrite table nzhang_part9 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08'
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+from srcpart
+insert overwrite table nzhang_part9 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08'
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF srcpart)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB nzhang_part9 (TOK_PARTSPEC (TOK_PARTVAL ds) (TOK_PARTVAL hr)))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value)) (TOK_SELEXPR (TOK_TABLE_OR_COL ds)) (TOK_SELEXPR (TOK_TABLE_OR_COL hr))) (TOK_WHERE (<= (TOK_TABLE_OR_COL ds) '2008-04-08'))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        srcpart 
+          TableScan
+            alias: srcpart
+            Filter Operator
+              predicate:
+                  expr: (ds <= '2008-04-08')
+                  type: boolean
+              Filter Operator
+                predicate:
+                    expr: (ds <= '2008-04-08')
+                    type: boolean
+                Select Operator
+                  expressions:
+                        expr: key
+                        type: string
+                        expr: value
+                        type: string
+                        expr: ds
+                        type: string
+                        expr: hr
+                        type: string
+                  outputColumnNames: _col0, _col1, _col2, _col3
+                  File Output Operator
+                    compressed: false
+                    GlobalTableId: 1
+                    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: nzhang_part9
+
+  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: nzhang_part9
+
+
+PREHOOK: query: from srcpart
+insert overwrite table nzhang_part9 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: query: from srcpart
+insert overwrite table nzhang_part9 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Output: default@nzhang_part9@ds=2008-04-08/hr=11
+POSTHOOK: Output: default@nzhang_part9@ds=2008-04-08/hr=12
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]
+PREHOOK: query: show partitions nzhang_part9
+PREHOOK: type: SHOWPARTITIONS
+POSTHOOK: query: show partitions nzhang_part9
+POSTHOOK: type: SHOWPARTITIONS
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]
+ds=2008-04-08/hr=11
+ds=2008-04-08/hr=12
+PREHOOK: query: select * from nzhang_part9 where ds is not null and hr is not null
+PREHOOK: type: QUERY
+PREHOOK: Input: default@nzhang_part9@ds=2008-04-08/hr=11
+PREHOOK: Input: default@nzhang_part9@ds=2008-04-08/hr=12
+PREHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-04-14_10-55-25_862_5372560267403711450/10000
+POSTHOOK: query: select * from nzhang_part9 where ds is not null and hr is not null
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@nzhang_part9@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@nzhang_part9@ds=2008-04-08/hr=12
+POSTHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-04-14_10-55-25_862_5372560267403711450/10000
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]
+238	val_238	2008-04-08	11
+86	val_86	2008-04-08	11
+311	val_311	2008-04-08	11
+27	val_27	2008-04-08	11
+165	val_165	2008-04-08	11
+409	val_409	2008-04-08	11
+255	val_255	2008-04-08	11
+278	val_278	2008-04-08	11
+98	val_98	2008-04-08	11
+484	val_484	2008-04-08	11
+265	val_265	2008-04-08	11
+193	val_193	2008-04-08	11
+401	val_401	2008-04-08	11
+150	val_150	2008-04-08	11
+273	val_273	2008-04-08	11
+224	val_224	2008-04-08	11
+369	val_369	2008-04-08	11
+66	val_66	2008-04-08	11
+128	val_128	2008-04-08	11
+213	val_213	2008-04-08	11
+146	val_146	2008-04-08	11
+406	val_406	2008-04-08	11
+429	val_429	2008-04-08	11
+374	val_374	2008-04-08	11
+152	val_152	2008-04-08	11
+469	val_469	2008-04-08	11
+145	val_145	2008-04-08	11
+495	val_495	2008-04-08	11
+37	val_37	2008-04-08	11
+327	val_327	2008-04-08	11
+281	val_281	2008-04-08	11
+277	val_277	2008-04-08	11
+209	val_209	2008-04-08	11
+15	val_15	2008-04-08	11
+82	val_82	2008-04-08	11
+403	val_403	2008-04-08	11
+166	val_166	2008-04-08	11
+417	val_417	2008-04-08	11
+430	val_430	2008-04-08	11
+252	val_252	2008-04-08	11
+292	val_292	2008-04-08	11
+219	val_219	2008-04-08	11
+287	val_287	2008-04-08	11
+153	val_153	2008-04-08	11
+193	val_193	2008-04-08	11
+338	val_338	2008-04-08	11
+446	val_446	2008-04-08	11
+459	val_459	2008-04-08	11
+394	val_394	2008-04-08	11
+237	val_237	2008-04-08	11
+482	val_482	2008-04-08	11
+174	val_174	2008-04-08	11
+413	val_413	2008-04-08	11
+494	val_494	2008-04-08	11
+207	val_207	2008-04-08	11
+199	val_199	2008-04-08	11
+466	val_466	2008-04-08	11
+208	val_208	2008-04-08	11
+174	val_174	2008-04-08	11
+399	val_399	2008-04-08	11
+396	val_396	2008-04-08	11
+247	val_247	2008-04-08	11
+417	val_417	2008-04-08	11
+489	val_489	2008-04-08	11
+162	val_162	2008-04-08	11
+377	val_377	2008-04-08	11
+397	val_397	2008-04-08	11
+309	val_309	2008-04-08	11
+365	val_365	2008-04-08	11
+266	val_266	2008-04-08	11
+439	val_439	2008-04-08	11
+342	val_342	2008-04-08	11
+367	val_367	2008-04-08	11
+325	val_325	2008-04-08	11
+167	val_167	2008-04-08	11
+195	val_195	2008-04-08	11
+475	val_475	2008-04-08	11
+17	val_17	2008-04-08	11
+113	val_113	2008-04-08	11
+155	val_155	2008-04-08	11
+203	val_203	2008-04-08	11
+339	val_339	2008-04-08	11
+0	val_0	2008-04-08	11
+455	val_455	2008-04-08	11
+128	val_128	2008-04-08	11
+311	val_311	2008-04-08	11
+316	val_316	2008-04-08	11
+57	val_57	2008-04-08	11
+302	val_302	2008-04-08	11
+205	val_205	2008-04-08	11
+149	val_149	2008-04-08	11
+438	val_438	2008-04-08	11
+345	val_345	2008-04-08	11
+129	val_129	2008-04-08	11
+170	val_170	2008-04-08	11
+20	val_20	2008-04-08	11
+489	val_489	2008-04-08	11
+157	val_157	2008-04-08	11
+378	val_378	2008-04-08	11
+221	val_221	2008-04-08	11
+92	val_92	2008-04-08	11
+111	val_111	2008-04-08	11
+47	val_47	2008-04-08	11
+72	val_72	2008-04-08	11
+4	val_4	2008-04-08	11
+280	val_280	2008-04-08	11
+35	val_35	2008-04-08	11
+427	val_427	2008-04-08	11
+277	val_277	2008-04-08	11
+208	val_208	2008-04-08	11
+356	val_356	2008-04-08	11
+399	val_399	2008-04-08	11
+169	val_169	2008-04-08	11
+382	val_382	2008-04-08	11
+498	val_498	2008-04-08	11
+125	val_125	2008-04-08	11
+386	val_386	2008-04-08	11
+437	val_437	2008-04-08	11
+469	val_469	2008-04-08	11
+192	val_192	2008-04-08	11
+286	val_286	2008-04-08	11
+187	val_187	2008-04-08	11
+176	val_176	2008-04-08	11
+54	val_54	2008-04-08	11
+459	val_459	2008-04-08	11
+51	val_51	2008-04-08	11
+138	val_138	2008-04-08	11
+103	val_103	2008-04-08	11
+239	val_239	2008-04-08	11
+213	val_213	2008-04-08	11
+216	val_216	2008-04-08	11
+430	val_430	2008-04-08	11
+278	val_278	2008-04-08	11
+176	val_176	2008-04-08	11
+289	val_289	2008-04-08	11
+221	val_221	2008-04-08	11
+65	val_65	2008-04-08	11
+318	val_318	2008-04-08	11
+332	val_332	2008-04-08	11
+311	val_311	2008-04-08	11
+275	val_275	2008-04-08	11
+137	val_137	2008-04-08	11
+241	val_241	2008-04-08	11
+83	val_83	2008-04-08	11
+333	val_333	2008-04-08	11
+180	val_180	2008-04-08	11
+284	val_284	2008-04-08	11
+12	val_12	2008-04-08	11
+230	val_230	2008-04-08	11
+181	val_181	2008-04-08	11
+67	val_67	2008-04-08	11
+260	val_260	2008-04-08	11
+404	val_404	2008-04-08	11
+384	val_384	2008-04-08	11
+489	val_489	2008-04-08	11
+353	val_353	2008-04-08	11
+373	val_373	2008-04-08	11
+272	val_272	2008-04-08	11
+138	val_138	2008-04-08	11
+217	val_217	2008-04-08	11
+84	val_84	2008-04-08	11
+348	val_348	2008-04-08	11
+466	val_466	2008-04-08	11
+58	val_58	2008-04-08	11
+8	val_8	2008-04-08	11
+411	val_411	2008-04-08	11
+230	val_230	2008-04-08	11
+208	val_208	2008-04-08	11
+348	val_348	2008-04-08	11
+24	val_24	2008-04-08	11
+463	val_463	2008-04-08	11
+431	val_431	2008-04-08	11
+179	val_179	2008-04-08	11
+172	val_172	2008-04-08	11
+42	val_42	2008-04-08	11
+129	val_129	2008-04-08	11
+158	val_158	2008-04-08	11
+119	val_119	2008-04-08	11
+496	val_496	2008-04-08	11
+0	val_0	2008-04-08	11
+322	val_322	2008-04-08	11
+197	val_197	2008-04-08	11
+468	val_468	2008-04-08	11
+393	val_393	2008-04-08	11
+454	val_454	2008-04-08	11
+100	val_100	2008-04-08	11
+298	val_298	2008-04-08	11
+199	val_199	2008-04-08	11
+191	val_191	2008-04-08	11
+418	val_418	2008-04-08	11
+96	val_96	2008-04-08	11
+26	val_26	2008-04-08	11
+165	val_165	2008-04-08	11
+327	val_327	2008-04-08	11
+230	val_230	2008-04-08	11
+205	val_205	2008-04-08	11
+120	val_120	2008-04-08	11
+131	val_131	2008-04-08	11
+51	val_51	2008-04-08	11
+404	val_404	2008-04-08	11
+43	val_43	2008-04-08	11
+436	val_436	2008-04-08	11
+156	val_156	2008-04-08	11
+469	val_469	2008-04-08	11
+468	val_468	2008-04-08	11
+308	val_308	2008-04-08	11
+95	val_95	2008-04-08	11
+196	val_196	2008-04-08	11
+288	val_288	2008-04-08	11
+481	val_481	2008-04-08	11
+457	val_457	2008-04-08	11
+98	val_98	2008-04-08	11
+282	val_282	2008-04-08	11
+197	val_197	2008-04-08	11
+187	val_187	2008-04-08	11
+318	val_318	2008-04-08	11
+318	val_318	2008-04-08	11
+409	val_409	2008-04-08	11
+470	val_470	2008-04-08	11
+137	val_137	2008-04-08	11
+369	val_369	2008-04-08	11
+316	val_316	2008-04-08	11
+169	val_169	2008-04-08	11
+413	val_413	2008-04-08	11
+85	val_85	2008-04-08	11
+77	val_77	2008-04-08	11
+0	val_0	2008-04-08	11
+490	val_490	2008-04-08	11
+87	val_87	2008-04-08	11
+364	val_364	2008-04-08	11
+179	val_179	2008-04-08	11
+118	val_118	2008-04-08	11
+134	val_134	2008-04-08	11
+395	val_395	2008-04-08	11
+282	val_282	2008-04-08	11
+138	val_138	2008-04-08	11
+238	val_238	2008-04-08	11
+419	val_419	2008-04-08	11
+15	val_15	2008-04-08	11
+118	val_118	2008-04-08	11
+72	val_72	2008-04-08	11
+90	val_90	2008-04-08	11
+307	val_307	2008-04-08	11
+19	val_19	2008-04-08	11
+435	val_435	2008-04-08	11
+10	val_10	2008-04-08	11
+277	val_277	2008-04-08	11
+273	val_273	2008-04-08	11
+306	val_306	2008-04-08	11
+224	val_224	2008-04-08	11
+309	val_309	2008-04-08	11
+389	val_389	2008-04-08	11
+327	val_327	2008-04-08	11
+242	val_242	2008-04-08	11
+369	val_369	2008-04-08	11
+392	val_392	2008-04-08	11
+272	val_272	2008-04-08	11
+331	val_331	2008-04-08	11
+401	val_401	2008-04-08	11
+242	val_242	2008-04-08	11
+452	val_452	2008-04-08	11
+177	val_177	2008-04-08	11
+226	val_226	2008-04-08	11
+5	val_5	2008-04-08	11
+497	val_497	2008-04-08	11
+402	val_402	2008-04-08	11
+396	val_396	2008-04-08	11
+317	val_317	2008-04-08	11
+395	val_395	2008-04-08	11
+58	val_58	2008-04-08	11
+35	val_35	2008-04-08	11
+336	val_336	2008-04-08	11
+95	val_95	2008-04-08	11
+11	val_11	2008-04-08	11
+168	val_168	2008-04-08	11
+34	val_34	2008-04-08	11
+229	val_229	2008-04-08	11
+233	val_233	2008-04-08	11
+143	val_143	2008-04-08	11
+472	val_472	2008-04-08	11
+322	val_322	2008-04-08	11
+498	val_498	2008-04-08	11
+160	val_160	2008-04-08	11
+195	val_195	2008-04-08	11
+42	val_42	2008-04-08	11
+321	val_321	2008-04-08	11
+430	val_430	2008-04-08	11
+119	val_119	2008-04-08	11
+489	val_489	2008-04-08	11
+458	val_458	2008-04-08	11
+78	val_78	2008-04-08	11
+76	val_76	2008-04-08	11
+41	val_41	2008-04-08	11
+223	val_223	2008-04-08	11
+492	val_492	2008-04-08	11
+149	val_149	2008-04-08	11
+449	val_449	2008-04-08	11
+218	val_218	2008-04-08	11
+228	val_228	2008-04-08	11
+138	val_138	2008-04-08	11
+453	val_453	2008-04-08	11
+30	val_30	2008-04-08	11
+209	val_209	2008-04-08	11
+64	val_64	2008-04-08	11
+468	val_468	2008-04-08	11
+76	val_76	2008-04-08	11
+74	val_74	2008-04-08	11
+342	val_342	2008-04-08	11
+69	val_69	2008-04-08	11
+230	val_230	2008-04-08	11
+33	val_33	2008-04-08	11
+368	val_368	2008-04-08	11
+103	val_103	2008-04-08	11
+296	val_296	2008-04-08	11
+113	val_113	2008-04-08	11
+216	val_216	2008-04-08	11
+367	val_367	2008-04-08	11
+344	val_344	2008-04-08	11
+167	val_167	2008-04-08	11
+274	val_274	2008-04-08	11
+219	val_219	2008-04-08	11
+239	val_239	2008-04-08	11
+485	val_485	2008-04-08	11
+116	val_116	2008-04-08	11
+223	val_223	2008-04-08	11
+256	val_256	2008-04-08	11
+263	val_263	2008-04-08	11
+70	val_70	2008-04-08	11
+487	val_487	2008-04-08	11
+480	val_480	2008-04-08	11
+401	val_401	2008-04-08	11
+288	val_288	2008-04-08	11
+191	val_191	2008-04-08	11
+5	val_5	2008-04-08	11
+244	val_244	2008-04-08	11
+438	val_438	2008-04-08	11
+128	val_128	2008-04-08	11
+467	val_467	2008-04-08	11
+432	val_432	2008-04-08	11
+202	val_202	2008-04-08	11
+316	val_316	2008-04-08	11
+229	val_229	2008-04-08	11
+469	val_469	2008-04-08	11
+463	val_463	2008-04-08	11
+280	val_280	2008-04-08	11
+2	val_2	2008-04-08	11
+35	val_35	2008-04-08	11
+283	val_283	2008-04-08	11
+331	val_331	2008-04-08	11
+235	val_235	2008-04-08	11
+80	val_80	2008-04-08	11
+44	val_44	2008-04-08	11
+193	val_193	2008-04-08	11
+321	val_321	2008-04-08	11
+335	val_335	2008-04-08	11
+104	val_104	2008-04-08	11
+466	val_466	2008-04-08	11
+366	val_366	2008-04-08	11
+175	val_175	2008-04-08	11
+403	val_403	2008-04-08	11
+483	val_483	2008-04-08	11
+53	val_53	2008-04-08	11
+105	val_105	2008-04-08	11
+257	val_257	2008-04-08	11
+406	val_406	2008-04-08	11
+409	val_409	2008-04-08	11
+190	val_190	2008-04-08	11
+406	val_406	2008-04-08	11
+401	val_401	2008-04-08	11
+114	val_114	2008-04-08	11
+258	val_258	2008-04-08	11
+90	val_90	2008-04-08	11
+203	val_203	2008-04-08	11
+262	val_262	2008-04-08	11
+348	val_348	2008-04-08	11
+424	val_424	2008-04-08	11
+12	val_12	2008-04-08	11
+396	val_396	2008-04-08	11
+201	val_201	2008-04-08	11
+217	val_217	2008-04-08	11
+164	val_164	2008-04-08	11
+431	val_431	2008-04-08	11
+454	val_454	2008-04-08	11
+478	val_478	2008-04-08	11
+298	val_298	2008-04-08	11
+125	val_125	2008-04-08	11
+431	val_431	2008-04-08	11
+164	val_164	2008-04-08	11
+424	val_424	2008-04-08	11
+187	val_187	2008-04-08	11
+382	val_382	2008-04-08	11
+5	val_5	2008-04-08	11
+70	val_70	2008-04-08	11
+397	val_397	2008-04-08	11
+480	val_480	2008-04-08	11
+291	val_291	2008-04-08	11
+24	val_24	2008-04-08	11
+351	val_351	2008-04-08	11
+255	val_255	2008-04-08	11
+104	val_104	2008-04-08	11
+70	val_70	2008-04-08	11
+163	val_163	2008-04-08	11
+438	val_438	2008-04-08	11
+119	val_119	2008-04-08	11
+414	val_414	2008-04-08	11
+200	val_200	2008-04-08	11
+491	val_491	2008-04-08	11
+237	val_237	2008-04-08	11
+439	val_439	2008-04-08	11
+360	val_360	2008-04-08	11
+248	val_248	2008-04-08	11
+479	val_479	2008-04-08	11
+305	val_305	2008-04-08	11
+417	val_417	2008-04-08	11
+199	val_199	2008-04-08	11
+444	val_444	2008-04-08	11
+120	val_120	2008-04-08	11
+429	val_429	2008-04-08	11
+169	val_169	2008-04-08	11
+443	val_443	2008-04-08	11
+323	val_323	2008-04-08	11
+325	val_325	2008-04-08	11
+277	val_277	2008-04-08	11
+230	val_230	2008-04-08	11
+478	val_478	2008-04-08	11
+178	val_178	2008-04-08	11
+468	val_468	2008-04-08	11
+310	val_310	2008-04-08	11
+317	val_317	2008-04-08	11
+333	val_333	2008-04-08	11
+493	val_493	2008-04-08	11
+460	val_460	2008-04-08	11
+207	val_207	2008-04-08	11
+249	val_249	2008-04-08	11
+265	val_265	2008-04-08	11
+480	val_480	2008-04-08	11
+83	val_83	2008-04-08	11
+136	val_136	2008-04-08	11
+353	val_353	2008-04-08	11
+172	val_172	2008-04-08	11
+214	val_214	2008-04-08	11
+462	val_462	2008-04-08	11
+233	val_233	2008-04-08	11
+406	val_406	2008-04-08	11
+133	val_133	2008-04-08	11
+175	val_175	2008-04-08	11
+189	val_189	2008-04-08	11
+454	val_454	2008-04-08	11
+375	val_375	2008-04-08	11
+401	val_401	2008-04-08	11
+421	val_421	2008-04-08	11
+407	val_407	2008-04-08	11
+384	val_384	2008-04-08	11
+256	val_256	2008-04-08	11
+26	val_26	2008-04-08	11
+134	val_134	2008-04-08	11
+67	val_67	2008-04-08	11
+384	val_384	2008-04-08	11
+379	val_379	2008-04-08	11
+18	val_18	2008-04-08	11
+462	val_462	2008-04-08	11
+492	val_492	2008-04-08	11
+100	val_100	2008-04-08	11
+298	val_298	2008-04-08	11
+9	val_9	2008-04-08	11
+341	val_341	2008-04-08	11
+498	val_498	2008-04-08	11
+146	val_146	2008-04-08	11
+458	val_458	2008-04-08	11
+362	val_362	2008-04-08	11
+186	val_186	2008-04-08	11
+285	val_285	2008-04-08	11
+348	val_348	2008-04-08	11
+167	val_167	2008-04-08	11
+18	val_18	2008-04-08	11
+273	val_273	2008-04-08	11
+183	val_183	2008-04-08	11
+281	val_281	2008-04-08	11
+344	val_344	2008-04-08	11
+97	val_97	2008-04-08	11
+469	val_469	2008-04-08	11
+315	val_315	2008-04-08	11
+84	val_84	2008-04-08	11
+28	val_28	2008-04-08	11
+37	val_37	2008-04-08	11
+448	val_448	2008-04-08	11
+152	val_152	2008-04-08	11
+348	val_348	2008-04-08	11
+307	val_307	2008-04-08	11
+194	val_194	2008-04-08	11
+414	val_414	2008-04-08	11
+477	val_477	2008-04-08	11
+222	val_222	2008-04-08	11
+126	val_126	2008-04-08	11
+90	val_90	2008-04-08	11
+169	val_169	2008-04-08	11
+403	val_403	2008-04-08	11
+400	val_400	2008-04-08	11
+200	val_200	2008-04-08	11
+97	val_97	2008-04-08	11
+238	val_238	2008-04-08	12
+86	val_86	2008-04-08	12
+311	val_311	2008-04-08	12
+27	val_27	2008-04-08	12
+165	val_165	2008-04-08	12
+409	val_409	2008-04-08	12
+255	val_255	2008-04-08	12
+278	val_278	2008-04-08	12
+98	val_98	2008-04-08	12
+484	val_484	2008-04-08	12
+265	val_265	2008-04-08	12
+193	val_193	2008-04-08	12
+401	val_401	2008-04-08	12
+150	val_150	2008-04-08	12
+273	val_273	2008-04-08	12
+224	val_224	2008-04-08	12
+369	val_369	2008-04-08	12
+66	val_66	2008-04-08	12
+128	val_128	2008-04-08	12
+213	val_213	2008-04-08	12
+146	val_146	2008-04-08	12
+406	val_406	2008-04-08	12
+429	val_429	2008-04-08	12
+374	val_374	2008-04-08	12
+152	val_152	2008-04-08	12
+469	val_469	2008-04-08	12
+145	val_145	2008-04-08	12
+495	val_495	2008-04-08	12
+37	val_37	2008-04-08	12
+327	val_327	2008-04-08	12
+281	val_281	2008-04-08	12
+277	val_277	2008-04-08	12
+209	val_209	2008-04-08	12
+15	val_15	2008-04-08	12
+82	val_82	2008-04-08	12
+403	val_403	2008-04-08	12
+166	val_166	2008-04-08	12
+417	val_417	2008-04-08	12
+430	val_430	2008-04-08	12
+252	val_252	2008-04-08	12
+292	val_292	2008-04-08	12
+219	val_219	2008-04-08	12
+287	val_287	2008-04-08	12
+153	val_153	2008-04-08	12
+193	val_193	2008-04-08	12
+338	val_338	2008-04-08	12
+446	val_446	2008-04-08	12
+459	val_459	2008-04-08	12
+394	val_394	2008-04-08	12
+237	val_237	2008-04-08	12
+482	val_482	2008-04-08	12
+174	val_174	2008-04-08	12
+413	val_413	2008-04-08	12
+494	val_494	2008-04-08	12
+207	val_207	2008-04-08	12
+199	val_199	2008-04-08	12
+466	val_466	2008-04-08	12
+208	val_208	2008-04-08	12
+174	val_174	2008-04-08	12
+399	val_399	2008-04-08	12
+396	val_396	2008-04-08	12
+247	val_247	2008-04-08	12
+417	val_417	2008-04-08	12
+489	val_489	2008-04-08	12
+162	val_162	2008-04-08	12
+377	val_377	2008-04-08	12
+397	val_397	2008-04-08	12
+309	val_309	2008-04-08	12
+365	val_365	2008-04-08	12
+266	val_266	2008-04-08	12
+439	val_439	2008-04-08	12
+342	val_342	2008-04-08	12
+367	val_367	2008-04-08	12
+325	val_325	2008-04-08	12
+167	val_167	2008-04-08	12
+195	val_195	2008-04-08	12
+475	val_475	2008-04-08	12
+17	val_17	2008-04-08	12
+113	val_113	2008-04-08	12
+155	val_155	2008-04-08	12
+203	val_203	2008-04-08	12
+339	val_339	2008-04-08	12
+0	val_0	2008-04-08	12
+455	val_455	2008-04-08	12
+128	val_128	2008-04-08	12
+311	val_311	2008-04-08	12
+316	val_316	2008-04-08	12
+57	val_57	2008-04-08	12
+302	val_302	2008-04-08	12
+205	val_205	2008-04-08	12
+149	val_149	2008-04-08	12
+438	val_438	2008-04-08	12
+345	val_345	2008-04-08	12
+129	val_129	2008-04-08	12
+170	val_170	2008-04-08	12
+20	val_20	2008-04-08	12
+489	val_489	2008-04-08	12
+157	val_157	2008-04-08	12
+378	val_378	2008-04-08	12
+221	val_221	2008-04-08	12
+92	val_92	2008-04-08	12
+111	val_111	2008-04-08	12
+47	val_47	2008-04-08	12
+72	val_72	2008-04-08	12
+4	val_4	2008-04-08	12
+280	val_280	2008-04-08	12
+35	val_35	2008-04-08	12
+427	val_427	2008-04-08	12
+277	val_277	2008-04-08	12
+208	val_208	2008-04-08	12
+356	val_356	2008-04-08	12
+399	val_399	2008-04-08	12
+169	val_169	2008-04-08	12
+382	val_382	2008-04-08	12
+498	val_498	2008-04-08	12
+125	val_125	2008-04-08	12
+386	val_386	2008-04-08	12
+437	val_437	2008-04-08	12
+469	val_469	2008-04-08	12
+192	val_192	2008-04-08	12
+286	val_286	2008-04-08	12
+187	val_187	2008-04-08	12
+176	val_176	2008-04-08	12
+54	val_54	2008-04-08	12
+459	val_459	2008-04-08	12
+51	val_51	2008-04-08	12
+138	val_138	2008-04-08	12
+103	val_103	2008-04-08	12
+239	val_239	2008-04-08	12
+213	val_213	2008-04-08	12
+216	val_216	2008-04-08	12
+430	val_430	2008-04-08	12
+278	val_278	2008-04-08	12
+176	val_176	2008-04-08	12
+289	val_289	2008-04-08	12
+221	val_221	2008-04-08	12
+65	val_65	2008-04-08	12
+318	val_318	2008-04-08	12
+332	val_332	2008-04-08	12
+311	val_311	2008-04-08	12
+275	val_275	2008-04-08	12
+137	val_137	2008-04-08	12
+241	val_241	2008-04-08	12
+83	val_83	2008-04-08	12
+333	val_333	2008-04-08	12
+180	val_180	2008-04-08	12
+284	val_284	2008-04-08	12
+12	val_12	2008-04-08	12
+230	val_230	2008-04-08	12
+181	val_181	2008-04-08	12
+67	val_67	2008-04-08	12
+260	val_260	2008-04-08	12
+404	val_404	2008-04-08	12
+384	val_384	2008-04-08	12
+489	val_489	2008-04-08	12
+353	val_353	2008-04-08	12
+373	val_373	2008-04-08	12
+272	val_272	2008-04-08	12
+138	val_138	2008-04-08	12
+217	val_217	2008-04-08	12
+84	val_84	2008-04-08	12
+348	val_348	2008-04-08	12
+466	val_466	2008-04-08	12
+58	val_58	2008-04-08	12
+8	val_8	2008-04-08	12
+411	val_411	2008-04-08	12
+230	val_230	2008-04-08	12
+208	val_208	2008-04-08	12
+348	val_348	2008-04-08	12
+24	val_24	2008-04-08	12
+463	val_463	2008-04-08	12
+431	val_431	2008-04-08	12
+179	val_179	2008-04-08	12
+172	val_172	2008-04-08	12
+42	val_42	2008-04-08	12
+129	val_129	2008-04-08	12
+158	val_158	2008-04-08	12
+119	val_119	2008-04-08	12
+496	val_496	2008-04-08	12
+0	val_0	2008-04-08	12
+322	val_322	2008-04-08	12
+197	val_197	2008-04-08	12
+468	val_468	2008-04-08	12
+393	val_393	2008-04-08	12
+454	val_454	2008-04-08	12
+100	val_100	2008-04-08	12
+298	val_298	2008-04-08	12
+199	val_199	2008-04-08	12
+191	val_191	2008-04-08	12
+418	val_418	2008-04-08	12
+96	val_96	2008-04-08	12
+26	val_26	2008-04-08	12
+165	val_165	2008-04-08	12
+327	val_327	2008-04-08	12
+230	val_230	2008-04-08	12
+205	val_205	2008-04-08	12
+120	val_120	2008-04-08	12
+131	val_131	2008-04-08	12
+51	val_51	2008-04-08	12
+404	val_404	2008-04-08	12
+43	val_43	2008-04-08	12
+436	val_436	2008-04-08	12
+156	val_156	2008-04-08	12
+469	val_469	2008-04-08	12
+468	val_468	2008-04-08	12
+308	val_308	2008-04-08	12
+95	val_95	2008-04-08	12
+196	val_196	2008-04-08	12
+288	val_288	2008-04-08	12
+481	val_481	2008-04-08	12
+457	val_457	2008-04-08	12
+98	val_98	2008-04-08	12
+282	val_282	2008-04-08	12
+197	val_197	2008-04-08	12
+187	val_187	2008-04-08	12
+318	val_318	2008-04-08	12
+318	val_318	2008-04-08	12
+409	val_409	2008-04-08	12
+470	val_470	2008-04-08	12
+137	val_137	2008-04-08	12
+369	val_369	2008-04-08	12
+316	val_316	2008-04-08	12
+169	val_169	2008-04-08	12
+413	val_413	2008-04-08	12
+85	val_85	2008-04-08	12
+77	val_77	2008-04-08	12
+0	val_0	2008-04-08	12
+490	val_490	2008-04-08	12
+87	val_87	2008-04-08	12
+364	val_364	2008-04-08	12
+179	val_179	2008-04-08	12
+118	val_118	2008-04-08	12
+134	val_134	2008-04-08	12
+395	val_395	2008-04-08	12
+282	val_282	2008-04-08	12
+138	val_138	2008-04-08	12
+238	val_238	2008-04-08	12
+419	val_419	2008-04-08	12
+15	val_15	2008-04-08	12
+118	val_118	2008-04-08	12
+72	val_72	2008-04-08	12
+90	val_90	2008-04-08	12
+307	val_307	2008-04-08	12
+19	val_19	2008-04-08	12
+435	val_435	2008-04-08	12
+10	val_10	2008-04-08	12
+277	val_277	2008-04-08	12
+273	val_273	2008-04-08	12
+306	val_306	2008-04-08	12
+224	val_224	2008-04-08	12
+309	val_309	2008-04-08	12
+389	val_389	2008-04-08	12
+327	val_327	2008-04-08	12
+242	val_242	2008-04-08	12
+369	val_369	2008-04-08	12
+392	val_392	2008-04-08	12
+272	val_272	2008-04-08	12
+331	val_331	2008-04-08	12
+401	val_401	2008-04-08	12
+242	val_242	2008-04-08	12
+452	val_452	2008-04-08	12
+177	val_177	2008-04-08	12
+226	val_226	2008-04-08	12
+5	val_5	2008-04-08	12
+497	val_497	2008-04-08	12
+402	val_402	2008-04-08	12
+396	val_396	2008-04-08	12
+317	val_317	2008-04-08	12
+395	val_395	2008-04-08	12
+58	val_58	2008-04-08	12
+35	val_35	2008-04-08	12
+336	val_336	2008-04-08	12
+95	val_95	2008-04-08	12
+11	val_11	2008-04-08	12
+168	val_168	2008-04-08	12
+34	val_34	2008-04-08	12
+229	val_229	2008-04-08	12
+233	val_233	2008-04-08	12
+143	val_143	2008-04-08	12
+472	val_472	2008-04-08	12
+322	val_322	2008-04-08	12
+498	val_498	2008-04-08	12
+160	val_160	2008-04-08	12
+195	val_195	2008-04-08	12
+42	val_42	2008-04-08	12
+321	val_321	2008-04-08	12
+430	val_430	2008-04-08	12
+119	val_119	2008-04-08	12
+489	val_489	2008-04-08	12
+458	val_458	2008-04-08	12
+78	val_78	2008-04-08	12
+76	val_76	2008-04-08	12
+41	val_41	2008-04-08	12
+223	val_223	2008-04-08	12
+492	val_492	2008-04-08	12
+149	val_149	2008-04-08	12
+449	val_449	2008-04-08	12
+218	val_218	2008-04-08	12
+228	val_228	2008-04-08	12
+138	val_138	2008-04-08	12
+453	val_453	2008-04-08	12
+30	val_30	2008-04-08	12
+209	val_209	2008-04-08	12
+64	val_64	2008-04-08	12
+468	val_468	2008-04-08	12
+76	val_76	2008-04-08	12
+74	val_74	2008-04-08	12
+342	val_342	2008-04-08	12
+69	val_69	2008-04-08	12
+230	val_230	2008-04-08	12
+33	val_33	2008-04-08	12
+368	val_368	2008-04-08	12
+103	val_103	2008-04-08	12
+296	val_296	2008-04-08	12
+113	val_113	2008-04-08	12
+216	val_216	2008-04-08	12
+367	val_367	2008-04-08	12
+344	val_344	2008-04-08	12
+167	val_167	2008-04-08	12
+274	val_274	2008-04-08	12
+219	val_219	2008-04-08	12
+239	val_239	2008-04-08	12
+485	val_485	2008-04-08	12
+116	val_116	2008-04-08	12
+223	val_223	2008-04-08	12
+256	val_256	2008-04-08	12
+263	val_263	2008-04-08	12
+70	val_70	2008-04-08	12
+487	val_487	2008-04-08	12
+480	val_480	2008-04-08	12
+401	val_401	2008-04-08	12
+288	val_288	2008-04-08	12
+191	val_191	2008-04-08	12
+5	val_5	2008-04-08	12
+244	val_244	2008-04-08	12
+438	val_438	2008-04-08	12
+128	val_128	2008-04-08	12
+467	val_467	2008-04-08	12
+432	val_432	2008-04-08	12
+202	val_202	2008-04-08	12
+316	val_316	2008-04-08	12
+229	val_229	2008-04-08	12
+469	val_469	2008-04-08	12
+463	val_463	2008-04-08	12
+280	val_280	2008-04-08	12
+2	val_2	2008-04-08	12
+35	val_35	2008-04-08	12
+283	val_283	2008-04-08	12
+331	val_331	2008-04-08	12
+235	val_235	2008-04-08	12
+80	val_80	2008-04-08	12
+44	val_44	2008-04-08	12
+193	val_193	2008-04-08	12
+321	val_321	2008-04-08	12
+335	val_335	2008-04-08	12
+104	val_104	2008-04-08	12
+466	val_466	2008-04-08	12
+366	val_366	2008-04-08	12
+175	val_175	2008-04-08	12
+403	val_403	2008-04-08	12
+483	val_483	2008-04-08	12
+53	val_53	2008-04-08	12
+105	val_105	2008-04-08	12
+257	val_257	2008-04-08	12
+406	val_406	2008-04-08	12
+409	val_409	2008-04-08	12
+190	val_190	2008-04-08	12
+406	val_406	2008-04-08	12
+401	val_401	2008-04-08	12
+114	val_114	2008-04-08	12
+258	val_258	2008-04-08	12
+90	val_90	2008-04-08	12
+203	val_203	2008-04-08	12
+262	val_262	2008-04-08	12
+348	val_348	2008-04-08	12
+424	val_424	2008-04-08	12
+12	val_12	2008-04-08	12
+396	val_396	2008-04-08	12
+201	val_201	2008-04-08	12
+217	val_217	2008-04-08	12
+164	val_164	2008-04-08	12
+431	val_431	2008-04-08	12
+454	val_454	2008-04-08	12
+478	val_478	2008-04-08	12
+298	val_298	2008-04-08	12
+125	val_125	2008-04-08	12
+431	val_431	2008-04-08	12
+164	val_164	2008-04-08	12
+424	val_424	2008-04-08	12
+187	val_187	2008-04-08	12
+382	val_382	2008-04-08	12
+5	val_5	2008-04-08	12
+70	val_70	2008-04-08	12
+397	val_397	2008-04-08	12
+480	val_480	2008-04-08	12
+291	val_291	2008-04-08	12
+24	val_24	2008-04-08	12
+351	val_351	2008-04-08	12
+255	val_255	2008-04-08	12
+104	val_104	2008-04-08	12
+70	val_70	2008-04-08	12
+163	val_163	2008-04-08	12
+438	val_438	2008-04-08	12
+119	val_119	2008-04-08	12
+414	val_414	2008-04-08	12
+200	val_200	2008-04-08	12
+491	val_491	2008-04-08	12
+237	val_237	2008-04-08	12
+439	val_439	2008-04-08	12
+360	val_360	2008-04-08	12
+248	val_248	2008-04-08	12
+479	val_479	2008-04-08	12
+305	val_305	2008-04-08	12
+417	val_417	2008-04-08	12
+199	val_199	2008-04-08	12
+444	val_444	2008-04-08	12
+120	val_120	2008-04-08	12
+429	val_429	2008-04-08	12
+169	val_169	2008-04-08	12
+443	val_443	2008-04-08	12
+323	val_323	2008-04-08	12
+325	val_325	2008-04-08	12
+277	val_277	2008-04-08	12
+230	val_230	2008-04-08	12
+478	val_478	2008-04-08	12
+178	val_178	2008-04-08	12
+468	val_468	2008-04-08	12
+310	val_310	2008-04-08	12
+317	val_317	2008-04-08	12
+333	val_333	2008-04-08	12
+493	val_493	2008-04-08	12
+460	val_460	2008-04-08	12
+207	val_207	2008-04-08	12
+249	val_249	2008-04-08	12
+265	val_265	2008-04-08	12
+480	val_480	2008-04-08	12
+83	val_83	2008-04-08	12
+136	val_136	2008-04-08	12
+353	val_353	2008-04-08	12
+172	val_172	2008-04-08	12
+214	val_214	2008-04-08	12
+462	val_462	2008-04-08	12
+233	val_233	2008-04-08	12
+406	val_406	2008-04-08	12
+133	val_133	2008-04-08	12
+175	val_175	2008-04-08	12
+189	val_189	2008-04-08	12
+454	val_454	2008-04-08	12
+375	val_375	2008-04-08	12
+401	val_401	2008-04-08	12
+421	val_421	2008-04-08	12
+407	val_407	2008-04-08	12
+384	val_384	2008-04-08	12
+256	val_256	2008-04-08	12
+26	val_26	2008-04-08	12
+134	val_134	2008-04-08	12
+67	val_67	2008-04-08	12
+384	val_384	2008-04-08	12
+379	val_379	2008-04-08	12
+18	val_18	2008-04-08	12
+462	val_462	2008-04-08	12
+492	val_492	2008-04-08	12
+100	val_100	2008-04-08	12
+298	val_298	2008-04-08	12
+9	val_9	2008-04-08	12
+341	val_341	2008-04-08	12
+498	val_498	2008-04-08	12
+146	val_146	2008-04-08	12
+458	val_458	2008-04-08	12
+362	val_362	2008-04-08	12
+186	val_186	2008-04-08	12
+285	val_285	2008-04-08	12
+348	val_348	2008-04-08	12
+167	val_167	2008-04-08	12
+18	val_18	2008-04-08	12
+273	val_273	2008-04-08	12
+183	val_183	2008-04-08	12
+281	val_281	2008-04-08	12
+344	val_344	2008-04-08	12
+97	val_97	2008-04-08	12
+469	val_469	2008-04-08	12
+315	val_315	2008-04-08	12
+84	val_84	2008-04-08	12
+28	val_28	2008-04-08	12
+37	val_37	2008-04-08	12
+448	val_448	2008-04-08	12
+152	val_152	2008-04-08	12
+348	val_348	2008-04-08	12
+307	val_307	2008-04-08	12
+194	val_194	2008-04-08	12
+414	val_414	2008-04-08	12
+477	val_477	2008-04-08	12
+222	val_222	2008-04-08	12
+126	val_126	2008-04-08	12
+90	val_90	2008-04-08	12
+169	val_169	2008-04-08	12
+403	val_403	2008-04-08	12
+400	val_400	2008-04-08	12
+200	val_200	2008-04-08	12
+97	val_97	2008-04-08	12
+PREHOOK: query: drop table nzhang_part9
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table nzhang_part9
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Output: default@nzhang_part9
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
+POSTHOOK: Lineage: nzhang_part9 PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]

Modified: hadoop/hive/trunk/ql/src/test/results/compiler/plan/case_sensitivity.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/compiler/plan/case_sensitivity.q.xml?rev=934241&r1=934240&r2=934241&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/compiler/plan/case_sensitivity.q.xml (original)
+++ hadoop/hive/trunk/ql/src/test/results/compiler/plan/case_sensitivity.q.xml Wed Apr 14 23:36:07 2010
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8"?> 
-<java version="1.6.0_17" class="java.beans.XMLDecoder"> 
+<java version="1.6.0_14" class="java.beans.XMLDecoder"> 
  <object id="MapRedTask0" class="org.apache.hadoop.hive.ql.exec.MapRedTask"> 
   <void property="childTasks"> 
    <object class="java.util.ArrayList"> 
@@ -41,7 +41,7 @@
                     <void property="aliasToWork"> 
                      <object class="java.util.LinkedHashMap"> 
                       <void method="put"> 
-                       <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-17_798_2050344255230359696/10002</string> 
+                       <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-03_089_4302759693961110632/10002</string> 
                        <object id="TableScanOperator0" class="org.apache.hadoop.hive.ql.exec.TableScanOperator"> 
                         <void property="childOperators"> 
                          <object class="java.util.ArrayList"> 
@@ -286,10 +286,10 @@
                     <void property="pathToAliases"> 
                      <object class="java.util.LinkedHashMap"> 
                       <void method="put"> 
-                       <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-17_798_2050344255230359696/10002</string> 
+                       <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-03_089_4302759693961110632/10002</string> 
                        <object class="java.util.ArrayList"> 
                         <void method="add"> 
-                         <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-17_798_2050344255230359696/10002</string> 
+                         <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-03_089_4302759693961110632/10002</string> 
                         </void> 
                        </object> 
                       </void> 
@@ -298,7 +298,7 @@
                     <void property="pathToPartitionInfo"> 
                      <object class="java.util.LinkedHashMap"> 
                       <void method="put"> 
-                       <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-17_798_2050344255230359696/10002</string> 
+                       <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-03_089_4302759693961110632/10002</string> 
                        <object class="org.apache.hadoop.hive.ql.plan.PartitionDesc"> 
                         <void property="baseFileName"> 
                          <string>10002</string> 
@@ -352,11 +352,11 @@
                           </void> 
                           <void method="put"> 
                            <string>location</string> 
-                           <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1</string> 
+                           <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/dest1</string> 
                           </void> 
                           <void method="put"> 
                            <string>transient_lastDdlTime</string> 
-                           <string>1268858177</string> 
+                           <string>1269980282</string> 
                           </void> 
                          </object> 
                         </void> 
@@ -395,7 +395,7 @@
                           <void property="conf"> 
                            <object class="org.apache.hadoop.hive.ql.plan.FileSinkDesc"> 
                             <void property="dirName"> 
-                             <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-17_798_2050344255230359696/10000</string> 
+                             <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-03_089_4302759693961110632/10000</string> 
                             </void> 
                             <void property="numFiles"> 
                              <int>1</int> 
@@ -447,7 +447,7 @@
                                 </void> 
                                 <void method="put"> 
                                  <string>location</string> 
-                                 <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1</string> 
+                                 <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/dest1</string> 
                                 </void> 
                                 <void method="put"> 
                                  <string>file.outputformat</string> 
@@ -455,7 +455,7 @@
                                 </void> 
                                 <void method="put"> 
                                  <string>transient_lastDdlTime</string> 
-                                 <string>1268858177</string> 
+                                 <string>1269980282</string> 
                                 </void> 
                                </object> 
                               </void> 
@@ -590,19 +590,19 @@
                 <void property="loadTableWork"> 
                  <object class="org.apache.hadoop.hive.ql.plan.LoadTableDesc"> 
                   <void property="partitionSpec"> 
-                   <object class="java.util.HashMap"/> 
+                   <object class="java.util.LinkedHashMap"/> 
                   </void> 
                   <void property="replace"> 
                    <boolean>true</boolean> 
                   </void> 
                   <void property="sourceDir"> 
-                   <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-17_798_2050344255230359696/10000</string> 
+                   <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-03_089_4302759693961110632/10000</string> 
                   </void> 
                   <void property="table"> 
                    <object idref="TableDesc2"/> 
                   </void> 
                   <void property="tmpDir"> 
-                   <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-17_798_2050344255230359696/10001</string> 
+                   <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-03_089_4302759693961110632/10001</string> 
                   </void> 
                  </object> 
                 </void> 
@@ -623,10 +623,10 @@
                <boolean>true</boolean> 
               </void> 
               <void property="sourceDir"> 
-               <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-17_798_2050344255230359696/10002</string> 
+               <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-03_089_4302759693961110632/10002</string> 
               </void> 
               <void property="targetDir"> 
-               <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-17_798_2050344255230359696/10000</string> 
+               <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-03_089_4302759693961110632/10000</string> 
               </void> 
              </object> 
             </void> 
@@ -652,7 +652,7 @@
       <void property="resolverCtx"> 
        <object class="org.apache.hadoop.hive.ql.plan.ConditionalResolverMergeFiles$ConditionalResolverMergeFilesCtx"> 
         <void property="dir"> 
-         <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-17_798_2050344255230359696/10002</string> 
+         <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-03_089_4302759693961110632/10002</string> 
         </void> 
         <void property="listTasks"> 
          <object idref="ArrayList0"/> 
@@ -742,11 +742,11 @@
          </void> 
          <void method="put"> 
           <string>location</string> 
-          <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src_thrift</string> 
+          <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/src_thrift</string> 
          </void> 
          <void method="put"> 
           <string>transient_lastDdlTime</string> 
-          <string>1268858176</string> 
+          <string>1269980282</string> 
          </void> 
         </object> 
        </void> 
@@ -802,7 +802,7 @@
                            <int>1</int> 
                           </void> 
                           <void property="dirName"> 
-                           <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-17_798_2050344255230359696/10002</string> 
+                           <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-03_089_4302759693961110632/10002</string> 
                           </void> 
                           <void property="numFiles"> 
                            <int>1</int> 
@@ -1415,7 +1415,7 @@
     <void property="pathToAliases"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src_thrift</string> 
+       <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/src_thrift</string> 
        <object class="java.util.ArrayList"> 
         <void method="add"> 
          <string>src_thrift</string> 
@@ -1427,7 +1427,7 @@
     <void property="pathToPartitionInfo"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src_thrift</string> 
+       <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/src_thrift</string> 
        <object class="org.apache.hadoop.hive.ql.plan.PartitionDesc"> 
         <void property="baseFileName"> 
          <string>src_thrift</string> 
@@ -1488,11 +1488,11 @@
           </void> 
           <void method="put"> 
            <string>location</string> 
-           <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src_thrift</string> 
+           <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/src_thrift</string> 
           </void> 
           <void method="put"> 
            <string>transient_lastDdlTime</string> 
-           <string>1268858176</string> 
+           <string>1269980282</string> 
           </void> 
          </object> 
         </void> 

Modified: hadoop/hive/trunk/ql/src/test/results/compiler/plan/groupby1.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/compiler/plan/groupby1.q.xml?rev=934241&r1=934240&r2=934241&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/compiler/plan/groupby1.q.xml (original)
+++ hadoop/hive/trunk/ql/src/test/results/compiler/plan/groupby1.q.xml Wed Apr 14 23:36:07 2010
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8"?> 
-<java version="1.6.0_07" class="java.beans.XMLDecoder"> 
+<java version="1.6.0_14" class="java.beans.XMLDecoder"> 
  <object id="MapRedTask0" class="org.apache.hadoop.hive.ql.exec.MapRedTask"> 
   <void property="childTasks"> 
    <object class="java.util.ArrayList"> 
@@ -20,13 +20,13 @@
         <void property="loadTableWork"> 
          <object class="org.apache.hadoop.hive.ql.plan.LoadTableDesc"> 
           <void property="partitionSpec"> 
-           <object class="java.util.HashMap"/> 
+           <object class="java.util.LinkedHashMap"/> 
           </void> 
           <void property="replace"> 
            <boolean>true</boolean> 
           </void> 
           <void property="sourceDir"> 
-           <string>file:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-02-17_17-17-34_222_3384493340844184246/10000</string> 
+           <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-10_516_4874157256531334774/10000</string> 
           </void> 
           <void property="table"> 
            <object id="TableDesc0" class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
@@ -79,11 +79,11 @@
               </void> 
               <void method="put"> 
                <string>location</string> 
-               <string>file:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/dest1</string> 
+               <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/dest1</string> 
               </void> 
               <void method="put"> 
                <string>transient_lastDdlTime</string> 
-               <string>1266455854</string> 
+               <string>1269980290</string> 
               </void> 
              </object> 
             </void> 
@@ -93,7 +93,7 @@
            </object> 
           </void> 
           <void property="tmpDir"> 
-           <string>file:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-02-17_17-17-34_222_3384493340844184246/10001</string> 
+           <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-10_516_4874157256531334774/10001</string> 
           </void> 
          </object> 
         </void> 
@@ -164,11 +164,11 @@
          </void> 
          <void method="put"> 
           <string>location</string> 
-          <string>file:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/src</string> 
+          <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/src</string> 
          </void> 
          <void method="put"> 
           <string>transient_lastDdlTime</string> 
-          <string>1266455853</string> 
+          <string>1269980289</string> 
          </void> 
         </object> 
        </void> 
@@ -741,7 +741,7 @@
     <void property="pathToAliases"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/src</string> 
+       <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/src</string> 
        <object class="java.util.ArrayList"> 
         <void method="add"> 
          <string>src</string> 
@@ -753,7 +753,7 @@
     <void property="pathToPartitionInfo"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/src</string> 
+       <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/src</string> 
        <object class="org.apache.hadoop.hive.ql.plan.PartitionDesc"> 
         <void property="baseFileName"> 
          <string>src</string> 
@@ -810,11 +810,11 @@
           </void> 
           <void method="put"> 
            <string>location</string> 
-           <string>file:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/src</string> 
+           <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/src</string> 
           </void> 
           <void method="put"> 
            <string>transient_lastDdlTime</string> 
-           <string>1266455853</string> 
+           <string>1269980289</string> 
           </void> 
          </object> 
         </void> 
@@ -860,7 +860,7 @@
                  <int>1</int> 
                 </void> 
                 <void property="dirName"> 
-                 <string>file:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-02-17_17-17-34_222_3384493340844184246/10000</string> 
+                 <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-10_516_4874157256531334774/10000</string> 
                 </void> 
                 <void property="numFiles"> 
                  <int>1</int> 

Modified: hadoop/hive/trunk/ql/src/test/results/compiler/plan/input1.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/compiler/plan/input1.q.xml?rev=934241&r1=934240&r2=934241&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/compiler/plan/input1.q.xml (original)
+++ hadoop/hive/trunk/ql/src/test/results/compiler/plan/input1.q.xml Wed Apr 14 23:36:07 2010
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8"?> 
-<java version="1.6.0_17" class="java.beans.XMLDecoder"> 
+<java version="1.6.0_14" class="java.beans.XMLDecoder"> 
  <object id="MapRedTask0" class="org.apache.hadoop.hive.ql.exec.MapRedTask"> 
   <void property="childTasks"> 
    <object class="java.util.ArrayList"> 
@@ -41,7 +41,7 @@
                     <void property="aliasToWork"> 
                      <object class="java.util.LinkedHashMap"> 
                       <void method="put"> 
-                       <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-41_887_8284459572818506365/10002</string> 
+                       <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-26_782_8000254486605037992/10002</string> 
                        <object id="TableScanOperator0" class="org.apache.hadoop.hive.ql.exec.TableScanOperator"> 
                         <void property="childOperators"> 
                          <object class="java.util.ArrayList"> 
@@ -286,10 +286,10 @@
                     <void property="pathToAliases"> 
                      <object class="java.util.LinkedHashMap"> 
                       <void method="put"> 
-                       <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-41_887_8284459572818506365/10002</string> 
+                       <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-26_782_8000254486605037992/10002</string> 
                        <object class="java.util.ArrayList"> 
                         <void method="add"> 
-                         <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-41_887_8284459572818506365/10002</string> 
+                         <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-26_782_8000254486605037992/10002</string> 
                         </void> 
                        </object> 
                       </void> 
@@ -298,7 +298,7 @@
                     <void property="pathToPartitionInfo"> 
                      <object class="java.util.LinkedHashMap"> 
                       <void method="put"> 
-                       <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-41_887_8284459572818506365/10002</string> 
+                       <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-26_782_8000254486605037992/10002</string> 
                        <object class="org.apache.hadoop.hive.ql.plan.PartitionDesc"> 
                         <void property="baseFileName"> 
                          <string>10002</string> 
@@ -352,11 +352,11 @@
                           </void> 
                           <void method="put"> 
                            <string>location</string> 
-                           <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1</string> 
+                           <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/dest1</string> 
                           </void> 
                           <void method="put"> 
                            <string>transient_lastDdlTime</string> 
-                           <string>1268858201</string> 
+                           <string>1269980306</string> 
                           </void> 
                          </object> 
                         </void> 
@@ -395,7 +395,7 @@
                           <void property="conf"> 
                            <object class="org.apache.hadoop.hive.ql.plan.FileSinkDesc"> 
                             <void property="dirName"> 
-                             <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-41_887_8284459572818506365/10000</string> 
+                             <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-26_782_8000254486605037992/10000</string> 
                             </void> 
                             <void property="numFiles"> 
                              <int>1</int> 
@@ -447,7 +447,7 @@
                                 </void> 
                                 <void method="put"> 
                                  <string>location</string> 
-                                 <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1</string> 
+                                 <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/dest1</string> 
                                 </void> 
                                 <void method="put"> 
                                  <string>file.outputformat</string> 
@@ -455,7 +455,7 @@
                                 </void> 
                                 <void method="put"> 
                                  <string>transient_lastDdlTime</string> 
-                                 <string>1268858201</string> 
+                                 <string>1269980306</string> 
                                 </void> 
                                </object> 
                               </void> 
@@ -586,19 +586,19 @@
                 <void property="loadTableWork"> 
                  <object class="org.apache.hadoop.hive.ql.plan.LoadTableDesc"> 
                   <void property="partitionSpec"> 
-                   <object class="java.util.HashMap"/> 
+                   <object class="java.util.LinkedHashMap"/> 
                   </void> 
                   <void property="replace"> 
                    <boolean>true</boolean> 
                   </void> 
                   <void property="sourceDir"> 
-                   <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-41_887_8284459572818506365/10000</string> 
+                   <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-26_782_8000254486605037992/10000</string> 
                   </void> 
                   <void property="table"> 
                    <object idref="TableDesc2"/> 
                   </void> 
                   <void property="tmpDir"> 
-                   <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-41_887_8284459572818506365/10001</string> 
+                   <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-26_782_8000254486605037992/10001</string> 
                   </void> 
                  </object> 
                 </void> 
@@ -619,10 +619,10 @@
                <boolean>true</boolean> 
               </void> 
               <void property="sourceDir"> 
-               <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-41_887_8284459572818506365/10002</string> 
+               <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-26_782_8000254486605037992/10002</string> 
               </void> 
               <void property="targetDir"> 
-               <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-41_887_8284459572818506365/10000</string> 
+               <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-26_782_8000254486605037992/10000</string> 
               </void> 
              </object> 
             </void> 
@@ -648,7 +648,7 @@
       <void property="resolverCtx"> 
        <object class="org.apache.hadoop.hive.ql.plan.ConditionalResolverMergeFiles$ConditionalResolverMergeFilesCtx"> 
         <void property="dir"> 
-         <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-41_887_8284459572818506365/10002</string> 
+         <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-26_782_8000254486605037992/10002</string> 
         </void> 
         <void property="listTasks"> 
          <object idref="ArrayList0"/> 
@@ -734,11 +734,11 @@
          </void> 
          <void method="put"> 
           <string>location</string> 
-          <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src</string> 
+          <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/src</string> 
          </void> 
          <void method="put"> 
           <string>transient_lastDdlTime</string> 
-          <string>1268858201</string> 
+          <string>1269980306</string> 
          </void> 
         </object> 
        </void> 
@@ -794,7 +794,7 @@
                            <int>1</int> 
                           </void> 
                           <void property="dirName"> 
-                           <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/scratchdir/hive_2010-03-17_13-36-41_887_8284459572818506365/10002</string> 
+                           <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/scratchdir/hive_2010-03-30_13-18-26_782_8000254486605037992/10002</string> 
                           </void> 
                           <void property="numFiles"> 
                            <int>1</int> 
@@ -1216,7 +1216,7 @@
     <void property="pathToAliases"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src</string> 
+       <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/src</string> 
        <object class="java.util.ArrayList"> 
         <void method="add"> 
          <string>src</string> 
@@ -1228,7 +1228,7 @@
     <void property="pathToPartitionInfo"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src</string> 
+       <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/src</string> 
        <object class="org.apache.hadoop.hive.ql.plan.PartitionDesc"> 
         <void property="baseFileName"> 
          <string>src</string> 
@@ -1285,11 +1285,11 @@
           </void> 
           <void method="put"> 
            <string>location</string> 
-           <string>file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src</string> 
+           <string>file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/src</string> 
           </void> 
           <void method="put"> 
            <string>transient_lastDdlTime</string> 
-           <string>1268858201</string> 
+           <string>1269980306</string> 
           </void> 
          </object> 
         </void> 



Mime
View raw message