hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sd...@apache.org
Subject svn commit: r1238175 [3/4] - in /hive/trunk: contrib/src/test/results/clientpositive/ data/files/ ql/src/java/org/apache/hadoop/hive/ql/parse/ ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/ ql/src/test/results/compiler/plan/
Date Tue, 31 Jan 2012 06:39:47 GMT
Modified: hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out Tue Jan 31 06:39:43 2012
@@ -30,13 +30,13 @@ POSTHOOK: query: CREATE TABLE db2.destin
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: db2@destinTable
 PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
 POSTHOOK: type: QUERY
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME db1 sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME db2 destinTable) (TOK_PARTSPEC (TOK_PARTVAL ds '2011-11-11')))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '2011-11-11')) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL one))) (TOK_LIMIT 5)))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME db1 sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME db2 destinTable) (TOK_PARTSPEC (TOK_PARTVAL ds '2011-11-11')))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '2011-11-11')) (TOK_ORDERBY (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL one)) (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL two))) (TOK_LIMIT 5)))
 
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
@@ -62,7 +62,9 @@ STAGE PLANS:
                 key expressions:
                       expr: _col0
                       type: string
-                sort order: +
+                      expr: _col1
+                      type: string
+                sort order: --
                 tag: -1
                 value expressions:
                       expr: _col0
@@ -87,7 +89,9 @@ STAGE PLANS:
               key expressions:
                     expr: _col0
                     type: string
-              sort order: +
+                    expr: _col1
+                    type: string
+              sort order: --
               tag: -1
               value expressions:
                     expr: _col0
@@ -123,42 +127,42 @@ STAGE PLANS:
 
 
 PREHOOK: query: INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
 PREHOOK: type: QUERY
 PREHOOK: Input: db1@sourcetable@ds=2011-11-11
 PREHOOK: Output: db2@destintable@ds=2011-11-11
 POSTHOOK: query: INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
 POSTHOOK: type: QUERY
 POSTHOOK: Input: db1@sourcetable@ds=2011-11-11
 POSTHOOK: Output: db2@destintable@ds=2011-11-11
 POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).one SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:one, type:string, comment:null), ]
 POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
-PREHOOK: query: select one,two from db2.destinTable
+PREHOOK: query: select one,two from db2.destinTable order by one desc, two desc
 PREHOOK: type: QUERY
 PREHOOK: Input: db2@destintable@ds=2011-11-11
 #### A masked pattern was here ####
-POSTHOOK: query: select one,two from db2.destinTable
+POSTHOOK: query: select one,two from db2.destinTable order by one desc, two desc
 POSTHOOK: type: QUERY
 POSTHOOK: Input: db2@destintable@ds=2011-11-11
 #### A masked pattern was here ####
 POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).one SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:one, type:string, comment:null), ]
 POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
-	
-	
-	val_27
-	val_165
-	val_409
+98	val_98
+98	val_98
+98	val_98
+97	val_97
+97	val_97
 PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
 POSTHOOK: type: QUERY
 POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).one SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:one, type:string, comment:null), ]
 POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME db1 sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME db2 destinTable) (TOK_PARTSPEC (TOK_PARTVAL ds '2011-11-11')))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '2011-11-11')) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL one))) (TOK_LIMIT 5)))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME db1 sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME db2 destinTable) (TOK_PARTSPEC (TOK_PARTVAL ds '2011-11-11')))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '2011-11-11')) (TOK_ORDERBY (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL one)) (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL two))) (TOK_LIMIT 5)))
 
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
@@ -184,7 +188,9 @@ STAGE PLANS:
                 key expressions:
                       expr: _col0
                       type: string
-                sort order: +
+                      expr: _col1
+                      type: string
+                sort order: --
                 tag: -1
                 value expressions:
                       expr: _col0
@@ -209,7 +215,9 @@ STAGE PLANS:
               key expressions:
                     expr: _col0
                     type: string
-              sort order: +
+                    expr: _col1
+                    type: string
+              sort order: --
               tag: -1
               value expressions:
                     expr: _col0
@@ -245,12 +253,12 @@ STAGE PLANS:
 
 
 PREHOOK: query: INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
 PREHOOK: type: QUERY
 PREHOOK: Input: db1@sourcetable@ds=2011-11-11
 PREHOOK: Output: db2@destintable@ds=2011-11-11
 POSTHOOK: query: INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
 POSTHOOK: type: QUERY
 POSTHOOK: Input: db1@sourcetable@ds=2011-11-11
 POSTHOOK: Output: db2@destintable@ds=2011-11-11
@@ -258,11 +266,11 @@ POSTHOOK: Lineage: destintable PARTITION
 POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
 POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).one SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:one, type:string, comment:null), ]
 POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
-PREHOOK: query: select one,two from db2.destinTable
+PREHOOK: query: select one,two from db2.destinTable order by one desc, two desc
 PREHOOK: type: QUERY
 PREHOOK: Input: db2@destintable@ds=2011-11-11
 #### A masked pattern was here ####
