You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2013/10/22 19:59:08 UTC
svn commit: r1534711 [10/15] - in /hive/branches/maven: ./
ant/src/org/apache/hadoop/hive/ant/
beeline/src/java/org/apache/hive/beeline/ bin/ bin/ext/
cli/src/java/org/apache/hadoop/hive/cli/ common/
common/src/java/org/apache/hadoop/hive/common/type/ ...
Modified: hive/branches/maven/ql/src/test/results/clientpositive/varchar_nested_types.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientpositive/varchar_nested_types.q.out?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientpositive/varchar_nested_types.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientpositive/varchar_nested_types.q.out Tue Oct 22 17:58:59 2013
@@ -28,12 +28,12 @@ POSTHOOK: query: create table varchar_ne
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@varchar_nested_1
PREHOOK: query: insert overwrite table varchar_nested_1
- select key, value from src limit 5
+ select key, value from src order by key limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@varchar_nested_1
POSTHOOK: query: insert overwrite table varchar_nested_1
- select key, value from src limit 5
+ select key, value from src order by key limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@varchar_nested_1
@@ -80,11 +80,7 @@ POSTHOOK: Input: default@varchar_nested_
POSTHOOK: Lineage: varchar_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: varchar_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: varchar_nested_array.c1 EXPRESSION [(varchar_nested_1)varchar_nested_1.FieldSchema(name:value, type:varchar(20), comment:null), ]
-["val_238","val_238"]
-["val_86","val_86"]
-["val_311","val_311"]
-["val_27","val_27"]
-["val_165","val_165"]
+["val_0","val_0"]
PREHOOK: query: -- maps
create table varchar_nested_map (c1 map<int, varchar(20)>)
PREHOOK: type: CREATETABLE
@@ -130,11 +126,7 @@ POSTHOOK: Lineage: varchar_nested_1.key
POSTHOOK: Lineage: varchar_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: varchar_nested_array.c1 EXPRESSION [(varchar_nested_1)varchar_nested_1.FieldSchema(name:value, type:varchar(20), comment:null), ]
POSTHOOK: Lineage: varchar_nested_map.c1 EXPRESSION [(varchar_nested_1)varchar_nested_1.FieldSchema(name:key, type:int, comment:null), (varchar_nested_1)varchar_nested_1.FieldSchema(name:value, type:varchar(20), comment:null), ]
-{238:"val_238"}
-{86:"val_86"}
-{311:"val_311"}
-{27:"val_27"}
-{165:"val_165"}
+{0:"val_0"}
PREHOOK: query: -- structs
create table varchar_nested_struct (c1 struct<a:int, b:varchar(20), c:string>)
PREHOOK: type: CREATETABLE
@@ -190,11 +182,7 @@ POSTHOOK: Lineage: varchar_nested_1.valu
POSTHOOK: Lineage: varchar_nested_array.c1 EXPRESSION [(varchar_nested_1)varchar_nested_1.FieldSchema(name:value, type:varchar(20), comment:null), ]
POSTHOOK: Lineage: varchar_nested_map.c1 EXPRESSION [(varchar_nested_1)varchar_nested_1.FieldSchema(name:key, type:int, comment:null), (varchar_nested_1)varchar_nested_1.FieldSchema(name:value, type:varchar(20), comment:null), ]
POSTHOOK: Lineage: varchar_nested_struct.c1 EXPRESSION [(varchar_nested_1)varchar_nested_1.FieldSchema(name:key, type:int, comment:null), (varchar_nested_1)varchar_nested_1.FieldSchema(name:value, type:varchar(20), comment:null), ]
-{"a":238,"b":"val_238","c":"val_238"}
-{"a":86,"b":"val_86","c":"val_86"}
-{"a":311,"b":"val_311","c":"val_311"}
-{"a":27,"b":"val_27","c":"val_27"}
-{"a":165,"b":"val_165","c":"val_165"}
+{"a":0,"b":"val_0","c":"val_0"}
PREHOOK: query: -- nested type with create table as
create table varchar_nested_cta as
select * from varchar_nested_struct
@@ -234,11 +222,7 @@ POSTHOOK: Lineage: varchar_nested_1.valu
POSTHOOK: Lineage: varchar_nested_array.c1 EXPRESSION [(varchar_nested_1)varchar_nested_1.FieldSchema(name:value, type:varchar(20), comment:null), ]
POSTHOOK: Lineage: varchar_nested_map.c1 EXPRESSION [(varchar_nested_1)varchar_nested_1.FieldSchema(name:key, type:int, comment:null), (varchar_nested_1)varchar_nested_1.FieldSchema(name:value, type:varchar(20), comment:null), ]
POSTHOOK: Lineage: varchar_nested_struct.c1 EXPRESSION [(varchar_nested_1)varchar_nested_1.FieldSchema(name:key, type:int, comment:null), (varchar_nested_1)varchar_nested_1.FieldSchema(name:value, type:varchar(20), comment:null), ]
-{"a":238,"b":"val_238","c":"val_238"}
-{"a":86,"b":"val_86","c":"val_86"}
-{"a":311,"b":"val_311","c":"val_311"}
-{"a":27,"b":"val_27","c":"val_27"}
-{"a":165,"b":"val_165","c":"val_165"}
+{"a":0,"b":"val_0","c":"val_0"}
PREHOOK: query: -- nested type with view
create table varchar_nested_view as
select * from varchar_nested_struct
@@ -278,11 +262,7 @@ POSTHOOK: Lineage: varchar_nested_1.valu
POSTHOOK: Lineage: varchar_nested_array.c1 EXPRESSION [(varchar_nested_1)varchar_nested_1.FieldSchema(name:value, type:varchar(20), comment:null), ]
POSTHOOK: Lineage: varchar_nested_map.c1 EXPRESSION [(varchar_nested_1)varchar_nested_1.FieldSchema(name:key, type:int, comment:null), (varchar_nested_1)varchar_nested_1.FieldSchema(name:value, type:varchar(20), comment:null), ]
POSTHOOK: Lineage: varchar_nested_struct.c1 EXPRESSION [(varchar_nested_1)varchar_nested_1.FieldSchema(name:key, type:int, comment:null), (varchar_nested_1)varchar_nested_1.FieldSchema(name:value, type:varchar(20), comment:null), ]
-{"a":238,"b":"val_238","c":"val_238"}
-{"a":86,"b":"val_86","c":"val_86"}
-{"a":311,"b":"val_311","c":"val_311"}
-{"a":27,"b":"val_27","c":"val_27"}
-{"a":165,"b":"val_165","c":"val_165"}
+{"a":0,"b":"val_0","c":"val_0"}
PREHOOK: query: drop table varchar_nested_1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@varchar_nested_1
Modified: hive/branches/maven/ql/src/test/results/clientpositive/varchar_udf1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientpositive/varchar_udf1.q.out?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientpositive/varchar_udf1.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientpositive/varchar_udf1.q.out Tue Oct 22 17:58:59 2013
@@ -8,12 +8,12 @@ POSTHOOK: query: create table varchar_ud
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@varchar_udf_1
PREHOOK: query: insert overwrite table varchar_udf_1
- select key, value, key, value from src limit 5
+ select key, value, key, value from src where key = '238' limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@varchar_udf_1
POSTHOOK: query: insert overwrite table varchar_udf_1
- select key, value, key, value from src limit 5
+ select key, value, key, value from src where key = '238' limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@varchar_udf_1
@@ -501,7 +501,7 @@ POSTHOOK: Lineage: varchar_udf_1.c1 SIMP
POSTHOOK: Lineage: varchar_udf_1.c2 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: varchar_udf_1.c3 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: varchar_udf_1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-{"columntype":"String","maxlength":7,"avglength":6.6,"countnulls":0,"numdistinctvalues":7} {"columntype":"String","maxlength":7,"avglength":6.6,"countnulls":0,"numdistinctvalues":7}
+{"columntype":"String","maxlength":7,"avglength":7.0,"countnulls":0,"numdistinctvalues":1} {"columntype":"String","maxlength":7,"avglength":7.0,"countnulls":0,"numdistinctvalues":1}
PREHOOK: query: select
min(c2),
min(c4)
@@ -520,7 +520,7 @@ POSTHOOK: Lineage: varchar_udf_1.c1 SIMP
POSTHOOK: Lineage: varchar_udf_1.c2 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: varchar_udf_1.c3 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: varchar_udf_1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-val_165 val_165
+val_238 val_238
PREHOOK: query: select
max(c2),
max(c4)
@@ -539,7 +539,7 @@ POSTHOOK: Lineage: varchar_udf_1.c1 SIMP
POSTHOOK: Lineage: varchar_udf_1.c2 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: varchar_udf_1.c3 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: varchar_udf_1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-val_86 val_86
+val_238 val_238
PREHOOK: query: drop table varchar_udf_1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@varchar_udf_1
Modified: hive/branches/maven/ql/src/test/results/clientpositive/vectorization_short_regress.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientpositive/vectorization_short_regress.q.out?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientpositive/vectorization_short_regress.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientpositive/vectorization_short_regress.q.out Tue Oct 22 17:58:59 2013
@@ -363,7 +363,7 @@ POSTHOOK: Input: default@alltypesorc
PREHOOK: query: -- TargetTypeClasses: Long, Bool, Double, String, Timestamp
-- Functions: Max, VarP, StDevP, Avg, Min, StDev, Var
-- ArithmeticOps: Divide, Multiply, Remainder, Subtract
--- FilterOps: LessThan, LessThanOrEqual, GreaterThan, GreaterThanOrEqual, Like
+-- FilterOps: LessThan, LessThanOrEqual, GreaterThan, GreaterThanOrEqual, Like, RLike
-- GroupBy: NoGroupByProjectAggs
EXPLAIN SELECT MAX(cint),
(MAX(cint) / -3728),
@@ -394,14 +394,14 @@ WHERE (((cbigint <= 197)
OR ((cdouble >= -26.28)
AND (csmallint > cdouble))
OR ((ctinyint > cfloat)
- AND (cstring1 LIKE '%ss%'))
+ AND (cstring1 RLIKE '.*ss.*'))
OR ((cfloat > 79.553)
AND (cstring2 LIKE '10%')))
PREHOOK: type: QUERY
POSTHOOK: query: -- TargetTypeClasses: Long, Bool, Double, String, Timestamp
-- Functions: Max, VarP, StDevP, Avg, Min, StDev, Var
-- ArithmeticOps: Divide, Multiply, Remainder, Subtract
--- FilterOps: LessThan, LessThanOrEqual, GreaterThan, GreaterThanOrEqual, Like
+-- FilterOps: LessThan, LessThanOrEqual, GreaterThan, GreaterThanOrEqual, Like, RLike
-- GroupBy: NoGroupByProjectAggs
EXPLAIN SELECT MAX(cint),
(MAX(cint) / -3728),
@@ -432,12 +432,12 @@ WHERE (((cbigint <= 197)
OR ((cdouble >= -26.28)
AND (csmallint > cdouble))
OR ((ctinyint > cfloat)
- AND (cstring1 LIKE '%ss%'))
+ AND (cstring1 RLIKE '.*ss.*'))
OR ((cfloat > 79.553)
AND (cstring2 LIKE '10%')))
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (TOK_SELEXPR (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (% (- 563) (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (/ (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint)) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmalli
nt)) 10.175)) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (% (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)) 10.175))) (TOK_SELEXPR (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (% (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble)) (- 26.28))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (% (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (% (- 563) (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))))) (TOK_SELEXPR (- (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)) (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint)))) (TOK_SELEXPR (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)))) (TOK_WHERE (OR (OR (OR (AND (<= (TOK_TAB
LE_OR_COL cbigint) 197) (< (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_COL cbigint))) (AND (>= (TOK_TABLE_OR_COL cdouble) (- 26.28)) (> (TOK_TABLE_OR_COL csmallint) (TOK_TABLE_OR_COL cdouble)))) (AND (> (TOK_TABLE_OR_COL ctinyint) (TOK_TABLE_OR_COL cfloat)) (LIKE (TOK_TABLE_OR_COL cstring1) '%ss%'))) (AND (> (TOK_TABLE_OR_COL cfloat) 79.553) (LIKE (TOK_TABLE_OR_COL cstring2) '10%'))))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (TOK_SELEXPR (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (% (- 563) (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (/ (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint)) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmalli
nt)) 10.175)) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (% (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)) 10.175))) (TOK_SELEXPR (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (% (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble)) (- 26.28))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (% (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (% (- 563) (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))))) (TOK_SELEXPR (- (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)) (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint)))) (TOK_SELEXPR (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)))) (TOK_WHERE (OR (OR (OR (AND (<= (TOK_TAB
LE_OR_COL cbigint) 197) (< (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_COL cbigint))) (AND (>= (TOK_TABLE_OR_COL cdouble) (- 26.28)) (> (TOK_TABLE_OR_COL csmallint) (TOK_TABLE_OR_COL cdouble)))) (AND (> (TOK_TABLE_OR_COL ctinyint) (TOK_TABLE_OR_COL cfloat)) (RLIKE (TOK_TABLE_OR_COL cstring1) '.*ss.*'))) (AND (> (TOK_TABLE_OR_COL cfloat) 79.553) (LIKE (TOK_TABLE_OR_COL cstring2) '10%'))))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -452,7 +452,7 @@ STAGE PLANS:
alias: alltypesorc
Filter Operator
predicate:
- expr: (((((cbigint <= 197) and (cint < cbigint)) or ((cdouble >= (- 26.28)) and (csmallint > cdouble))) or ((ctinyint > cfloat) and (cstring1 like '%ss%'))) or ((cfloat > 79.553) and (cstring2 like '10%')))
+ expr: (((((cbigint <= 197) and (cint < cbigint)) or ((cdouble >= (- 26.28)) and (csmallint > cdouble))) or ((ctinyint > cfloat) and (cstring1 rlike '.*ss.*'))) or ((cfloat > 79.553) and (cstring2 like '10%')))
type: boolean
Vectorized execution: true
Select Operator
@@ -612,7 +612,7 @@ WHERE (((cbigint <= 197)
OR ((cdouble >= -26.28)
AND (csmallint > cdouble))
OR ((ctinyint > cfloat)
- AND (cstring1 LIKE '%ss%'))
+ AND (cstring1 RLIKE '.*ss.*'))
OR ((cfloat > 79.553)
AND (cstring2 LIKE '10%')))
PREHOOK: type: QUERY
@@ -647,7 +647,7 @@ WHERE (((cbigint <= 197)
OR ((cdouble >= -26.28)
AND (csmallint > cdouble))
OR ((ctinyint > cfloat)
- AND (cstring1 LIKE '%ss%'))
+ AND (cstring1 RLIKE '.*ss.*'))
OR ((cfloat > 79.553)
AND (cstring2 LIKE '10%')))
POSTHOOK: type: QUERY
@@ -1161,7 +1161,7 @@ POSTHOOK: Input: default@alltypesorc
PREHOOK: query: -- TargetTypeClasses: Timestamp, String, Long, Double, Bool
-- Functions: Max, Avg, Min, Var, StDev, Count, StDevP, Sum
-- ArithmeticOps: Multiply, Subtract, Add, Divide
--- FilterOps: Like, NotEqual, LessThan, GreaterThanOrEqual, GreaterThan
+-- FilterOps: Like, NotEqual, LessThan, GreaterThanOrEqual, GreaterThan, RLike
-- GroupBy: NoGroupByProjectColumns
EXPLAIN SELECT cint,
cdouble,
@@ -1187,7 +1187,7 @@ EXPLAIN SELECT cint,
(-(ctinyint)),
(79.553 / ctinyint)
FROM alltypesorc
-WHERE (((cstring1 LIKE 'a%')
+WHERE (((cstring1 RLIKE 'a.*')
AND (cstring2 LIKE '%ss%'))
OR ((1 != cboolean2)
AND ((csmallint < 79.553)
@@ -1200,7 +1200,7 @@ PREHOOK: type: QUERY
POSTHOOK: query: -- TargetTypeClasses: Timestamp, String, Long, Double, Bool
-- Functions: Max, Avg, Min, Var, StDev, Count, StDevP, Sum
-- ArithmeticOps: Multiply, Subtract, Add, Divide
--- FilterOps: Like, NotEqual, LessThan, GreaterThanOrEqual, GreaterThan
+-- FilterOps: Like, NotEqual, LessThan, GreaterThanOrEqual, GreaterThan, RLike
-- GroupBy: NoGroupByProjectColumns
EXPLAIN SELECT cint,
cdouble,
@@ -1226,7 +1226,7 @@ EXPLAIN SELECT cint,
(-(ctinyint)),
(79.553 / ctinyint)
FROM alltypesorc
-WHERE (((cstring1 LIKE 'a%')
+WHERE (((cstring1 RLIKE 'a.*')
AND (cstring2 LIKE '%ss%'))
OR ((1 != cboolean2)
AND ((csmallint < 79.553)
@@ -1237,7 +1237,7 @@ WHERE (((cstring1 LIKE 'a%')
AND (ctinyint > cbigint)))
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL cint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cdouble)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp2)) (TOK_SELEXPR (TOK_TABLE_OR_COL cstring1)) (TOK_SELEXPR (TOK_TABLE_OR_COL cboolean2)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctinyint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cfloat)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp1)) (TOK_SELEXPR (TOK_TABLE_OR_COL csmallint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cbigint)) (TOK_SELEXPR (* (- 3728) (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (- (- 863.257) (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL csmallint) (- (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (+ (- (TOK_TABLE_OR_COL csmallint) (- (TOK_TABLE_OR_COL csmallint))) (- (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (/ (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_C
OL cint))) (TOK_SELEXPR (- (- (- 863.257) (TOK_TABLE_OR_COL cint)) (- 26.28))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (* (TOK_TABLE_OR_COL cdouble) (- 89010))) (TOK_SELEXPR (/ (TOK_TABLE_OR_COL ctinyint) 988888)) (TOK_SELEXPR (- (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (/ 79.553 (TOK_TABLE_OR_COL ctinyint)))) (TOK_WHERE (OR (OR (OR (AND (LIKE (TOK_TABLE_OR_COL cstring1) 'a%') (LIKE (TOK_TABLE_OR_COL cstring2) '%ss%')) (AND (!= 1 (TOK_TABLE_OR_COL cboolean2)) (AND (< (TOK_TABLE_OR_COL csmallint) 79.553) (!= (- 257) (TOK_TABLE_OR_COL ctinyint))))) (AND (> (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL ctinyint)) (>= (TOK_TABLE_OR_COL cfloat) (TOK_TABLE_OR_COL cint)))) (AND (< (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_COL cbigint)) (> (TOK_TABLE_OR_COL ctinyint) (TOK_TABLE_OR_COL cbigint)))))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL cint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cdouble)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp2)) (TOK_SELEXPR (TOK_TABLE_OR_COL cstring1)) (TOK_SELEXPR (TOK_TABLE_OR_COL cboolean2)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctinyint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cfloat)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp1)) (TOK_SELEXPR (TOK_TABLE_OR_COL csmallint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cbigint)) (TOK_SELEXPR (* (- 3728) (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (- (- 863.257) (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL csmallint) (- (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (+ (- (TOK_TABLE_OR_COL csmallint) (- (TOK_TABLE_OR_COL csmallint))) (- (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (/ (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_C
OL cint))) (TOK_SELEXPR (- (- (- 863.257) (TOK_TABLE_OR_COL cint)) (- 26.28))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (* (TOK_TABLE_OR_COL cdouble) (- 89010))) (TOK_SELEXPR (/ (TOK_TABLE_OR_COL ctinyint) 988888)) (TOK_SELEXPR (- (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (/ 79.553 (TOK_TABLE_OR_COL ctinyint)))) (TOK_WHERE (OR (OR (OR (AND (RLIKE (TOK_TABLE_OR_COL cstring1) 'a.*') (LIKE (TOK_TABLE_OR_COL cstring2) '%ss%')) (AND (!= 1 (TOK_TABLE_OR_COL cboolean2)) (AND (< (TOK_TABLE_OR_COL csmallint) 79.553) (!= (- 257) (TOK_TABLE_OR_COL ctinyint))))) (AND (> (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL ctinyint)) (>= (TOK_TABLE_OR_COL cfloat) (TOK_TABLE_OR_COL cint)))) (AND (< (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_COL cbigint)) (> (TOK_TABLE_OR_COL ctinyint) (TOK_TABLE_OR_COL cbigint)))))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -1252,7 +1252,7 @@ STAGE PLANS:
alias: alltypesorc
Filter Operator
predicate:
- expr: (((((cstring1 like 'a%') and (cstring2 like '%ss%')) or ((1 <> cboolean2) and ((csmallint < 79.553) and ((- 257) <> ctinyint)))) or ((cdouble > ctinyint) and (cfloat >= cint))) or ((cint < cbigint) and (ctinyint > cbigint)))
+ expr: (((((cstring1 rlike 'a.*') and (cstring2 like '%ss%')) or ((1 <> cboolean2) and ((csmallint < 79.553) and ((- 257) <> ctinyint)))) or ((cdouble > ctinyint) and (cfloat >= cint))) or ((cint < cbigint) and (ctinyint > cbigint)))
type: boolean
Vectorized execution: true
Select Operator
@@ -1343,7 +1343,7 @@ PREHOOK: query: SELECT cint,
(-(ctinyint)),
(79.553 / ctinyint)
FROM alltypesorc
-WHERE (((cstring1 LIKE 'a%')
+WHERE (((cstring1 RLIKE 'a.*')
AND (cstring2 LIKE '%ss%'))
OR ((1 != cboolean2)
AND ((csmallint < 79.553)
@@ -1379,7 +1379,7 @@ POSTHOOK: query: SELECT cint,
(-(ctinyint)),
(79.553 / ctinyint)
FROM alltypesorc
-WHERE (((cstring1 LIKE 'a%')
+WHERE (((cstring1 RLIKE 'a.*')
AND (cstring2 LIKE '%ss%'))
OR ((1 != cboolean2)
AND ((csmallint < 79.553)
@@ -8252,7 +8252,7 @@ POSTHOOK: Input: default@alltypesorc
PREHOOK: query: -- TargetTypeClasses: Bool, Timestamp, String, Double, Long
-- Functions: StDevP, Avg, Count, Min, Var, VarP, Sum
-- ArithmeticOps: Multiply, Subtract, Add, Divide, Remainder
--- FilterOps: NotEqual, LessThan, Like, Equal
+-- FilterOps: NotEqual, LessThan, Like, Equal, RLike
-- GroupBy: GroupBy
EXPLAIN SELECT ctimestamp1,
cstring1,
@@ -8297,7 +8297,7 @@ FROM alltypesorc
WHERE (((ctimestamp1 != 0))
AND ((((-257 != ctinyint)
AND (cboolean2 IS NOT NULL))
- AND ((cstring1 LIKE '%ss')
+ AND ((cstring1 RLIKE '.*ss')
AND (-10669 < ctimestamp1)))
OR (ctimestamp2 = -10669)
OR ((ctimestamp1 < 0)
@@ -8310,7 +8310,7 @@ PREHOOK: type: QUERY
POSTHOOK: query: -- TargetTypeClasses: Bool, Timestamp, String, Double, Long
-- Functions: StDevP, Avg, Count, Min, Var, VarP, Sum
-- ArithmeticOps: Multiply, Subtract, Add, Divide, Remainder
--- FilterOps: NotEqual, LessThan, Like, Equal
+-- FilterOps: NotEqual, LessThan, Like, Equal, RLike
-- GroupBy: GroupBy
EXPLAIN SELECT ctimestamp1,
cstring1,
@@ -8355,7 +8355,7 @@ FROM alltypesorc
WHERE (((ctimestamp1 != 0))
AND ((((-257 != ctinyint)
AND (cboolean2 IS NOT NULL))
- AND ((cstring1 LIKE '%ss')
+ AND ((cstring1 RLIKE '.*ss')
AND (-10669 < ctimestamp1)))
OR (ctimestamp2 = -10669)
OR ((ctimestamp1 < 0)
@@ -8366,7 +8366,7 @@ WHERE (((ctimestamp1 != 0))
GROUP BY ctimestamp1, cstring1
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp1)) (TOK_SELEXPR (TOK_TABLE_OR_COL cstring1)) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (* (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) 10.175)) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTIONSTAR COUNT)) (TOK_SELEXPR (- (TOK_FUNCTIONSTAR COUNT))) (TOK_SELEXPR (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (T
OK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (TOK_SELEXPR (- (* (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) 10.175))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT))))) (TOK_SELEXPR (- (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))))) (TOK_SELEXPR (/ (- (TOK_FUNCTIONSTAR COUNT)) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (/ 10.175 (TOK_FUNCTION AVG (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (- (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (T
OK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT))))) (TOK_SELEXPR (- (- (* (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) 10.175)))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (* (- (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) 10.175)) (TOK_SELEXPR (% 10.175 (/ 10.175 (TOK_FUNCTION AVG (TOK_TABLE_OR_COL csmallint))))) (TOK_SELEXPR (- (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_O
R_COL cdouble))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))))) (TOK_SELEXPR (% (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (/ (- 26.28) (- (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint))))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (/ (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (- (- (TOK_FUNCTIONSTAR COUNT)))) (TOK_SELEXPR (TOK_FUNCTIONSTAR COUNT)) (TOK_SELEXPR (% (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.2
8) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (- 26.28)))) (TOK_WHERE (AND (!= (TOK_TABLE_OR_COL ctimestamp1) 0) (OR (OR (OR (OR (AND (AND (!= (- 257) (TOK_TABLE_OR_COL ctinyint)) (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL cboolean2))) (AND (LIKE (TOK_TABLE_OR_COL cstring1) '%ss') (< (- 10669) (TOK_TABLE_OR_COL ctimestamp1)))) (= (TOK_TABLE_OR_COL ctimestamp2) (- 10669))) (AND (< (TOK_TABLE_OR_COL ctimestamp1) 0) (LIKE (TOK_TABLE_OR_COL cstring2) '%b%'))) (= (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL cint))) (AND (TOK_FUNCTION TOK_ISNULL (TOK_TABLE_OR_COL cboolean1)) (< (TOK_TABLE_OR_COL cfloat) (TOK_TABLE_OR_COL cint)))))) (TOK_GROUPBY (TOK_TABLE_OR_COL ctimestamp1) (TOK_TABLE_OR_COL cstring1))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp1)) (TOK_SELEXPR (TOK_TABLE_OR_COL cstring1)) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (* (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) 10.175)) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTIONSTAR COUNT)) (TOK_SELEXPR (- (TOK_FUNCTIONSTAR COUNT))) (TOK_SELEXPR (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (T
OK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (TOK_SELEXPR (- (* (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) 10.175))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT))))) (TOK_SELEXPR (- (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))))) (TOK_SELEXPR (/ (- (TOK_FUNCTIONSTAR COUNT)) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (/ 10.175 (TOK_FUNCTION AVG (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (- (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (T
OK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT))))) (TOK_SELEXPR (- (- (* (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) 10.175)))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (* (- (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) 10.175)) (TOK_SELEXPR (% 10.175 (/ 10.175 (TOK_FUNCTION AVG (TOK_TABLE_OR_COL csmallint))))) (TOK_SELEXPR (- (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_O
R_COL cdouble))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))))) (TOK_SELEXPR (% (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (/ (- 26.28) (- (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint))))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (/ (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (- (- (TOK_FUNCTIONSTAR COUNT)))) (TOK_SELEXPR (TOK_FUNCTIONSTAR COUNT)) (TOK_SELEXPR (% (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.2
8) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (- 26.28)))) (TOK_WHERE (AND (!= (TOK_TABLE_OR_COL ctimestamp1) 0) (OR (OR (OR (OR (AND (AND (!= (- 257) (TOK_TABLE_OR_COL ctinyint)) (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL cboolean2))) (AND (RLIKE (TOK_TABLE_OR_COL cstring1) '.*ss') (< (- 10669) (TOK_TABLE_OR_COL ctimestamp1)))) (= (TOK_TABLE_OR_COL ctimestamp2) (- 10669))) (AND (< (TOK_TABLE_OR_COL ctimestamp1) 0) (LIKE (TOK_TABLE_OR_COL cstring2) '%b%'))) (= (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL cint))) (AND (TOK_FUNCTION TOK_ISNULL (TOK_TABLE_OR_COL cboolean1)) (< (TOK_TABLE_OR_COL cfloat) (TOK_TABLE_OR_COL cint)))))) (TOK_GROUPBY (TOK_TABLE_OR_COL ctimestamp1) (TOK_TABLE_OR_COL cstring1))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -8381,7 +8381,7 @@ STAGE PLANS:
alias: alltypesorc
Filter Operator
predicate:
- expr: ((ctimestamp1 <> 0) and ((((((((- 257) <> ctinyint) and cboolean2 is not null) and ((cstring1 like '%ss') and ((- 10669) < ctimestamp1))) or (ctimestamp2 = (- 10669))) or ((ctimestamp1 < 0) and (cstring2 like '%b%'))) or (cdouble = cint)) or (cboolean1 is null and (cfloat < cint))))
+ expr: ((ctimestamp1 <> 0) and ((((((((- 257) <> ctinyint) and cboolean2 is not null) and ((cstring1 rlike '.*ss') and ((- 10669) < ctimestamp1))) or (ctimestamp2 = (- 10669))) or ((ctimestamp1 < 0) and (cstring2 like '%b%'))) or (cdouble = cint)) or (cboolean1 is null and (cfloat < cint))))
type: boolean
Vectorized execution: true
Select Operator
@@ -8627,7 +8627,7 @@ FROM alltypesorc
WHERE (((ctimestamp1 != 0))
AND ((((-257 != ctinyint)
AND (cboolean2 IS NOT NULL))
- AND ((cstring1 LIKE '%ss')
+ AND ((cstring1 RLIKE '.*ss')
AND (-10669 < ctimestamp1)))
OR (ctimestamp2 = -10669)
OR ((ctimestamp1 < 0)
@@ -8682,7 +8682,7 @@ FROM alltypesorc
WHERE (((ctimestamp1 != 0))
AND ((((-257 != ctinyint)
AND (cboolean2 IS NOT NULL))
- AND ((cstring1 LIKE '%ss')
+ AND ((cstring1 RLIKE '.*ss')
AND (-10669 < ctimestamp1)))
OR (ctimestamp2 = -10669)
OR ((ctimestamp1 < 0)
@@ -8936,7 +8936,7 @@ WARNING: Comparing a bigint and a double
PREHOOK: query: -- TargetTypeClasses: Double, Long, String, Timestamp, Bool
-- Functions: Max, Sum, Var, Avg, Min, VarP, StDev, StDevP
-- ArithmeticOps: Divide, Subtract, Remainder, Add, Multiply
--- FilterOps: GreaterThan, LessThanOrEqual, Equal, LessThan, GreaterThanOrEqual, NotEqual, Like
+-- FilterOps: GreaterThan, LessThanOrEqual, Equal, LessThan, GreaterThanOrEqual, NotEqual, Like, RLike
-- GroupBy: GroupBy
EXPLAIN SELECT cboolean1,
MAX(cfloat),
@@ -8972,7 +8972,7 @@ WHERE (((cboolean1 IS NOT NULL))
OR ((cint >= -257)
AND ((cstring1 IS NOT NULL)
AND (cboolean1 >= 1)))
- OR (cstring2 LIKE 'b')
+ OR (cstring2 RLIKE 'b')
OR ((csmallint >= ctinyint)
AND (ctimestamp2 IS NULL))))
GROUP BY cboolean1
@@ -8981,7 +8981,7 @@ PREHOOK: type: QUERY
POSTHOOK: query: -- TargetTypeClasses: Double, Long, String, Timestamp, Bool
-- Functions: Max, Sum, Var, Avg, Min, VarP, StDev, StDevP
-- ArithmeticOps: Divide, Subtract, Remainder, Add, Multiply
--- FilterOps: GreaterThan, LessThanOrEqual, Equal, LessThan, GreaterThanOrEqual, NotEqual, Like
+-- FilterOps: GreaterThan, LessThanOrEqual, Equal, LessThan, GreaterThanOrEqual, NotEqual, Like, RLike
-- GroupBy: GroupBy
EXPLAIN SELECT cboolean1,
MAX(cfloat),
@@ -9017,14 +9017,14 @@ WHERE (((cboolean1 IS NOT NULL))
OR ((cint >= -257)
AND ((cstring1 IS NOT NULL)
AND (cboolean1 >= 1)))
- OR (cstring2 LIKE 'b')
+ OR (cstring2 RLIKE 'b')
OR ((csmallint >= ctinyint)
AND (ctimestamp2 IS NULL))))
GROUP BY cboolean1
ORDER BY cboolean1
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL cboolean1)) (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (/ (- 26.28) (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cbigint)) 10.175)) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (% (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)) (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (+ 10.175 (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat))))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (+ (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cbigint)) 10.175) (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint))) (TOK_SELEX
PR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (+ 10.175 (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))))) (TOK_SELEXPR (/ 79.553 (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint)))) (TOK_SELEXPR (% (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)) (/ 79.553 (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))))) (TOK_SELEXPR (- (+ 10.175 (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))))) (TOK_SELEXPR (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (* (- 1.389) (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint)))) (TOK_SELEXPR (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint)) (* (- 1.389) (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint))))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint)) (* (- 1.389) (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint)))))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR
(- (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (* (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint))))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL cboolean1)) (OR (OR (OR (AND (< (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL csmallint)) (AND (= (TOK_TABLE_OR_COL cboolean2) (TOK_TABLE_OR_COL cboolean1)) (<= (TOK_TABLE_OR_COL cbigint) (- 863.257)))) (AND (>= (TOK_TABLE_OR_COL cint) (- 257)) (AND (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL cstring1)) (>= (TOK_TABLE_OR_COL cboolean1) 1)))) (LIKE (TOK_TABLE_OR_COL cstring2) 'b')) (AND (>= (TOK_TABLE_OR_COL csmallint) (TOK_TABLE_OR_COL ctinyint)) (TOK_FUNCTION TOK_ISNULL (TOK_TABLE_OR_COL ctimestamp2)))))) (TOK_GROUPBY (TOK_TABLE_OR_COL cboolean1)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL cboolean1)))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL cboolean1)) (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (/ (- 26.28) (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cbigint)) 10.175)) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (% (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)) (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (+ 10.175 (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat))))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (+ (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cbigint)) 10.175) (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint))) (TOK_SELEX
PR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (+ 10.175 (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))))) (TOK_SELEXPR (/ 79.553 (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint)))) (TOK_SELEXPR (% (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)) (/ 79.553 (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))))) (TOK_SELEXPR (- (+ 10.175 (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))))) (TOK_SELEXPR (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (* (- 1.389) (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint)))) (TOK_SELEXPR (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint)) (* (- 1.389) (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint))))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint)) (* (- 1.389) (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint)))))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR
(- (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (* (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint))))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL cboolean1)) (OR (OR (OR (AND (< (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL csmallint)) (AND (= (TOK_TABLE_OR_COL cboolean2) (TOK_TABLE_OR_COL cboolean1)) (<= (TOK_TABLE_OR_COL cbigint) (- 863.257)))) (AND (>= (TOK_TABLE_OR_COL cint) (- 257)) (AND (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL cstring1)) (>= (TOK_TABLE_OR_COL cboolean1) 1)))) (RLIKE (TOK_TABLE_OR_COL cstring2) 'b')) (AND (>= (TOK_TABLE_OR_COL csmallint) (TOK_TABLE_OR_COL ctinyint)) (TOK_FUNCTION TOK_ISNULL (TOK_TABLE_OR_COL ctimestamp2)))))) (TOK_GROUPBY (TOK_TABLE_OR_COL cboolean1)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL cboolean1)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -9040,7 +9040,7 @@ STAGE PLANS:
alias: alltypesorc
Filter Operator
predicate:
- expr: (cboolean1 is not null and (((((cdouble < csmallint) and ((cboolean2 = cboolean1) and (cbigint <= (- 863.257)))) or ((cint >= (- 257)) and (cstring1 is not null and (cboolean1 >= 1)))) or (cstring2 like 'b')) or ((csmallint >= ctinyint) and ctimestamp2 is null)))
+ expr: (cboolean1 is not null and (((((cdouble < csmallint) and ((cboolean2 = cboolean1) and (cbigint <= (- 863.257)))) or ((cint >= (- 257)) and (cstring1 is not null and (cboolean1 >= 1)))) or (cstring2 rlike 'b')) or ((csmallint >= ctinyint) and ctimestamp2 is null)))
type: boolean
Vectorized execution: true
Select Operator
@@ -9306,7 +9306,7 @@ WHERE (((cboolean1 IS NOT NULL))
OR ((cint >= -257)
AND ((cstring1 IS NOT NULL)
AND (cboolean1 >= 1)))
- OR (cstring2 LIKE 'b')
+ OR (cstring2 RLIKE 'b')
OR ((csmallint >= ctinyint)
AND (ctimestamp2 IS NULL))))
GROUP BY cboolean1
@@ -9348,7 +9348,7 @@ WHERE (((cboolean1 IS NOT NULL))
OR ((cint >= -257)
AND ((cstring1 IS NOT NULL)
AND (cboolean1 >= 1)))
- OR (cstring2 LIKE 'b')
+ OR (cstring2 RLIKE 'b')
OR ((csmallint >= ctinyint)
AND (ctimestamp2 IS NULL))))
GROUP BY cboolean1
Modified: hive/branches/maven/ql/src/test/results/compiler/errors/garbage.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/errors/garbage.q.out?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/errors/garbage.q.out (original)
+++ hive/branches/maven/ql/src/test/results/compiler/errors/garbage.q.out Tue Oct 22 17:58:59 2013
@@ -1 +1 @@
-Parse Error: line 1:0 cannot recognize input near 'this' 'is' 'totally'
+Parse Error: line 1:0 cannot recognize input near 'this' 'is' 'totally'
\ No newline at end of file
Modified: hive/branches/maven/ql/src/test/results/compiler/errors/invalid_create_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/errors/invalid_create_table.q.out?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/errors/invalid_create_table.q.out (original)
+++ hive/branches/maven/ql/src/test/results/compiler/errors/invalid_create_table.q.out Tue Oct 22 17:58:59 2013
@@ -1 +1 @@
-Parse Error: line 3:2 mismatched input 'b' expecting ) near 'INT' in create table statement
+Parse Error: line 3:2 mismatched input 'b' expecting ) near 'INT' in create table statement
\ No newline at end of file
Modified: hive/branches/maven/ql/src/test/results/compiler/errors/invalid_select.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/errors/invalid_select.q.out?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/errors/invalid_select.q.out (original)
+++ hive/branches/maven/ql/src/test/results/compiler/errors/invalid_select.q.out Tue Oct 22 17:58:59 2013
@@ -1,2 +1,2 @@
Parse Error: line 3:6 missing FROM at '(' near '(' in subquery source
-line 3:7 cannot recognize input near 'b' ')' 'FROM' in subquery source
+line 3:7 cannot recognize input near 'b' ')' 'FROM' in subquery source
\ No newline at end of file
Modified: hive/branches/maven/ql/src/test/results/compiler/errors/macro_reserved_word.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/errors/macro_reserved_word.q.out?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/errors/macro_reserved_word.q.out (original)
+++ hive/branches/maven/ql/src/test/results/compiler/errors/macro_reserved_word.q.out Tue Oct 22 17:58:59 2013
@@ -1 +1 @@
-Parse Error: line 1:23 mismatched input 'DOUBLE' expecting Identifier near 'MACRO' in create macro statement
+Parse Error: line 1:23 mismatched input 'DOUBLE' expecting Identifier near 'MACRO' in create macro statement
\ No newline at end of file
Modified: hive/branches/maven/ql/src/test/results/compiler/errors/missing_overwrite.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/errors/missing_overwrite.q.out?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/errors/missing_overwrite.q.out (original)
+++ hive/branches/maven/ql/src/test/results/compiler/errors/missing_overwrite.q.out Tue Oct 22 17:58:59 2013
@@ -1 +1 @@
-Parse Error: line 2:0 cannot recognize input near 'INSERT' 'TABLE' 'dest1' in insert clause
+Parse Error: line 2:0 cannot recognize input near 'INSERT' 'TABLE' 'dest1' in insert clause
\ No newline at end of file
Modified: hive/branches/maven/ql/src/test/results/compiler/errors/quoted_string.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/errors/quoted_string.q.out?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/errors/quoted_string.q.out (original)
+++ hive/branches/maven/ql/src/test/results/compiler/errors/quoted_string.q.out Tue Oct 22 17:58:59 2013
@@ -1,2 +1,2 @@
Parse Error: line 3:0 character '<EOF>' not supported here
-line 3:0 character '<EOF>' not supported here
+line 3:0 character '<EOF>' not supported here
\ No newline at end of file
Modified: hive/branches/maven/ql/src/test/results/compiler/errors/wrong_distinct2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/errors/wrong_distinct2.q.out?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/errors/wrong_distinct2.q.out (original)
+++ hive/branches/maven/ql/src/test/results/compiler/errors/wrong_distinct2.q.out Tue Oct 22 17:58:59 2013
@@ -1 +1 @@
-Parse Error: line 2:45 cannot recognize input near 'DISTINCT' 'substr' '(' in select expression
+Parse Error: line 2:45 cannot recognize input near 'DISTINCT' 'substr' '(' in select expression
\ No newline at end of file
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/case_sensitivity.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/case_sensitivity.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/case_sensitivity.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/case_sensitivity.q.xml Tue Oct 22 17:58:59 2013
@@ -713,7 +713,7 @@
<object idref="ListBucketingCtx0"/>
</void>
<void property="maxStatsKeyPrefixLength">
- <int>200</int>
+ <int>150</int>
</void>
<void property="numFiles">
<int>1</int>
@@ -772,7 +772,7 @@
<object id="ExprNodeFieldDesc0" class="org.apache.hadoop.hive.ql.plan.ExprNodeFieldDesc">
<void property="desc">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -856,7 +856,7 @@
<void method="put">
<string>_col0</string>
<object id="ExprNodeGenericFuncDesc0" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -989,11 +989,11 @@
<object class="org.apache.hadoop.hive.ql.plan.FilterDesc">
<void property="predicate">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/cast1.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/cast1.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/cast1.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/cast1.q.xml Tue Oct 22 17:58:59 2013
@@ -388,7 +388,7 @@
<void method="put">
<string>_col6</string>
<object id="ExprNodeGenericFuncDesc0" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc">
@@ -420,7 +420,7 @@
<void method="put">
<string>_col5</string>
<object id="ExprNodeGenericFuncDesc1" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc">
@@ -452,7 +452,7 @@
<void method="put">
<string>_col4</string>
<object id="ExprNodeGenericFuncDesc2" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc">
@@ -466,7 +466,7 @@
</void>
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc">
@@ -518,7 +518,7 @@
<void method="put">
<string>_col3</string>
<object id="ExprNodeGenericFuncDesc3" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc">
@@ -563,7 +563,7 @@
<void method="put">
<string>_col2</string>
<object id="ExprNodeGenericFuncDesc4" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc">
@@ -608,7 +608,7 @@
<void method="put">
<string>_col1</string>
<object id="ExprNodeGenericFuncDesc5" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc">
@@ -653,7 +653,7 @@
<void method="put">
<string>_col0</string>
<object id="ExprNodeGenericFuncDesc6" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc">
@@ -905,7 +905,7 @@
<object class="org.apache.hadoop.hive.ql.plan.FilterDesc">
<void property="predicate">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/groupby1.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/groupby1.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/groupby1.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/groupby1.q.xml Tue Oct 22 17:58:59 2013
@@ -561,7 +561,7 @@
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -1228,7 +1228,7 @@
<object idref="ListBucketingCtx0"/>
</void>
<void property="maxStatsKeyPrefixLength">
- <int>200</int>
+ <int>150</int>
</void>
<void property="numFiles">
<int>1</int>
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/groupby2.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/groupby2.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/groupby2.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/groupby2.q.xml Tue Oct 22 17:58:59 2013
@@ -462,7 +462,7 @@
<void method="put">
<string>_col1</string>
<object id="ExprNodeGenericFuncDesc0" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -511,7 +511,7 @@
<void method="put">
<string>_col0</string>
<object id="ExprNodeGenericFuncDesc1" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -589,7 +589,7 @@
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -650,7 +650,7 @@
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -1480,7 +1480,7 @@
<void method="put">
<string>_col2</string>
<object id="ExprNodeGenericFuncDesc2" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/groupby3.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/groupby3.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/groupby3.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/groupby3.q.xml Tue Oct 22 17:58:59 2013
@@ -542,7 +542,7 @@
<void method="put">
<string>_col0</string>
<object id="ExprNodeGenericFuncDesc0" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -611,7 +611,7 @@
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -672,7 +672,7 @@
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -736,7 +736,7 @@
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -797,7 +797,7 @@
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -858,7 +858,7 @@
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/groupby4.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/groupby4.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/groupby4.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/groupby4.q.xml Tue Oct 22 17:58:59 2013
@@ -341,7 +341,7 @@
<void method="put">
<string>_col0</string>
<object id="ExprNodeGenericFuncDesc0" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/groupby5.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/groupby5.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/groupby5.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/groupby5.q.xml Tue Oct 22 17:58:59 2013
@@ -414,7 +414,7 @@
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/groupby6.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/groupby6.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/groupby6.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/groupby6.q.xml Tue Oct 22 17:58:59 2013
@@ -341,7 +341,7 @@
<void method="put">
<string>_col0</string>
<object id="ExprNodeGenericFuncDesc0" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/input1.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/input1.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/input1.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/input1.q.xml Tue Oct 22 17:58:59 2013
@@ -705,7 +705,7 @@
<object idref="ListBucketingCtx0"/>
</void>
<void property="maxStatsKeyPrefixLength">
- <int>200</int>
+ <int>150</int>
</void>
<void property="numFiles">
<int>1</int>
@@ -887,7 +887,7 @@
<object class="org.apache.hadoop.hive.ql.plan.FilterDesc">
<void property="predicate">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/input2.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/input2.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/input2.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/input2.q.xml Tue Oct 22 17:58:59 2013
@@ -1754,7 +1754,7 @@
<object idref="ListBucketingCtx0"/>
</void>
<void property="maxStatsKeyPrefixLength">
- <int>200</int>
+ <int>150</int>
</void>
<void property="numFiles">
<int>1</int>
@@ -1939,7 +1939,7 @@
<object class="org.apache.hadoop.hive.ql.plan.FilterDesc">
<void property="predicate">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -2077,7 +2077,7 @@
<object idref="ListBucketingCtx1"/>
</void>
<void property="maxStatsKeyPrefixLength">
- <int>200</int>
+ <int>150</int>
</void>
<void property="numFiles">
<int>1</int>
@@ -2259,11 +2259,11 @@
<object class="org.apache.hadoop.hive.ql.plan.FilterDesc">
<void property="predicate">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -2300,7 +2300,7 @@
</void>
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -2414,7 +2414,7 @@
<object idref="ListBucketingCtx2"/>
</void>
<void property="maxStatsKeyPrefixLength">
- <int>200</int>
+ <int>150</int>
</void>
<void property="numFiles">
<int>1</int>
@@ -2593,7 +2593,7 @@
<object class="org.apache.hadoop.hive.ql.plan.FilterDesc">
<void property="predicate">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/input20.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/input20.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/input20.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/input20.q.xml Tue Oct 22 17:58:59 2013
@@ -555,7 +555,7 @@
<void method="put">
<string>_col1</string>
<object id="ExprNodeGenericFuncDesc0" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -611,7 +611,7 @@
<void method="put">
<string>_col0</string>
<object id="ExprNodeGenericFuncDesc1" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/input3.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/input3.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/input3.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/input3.q.xml Tue Oct 22 17:58:59 2013
@@ -2140,7 +2140,7 @@
<object idref="ListBucketingCtx0"/>
</void>
<void property="maxStatsKeyPrefixLength">
- <int>200</int>
+ <int>150</int>
</void>
<void property="numFiles">
<int>1</int>
@@ -2325,7 +2325,7 @@
<object class="org.apache.hadoop.hive.ql.plan.FilterDesc">
<void property="predicate">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -2463,7 +2463,7 @@
<object idref="ListBucketingCtx1"/>
</void>
<void property="maxStatsKeyPrefixLength">
- <int>200</int>
+ <int>150</int>
</void>
<void property="numFiles">
<int>1</int>
@@ -2645,11 +2645,11 @@
<object class="org.apache.hadoop.hive.ql.plan.FilterDesc">
<void property="predicate">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -2686,7 +2686,7 @@
</void>
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -2800,7 +2800,7 @@
<object idref="ListBucketingCtx2"/>
</void>
<void property="maxStatsKeyPrefixLength">
- <int>200</int>
+ <int>150</int>
</void>
<void property="numFiles">
<int>1</int>
@@ -2979,11 +2979,11 @@
<object class="org.apache.hadoop.hive.ql.plan.FilterDesc">
<void property="predicate">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -3020,7 +3020,7 @@
</void>
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -3271,7 +3271,7 @@
<object class="org.apache.hadoop.hive.ql.plan.FilterDesc">
<void property="predicate">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/input4.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/input4.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/input4.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/input4.q.xml Tue Oct 22 17:58:59 2013
@@ -550,7 +550,7 @@
<object class="org.apache.hadoop.hive.ql.plan.FilterDesc">
<void property="predicate">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object idref="ExprNodeColumnDesc1"/>
@@ -1242,7 +1242,7 @@
<object idref="ListBucketingCtx0"/>
</void>
<void property="maxStatsKeyPrefixLength">
- <int>200</int>
+ <int>150</int>
</void>
<void property="numFiles">
<int>1</int>
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/input5.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/input5.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/input5.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/input5.q.xml Tue Oct 22 17:58:59 2013
@@ -1292,7 +1292,7 @@
<object idref="ListBucketingCtx0"/>
</void>
<void property="maxStatsKeyPrefixLength">
- <int>200</int>
+ <int>150</int>
</void>
<void property="numFiles">
<int>1</int>
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/input6.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/input6.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/input6.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/input6.q.xml Tue Oct 22 17:58:59 2013
@@ -705,7 +705,7 @@
<object idref="ListBucketingCtx0"/>
</void>
<void property="maxStatsKeyPrefixLength">
- <int>200</int>
+ <int>150</int>
</void>
<void property="numFiles">
<int>1</int>
@@ -887,7 +887,7 @@
<object class="org.apache.hadoop.hive.ql.plan.FilterDesc">
<void property="predicate">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/input7.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/input7.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/input7.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/input7.q.xml Tue Oct 22 17:58:59 2013
@@ -701,7 +701,7 @@
<object idref="ListBucketingCtx0"/>
</void>
<void property="maxStatsKeyPrefixLength">
- <int>200</int>
+ <int>150</int>
</void>
<void property="numFiles">
<int>1</int>
Modified: hive/branches/maven/ql/src/test/results/compiler/plan/input8.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/compiler/plan/input8.q.xml?rev=1534711&r1=1534710&r2=1534711&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/compiler/plan/input8.q.xml (original)
+++ hive/branches/maven/ql/src/test/results/compiler/plan/input8.q.xml Tue Oct 22 17:58:59 2013
@@ -320,7 +320,7 @@
<void method="put">
<string>_col2</string>
<object id="ExprNodeGenericFuncDesc0" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeNullDesc"/>
@@ -351,7 +351,7 @@
<void method="put">
<string>_col1</string>
<object id="ExprNodeGenericFuncDesc1" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
@@ -396,7 +396,7 @@
<void method="put">
<string>_col0</string>
<object id="ExprNodeGenericFuncDesc2" class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc">
- <void property="childExprs">
+ <void property="children">
<object class="java.util.ArrayList">
<void method="add">
<object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc">