hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sd...@apache.org
Subject svn commit: r1238175 [1/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
Author: sdong
Date: Tue Jan 31 06:39:43 2012
New Revision: 1238175

URL: http://svn.apache.org/viewvc?rev=1238175&view=rev
Log:
HIVE-2249 When creating constant expression for numbers, try to infer type from another comparison operand, instead of trying to use integer first, and then long and double (Zhiqiu Kong via Siying Dong)

Added:
    hive/trunk/data/files/infer_const_type.txt
    hive/trunk/ql/src/test/queries/clientpositive/infer_const_type.q
    hive/trunk/ql/src/test/results/clientpositive/infer_const_type.q.out
Modified:
    hive/trunk/contrib/src/test/results/clientpositive/dboutput.q.out
    hive/trunk/contrib/src/test/results/clientpositive/serde_typedbytes4.q.out
    hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java
    hive/trunk/ql/src/test/queries/clientpositive/insert1_overwrite_partitions.q
    hive/trunk/ql/src/test/queries/clientpositive/insert2_overwrite_partitions.q
    hive/trunk/ql/src/test/queries/clientpositive/ppr_pushdown.q
    hive/trunk/ql/src/test/results/clientpositive/auto_join0.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join11.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join12.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join13.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join14.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join16.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join20.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join21.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join23.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join27.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join28.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join29.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join4.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join5.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join6.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join7.q.out
    hive/trunk/ql/src/test/results/clientpositive/auto_join8.q.out
    hive/trunk/ql/src/test/results/clientpositive/cast1.q.out
    hive/trunk/ql/src/test/results/clientpositive/cluster.q.out
    hive/trunk/ql/src/test/results/clientpositive/create_view.q.out
    hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out
    hive/trunk/ql/src/test/results/clientpositive/having.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_auto.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_auto_file_format.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_auto_multiple.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_auto_partitioned.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_auto_unused.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_auto_update.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_bitmap3.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_bitmap_compression.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_compression.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_stale.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_stale_partitioned.q.out
    hive/trunk/ql/src/test/results/clientpositive/input11.q.out
    hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out
    hive/trunk/ql/src/test/results/clientpositive/input12.q.out
    hive/trunk/ql/src/test/results/clientpositive/input13.q.out
    hive/trunk/ql/src/test/results/clientpositive/input14.q.out
    hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out
    hive/trunk/ql/src/test/results/clientpositive/input18.q.out
    hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out
    hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out
    hive/trunk/ql/src/test/results/clientpositive/input42.q.out
    hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out
    hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out
    hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out
    hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out
    hive/trunk/ql/src/test/results/clientpositive/insert1_overwrite_partitions.q.out
    hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out
    hive/trunk/ql/src/test/results/clientpositive/join0.q.out
    hive/trunk/ql/src/test/results/clientpositive/join11.q.out
    hive/trunk/ql/src/test/results/clientpositive/join12.q.out
    hive/trunk/ql/src/test/results/clientpositive/join13.q.out
    hive/trunk/ql/src/test/results/clientpositive/join14.q.out
    hive/trunk/ql/src/test/results/clientpositive/join16.q.out
    hive/trunk/ql/src/test/results/clientpositive/join20.q.out
    hive/trunk/ql/src/test/results/clientpositive/join21.q.out
    hive/trunk/ql/src/test/results/clientpositive/join23.q.out
    hive/trunk/ql/src/test/results/clientpositive/join34.q.out
    hive/trunk/ql/src/test/results/clientpositive/join35.q.out
    hive/trunk/ql/src/test/results/clientpositive/join38.q.out
    hive/trunk/ql/src/test/results/clientpositive/join39.q.out
    hive/trunk/ql/src/test/results/clientpositive/join4.q.out
    hive/trunk/ql/src/test/results/clientpositive/join40.q.out
    hive/trunk/ql/src/test/results/clientpositive/join5.q.out
    hive/trunk/ql/src/test/results/clientpositive/join6.q.out
    hive/trunk/ql/src/test/results/clientpositive/join7.q.out
    hive/trunk/ql/src/test/results/clientpositive/join8.q.out
    hive/trunk/ql/src/test/results/clientpositive/load_dyn_part13.q.out
    hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out
    hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out
    hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out
    hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out
    hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out
    hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out
    hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out
    hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out
    hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out
    hive/trunk/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out
    hive/trunk/ql/src/test/results/clientpositive/order2.q.out
    hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out
    hive/trunk/ql/src/test/results/clientpositive/pcr.q.out
    hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out
    hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out
    hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out
    hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out
    hive/trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out
    hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown.q.out
    hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown3.q.out
    hive/trunk/ql/src/test/results/clientpositive/quote1.q.out
    hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out
    hive/trunk/ql/src/test/results/clientpositive/rcfile_null_value.q.out
    hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out
    hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out
    hive/trunk/ql/src/test/results/clientpositive/router_join_ppr.q.out
    hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out
    hive/trunk/ql/src/test/results/clientpositive/set_processor_namespaces.q.out
    hive/trunk/ql/src/test/results/clientpositive/skewjoin.q.out
    hive/trunk/ql/src/test/results/clientpositive/subq.q.out
    hive/trunk/ql/src/test/results/clientpositive/subq2.q.out
    hive/trunk/ql/src/test/results/clientpositive/transform_ppr1.q.out
    hive/trunk/ql/src/test/results/clientpositive/transform_ppr2.q.out
    hive/trunk/ql/src/test/results/clientpositive/udf1.q.out
    hive/trunk/ql/src/test/results/clientpositive/udf9.q.out
    hive/trunk/ql/src/test/results/clientpositive/udf_10_trims.q.out
    hive/trunk/ql/src/test/results/clientpositive/udf_hour.q.out
    hive/trunk/ql/src/test/results/clientpositive/udf_like.q.out
    hive/trunk/ql/src/test/results/clientpositive/udf_lower.q.out
    hive/trunk/ql/src/test/results/clientpositive/udf_minute.q.out
    hive/trunk/ql/src/test/results/clientpositive/udf_parse_url.q.out
    hive/trunk/ql/src/test/results/clientpositive/udf_second.q.out
    hive/trunk/ql/src/test/results/clientpositive/udf_union.q.out
    hive/trunk/ql/src/test/results/clientpositive/union.q.out
    hive/trunk/ql/src/test/results/clientpositive/union20.q.out
    hive/trunk/ql/src/test/results/clientpositive/union22.q.out
    hive/trunk/ql/src/test/results/clientpositive/union24.q.out
    hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out
    hive/trunk/ql/src/test/results/compiler/plan/cast1.q.xml
    hive/trunk/ql/src/test/results/compiler/plan/input1.q.xml
    hive/trunk/ql/src/test/results/compiler/plan/input2.q.xml
    hive/trunk/ql/src/test/results/compiler/plan/input3.q.xml
    hive/trunk/ql/src/test/results/compiler/plan/input4.q.xml
    hive/trunk/ql/src/test/results/compiler/plan/input_part1.q.xml
    hive/trunk/ql/src/test/results/compiler/plan/join4.q.xml
    hive/trunk/ql/src/test/results/compiler/plan/join5.q.xml
    hive/trunk/ql/src/test/results/compiler/plan/join6.q.xml
    hive/trunk/ql/src/test/results/compiler/plan/join7.q.xml
    hive/trunk/ql/src/test/results/compiler/plan/join8.q.xml
    hive/trunk/ql/src/test/results/compiler/plan/subq.q.xml
    hive/trunk/ql/src/test/results/compiler/plan/udf1.q.xml
    hive/trunk/ql/src/test/results/compiler/plan/union.q.xml

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

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

Added: hive/trunk/data/files/infer_const_type.txt
URL: http://svn.apache.org/viewvc/hive/trunk/data/files/infer_const_type.txt?rev=1238175&view=auto
==============================================================================
--- hive/trunk/data/files/infer_const_type.txt (added)
+++ hive/trunk/data/files/infer_const_type.txt Tue Jan 31 06:39:43 2012
@@ -0,0 +1,3 @@
+1273276712345-12345906-307.01234
+1263276712345-12345906-307.01234
+1263276712345-12345906-307.01.57

Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java Tue Jan 31 06:39:43 2012
@@ -21,9 +21,11 @@ package org.apache.hadoop.hive.ql.parse;
 import java.util.ArrayList;
 import java.util.Arrays;
 import java.util.HashMap;
+import java.util.HashSet;
 import java.util.LinkedHashMap;
 import java.util.List;
 import java.util.Map;
+import java.util.Set;
 import java.util.Stack;
 
 import org.apache.commons.lang.StringUtils;
@@ -51,6 +53,8 @@ import org.apache.hadoop.hive.ql.plan.Ex
 import org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc;
 import org.apache.hadoop.hive.ql.plan.ExprNodeNullDesc;
 import org.apache.hadoop.hive.ql.udf.generic.GenericUDF;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFBaseCompare;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPEqual;
 import org.apache.hadoop.hive.serde.Constants;
 import org.apache.hadoop.hive.serde2.objectinspector.ObjectInspector;
 import org.apache.hadoop.hive.serde2.objectinspector.ObjectInspector.Category;
@@ -681,6 +685,79 @@ public final class TypeCheckProcFactory 
           }
         }
 
