You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by at...@apache.org on 2009/01/24 02:58:06 UTC

svn commit: r737291 [4/8] - in /hadoop/hive/trunk: ./ eclipse-templates/ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/ql/lib/ ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/apache/hadoop/hive/ql/parse...

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out Sat Jan 24 01:58:01 2009
@@ -20,8 +20,8 @@
                       expr: avg(DISTINCT UDFToDouble(substr(0, 4)))
                       expr: sum(UDFToDouble(substr(0, 4)))
                       expr: avg(UDFToDouble(substr(0, 4)))
-                      expr: min(UDFToDouble(substr(0, 4)))
-                      expr: max(UDFToDouble(substr(0, 4)))
+                      expr: min(substr(0, 4))
+                      expr: max(substr(0, 4))
                 keys:
                       expr: substr(0, 4)
                       type: string
@@ -43,15 +43,15 @@
                         expr: 3
                         type: string
                         expr: 4
-                        type: double
+                        type: string
                         expr: 5
-                        type: double
+                        type: string
       Reduce Operator Tree:
         Group By Operator
           aggregations:
                 expr: avg(DISTINCT UDFToDouble(KEY.0))
                 expr: sum(VALUE.1)
-                expr: avg(VALUE.2)
+                expr: avg(UDFToDouble(VALUE.2))
                 expr: min(VALUE.3)
                 expr: max(VALUE.4)
           mode: partial2
@@ -65,7 +65,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /tmp/hive-zshao/151053238/135596442.10001 
+        /data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/885399493/544614010.10001 
           Reduce Output Operator
             sort order: 
             tag: -1
@@ -77,15 +77,15 @@
                   expr: 2
                   type: string
                   expr: 3
-                  type: double
+                  type: string
                   expr: 4
-                  type: double
+                  type: string
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: avg(VALUE.0)
+                expr: avg(UDFToDouble(VALUE.0))
                 expr: sum(VALUE.1)
-                expr: avg(VALUE.2)
+                expr: avg(UDFToDouble(VALUE.2))
                 expr: min(VALUE.3)
                 expr: max(VALUE.4)
           mode: final
@@ -98,16 +98,28 @@
                   expr: 0
                   type: double
                   expr: 4
-                  type: double
+                  type: string
                   expr: 3
-                  type: double
-            File Output Operator
-              compressed: false
-              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
+                  type: string
+            Select Operator
+              expressions:
+                    expr: 0
+                    type: double
+                    expr: 1
+                    type: double
+                    expr: 2
+                    type: double
+                    expr: UDFToDouble(3)
+                    type: double
+                    expr: UDFToDouble(4)
+                    type: double
+              File Output Operator
+                compressed: false
+                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
@@ -120,4 +132,4 @@
                 name: dest1
 
 
-130091.0	260.182	256.10355987055016	498.0	0.0
+130091.0	NULL	NULL	98.0	98.0

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/implicit_cast1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/implicit_cast1.q.out?rev=737291&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/implicit_cast1.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/implicit_cast1.q.out Sat Jan 24 01:58:01 2009
@@ -0,0 +1,33 @@
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF implicit_test1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF implicit_test1))) (TOK_WHERE (<> (TOK_COLREF implicit_test1 a) 0))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        implicit_test1 
+            Filter Operator
+              predicate:
+                  expr: (UDFToDouble(a) <> UDFToDouble(0))
+                  type: boolean
+              Select Operator
+                expressions:
+                      expr: a
+                      type: bigint
+                      expr: b
+                      type: string
+                File Output Operator
+                  compressed: false
+                  table:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+
+

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         src 
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (UDFToDouble(key) < UDFToDouble(100))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         src 
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (UDFToDouble(key) < UDFToDouble(100))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         src 
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (UDFToDouble(key) < UDFToDouble(100))
                   type: boolean
               Select Operator
                 expressions:
@@ -35,7 +35,7 @@
                         name: dest1
             Filter Operator
               predicate:
-                  expr: ((key >= 100) and (key < 200))
+                  expr: ((UDFToDouble(key) >= UDFToDouble(100)) and (UDFToDouble(key) < UDFToDouble(200)))
                   type: boolean
               Select Operator
                 expressions:
@@ -58,7 +58,7 @@
                         name: dest2
             Filter Operator
               predicate:
-                  expr: (key >= 200)
+                  expr: (UDFToDouble(key) >= UDFToDouble(200))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         src 
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (UDFToDouble(key) < UDFToDouble(100))
                   type: boolean
               Select Operator
                 expressions:
@@ -35,7 +35,7 @@
                         name: dest1
             Filter Operator
               predicate:
-                  expr: ((key >= 100) and (key < 200))
+                  expr: ((UDFToDouble(key) >= UDFToDouble(100)) and (UDFToDouble(key) < UDFToDouble(200)))
                   type: boolean
               Select Operator
                 expressions:
@@ -58,7 +58,7 @@
                         name: dest2
             Filter Operator
               predicate:
-                  expr: ((key >= 200) and (key < 300))
+                  expr: ((UDFToDouble(key) >= UDFToDouble(200)) and (UDFToDouble(key) < UDFToDouble(300)))
                   type: boolean
               Select Operator
                 expressions:
@@ -77,7 +77,7 @@
                         name: dest3
             Filter Operator
               predicate:
-                  expr: (key >= 300)
+                  expr: (UDFToDouble(key) >= UDFToDouble(300))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out Sat Jan 24 01:58:01 2009
@@ -39,7 +39,7 @@
         Extract
           Filter Operator
             predicate:
-                expr: (0 < 100)
+                expr: (UDFToDouble(0) < UDFToDouble(100))
                 type: boolean
             Select Operator
               expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out Sat Jan 24 01:58:01 2009
