hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dhr...@apache.org
Subject svn commit: r712905 [9/38] - in /hadoop/core/trunk: ./ src/contrib/hive/ src/contrib/hive/cli/src/java/org/apache/hadoop/hive/cli/ src/contrib/hive/common/src/java/org/apache/hadoop/hive/conf/ src/contrib/hive/conf/ src/contrib/hive/data/files/ src/con...
Date Tue, 11 Nov 2008 01:50:18 GMT
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
             Filter Operator
               predicate:
                   expr: (key < 100)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key
@@ -29,7 +29,7 @@
             Filter Operator
               predicate:
                   expr: ((key >= 100) and (key < 200))
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key
@@ -45,7 +45,7 @@
             Filter Operator
               predicate:
                   expr: (key >= 200)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key
@@ -272,314 +272,314 @@
 194	val_194
 126	val_126
 169	val_169
-238	NULL	2008-04-08	12
-311	NULL	2008-04-08	12
-409	NULL	2008-04-08	12
-255	NULL	2008-04-08	12
-278	NULL	2008-04-08	12
-484	NULL	2008-04-08	12
-265	NULL	2008-04-08	12
-401	NULL	2008-04-08	12
-273	NULL	2008-04-08	12
-224	NULL	2008-04-08	12
-369	NULL	2008-04-08	12
-213	NULL	2008-04-08	12
-406	NULL	2008-04-08	12
-429	NULL	2008-04-08	12
-374	NULL	2008-04-08	12
-469	NULL	2008-04-08	12
-495	NULL	2008-04-08	12
-327	NULL	2008-04-08	12
-281	NULL	2008-04-08	12
-277	NULL	2008-04-08	12
-209	NULL	2008-04-08	12
-403	NULL	2008-04-08	12
-417	NULL	2008-04-08	12
-430	NULL	2008-04-08	12
-252	NULL	2008-04-08	12
-292	NULL	2008-04-08	12
-219	NULL	2008-04-08	12
-287	NULL	2008-04-08	12
-338	NULL	2008-04-08	12
-446	NULL	2008-04-08	12
-459	NULL	2008-04-08	12
-394	NULL	2008-04-08	12
-237	NULL	2008-04-08	12
-482	NULL	2008-04-08	12
-413	NULL	2008-04-08	12
-494	NULL	2008-04-08	12
-207	NULL	2008-04-08	12
-466	NULL	2008-04-08	12
-208	NULL	2008-04-08	12
-399	NULL	2008-04-08	12
-396	NULL	2008-04-08	12
-247	NULL	2008-04-08	12
-417	NULL	2008-04-08	12
-489	NULL	2008-04-08	12
-377	NULL	2008-04-08	12
-397	NULL	2008-04-08	12
-309	NULL	2008-04-08	12
-365	NULL	2008-04-08	12
-266	NULL	2008-04-08	12
-439	NULL	2008-04-08	12
-342	NULL	2008-04-08	12
-367	NULL	2008-04-08	12
-325	NULL	2008-04-08	12
-475	NULL	2008-04-08	12
-203	NULL	2008-04-08	12
-339	NULL	2008-04-08	12
-455	NULL	2008-04-08	12
-311	NULL	2008-04-08	12
-316	NULL	2008-04-08	12
-302	NULL	2008-04-08	12
-205	NULL	2008-04-08	12
-438	NULL	2008-04-08	12
-345	NULL	2008-04-08	12
-489	NULL	2008-04-08	12
-378	NULL	2008-04-08	12
-221	NULL	2008-04-08	12
-280	NULL	2008-04-08	12
-427	NULL	2008-04-08	12
-277	NULL	2008-04-08	12
-208	NULL	2008-04-08	12
-356	NULL	2008-04-08	12
-399	NULL	2008-04-08	12
-382	NULL	2008-04-08	12
-498	NULL	2008-04-08	12
-386	NULL	2008-04-08	12
-437	NULL	2008-04-08	12
-469	NULL	2008-04-08	12
-286	NULL	2008-04-08	12
-459	NULL	2008-04-08	12
-239	NULL	2008-04-08	12
-213	NULL	2008-04-08	12
-216	NULL	2008-04-08	12
-430	NULL	2008-04-08	12
-278	NULL	2008-04-08	12
-289	NULL	2008-04-08	12
-221	NULL	2008-04-08	12
-318	NULL	2008-04-08	12
-332	NULL	2008-04-08	12
-311	NULL	2008-04-08	12
-275	NULL	2008-04-08	12
-241	NULL	2008-04-08	12
-333	NULL	2008-04-08	12
-284	NULL	2008-04-08	12
-230	NULL	2008-04-08	12
-260	NULL	2008-04-08	12
-404	NULL	2008-04-08	12
-384	NULL	2008-04-08	12
-489	NULL	2008-04-08	12
-353	NULL	2008-04-08	12
-373	NULL	2008-04-08	12
-272	NULL	2008-04-08	12
-217	NULL	2008-04-08	12
-348	NULL	2008-04-08	12
-466	NULL	2008-04-08	12
-411	NULL	2008-04-08	12
-230	NULL	2008-04-08	12
-208	NULL	2008-04-08	12
-348	NULL	2008-04-08	12
-463	NULL	2008-04-08	12
-431	NULL	2008-04-08	12
-496	NULL	2008-04-08	12
-322	NULL	2008-04-08	12
-468	NULL	2008-04-08	12
-393	NULL	2008-04-08	12
-454	NULL	2008-04-08	12
-298	NULL	2008-04-08	12
-418	NULL	2008-04-08	12
-327	NULL	2008-04-08	12
-230	NULL	2008-04-08	12
-205	NULL	2008-04-08	12
-404	NULL	2008-04-08	12
-436	NULL	2008-04-08	12
-469	NULL	2008-04-08	12
-468	NULL	2008-04-08	12
-308	NULL	2008-04-08	12
-288	NULL	2008-04-08	12
-481	NULL	2008-04-08	12
-457	NULL	2008-04-08	12
-282	NULL	2008-04-08	12
-318	NULL	2008-04-08	12
-318	NULL	2008-04-08	12
-409	NULL	2008-04-08	12
-470	NULL	2008-04-08	12
-369	NULL	2008-04-08	12
-316	NULL	2008-04-08	12
-413	NULL	2008-04-08	12
-490	NULL	2008-04-08	12
-364	NULL	2008-04-08	12
-395	NULL	2008-04-08	12
-282	NULL	2008-04-08	12
-238	NULL	2008-04-08	12
-419	NULL	2008-04-08	12
-307	NULL	2008-04-08	12
-435	NULL	2008-04-08	12
-277	NULL	2008-04-08	12
-273	NULL	2008-04-08	12
-306	NULL	2008-04-08	12
-224	NULL	2008-04-08	12
-309	NULL	2008-04-08	12
-389	NULL	2008-04-08	12
-327	NULL	2008-04-08	12
-242	NULL	2008-04-08	12
-369	NULL	2008-04-08	12
-392	NULL	2008-04-08	12
-272	NULL	2008-04-08	12
-331	NULL	2008-04-08	12
-401	NULL	2008-04-08	12
-242	NULL	2008-04-08	12
-452	NULL	2008-04-08	12
-226	NULL	2008-04-08	12
-497	NULL	2008-04-08	12
-402	NULL	2008-04-08	12
-396	NULL	2008-04-08	12
-317	NULL	2008-04-08	12
-395	NULL	2008-04-08	12
-336	NULL	2008-04-08	12
-229	NULL	2008-04-08	12
-233	NULL	2008-04-08	12
-472	NULL	2008-04-08	12
-322	NULL	2008-04-08	12
-498	NULL	2008-04-08	12
-321	NULL	2008-04-08	12
-430	NULL	2008-04-08	12
-489	NULL	2008-04-08	12
-458	NULL	2008-04-08	12
-223	NULL	2008-04-08	12
-492	NULL	2008-04-08	12
-449	NULL	2008-04-08	12
-218	NULL	2008-04-08	12
-228	NULL	2008-04-08	12
-453	NULL	2008-04-08	12
-209	NULL	2008-04-08	12
-468	NULL	2008-04-08	12
-342	NULL	2008-04-08	12
-230	NULL	2008-04-08	12
-368	NULL	2008-04-08	12
-296	NULL	2008-04-08	12
-216	NULL	2008-04-08	12
-367	NULL	2008-04-08	12
-344	NULL	2008-04-08	12
-274	NULL	2008-04-08	12
-219	NULL	2008-04-08	12
-239	NULL	2008-04-08	12
-485	NULL	2008-04-08	12
-223	NULL	2008-04-08	12
-256	NULL	2008-04-08	12
-263	NULL	2008-04-08	12
-487	NULL	2008-04-08	12
-480	NULL	2008-04-08	12
-401	NULL	2008-04-08	12
-288	NULL	2008-04-08	12
-244	NULL	2008-04-08	12
-438	NULL	2008-04-08	12
-467	NULL	2008-04-08	12
-432	NULL	2008-04-08	12
-202	NULL	2008-04-08	12
-316	NULL	2008-04-08	12
-229	NULL	2008-04-08	12
-469	NULL	2008-04-08	12
-463	NULL	2008-04-08	12
-280	NULL	2008-04-08	12
-283	NULL	2008-04-08	12
-331	NULL	2008-04-08	12
-235	NULL	2008-04-08	12
-321	NULL	2008-04-08	12
-335	NULL	2008-04-08	12
-466	NULL	2008-04-08	12
-366	NULL	2008-04-08	12
-403	NULL	2008-04-08	12
-483	NULL	2008-04-08	12
-257	NULL	2008-04-08	12
-406	NULL	2008-04-08	12
-409	NULL	2008-04-08	12
-406	NULL	2008-04-08	12
-401	NULL	2008-04-08	12
-258	NULL	2008-04-08	12
-203	NULL	2008-04-08	12
-262	NULL	2008-04-08	12
-348	NULL	2008-04-08	12
-424	NULL	2008-04-08	12
-396	NULL	2008-04-08	12
-201	NULL	2008-04-08	12
-217	NULL	2008-04-08	12
-431	NULL	2008-04-08	12
-454	NULL	2008-04-08	12
-478	NULL	2008-04-08	12
-298	NULL	2008-04-08	12
-431	NULL	2008-04-08	12
-424	NULL	2008-04-08	12
-382	NULL	2008-04-08	12
-397	NULL	2008-04-08	12
-480	NULL	2008-04-08	12
-291	NULL	2008-04-08	12
-351	NULL	2008-04-08	12
-255	NULL	2008-04-08	12
-438	NULL	2008-04-08	12
-414	NULL	2008-04-08	12
-200	NULL	2008-04-08	12
-491	NULL	2008-04-08	12
-237	NULL	2008-04-08	12
-439	NULL	2008-04-08	12
-360	NULL	2008-04-08	12
-248	NULL	2008-04-08	12
-479	NULL	2008-04-08	12
-305	NULL	2008-04-08	12
-417	NULL	2008-04-08	12
-444	NULL	2008-04-08	12
-429	NULL	2008-04-08	12
-443	NULL	2008-04-08	12
-323	NULL	2008-04-08	12
-325	NULL	2008-04-08	12
-277	NULL	2008-04-08	12
-230	NULL	2008-04-08	12
-478	NULL	2008-04-08	12
-468	NULL	2008-04-08	12
-310	NULL	2008-04-08	12
-317	NULL	2008-04-08	12
-333	NULL	2008-04-08	12
-493	NULL	2008-04-08	12
-460	NULL	2008-04-08	12
-207	NULL	2008-04-08	12
-249	NULL	2008-04-08	12
-265	NULL	2008-04-08	12
-480	NULL	2008-04-08	12
-353	NULL	2008-04-08	12
-214	NULL	2008-04-08	12
-462	NULL	2008-04-08	12
-233	NULL	2008-04-08	12
-406	NULL	2008-04-08	12
-454	NULL	2008-04-08	12
-375	NULL	2008-04-08	12
-401	NULL	2008-04-08	12
-421	NULL	2008-04-08	12
-407	NULL	2008-04-08	12
-384	NULL	2008-04-08	12
-256	NULL	2008-04-08	12
-384	NULL	2008-04-08	12
-379	NULL	2008-04-08	12
-462	NULL	2008-04-08	12
-492	NULL	2008-04-08	12
-298	NULL	2008-04-08	12
-341	NULL	2008-04-08	12
-498	NULL	2008-04-08	12
-458	NULL	2008-04-08	12
-362	NULL	2008-04-08	12
-285	NULL	2008-04-08	12
-348	NULL	2008-04-08	12
-273	NULL	2008-04-08	12
-281	NULL	2008-04-08	12
-344	NULL	2008-04-08	12
-469	NULL	2008-04-08	12
-315	NULL	2008-04-08	12
-448	NULL	2008-04-08	12
-348	NULL	2008-04-08	12
-307	NULL	2008-04-08	12
-414	NULL	2008-04-08	12
-477	NULL	2008-04-08	12
-222	NULL	2008-04-08	12
-403	NULL	2008-04-08	12
-400	NULL	2008-04-08	12
-200	NULL	2008-04-08	12
+238	2008-04-08	12
+311	2008-04-08	12
+409	2008-04-08	12
+255	2008-04-08	12
+278	2008-04-08	12
+484	2008-04-08	12
+265	2008-04-08	12
+401	2008-04-08	12
+273	2008-04-08	12
+224	2008-04-08	12
+369	2008-04-08	12
+213	2008-04-08	12
+406	2008-04-08	12
+429	2008-04-08	12
+374	2008-04-08	12
+469	2008-04-08	12
+495	2008-04-08	12
+327	2008-04-08	12
+281	2008-04-08	12
+277	2008-04-08	12
+209	2008-04-08	12
+403	2008-04-08	12
+417	2008-04-08	12
+430	2008-04-08	12
+252	2008-04-08	12
+292	2008-04-08	12
+219	2008-04-08	12
+287	2008-04-08	12
+338	2008-04-08	12
+446	2008-04-08	12
+459	2008-04-08	12
+394	2008-04-08	12
+237	2008-04-08	12
+482	2008-04-08	12
+413	2008-04-08	12
+494	2008-04-08	12
+207	2008-04-08	12
+466	2008-04-08	12
+208	2008-04-08	12
+399	2008-04-08	12
+396	2008-04-08	12
+247	2008-04-08	12
+417	2008-04-08	12
+489	2008-04-08	12
+377	2008-04-08	12
+397	2008-04-08	12
+309	2008-04-08	12
+365	2008-04-08	12
+266	2008-04-08	12
+439	2008-04-08	12
+342	2008-04-08	12
+367	2008-04-08	12
+325	2008-04-08	12
+475	2008-04-08	12
+203	2008-04-08	12
+339	2008-04-08	12
+455	2008-04-08	12
+311	2008-04-08	12
+316	2008-04-08	12
+302	2008-04-08	12
+205	2008-04-08	12
+438	2008-04-08	12
+345	2008-04-08	12
+489	2008-04-08	12
+378	2008-04-08	12
+221	2008-04-08	12
+280	2008-04-08	12
+427	2008-04-08	12
+277	2008-04-08	12
+208	2008-04-08	12
+356	2008-04-08	12
+399	2008-04-08	12
+382	2008-04-08	12
+498	2008-04-08	12
+386	2008-04-08	12
+437	2008-04-08	12
+469	2008-04-08	12
+286	2008-04-08	12
+459	2008-04-08	12
+239	2008-04-08	12
+213	2008-04-08	12
+216	2008-04-08	12
+430	2008-04-08	12
+278	2008-04-08	12
+289	2008-04-08	12
+221	2008-04-08	12
+318	2008-04-08	12
+332	2008-04-08	12
+311	2008-04-08	12
+275	2008-04-08	12
+241	2008-04-08	12
+333	2008-04-08	12
+284	2008-04-08	12
+230	2008-04-08	12
+260	2008-04-08	12
+404	2008-04-08	12
+384	2008-04-08	12
+489	2008-04-08	12
+353	2008-04-08	12
+373	2008-04-08	12
+272	2008-04-08	12
+217	2008-04-08	12
+348	2008-04-08	12
+466	2008-04-08	12
+411	2008-04-08	12
+230	2008-04-08	12
+208	2008-04-08	12
+348	2008-04-08	12
+463	2008-04-08	12
+431	2008-04-08	12
+496	2008-04-08	12
+322	2008-04-08	12
+468	2008-04-08	12
+393	2008-04-08	12
+454	2008-04-08	12
+298	2008-04-08	12
+418	2008-04-08	12
+327	2008-04-08	12
+230	2008-04-08	12
+205	2008-04-08	12
+404	2008-04-08	12
+436	2008-04-08	12
+469	2008-04-08	12
+468	2008-04-08	12
+308	2008-04-08	12
+288	2008-04-08	12
+481	2008-04-08	12
+457	2008-04-08	12
+282	2008-04-08	12
+318	2008-04-08	12
+318	2008-04-08	12
+409	2008-04-08	12
+470	2008-04-08	12
+369	2008-04-08	12
+316	2008-04-08	12
+413	2008-04-08	12
+490	2008-04-08	12
+364	2008-04-08	12
+395	2008-04-08	12
+282	2008-04-08	12
+238	2008-04-08	12
+419	2008-04-08	12
+307	2008-04-08	12
+435	2008-04-08	12
+277	2008-04-08	12
+273	2008-04-08	12
+306	2008-04-08	12
+224	2008-04-08	12
+309	2008-04-08	12
+389	2008-04-08	12
+327	2008-04-08	12
+242	2008-04-08	12
+369	2008-04-08	12
+392	2008-04-08	12
+272	2008-04-08	12
+331	2008-04-08	12
+401	2008-04-08	12
+242	2008-04-08	12
+452	2008-04-08	12
+226	2008-04-08	12
+497	2008-04-08	12
+402	2008-04-08	12
+396	2008-04-08	12
+317	2008-04-08	12
+395	2008-04-08	12
+336	2008-04-08	12
+229	2008-04-08	12
+233	2008-04-08	12
+472	2008-04-08	12
+322	2008-04-08	12
+498	2008-04-08	12
+321	2008-04-08	12
+430	2008-04-08	12
+489	2008-04-08	12
+458	2008-04-08	12
+223	2008-04-08	12
+492	2008-04-08	12
+449	2008-04-08	12
+218	2008-04-08	12
+228	2008-04-08	12
+453	2008-04-08	12
+209	2008-04-08	12
+468	2008-04-08	12
+342	2008-04-08	12
+230	2008-04-08	12
+368	2008-04-08	12
+296	2008-04-08	12
+216	2008-04-08	12
+367	2008-04-08	12
+344	2008-04-08	12
+274	2008-04-08	12
+219	2008-04-08	12
+239	2008-04-08	12
+485	2008-04-08	12
+223	2008-04-08	12
+256	2008-04-08	12
+263	2008-04-08	12
+487	2008-04-08	12
+480	2008-04-08	12
+401	2008-04-08	12
+288	2008-04-08	12
+244	2008-04-08	12
+438	2008-04-08	12
+467	2008-04-08	12
+432	2008-04-08	12
+202	2008-04-08	12
+316	2008-04-08	12
+229	2008-04-08	12
+469	2008-04-08	12
+463	2008-04-08	12
+280	2008-04-08	12
+283	2008-04-08	12
+331	2008-04-08	12
+235	2008-04-08	12
+321	2008-04-08	12
+335	2008-04-08	12
+466	2008-04-08	12
+366	2008-04-08	12
+403	2008-04-08	12
+483	2008-04-08	12
+257	2008-04-08	12
+406	2008-04-08	12
+409	2008-04-08	12
+406	2008-04-08	12
+401	2008-04-08	12
+258	2008-04-08	12
+203	2008-04-08	12
+262	2008-04-08	12
+348	2008-04-08	12
+424	2008-04-08	12
+396	2008-04-08	12
+201	2008-04-08	12
+217	2008-04-08	12
+431	2008-04-08	12
+454	2008-04-08	12
+478	2008-04-08	12
+298	2008-04-08	12
+431	2008-04-08	12
+424	2008-04-08	12
+382	2008-04-08	12
+397	2008-04-08	12
+480	2008-04-08	12
+291	2008-04-08	12
+351	2008-04-08	12
+255	2008-04-08	12
+438	2008-04-08	12
+414	2008-04-08	12
+200	2008-04-08	12
+491	2008-04-08	12
+237	2008-04-08	12
+439	2008-04-08	12
+360	2008-04-08	12
+248	2008-04-08	12
+479	2008-04-08	12
+305	2008-04-08	12
+417	2008-04-08	12
+444	2008-04-08	12
+429	2008-04-08	12
+443	2008-04-08	12
+323	2008-04-08	12
+325	2008-04-08	12
+277	2008-04-08	12
+230	2008-04-08	12
+478	2008-04-08	12
+468	2008-04-08	12
+310	2008-04-08	12
+317	2008-04-08	12
+333	2008-04-08	12
+493	2008-04-08	12
+460	2008-04-08	12
+207	2008-04-08	12
+249	2008-04-08	12
+265	2008-04-08	12
+480	2008-04-08	12
+353	2008-04-08	12
+214	2008-04-08	12
+462	2008-04-08	12
+233	2008-04-08	12
+406	2008-04-08	12
+454	2008-04-08	12
+375	2008-04-08	12
+401	2008-04-08	12
+421	2008-04-08	12
+407	2008-04-08	12
+384	2008-04-08	12
+256	2008-04-08	12
+384	2008-04-08	12
+379	2008-04-08	12
+462	2008-04-08	12
+492	2008-04-08	12
+298	2008-04-08	12
+341	2008-04-08	12
+498	2008-04-08	12
+458	2008-04-08	12
+362	2008-04-08	12
+285	2008-04-08	12
+348	2008-04-08	12
+273	2008-04-08	12
+281	2008-04-08	12
+344	2008-04-08	12
+469	2008-04-08	12
+315	2008-04-08	12
+448	2008-04-08	12
+348	2008-04-08	12
+307	2008-04-08	12
+414	2008-04-08	12
+477	2008-04-08	12
+222	2008-04-08	12
+403	2008-04-08	12
+400	2008-04-08	12
+200	2008-04-08	12

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
             Filter Operator
               predicate:
                   expr: (key < 100)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key