+        // Try to infer the type of the constant only if there are two
+        // nodes, one of them is column and the other is numeric const
+        if (fi.getGenericUDF() instanceof GenericUDFBaseCompare
+            && children.size() == 2
+            && ((children.get(0) instanceof ExprNodeConstantDesc
+                && children.get(1) instanceof ExprNodeColumnDesc)
+                || (children.get(0) instanceof ExprNodeColumnDesc
+                    && children.get(1) instanceof ExprNodeConstantDesc))) {
+          int constIdx =
+              children.get(0) instanceof ExprNodeConstantDesc ? 0 : 1;
+
+          Set<String> inferTypes = new HashSet<String>(Arrays.asList(
+              Constants.TINYINT_TYPE_NAME.toLowerCase(),
+              Constants.SMALLINT_TYPE_NAME.toLowerCase(),
+              Constants.INT_TYPE_NAME.toLowerCase(),
+              Constants.BIGINT_TYPE_NAME.toLowerCase(),
+              Constants.FLOAT_TYPE_NAME.toLowerCase(),
+              Constants.DOUBLE_TYPE_NAME.toLowerCase(),
+              Constants.STRING_TYPE_NAME.toLowerCase()
+              ));
+
+          String constType = children.get(constIdx).getTypeString().toLowerCase();
+          String columnType = children.get(1 - constIdx).getTypeString().toLowerCase();
+
+          if (inferTypes.contains(constType) && inferTypes.contains(columnType)
+              && !columnType.equalsIgnoreCase(constType)) {
+            String constValue =
+                ((ExprNodeConstantDesc) children.get(constIdx)).getValue().toString();
+            boolean triedDouble = false;
+
+            Number value = null;
+            try {
+              if (columnType.equalsIgnoreCase(Constants.TINYINT_TYPE_NAME)) {
+                value = new Byte(constValue);
+              } else if (columnType.equalsIgnoreCase(Constants.SMALLINT_TYPE_NAME)) {
+                value = new Short(constValue);
+              } else if (columnType.equalsIgnoreCase(Constants.INT_TYPE_NAME)) {
+                value = new Integer(constValue);
+              } else if (columnType.equalsIgnoreCase(Constants.BIGINT_TYPE_NAME)) {
+                value = new Long(constValue);
+              } else if (columnType.equalsIgnoreCase(Constants.FLOAT_TYPE_NAME)) {
+                value = new Float(constValue);
+              } else if (columnType.equalsIgnoreCase(Constants.DOUBLE_TYPE_NAME)
+                  || (columnType.equalsIgnoreCase(Constants.STRING_TYPE_NAME)
+                     && !constType.equalsIgnoreCase(Constants.BIGINT_TYPE_NAME))) {
+                // no smart inference for queries like "str_col = bigint_const"
+                triedDouble = true;
+                value = new Double(constValue);
+              }
+            } catch (NumberFormatException nfe) {
+              // this exception suggests the precise type inference did not succeed
+              // we'll try again to convert it to double
+              // however, if we already tried this, or the column is NUMBER type and
+              // the operator is EQUAL, return false due to the type mismatch
+              if (triedDouble ||
+                  (fi.getGenericUDF() instanceof GenericUDFOPEqual
+                  && !columnType.equals(Constants.STRING_TYPE_NAME))) {
+                return new ExprNodeConstantDesc(false);
+              }
+
+              try {
+                value = new Double(constValue);
+              } catch (NumberFormatException ex) {
+                return new ExprNodeConstantDesc(false);
+              }
+            }
+
+            if (value != null) {
+              children.set(constIdx, new ExprNodeConstantDesc(value));
+            }
+          }
+        }
+
         desc = ExprNodeGenericFuncDesc.newInstance(fi.getGenericUDF(), children);
       }
       // UDFOPPositive is a no-op.