@@ -49,7 +49,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/pchakka/workspace/oshive/build/ql/tmp/557187098/238412176.10001 
+        /data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/456652865/144848153.10001 
           Reduce Output Operator
             key expressions:
                   expr: 0
@@ -70,7 +70,7 @@
           Limit
             Filter Operator
               predicate:
-                  expr: (0 < 100)
+                  expr: (UDFToDouble(0) < UDFToDouble(100))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out Sat Jan 24 01:58:01 2009
@@ -43,7 +43,7 @@
         Extract
           Filter Operator
             predicate:
-                expr: (0 < 100)
+                expr: (UDFToDouble(0) < UDFToDouble(100))
                 type: boolean
             Select Operator
               expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out Sat Jan 24 01:58:01 2009
@@ -14,7 +14,7 @@
         src 
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (UDFToDouble(key) < UDFToDouble(100))
                   type: boolean
               Select Operator
                 expressions:
@@ -33,7 +33,7 @@
                           type: string
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (UDFToDouble(key) < UDFToDouble(100))
                   type: boolean
               Select Operator
                 expressions:
@@ -85,7 +85,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /tmp/hive-zshao/196681773/625336699.10002 
+        /data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/2110365113/704872924.10002 
           Reduce Output Operator
             sort order: 
             tag: -1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         x 
             Filter Operator
               predicate:
-                  expr: (key < 300)
+                  expr: (UDFToDouble(key) < UDFToDouble(300))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out Sat Jan 24 01:58:01 2009
@@ -22,7 +22,7 @@
                       type: string
                 Select Operator
                   expressions:
-                        expr: UDFToDouble(UDFToBoolean(0))
+                        expr: UDFToDouble(0)
                         type: double
                         expr: UDFToInteger(1)
                         type: int

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out Sat Jan 24 01:58:01 2009
@@ -16,19 +16,19 @@
                     type: string
               Select Operator
                 expressions:
-                      expr: (4 + null)
-                      type: int
+                      expr: (UDFToDouble(4) + null)
+                      type: double
                       expr: (UDFToDouble(0) - null)
                       type: double
                       expr: (null + null)
-                      type: tinyint
+                      type: double
                 Select Operator
                   expressions:
                         expr: UDFToString(0)
                         type: string
                         expr: UDFToInteger(1)
                         type: int
-                        expr: UDFToDouble(2)
+                        expr: 2
                         type: double
                   File Output Operator
                     compressed: false

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out Sat Jan 24 01:58:01 2009
@@ -26,7 +26,7 @@
                         type: string
                   Select Operator
                     expressions:
-                          expr: UDFToString(UDFToBoolean(0))
+                          expr: UDFToString(0)
                           type: string
                           expr: UDFToInteger(1)
                           type: int

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         srcpart 
             Filter Operator
               predicate:
-                  expr: (((key < 100) and (ds = '2008-04-08')) and (hr = '12'))
+                  expr: (((UDFToDouble(key) < UDFToDouble(100)) and (ds = '2008-04-08')) and (hr = '12'))
                   type: boolean
               Select Operator
                 expressions:
@@ -36,7 +36,7 @@
                         type: string
                   File Output Operator
                     compressed: false
-                    directory: /tmp/hive-zshao/293656751/393363001.10000.insclause-0
+                    directory: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/1332023401/49833095.10000.insclause-0
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -49,14 +49,14 @@
                           serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                           file.inputformat org.apache.hadoop.mapred.TextInputFormat
                           file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                          location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+                          location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1
                         serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                         name: dest1
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+        file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
       Path -> Partition:
-        file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+        file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
           Partition
             partition values:
               ds 2008-04-08
@@ -74,7 +74,7 @@
                 serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart
+                location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
               name: srcpart
 
@@ -82,7 +82,7 @@
     Move Operator
       tables:
             replace: true
-            source: /tmp/hive-zshao/293656751/393363001.10000.insclause-0
+            source: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/1332023401/49833095.10000.insclause-0
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -95,7 +95,7 @@
                   serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat
                   file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                  location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+                  location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1
                 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                 name: dest1
 

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         srcpart 
             Filter Operator
               predicate:
-                  expr: (((key < 100) and (ds = '2008-04-08')) and (hr = '12'))
+                  expr: (((UDFToDouble(key) < UDFToDouble(100)) and (ds = '2008-04-08')) and (hr = '12'))
                   type: boolean
               Select Operator
                 expressions:
@@ -36,7 +36,7 @@
                         type: string
                   File Output Operator
                     compressed: false
-                    directory: /tmp/hive-zshao/591856793/204210378.10000.insclause-0
+                    directory: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/108623150/305040120.10000.insclause-0
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -49,12 +49,12 @@
                           serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                           file.inputformat org.apache.hadoop.mapred.TextInputFormat
                           file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                          location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+                          location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1
                         serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                         name: dest1
             Filter Operator
               predicate:
-                  expr: (((key < 100) and (ds = '2008-04-09')) and (hr = '12'))
+                  expr: (((UDFToDouble(key) < UDFToDouble(100)) and (ds = '2008-04-09')) and (hr = '12'))
                   type: boolean
               Select Operator
                 expressions:
@@ -78,7 +78,7 @@
                         type: string
                   File Output Operator
                     compressed: false
-                    directory: /tmp/hive-zshao/591856793/204210378.10001.insclause-1
+                    directory: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/108623150/305040120.10001.insclause-1
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -91,15 +91,15 @@
                           serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                           file.inputformat org.apache.hadoop.mapred.TextInputFormat
                           file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                          location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest2
+                          location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest2
                         serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                         name: dest2
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
-        file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
+        file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+        file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
       Path -> Partition:
-        file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+        file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
           Partition
             partition values:
               ds 2008-04-08
@@ -117,10 +117,10 @@
                 serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart
+                location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
               name: srcpart
-        file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
+        file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
           Partition
             partition values:
               ds 2008-04-09
@@ -138,7 +138,7 @@
                 serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart
+                location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
               name: srcpart
 
@@ -146,7 +146,7 @@
     Move Operator
       tables:
             replace: true
-            source: /tmp/hive-zshao/591856793/204210378.10000.insclause-0
+            source: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/108623150/305040120.10000.insclause-0
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -159,11 +159,11 @@
                   serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat
                   file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                  location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+                  location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1
                 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                 name: dest1
             replace: true
-            source: /tmp/hive-zshao/591856793/204210378.10001.insclause-1
+            source: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/108623150/305040120.10001.insclause-1
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -176,7 +176,7 @@
                   serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat
                   file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                  location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest2
+                  location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest2
                 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                 name: dest2
 

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         x 
             Filter Operator
               predicate:
-                  expr: ((ds = '2008-04-08') and (key < 100))
+                  expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100)))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         x 
             Filter Operator
               predicate:
-                  expr: (ds = ((2008 - 4) - 8))
+                  expr: (UDFToDouble(ds) = UDFToDouble(((2008 - 4) - 8)))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out Sat Jan 24 01:58:01 2009
@@ -13,7 +13,7 @@
         src2:src 
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (UDFToDouble(key) < UDFToDouble(10))
                   type: boolean
               Select Operator
                 expressions:
@@ -32,7 +32,7 @@
         src1:src 
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (UDFToDouble(key) < UDFToDouble(10))
                   type: boolean
               Select Operator
                 expressions:
@@ -75,7 +75,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/pchakka/workspace/oshive/build/ql/tmp/1608930740/15144587.10002 
+        /data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/143976251/534107059.10002 
           Reduce Output Operator
             key expressions:
                   expr: 0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join11.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join11.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join11.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join11.q.out Sat Jan 24 01:58:01 2009
@@ -39,7 +39,7 @@
                     type: string
               Filter Operator
                 predicate:
-                    expr: (0 < 100)
+                    expr: (UDFToDouble(0) < UDFToDouble(100))
                     type: boolean
                 Reduce Output Operator
                   key expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join12.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join12.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join12.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join12.q.out Sat Jan 24 01:58:01 2009
@@ -39,7 +39,7 @@
                     type: string
               Filter Operator
                 predicate:
-                    expr: (0 < 100)
+                    expr: (UDFToDouble(0) < UDFToDouble(100))
                     type: boolean
                 Reduce Output Operator
                   key expressions:
@@ -64,7 +64,7 @@
                     type: string
               Filter Operator
                 predicate:
-                    expr: (0 < 80)
+                    expr: (UDFToDouble(0) < UDFToDouble(80))
                     type: boolean
                 Reduce Output Operator
                   key expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out Sat Jan 24 01:58:01 2009
@@ -40,7 +40,7 @@
                     type: string
               Filter Operator
                 predicate:
-                    expr: (0 < 100)
+                    expr: (UDFToDouble(0) < UDFToDouble(100))
                     type: boolean
                 Reduce Output Operator
                   key expressions:
@@ -101,7 +101,7 @@
                     type: string
               Filter Operator
                 predicate:
-                    expr: (0 < 200)
+                    expr: (UDFToDouble(0) < UDFToDouble(200))
                     type: boolean
                 Reduce Output Operator
                   key expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join14.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join14.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join14.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join14.q.out Sat Jan 24 01:58:01 2009
@@ -45,7 +45,7 @@
                     type: string
               Filter Operator
                 predicate:
-                    expr: (0 > 100)
+                    expr: (UDFToDouble(0) > UDFToDouble(100))
                     type: boolean
                 Reduce Output Operator
                   key expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join16.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join16.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join16.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join16.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         subq:a 
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (UDFToDouble(key) > UDFToDouble(10))
                   type: boolean
               Select Operator
                 expressions:
@@ -22,7 +22,7 @@
                       type: string
                 Filter Operator
                   predicate:
-                      expr: (0 > 20)
+                      expr: (UDFToDouble(0) > UDFToDouble(20))
                       type: boolean
                   Reduce Output Operator
                     key expressions:
@@ -70,7 +70,7 @@
             1 {VALUE.0} {VALUE.1}
           Filter Operator
             predicate:
-                expr: (3 < 200)
+                expr: (UDFToDouble(3) < UDFToDouble(200))
                 type: boolean
             Select Operator
               expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         c:b:src2 
             Filter Operator
               predicate:
-                  expr: ((key > 15) and (key < 25))
+                  expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
                   type: boolean
               Select Operator
                 expressions:
@@ -37,7 +37,7 @@
         c:a:src1 
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         c:b:src2 
             Filter Operator
               predicate:
-                  expr: ((key > 15) and (key < 25))
+                  expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
                   type: boolean
               Select Operator
                 expressions:
@@ -37,7 +37,7 @@
         c:a:src1 
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         c:b:src2 
             Filter Operator
               predicate:
-                  expr: ((key > 15) and (key < 25))
+                  expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
                   type: boolean
               Select Operator
                 expressions:
@@ -37,7 +37,7 @@
         c:a:src1 
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         c:b:src2 
             Filter Operator
               predicate:
-                  expr: ((key > 15) and (key < 25))
+                  expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
                   type: boolean
               Select Operator
                 expressions:
@@ -37,7 +37,7 @@
         c:a:src1 
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
                   type: boolean
               Select Operator
                 expressions:
@@ -62,7 +62,7 @@
         c:c:src3 
             Filter Operator
               predicate:
-                  expr: ((key > 20) and (key < 25))
+                  expr: ((UDFToDouble(key) > UDFToDouble(20)) and (UDFToDouble(key) < UDFToDouble(25)))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         c:b:src2 
             Filter Operator
               predicate:
-                  expr: ((key > 15) and (key < 25))
+                  expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
                   type: boolean
               Select Operator
                 expressions:
@@ -37,7 +37,7 @@
         c:a:src1 
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out Sat Jan 24 01:58:01 2009
@@ -18,7 +18,7 @@
                     type: string
               Filter Operator
                 predicate:
-                    expr: (1 < 100)
+                    expr: (UDFToDouble(1) < UDFToDouble(100))
                     type: boolean
                 Select Operator
                   expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out Sat Jan 24 01:58:01 2009
@@ -17,7 +17,7 @@
                     type: string
               Filter Operator
                 predicate:
-                    expr: (0 < 100)
+                    expr: (UDFToDouble(0) < UDFToDouble(100))
                     type: boolean
                 Reduce Output Operator
                   key expressions:
@@ -49,7 +49,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /tmp/hive-zshao/10020404/161743246.10001 
+        /data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/562761632/249466954.10001 
           Reduce Output Operator
             key expressions:
                   expr: 0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out Sat Jan 24 01:58:01 2009
@@ -17,7 +17,7 @@
                     type: string
               Filter Operator
                 predicate:
-                    expr: (0 < 100)
+                    expr: (UDFToDouble(0) < UDFToDouble(100))
                     type: boolean
                 Reduce Output Operator
                   key expressions:
@@ -49,7 +49,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /tmp/hive-zshao/55994326/602553370.10001 
+        /data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/903914190/338096343.10001 
           Reduce Output Operator
             key expressions:
                   expr: 0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         src 
             Filter Operator
               predicate:
-                  expr: ((key >= 200) and (key < 300))
+                  expr: ((UDFToDouble(key) >= UDFToDouble(200)) and (UDFToDouble(key) < UDFToDouble(300)))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample7.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample7.q.out Sat Jan 24 01:58:01 2009
@@ -16,7 +16,7 @@
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: (key > 100)
+                    expr: (UDFToDouble(key) > UDFToDouble(100))
                     type: boolean
                 Select Operator
                   expressions:
@@ -32,7 +32,7 @@
                           type: string
                     File Output Operator
                       compressed: false
-                      directory: /tmp/hive-zshao/444520495/211065154.10000.insclause-0
+                      directory: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/390012861/922014023.10000.insclause-0
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
                           output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -45,14 +45,14 @@
                             serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                             file.inputformat org.apache.hadoop.mapred.TextInputFormat
                             file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                            location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+                            location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1
                           serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                           name: dest1
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcbucket/kv1.txt 
+        file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcbucket/kv1.txt 
       Path -> Partition:
-        file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcbucket/kv1.txt 
+        file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcbucket/kv1.txt 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -67,7 +67,7 @@
                 serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcbucket
+                location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcbucket
               serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
               name: srcbucket
 
@@ -75,7 +75,7 @@
     Move Operator
       tables:
             replace: true
-            source: /tmp/hive-zshao/444520495/211065154.10000.insclause-0
+            source: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/390012861/922014023.10000.insclause-0
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -88,7 +88,7 @@
                   serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat
                   file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                  location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+                  location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1
                 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
                 name: dest1
 

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/subq.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/subq.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/subq.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/subq.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         unioninput:src 
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (UDFToDouble(key) < UDFToDouble(100))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/subq2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/subq2.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/subq2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/subq2.q.out Sat Jan 24 01:58:01 2009
@@ -45,7 +45,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /tmp/hive-zshao/368989435/823759952.10002 
+        /data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/217677179/137363579.10002 
           Reduce Output Operator
             key expressions:
                   expr: 0
@@ -74,7 +74,7 @@
                   type: bigint
             Filter Operator
               predicate:
-                  expr: (0 >= 90)
+                  expr: (UDFToDouble(0) >= UDFToDouble(90))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf1.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf1.q.out Sat Jan 24 01:58:01 2009
@@ -16,7 +16,7 @@
                     type: string
               Filter Operator
                 predicate:
-                    expr: (0 = 86)
+                    expr: (UDFToDouble(0) = UDFToDouble(86))
                     type: boolean
                 Select Operator
                   expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out Sat Jan 24 01:58:01 2009
@@ -24,11 +24,11 @@
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: max(UDFToDouble(VALUE.0))
+                expr: max(VALUE.0)
                 expr: avg(UDFToDouble(VALUE.0))
                 expr: count(VALUE.0)
                 expr: sum(UDFToDouble(VALUE.0))
-                expr: min(UDFToDouble(VALUE.0))
+                expr: min(VALUE.0)
           mode: partial1
           File Output Operator
             compressed: false
@@ -40,13 +40,13 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /tmp/hive-zshao/546652046/1647731334.10001 
+        /data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/68854306/763012378.10001 
           Reduce Output Operator
             sort order: 
             tag: -1
             value expressions:
                   expr: 0
-                  type: double
+                  type: int
                   expr: 1
                   type: string
                   expr: 2
@@ -54,12 +54,12 @@
                   expr: 3
                   type: double
                   expr: 4
-                  type: double
+                  type: int
       Reduce Operator Tree:
         Group By Operator
           aggregations:
                 expr: max(VALUE.0)
-                expr: avg(VALUE.1)
+                expr: avg(UDFToDouble(VALUE.1))
                 expr: count(VALUE.2)
                 expr: sum(VALUE.3)
                 expr: min(VALUE.4)
@@ -73,9 +73,9 @@
                   expr: 1
                   type: double
                   expr: 4
-                  type: double
+                  type: int
                   expr: 0
-                  type: double
+                  type: int
             File Output Operator
               compressed: false
               table:

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union.q.out?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union.q.out Sat Jan 24 01:58:01 2009
@@ -12,7 +12,7 @@
         null-subquery1:unioninput-subquery1:src 
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (UDFToDouble(key) < UDFToDouble(100))
                   type: boolean
               Select Operator
                 expressions:
@@ -34,7 +34,7 @@
         null-subquery2:unioninput-subquery2:src 
             Filter Operator
               predicate:
-                  expr: (key > 100)
+                  expr: (UDFToDouble(key) > UDFToDouble(100))
                   type: boolean
               Select Operator
                 expressions:

Modified: hadoop/hive/trunk/ql/src/test/results/compiler/plan/cast1.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/compiler/plan/cast1.q.xml?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/compiler/plan/cast1.q.xml (original)
+++ hadoop/hive/trunk/ql/src/test/results/compiler/plan/cast1.q.xml Sat Jan 24 01:58:01 2009
@@ -30,7 +30,7 @@
                         <void property="conf"> 
                          <object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc"> 
                           <void property="dirName"> 
-                           <string>/tmp/hive-njain/802827123.10001.insclause-0</string> 
+                           <string>/data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/1339188432.10001.insclause-0</string> 
                           </void> 
                           <void property="tableInfo"> 
                            <object class="org.apache.hadoop.hive.ql.plan.tableDesc"> 
@@ -569,14 +569,14 @@
                      <class>org.apache.hadoop.hive.ql.udf.UDFOPEqual</class> 
                     </void> 
                     <void property="UDFMethod"> 
-                     <object class="org.apache.hadoop.hive.ql.udf.UDFBaseCompare" method="getMethod"> 
+                     <object class="org.apache.hadoop.hive.ql.udf.UDFOPEqual" method="getMethod"> 
                       <string>evaluate</string> 
                       <array class="java.lang.Class" length="2"> 
                        <void index="0"> 
-                        <class>java.lang.String</class> 
+                        <class>java.lang.Double</class> 
                        </void> 
                        <void index="1"> 
-                        <class>java.lang.Number</class> 
+                        <class>java.lang.Double</class> 
                        </void> 
                       </array> 
                      </object> 
@@ -584,26 +584,74 @@
                     <void property="children"> 
                      <object class="java.util.ArrayList"> 
                       <void method="add"> 
-                       <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-                        <void property="column"> 
-                         <string>0</string> 
+                       <object class="org.apache.hadoop.hive.ql.plan.exprNodeFuncDesc"> 
+                        <void property="UDFClass"> 
+                         <class>org.apache.hadoop.hive.ql.udf.UDFToDouble</class> 
+                        </void> 
+                        <void property="UDFMethod"> 
+                         <object class="org.apache.hadoop.hive.ql.udf.UDFToDouble" method="getMethod"> 
+                          <string>evaluate</string> 
+                          <array class="java.lang.Class" length="1"> 
+                           <void index="0"> 
+                            <class>java.lang.String</class> 
+                           </void> 
+                          </array> 
+                         </object> 
                         </void> 
-                        <void property="typeInfo"> 
-                         <object id="PrimitiveTypeInfo3" class="org.apache.hadoop.hive.ql.typeinfo.PrimitiveTypeInfo"> 
-                          <void property="primitiveClass"> 
-                           <class>java.lang.String</class> 
+                        <void property="children"> 
+                         <object class="java.util.ArrayList"> 
+                          <void method="add"> 
+                           <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+                            <void property="column"> 
+                             <string>0</string> 
+                            </void> 
+                            <void property="typeInfo"> 
+                             <object id="PrimitiveTypeInfo3" class="org.apache.hadoop.hive.ql.typeinfo.PrimitiveTypeInfo"> 
+                              <void property="primitiveClass"> 
+                               <class>java.lang.String</class> 
+                              </void> 
+                             </object> 
+                            </void> 
+                           </object> 
                           </void> 
                          </object> 
                         </void> 
+                        <void property="typeInfo"> 
+                         <object idref="PrimitiveTypeInfo1"/> 
+                        </void> 
                        </object> 
                       </void> 
                       <void method="add"> 
-                       <object class="org.apache.hadoop.hive.ql.plan.exprNodeConstantDesc"> 
-                        <void property="typeInfo"> 
-                         <object idref="PrimitiveTypeInfo0"/> 
+                       <object class="org.apache.hadoop.hive.ql.plan.exprNodeFuncDesc"> 
+                        <void property="UDFClass"> 
+                         <class>org.apache.hadoop.hive.ql.udf.UDFToDouble</class> 
+                        </void> 
+                        <void property="UDFMethod"> 
+                         <object class="org.apache.hadoop.hive.ql.udf.UDFToDouble" method="getMethod"> 
+                          <string>evaluate</string> 
+                          <array class="java.lang.Class" length="1"> 
+                           <void index="0"> 
+                            <class>java.lang.Integer</class> 
+                           </void> 
+                          </array> 
+                         </object> 
+                        </void> 
+                        <void property="children"> 
+                         <object class="java.util.ArrayList"> 
+                          <void method="add"> 
+                           <object class="org.apache.hadoop.hive.ql.plan.exprNodeConstantDesc"> 
+                            <void property="typeInfo"> 
+                             <object idref="PrimitiveTypeInfo0"/> 
+                            </void> 
+                            <void property="value"> 
+                             <int>86</int> 
+                            </void> 
+                           </object> 
+                          </void> 
+                         </object> 
                         </void> 
-                        <void property="value"> 
-                         <int>86</int> 
+                        <void property="typeInfo"> 
+                         <object idref="PrimitiveTypeInfo1"/> 
                         </void> 
                        </object> 
                       </void> 
@@ -716,7 +764,7 @@
     <void property="pathToAliases"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src</string> 
+       <string>file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src</string> 
        <object class="java.util.ArrayList"> 
         <void method="add"> 
          <string>src</string> 