@@ -29,7 +29,7 @@
             Filter Operator
               predicate:
                   expr: ((key >= 100) and (key < 200))
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key
@@ -45,7 +45,7 @@
             Filter Operator
               predicate:
                   expr: ((key >= 200) and (key < 300))
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key
@@ -59,7 +59,7 @@
             Filter Operator
               predicate:
                   expr: (key >= 300)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: value
@@ -287,109 +287,109 @@
 194	val_194
 126	val_126
 169	val_169
-238	NULL	2008-04-08	12
-255	NULL	2008-04-08	12
-278	NULL	2008-04-08	12
-265	NULL	2008-04-08	12
-273	NULL	2008-04-08	12
-224	NULL	2008-04-08	12
-213	NULL	2008-04-08	12
-281	NULL	2008-04-08	12
-277	NULL	2008-04-08	12
-209	NULL	2008-04-08	12
-252	NULL	2008-04-08	12
-292	NULL	2008-04-08	12
-219	NULL	2008-04-08	12
-287	NULL	2008-04-08	12
-237	NULL	2008-04-08	12
-207	NULL	2008-04-08	12
-208	NULL	2008-04-08	12
-247	NULL	2008-04-08	12
-266	NULL	2008-04-08	12
-203	NULL	2008-04-08	12
-205	NULL	2008-04-08	12
-221	NULL	2008-04-08	12
-280	NULL	2008-04-08	12
-277	NULL	2008-04-08	12
-208	NULL	2008-04-08	12
-286	NULL	2008-04-08	12
-239	NULL	2008-04-08	12
-213	NULL	2008-04-08	12
-216	NULL	2008-04-08	12
-278	NULL	2008-04-08	12
-289	NULL	2008-04-08	12
-221	NULL	2008-04-08	12
-275	NULL	2008-04-08	12
-241	NULL	2008-04-08	12
-284	NULL	2008-04-08	12
-230	NULL	2008-04-08	12
-260	NULL	2008-04-08	12
-272	NULL	2008-04-08	12
-217	NULL	2008-04-08	12
-230	NULL	2008-04-08	12
-208	NULL	2008-04-08	12
-298	NULL	2008-04-08	12
-230	NULL	2008-04-08	12
-205	NULL	2008-04-08	12
-288	NULL	2008-04-08	12
-282	NULL	2008-04-08	12
-282	NULL	2008-04-08	12
-238	NULL	2008-04-08	12
-277	NULL	2008-04-08	12
-273	NULL	2008-04-08	12
-224	NULL	2008-04-08	12
-242	NULL	2008-04-08	12
-272	NULL	2008-04-08	12
-242	NULL	2008-04-08	12
-226	NULL	2008-04-08	12
-229	NULL	2008-04-08	12
-233	NULL	2008-04-08	12
-223	NULL	2008-04-08	12
-218	NULL	2008-04-08	12
-228	NULL	2008-04-08	12
-209	NULL	2008-04-08	12
-230	NULL	2008-04-08	12
-296	NULL	2008-04-08	12
-216	NULL	2008-04-08	12
-274	NULL	2008-04-08	12
-219	NULL	2008-04-08	12
-239	NULL	2008-04-08	12
-223	NULL	2008-04-08	12
-256	NULL	2008-04-08	12
-263	NULL	2008-04-08	12
-288	NULL	2008-04-08	12
-244	NULL	2008-04-08	12
-202	NULL	2008-04-08	12
-229	NULL	2008-04-08	12
-280	NULL	2008-04-08	12
-283	NULL	2008-04-08	12
-235	NULL	2008-04-08	12
-257	NULL	2008-04-08	12
-258	NULL	2008-04-08	12
-203	NULL	2008-04-08	12
-262	NULL	2008-04-08	12
-201	NULL	2008-04-08	12
-217	NULL	2008-04-08	12
-298	NULL	2008-04-08	12
-291	NULL	2008-04-08	12
-255	NULL	2008-04-08	12
-200	NULL	2008-04-08	12
-237	NULL	2008-04-08	12
-248	NULL	2008-04-08	12
-277	NULL	2008-04-08	12
-230	NULL	2008-04-08	12
-207	NULL	2008-04-08	12
-249	NULL	2008-04-08	12
-265	NULL	2008-04-08	12
-214	NULL	2008-04-08	12
-233	NULL	2008-04-08	12
-256	NULL	2008-04-08	12
-298	NULL	2008-04-08	12
-285	NULL	2008-04-08	12
-273	NULL	2008-04-08	12
-281	NULL	2008-04-08	12
-222	NULL	2008-04-08	12
-200	NULL	2008-04-08	12
+238	2008-04-08	12
+255	2008-04-08	12
+278	2008-04-08	12
+265	2008-04-08	12
+273	2008-04-08	12
+224	2008-04-08	12
+213	2008-04-08	12
+281	2008-04-08	12
+277	2008-04-08	12
+209	2008-04-08	12
+252	2008-04-08	12
+292	2008-04-08	12
+219	2008-04-08	12
+287	2008-04-08	12
+237	2008-04-08	12
+207	2008-04-08	12
+208	2008-04-08	12
+247	2008-04-08	12
+266	2008-04-08	12
+203	2008-04-08	12
+205	2008-04-08	12
+221	2008-04-08	12
+280	2008-04-08	12
+277	2008-04-08	12
+208	2008-04-08	12
+286	2008-04-08	12
+239	2008-04-08	12
+213	2008-04-08	12
+216	2008-04-08	12
+278	2008-04-08	12
+289	2008-04-08	12
+221	2008-04-08	12
+275	2008-04-08	12
+241	2008-04-08	12
+284	2008-04-08	12
+230	2008-04-08	12
+260	2008-04-08	12
+272	2008-04-08	12
+217	2008-04-08	12
+230	2008-04-08	12
+208	2008-04-08	12
+298	2008-04-08	12
+230	2008-04-08	12
+205	2008-04-08	12
+288	2008-04-08	12
+282	2008-04-08	12
+282	2008-04-08	12
+238	2008-04-08	12
+277	2008-04-08	12
+273	2008-04-08	12
+224	2008-04-08	12
+242	2008-04-08	12
+272	2008-04-08	12
+242	2008-04-08	12
+226	2008-04-08	12
+229	2008-04-08	12
+233	2008-04-08	12
+223	2008-04-08	12
+218	2008-04-08	12
+228	2008-04-08	12
+209	2008-04-08	12
+230	2008-04-08	12
+296	2008-04-08	12
+216	2008-04-08	12
+274	2008-04-08	12
+219	2008-04-08	12
+239	2008-04-08	12
+223	2008-04-08	12
+256	2008-04-08	12
+263	2008-04-08	12
+288	2008-04-08	12
+244	2008-04-08	12
+202	2008-04-08	12
+229	2008-04-08	12
+280	2008-04-08	12
+283	2008-04-08	12
+235	2008-04-08	12
+257	2008-04-08	12
+258	2008-04-08	12
+203	2008-04-08	12
+262	2008-04-08	12
+201	2008-04-08	12
+217	2008-04-08	12
+298	2008-04-08	12
+291	2008-04-08	12
+255	2008-04-08	12
+200	2008-04-08	12
+237	2008-04-08	12
+248	2008-04-08	12
+277	2008-04-08	12
+230	2008-04-08	12
+207	2008-04-08	12
+249	2008-04-08	12
+265	2008-04-08	12
+214	2008-04-08	12
+233	2008-04-08	12
+256	2008-04-08	12
+298	2008-04-08	12
+285	2008-04-08	12
+273	2008-04-08	12
+281	2008-04-08	12
+222	2008-04-08	12
+200	2008-04-08	12
 val_311
 val_409
 val_484

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_COLLIST (TOK_COLREF src key) (TOK_COLREF src value)) (TOK_ALIASLIST tkey tvalue) '/bin/cat'))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue))) (TOK_WHERE (< (TOK_COLREF tmap tkey) 100))))
+  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (TOK_COLREF src key) (TOK_COLREF src value)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue))) (TOK_WHERE (< (TOK_COLREF tmap tkey) 100))))
 
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
@@ -25,7 +25,9 @@
                   key expressions:
                         expr: tkey
                         type: string
-                  # partition fields: 1
+                  Map-reduce partition columns:
+                        expr: tkey
+                        type: string
                   tag: -1
                   value expressions:
                         expr: tkey
@@ -37,7 +39,7 @@
           Filter Operator
             predicate:
                 expr: (0 < 100)
-                type: Boolean
+                type: boolean
             Select Operator
               expressions:
                     expr: 0

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14_limit.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14_limit.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14_limit.q.out Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_COLLIST (TOK_COLREF src key) (TOK_COLREF src value)) (TOK_ALIASLIST tkey tvalue) '/bin/cat'))) (TOK_CLUSTERBY tkey) (TOK_LIMIT 20))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue))) (TOK_WHERE (< (TOK_COLREF tmap tkey) 100))))
+  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (TOK_COLREF src key) (TOK_COLREF src value)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY tkey) (TOK_LIMIT 20))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue))) (TOK_WHERE (< (TOK_COLREF tmap tkey) 100))))
 
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
@@ -26,7 +26,9 @@
                   key expressions:
                         expr: tkey
                         type: string
-                  # partition fields: 1
+                  Map-reduce partition columns:
+                        expr: tkey
+                        type: string
                   tag: -1
                   value expressions:
                         expr: tkey
@@ -38,18 +40,21 @@
           Limit
             File Output Operator
               table:
-                  input format: org.apache.hadoop.mapred.TextInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                  output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+                  name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /tmp/hive-njain/945772770/1814909502.10001 
+        /tmp/hive-njain/195632265/461794176.10001 
           Reduce Output Operator
             key expressions:
                   expr: 0
                   type: string
-            # partition fields: 1
+            Map-reduce partition columns:
+                  expr: 0
+                  type: string
             tag: -1
             value expressions:
                   expr: 0
@@ -63,7 +68,7 @@
             Filter Operator
               predicate:
                   expr: (0 < 100)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: 0

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
 ABSTRACT SYNTAX TREE:
-  (TOK_CREATETABLE TEST15 (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEROWFORMAT (TOK_TABLEROWFORMATFIELD '\t')))
+  (TOK_CREATETABLE TEST15 (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEROWFORMAT (TOK_TABLEROWFORMATFIELD '\t')) TOK_TBLTEXTFILE)
 
 STAGE DEPENDENCIES:
   Stage-0 is a root stage

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input17.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input17.q.out?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input17.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input17.q.out Mon Nov 10 17:50:06 2008
@@ -0,0 +1,80 @@
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (+ (TOK_COLREF src_thrift aint) ([ (TOK_COLREF src_thrift lint) 0)) ([ (TOK_COLREF src_thrift lintstring) 0)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue)))))
+
+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:
+        tmap:src_thrift 
+            Select Operator
+              expressions:
+                    expr: aint
+                    type: int
+                    expr: lint
+                    type: array<int>
+                    expr: lintstring
+                    type: array<struct{myint:int,mystring:string}>
+              Select Operator
+                expressions:
+                      expr: (0 + 1[0])
+                      type: int
+                      expr: 2[0]
+                      type: struct{myint:int,mystring:string}
+                Transform Operator
+                  command: /bin/cat
+                  output info:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                  Reduce Output Operator
+                    key expressions:
+                          expr: tkey
+                          type: string
+                    Map-reduce partition columns:
+                          expr: tkey
+                          type: string
+                    tag: -1
+                    value expressions:
+                          expr: tkey
+                          type: string
+                          expr: tvalue
+                          type: string
+      Reduce Operator Tree:
+        Extract
+          Select Operator
+            expressions:
+                  expr: 0
+                  type: string
+                  expr: 1
+                  type: string
+            File Output Operator
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                  name: dest1
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            replace:
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
+
+
+-1103622755	{"myint":64,"mystring":"512"}
+-1147582749	{"myint":1,"mystring":"1"}
+-1220068486	{"myint":0,"mystring":"0"}
+-1281615204	{"myint":36,"mystring":"216"}
+-1587372270	{"myint":9,"mystring":"27"}
+-1883609158	{"myint":81,"mystring":"729"}
+-2091002568	{"myint":4,"mystring":"8"}
+-240543261	{"myint":16,"mystring":"64"}
+1539139271	{"myint":49,"mystring":"343"}
+1914724542	{"myint":25,"mystring":"125"}

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input18.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input18.q.out?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input18.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input18.q.out Mon Nov 10 17:50:06 2008
@@ -0,0 +1,154 @@
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (TOK_COLREF src key) (TOK_COLREF src value) (+ 1 2) (+ 3 4)) '/bin/cat'))) (TOK_CLUSTERBY key))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap key)) (TOK_SELEXPR (TOK_FUNCTION regexp_replace (TOK_COLREF tmap value) '\t' '+'))) (TOK_WHERE (< (TOK_COLREF tmap key) 100))))
+
+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:
+        tmap:src 
+            Select Operator
+              expressions:
+                    expr: key
+                    type: string
+                    expr: value
+                    type: string
+                    expr: (1 + 2)
+                    type: int
+                    expr: (3 + 4)
+                    type: int
+              Transform Operator
+                command: /bin/cat
+                output info:
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                Reduce Output Operator
+                  key expressions:
+                        expr: key
+                        type: string
+                  Map-reduce partition columns:
+                        expr: key
+                        type: string
+                  tag: -1
+                  value expressions:
+                        expr: key
+                        type: string
+                        expr: value
+                        type: string
+      Reduce Operator Tree:
+        Extract
+          Filter Operator
+            predicate:
+                expr: (0 < 100)
+                type: boolean
+            Select Operator
+              expressions:
+                    expr: 0
+                    type: string
+                    expr: regexp_replace(1, '	', '+')
+                    type: string
+              File Output Operator
+                table:
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                    name: dest1
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            replace:
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
+
+
+0	val_0+3+7
+0	val_0+3+7
+0	val_0+3+7
+10	val_10+3+7
+11	val_11+3+7
+12	val_12+3+7
+12	val_12+3+7
+15	val_15+3+7
+15	val_15+3+7
+17	val_17+3+7
+18	val_18+3+7
+18	val_18+3+7
+19	val_19+3+7
+2	val_2+3+7
+20	val_20+3+7
+24	val_24+3+7
+24	val_24+3+7
+26	val_26+3+7
+26	val_26+3+7
+27	val_27+3+7
+28	val_28+3+7
+30	val_30+3+7
+33	val_33+3+7
+34	val_34+3+7
+35	val_35+3+7
+35	val_35+3+7
+35	val_35+3+7
+37	val_37+3+7
+37	val_37+3+7
+4	val_4+3+7
+41	val_41+3+7
+42	val_42+3+7
+42	val_42+3+7
+43	val_43+3+7
+44	val_44+3+7
+47	val_47+3+7
+5	val_5+3+7
+5	val_5+3+7
+5	val_5+3+7
+51	val_51+3+7
+51	val_51+3+7
+53	val_53+3+7
+54	val_54+3+7
+57	val_57+3+7
+58	val_58+3+7
+58	val_58+3+7
+64	val_64+3+7
+65	val_65+3+7
+66	val_66+3+7
+67	val_67+3+7
+67	val_67+3+7
+69	val_69+3+7
+70	val_70+3+7
+70	val_70+3+7
+70	val_70+3+7
+72	val_72+3+7
+72	val_72+3+7
+74	val_74+3+7
+76	val_76+3+7
+76	val_76+3+7
+77	val_77+3+7
+78	val_78+3+7
+8	val_8+3+7
+80	val_80+3+7
+82	val_82+3+7
+83	val_83+3+7
+83	val_83+3+7
+84	val_84+3+7
+84	val_84+3+7
+85	val_85+3+7
+86	val_86+3+7
+87	val_87+3+7
+9	val_9+3+7
+90	val_90+3+7
+90	val_90+3+7
+90	val_90+3+7
+92	val_92+3+7
+95	val_95+3+7
+95	val_95+3+7
+96	val_96+3+7
+97	val_97+3+7
+97	val_97+3+7
+98	val_98+3+7
+98	val_98+3+7

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input19.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input19.q.out?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input19.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input19.q.out Mon Nov 10 17:50:06 2008
@@ -0,0 +1 @@
+127.0.0.1		frank	10/Oct/2000:13:55:36 -0700	GET /apache_pb.gif HTTP/1.0	200	2326

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1_limit.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1_limit.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1_limit.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
             Filter Operator
               predicate:
                   expr: (key < 100)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key