Added: hive/trunk/ql/src/test/queries/clientpositive/infer_const_type.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/infer_const_type.q?rev=1238175&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/infer_const_type.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/infer_const_type.q Tue Jan 31 06:39:43 2012
@@ -0,0 +1,66 @@
+DROP TABLE infertypes;
+CREATE TABLE infertypes(ti TINYINT, si SMALLINT, i INT, bi BIGINT, fl FLOAT, db DOUBLE, str STRING);
+
+LOAD DATA LOCAL INPATH '../data/files/infer_const_type.txt' OVERWRITE INTO TABLE infertypes;
+
+SELECT * FROM infertypes;
+
+EXPLAIN SELECT * FROM infertypes WHERE
+  ti  = '127' AND
+  si  = 32767 AND
+  i   = '12345' AND
+  bi  = '-12345' AND
+  fl  = '0906' AND
+  db  = '-307' AND
+  str = 1234;
+
+SELECT * FROM infertypes WHERE
+  ti  = '127' AND
+  si  = 32767 AND
+  i   = '12345' AND
+  bi  = '-12345' AND
+  fl  = '0906' AND
+  db  = '-307' AND
+  str = 1234;
+
+-- all should return false as all numbers exceeed the largest number 
+-- which could be represented by the corresponding type
+-- and string_col = long_const should return false
+EXPLAIN SELECT * FROM infertypes WHERE
+  ti  = '128' OR
+  si  = 32768 OR
+  i   = '2147483648' OR
+  bi  = '9223372036854775808' OR
+  fl  = 'float' OR
+  db  = 'double';
+
+SELECT * FROM infertypes WHERE
+  ti  = '128' OR
+  si  = 32768 OR
+  i   = '2147483648' OR
+  bi  = '9223372036854775808' OR
+  fl  = 'float' OR
+  db  = 'double';
+
+-- for the query like: int_col = double, should return false 
+EXPLAIN SELECT * FROM infertypes WHERE
+  ti  = '127.0' OR
+  si  = 327.0 OR
+  i   = '-100.0';
+
+SELECT * FROM infertypes WHERE
+  ti  = '127.0' OR
+  si  = 327.0 OR
+  i   = '-100.0';
+
+EXPLAIN SELECT * FROM infertypes WHERE
+  ti < '127.0' AND
+  i > '100.0' AND
+  str = 1.57;
+
+SELECT * FROM infertypes WHERE
+  ti < '127.0' AND
+  i > '100.0' AND
+  str = 1.57;
+
+DROP TABLE infertypes;