@@ -728,7 +776,7 @@
     <void property="pathToPartitionInfo"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src</string> 
+       <string>file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src</string> 
        <object class="org.apache.hadoop.hive.ql.plan.partitionDesc"> 
         <void property="partSpec"> 
          <object class="java.util.LinkedHashMap"/> 
@@ -780,7 +828,7 @@
             </void> 
             <void method="put"> 
              <string>location</string> 
-             <string>file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src</string> 
+             <string>file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src</string> 
             </void> 
            </object> 
           </void> 

Modified: hadoop/hive/trunk/ql/src/test/results/compiler/plan/groupby3.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/compiler/plan/groupby3.q.xml?rev=737291&r1=737290&r2=737291&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/compiler/plan/groupby3.q.xml (original)
+++ hadoop/hive/trunk/ql/src/test/results/compiler/plan/groupby3.q.xml Sat Jan 24 01:58:01 2009
@@ -20,7 +20,7 @@
         <void property="aliasToWork"> 
          <object class="java.util.HashMap"> 
           <void method="put"> 
-           <string>/tmp/hive-zshao/1268121/343796403.10002</string> 
+           <string>/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/39762029/165173809.10002</string> 
            <object id="ReduceSinkOperator0" class="org.apache.hadoop.hive.ql.exec.ReduceSinkOperator"> 
             <void property="conf"> 
              <object class="org.apache.hadoop.hive.ql.plan.reduceSinkDesc"> 
@@ -118,7 +118,7 @@
                    <string>3</string> 
                   </void> 
                   <void property="typeInfo"> 
-                   <object idref="PrimitiveTypeInfo1"/> 
+                   <object idref="PrimitiveTypeInfo0"/> 
                   </void> 
                  </object> 
                 </void> 
@@ -128,7 +128,7 @@
                    <string>4</string> 
                   </void> 
                   <void property="typeInfo"> 
-                   <object idref="PrimitiveTypeInfo1"/> 
+                   <object idref="PrimitiveTypeInfo0"/> 
                   </void> 
                  </object> 
                 </void> 
@@ -153,7 +153,7 @@
                   </void> 
                   <void method="put"> 
                    <string>serialization.ddl</string> 
-                   <string>struct binary_table { string reducesinkvalue0, double reducesinkvalue1, string reducesinkvalue2, double reducesinkvalue3, double reducesinkvalue4}</string> 
+                   <string>struct binary_table { string reducesinkvalue0, double reducesinkvalue1, string reducesinkvalue2, string reducesinkvalue3, string reducesinkvalue4}</string> 
                   </void> 
                   <void method="put"> 
                    <string>serialization.format</string> 
@@ -176,7 +176,7 @@
                     <void property="conf"> 
                      <object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc"> 
                       <void property="dirName"> 
-                       <string>/tmp/hive-zshao/1268121/343796403.10002</string> 
+                       <string>/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/39762029/165173809.10002</string> 
                       </void> 
                       <void property="tableInfo"> 
                        <object id="tableDesc2" class="org.apache.hadoop.hive.ql.plan.tableDesc"> 
@@ -197,7 +197,7 @@
                           </void> 
                           <void method="put"> 
                            <string>serialization.ddl</string> 
-                           <string>struct binary_table { string temporarycol0, double temporarycol1, string temporarycol2, double temporarycol3, double temporarycol4}</string> 
+                           <string>struct binary_table { string temporarycol0, double temporarycol1, string temporarycol2, string temporarycol3, string temporarycol4}</string> 
                           </void> 
                           <void method="put"> 
                            <string>serialization.format</string> 
@@ -256,7 +256,7 @@
                            <string>3</string> 
                           </void> 
                           <void property="type"> 
-                           <object idref="PrimitiveTypeInfo1"/> 
+                           <object idref="PrimitiveTypeInfo0"/> 
                           </void> 
                          </object> 
                         </void> 
@@ -266,7 +266,7 @@
                            <string>4</string> 
                           </void> 
                           <void property="type"> 
-                           <object idref="PrimitiveTypeInfo1"/> 
+                           <object idref="PrimitiveTypeInfo0"/> 
                           </void> 
                          </object> 
                         </void> 
@@ -423,41 +423,17 @@
                     <void method="add"> 
                      <object class="org.apache.hadoop.hive.ql.plan.aggregationDesc"> 
                       <void property="aggregationClass"> 
-                       <class>org.apache.hadoop.hive.ql.udf.UDAFMin</class> 
+                       <class>org.apache.hadoop.hive.ql.udf.UDAFMin$MinStringEvaluator</class> 
                       </void> 
                       <void property="parameters"> 
                        <object class="java.util.ArrayList"> 
                         <void method="add"> 
-                         <object class="org.apache.hadoop.hive.ql.plan.exprNodeFuncDesc"> 
-                          <void property="UDFClass"> 
-                           <class>org.apache.hadoop.hive.ql.udf.UDFToDouble</class> 
-                          </void> 
-                          <void property="UDFMethod"> 
-                           <object class="org.apache.hadoop.hive.ql.udf.UDFToDouble" method="getMethod"> 
-                            <string>evaluate</string> 
-                            <array class="java.lang.Class" length="1"> 
-                             <void index="0"> 
-                              <class>java.lang.String</class> 
-                             </void> 
-                            </array> 
-                           </object> 
-                          </void> 
-                          <void property="children"> 
-                           <object class="java.util.ArrayList"> 
-                            <void method="add"> 
-                             <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-                              <void property="column"> 
-                               <string>KEY.0</string> 
-                              </void> 
-                              <void property="typeInfo"> 
-                               <object idref="PrimitiveTypeInfo0"/> 
-                              </void> 
-                             </object> 
-                            </void> 
-                           </object> 
+                         <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+                          <void property="column"> 
+                           <string>KEY.0</string> 
                           </void> 
                           <void property="typeInfo"> 
-                           <object idref="PrimitiveTypeInfo1"/> 
+                           <object idref="PrimitiveTypeInfo0"/> 
                           </void> 
                          </object> 
                         </void> 
@@ -468,41 +444,17 @@
                     <void method="add"> 
                      <object class="org.apache.hadoop.hive.ql.plan.aggregationDesc"> 
                       <void property="aggregationClass"> 
-                       <class>org.apache.hadoop.hive.ql.udf.UDAFMax</class> 
+                       <class>org.apache.hadoop.hive.ql.udf.UDAFMax$MaxStringEvaluator</class> 
                       </void> 
                       <void property="parameters"> 
                        <object class="java.util.ArrayList"> 
                         <void method="add"> 
-                         <object class="org.apache.hadoop.hive.ql.plan.exprNodeFuncDesc"> 
-                          <void property="UDFClass"> 
-                           <class>org.apache.hadoop.hive.ql.udf.UDFToDouble</class> 
-                          </void> 
-                          <void property="UDFMethod"> 
-                           <object class="org.apache.hadoop.hive.ql.udf.UDFToDouble" method="getMethod"> 
-                            <string>evaluate</string> 
-                            <array class="java.lang.Class" length="1"> 
-                             <void index="0"> 
-                              <class>java.lang.String</class> 
-                             </void> 
-                            </array> 
-                           </object> 
-                          </void> 
-                          <void property="children"> 
-                           <object class="java.util.ArrayList"> 
-                            <void method="add"> 
-                             <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-                              <void property="column"> 
-                               <string>KEY.0</string> 
-                              </void> 
-                              <void property="typeInfo"> 
-                               <object idref="PrimitiveTypeInfo0"/> 
-                              </void> 
-                             </object> 
-                            </void> 
-                           </object> 
+                         <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+                          <void property="column"> 
+                           <string>KEY.0</string> 
                           </void> 
                           <void property="typeInfo"> 
-                           <object idref="PrimitiveTypeInfo1"/> 
+                           <object idref="PrimitiveTypeInfo0"/> 
                           </void> 
                          </object> 
                         </void> 
@@ -822,7 +774,7 @@
                    <string>VALUE.3</string> 
                   </void> 
                   <void property="type"> 
-                   <object idref="PrimitiveTypeInfo1"/> 
+                   <object idref="PrimitiveTypeInfo0"/> 
                   </void> 
                  </object> 
                 </void> 
@@ -832,7 +784,7 @@
                    <string>VALUE.4</string> 
                   </void> 
                   <void property="type"> 
-                   <object idref="PrimitiveTypeInfo1"/> 
+                   <object idref="PrimitiveTypeInfo0"/> 
                   </void> 
                  </object> 
                 </void> 
@@ -853,10 +805,10 @@
         <void property="pathToAliases"> 
          <object class="java.util.LinkedHashMap"> 
           <void method="put"> 
-           <string>/tmp/hive-zshao/1268121/343796403.10002</string> 
+           <string>/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/39762029/165173809.10002</string> 
            <object class="java.util.ArrayList"> 
             <void method="add"> 
-             <string>/tmp/hive-zshao/1268121/343796403.10002</string> 
+             <string>/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/39762029/165173809.10002</string> 
             </void> 
            </object> 
           </void> 
@@ -865,7 +817,7 @@
         <void property="pathToPartitionInfo"> 
          <object class="java.util.LinkedHashMap"> 
           <void method="put"> 
-           <string>/tmp/hive-zshao/1268121/343796403.10002</string> 
+           <string>/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/39762029/165173809.10002</string> 
            <object class="org.apache.hadoop.hive.ql.plan.partitionDesc"> 
             <void property="tableDesc"> 
              <object idref="tableDesc2"/> 
@@ -887,7 +839,7 @@
                   <void property="conf"> 
                    <object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc"> 
                     <void property="dirName"> 
-                     <string>/tmp/hive-zshao/147248168.10001.insclause-0</string> 
+                     <string>/data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/579206814.10001.insclause-0</string> 
                     </void> 
                     <void property="tableInfo"> 
                      <object class="org.apache.hadoop.hive.ql.plan.tableDesc"> 
@@ -963,7 +915,7 @@
                          <string>3</string> 
                         </void> 
                         <void property="type"> 
-                         <object idref="PrimitiveTypeInfo1"/> 
+                         <object idref="PrimitiveTypeInfo0"/> 
                         </void> 
                        </object> 
                       </void> 
@@ -973,7 +925,7 @@
                          <string>4</string> 
                         </void> 
                         <void property="type"> 
-                         <object idref="PrimitiveTypeInfo1"/> 
+                         <object idref="PrimitiveTypeInfo0"/> 
                         </void> 
                        </object> 
                       </void> 
@@ -1025,7 +977,7 @@
                      <string>4</string> 
                     </void> 
                     <void property="typeInfo"> 
-                     <object idref="PrimitiveTypeInfo1"/> 
+                     <object idref="PrimitiveTypeInfo0"/> 
                     </void> 
                    </object> 
                   </void> 
@@ -1035,7 +987,7 @@
                      <string>3</string> 
                     </void> 
                     <void property="typeInfo"> 
-                     <object idref="PrimitiveTypeInfo1"/> 
+                     <object idref="PrimitiveTypeInfo0"/> 
                     </void> 
                    </object> 
                   </void> 
@@ -1073,12 +1025,36 @@
                 <void property="parameters"> 
                  <object class="java.util.ArrayList"> 
                   <void method="add"> 