@@ -30,7 +30,7 @@
             Filter Operator
               predicate:
                   expr: (key < 100)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2_limit.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2_limit.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2_limit.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
             Filter Operator
               predicate:
                   expr: (key < 300)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out Mon Nov 10 17:50:06 2008
@@ -61,4 +61,4 @@
 r1	int
 r2	float
 Detailed Table Information:
-Table(tableName:test3c,dbName:default,owner:njain,createTime:1224285029,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:r1,type:int,comment:null), FieldSchema(name:r2,type:float,comment:null)],location:file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/test3b,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{last_modified_by=njain,last_modified_time=1224285029,SORTBUCKETCOLSPREFIX=TRUE})
+Table(tableName:test3c,dbName:default,owner:njain,createTime:1225993819,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:r1,type:int,comment:null), FieldSchema(name:r2,type:float,comment:null)],location:file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/test3b,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{last_modified_by=njain,last_modified_time=1225993820})

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out Mon Nov 10 17:50:06 2008
@@ -9,7 +9,7 @@
   Stage: Stage-0
     Copy
       source: file:/home/njain/workspace/hadoop-0.17/src/contrib/hive/data/files/kv1.txt
-      destination: file:/tmp/hive-njain/-478939701
+      destination: file:/tmp/hive-njain/-1533162426
 
   Stage: Stage-1
     Move Operator

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_COLLIST (TOK_COLREF src_thrift lint) (TOK_COLREF src_thrift lintstring)) (TOK_ALIASLIST tkey tvalue) '/bin/cat'))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue)))))
+  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (TOK_COLREF src_thrift lint) (TOK_COLREF src_thrift lintstring)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue)))))
 
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
@@ -16,22 +16,30 @@
                     type: array<int>
                     expr: lintstring
                     type: array<struct{myint:int,mystring:string}>