Modified: hive/trunk/ql/src/test/queries/clientpositive/insert1_overwrite_partitions.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/insert1_overwrite_partitions.q?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/insert1_overwrite_partitions.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/insert1_overwrite_partitions.q Tue Jan 31 06:39:43 2012
@@ -7,28 +7,28 @@ load data local inpath '../data/files/kv
 CREATE TABLE destinTable (one string,two string) PARTITIONED BY (ds string,hr string);
 
 EXPLAIN INSERT OVERWRITE TABLE destinTable PARTITION (ds='2011-11-11', hr='11') if not exists
-SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one limit 5;
+SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one desc, two desc limit 5;
 
 INSERT OVERWRITE TABLE destinTable PARTITION (ds='2011-11-11', hr='11') if not exists
-SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one limit 5;
+SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one desc, two desc limit 5;
 
-select one,two from destinTable;
+select one,two from destinTable order by one desc, two desc;
 
 EXPLAIN INSERT OVERWRITE TABLE destinTable PARTITION (ds='2011-11-11', hr='11') if not exists
-SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='12' order by one limit 5;
+SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='12' order by one desc, two desc limit 5;
 
 INSERT OVERWRITE TABLE destinTable PARTITION (ds='2011-11-11', hr='11') if not exists
-SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='12' order by one limit 5;
+SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='12' order by one desc, two desc limit 5;
 
-select one,two from destinTable;
+select one,two from destinTable order by one desc, two desc;
 
 drop table destinTable;
 
 CREATE TABLE destinTable (one string,two string);
 
-EXPLAIN INSERT OVERWRITE TABLE destinTable SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one limit 5;
+EXPLAIN INSERT OVERWRITE TABLE destinTable SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one desc, two desc limit 5;
 
-INSERT OVERWRITE TABLE destinTable SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one limit 5;
+INSERT OVERWRITE TABLE destinTable SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one desc, two desc limit 5;
 
 drop table destinTable;
 

Modified: hive/trunk/ql/src/test/queries/clientpositive/insert2_overwrite_partitions.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/insert2_overwrite_partitions.q?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/insert2_overwrite_partitions.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/insert2_overwrite_partitions.q Tue Jan 31 06:39:43 2012
@@ -11,20 +11,20 @@ load data local inpath '../data/files/kv
 CREATE TABLE db2.destinTable (one string,two string) PARTITIONED BY (ds string);
 
 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;
 
 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;
 
-select one,two from db2.destinTable;
+select one,two from db2.destinTable order by one desc, two desc;
 
 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;
 
 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;
 
-select one,two from db2.destinTable;
+select one,two from db2.destinTable order by one desc, two desc;
 
 drop table db2.destinTable;
 

Modified: hive/trunk/ql/src/test/queries/clientpositive/ppr_pushdown.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/ppr_pushdown.q?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/ppr_pushdown.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/ppr_pushdown.q Tue Jan 31 06:39:43 2012
@@ -19,15 +19,15 @@ insert overwrite table ppr_test partitio
 insert overwrite table ppr_test partition(ds = '12*4') select * from (select '12*4' from src limit 1 union all select 'abcd' from src limit 1) s;
 
 