-                   <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-                    <void property="column"> 
-                     <string>VALUE.0</string> 
+                   <object class="org.apache.hadoop.hive.ql.plan.exprNodeFuncDesc"> 
+                    <void property="UDFClass"> 
+                     <class>org.apache.hadoop.hive.ql.udf.UDFToDouble</class> 
+                    </void> 
+                    <void property="UDFMethod"> 
+                     <object class="org.apache.hadoop.hive.ql.udf.UDFToDouble" method="getMethod"> 
+                      <string>evaluate</string> 
+                      <array class="java.lang.Class" length="1"> 
+                       <void index="0"> 
+                        <class>java.lang.String</class> 
+                       </void> 
+                      </array> 
+                     </object> 
+                    </void> 
+                    <void property="children"> 
+                     <object class="java.util.ArrayList"> 
+                      <void method="add"> 
+                       <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+                        <void property="column"> 
+                         <string>VALUE.0</string> 
+                        </void> 
+                        <void property="typeInfo"> 
+                         <object idref="PrimitiveTypeInfo0"/> 
+                        </void> 
+                       </object> 
+                      </void> 
+                     </object> 
                     </void> 
                     <void property="typeInfo"> 
-                     <object idref="PrimitiveTypeInfo0"/> 
+                     <object idref="PrimitiveTypeInfo1"/> 
                     </void> 
                    </object> 
                   </void> 
@@ -1115,12 +1091,36 @@
                 <void property="parameters"> 
                  <object class="java.util.ArrayList"> 
                   <void method="add"> 
-                   <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-                    <void property="column"> 
-                     <string>VALUE.2</string> 
+                   <object class="org.apache.hadoop.hive.ql.plan.exprNodeFuncDesc"> 
+                    <void property="UDFClass"> 
+                     <class>org.apache.hadoop.hive.ql.udf.UDFToDouble</class> 
+                    </void> 
+                    <void property="UDFMethod"> 
+                     <object class="org.apache.hadoop.hive.ql.udf.UDFToDouble" method="getMethod"> 
+                      <string>evaluate</string> 
+                      <array class="java.lang.Class" length="1"> 
+                       <void index="0"> 
+                        <class>java.lang.String</class> 
+                       </void> 
+                      </array> 
+                     </object> 
+                    </void> 
+                    <void property="children"> 
+                     <object class="java.util.ArrayList"> 
+                      <void method="add"> 
+                       <object class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+                        <void property="column"> 
+                         <string>VALUE.2</string> 
+                        </void> 
+                        <void property="typeInfo"> 
+                         <object idref="PrimitiveTypeInfo0"/> 
+                        </void> 
+                       </object> 
+                      </void> 
+                     </object> 
                     </void> 
                     <void property="typeInfo"> 
-                     <object idref="PrimitiveTypeInfo0"/> 
+                     <object idref="PrimitiveTypeInfo1"/> 
                     </void> 
                    </object> 
                   </void> 
@@ -1131,7 +1131,7 @@
               <void method="add"> 
                <object class="org.apache.hadoop.hive.ql.plan.aggregationDesc"> 
                 <void property="aggregationClass"> 
-                 <class>org.apache.hadoop.hive.ql.udf.UDAFMin</class> 
+                 <class>org.apache.hadoop.hive.ql.udf.UDAFMin$MinStringEvaluator</class> 
                 </void> 
                 <void property="parameters"> 
                  <object class="java.util.ArrayList"> 
@@ -1141,7 +1141,7 @@
                      <string>VALUE.3</string> 
                     </void> 
                     <void property="typeInfo"> 
-                     <object idref="PrimitiveTypeInfo1"/> 
+                     <object idref="PrimitiveTypeInfo0"/> 
                     </void> 
                    </object> 
                   </void> 
@@ -1152,7 +1152,7 @@
               <void method="add"> 
                <object class="org.apache.hadoop.hive.ql.plan.aggregationDesc"> 
                 <void property="aggregationClass"> 
-                 <class>org.apache.hadoop.hive.ql.udf.UDAFMax</class> 
+                 <class>org.apache.hadoop.hive.ql.udf.UDAFMax$MaxStringEvaluator</class> 
                 </void> 
                 <void property="parameters"> 
                  <object class="java.util.ArrayList"> 
@@ -1162,7 +1162,7 @@
                      <string>VALUE.4</string> 
                     </void> 
                     <void property="typeInfo"> 
-                     <object idref="PrimitiveTypeInfo1"/> 
+                     <object idref="PrimitiveTypeInfo0"/> 
                     </void> 
                    </object> 
                   </void> 
@@ -1229,7 +1229,7 @@
                  <string>3</string> 
                 </void> 
                 <void property="type"> 
-                 <object idref="PrimitiveTypeInfo1"/> 
+                 <object idref="PrimitiveTypeInfo0"/> 
                 </void> 
                </object> 
               </void> 
@@ -1239,7 +1239,7 @@
                  <string>4</string> 
                 </void> 
                 <void property="type"> 
-                 <object idref="PrimitiveTypeInfo1"/> 
+                 <object idref="PrimitiveTypeInfo0"/> 
                 </void> 
                </object> 
               </void> 
@@ -1281,7 +1281,7 @@
     <void property="pathToAliases"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src</string> 
+       <string>file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src</string> 
        <object class="java.util.ArrayList"> 
         <void method="add"> 
          <string>src</string> 
@@ -1293,7 +1293,7 @@
     <void property="pathToPartitionInfo"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src</string> 
+       <string>file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src</string> 
        <object class="org.apache.hadoop.hive.ql.plan.partitionDesc"> 
         <void property="partSpec"> 
          <object class="java.util.LinkedHashMap"/> 
@@ -1345,7 +1345,7 @@
             </void> 
             <void method="put"> 
              <string>location</string> 
-             <string>file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src</string> 
+             <string>file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src</string> 
             </void> 
            </object> 
           </void>