-              Transform Operator
-                command: /bin/cat
-                output info:
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                Reduce Output Operator
-                  key expressions:
-                        expr: tkey
-                        type: string
-                  # partition fields: 1
-                  tag: -1
-                  value expressions:
-                        expr: tkey
-                        type: string
-                        expr: tvalue
-                        type: string
+              Select Operator
+                expressions:
+                      expr: 0
+                      type: array<int>
+                      expr: 1
+                      type: array<struct{myint:int,mystring:string}>
+                Transform Operator
+                  command: /bin/cat
+                  output info:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                  Reduce Output Operator
+                    key expressions:
+                          expr: tkey
+                          type: string
+                    Map-reduce partition columns:
+                          expr: tkey
+                          type: string
+                    tag: -1
+                    value expressions:
+                          expr: tkey
+                          type: string
+                          expr: tvalue
+                          type: string
       Reduce Operator Tree:
         Extract
           Select Operator

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
             Filter Operator
               predicate:
                   expr: key is null
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out Mon Nov 10 17:50:06 2008
@@ -12,16 +12,20 @@
         src1 
             Select Operator
               expressions:
-                    expr: null
-                    type: string
                     expr: key
                     type: string
-              File Output Operator
-                table:
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
-                    name: dest1
+              Select Operator
+                expressions:
+                      expr: null
+                      type: string
+                      expr: 0
+                      type: string
+                File Output Operator
+                  table:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest1
 
   Stage: Stage-0
     Move Operator

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out Mon Nov 10 17:50:06 2008
@@ -12,18 +12,22 @@
         src1 
             Select Operator
               expressions:
-                    expr: (4 + null)
-                    type: int
-                    expr: (UDFToDouble(key) - null)
-                    type: double
-                    expr: (null + null)
-                    type: Byte
-              File Output Operator
-                table:
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
-                    name: dest1
+                    expr: key
+                    type: string
+              Select Operator
+                expressions:
+                      expr: (4 + null)
+                      type: int
+                      expr: (UDFToDouble(0) - null)
+                      type: double
+                      expr: (null + null)
+                      type: tinyint
+                File Output Operator
+                  table:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest1
 
   Stage: Stage-0
     Move Operator

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out Mon Nov 10 17:50:06 2008
@@ -10,22 +10,26 @@
     Map Reduce
       Alias -> Map Operator Tree:
         src1 
-            Filter Operator
-              predicate:
-                  expr: (null = null)
-                  type: Boolean
-              Select Operator
-                expressions:
-                      expr: null
-                      type: string
-                      expr: key
-                      type: string
-                File Output Operator
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
-                      name: dest1
+            Select Operator
+              expressions:
+                    expr: key
+                    type: string
+              Filter Operator
+                predicate:
+                    expr: (null = null)
+                    type: boolean
+                Select Operator
+                  expressions:
+                        expr: null
+                        type: string
+                        expr: 0
+                        type: string
+                  File Output Operator
+                    table:
+                        input format: org.apache.hadoop.mapred.TextInputFormat
+                        output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                        serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                        name: dest1
 
   Stage: Stage-0
     Move Operator

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dynamicserde.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dynamicserde.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dynamicserde.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dynamicserde.q.out Mon Nov 10 17:50:06 2008
@@ -22,12 +22,24 @@
                     type: int
                     expr: astring
                     type: string
