diff --git contrib/src/test/results/clientpositive/dboutput.q.out contrib/src/test/results/clientpositive/dboutput.q.out index e81d02c..6425b66 100644 --- contrib/src/test/results/clientpositive/dboutput.q.out +++ contrib/src/test/results/clientpositive/dboutput.q.out @@ -141,7 +141,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: diff --git contrib/src/test/results/clientpositive/serde_typedbytes4.q.out contrib/src/test/results/clientpositive/serde_typedbytes4.q.out index 8e4baca..2fe17ea 100644 --- contrib/src/test/results/clientpositive/serde_typedbytes4.q.out +++ contrib/src/test/results/clientpositive/serde_typedbytes4.q.out @@ -48,7 +48,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: diff --git ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java index 59e55ae..9999851 100644 --- ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java +++ ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java @@ -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.ExprNodeFieldDesc; 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,86 @@ 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 inferTypes = new HashSet(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() + )); + + Set doubleTypes = new HashSet(Arrays.asList( + Constants.FLOAT_TYPE_NAME.toLowerCase(), + Constants.DOUBLE_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; + + try { + // return false for the expr like int_col = non_double_value + // such as: int_col = 1.0 + Number value = null; + + 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))) { + triedDouble = true; + value = new Double(constValue); + } + + if (value != null) { + children.set(constIdx, new ExprNodeConstantDesc(value)); + } + } 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 { + Number value = new Double(constValue); + } catch (NumberFormatException ex) { + return new ExprNodeConstantDesc(false); + } + } + } + } + desc = ExprNodeGenericFuncDesc.newInstance(fi.getGenericUDF(), children); } // UDFOPPositive is a no-op. diff --git ql/src/test/results/clientpositive/auto_join0.q.out ql/src/test/results/clientpositive/auto_join0.q.out index a07af57..1ea51a1 100644 --- ql/src/test/results/clientpositive/auto_join0.q.out +++ ql/src/test/results/clientpositive/auto_join0.q.out @@ -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: diff --git ql/src/test/results/clientpositive/auto_join11.q.out ql/src/test/results/clientpositive/auto_join11.q.out index c99cfa4..38ec39d 100644 --- ql/src/test/results/clientpositive/auto_join11.q.out +++ ql/src/test/results/clientpositive/auto_join11.q.out @@ -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: diff --git ql/src/test/results/clientpositive/auto_join12.q.out ql/src/test/results/clientpositive/auto_join12.q.out index 17fade4..da0b55d 100644 --- ql/src/test/results/clientpositive/auto_join12.q.out +++ ql/src/test/results/clientpositive/auto_join12.q.out @@ -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: diff --git ql/src/test/results/clientpositive/auto_join13.q.out ql/src/test/results/clientpositive/auto_join13.q.out index 52e0539..80b08f1 100644 --- ql/src/test/results/clientpositive/auto_join13.q.out +++ ql/src/test/results/clientpositive/auto_join13.q.out @@ -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: diff --git ql/src/test/results/clientpositive/auto_join14.q.out ql/src/test/results/clientpositive/auto_join14.q.out index 4ea1bd7..18a1b57 100644 --- ql/src/test/results/clientpositive/auto_join14.q.out +++ ql/src/test/results/clientpositive/auto_join14.q.out @@ -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: diff --git ql/src/test/results/clientpositive/auto_join16.q.out ql/src/test/results/clientpositive/auto_join16.q.out index fa6ad7c..8983883 100644 --- ql/src/test/results/clientpositive/auto_join16.q.out +++ ql/src/test/results/clientpositive/auto_join16.q.out @@ -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: diff --git ql/src/test/results/clientpositive/auto_join20.q.out ql/src/test/results/clientpositive/auto_join20.q.out index 69bce3a..78a18ba 100644 --- ql/src/test/results/clientpositive/auto_join20.q.out +++ ql/src/test/results/clientpositive/auto_join20.q.out @@ -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 diff --git ql/src/test/results/clientpositive/auto_join21.q.out ql/src/test/results/clientpositive/auto_join21.q.out index 023b00b..0e30e59 100644 --- ql/src/test/results/clientpositive/auto_join21.q.out +++ ql/src/test/results/clientpositive/auto_join21.q.out @@ -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 diff --git ql/src/test/results/clientpositive/auto_join23.q.out ql/src/test/results/clientpositive/auto_join23.q.out index f22cc2f..205c31d 100644 --- ql/src/test/results/clientpositive/auto_join23.q.out +++ ql/src/test/results/clientpositive/auto_join23.q.out @@ -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: diff --git ql/src/test/results/clientpositive/auto_join27.q.out ql/src/test/results/clientpositive/auto_join27.q.out index 9d6de93..d7a8db6 100644 --- ql/src/test/results/clientpositive/auto_join27.q.out +++ ql/src/test/results/clientpositive/auto_join27.q.out @@ -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: diff --git ql/src/test/results/clientpositive/auto_join28.q.out ql/src/test/results/clientpositive/auto_join28.q.out index 369aacf..bfcbce2 100644 --- ql/src/test/results/clientpositive/auto_join28.q.out +++ ql/src/test/results/clientpositive/auto_join28.q.out @@ -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 diff --git ql/src/test/results/clientpositive/auto_join29.q.out ql/src/test/results/clientpositive/auto_join29.q.out index c85cb21..3097ba4 100644 --- ql/src/test/results/clientpositive/auto_join29.q.out +++ ql/src/test/results/clientpositive/auto_join29.q.out @@ -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: diff --git ql/src/test/results/clientpositive/auto_join4.q.out ql/src/test/results/clientpositive/auto_join4.q.out index c5e3ee1..28ee1fe 100644 --- ql/src/test/results/clientpositive/auto_join4.q.out +++ ql/src/test/results/clientpositive/auto_join4.q.out @@ -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: diff --git ql/src/test/results/clientpositive/auto_join5.q.out ql/src/test/results/clientpositive/auto_join5.q.out index ecfd0be..2890c9b 100644 --- ql/src/test/results/clientpositive/auto_join5.q.out +++ ql/src/test/results/clientpositive/auto_join5.q.out @@ -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: diff --git ql/src/test/results/clientpositive/auto_join6.q.out ql/src/test/results/clientpositive/auto_join6.q.out index 861a03c..9dd4744 100644 --- ql/src/test/results/clientpositive/auto_join6.q.out +++ ql/src/test/results/clientpositive/auto_join6.q.out @@ -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: diff --git ql/src/test/results/clientpositive/auto_join7.q.out ql/src/test/results/clientpositive/auto_join7.q.out index 4e041d8..ba566b5 100644 --- ql/src/test/results/clientpositive/auto_join7.q.out +++ ql/src/test/results/clientpositive/auto_join7.q.out @@ -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: diff --git ql/src/test/results/clientpositive/auto_join8.q.out ql/src/test/results/clientpositive/auto_join8.q.out index 663a324..9f49172 100644 --- ql/src/test/results/clientpositive/auto_join8.q.out +++ ql/src/test/results/clientpositive/auto_join8.q.out @@ -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: diff --git ql/src/test/results/clientpositive/cast1.q.out ql/src/test/results/clientpositive/cast1.q.out index 78e3d54..3bc10b3 100644 --- ql/src/test/results/clientpositive/cast1.q.out +++ ql/src/test/results/clientpositive/cast1.q.out @@ -29,7 +29,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/cluster.q.out ql/src/test/results/clientpositive/cluster.q.out index e139b60..353cc70 100644 --- ql/src/test/results/clientpositive/cluster.q.out +++ ql/src/test/results/clientpositive/cluster.q.out @@ -20,7 +20,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 10) + expr: (key = 10.0) type: boolean Select Operator expressions: @@ -88,7 +88,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Select Operator expressions: @@ -156,7 +156,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Select Operator expressions: @@ -224,7 +224,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Select Operator expressions: @@ -292,7 +292,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Select Operator expressions: @@ -360,7 +360,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Select Operator expressions: @@ -428,7 +428,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Select Operator expressions: @@ -519,7 +519,7 @@ STAGE PLANS: Extract Filter Operator predicate: - expr: (_col0 = 20) + expr: (_col0 = 20.0) type: boolean Select Operator expressions: @@ -572,7 +572,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Reduce Output Operator key expressions: @@ -593,7 +593,7 @@ STAGE PLANS: alias: y Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Reduce Output Operator key expressions: @@ -698,7 +698,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Reduce Output Operator key expressions: @@ -719,7 +719,7 @@ STAGE PLANS: alias: y Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Reduce Output Operator key expressions: @@ -830,7 +830,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Reduce Output Operator key expressions: @@ -851,7 +851,7 @@ STAGE PLANS: alias: y Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Reduce Output Operator key expressions: @@ -962,7 +962,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Reduce Output Operator key expressions: @@ -983,7 +983,7 @@ STAGE PLANS: alias: y Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Reduce Output Operator key expressions: @@ -1099,7 +1099,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: @@ -1135,7 +1135,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key > 100) + expr: (key > 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/create_view.q.out ql/src/test/results/clientpositive/create_view.q.out index 8808084..26f3015 100644 --- ql/src/test/results/clientpositive/create_view.q.out +++ ql/src/test/results/clientpositive/create_view.q.out @@ -186,7 +186,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 18) + expr: (key = 18.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out index 7a638a2..37aa6dc 100644 --- ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out +++ ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out @@ -79,7 +79,7 @@ STAGE PLANS: Forward Filter Operator predicate: - expr: (KEY._col0 >= 5) + expr: (KEY._col0 >= 5.0) type: boolean Group By Operator aggregations: @@ -129,7 +129,7 @@ STAGE PLANS: name: default.dest_g2 Filter Operator predicate: - expr: (KEY._col0 < 5) + expr: (KEY._col0 < 5.0) type: boolean Group By Operator aggregations: @@ -480,7 +480,7 @@ STAGE PLANS: Forward Filter Operator predicate: - expr: (KEY._col0 >= 5) + expr: (KEY._col0 >= 5.0) type: boolean Group By Operator aggregations: @@ -530,7 +530,7 @@ STAGE PLANS: name: default.dest_g2 Filter Operator predicate: - expr: (KEY._col0 < 5) + expr: (KEY._col0 < 5.0) type: boolean Group By Operator aggregations: @@ -723,7 +723,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat Filter Operator predicate: - expr: (KEY._col0 >= 5) + expr: (KEY._col0 >= 5.0) type: boolean Group By Operator aggregations: diff --git ql/src/test/results/clientpositive/having.q.out ql/src/test/results/clientpositive/having.q.out index 61c846b..5661c42 100644 --- ql/src/test/results/clientpositive/having.q.out +++ ql/src/test/results/clientpositive/having.q.out @@ -113,7 +113,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key <> 302) + expr: (key <> 302.0) type: boolean Select Operator expressions: @@ -792,7 +792,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key > 300) + expr: (key > 300.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_auto.q.out ql/src/test/results/clientpositive/index_auto.q.out index 58b76f3..80d045a 100644 --- ql/src/test/results/clientpositive/index_auto.q.out +++ ql/src/test/results/clientpositive/index_auto.q.out @@ -83,7 +83,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Select Operator expressions: @@ -176,11 +176,11 @@ STAGE PLANS: TableScan alias: default__src_src_index__ filterExpr: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Filter Operator predicate: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Select Operator expressions: @@ -218,11 +218,11 @@ STAGE PLANS: TableScan alias: src filterExpr: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Filter Operator predicate: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_auto_empty.q.out ql/src/test/results/clientpositive/index_auto_empty.q.out index ed4e274..d219457 100644 --- ql/src/test/results/clientpositive/index_auto_empty.q.out +++ ql/src/test/results/clientpositive/index_auto_empty.q.out @@ -62,11 +62,11 @@ STAGE PLANS: TableScan alias: temp filterExpr: - expr: (key = 86) + expr: (key = 86.0) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_auto_file_format.q.out ql/src/test/results/clientpositive/index_auto_file_format.q.out index 549c8b9..400d3f9 100644 --- ql/src/test/results/clientpositive/index_auto_file_format.q.out +++ ql/src/test/results/clientpositive/index_auto_file_format.q.out @@ -43,11 +43,11 @@ STAGE PLANS: TableScan alias: default__src_src_index__ filterExpr: - expr: (key = 86) + expr: (key = 86.0) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: @@ -85,11 +85,11 @@ STAGE PLANS: TableScan alias: src filterExpr: - expr: (key = 86) + expr: (key = 86.0) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: @@ -175,11 +175,11 @@ STAGE PLANS: TableScan alias: default__src_src_index__ filterExpr: - expr: (key = 86) + expr: (key = 86.0) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: @@ -217,11 +217,11 @@ STAGE PLANS: TableScan alias: src filterExpr: - expr: (key = 86) + expr: (key = 86.0) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_auto_mult_tables.q.out ql/src/test/results/clientpositive/index_auto_mult_tables.q.out index a132d71..4d885b4 100644 --- ql/src/test/results/clientpositive/index_auto_mult_tables.q.out +++ ql/src/test/results/clientpositive/index_auto_mult_tables.q.out @@ -25,7 +25,7 @@ STAGE PLANS: alias: a Filter Operator predicate: - expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90)) + expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0)) type: boolean Reduce Output Operator key expressions: @@ -46,7 +46,7 @@ STAGE PLANS: alias: b Filter Operator predicate: - expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100)) + expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0)) type: boolean Reduce Output Operator key expressions: @@ -262,11 +262,11 @@ STAGE PLANS: TableScan alias: default__srcpart_srcpart_index__ filterExpr: - expr: (((((key > 70) and (key < 90)) and (key > 80)) and (key < 100)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) + expr: (((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) type: boolean Filter Operator predicate: - expr: (((((key > 70) and (key < 90)) and (key > 80)) and (key < 100)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) + expr: (((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) type: boolean Select Operator expressions: @@ -349,11 +349,11 @@ STAGE PLANS: TableScan alias: a filterExpr: - expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90)) + expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0)) type: boolean Filter Operator predicate: - expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90)) + expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0)) type: boolean Reduce Output Operator key expressions: @@ -373,11 +373,11 @@ STAGE PLANS: TableScan alias: b filterExpr: - expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100)) + expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0)) type: boolean Filter Operator predicate: - expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100)) + expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0)) type: boolean Reduce Output Operator key expressions: @@ -445,11 +445,11 @@ STAGE PLANS: TableScan alias: default__src_src_index__ filterExpr: - expr: (((((key > 80) and (key < 100)) and (key > 70)) and (key < 90)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) + expr: (((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) type: boolean Filter Operator predicate: - expr: (((((key > 80) and (key < 100)) and (key > 70)) and (key < 90)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) + expr: (((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out index a1df2b3..860d3bb 100644 --- ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out +++ ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out @@ -25,7 +25,7 @@ STAGE PLANS: alias: a Filter Operator predicate: - expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90)) + expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0)) type: boolean Reduce Output Operator key expressions: @@ -46,7 +46,7 @@ STAGE PLANS: alias: b Filter Operator predicate: - expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100)) + expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0)) type: boolean Reduce Output Operator key expressions: @@ -264,11 +264,11 @@ STAGE PLANS: TableScan alias: default__srcpart_srcpart_index__ filterExpr: - expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100)) + expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0)) type: boolean Filter Operator predicate: - expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100)) + expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0)) type: boolean Select Operator expressions: @@ -306,11 +306,11 @@ STAGE PLANS: TableScan alias: a filterExpr: - expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90)) + expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0)) type: boolean Filter Operator predicate: - expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90)) + expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0)) type: boolean Reduce Output Operator key expressions: @@ -330,11 +330,11 @@ STAGE PLANS: TableScan alias: b filterExpr: - expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100)) + expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0)) type: boolean Filter Operator predicate: - expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100)) + expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0)) type: boolean Reduce Output Operator key expressions: @@ -413,11 +413,11 @@ STAGE PLANS: TableScan alias: default__src_src_index__ filterExpr: - expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90)) + expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0)) type: boolean Filter Operator predicate: - expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90)) + expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0)) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_auto_multiple.q.out ql/src/test/results/clientpositive/index_auto_multiple.q.out index a068ab3..abff457 100644 --- ql/src/test/results/clientpositive/index_auto_multiple.q.out +++ ql/src/test/results/clientpositive/index_auto_multiple.q.out @@ -67,11 +67,11 @@ STAGE PLANS: TableScan alias: default__src_src_key_index__ filterExpr: - expr: (key = 86) + expr: (key = 86.0) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: @@ -109,11 +109,11 @@ STAGE PLANS: TableScan alias: src filterExpr: - expr: (key = 86) + expr: (key = 86.0) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_auto_partitioned.q.out ql/src/test/results/clientpositive/index_auto_partitioned.q.out index 27e20b8..ba28e6c 100644 --- ql/src/test/results/clientpositive/index_auto_partitioned.q.out +++ ql/src/test/results/clientpositive/index_auto_partitioned.q.out @@ -55,11 +55,11 @@ STAGE PLANS: TableScan alias: default__srcpart_src_part_index__ filterExpr: - expr: ((key = 86) and (ds = '2008-04-09')) + expr: ((key = 86.0) and (ds = '2008-04-09')) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: @@ -97,11 +97,11 @@ STAGE PLANS: TableScan alias: srcpart filterExpr: - expr: ((key = 86) and (ds = '2008-04-09')) + expr: ((key = 86.0) and (ds = '2008-04-09')) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_auto_self_join.q.out ql/src/test/results/clientpositive/index_auto_self_join.q.out index 078aea7..62b256b 100644 --- ql/src/test/results/clientpositive/index_auto_self_join.q.out +++ ql/src/test/results/clientpositive/index_auto_self_join.q.out @@ -23,7 +23,7 @@ STAGE PLANS: alias: a Filter Operator predicate: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Reduce Output Operator key expressions: @@ -42,7 +42,7 @@ STAGE PLANS: alias: b Filter Operator predicate: - expr: ((key > 70) and (key < 90)) + expr: ((key > 70.0) and (key < 90.0)) type: boolean Reduce Output Operator key expressions: @@ -173,11 +173,11 @@ STAGE PLANS: TableScan alias: default__src_src_index__ filterExpr: - expr: (((key > 70) and (key < 90)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) + expr: (((key > 70.0) and (key < 90.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) type: boolean Filter Operator predicate: - expr: (((key > 70) and (key < 90)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) + expr: (((key > 70.0) and (key < 90.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) type: boolean Select Operator expressions: @@ -260,11 +260,11 @@ STAGE PLANS: TableScan alias: a filterExpr: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Filter Operator predicate: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Reduce Output Operator key expressions: @@ -282,11 +282,11 @@ STAGE PLANS: TableScan alias: b filterExpr: - expr: ((key > 70) and (key < 90)) + expr: ((key > 70.0) and (key < 90.0)) type: boolean Filter Operator predicate: - expr: ((key > 70) and (key < 90)) + expr: ((key > 70.0) and (key < 90.0)) type: boolean Reduce Output Operator key expressions: @@ -354,11 +354,11 @@ STAGE PLANS: TableScan alias: default__src_src_index__ filterExpr: - expr: (((key > 80) and (key < 100)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) + expr: (((key > 80.0) and (key < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) type: boolean Filter Operator predicate: - expr: (((key > 80) and (key < 100)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) + expr: (((key > 80.0) and (key < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_auto_unused.q.out ql/src/test/results/clientpositive/index_auto_unused.q.out index 125b5e0..c5a51ff 100644 --- ql/src/test/results/clientpositive/index_auto_unused.q.out +++ ql/src/test/results/clientpositive/index_auto_unused.q.out @@ -42,11 +42,11 @@ STAGE PLANS: TableScan alias: src filterExpr: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Filter Operator predicate: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Select Operator expressions: @@ -134,11 +134,11 @@ STAGE PLANS: TableScan alias: src filterExpr: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Filter Operator predicate: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Select Operator expressions: @@ -226,11 +226,11 @@ STAGE PLANS: TableScan alias: src filterExpr: - expr: ((key < 10) or (key > 480)) + expr: ((key < 10.0) or (key > 480.0)) type: boolean Filter Operator predicate: - expr: ((key < 10) or (key > 480)) + expr: ((key < 10.0) or (key > 480.0)) type: boolean Select Operator expressions: @@ -363,11 +363,11 @@ STAGE PLANS: TableScan alias: src filterExpr: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Filter Operator predicate: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Select Operator expressions: @@ -502,11 +502,11 @@ STAGE PLANS: TableScan alias: srcpart filterExpr: - expr: (((ds = '2008-04-09') and (hr = 12)) and (key < 10)) + expr: (((ds = '2008-04-09') and (hr = 12.0)) and (key < 10.0)) type: boolean Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_auto_update.q.out ql/src/test/results/clientpositive/index_auto_update.q.out index 0af0115..e8c9c0c 100644 --- ql/src/test/results/clientpositive/index_auto_update.q.out +++ ql/src/test/results/clientpositive/index_auto_update.q.out @@ -268,11 +268,11 @@ STAGE PLANS: TableScan alias: default__temp_temp_index__ filterExpr: - expr: (key = 86) + expr: (key = 86.0) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: @@ -310,11 +310,11 @@ STAGE PLANS: TableScan alias: temp filterExpr: - expr: (key = 86) + expr: (key = 86.0) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_bitmap3.q.out ql/src/test/results/clientpositive/index_bitmap3.q.out index 335a27e..ac302ce 100644 --- ql/src/test/results/clientpositive/index_bitmap3.q.out +++ ql/src/test/results/clientpositive/index_bitmap3.q.out @@ -149,7 +149,7 @@ STAGE PLANS: alias: default__src_src1_index__ Filter Operator predicate: - expr: (key = 0) + expr: (key = 0.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_bitmap_auto.q.out ql/src/test/results/clientpositive/index_bitmap_auto.q.out index 0314344..5526cb8 100644 --- ql/src/test/results/clientpositive/index_bitmap_auto.q.out +++ ql/src/test/results/clientpositive/index_bitmap_auto.q.out @@ -168,7 +168,7 @@ STAGE PLANS: alias: default__src_src1_index__ Filter Operator predicate: - expr: (key = 0) + expr: (key = 0.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out index aee253b..67dfc10 100644 --- ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out +++ ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out @@ -54,11 +54,11 @@ STAGE PLANS: TableScan alias: default__srcpart_src_part_index__ filterExpr: - expr: ((key = 86) and (not EWAH_BITMAP_EMPTY(_bitmaps))) + expr: ((key = 86.0) and (not EWAH_BITMAP_EMPTY(_bitmaps))) type: boolean Filter Operator predicate: - expr: ((key = 86) and (not EWAH_BITMAP_EMPTY(_bitmaps))) + expr: ((key = 86.0) and (not EWAH_BITMAP_EMPTY(_bitmaps))) type: boolean Select Operator expressions: @@ -141,11 +141,11 @@ STAGE PLANS: TableScan alias: srcpart filterExpr: - expr: ((key = 86) and (ds = '2008-04-09')) + expr: ((key = 86.0) and (ds = '2008-04-09')) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_bitmap_compression.q.out ql/src/test/results/clientpositive/index_bitmap_compression.q.out index 80bf3e7..53d5fa9 100644 --- ql/src/test/results/clientpositive/index_bitmap_compression.q.out +++ ql/src/test/results/clientpositive/index_bitmap_compression.q.out @@ -42,11 +42,11 @@ STAGE PLANS: TableScan alias: default__src_src_index__ filterExpr: - expr: (((key > 80) and (key < 100)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) + expr: (((key > 80.0) and (key < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) type: boolean Filter Operator predicate: - expr: (((key > 80) and (key < 100)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) + expr: (((key > 80.0) and (key < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) type: boolean Select Operator expressions: @@ -129,11 +129,11 @@ STAGE PLANS: TableScan alias: src filterExpr: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Filter Operator predicate: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_compression.q.out ql/src/test/results/clientpositive/index_compression.q.out index 7ecd854..ea4c969 100644 --- ql/src/test/results/clientpositive/index_compression.q.out +++ ql/src/test/results/clientpositive/index_compression.q.out @@ -43,11 +43,11 @@ STAGE PLANS: TableScan alias: default__src_src_index__ filterExpr: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Filter Operator predicate: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Select Operator expressions: @@ -85,11 +85,11 @@ STAGE PLANS: TableScan alias: src filterExpr: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Filter Operator predicate: - expr: ((key > 80) and (key < 100)) + expr: ((key > 80.0) and (key < 100.0)) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_stale.q.out ql/src/test/results/clientpositive/index_stale.q.out index fc6982f..81aa310 100644 --- ql/src/test/results/clientpositive/index_stale.q.out +++ ql/src/test/results/clientpositive/index_stale.q.out @@ -84,11 +84,11 @@ STAGE PLANS: TableScan alias: temp filterExpr: - expr: (key = 86) + expr: (key = 86.0) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/index_stale_partitioned.q.out ql/src/test/results/clientpositive/index_stale_partitioned.q.out index 793b505..7b40efc 100644 --- ql/src/test/results/clientpositive/index_stale_partitioned.q.out +++ ql/src/test/results/clientpositive/index_stale_partitioned.q.out @@ -108,11 +108,11 @@ STAGE PLANS: TableScan alias: temp filterExpr: - expr: ((key = 86) and (foo = 'bar')) + expr: ((key = 86.0) and (foo = 'bar')) type: boolean Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/input11.q.out ql/src/test/results/clientpositive/input11.q.out index 3ded9f7..c8e80b3 100644 --- ql/src/test/results/clientpositive/input11.q.out +++ ql/src/test/results/clientpositive/input11.q.out @@ -31,7 +31,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/input11_limit.q.out ql/src/test/results/clientpositive/input11_limit.q.out index 2b7e1f8..8c3af00 100644 --- ql/src/test/results/clientpositive/input11_limit.q.out +++ ql/src/test/results/clientpositive/input11_limit.q.out @@ -28,7 +28,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/input12.q.out ql/src/test/results/clientpositive/input12.q.out index 6f91bf9..2929907 100644 --- ql/src/test/results/clientpositive/input12.q.out +++ ql/src/test/results/clientpositive/input12.q.out @@ -55,7 +55,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: @@ -81,7 +81,7 @@ STAGE PLANS: name: default.dest1 Filter Operator predicate: - expr: ((key >= 100) and (key < 200)) + expr: ((key >= 100.0) and (key < 200.0)) type: boolean Select Operator expressions: @@ -107,7 +107,7 @@ STAGE PLANS: name: default.dest2 Filter Operator predicate: - expr: (key >= 200) + expr: (key >= 200.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/input13.q.out ql/src/test/results/clientpositive/input13.q.out index 623a108..d808b3a 100644 --- ql/src/test/results/clientpositive/input13.q.out +++ ql/src/test/results/clientpositive/input13.q.out @@ -61,7 +61,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: @@ -87,7 +87,7 @@ STAGE PLANS: name: default.dest1 Filter Operator predicate: - expr: ((key >= 100) and (key < 200)) + expr: ((key >= 100.0) and (key < 200.0)) type: boolean Select Operator expressions: @@ -113,7 +113,7 @@ STAGE PLANS: name: default.dest2 Filter Operator predicate: - expr: ((key >= 200) and (key < 300)) + expr: ((key >= 200.0) and (key < 300.0)) type: boolean Select Operator expressions: @@ -135,7 +135,7 @@ STAGE PLANS: name: default.dest3 Filter Operator predicate: - expr: (key >= 300) + expr: (key >= 300.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/input14.q.out ql/src/test/results/clientpositive/input14.q.out index ee5ee54..84ed1fd 100644 --- ql/src/test/results/clientpositive/input14.q.out +++ ql/src/test/results/clientpositive/input14.q.out @@ -50,7 +50,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Filter Operator predicate: - expr: (_col0 < 100) + expr: (_col0 < 100.0) type: boolean Reduce Output Operator key expressions: diff --git ql/src/test/results/clientpositive/input14_limit.q.out ql/src/test/results/clientpositive/input14_limit.q.out index 6bee6cf..77c6566 100644 --- ql/src/test/results/clientpositive/input14_limit.q.out +++ ql/src/test/results/clientpositive/input14_limit.q.out @@ -96,7 +96,7 @@ STAGE PLANS: Limit Filter Operator predicate: - expr: (_col0 < 100) + expr: (_col0 < 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/input18.q.out ql/src/test/results/clientpositive/input18.q.out index 932e5f6..cb7b37b 100644 --- ql/src/test/results/clientpositive/input18.q.out +++ ql/src/test/results/clientpositive/input18.q.out @@ -54,7 +54,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Filter Operator predicate: - expr: (_col0 < 100) + expr: (_col0 < 100.0) type: boolean Reduce Output Operator key expressions: diff --git ql/src/test/results/clientpositive/input1_limit.q.out ql/src/test/results/clientpositive/input1_limit.q.out index 317f729..f3f0e4e 100644 --- ql/src/test/results/clientpositive/input1_limit.q.out +++ ql/src/test/results/clientpositive/input1_limit.q.out @@ -38,7 +38,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: @@ -58,7 +58,7 @@ STAGE PLANS: type: string Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/input2_limit.q.out ql/src/test/results/clientpositive/input2_limit.q.out index 251b5c0..15a443b 100644 --- ql/src/test/results/clientpositive/input2_limit.q.out +++ ql/src/test/results/clientpositive/input2_limit.q.out @@ -20,7 +20,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key < 300) + expr: (key < 300.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/input42.q.out ql/src/test/results/clientpositive/input42.q.out index 9eae5fd..922fcec 100644 --- ql/src/test/results/clientpositive/input42.q.out +++ ql/src/test/results/clientpositive/input42.q.out @@ -1184,7 +1184,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 200) + expr: (key < 200.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/input_part1.q.out ql/src/test/results/clientpositive/input_part1.q.out index 10ad56d..bb8c4b3 100644 --- ql/src/test/results/clientpositive/input_part1.q.out +++ ql/src/test/results/clientpositive/input_part1.q.out @@ -33,7 +33,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/input_part2.q.out ql/src/test/results/clientpositive/input_part2.q.out index 06cad7e..e8ac858 100644 --- ql/src/test/results/clientpositive/input_part2.q.out +++ ql/src/test/results/clientpositive/input_part2.q.out @@ -45,7 +45,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key < 100) and (ds = '2008-04-08')) + expr: ((key < 100.0) and (ds = '2008-04-08')) type: boolean Select Operator expressions: @@ -96,7 +96,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key < 100) and (ds = '2008-04-09')) + expr: ((key < 100.0) and (ds = '2008-04-09')) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/input_part5.q.out ql/src/test/results/clientpositive/input_part5.q.out index bfc9f9b..b773a3d 100644 --- ql/src/test/results/clientpositive/input_part5.q.out +++ ql/src/test/results/clientpositive/input_part5.q.out @@ -31,7 +31,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/input_part7.q.out ql/src/test/results/clientpositive/input_part7.q.out index 1e9dfa9..2e847fd 100644 --- ql/src/test/results/clientpositive/input_part7.q.out +++ ql/src/test/results/clientpositive/input_part7.q.out @@ -32,7 +32,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: @@ -85,7 +85,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/join0.q.out ql/src/test/results/clientpositive/join0.q.out index 6d5fc0b..fe5bb5c 100644 --- ql/src/test/results/clientpositive/join0.q.out +++ ql/src/test/results/clientpositive/join0.q.out @@ -31,7 +31,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: @@ -53,7 +53,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/join11.q.out ql/src/test/results/clientpositive/join11.q.out index 201dc47..347a482 100644 --- ql/src/test/results/clientpositive/join11.q.out +++ ql/src/test/results/clientpositive/join11.q.out @@ -30,7 +30,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/join12.q.out ql/src/test/results/clientpositive/join12.q.out index 52b30b9..83c5ff1 100644 --- ql/src/test/results/clientpositive/join12.q.out +++ ql/src/test/results/clientpositive/join12.q.out @@ -36,7 +36,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: @@ -82,7 +82,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 80) + expr: (key < 80.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/join13.q.out ql/src/test/results/clientpositive/join13.q.out index 92801d8..7044f3a 100644 --- ql/src/test/results/clientpositive/join13.q.out +++ ql/src/test/results/clientpositive/join13.q.out @@ -37,7 +37,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: @@ -119,7 +119,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 200) + expr: (key < 200.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/join14.q.out ql/src/test/results/clientpositive/join14.q.out index 94832df..92e4b7e 100644 --- ql/src/test/results/clientpositive/join14.q.out +++ ql/src/test/results/clientpositive/join14.q.out @@ -28,7 +28,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key > 100) + expr: (key > 100.0) type: boolean Reduce Output Operator key expressions: diff --git ql/src/test/results/clientpositive/join16.q.out ql/src/test/results/clientpositive/join16.q.out index 4e17a03..1fc80da 100644 --- ql/src/test/results/clientpositive/join16.q.out +++ ql/src/test/results/clientpositive/join16.q.out @@ -18,7 +18,7 @@ STAGE PLANS: alias: a Filter Operator predicate: - expr: (((key > 10) and (key > 20)) and (value < 200)) + expr: (((key > 10.0) and (key > 20.0)) and (value < 200.0)) type: boolean Select Operator expressions: @@ -48,7 +48,7 @@ STAGE PLANS: alias: tab Filter Operator predicate: - expr: (value < 200) + expr: (value < 200.0) type: boolean Reduce Output Operator key expressions: diff --git ql/src/test/results/clientpositive/join20.q.out ql/src/test/results/clientpositive/join20.q.out index 2b6e985..29a09a4 100644 --- ql/src/test/results/clientpositive/join20.q.out +++ ql/src/test/results/clientpositive/join20.q.out @@ -23,7 +23,7 @@ STAGE PLANS: alias: src1 Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Reduce Output Operator key expressions: @@ -85,7 +85,7 @@ STAGE PLANS: filter predicates: 0 1 - 2 {(VALUE._col0 < 20)} + 2 {(VALUE._col0 < 20.0)} handleSkewJoin: false outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 Select Operator @@ -740,7 +740,7 @@ STAGE PLANS: alias: src1 Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Reduce Output Operator key expressions: @@ -761,7 +761,7 @@ STAGE PLANS: alias: src2 Filter Operator predicate: - expr: (key < 15) + expr: (key < 15.0) type: boolean Reduce Output Operator key expressions: @@ -806,7 +806,7 @@ STAGE PLANS: filter predicates: 0 1 - 2 {(VALUE._col0 < 20)} + 2 {(VALUE._col0 < 20.0)} handleSkewJoin: false outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 Select Operator diff --git ql/src/test/results/clientpositive/join21.q.out ql/src/test/results/clientpositive/join21.q.out index 454dd18..c794da0 100644 --- ql/src/test/results/clientpositive/join21.q.out +++ ql/src/test/results/clientpositive/join21.q.out @@ -38,7 +38,7 @@ STAGE PLANS: alias: src2 Filter Operator predicate: - expr: (key > 10) + expr: (key > 10.0) type: boolean Reduce Output Operator key expressions: @@ -81,9 +81,9 @@ STAGE PLANS: 1 {VALUE._col0} {VALUE._col1} 2 {VALUE._col0} {VALUE._col1} filter predicates: - 0 {(VALUE._col0 < 10)} + 0 {(VALUE._col0 < 10.0)} 1 - 2 {(VALUE._col0 < 10)} + 2 {(VALUE._col0 < 10.0)} handleSkewJoin: false outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 Select Operator diff --git ql/src/test/results/clientpositive/join23.q.out ql/src/test/results/clientpositive/join23.q.out index cdee6a7..9229e9c 100644 --- ql/src/test/results/clientpositive/join23.q.out +++ ql/src/test/results/clientpositive/join23.q.out @@ -21,7 +21,7 @@ STAGE PLANS: alias: src1 Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Reduce Output Operator sort order: @@ -36,7 +36,7 @@ STAGE PLANS: alias: src2 Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Reduce Output Operator sort order: diff --git ql/src/test/results/clientpositive/join34.q.out ql/src/test/results/clientpositive/join34.q.out index 8a02fd6..e44a5d6 100644 --- ql/src/test/results/clientpositive/join34.q.out +++ ql/src/test/results/clientpositive/join34.q.out @@ -67,7 +67,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 20) + expr: (key < 20.0) type: boolean Select Operator expressions: @@ -138,7 +138,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key > 100) + expr: (key > 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/join35.q.out ql/src/test/results/clientpositive/join35.q.out index e2f8668..cb8933d 100644 --- ql/src/test/results/clientpositive/join35.q.out +++ ql/src/test/results/clientpositive/join35.q.out @@ -48,7 +48,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 20) + expr: (key < 20.0) type: boolean Select Operator expressions: @@ -451,7 +451,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key > 100) + expr: (key > 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/join38.q.out ql/src/test/results/clientpositive/join38.q.out index dae307a..ee7c0d8 100644 --- ql/src/test/results/clientpositive/join38.q.out +++ ql/src/test/results/clientpositive/join38.q.out @@ -91,7 +91,7 @@ STAGE PLANS: alias: a Filter Operator predicate: - expr: (key = 111) + expr: (key = 111.0) type: boolean HashTable Sink Operator condition expressions: @@ -111,7 +111,7 @@ STAGE PLANS: alias: b Filter Operator predicate: - expr: (col11 = 111) + expr: (col11 = 111.0) type: boolean Map Join Operator condition map: diff --git ql/src/test/results/clientpositive/join39.q.out ql/src/test/results/clientpositive/join39.q.out index f895fb2..942002a 100644 --- ql/src/test/results/clientpositive/join39.q.out +++ ql/src/test/results/clientpositive/join39.q.out @@ -38,7 +38,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key <= 100) + expr: (key <= 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/join4.q.out ql/src/test/results/clientpositive/join4.q.out index 3bce5f0..6e18925 100644 --- ql/src/test/results/clientpositive/join4.q.out +++ ql/src/test/results/clientpositive/join4.q.out @@ -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: diff --git ql/src/test/results/clientpositive/join40.q.out ql/src/test/results/clientpositive/join40.q.out index 03671c1..bcd2b59 100644 --- ql/src/test/results/clientpositive/join40.q.out +++ ql/src/test/results/clientpositive/join40.q.out @@ -37,7 +37,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key <= 100) + expr: (key <= 100.0) type: boolean Select Operator expressions: @@ -1806,7 +1806,7 @@ STAGE PLANS: alias: src1 Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Reduce Output Operator key expressions: @@ -1868,7 +1868,7 @@ STAGE PLANS: filter predicates: 0 1 - 2 {(VALUE._col0 < 20)} + 2 {(VALUE._col0 < 20.0)} handleSkewJoin: false outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 Select Operator @@ -2523,7 +2523,7 @@ STAGE PLANS: alias: src1 Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Reduce Output Operator key expressions: @@ -2544,7 +2544,7 @@ STAGE PLANS: alias: src2 Filter Operator predicate: - expr: (key < 15) + expr: (key < 15.0) type: boolean Reduce Output Operator key expressions: @@ -2589,7 +2589,7 @@ STAGE PLANS: filter predicates: 0 1 - 2 {(VALUE._col0 < 20)} + 2 {(VALUE._col0 < 20.0)} handleSkewJoin: false outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 Select Operator @@ -3248,7 +3248,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key <= 100) + expr: (key <= 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/join5.q.out ql/src/test/results/clientpositive/join5.q.out index 5f729d1..22c778a 100644 --- ql/src/test/results/clientpositive/join5.q.out +++ ql/src/test/results/clientpositive/join5.q.out @@ -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: diff --git ql/src/test/results/clientpositive/join6.q.out ql/src/test/results/clientpositive/join6.q.out index 676b422..8bb6d74 100644 --- ql/src/test/results/clientpositive/join6.q.out +++ ql/src/test/results/clientpositive/join6.q.out @@ -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: diff --git ql/src/test/results/clientpositive/join7.q.out ql/src/test/results/clientpositive/join7.q.out index 359811a..f508507 100644 --- ql/src/test/results/clientpositive/join7.q.out +++ ql/src/test/results/clientpositive/join7.q.out @@ -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: diff --git ql/src/test/results/clientpositive/join8.q.out ql/src/test/results/clientpositive/join8.q.out index ce78ac7..97b1e92 100644 --- ql/src/test/results/clientpositive/join8.q.out +++ ql/src/test/results/clientpositive/join8.q.out @@ -50,7 +50,7 @@ STAGE PLANS: alias: src1 Filter Operator predicate: - expr: (((key > 10) and (key < 20)) and key is not null) + expr: (((key > 10.0) and (key < 20.0)) and key is not null) type: boolean Select Operator expressions: @@ -78,7 +78,7 @@ STAGE PLANS: alias: src2 Filter Operator predicate: - expr: (((key > 15) and (key < 25)) and key is not null) + expr: (((key > 15.0) and (key < 25.0)) and key is not null) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/load_dyn_part13.q.out ql/src/test/results/clientpositive/load_dyn_part13.q.out index 9418700..8824ecf 100644 --- ql/src/test/results/clientpositive/load_dyn_part13.q.out +++ ql/src/test/results/clientpositive/load_dyn_part13.q.out @@ -60,7 +60,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 20) + expr: (key < 20.0) type: boolean Select Operator expressions: @@ -94,7 +94,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: ((key > 20) and (key < 40)) + expr: ((key > 20.0) and (key < 40.0)) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/louter_join_ppr.q.out ql/src/test/results/clientpositive/louter_join_ppr.q.out index 641fd68..9c0a02b 100644 --- ql/src/test/results/clientpositive/louter_join_ppr.q.out +++ ql/src/test/results/clientpositive/louter_join_ppr.q.out @@ -34,7 +34,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Reduce Output Operator key expressions: @@ -57,7 +57,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Reduce Output Operator key expressions: @@ -195,7 +195,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((_col4 > 15) and (_col4 < 25)) + expr: ((_col4 > 15.0) and (_col4 < 25.0)) type: boolean Select Operator expressions: @@ -303,7 +303,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Reduce Output Operator key expressions: @@ -328,7 +328,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Reduce Output Operator key expressions: @@ -543,7 +543,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((_col6 > 15) and (_col6 < 25)) + expr: ((_col6 > 15.0) and (_col6 < 25.0)) type: boolean Select Operator expressions: @@ -655,7 +655,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Reduce Output Operator key expressions: @@ -678,7 +678,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Reduce Output Operator key expressions: @@ -892,7 +892,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (((_col4 > 15) and (_col4 < 25)) and (_col6 = '2008-04-08')) + expr: (((_col4 > 15.0) and (_col4 < 25.0)) and (_col6 = '2008-04-08')) type: boolean Select Operator expressions: @@ -1004,7 +1004,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Reduce Output Operator key expressions: @@ -1029,7 +1029,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Reduce Output Operator key expressions: @@ -1167,7 +1167,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((_col6 > 15) and (_col6 < 25)) + expr: ((_col6 > 15.0) and (_col6 < 25.0)) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/multi_insert.q.out ql/src/test/results/clientpositive/multi_insert.q.out index 542bf47..0a9012d 100644 --- ql/src/test/results/clientpositive/multi_insert.q.out +++ ql/src/test/results/clientpositive/multi_insert.q.out @@ -37,7 +37,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: @@ -56,7 +56,7 @@ STAGE PLANS: name: default.src_multi1 Filter Operator predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Select Operator expressions: @@ -201,7 +201,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: @@ -220,7 +220,7 @@ STAGE PLANS: name: default.src_multi1 Filter Operator predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Select Operator expressions: @@ -419,7 +419,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: @@ -438,7 +438,7 @@ STAGE PLANS: name: default.src_multi1 Filter Operator predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Select Operator expressions: @@ -615,7 +615,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: @@ -634,7 +634,7 @@ STAGE PLANS: name: default.src_multi1 Filter Operator predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Select Operator expressions: @@ -865,7 +865,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: ((key < 10) or ((key > 10) and (key < 20))) + expr: ((key < 10.0) or ((key > 10.0) and (key < 20.0))) type: boolean Select Operator expressions: @@ -1118,7 +1118,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: ((key < 10) or ((key > 10) and (key < 20))) + expr: ((key < 10.0) or ((key > 10.0) and (key < 20.0))) type: boolean Select Operator expressions: @@ -1409,7 +1409,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: ((key < 10) or ((key > 10) and (key < 20))) + expr: ((key < 10.0) or ((key > 10.0) and (key < 20.0))) type: boolean Select Operator expressions: @@ -1662,7 +1662,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: ((key < 10) or ((key > 10) and (key < 20))) + expr: ((key < 10.0) or ((key > 10.0) and (key < 20.0))) type: boolean Select Operator expressions: @@ -1961,7 +1961,7 @@ STAGE PLANS: Union Filter Operator predicate: - expr: (_col0 < 10) + expr: (_col0 < 10.0) type: boolean Select Operator expressions: @@ -1980,7 +1980,7 @@ STAGE PLANS: name: default.src_multi1 Filter Operator predicate: - expr: ((_col0 > 10) and (_col0 < 20)) + expr: ((_col0 > 10.0) and (_col0 < 20.0)) type: boolean Select Operator expressions: @@ -2010,7 +2010,7 @@ STAGE PLANS: Union Filter Operator predicate: - expr: (_col0 < 10) + expr: (_col0 < 10.0) type: boolean Select Operator expressions: @@ -2029,7 +2029,7 @@ STAGE PLANS: name: default.src_multi1 Filter Operator predicate: - expr: ((_col0 > 10) and (_col0 < 20)) + expr: ((_col0 > 10.0) and (_col0 < 20.0)) type: boolean Select Operator expressions: @@ -2265,7 +2265,7 @@ STAGE PLANS: Union Filter Operator predicate: - expr: (_col0 < 10) + expr: (_col0 < 10.0) type: boolean Select Operator expressions: @@ -2284,7 +2284,7 @@ STAGE PLANS: name: default.src_multi1 Filter Operator predicate: - expr: ((_col0 > 10) and (_col0 < 20)) + expr: ((_col0 > 10.0) and (_col0 < 20.0)) type: boolean Select Operator expressions: @@ -2314,7 +2314,7 @@ STAGE PLANS: Union Filter Operator predicate: - expr: (_col0 < 10) + expr: (_col0 < 10.0) type: boolean Select Operator expressions: @@ -2333,7 +2333,7 @@ STAGE PLANS: name: default.src_multi1 Filter Operator predicate: - expr: ((_col0 > 10) and (_col0 < 20)) + expr: ((_col0 > 10.0) and (_col0 < 20.0)) type: boolean Select Operator expressions: @@ -2623,7 +2623,7 @@ STAGE PLANS: Union Filter Operator predicate: - expr: (_col0 < 10) + expr: (_col0 < 10.0) type: boolean Select Operator expressions: @@ -2642,7 +2642,7 @@ STAGE PLANS: name: default.src_multi1 Filter Operator predicate: - expr: ((_col0 > 10) and (_col0 < 20)) + expr: ((_col0 > 10.0) and (_col0 < 20.0)) type: boolean Select Operator expressions: @@ -2672,7 +2672,7 @@ STAGE PLANS: Union Filter Operator predicate: - expr: (_col0 < 10) + expr: (_col0 < 10.0) type: boolean Select Operator expressions: @@ -2691,7 +2691,7 @@ STAGE PLANS: name: default.src_multi1 Filter Operator predicate: - expr: ((_col0 > 10) and (_col0 < 20)) + expr: ((_col0 > 10.0) and (_col0 < 20.0)) type: boolean Select Operator expressions: @@ -2959,7 +2959,7 @@ STAGE PLANS: Union Filter Operator predicate: - expr: (_col0 < 10) + expr: (_col0 < 10.0) type: boolean Select Operator expressions: @@ -2978,7 +2978,7 @@ STAGE PLANS: name: default.src_multi1 Filter Operator predicate: - expr: ((_col0 > 10) and (_col0 < 20)) + expr: ((_col0 > 10.0) and (_col0 < 20.0)) type: boolean Select Operator expressions: @@ -3008,7 +3008,7 @@ STAGE PLANS: Union Filter Operator predicate: - expr: (_col0 < 10) + expr: (_col0 < 10.0) type: boolean Select Operator expressions: @@ -3027,7 +3027,7 @@ STAGE PLANS: name: default.src_multi1 Filter Operator predicate: - expr: ((_col0 > 10) and (_col0 < 20)) + expr: ((_col0 > 10.0) and (_col0 < 20.0)) type: boolean Select Operator expressions: @@ -3338,7 +3338,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 0) + expr: (key = 0.0) type: boolean Select Operator expressions: @@ -3355,7 +3355,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Filter Operator predicate: - expr: (key = 2) + expr: (key = 2.0) type: boolean Select Operator expressions: @@ -3372,7 +3372,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Filter Operator predicate: - expr: (key = 4) + expr: (key = 4.0) type: boolean Select Operator expressions: @@ -3510,7 +3510,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 0) + expr: (key = 0.0) type: boolean Select Operator expressions: @@ -3527,7 +3527,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Filter Operator predicate: - expr: (key = 2) + expr: (key = 2.0) type: boolean Select Operator expressions: @@ -3544,7 +3544,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Filter Operator predicate: - expr: (key = 4) + expr: (key = 4.0) type: boolean Select Operator expressions: @@ -3682,7 +3682,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 0) + expr: (key = 0.0) type: boolean Select Operator expressions: @@ -3699,7 +3699,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Filter Operator predicate: - expr: (key = 2) + expr: (key = 2.0) type: boolean Select Operator expressions: @@ -3716,7 +3716,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Filter Operator predicate: - expr: (key = 4) + expr: (key = 4.0) type: boolean Select Operator expressions: @@ -3854,7 +3854,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 0) + expr: (key = 0.0) type: boolean Select Operator expressions: @@ -3871,7 +3871,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Filter Operator predicate: - expr: (key = 2) + expr: (key = 2.0) type: boolean Select Operator expressions: @@ -3888,7 +3888,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Filter Operator predicate: - expr: (key = 4) + expr: (key = 4.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/no_hooks.q.out ql/src/test/results/clientpositive/no_hooks.q.out index 4684fb6..1ca0fe3 100644 --- ql/src/test/results/clientpositive/no_hooks.q.out +++ ql/src/test/results/clientpositive/no_hooks.q.out @@ -18,7 +18,7 @@ STAGE PLANS: alias: src1 Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Reduce Output Operator sort order: @@ -33,7 +33,7 @@ STAGE PLANS: alias: src2 Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Reduce Output Operator sort order: diff --git ql/src/test/results/clientpositive/noalias_subq1.q.out ql/src/test/results/clientpositive/noalias_subq1.q.out index b3fe101..b51f68c 100644 --- ql/src/test/results/clientpositive/noalias_subq1.q.out +++ ql/src/test/results/clientpositive/noalias_subq1.q.out @@ -20,7 +20,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/notable_alias1.q.out ql/src/test/results/clientpositive/notable_alias1.q.out index 7bd6241..db89c1e 100644 --- ql/src/test/results/clientpositive/notable_alias1.q.out +++ ql/src/test/results/clientpositive/notable_alias1.q.out @@ -28,7 +28,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/notable_alias2.q.out ql/src/test/results/clientpositive/notable_alias2.q.out index 8d136f7..e144b72 100644 --- ql/src/test/results/clientpositive/notable_alias2.q.out +++ ql/src/test/results/clientpositive/notable_alias2.q.out @@ -28,7 +28,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/nullgroup.q.out ql/src/test/results/clientpositive/nullgroup.q.out index 7a7866b..434fa6c 100644 --- ql/src/test/results/clientpositive/nullgroup.q.out +++ ql/src/test/results/clientpositive/nullgroup.q.out @@ -20,7 +20,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key > 9999) + expr: (key > 9999.0) type: boolean Select Operator Group By Operator @@ -90,7 +90,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key > 9999) + expr: (key > 9999.0) type: boolean Select Operator Group By Operator @@ -161,7 +161,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key > 9999) + expr: (key > 9999.0) type: boolean Select Operator Reduce Output Operator @@ -252,7 +252,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key > 9999) + expr: (key > 9999.0) type: boolean Select Operator Reduce Output Operator diff --git ql/src/test/results/clientpositive/nullgroup2.q.out ql/src/test/results/clientpositive/nullgroup2.q.out index 4af2252..aa52d62 100644 --- ql/src/test/results/clientpositive/nullgroup2.q.out +++ ql/src/test/results/clientpositive/nullgroup2.q.out @@ -21,7 +21,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key > 9999) + expr: (key > 9999.0) type: boolean Select Operator expressions: @@ -141,7 +141,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key > 9999) + expr: (key > 9999.0) type: boolean Select Operator expressions: @@ -229,7 +229,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key > 9999) + expr: (key > 9999.0) type: boolean Select Operator expressions: @@ -340,7 +340,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key > 9999) + expr: (key > 9999.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/nullgroup4.q.out ql/src/test/results/clientpositive/nullgroup4.q.out index d219261..3dd3c66 100644 --- ql/src/test/results/clientpositive/nullgroup4.q.out +++ ql/src/test/results/clientpositive/nullgroup4.q.out @@ -21,7 +21,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 9999) + expr: (key = 9999.0) type: boolean Select Operator expressions: @@ -137,7 +137,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 9999) + expr: (key = 9999.0) type: boolean Select Operator expressions: @@ -224,7 +224,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 9999) + expr: (key = 9999.0) type: boolean Select Operator expressions: @@ -328,7 +328,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 9999) + expr: (key = 9999.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out index 3e8f5ea..9ac4bbc 100644 --- ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out +++ ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out @@ -20,7 +20,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 9999) + expr: (key = 9999.0) type: boolean Select Operator expressions: @@ -116,7 +116,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 9999) + expr: (key = 9999.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/order2.q.out ql/src/test/results/clientpositive/order2.q.out index 4841f3f..d8d666c 100644 --- ql/src/test/results/clientpositive/order2.q.out +++ ql/src/test/results/clientpositive/order2.q.out @@ -45,7 +45,7 @@ STAGE PLANS: Limit Filter Operator predicate: - expr: (_col0 < 10) + expr: (_col0 < 10.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/outer_join_ppr.q.out ql/src/test/results/clientpositive/outer_join_ppr.q.out index 05c5642..954e72f 100644 --- ql/src/test/results/clientpositive/outer_join_ppr.q.out +++ ql/src/test/results/clientpositive/outer_join_ppr.q.out @@ -264,7 +264,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((((_col4 > 15) and (_col4 < 25)) and (_col0 > 10)) and (_col0 < 20)) + expr: ((((_col4 > 15.0) and (_col4 < 25.0)) and (_col0 > 10.0)) and (_col0 < 20.0)) type: boolean Select Operator expressions: @@ -603,7 +603,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (((((_col4 > 15) and (_col4 < 25)) and (_col6 = '2008-04-08')) and (_col0 > 10)) and (_col0 < 20)) + expr: (((((_col4 > 15.0) and (_col4 < 25.0)) and (_col6 = '2008-04-08')) and (_col0 > 10.0)) and (_col0 < 20.0)) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/pcr.q.out ql/src/test/results/clientpositive/pcr.q.out index 6f742f2..7ad1a72 100644 --- ql/src/test/results/clientpositive/pcr.q.out +++ ql/src/test/results/clientpositive/pcr.q.out @@ -4624,7 +4624,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key = 11) + expr: (key = 11.0) type: boolean Select Operator expressions: @@ -4825,7 +4825,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key = 11) + expr: (key = 11.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/ppd_clusterby.q.out ql/src/test/results/clientpositive/ppd_clusterby.q.out index 61441cf..80e373e 100644 --- ql/src/test/results/clientpositive/ppd_clusterby.q.out +++ ql/src/test/results/clientpositive/ppd_clusterby.q.out @@ -20,11 +20,11 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 10) + expr: (key = 10.0) type: boolean Filter Operator predicate: - expr: (key = 10) + expr: (key = 10.0) type: boolean Select Operator expressions: @@ -93,7 +93,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Reduce Output Operator key expressions: @@ -114,7 +114,7 @@ STAGE PLANS: alias: y Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Reduce Output Operator key expressions: @@ -139,7 +139,7 @@ STAGE PLANS: outputColumnNames: _col0, _col1, _col4 Filter Operator predicate: - expr: (_col0 = 20) + expr: (_col0 = 20.0) type: boolean Select Operator expressions: @@ -222,7 +222,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 10) + expr: (key = 10.0) type: boolean Select Operator expressions: @@ -291,7 +291,7 @@ STAGE PLANS: alias: x Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Reduce Output Operator key expressions: @@ -312,7 +312,7 @@ STAGE PLANS: alias: y Filter Operator predicate: - expr: (key = 20) + expr: (key = 20.0) type: boolean Reduce Output Operator key expressions: diff --git ql/src/test/results/clientpositive/ppd_multi_insert.q.out ql/src/test/results/clientpositive/ppd_multi_insert.q.out index 1e983c4..851ddff 100644 --- ql/src/test/results/clientpositive/ppd_multi_insert.q.out +++ ql/src/test/results/clientpositive/ppd_multi_insert.q.out @@ -84,7 +84,7 @@ STAGE PLANS: outputColumnNames: _col0, _col1 Filter Operator predicate: - expr: (_col0 < 100) + expr: (_col0 < 100.0) type: boolean Select Operator expressions: @@ -110,7 +110,7 @@ STAGE PLANS: name: default.mi1 Filter Operator predicate: - expr: ((_col0 >= 100) and (_col0 < 200)) + expr: ((_col0 >= 100.0) and (_col0 < 200.0)) type: boolean Select Operator expressions: @@ -136,7 +136,7 @@ STAGE PLANS: name: default.mi2 Filter Operator predicate: - expr: ((_col0 >= 200) and (_col0 < 300)) + expr: ((_col0 >= 200.0) and (_col0 < 300.0)) type: boolean Select Operator expressions: @@ -158,7 +158,7 @@ STAGE PLANS: name: default.mi3 Filter Operator predicate: - expr: (_col0 >= 300) + expr: (_col0 >= 300.0) type: boolean Select Operator expressions: @@ -1391,7 +1391,7 @@ STAGE PLANS: outputColumnNames: _col0, _col1 Filter Operator predicate: - expr: (_col0 < 100) + expr: (_col0 < 100.0) type: boolean Select Operator expressions: @@ -1417,7 +1417,7 @@ STAGE PLANS: name: default.mi1 Filter Operator predicate: - expr: ((_col0 >= 100) and (_col0 < 200)) + expr: ((_col0 >= 100.0) and (_col0 < 200.0)) type: boolean Select Operator expressions: @@ -1443,7 +1443,7 @@ STAGE PLANS: name: default.mi2 Filter Operator predicate: - expr: ((_col0 >= 200) and (_col0 < 300)) + expr: ((_col0 >= 200.0) and (_col0 < 300.0)) type: boolean Select Operator expressions: @@ -1465,7 +1465,7 @@ STAGE PLANS: name: default.mi3 Filter Operator predicate: - expr: (_col0 >= 300) + expr: (_col0 >= 300.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/ppd_outer_join1.q.out ql/src/test/results/clientpositive/ppd_outer_join1.q.out index b65f69b..8b97943 100644 --- ql/src/test/results/clientpositive/ppd_outer_join1.q.out +++ ql/src/test/results/clientpositive/ppd_outer_join1.q.out @@ -32,7 +32,7 @@ STAGE PLANS: alias: a Filter Operator predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Reduce Output Operator key expressions: @@ -53,7 +53,7 @@ STAGE PLANS: alias: b Filter Operator predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Reduce Output Operator key expressions: @@ -80,7 +80,7 @@ STAGE PLANS: outputColumnNames: _col0, _col1, _col4, _col5 Filter Operator predicate: - expr: ((((_col0 > 10) and (_col0 < 20)) and (_col4 > 15)) and (_col4 < 25)) + expr: ((((_col0 > 10.0) and (_col0 < 20.0)) and (_col4 > 15.0)) and (_col4 < 25.0)) type: boolean Select Operator expressions: @@ -165,7 +165,7 @@ STAGE PLANS: alias: a Filter Operator predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Reduce Output Operator key expressions: @@ -186,7 +186,7 @@ STAGE PLANS: alias: b Filter Operator predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Reduce Output Operator key expressions: @@ -213,7 +213,7 @@ STAGE PLANS: outputColumnNames: _col0, _col1, _col4, _col5 Filter Operator predicate: - expr: ((_col4 > 15) and (_col4 < 25)) + expr: ((_col4 > 15.0) and (_col4 < 25.0)) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/ppd_transform.q.out ql/src/test/results/clientpositive/ppd_transform.q.out index 1cd9844..bb35013 100644 --- ql/src/test/results/clientpositive/ppd_transform.q.out +++ ql/src/test/results/clientpositive/ppd_transform.q.out @@ -60,7 +60,7 @@ STAGE PLANS: Extract Filter Operator predicate: - expr: (_col0 < 100) + expr: (_col0 < 100.0) type: boolean Select Operator expressions: @@ -231,7 +231,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Filter Operator predicate: - expr: (_col0 < 100) + expr: (_col0 < 100.0) type: boolean Reduce Output Operator key expressions: diff --git ql/src/test/results/clientpositive/ppd_udf_col.q.out ql/src/test/results/clientpositive/ppd_udf_col.q.out index 632f315..4ff573e 100644 --- ql/src/test/results/clientpositive/ppd_udf_col.q.out +++ ql/src/test/results/clientpositive/ppd_udf_col.q.out @@ -24,11 +24,11 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 100) + expr: (key = 100.0) type: boolean Filter Operator predicate: - expr: (key = 100) + expr: (key = 100.0) type: boolean Select Operator expressions: @@ -90,11 +90,11 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 100) + expr: (key = 100.0) type: boolean Filter Operator predicate: - expr: (key = 100) + expr: (key = 100.0) type: boolean Select Operator expressions: @@ -164,11 +164,11 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 100) + expr: (key = 100.0) type: boolean Filter Operator predicate: - expr: (key = 100) + expr: (key = 100.0) type: boolean Select Operator expressions: @@ -181,7 +181,7 @@ STAGE PLANS: outputColumnNames: _col0, _col2, _col3 Filter Operator predicate: - expr: (_col3 <= 3) + expr: (_col3 <= 3.0) type: boolean Select Operator expressions: @@ -230,11 +230,11 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 100) + expr: (key = 100.0) type: boolean Filter Operator predicate: - expr: (key = 100) + expr: (key = 100.0) type: boolean Select Operator expressions: @@ -247,7 +247,7 @@ STAGE PLANS: outputColumnNames: _col0, _col2, _col3 Filter Operator predicate: - expr: (_col3 <= 200) + expr: (_col3 <= 200.0) type: boolean Select Operator expressions: @@ -296,7 +296,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 100) + expr: (key = 100.0) type: boolean Select Operator expressions: @@ -358,7 +358,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 100) + expr: (key = 100.0) type: boolean Select Operator expressions: @@ -424,7 +424,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 100) + expr: (key = 100.0) type: boolean Select Operator expressions: @@ -437,7 +437,7 @@ STAGE PLANS: outputColumnNames: _col0, _col2, _col3 Filter Operator predicate: - expr: (_col3 <= 3) + expr: (_col3 <= 3.0) type: boolean Select Operator expressions: @@ -486,7 +486,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 100) + expr: (key = 100.0) type: boolean Select Operator expressions: @@ -499,7 +499,7 @@ STAGE PLANS: outputColumnNames: _col0, _col2, _col3 Filter Operator predicate: - expr: (_col3 <= 200) + expr: (_col3 <= 200.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/ppr_pushdown3.q.out ql/src/test/results/clientpositive/ppr_pushdown3.q.out index d0ddaa7..038fa5b 100644 --- ql/src/test/results/clientpositive/ppr_pushdown3.q.out +++ ql/src/test/results/clientpositive/ppr_pushdown3.q.out @@ -18,7 +18,7 @@ STAGE PLANS: alias: srcpart Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/quote1.q.out ql/src/test/results/clientpositive/quote1.q.out index 323c8a6..9e67744 100644 --- ql/src/test/results/clientpositive/quote1.q.out +++ ql/src/test/results/clientpositive/quote1.q.out @@ -31,7 +31,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: ((key >= 200) and (key < 300)) + expr: ((key >= 200.0) and (key < 300.0)) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/rand_partitionpruner3.q.out ql/src/test/results/clientpositive/rand_partitionpruner3.q.out index 4e9358b..b52b281 100644 --- ql/src/test/results/clientpositive/rand_partitionpruner3.q.out +++ ql/src/test/results/clientpositive/rand_partitionpruner3.q.out @@ -24,7 +24,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((rand(1) < 0.1) and (not ((key > 50) or (key < 10)))) + expr: ((rand(1) < 0.1) and (not ((key > 50.0) or (key < 10.0)))) type: boolean Select Operator expressions: @@ -138,7 +138,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (not ((key > 50) or (key < 10))) + expr: (not ((key > 50.0) or (key < 10.0))) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/rcfile_null_value.q.out ql/src/test/results/clientpositive/rcfile_null_value.q.out index e55e837..bf0d79f 100644 --- ql/src/test/results/clientpositive/rcfile_null_value.q.out +++ ql/src/test/results/clientpositive/rcfile_null_value.q.out @@ -104,7 +104,7 @@ STAGE PLANS: alias: src1 Filter Operator predicate: - expr: ((key > 10) and (key < 20)) + expr: ((key > 10.0) and (key < 20.0)) type: boolean Select Operator expressions: @@ -132,7 +132,7 @@ STAGE PLANS: alias: src2 Filter Operator predicate: - expr: ((key > 15) and (key < 25)) + expr: ((key > 15.0) and (key < 25.0)) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/regex_col.q.out ql/src/test/results/clientpositive/regex_col.q.out index 7bafc2c..b0f8bf2 100644 --- ql/src/test/results/clientpositive/regex_col.q.out +++ ql/src/test/results/clientpositive/regex_col.q.out @@ -214,7 +214,7 @@ STAGE PLANS: alias: a Filter Operator predicate: - expr: (key = 103) + expr: (key = 103.0) type: boolean Reduce Output Operator key expressions: diff --git ql/src/test/results/clientpositive/regexp_extract.q.out ql/src/test/results/clientpositive/regexp_extract.q.out index 4f54529..cc76129 100644 --- ql/src/test/results/clientpositive/regexp_extract.q.out +++ ql/src/test/results/clientpositive/regexp_extract.q.out @@ -56,7 +56,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (_col0 < 100) + expr: (_col0 < 100.0) type: boolean Reduce Output Operator key expressions: @@ -302,7 +302,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (_col0 < 100) + expr: (_col0 < 100.0) type: boolean Reduce Output Operator key expressions: diff --git ql/src/test/results/clientpositive/router_join_ppr.q.out ql/src/test/results/clientpositive/router_join_ppr.q.out index 8eb4ece..c6e6335 100644 --- ql/src/test/results/clientpositive/router_join_ppr.q.out +++ ql/src/test/results/clientpositive/router_join_ppr.q.out @@ -34,7 +34,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 15) and (key < 25)) + expr: ((key > 15.0) and (key < 25.0)) type: boolean Reduce Output Operator key expressions: @@ -57,7 +57,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 15) and (key < 25)) + expr: ((key > 15.0) and (key < 25.0)) type: boolean Reduce Output Operator key expressions: @@ -274,7 +274,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((_col0 > 10) and (_col0 < 20)) + expr: ((_col0 > 10.0) and (_col0 < 20.0)) type: boolean Select Operator expressions: @@ -386,7 +386,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 15) and (key < 25)) + expr: ((key > 15.0) and (key < 25.0)) type: boolean Reduce Output Operator key expressions: @@ -409,7 +409,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 15) and (key < 25)) + expr: ((key > 15.0) and (key < 25.0)) type: boolean Reduce Output Operator key expressions: @@ -547,7 +547,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((_col0 > 10) and (_col0 < 20)) + expr: ((_col0 > 10.0) and (_col0 < 20.0)) type: boolean Select Operator expressions: @@ -655,7 +655,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 15) and (key < 25)) + expr: ((key > 15.0) and (key < 25.0)) type: boolean Reduce Output Operator key expressions: @@ -678,7 +678,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 15) and (key < 25)) + expr: ((key > 15.0) and (key < 25.0)) type: boolean Reduce Output Operator key expressions: @@ -818,7 +818,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((_col0 > 10) and (_col0 < 20)) + expr: ((_col0 > 10.0) and (_col0 < 20.0)) type: boolean Select Operator expressions: @@ -926,7 +926,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 15) and (key < 25)) + expr: ((key > 15.0) and (key < 25.0)) type: boolean Reduce Output Operator key expressions: @@ -951,7 +951,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((key > 15) and (key < 25)) + expr: ((key > 15.0) and (key < 25.0)) type: boolean Reduce Output Operator key expressions: @@ -1163,7 +1163,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (((_col0 > 10) and (_col0 < 20)) and (_col2 = '2008-04-08')) + expr: (((_col0 > 10.0) and (_col0 < 20.0)) and (_col2 = '2008-04-08')) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/semijoin.q.out ql/src/test/results/clientpositive/semijoin.q.out index 5e0b172..f7ffc92 100644 --- ql/src/test/results/clientpositive/semijoin.q.out +++ ql/src/test/results/clientpositive/semijoin.q.out @@ -515,7 +515,7 @@ STAGE PLANS: alias: b Filter Operator predicate: - expr: (key < '15') + expr: (key < 15) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/set_processor_namespaces.q.out ql/src/test/results/clientpositive/set_processor_namespaces.q.out index d6b58cc..60c7b8c 100644 --- ql/src/test/results/clientpositive/set_processor_namespaces.q.out +++ ql/src/test/results/clientpositive/set_processor_namespaces.q.out @@ -23,7 +23,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 5) + expr: (key = 5.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/skewjoin.q.out ql/src/test/results/clientpositive/skewjoin.q.out index c44c9cd..3797b9d 100644 --- ql/src/test/results/clientpositive/skewjoin.q.out +++ ql/src/test/results/clientpositive/skewjoin.q.out @@ -1191,7 +1191,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: @@ -1237,7 +1237,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 80) + expr: (key < 80.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/subq.q.out ql/src/test/results/clientpositive/subq.q.out index 3460b6e..5156beb 100644 --- ql/src/test/results/clientpositive/subq.q.out +++ ql/src/test/results/clientpositive/subq.q.out @@ -29,7 +29,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/subq2.q.out ql/src/test/results/clientpositive/subq2.q.out index bd5c09a..bcc998d 100644 --- ql/src/test/results/clientpositive/subq2.q.out +++ ql/src/test/results/clientpositive/subq2.q.out @@ -24,7 +24,7 @@ STAGE PLANS: alias: b Filter Operator predicate: - expr: (key >= 90) + expr: (key >= 90.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/transform_ppr1.q.out ql/src/test/results/clientpositive/transform_ppr1.q.out index 634972e..213424a 100644 --- ql/src/test/results/clientpositive/transform_ppr1.q.out +++ ql/src/test/results/clientpositive/transform_ppr1.q.out @@ -53,7 +53,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((_col1 < 100) and (_col0 = '2008-04-08')) + expr: ((_col1 < 100.0) and (_col0 = '2008-04-08')) type: boolean Reduce Output Operator key expressions: diff --git ql/src/test/results/clientpositive/transform_ppr2.q.out ql/src/test/results/clientpositive/transform_ppr2.q.out index 4b526dc..d36623e 100644 --- ql/src/test/results/clientpositive/transform_ppr2.q.out +++ ql/src/test/results/clientpositive/transform_ppr2.q.out @@ -55,7 +55,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (_col1 < 100) + expr: (_col1 < 100.0) type: boolean Reduce Output Operator key expressions: diff --git ql/src/test/results/clientpositive/udf1.q.out ql/src/test/results/clientpositive/udf1.q.out index 8407967..f276f02 100644 --- ql/src/test/results/clientpositive/udf1.q.out +++ ql/src/test/results/clientpositive/udf1.q.out @@ -49,7 +49,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/udf9.q.out ql/src/test/results/clientpositive/udf9.q.out index 24c2895..ea77b7a 100644 --- ql/src/test/results/clientpositive/udf9.q.out +++ ql/src/test/results/clientpositive/udf9.q.out @@ -36,7 +36,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/udf_10_trims.q.out ql/src/test/results/clientpositive/udf_10_trims.q.out index 22f5500..f6af34e 100644 --- ql/src/test/results/clientpositive/udf_10_trims.q.out +++ ql/src/test/results/clientpositive/udf_10_trims.q.out @@ -35,7 +35,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/udf_hour.q.out ql/src/test/results/clientpositive/udf_hour.q.out index 1c41b21..cffbbcd 100644 --- ql/src/test/results/clientpositive/udf_hour.q.out +++ ql/src/test/results/clientpositive/udf_hour.q.out @@ -38,7 +38,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/udf_like.q.out ql/src/test/results/clientpositive/udf_like.q.out index 5f4260c..e9e3a72 100644 --- ql/src/test/results/clientpositive/udf_like.q.out +++ ql/src/test/results/clientpositive/udf_like.q.out @@ -39,7 +39,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/udf_lower.q.out ql/src/test/results/clientpositive/udf_lower.q.out index e2922ad..d1f279c 100644 --- ql/src/test/results/clientpositive/udf_lower.q.out +++ ql/src/test/results/clientpositive/udf_lower.q.out @@ -34,7 +34,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/udf_minute.q.out ql/src/test/results/clientpositive/udf_minute.q.out index cad1104..3a4cf0c 100644 --- ql/src/test/results/clientpositive/udf_minute.q.out +++ ql/src/test/results/clientpositive/udf_minute.q.out @@ -38,7 +38,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/udf_parse_url.q.out ql/src/test/results/clientpositive/udf_parse_url.q.out index e0907e5..0f3a3ec 100644 --- ql/src/test/results/clientpositive/udf_parse_url.q.out +++ ql/src/test/results/clientpositive/udf_parse_url.q.out @@ -61,7 +61,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/udf_second.q.out ql/src/test/results/clientpositive/udf_second.q.out index 0272c8e..63f26b2 100644 --- ql/src/test/results/clientpositive/udf_second.q.out +++ ql/src/test/results/clientpositive/udf_second.q.out @@ -38,7 +38,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key = 86) + expr: (key = 86.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/udf_union.q.out ql/src/test/results/clientpositive/udf_union.q.out index c2a9537..c794039 100644 --- ql/src/test/results/clientpositive/udf_union.q.out +++ ql/src/test/results/clientpositive/udf_union.q.out @@ -39,7 +39,7 @@ STAGE PLANS: expressions: expr: create_union(0,key) type: uniontype - expr: create_union(if((key < 100), 0, 1),2.0,value) + expr: create_union(if((key < 100.0), 0, 1),2.0,value) type: uniontype expr: create_union(1,'a',struct(2,'b')) type: uniontype> diff --git ql/src/test/results/clientpositive/union.q.out ql/src/test/results/clientpositive/union.q.out index e8560a4..b144eae 100644 --- ql/src/test/results/clientpositive/union.q.out +++ ql/src/test/results/clientpositive/union.q.out @@ -37,7 +37,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: @@ -65,7 +65,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: (key > 100) + expr: (key > 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/union20.q.out ql/src/test/results/clientpositive/union20.q.out index 932f472..3ae87b3 100644 --- ql/src/test/results/clientpositive/union20.q.out +++ ql/src/test/results/clientpositive/union20.q.out @@ -116,7 +116,7 @@ STAGE PLANS: alias: s2 Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: @@ -145,7 +145,7 @@ STAGE PLANS: alias: s4 Filter Operator predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/union22.q.out ql/src/test/results/clientpositive/union22.q.out index 27bd3ac..192f254 100644 --- ql/src/test/results/clientpositive/union22.q.out +++ ql/src/test/results/clientpositive/union22.q.out @@ -104,7 +104,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: ((k0 > 50) and (k1 > 20)) + expr: ((k0 > 50.0) and (k1 > 20.0)) type: boolean Select Operator expressions: @@ -138,7 +138,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (k1 > 20) + expr: (k1 > 20.0) type: boolean Map Join Operator condition map: @@ -341,7 +341,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (k0 <= 50) + expr: (k0 <= 50.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/union24.q.out ql/src/test/results/clientpositive/union24.q.out index 1ca76cf..1aa5863 100644 --- ql/src/test/results/clientpositive/union24.q.out +++ ql/src/test/results/clientpositive/union24.q.out @@ -69,7 +69,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: @@ -208,7 +208,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: @@ -243,7 +243,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: @@ -278,7 +278,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: @@ -572,7 +572,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Reduce Output Operator key expressions: @@ -593,7 +593,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Reduce Output Operator key expressions: @@ -759,7 +759,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: @@ -794,7 +794,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: @@ -1037,7 +1037,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Reduce Output Operator key expressions: @@ -1058,7 +1058,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Reduce Output Operator key expressions: @@ -1297,7 +1297,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: @@ -1332,7 +1332,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 10) + expr: (key < 10.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/clientpositive/union_ppr.q.out ql/src/test/results/clientpositive/union_ppr.q.out index 4d448d1..7d4e480 100644 --- ql/src/test/results/clientpositive/union_ppr.q.out +++ ql/src/test/results/clientpositive/union_ppr.q.out @@ -34,7 +34,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: @@ -87,7 +87,7 @@ STAGE PLANS: Filter Operator isSamplingPred: false predicate: - expr: (key < 100) + expr: (key < 100.0) type: boolean Select Operator expressions: diff --git ql/src/test/results/compiler/plan/cast1.q.xml ql/src/test/results/compiler/plan/cast1.q.xml index c071530..9f63222 100644 --- ql/src/test/results/compiler/plan/cast1.q.xml +++ ql/src/test/results/compiler/plan/cast1.q.xml @@ -894,10 +894,10 @@ - + - 86 + 86.0 diff --git ql/src/test/results/compiler/plan/input1.q.xml ql/src/test/results/compiler/plan/input1.q.xml index 66d8b62..e698cf5 100755 --- ql/src/test/results/compiler/plan/input1.q.xml +++ ql/src/test/results/compiler/plan/input1.q.xml @@ -821,12 +821,12 @@ - int + double - 100 + 100.0 diff --git ql/src/test/results/compiler/plan/input2.q.xml ql/src/test/results/compiler/plan/input2.q.xml index d0e15f2..cc3fc53 100755 --- ql/src/test/results/compiler/plan/input2.q.xml +++ ql/src/test/results/compiler/plan/input2.q.xml @@ -1745,12 +1745,12 @@ - int + double - 100 + 100.0 @@ -2049,7 +2049,7 @@ - 100 + 100.0 @@ -2086,7 +2086,7 @@ - 200 + 200.0 @@ -2231,7 +2231,11 @@ _col1 - + + + int + + 2 @@ -2327,7 +2331,7 @@ _col1 - + @@ -2364,7 +2368,7 @@ - 200 + 200.0 diff --git ql/src/test/results/compiler/plan/input3.q.xml ql/src/test/results/compiler/plan/input3.q.xml index fd213a5..d606ccc 100755 --- ql/src/test/results/compiler/plan/input3.q.xml +++ ql/src/test/results/compiler/plan/input3.q.xml @@ -2081,12 +2081,12 @@ - int + double - 100 + 100.0 @@ -2385,7 +2385,7 @@ - 100 + 100.0 @@ -2422,7 +2422,7 @@ - 200 + 200.0 @@ -2567,7 +2567,11 @@ _col1 - + + + int + + 2 @@ -2663,7 +2667,7 @@ _col1 - + @@ -2704,7 +2708,7 @@ - 200 + 200.0 @@ -2741,7 +2745,7 @@ - 300 + 300.0 @@ -2986,7 +2990,7 @@ - 300 + 300.0 diff --git ql/src/test/results/compiler/plan/input4.q.xml ql/src/test/results/compiler/plan/input4.q.xml index 1ef69c2..ff9565b 100755 --- ql/src/test/results/compiler/plan/input4.q.xml +++ ql/src/test/results/compiler/plan/input4.q.xml @@ -532,12 +532,12 @@ - int + double - 100 + 100.0 diff --git ql/src/test/results/compiler/plan/input_part1.q.xml ql/src/test/results/compiler/plan/input_part1.q.xml index fc5146a..a489754 100644 --- ql/src/test/results/compiler/plan/input_part1.q.xml +++ ql/src/test/results/compiler/plan/input_part1.q.xml @@ -545,12 +545,12 @@ - int + double - 100 + 100.0 diff --git ql/src/test/results/compiler/plan/join4.q.xml ql/src/test/results/compiler/plan/join4.q.xml index 29958bb..f717867 100644 --- ql/src/test/results/compiler/plan/join4.q.xml +++ ql/src/test/results/compiler/plan/join4.q.xml @@ -640,12 +640,12 @@ - int + double - 10 + 10.0 @@ -686,7 +686,7 @@ - 20 + 20.0 @@ -1226,7 +1226,7 @@ - 15 + 15.0 @@ -1263,7 +1263,7 @@ - 25 + 25.0 diff --git ql/src/test/results/compiler/plan/join5.q.xml ql/src/test/results/compiler/plan/join5.q.xml index a92a557..768959d 100644 --- ql/src/test/results/compiler/plan/join5.q.xml +++ ql/src/test/results/compiler/plan/join5.q.xml @@ -640,12 +640,12 @@ - int + double - 10 + 10.0 @@ -686,7 +686,7 @@ - 20 + 20.0 @@ -1226,7 +1226,7 @@ - 15 + 15.0 @@ -1263,7 +1263,7 @@ - 25 + 25.0 diff --git ql/src/test/results/compiler/plan/join6.q.xml ql/src/test/results/compiler/plan/join6.q.xml index 4705a14..cf5befe 100644 --- ql/src/test/results/compiler/plan/join6.q.xml +++ ql/src/test/results/compiler/plan/join6.q.xml @@ -640,12 +640,12 @@ - int + double - 10 + 10.0 @@ -686,7 +686,7 @@ - 20 + 20.0 @@ -1226,7 +1226,7 @@ - 15 + 15.0 @@ -1263,7 +1263,7 @@ - 25 + 25.0 diff --git ql/src/test/results/compiler/plan/join7.q.xml ql/src/test/results/compiler/plan/join7.q.xml index 238b204..8e4097f 100644 --- ql/src/test/results/compiler/plan/join7.q.xml +++ ql/src/test/results/compiler/plan/join7.q.xml @@ -772,12 +772,12 @@ - int + double - 10 + 10.0 @@ -818,7 +818,7 @@ - 20 + 20.0 @@ -1358,7 +1358,7 @@ - 15 + 15.0 @@ -1395,7 +1395,7 @@ - 25 + 25.0 @@ -1931,7 +1931,7 @@ - 20 + 20.0 @@ -1968,7 +1968,7 @@ - 25 + 25.0 diff --git ql/src/test/results/compiler/plan/join8.q.xml ql/src/test/results/compiler/plan/join8.q.xml index 2d66e93..954c10a 100644 --- ql/src/test/results/compiler/plan/join8.q.xml +++ ql/src/test/results/compiler/plan/join8.q.xml @@ -644,12 +644,12 @@ - int + double - 10 + 10.0 @@ -690,7 +690,7 @@ - 20 + 20.0 @@ -1271,7 +1271,7 @@ - 15 + 15.0 @@ -1308,7 +1308,7 @@ - 25 + 25.0 diff --git ql/src/test/results/compiler/plan/subq.q.xml ql/src/test/results/compiler/plan/subq.q.xml index f361966..61f989c 100644 --- ql/src/test/results/compiler/plan/subq.q.xml +++ ql/src/test/results/compiler/plan/subq.q.xml @@ -849,12 +849,12 @@ - int + double - 100 + 100.0 diff --git ql/src/test/results/compiler/plan/udf1.q.xml ql/src/test/results/compiler/plan/udf1.q.xml index 8ccf72a..ba68fcd 100644 --- ql/src/test/results/compiler/plan/udf1.q.xml +++ ql/src/test/results/compiler/plan/udf1.q.xml @@ -1718,12 +1718,12 @@ - int + double - 86 + 86.0 diff --git ql/src/test/results/compiler/plan/union.q.xml ql/src/test/results/compiler/plan/union.q.xml index 2398b0f..b89bccd 100644 --- ql/src/test/results/compiler/plan/union.q.xml +++ ql/src/test/results/compiler/plan/union.q.xml @@ -987,12 +987,12 @@ - int + double - 100 + 100.0 @@ -1367,7 +1367,7 @@ - 100 + 100.0