-POSTHOOK: query: select one,two from db2.destinTable
+POSTHOOK: query: select one,two from db2.destinTable order by one desc, two desc
 POSTHOOK: type: QUERY
 POSTHOOK: Input: db2@destintable@ds=2011-11-11
 #### A masked pattern was here ####
@@ -270,11 +278,11 @@ POSTHOOK: Lineage: destintable PARTITION
 POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
 POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).one SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:one, type:string, comment:null), ]
 POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
-	
-	
-	val_27
-	val_165
-	val_409
+98	val_98
+98	val_98
+98	val_98
+97	val_97
+97	val_97
 PREHOOK: query: drop table db2.destinTable
 PREHOOK: type: DROPTABLE
 POSTHOOK: query: drop table db2.destinTable

Modified: hive/trunk/ql/src/test/results/clientpositive/join0.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join0.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join0.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join0.q.out Tue Jan 31 06:39:43 2012
@@ -31,7 +31,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -53,7 +53,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join11.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join11.q.out Tue Jan 31 06:39:43 2012
@@ -30,7 +30,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join12.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join12.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join12.q.out Tue Jan 31 06:39:43 2012
@@ -36,7 +36,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -82,7 +82,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 80)
+                  expr: (key < 80.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join13.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join13.q.out Tue Jan 31 06:39:43 2012
@@ -37,7 +37,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -119,7 +119,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 200)
+                  expr: (key < 200.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join14.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join14.q.out Tue Jan 31 06:39:43 2012
@@ -28,7 +28,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key > 100)
+                  expr: (key > 100.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join16.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join16.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join16.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join16.q.out Tue Jan 31 06:39:43 2012
@@ -18,7 +18,7 @@ STAGE PLANS:
             alias: a
             Filter Operator
               predicate:
-                  expr: (((key > 10) and (key > 20)) and (value < 200))
+                  expr: (((key > 10.0) and (key > 20.0)) and (value < 200.0))
                   type: boolean
               Select Operator
                 expressions:
@@ -48,7 +48,7 @@ STAGE PLANS:
             alias: tab
             Filter Operator
               predicate:
-                  expr: (value < 200)
+                  expr: (value < 200.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join20.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join20.q.out Tue Jan 31 06:39:43 2012
@@ -23,7 +23,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -85,7 +85,7 @@ STAGE PLANS:
           filter predicates:
             0 
             1 
-            2 {(VALUE._col0 < 20)}
+            2 {(VALUE._col0 < 20.0)}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
           Select Operator
@@ -740,7 +740,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -761,7 +761,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key < 15)
+                  expr: (key < 15.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -806,7 +806,7 @@ STAGE PLANS:
           filter predicates:
             0 
             1 
-            2 {(VALUE._col0 < 20)}
+            2 {(VALUE._col0 < 20.0)}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
           Select Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/join21.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join21.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join21.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join21.q.out Tue Jan 31 06:39:43 2012
@@ -38,7 +38,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -81,9 +81,9 @@ STAGE PLANS:
             1 {VALUE._col0} {VALUE._col1}
             2 {VALUE._col0} {VALUE._col1}
           filter predicates:
-            0 {(VALUE._col0 < 10)}
+            0 {(VALUE._col0 < 10.0)}
             1 
-            2 {(VALUE._col0 < 10)}
+            2 {(VALUE._col0 < 10.0)}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
           Select Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/join23.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join23.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join23.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join23.q.out Tue Jan 31 06:39:43 2012
@@ -21,7 +21,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 sort order: 
@@ -36,7 +36,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 sort order: 

Modified: hive/trunk/ql/src/test/results/clientpositive/join34.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join34.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join34.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join34.q.out Tue Jan 31 06:39:43 2012
@@ -67,7 +67,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: (key < 20)
+                  expr: (key < 20.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -138,7 +138,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: (key > 100)
+                  expr: (key > 100.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join35.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join35.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join35.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join35.q.out Tue Jan 31 06:39:43 2012
@@ -48,7 +48,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: (key < 20)
+                  expr: (key < 20.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -451,7 +451,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: (key > 100)
+                  expr: (key > 100.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join38.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join38.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join38.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join38.q.out Tue Jan 31 06:39:43 2012
@@ -91,7 +91,7 @@ STAGE PLANS:
             alias: a
             Filter Operator
               predicate:
-                  expr: (key = 111)
+                  expr: (key = 111.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -111,7 +111,7 @@ STAGE PLANS:
             alias: b
             Filter Operator
               predicate:
-                  expr: (col11 = 111)
+                  expr: (col11 = 111.0)
                   type: boolean
               Map Join Operator
                 condition map:

Modified: hive/trunk/ql/src/test/results/clientpositive/join39.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join39.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join39.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join39.q.out Tue Jan 31 06:39:43 2012
@@ -38,7 +38,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key <= 100)
+                  expr: (key <= 100.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join4.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join4.q.out Tue Jan 31 06:39:43 2012
@@ -50,7 +50,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Select Operator
                 expressions:
@@ -78,7 +78,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: ((key > 15) and (key < 25))
+                  expr: ((key > 15.0) and (key < 25.0))
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join40.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join40.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join40.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join40.q.out Tue Jan 31 06:39:43 2012
@@ -37,7 +37,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key <= 100)
+                  expr: (key <= 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -1806,7 +1806,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -1868,7 +1868,7 @@ STAGE PLANS:
           filter predicates:
             0 
             1 
-            2 {(VALUE._col0 < 20)}
+            2 {(VALUE._col0 < 20.0)}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
           Select Operator
@@ -2523,7 +2523,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -2544,7 +2544,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key < 15)
+                  expr: (key < 15.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -2589,7 +2589,7 @@ STAGE PLANS:
           filter predicates:
             0 
             1 
-            2 {(VALUE._col0 < 20)}
+            2 {(VALUE._col0 < 20.0)}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
           Select Operator
@@ -3248,7 +3248,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key <= 100)
+                  expr: (key <= 100.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join5.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join5.q.out Tue Jan 31 06:39:43 2012
@@ -50,7 +50,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Select Operator
                 expressions:
@@ -78,7 +78,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: ((key > 15) and (key < 25))
+                  expr: ((key > 15.0) and (key < 25.0))
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join6.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join6.q.out Tue Jan 31 06:39:43 2012
@@ -50,7 +50,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Select Operator
                 expressions:
@@ -78,7 +78,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: ((key > 15) and (key < 25))
+                  expr: ((key > 15.0) and (key < 25.0))
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join7.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join7.q.out Tue Jan 31 06:39:43 2012
@@ -60,7 +60,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Select Operator
                 expressions:
@@ -88,7 +88,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: ((key > 15) and (key < 25))
+                  expr: ((key > 15.0) and (key < 25.0))
                   type: boolean
               Select Operator
                 expressions:
@@ -116,7 +116,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: ((key > 20) and (key < 25))
+                  expr: ((key > 20.0) and (key < 25.0))
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join8.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join8.q.out Tue Jan 31 06:39:43 2012
@@ -50,7 +50,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (((key > 10) and (key < 20)) and key is not null)
+                  expr: (((key > 10.0) and (key < 20.0)) and key is not null)
                   type: boolean
               Select Operator
                 expressions:
@@ -78,7 +78,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (((key > 15) and (key < 25)) and key is not null)
+                  expr: (((key > 15.0) and (key < 25.0)) and key is not null)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/load_dyn_part13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part13.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/load_dyn_part13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/load_dyn_part13.q.out Tue Jan 31 06:39:43 2012
@@ -60,7 +60,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 20)
+                  expr: (key < 20.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -94,7 +94,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: ((key > 20) and (key < 40))
+                  expr: ((key > 20.0) and (key < 40.0))
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out Tue Jan 31 06:39:43 2012
@@ -34,7 +34,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -57,7 +57,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -195,7 +195,7 @@ STAGE PLANS:
           Filter Operator
             isSamplingPred: false
             predicate:
-                expr: ((_col4 > 15) and (_col4 < 25))
+                expr: ((_col4 > 15.0) and (_col4 < 25.0))
                 type: boolean
             Select Operator
               expressions:
@@ -303,7 +303,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -328,7 +328,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -543,7 +543,7 @@ STAGE PLANS:
           Filter Operator
             isSamplingPred: false
             predicate:
-                expr: ((_col6 > 15) and (_col6 < 25))
+                expr: ((_col6 > 15.0) and (_col6 < 25.0))
                 type: boolean
             Select Operator
               expressions:
@@ -655,7 +655,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -678,7 +678,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -892,7 +892,7 @@ STAGE PLANS:
           Filter Operator
             isSamplingPred: false
             predicate:
-                expr: (((_col4 > 15) and (_col4 < 25)) and (_col6 = '2008-04-08'))
+                expr: (((_col4 > 15.0) and (_col4 < 25.0)) and (_col6 = '2008-04-08'))
                 type: boolean
             Select Operator
               expressions:
@@ -1004,7 +1004,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -1029,7 +1029,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -1167,7 +1167,7 @@ STAGE PLANS:
           Filter Operator
             isSamplingPred: false
             predicate:
-                expr: ((_col6 > 15) and (_col6 < 25))
+                expr: ((_col6 > 15.0) and (_col6 < 25.0))
                 type: boolean
             Select Operator
               expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out Tue Jan 31 06:39:43 2012
@@ -37,7 +37,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -56,7 +56,7 @@ STAGE PLANS:
                       name: default.src_multi1
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Select Operator
                 expressions:
@@ -201,7 +201,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -220,7 +220,7 @@ STAGE PLANS:
                       name: default.src_multi1
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Select Operator
                 expressions:
@@ -419,7 +419,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -438,7 +438,7 @@ STAGE PLANS:
                       name: default.src_multi1
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Select Operator
                 expressions:
@@ -615,7 +615,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -634,7 +634,7 @@ STAGE PLANS:
                       name: default.src_multi1
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Select Operator
                 expressions:
@@ -865,7 +865,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: ((key < 10) or ((key > 10) and (key < 20)))
+                  expr: ((key < 10.0) or ((key > 10.0) and (key < 20.0)))
                   type: boolean
               Select Operator
                 expressions:
@@ -1118,7 +1118,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: ((key < 10) or ((key > 10) and (key < 20)))
+                  expr: ((key < 10.0) or ((key > 10.0) and (key < 20.0)))
                   type: boolean
               Select Operator
                 expressions:
@@ -1409,7 +1409,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: ((key < 10) or ((key > 10) and (key < 20)))
+                  expr: ((key < 10.0) or ((key > 10.0) and (key < 20.0)))
                   type: boolean
               Select Operator
                 expressions:
@@ -1662,7 +1662,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: ((key < 10) or ((key > 10) and (key < 20)))
+                  expr: ((key < 10.0) or ((key > 10.0) and (key < 20.0)))
                   type: boolean
               Select Operator
                 expressions:
@@ -1961,7 +1961,7 @@ STAGE PLANS:
               Union
                 Filter Operator
                   predicate:
-                      expr: (_col0 < 10)
+                      expr: (_col0 < 10.0)
                       type: boolean
                   Select Operator
                     expressions:
@@ -1980,7 +1980,7 @@ STAGE PLANS:
                           name: default.src_multi1
                 Filter Operator
                   predicate:
-                      expr: ((_col0 > 10) and (_col0 < 20))
+                      expr: ((_col0 > 10.0) and (_col0 < 20.0))
                       type: boolean
                   Select Operator
                     expressions:
@@ -2010,7 +2010,7 @@ STAGE PLANS:
               Union
                 Filter Operator
                   predicate:
-                      expr: (_col0 < 10)
+                      expr: (_col0 < 10.0)
                       type: boolean
                   Select Operator
                     expressions:
@@ -2029,7 +2029,7 @@ STAGE PLANS:
                           name: default.src_multi1
                 Filter Operator
                   predicate:
-                      expr: ((_col0 > 10) and (_col0 < 20))
+                      expr: ((_col0 > 10.0) and (_col0 < 20.0))
                       type: boolean
                   Select Operator
                     expressions:
@@ -2265,7 +2265,7 @@ STAGE PLANS:
               Union
                 Filter Operator
                   predicate:
-                      expr: (_col0 < 10)
+                      expr: (_col0 < 10.0)
                       type: boolean
                   Select Operator
                     expressions:
@@ -2284,7 +2284,7 @@ STAGE PLANS:
                           name: default.src_multi1
                 Filter Operator
                   predicate:
-                      expr: ((_col0 > 10) and (_col0 < 20))
+                      expr: ((_col0 > 10.0) and (_col0 < 20.0))
                       type: boolean
                   Select Operator
                     expressions:
@@ -2314,7 +2314,7 @@ STAGE PLANS:
               Union
                 Filter Operator
                   predicate:
-                      expr: (_col0 < 10)
+                      expr: (_col0 < 10.0)
                       type: boolean
                   Select Operator
                     expressions:
@@ -2333,7 +2333,7 @@ STAGE PLANS:
                           name: default.src_multi1
                 Filter Operator
                   predicate:
-                      expr: ((_col0 > 10) and (_col0 < 20))
+                      expr: ((_col0 > 10.0) and (_col0 < 20.0))
                       type: boolean
                   Select Operator
                     expressions:
@@ -2623,7 +2623,7 @@ STAGE PLANS:
               Union
                 Filter Operator
                   predicate:
-                      expr: (_col0 < 10)
+                      expr: (_col0 < 10.0)
                       type: boolean
                   Select Operator
                     expressions:
@@ -2642,7 +2642,7 @@ STAGE PLANS:
                           name: default.src_multi1
                 Filter Operator
                   predicate:
-                      expr: ((_col0 > 10) and (_col0 < 20))
+                      expr: ((_col0 > 10.0) and (_col0 < 20.0))
                       type: boolean
                   Select Operator
                     expressions:
@@ -2672,7 +2672,7 @@ STAGE PLANS:
               Union
                 Filter Operator
                   predicate:
-                      expr: (_col0 < 10)
+                      expr: (_col0 < 10.0)
                       type: boolean
                   Select Operator
                     expressions:
@@ -2691,7 +2691,7 @@ STAGE PLANS:
                           name: default.src_multi1
                 Filter Operator
                   predicate:
-                      expr: ((_col0 > 10) and (_col0 < 20))
+                      expr: ((_col0 > 10.0) and (_col0 < 20.0))
                       type: boolean
                   Select Operator
                     expressions:
@@ -2959,7 +2959,7 @@ STAGE PLANS:
               Union
                 Filter Operator
                   predicate:
-                      expr: (_col0 < 10)
+                      expr: (_col0 < 10.0)
                       type: boolean
                   Select Operator
                     expressions:
@@ -2978,7 +2978,7 @@ STAGE PLANS:
                           name: default.src_multi1
                 Filter Operator
                   predicate:
-                      expr: ((_col0 > 10) and (_col0 < 20))
+                      expr: ((_col0 > 10.0) and (_col0 < 20.0))
                       type: boolean
                   Select Operator
                     expressions:
@@ -3008,7 +3008,7 @@ STAGE PLANS:
               Union
                 Filter Operator
                   predicate:
-                      expr: (_col0 < 10)
+                      expr: (_col0 < 10.0)
                       type: boolean
                   Select Operator
                     expressions:
@@ -3027,7 +3027,7 @@ STAGE PLANS:
                           name: default.src_multi1
                 Filter Operator
                   predicate:
-                      expr: ((_col0 > 10) and (_col0 < 20))
+                      expr: ((_col0 > 10.0) and (_col0 < 20.0))
                       type: boolean
                   Select Operator
                     expressions:
@@ -3338,7 +3338,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key = 0)
+                  expr: (key = 0.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -3355,7 +3355,7 @@ STAGE PLANS:
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             Filter Operator
               predicate:
-                  expr: (key = 2)
+                  expr: (key = 2.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -3372,7 +3372,7 @@ STAGE PLANS:
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             Filter Operator
               predicate:
-                  expr: (key = 4)
+                  expr: (key = 4.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -3510,7 +3510,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key = 0)
+                  expr: (key = 0.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -3527,7 +3527,7 @@ STAGE PLANS:
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             Filter Operator
               predicate:
-                  expr: (key = 2)
+                  expr: (key = 2.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -3544,7 +3544,7 @@ STAGE PLANS:
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             Filter Operator
               predicate:
-                  expr: (key = 4)
+                  expr: (key = 4.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -3682,7 +3682,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key = 0)
+                  expr: (key = 0.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -3699,7 +3699,7 @@ STAGE PLANS:
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             Filter Operator
               predicate:
-                  expr: (key = 2)
+                  expr: (key = 2.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -3716,7 +3716,7 @@ STAGE PLANS:
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             Filter Operator
               predicate:
-                  expr: (key = 4)
+                  expr: (key = 4.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -3854,7 +3854,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key = 0)
+                  expr: (key = 0.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -3871,7 +3871,7 @@ STAGE PLANS:
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             Filter Operator
               predicate:
-                  expr: (key = 2)
+                  expr: (key = 2.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -3888,7 +3888,7 @@ STAGE PLANS:
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             Filter Operator
               predicate:
-                  expr: (key = 4)
+                  expr: (key = 4.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out Tue Jan 31 06:39:43 2012
@@ -18,7 +18,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 sort order: 
@@ -33,7 +33,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 sort order: 

Modified: hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out Tue Jan 31 06:39:43 2012
@@ -20,7 +20,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out Tue Jan 31 06:39:43 2012
@@ -28,7 +28,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out Tue Jan 31 06:39:43 2012
@@ -28,7 +28,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out Tue Jan 31 06:39:43 2012
@@ -20,7 +20,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key > 9999)
+                  expr: (key > 9999.0)
                   type: boolean
               Select Operator
                 Group By Operator
@@ -90,7 +90,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key > 9999)
+                  expr: (key > 9999.0)
                   type: boolean
               Select Operator
                 Group By Operator
@@ -161,7 +161,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key > 9999)
+                  expr: (key > 9999.0)
                   type: boolean
               Select Operator
                 Reduce Output Operator
@@ -252,7 +252,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key > 9999)
+                  expr: (key > 9999.0)
                   type: boolean
               Select Operator
                 Reduce Output Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out Tue Jan 31 06:39:43 2012
@@ -21,7 +21,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key > 9999)
+                  expr: (key > 9999.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -141,7 +141,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key > 9999)
+                  expr: (key > 9999.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -229,7 +229,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key > 9999)
+                  expr: (key > 9999.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -340,7 +340,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key > 9999)
+                  expr: (key > 9999.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out Tue Jan 31 06:39:43 2012
@@ -21,7 +21,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key = 9999)
+                  expr: (key = 9999.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -137,7 +137,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key = 9999)
+                  expr: (key = 9999.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -224,7 +224,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key = 9999)
+                  expr: (key = 9999.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -328,7 +328,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key = 9999)
+                  expr: (key = 9999.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out Tue Jan 31 06:39:43 2012
@@ -20,7 +20,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key = 9999)
+                  expr: (key = 9999.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -116,7 +116,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key = 9999)
+                  expr: (key = 9999.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/order2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/order2.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/order2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/order2.q.out Tue Jan 31 06:39:43 2012
@@ -45,7 +45,7 @@ STAGE PLANS:
           Limit
             Filter Operator
               predicate:
-                  expr: (_col0 < 10)
+                  expr: (_col0 < 10.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out Tue Jan 31 06:39:43 2012
@@ -264,7 +264,7 @@ STAGE PLANS:
           Filter Operator
             isSamplingPred: false
             predicate:
-                expr: ((((_col4 > 15) and (_col4 < 25)) and (_col0 > 10)) and (_col0 < 20))
+                expr: ((((_col4 > 15.0) and (_col4 < 25.0)) and (_col0 > 10.0)) and (_col0 < 20.0))
                 type: boolean
             Select Operator
               expressions:
@@ -603,7 +603,7 @@ STAGE PLANS:
           Filter Operator
             isSamplingPred: false
             predicate:
-                expr: (((((_col4 > 15) and (_col4 < 25)) and (_col6 = '2008-04-08')) and (_col0 > 10)) and (_col0 < 20))
+                expr: (((((_col4 > 15.0) and (_col4 < 25.0)) and (_col6 = '2008-04-08')) and (_col0 > 10.0)) and (_col0 < 20.0))
                 type: boolean
             Select Operator
               expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/pcr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/pcr.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/pcr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/pcr.q.out Tue Jan 31 06:39:43 2012
@@ -4624,7 +4624,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: (key = 11)
+                  expr: (key = 11.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -4825,7 +4825,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: (key = 11)
+                  expr: (key = 11.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out Tue Jan 31 06:39:43 2012
@@ -20,11 +20,11 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key = 10)
+                  expr: (key = 10.0)
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: (key = 10)
+                    expr: (key = 10.0)
                     type: boolean
                 Select Operator
                   expressions:
@@ -93,7 +93,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key = 20)
+                  expr: (key = 20.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -114,7 +114,7 @@ STAGE PLANS:
             alias: y
             Filter Operator
               predicate:
-                  expr: (key = 20)
+                  expr: (key = 20.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -139,7 +139,7 @@ STAGE PLANS:
           outputColumnNames: _col0, _col1, _col4
           Filter Operator
             predicate:
-                expr: (_col0 = 20)
+                expr: (_col0 = 20.0)
                 type: boolean
             Select Operator
               expressions:
@@ -222,7 +222,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key = 10)
+                  expr: (key = 10.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -291,7 +291,7 @@ STAGE PLANS:
             alias: x
             Filter Operator
               predicate:
-                  expr: (key = 20)
+                  expr: (key = 20.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -312,7 +312,7 @@ STAGE PLANS:
             alias: y
             Filter Operator
               predicate:
-                  expr: (key = 20)
+                  expr: (key = 20.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out Tue Jan 31 06:39:43 2012
@@ -84,7 +84,7 @@ STAGE PLANS:
           outputColumnNames: _col0, _col1
           Filter Operator
             predicate:
-                expr: (_col0 < 100)
+                expr: (_col0 < 100.0)
                 type: boolean
             Select Operator
               expressions:
@@ -110,7 +110,7 @@ STAGE PLANS:
                       name: default.mi1
           Filter Operator
             predicate:
-                expr: ((_col0 >= 100) and (_col0 < 200))
+                expr: ((_col0 >= 100.0) and (_col0 < 200.0))
                 type: boolean
             Select Operator
               expressions:
@@ -136,7 +136,7 @@ STAGE PLANS:
                       name: default.mi2
           Filter Operator
             predicate:
-                expr: ((_col0 >= 200) and (_col0 < 300))
+                expr: ((_col0 >= 200.0) and (_col0 < 300.0))
                 type: boolean
             Select Operator
               expressions:
@@ -158,7 +158,7 @@ STAGE PLANS:
                       name: default.mi3
           Filter Operator
             predicate:
-                expr: (_col0 >= 300)
+                expr: (_col0 >= 300.0)
                 type: boolean
             Select Operator
               expressions:
@@ -1391,7 +1391,7 @@ STAGE PLANS:
           outputColumnNames: _col0, _col1
           Filter Operator
             predicate:
-                expr: (_col0 < 100)
+                expr: (_col0 < 100.0)
                 type: boolean
             Select Operator
               expressions:
@@ -1417,7 +1417,7 @@ STAGE PLANS:
                       name: default.mi1
           Filter Operator
             predicate:
-                expr: ((_col0 >= 100) and (_col0 < 200))
+                expr: ((_col0 >= 100.0) and (_col0 < 200.0))
                 type: boolean
             Select Operator
               expressions:
@@ -1443,7 +1443,7 @@ STAGE PLANS:
                       name: default.mi2
           Filter Operator
             predicate:
-                expr: ((_col0 >= 200) and (_col0 < 300))
+                expr: ((_col0 >= 200.0) and (_col0 < 300.0))
                 type: boolean
             Select Operator
               expressions:
@@ -1465,7 +1465,7 @@ STAGE PLANS:
                       name: default.mi3
           Filter Operator
             predicate:
-                expr: (_col0 >= 300)
+                expr: (_col0 >= 300.0)
                 type: boolean
             Select Operator
               expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out Tue Jan 31 06:39:43 2012
@@ -32,7 +32,7 @@ STAGE PLANS:
             alias: a
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -53,7 +53,7 @@ STAGE PLANS:
             alias: b
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -80,7 +80,7 @@ STAGE PLANS:
           outputColumnNames: _col0, _col1, _col4, _col5
           Filter Operator
             predicate:
-                expr: ((((_col0 > 10) and (_col0 < 20)) and (_col4 > 15)) and (_col4 < 25))
+                expr: ((((_col0 > 10.0) and (_col0 < 20.0)) and (_col4 > 15.0)) and (_col4 < 25.0))
                 type: boolean
             Select Operator
               expressions:
@@ -165,7 +165,7 @@ STAGE PLANS:
             alias: a
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -186,7 +186,7 @@ STAGE PLANS:
             alias: b
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -213,7 +213,7 @@ STAGE PLANS:
           outputColumnNames: _col0, _col1, _col4, _col5
           Filter Operator
             predicate:
-                expr: ((_col4 > 15) and (_col4 < 25))
+                expr: ((_col4 > 15.0) and (_col4 < 25.0))
                 type: boolean
             Select Operator
               expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out Tue Jan 31 06:39:43 2012
@@ -60,7 +60,7 @@ STAGE PLANS:
         Extract
           Filter Operator
             predicate:
-                expr: (_col0 < 100)
+                expr: (_col0 < 100.0)
                 type: boolean
             Select Operator
               expressions:
@@ -231,7 +231,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 Filter Operator
                   predicate:
-                      expr: (_col0 < 100)
+                      expr: (_col0 < 100.0)
                       type: boolean
                   Reduce Output Operator
                     key expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out Tue Jan 31 06:39:43 2012
@@ -24,11 +24,11 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key = 100)
+                  expr: (key = 100.0)
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: (key = 100)
+                    expr: (key = 100.0)
                     type: boolean
                 Select Operator
                   expressions:
@@ -90,11 +90,11 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key = 100)
+                  expr: (key = 100.0)
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: (key = 100)
+                    expr: (key = 100.0)
                     type: boolean
                 Select Operator
                   expressions:
@@ -164,11 +164,11 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key = 100)
+                  expr: (key = 100.0)
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: (key = 100)
+                    expr: (key = 100.0)
                     type: boolean
                 Select Operator
                   expressions:
@@ -181,7 +181,7 @@ STAGE PLANS:
                   outputColumnNames: _col0, _col2, _col3
                   Filter Operator
                     predicate:
-                        expr: (_col3 <= 3)
+                        expr: (_col3 <= 3.0)
                         type: boolean
                     Select Operator
                       expressions:
@@ -230,11 +230,11 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key = 100)
+                  expr: (key = 100.0)
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: (key = 100)
+                    expr: (key = 100.0)
                     type: boolean
                 Select Operator
                   expressions:
@@ -247,7 +247,7 @@ STAGE PLANS:
                   outputColumnNames: _col0, _col2, _col3
                   Filter Operator
                     predicate:
-                        expr: (_col3 <= 200)
+                        expr: (_col3 <= 200.0)
                         type: boolean
                     Select Operator
                       expressions:
@@ -296,7 +296,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key = 100)
+                  expr: (key = 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -358,7 +358,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key = 100)
+                  expr: (key = 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -424,7 +424,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key = 100)
+                  expr: (key = 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -437,7 +437,7 @@ STAGE PLANS:
                 outputColumnNames: _col0, _col2, _col3
                 Filter Operator
                   predicate:
-                      expr: (_col3 <= 3)
+                      expr: (_col3 <= 3.0)
                       type: boolean
                   Select Operator
                     expressions:
@@ -486,7 +486,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key = 100)
+                  expr: (key = 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -499,7 +499,7 @@ STAGE PLANS:
                 outputColumnNames: _col0, _col2, _col3
                 Filter Operator
                   predicate:
-                      expr: (_col3 <= 200)
+                      expr: (_col3 <= 200.0)
                       type: boolean
                   Select Operator
                     expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown.q.out Tue Jan 31 06:39:43 2012
@@ -159,11 +159,11 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-PREHOOK: query: select * from ppr_test where ds = '1234'
+PREHOOK: query: select * from ppr_test where ds = '1234' order by key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@ppr_test@ds=1234
 #### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '1234'
+POSTHOOK: query: select * from ppr_test where ds = '1234' order by key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@ppr_test@ds=1234
 #### A masked pattern was here ####
@@ -175,13 +175,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd	1234
 1234	1234
-PREHOOK: query: select * from ppr_test where ds = '1224'
+abcd	1234
+PREHOOK: query: select * from ppr_test where ds = '1224' order by key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@ppr_test@ds=1224
 #### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '1224'
+POSTHOOK: query: select * from ppr_test where ds = '1224' order by key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@ppr_test@ds=1224
 #### A masked pattern was here ####
@@ -193,13 +193,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd	1224
 1224	1224
-PREHOOK: query: select * from ppr_test where ds = '1214'
+abcd	1224
+PREHOOK: query: select * from ppr_test where ds = '1214' order by key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@ppr_test@ds=1214
 #### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '1214'
+POSTHOOK: query: select * from ppr_test where ds = '1214' order by key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@ppr_test@ds=1214
 #### A masked pattern was here ####
@@ -211,13 +211,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd	1214
 1214	1214
-PREHOOK: query: select * from ppr_test where ds = '12.4'
+abcd	1214
+PREHOOK: query: select * from ppr_test where ds = '12.4' order by key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@ppr_test@ds=12.4
 #### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '12.4'
+POSTHOOK: query: select * from ppr_test where ds = '12.4' order by key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@ppr_test@ds=12.4
 #### A masked pattern was here ####
@@ -229,13 +229,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd	12.4
 12.4	12.4
-PREHOOK: query: select * from ppr_test where ds = '12+4'
+abcd	12.4
+PREHOOK: query: select * from ppr_test where ds = '12+4' order by key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@ppr_test@ds=12+4
 #### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '12+4'
+POSTHOOK: query: select * from ppr_test where ds = '12+4' order by key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@ppr_test@ds=12+4
 #### A masked pattern was here ####
@@ -247,13 +247,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd	12+4
 12+4	12+4
-PREHOOK: query: select * from ppr_test where ds = '12:4'
+abcd	12+4
+PREHOOK: query: select * from ppr_test where ds = '12:4' order by key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@ppr_test@ds=12%3A4
 #### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '12:4'
+POSTHOOK: query: select * from ppr_test where ds = '12:4' order by key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@ppr_test@ds=12%3A4
 #### A masked pattern was here ####
@@ -265,13 +265,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd	12:4
 12:4	12:4
-PREHOOK: query: select * from ppr_test where ds = '12%4'
+abcd	12:4
+PREHOOK: query: select * from ppr_test where ds = '12%4' order by key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@ppr_test@ds=12%254
 #### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '12%4'
+POSTHOOK: query: select * from ppr_test where ds = '12%4' order by key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@ppr_test@ds=12%254
 #### A masked pattern was here ####
@@ -283,13 +283,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd	12%4
 12%4	12%4
-PREHOOK: query: select * from ppr_test where ds = '12*4'
+abcd	12%4
+PREHOOK: query: select * from ppr_test where ds = '12*4' order by key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@ppr_test@ds=12%2A4
 #### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '12*4'
+POSTHOOK: query: select * from ppr_test where ds = '12*4' order by key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@ppr_test@ds=12%2A4
 #### A masked pattern was here ####
@@ -301,12 +301,12 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd	12*4
 12*4	12*4
-PREHOOK: query: select * from ppr_test where ds = '12.*4'
+abcd	12*4
+PREHOOK: query: select * from ppr_test where ds = '12.*4' order by key
 PREHOOK: type: QUERY
 #### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '12.*4'
+POSTHOOK: query: select * from ppr_test where ds = '12.*4' order by key
 POSTHOOK: type: QUERY
 #### A masked pattern was here ####
 POSTHOOK: Lineage: ppr_test PARTITION(ds=12%4).key EXPRESSION []

Modified: hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown3.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown3.q.out Tue Jan 31 06:39:43 2012
@@ -18,7 +18,7 @@ STAGE PLANS:
             alias: srcpart
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/quote1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/quote1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/quote1.q.out Tue Jan 31 06:39:43 2012
@@ -31,7 +31,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: ((key >= 200) and (key < 300))
+                  expr: ((key >= 200.0) and (key < 300.0))
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out Tue Jan 31 06:39:43 2012
@@ -24,7 +24,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: ((rand(1) < 0.1) and (not ((key > 50) or (key < 10))))
+                  expr: ((rand(1) < 0.1) and (not ((key > 50.0) or (key < 10.0))))
                   type: boolean
               Select Operator
                 expressions:
@@ -138,7 +138,7 @@ STAGE PLANS:
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: (not ((key > 50) or (key < 10)))
+                  expr: (not ((key > 50.0) or (key < 10.0)))
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/rcfile_null_value.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/rcfile_null_value.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/rcfile_null_value.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/rcfile_null_value.q.out Tue Jan 31 06:39:43 2012
@@ -104,7 +104,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: ((key > 10) and (key < 20))
+                  expr: ((key > 10.0) and (key < 20.0))
                   type: boolean
               Select Operator
                 expressions:
@@ -132,7 +132,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: ((key > 15) and (key < 25))
+                  expr: ((key > 15.0) and (key < 25.0))
                   type: boolean
               Select Operator
                 expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out Tue Jan 31 06:39:43 2012
@@ -214,7 +214,7 @@ STAGE PLANS:
             alias: a
             Filter Operator
               predicate:
-                  expr: (key = 103)
+                  expr: (key = 103.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:



Mime
View raw message