-              File Output Operator
-                table:
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
-                    name: dest1
+              Select Operator
+                expressions:
+                      expr: 0
+                      type: array<int>
+                      expr: 1
+                      type: array<string>
+                      expr: 2
+                      type: map<string,string>
+                      expr: 3
+                      type: int
+                      expr: 4
+                      type: string
+                File Output Operator
+                  table:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+                      name: dest1
 
   Stage: Stage-0
     Move Operator
@@ -50,3 +62,13 @@
 [7,14,21]	["70","700","7000"]	{"key_7":"value_7"}	1539139264	record_7
 [8,16,24]	["80","800","8000"]	{"key_8":"value_8"}	-1103622763	record_8
 [9,18,27]	["90","900","9000"]	{"key_9":"value_9"}	-1883609167	record_9
+0	0	NULL	-1220068486	record_0
+1	10	NULL	-1147582750	record_1
+2	20	NULL	-2091002570	record_2
+3	30	NULL	-1587372273	record_3
+4	40	NULL	-240543265	record_4
+5	50	NULL	1914724537	record_5
+6	60	NULL	-1281615210	record_6
+7	70	NULL	1539139264	record_7
+8	80	NULL	-1103622763	record_8
+9	90	NULL	-1883609167	record_9

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part0.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part0.q.out?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part0.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part0.q.out Mon Nov 10 17:50:06 2008
@@ -0,0 +1,1012 @@
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF SRCPART x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF x))) (TOK_WHERE (= (TOK_COLREF x ds) '2008-04-08'))))
+
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+
+
+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

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
             Filter Operator
               predicate:
                   expr: (((key < 100) and (ds = '2008-04-08')) and (hr = '12'))
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key
@@ -25,7 +25,7 @@
                       expr: ds
                       type: string
                 File Output Operator
-                  directory: /tmp/hive-njain/13222008/293248514.10000.insclause-0
+                  directory: /tmp/hive-njain/482622140/1009180747.10000.insclause-0
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -34,7 +34,6 @@
                         serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
                         serialization.format 1
                         columns key,value,hr,ds
-                        SORTBUCKETCOLSPREFIX TRUE
                         bucket_count -1
                         serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -72,7 +71,7 @@
     Move Operator
       tables:
             replace:
-            source: /tmp/hive-njain/13222008/293248514.10000.insclause-0
+            source: /tmp/hive-njain/482622140/1009180747.10000.insclause-0
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -81,7 +80,6 @@
                   serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
                   serialization.format 1
                   columns key,value,hr,ds
-                  SORTBUCKETCOLSPREFIX TRUE
                   bucket_count -1
                   serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part2.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part2.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
             Filter Operator
               predicate:
                   expr: (((key < 100) and (ds = '2008-04-08')) and (hr = '12'))
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key
@@ -25,7 +25,7 @@
                       expr: ds
                       type: string
                 File Output Operator
-                  directory: /tmp/hive-njain/925269835/11972654.10000.insclause-0
+                  directory: /tmp/hive-njain/238334885/114382058.10000.insclause-0
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -34,7 +34,6 @@
                         serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
                         serialization.format 1
                         columns key,value,hr,ds
-                        SORTBUCKETCOLSPREFIX TRUE
                         bucket_count -1
                         serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -45,7 +44,7 @@
             Filter Operator
               predicate:
                   expr: (((key < 100) and (ds = '2008-04-09')) and (hr = '12'))
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key
@@ -57,7 +56,7 @@
                       expr: ds
                       type: string
                 File Output Operator
-                  directory: /tmp/hive-njain/925269835/11972654.10001.insclause-1
+                  directory: /tmp/hive-njain/238334885/114382058.10001.insclause-1
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -66,7 +65,6 @@
                         serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
                         serialization.format 1
                         columns key,value,hr,ds
-                        SORTBUCKETCOLSPREFIX TRUE
                         bucket_count -1
                         serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -126,7 +124,7 @@
     Move Operator
       tables:
             replace:
-            source: /tmp/hive-njain/925269835/11972654.10000.insclause-0
+            source: /tmp/hive-njain/238334885/114382058.10000.insclause-0
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -135,7 +133,6 @@
                   serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
                   serialization.format 1
                   columns key,value,hr,ds
-                  SORTBUCKETCOLSPREFIX TRUE
                   bucket_count -1
                   serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -144,7 +141,7 @@
                 serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 name: dest1
             replace:
-            source: /tmp/hive-njain/925269835/11972654.10001.insclause-1
+            source: /tmp/hive-njain/238334885/114382058.10001.insclause-1
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -153,7 +150,6 @@
                   serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
                   serialization.format 1
                   columns key,value,hr,ds
-                  SORTBUCKETCOLSPREFIX TRUE
                   bucket_count -1
                   serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat



Mime
View raw message