-select * from ppr_test where ds = '1234';
-select * from ppr_test where ds = '1224';
-select * from ppr_test where ds = '1214';
-select * from ppr_test where ds = '12.4';
-select * from ppr_test where ds = '12+4';
-select * from ppr_test where ds = '12:4';
-select * from ppr_test where ds = '12%4';
-select * from ppr_test where ds = '12*4';
-select * from ppr_test where ds = '12.*4';
+select * from ppr_test where ds = '1234' order by key;
+select * from ppr_test where ds = '1224' order by key;
+select * from ppr_test where ds = '1214' order by key;
+select * from ppr_test where ds = '12.4' order by key;
+select * from ppr_test where ds = '12+4' order by key;
+select * from ppr_test where ds = '12:4' order by key;
+select * from ppr_test where ds = '12%4' order by key;
+select * from ppr_test where ds = '12*4' order by key;
+select * from ppr_test where ds = '12.*4' order by key;
 
 select * from ppr_test where ds = '1234' and key = '1234';
 select * from ppr_test where ds = '1224' and key = '1224';

Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join0.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join0.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join0.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join0.q.out Tue Jan 31 06:39:43 2012
@@ -50,7 +50,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -77,7 +77,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -210,7 +210,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -237,7 +237,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -286,7 +286,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -308,7 +308,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/auto_join11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join11.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join11.q.out Tue Jan 31 06:39:43 2012
@@ -66,7 +66,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -148,7 +148,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -220,7 +220,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/auto_join12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join12.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join12.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join12.q.out Tue Jan 31 06:39:43 2012
@@ -75,7 +75,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 80)
+                  expr: (key < 80.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -102,7 +102,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -190,7 +190,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -213,7 +213,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 80)
+                  expr: (key < 80.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -297,7 +297,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -345,7 +345,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 80)
+                  expr: (key < 80.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -397,7 +397,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -443,7 +443,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/auto_join13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join13.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join13.q.out Tue Jan 31 06:39:43 2012
@@ -78,7 +78,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -121,7 +121,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 200)
+                  expr: (key < 200.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -231,7 +231,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 200)
+                  expr: (key < 200.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -295,7 +295,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 200)
+                  expr: (key < 200.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -352,7 +352,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 100)
+                  expr: (key < 100.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -411,7 +411,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/auto_join14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join14.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join14.q.out Tue Jan 31 06:39:43 2012
@@ -56,7 +56,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key > 100)
+                  expr: (key > 100.0)
                   type: boolean
               Map Join Operator
                 condition map:
@@ -120,7 +120,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key > 100)
+                  expr: (key > 100.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -183,7 +183,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/auto_join16.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join16.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join16.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join16.q.out Tue Jan 31 06:39:43 2012
@@ -43,7 +43,7 @@ STAGE PLANS:
             alias: tab
             Filter Operator
               predicate:
-                  expr: (value < 200)
+                  expr: (value < 200.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -63,7 +63,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:
@@ -147,7 +147,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:
@@ -174,7 +174,7 @@ STAGE PLANS:
             alias: tab
             Filter Operator
               predicate:
-                  expr: (value < 200)
+                  expr: (value < 200.0)
                   type: boolean
               Map Join Operator
                 condition map:
@@ -218,7 +218,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:
@@ -248,7 +248,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/auto_join20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join20.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join20.q.out Tue Jan 31 06:39:43 2012
@@ -45,7 +45,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -55,7 +55,7 @@ STAGE PLANS:
                 filter predicates:
                   0 
                   1 
-                  2 {(key < 20)}
+                  2 {(key < 20.0)}
                 handleSkewJoin: false
                 keys:
                   0 [Column[key]]
@@ -73,7 +73,7 @@ STAGE PLANS:
               filter predicates:
                 0 
                 1 
-                2 {(key < 20)}
+                2 {(key < 20.0)}
               handleSkewJoin: false
               keys:
                 0 [Column[key]]
@@ -98,7 +98,7 @@ STAGE PLANS:
               filter predicates:
                 0 
                 1 
-                2 {(key < 20)}
+                2 {(key < 20.0)}
               handleSkewJoin: false
               keys:
                 0 [Column[key]]
@@ -230,7 +230,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -292,7 +292,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
@@ -388,7 +388,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -398,7 +398,7 @@ STAGE PLANS:
                 filter predicates:
                   0 
                   1 
-                  2 {(key < 20)}
+                  2 {(key < 20.0)}
                 handleSkewJoin: false
                 keys:
                   0 [Column[key]]
@@ -410,7 +410,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key < 15)
+                  expr: (key < 15.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -420,7 +420,7 @@ STAGE PLANS:
                 filter predicates:
                   0 
                   1 
-                  2 {(key < 20)}
+                  2 {(key < 20.0)}
                 handleSkewJoin: false
                 keys:
                   0 [Column[key]]
@@ -445,7 +445,7 @@ STAGE PLANS:
               filter predicates:
                 0 
                 1 
-                2 {(key < 20)}
+                2 {(key < 20.0)}
               handleSkewJoin: false
               keys:
                 0 [Column[key]]
@@ -577,7 +577,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -598,7 +598,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key < 15)
+                  expr: (key < 15.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -643,7 +643,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/auto_join21.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join21.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join21.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join21.q.out Tue Jan 31 06:39:43 2012
@@ -38,9 +38,9 @@ STAGE PLANS:
                 1 {key} {value}
                 2 {key} {value}
               filter predicates:
-                0 {(key < 10)}
+                0 {(key < 10.0)}
                 1 
-                2 {(key < 10)}
+                2 {(key < 10.0)}
               handleSkewJoin: false
               keys:
                 0 [Column[key]]
@@ -52,7 +52,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -60,9 +60,9 @@ STAGE PLANS:
                   1 {key} {value}
                   2 {key} {value}
                 filter predicates:
-                  0 {(key < 10)}
+                  0 {(key < 10.0)}
                   1 
-                  2 {(key < 10)}
+                  2 {(key < 10.0)}
                 handleSkewJoin: false
                 keys:
                   0 [Column[key]]
@@ -85,9 +85,9 @@ STAGE PLANS:
                 1 {key} {value}
                 2 {key} {value}
               filter predicates:
-                0 {(key < 10)}
+                0 {(key < 10.0)}
                 1 
-                2 {(key < 10)}
+                2 {(key < 10.0)}
               handleSkewJoin: false
               keys:
                 0 [Column[key]]
@@ -186,7 +186,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -229,9 +229,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/auto_join23.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join23.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join23.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join23.q.out Tue Jan 31 06:39:43 2012
@@ -33,7 +33,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -53,7 +53,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Map Join Operator
                 condition map:
@@ -133,7 +133,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -153,7 +153,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Map Join Operator
                 condition map:
@@ -195,7 +195,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 sort order: 
@@ -210,7 +210,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/auto_join27.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join27.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join27.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join27.q.out Tue Jan 31 06:39:43 2012
@@ -111,7 +111,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 200)
+                  expr: (key < 200.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -276,7 +276,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key < 200)
+                  expr: (key < 200.0)
                   type: boolean
               Select Operator
                 expressions:
@@ -350,7 +350,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/auto_join28.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join28.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join28.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join28.q.out Tue Jan 31 06:39:43 2012
@@ -42,7 +42,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -85,9 +85,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
@@ -203,7 +203,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -224,7 +224,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -250,7 +250,7 @@ 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 
           handleSkewJoin: false
@@ -351,7 +351,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -389,7 +389,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -416,7 +416,7 @@ STAGE PLANS:
             2 {VALUE._col0} {VALUE._col1}
           filter predicates:
             0 
-            1 {(VALUE._col0 > 10)}
+            1 {(VALUE._col0 > 10.0)}
             2 
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
@@ -516,7 +516,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -577,8 +577,8 @@ STAGE PLANS:
             2 {VALUE._col0} {VALUE._col1}
           filter predicates:
             0 
-            1 {(VALUE._col0 > 10)}
-            2 {(VALUE._col0 < 10)}
+            1 {(VALUE._col0 > 10.0)}
+            2 {(VALUE._col0 < 10.0)}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
           Select Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join29.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join29.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join29.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join29.q.out Tue Jan 31 06:39:43 2012
@@ -38,9 +38,9 @@ STAGE PLANS:
                 1 {key} {value}
                 2 {key} {value}
               filter predicates:
-                0 {(key < 10)}
+                0 {(key < 10.0)}
                 1 
-                2 {(key < 10)}
+                2 {(key < 10.0)}
               handleSkewJoin: false
               keys:
                 0 [Column[key]]
@@ -52,7 +52,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -60,9 +60,9 @@ STAGE PLANS:
                   1 {key} {value}
                   2 {key} {value}
                 filter predicates:
-                  0 {(key < 10)}
+                  0 {(key < 10.0)}
                   1 
-                  2 {(key < 10)}
+                  2 {(key < 10.0)}
                 handleSkewJoin: false
                 keys:
                   0 [Column[key]]
@@ -85,9 +85,9 @@ STAGE PLANS:
                 1 {key} {value}
                 2 {key} {value}
               filter predicates:
-                0 {(key < 10)}
+                0 {(key < 10.0)}
                 1 
-                2 {(key < 10)}
+                2 {(key < 10.0)}
               handleSkewJoin: false
               keys:
                 0 [Column[key]]
@@ -186,7 +186,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -229,9 +229,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
@@ -2911,7 +2911,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -2919,7 +2919,7 @@ STAGE PLANS:
                   1 {key} {value}
                   2 {key} {value}
                 filter predicates:
-                  0 {(key < 10)}
+                  0 {(key < 10.0)}
                   1 
                   2 
                 handleSkewJoin: false
@@ -2933,7 +2933,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -2941,7 +2941,7 @@ STAGE PLANS:
                   1 {key} {value}
                   2 {key} {value}
                 filter predicates:
-                  0 {(key < 10)}
+                  0 {(key < 10.0)}
                   1 
                   2 
                 handleSkewJoin: false
@@ -2966,7 +2966,7 @@ STAGE PLANS:
                 1 {key} {value}
                 2 {key} {value}
               filter predicates:
-                0 {(key < 10)}
+                0 {(key < 10.0)}
                 1 
                 2 
               handleSkewJoin: false
@@ -3067,7 +3067,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -3088,7 +3088,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -3114,7 +3114,7 @@ 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 
           handleSkewJoin: false
@@ -4218,7 +4218,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -4227,7 +4227,7 @@ STAGE PLANS:
                   2 {key} {value}
                 filter predicates:
                   0 
-                  1 {(key > 10)}
+                  1 {(key > 10.0)}
                   2 
                 handleSkewJoin: false
                 keys:
@@ -4240,7 +4240,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -4249,7 +4249,7 @@ STAGE PLANS:
                   2 {key} {value}
                 filter predicates:
                   0 
-                  1 {(key > 10)}
+                  1 {(key > 10.0)}
                   2 
                 handleSkewJoin: false
                 keys:
@@ -4274,7 +4274,7 @@ STAGE PLANS:
                 2 {key} {value}
               filter predicates:
                 0 
-                1 {(key > 10)}
+                1 {(key > 10.0)}
                 2 
               handleSkewJoin: false
               keys:
@@ -4357,7 +4357,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -4395,7 +4395,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -4422,7 +4422,7 @@ STAGE PLANS:
             2 {VALUE._col0} {VALUE._col1}
           filter predicates:
             0 
-            1 {(VALUE._col0 > 10)}
+            1 {(VALUE._col0 > 10.0)}
             2 
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
@@ -5045,7 +5045,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -5054,8 +5054,8 @@ STAGE PLANS:
                   2 {key} {value}
                 filter predicates:
                   0 
-                  1 {(key > 10)}
-                  2 {(key < 10)}
+                  1 {(key > 10.0)}
+                  2 {(key < 10.0)}
                 handleSkewJoin: false
                 keys:
                   0 [Column[key]]
@@ -5072,8 +5072,8 @@ STAGE PLANS:
                 2 {key} {value}
               filter predicates:
                 0 
-                1 {(key > 10)}
-                2 {(key < 10)}
+                1 {(key > 10.0)}
+                2 {(key < 10.0)}
               handleSkewJoin: false
               keys:
                 0 [Column[key]]
@@ -5097,8 +5097,8 @@ STAGE PLANS:
                 2 {key} {value}
               filter predicates:
                 0 
-                1 {(key > 10)}
-                2 {(key < 10)}
+                1 {(key > 10.0)}
+                2 {(key < 10.0)}
               handleSkewJoin: false
               keys:
                 0 [Column[key]]
@@ -5180,7 +5180,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -5241,8 +5241,8 @@ STAGE PLANS:
             2 {VALUE._col0} {VALUE._col1}
           filter predicates:
             0 
-            1 {(VALUE._col0 > 10)}
-            2 {(VALUE._col0 < 10)}
+            1 {(VALUE._col0 > 10.0)}
+            2 {(VALUE._col0 < 10.0)}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
           Select Operator
@@ -6382,7 +6382,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -6400,7 +6400,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -6422,7 +6422,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Map Join Operator
                 condition map:
@@ -6520,7 +6520,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -6538,7 +6538,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -6560,7 +6560,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               Map Join Operator
                 condition map:
@@ -6609,7 +6609,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -6630,7 +6630,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -6651,7 +6651,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -6749,7 +6749,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -6759,7 +6759,7 @@ STAGE PLANS:
                 filter predicates:
                   0 
                   1 
-                  2 {(key < 10)}
+                  2 {(key < 10.0)}
                 handleSkewJoin: false
                 keys:
                   0 [Column[key]]
@@ -6771,7 +6771,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -6781,7 +6781,7 @@ STAGE PLANS:
                 filter predicates:
                   0 
                   1 
-                  2 {(key < 10)}
+                  2 {(key < 10.0)}
                 handleSkewJoin: false
                 keys:
                   0 [Column[key]]
@@ -6806,7 +6806,7 @@ STAGE PLANS:
               filter predicates:
                 0 
                 1 
-                2 {(key < 10)}
+                2 {(key < 10.0)}
               handleSkewJoin: false
               keys:
                 0 [Column[key]]
@@ -6888,7 +6888,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -6909,7 +6909,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -6954,7 +6954,7 @@ STAGE PLANS:
           filter predicates:
             0 
             1 
-            2 {(VALUE._col0 < 10)}
+            2 {(VALUE._col0 < 10.0)}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
           Select Operator
@@ -7528,7 +7528,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -7536,7 +7536,7 @@ STAGE PLANS:
                   1 {key} {value}
                   2 {key} {value}
                 filter predicates:
-                  0 {(key < 10)}
+                  0 {(key < 10.0)}
                   1 
                   2 
                 handleSkewJoin: false
@@ -7550,7 +7550,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -7558,7 +7558,7 @@ STAGE PLANS:
                   1 {key} {value}
                   2 {key} {value}
                 filter predicates:
-                  0 {(key < 10)}
+                  0 {(key < 10.0)}
                   1 
                   2 
                 handleSkewJoin: false
@@ -7583,7 +7583,7 @@ STAGE PLANS:
                 1 {key} {value}
                 2 {key} {value}
               filter predicates:
-                0 {(key < 10)}
+                0 {(key < 10.0)}
                 1 
                 2 
               handleSkewJoin: false
@@ -7684,7 +7684,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -7705,7 +7705,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -7731,7 +7731,7 @@ 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 
           handleSkewJoin: false
@@ -7809,7 +7809,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -7818,7 +7818,7 @@ STAGE PLANS:
                   2 {key} {value}
                 filter predicates:
                   0 
-                  1 {(key > 10)}
+                  1 {(key > 10.0)}
                   2 
                 handleSkewJoin: false
                 keys:
@@ -7831,7 +7831,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -7840,7 +7840,7 @@ STAGE PLANS:
                   2 {key} {value}
                 filter predicates:
                   0 
-                  1 {(key > 10)}
+                  1 {(key > 10.0)}
                   2 
                 handleSkewJoin: false
                 keys:
@@ -7865,7 +7865,7 @@ STAGE PLANS:
                 2 {key} {value}
               filter predicates:
                 0 
-                1 {(key > 10)}
+                1 {(key > 10.0)}
                 2 
               handleSkewJoin: false
               keys:
@@ -7955,7 +7955,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -7964,7 +7964,7 @@ STAGE PLANS:
                   2 {key} {value}
                 filter predicates:
                   0 
-                  1 {(key > 10)}
+                  1 {(key > 10.0)}
                   2 
                 handleSkewJoin: false
                 keys:
@@ -7982,7 +7982,7 @@ STAGE PLANS:
                 2 {key} {value}
               filter predicates:
                 0 
-                1 {(key > 10)}
+                1 {(key > 10.0)}
                 2 
               handleSkewJoin: false
               keys:
@@ -7999,7 +7999,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Map Join Operator
                 condition map:
@@ -8011,7 +8011,7 @@ STAGE PLANS:
                   2 {key} {value}
                 filter predicates:
                   0 
-                  1 {(key > 10)}
+                  1 {(key > 10.0)}
                   2 
                 handleSkewJoin: false
                 keys:
@@ -8052,7 +8052,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -8090,7 +8090,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -8117,7 +8117,7 @@ STAGE PLANS:
             2 {VALUE._col0} {VALUE._col1}
           filter predicates:
             0 
-            1 {(VALUE._col0 > 10)}
+            1 {(VALUE._col0 > 10.0)}
             2 
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
@@ -8254,7 +8254,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -8272,7 +8272,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -8294,7 +8294,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Map Join Operator
                 condition map:
@@ -8392,7 +8392,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -8410,7 +8410,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -8432,7 +8432,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               Map Join Operator
                 condition map:
@@ -8488,7 +8488,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -8506,7 +8506,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               HashTable Sink Operator
                 condition expressions:
@@ -8528,7 +8528,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Map Join Operator
                 condition map:
@@ -8577,7 +8577,7 @@ STAGE PLANS:
             alias: src1
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -8598,7 +8598,7 @@ STAGE PLANS:
             alias: src2
             Filter Operator
               predicate:
-                  expr: (key > 10)
+                  expr: (key > 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:
@@ -8619,7 +8619,7 @@ STAGE PLANS:
             alias: src3
             Filter Operator
               predicate:
-                  expr: (key < 10)
+                  expr: (key < 10.0)
                   type: boolean
               Reduce Output Operator
                 key expressions:

Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join4.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join4.q.out Tue Jan 31 06:39:43 2012
@@ -60,7 +60,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:
@@ -87,7 +87,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:
@@ -173,7 +173,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:
@@ -201,7 +201,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/auto_join5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join5.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join5.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:
@@ -87,7 +87,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:
@@ -173,7 +173,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:
@@ -201,7 +201,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/auto_join6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join6.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_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/auto_join7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join7.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_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/auto_join8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join8.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join8.q.out Tue Jan 31 06:39:43 2012
@@ -60,7 +60,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:
@@ -87,7 +87,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:
@@ -177,7 +177,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:
@@ -205,7 +205,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/cast1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/cast1.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/cast1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/cast1.q.out Tue Jan 31 06:39:43 2012
@@ -29,7 +29,7 @@ STAGE PLANS:
             alias: src
             Filter Operator
               predicate:
-                  expr: (key = 86)
+                  expr: (key = 86.0)
                   type: boolean
               Select Operator
                 expressions:



Mime
View raw message