You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by sd...@apache.org on 2012/01/31 07:39:47 UTC
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/
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: