You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by sd...@apache.org on 2012/01/31 07:39:47 UTC
svn commit: r1238175 [3/4] - in /hive/trunk:
contrib/src/test/results/clientpositive/ data/files/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
ql/src/test/results/compiler/plan/
Modified: hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out Tue Jan 31 06:39:43 2012
@@ -30,13 +30,13 @@ POSTHOOK: query: CREATE TABLE db2.destin
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: db2@destinTable
PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME db1 sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME db2 destinTable) (TOK_PARTSPEC (TOK_PARTVAL ds '2011-11-11')))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '2011-11-11')) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL one))) (TOK_LIMIT 5)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME db1 sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME db2 destinTable) (TOK_PARTSPEC (TOK_PARTVAL ds '2011-11-11')))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '2011-11-11')) (TOK_ORDERBY (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL one)) (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL two))) (TOK_LIMIT 5)))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -62,7 +62,9 @@ STAGE PLANS:
key expressions:
expr: _col0
type: string
- sort order: +
+ expr: _col1
+ type: string
+ sort order: --
tag: -1
value expressions:
expr: _col0
@@ -87,7 +89,9 @@ STAGE PLANS:
key expressions:
expr: _col0
type: string
- sort order: +
+ expr: _col1
+ type: string
+ sort order: --
tag: -1
value expressions:
expr: _col0
@@ -123,42 +127,42 @@ STAGE PLANS:
PREHOOK: query: INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
PREHOOK: type: QUERY
PREHOOK: Input: db1@sourcetable@ds=2011-11-11
PREHOOK: Output: db2@destintable@ds=2011-11-11
POSTHOOK: query: INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
POSTHOOK: type: QUERY
POSTHOOK: Input: db1@sourcetable@ds=2011-11-11
POSTHOOK: Output: db2@destintable@ds=2011-11-11
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).one SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:one, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
-PREHOOK: query: select one,two from db2.destinTable
+PREHOOK: query: select one,two from db2.destinTable order by one desc, two desc
PREHOOK: type: QUERY
PREHOOK: Input: db2@destintable@ds=2011-11-11
#### A masked pattern was here ####
-POSTHOOK: query: select one,two from db2.destinTable
+POSTHOOK: query: select one,two from db2.destinTable order by one desc, two desc
POSTHOOK: type: QUERY
POSTHOOK: Input: db2@destintable@ds=2011-11-11
#### A masked pattern was here ####
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).one SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:one, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
-
-
- val_27
- val_165
- val_409
+98 val_98
+98 val_98
+98 val_98
+97 val_97
+97 val_97
PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
POSTHOOK: type: QUERY
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).one SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:one, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME db1 sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME db2 destinTable) (TOK_PARTSPEC (TOK_PARTVAL ds '2011-11-11')))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '2011-11-11')) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL one))) (TOK_LIMIT 5)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME db1 sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME db2 destinTable) (TOK_PARTSPEC (TOK_PARTVAL ds '2011-11-11')))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '2011-11-11')) (TOK_ORDERBY (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL one)) (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL two))) (TOK_LIMIT 5)))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -184,7 +188,9 @@ STAGE PLANS:
key expressions:
expr: _col0
type: string
- sort order: +
+ expr: _col1
+ type: string
+ sort order: --
tag: -1
value expressions:
expr: _col0
@@ -209,7 +215,9 @@ STAGE PLANS:
key expressions:
expr: _col0
type: string
- sort order: +
+ expr: _col1
+ type: string
+ sort order: --
tag: -1
value expressions:
expr: _col0
@@ -245,12 +253,12 @@ STAGE PLANS:
PREHOOK: query: INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
PREHOOK: type: QUERY
PREHOOK: Input: db1@sourcetable@ds=2011-11-11
PREHOOK: Output: db2@destintable@ds=2011-11-11
POSTHOOK: query: INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
-SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one limit 5
+SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
POSTHOOK: type: QUERY
POSTHOOK: Input: db1@sourcetable@ds=2011-11-11
POSTHOOK: Output: db2@destintable@ds=2011-11-11
@@ -258,11 +266,11 @@ POSTHOOK: Lineage: destintable PARTITION
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).one SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:one, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
-PREHOOK: query: select one,two from db2.destinTable
+PREHOOK: query: select one,two from db2.destinTable order by one desc, two desc
PREHOOK: type: QUERY
PREHOOK: Input: db2@destintable@ds=2011-11-11
#### A masked pattern was here ####
-POSTHOOK: query: select one,two from db2.destinTable
+POSTHOOK: query: select one,two from db2.destinTable order by one desc, two desc
POSTHOOK: type: QUERY
POSTHOOK: Input: db2@destintable@ds=2011-11-11
#### A masked pattern was here ####
@@ -270,11 +278,11 @@ POSTHOOK: Lineage: destintable PARTITION
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).one SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:one, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11).two SIMPLE [(sourcetable)db1.sourcetable.FieldSchema(name:two, type:string, comment:null), ]
-
-
- val_27
- val_165
- val_409
+98 val_98
+98 val_98
+98 val_98
+97 val_97
+97 val_97
PREHOOK: query: drop table db2.destinTable
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table db2.destinTable
Modified: hive/trunk/ql/src/test/results/clientpositive/join0.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join0.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join0.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join0.q.out Tue Jan 31 06:39:43 2012
@@ -31,7 +31,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Select Operator
expressions:
@@ -53,7 +53,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join11.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join11.q.out Tue Jan 31 06:39:43 2012
@@ -30,7 +30,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 100)
+ expr: (key < 100.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join12.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join12.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join12.q.out Tue Jan 31 06:39:43 2012
@@ -36,7 +36,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 100)
+ expr: (key < 100.0)
type: boolean
Select Operator
expressions:
@@ -82,7 +82,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 80)
+ expr: (key < 80.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join13.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join13.q.out Tue Jan 31 06:39:43 2012
@@ -37,7 +37,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 100)
+ expr: (key < 100.0)
type: boolean
Select Operator
expressions:
@@ -119,7 +119,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 200)
+ expr: (key < 200.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join14.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join14.q.out Tue Jan 31 06:39:43 2012
@@ -28,7 +28,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key > 100)
+ expr: (key > 100.0)
type: boolean
Reduce Output Operator
key expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join16.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join16.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join16.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join16.q.out Tue Jan 31 06:39:43 2012
@@ -18,7 +18,7 @@ STAGE PLANS:
alias: a
Filter Operator
predicate:
- expr: (((key > 10) and (key > 20)) and (value < 200))
+ expr: (((key > 10.0) and (key > 20.0)) and (value < 200.0))
type: boolean
Select Operator
expressions:
@@ -48,7 +48,7 @@ STAGE PLANS:
alias: tab
Filter Operator
predicate:
- expr: (value < 200)
+ expr: (value < 200.0)
type: boolean
Reduce Output Operator
key expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join20.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join20.q.out Tue Jan 31 06:39:43 2012
@@ -23,7 +23,7 @@ STAGE PLANS:
alias: src1
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -85,7 +85,7 @@ STAGE PLANS:
filter predicates:
0
1
- 2 {(VALUE._col0 < 20)}
+ 2 {(VALUE._col0 < 20.0)}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
@@ -740,7 +740,7 @@ STAGE PLANS:
alias: src1
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -761,7 +761,7 @@ STAGE PLANS:
alias: src2
Filter Operator
predicate:
- expr: (key < 15)
+ expr: (key < 15.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -806,7 +806,7 @@ STAGE PLANS:
filter predicates:
0
1
- 2 {(VALUE._col0 < 20)}
+ 2 {(VALUE._col0 < 20.0)}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join21.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join21.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join21.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join21.q.out Tue Jan 31 06:39:43 2012
@@ -38,7 +38,7 @@ STAGE PLANS:
alias: src2
Filter Operator
predicate:
- expr: (key > 10)
+ expr: (key > 10.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -81,9 +81,9 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1}
2 {VALUE._col0} {VALUE._col1}
filter predicates:
- 0 {(VALUE._col0 < 10)}
+ 0 {(VALUE._col0 < 10.0)}
1
- 2 {(VALUE._col0 < 10)}
+ 2 {(VALUE._col0 < 10.0)}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join23.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join23.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join23.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join23.q.out Tue Jan 31 06:39:43 2012
@@ -21,7 +21,7 @@ STAGE PLANS:
alias: src1
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Reduce Output Operator
sort order:
@@ -36,7 +36,7 @@ STAGE PLANS:
alias: src2
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Reduce Output Operator
sort order:
Modified: hive/trunk/ql/src/test/results/clientpositive/join34.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join34.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join34.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join34.q.out Tue Jan 31 06:39:43 2012
@@ -67,7 +67,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (key < 20)
+ expr: (key < 20.0)
type: boolean
Select Operator
expressions:
@@ -138,7 +138,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (key > 100)
+ expr: (key > 100.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join35.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join35.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join35.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join35.q.out Tue Jan 31 06:39:43 2012
@@ -48,7 +48,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (key < 20)
+ expr: (key < 20.0)
type: boolean
Select Operator
expressions:
@@ -451,7 +451,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (key > 100)
+ expr: (key > 100.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join38.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join38.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join38.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join38.q.out Tue Jan 31 06:39:43 2012
@@ -91,7 +91,7 @@ STAGE PLANS:
alias: a
Filter Operator
predicate:
- expr: (key = 111)
+ expr: (key = 111.0)
type: boolean
HashTable Sink Operator
condition expressions:
@@ -111,7 +111,7 @@ STAGE PLANS:
alias: b
Filter Operator
predicate:
- expr: (col11 = 111)
+ expr: (col11 = 111.0)
type: boolean
Map Join Operator
condition map:
Modified: hive/trunk/ql/src/test/results/clientpositive/join39.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join39.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join39.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join39.q.out Tue Jan 31 06:39:43 2012
@@ -38,7 +38,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key <= 100)
+ expr: (key <= 100.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join4.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join4.q.out Tue Jan 31 06:39:43 2012
@@ -50,7 +50,7 @@ STAGE PLANS:
alias: src1
Filter Operator
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Select Operator
expressions:
@@ -78,7 +78,7 @@ STAGE PLANS:
alias: src2
Filter Operator
predicate:
- expr: ((key > 15) and (key < 25))
+ expr: ((key > 15.0) and (key < 25.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join40.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join40.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join40.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join40.q.out Tue Jan 31 06:39:43 2012
@@ -37,7 +37,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key <= 100)
+ expr: (key <= 100.0)
type: boolean
Select Operator
expressions:
@@ -1806,7 +1806,7 @@ STAGE PLANS:
alias: src1
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -1868,7 +1868,7 @@ STAGE PLANS:
filter predicates:
0
1
- 2 {(VALUE._col0 < 20)}
+ 2 {(VALUE._col0 < 20.0)}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
@@ -2523,7 +2523,7 @@ STAGE PLANS:
alias: src1
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -2544,7 +2544,7 @@ STAGE PLANS:
alias: src2
Filter Operator
predicate:
- expr: (key < 15)
+ expr: (key < 15.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -2589,7 +2589,7 @@ STAGE PLANS:
filter predicates:
0
1
- 2 {(VALUE._col0 < 20)}
+ 2 {(VALUE._col0 < 20.0)}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Select Operator
@@ -3248,7 +3248,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key <= 100)
+ expr: (key <= 100.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join5.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join5.q.out Tue Jan 31 06:39:43 2012
@@ -50,7 +50,7 @@ STAGE PLANS:
alias: src1
Filter Operator
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Select Operator
expressions:
@@ -78,7 +78,7 @@ STAGE PLANS:
alias: src2
Filter Operator
predicate:
- expr: ((key > 15) and (key < 25))
+ expr: ((key > 15.0) and (key < 25.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join6.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join6.q.out Tue Jan 31 06:39:43 2012
@@ -50,7 +50,7 @@ STAGE PLANS:
alias: src1
Filter Operator
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Select Operator
expressions:
@@ -78,7 +78,7 @@ STAGE PLANS:
alias: src2
Filter Operator
predicate:
- expr: ((key > 15) and (key < 25))
+ expr: ((key > 15.0) and (key < 25.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join7.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join7.q.out Tue Jan 31 06:39:43 2012
@@ -60,7 +60,7 @@ STAGE PLANS:
alias: src1
Filter Operator
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Select Operator
expressions:
@@ -88,7 +88,7 @@ STAGE PLANS:
alias: src2
Filter Operator
predicate:
- expr: ((key > 15) and (key < 25))
+ expr: ((key > 15.0) and (key < 25.0))
type: boolean
Select Operator
expressions:
@@ -116,7 +116,7 @@ STAGE PLANS:
alias: src3
Filter Operator
predicate:
- expr: ((key > 20) and (key < 25))
+ expr: ((key > 20.0) and (key < 25.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join8.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join8.q.out Tue Jan 31 06:39:43 2012
@@ -50,7 +50,7 @@ STAGE PLANS:
alias: src1
Filter Operator
predicate:
- expr: (((key > 10) and (key < 20)) and key is not null)
+ expr: (((key > 10.0) and (key < 20.0)) and key is not null)
type: boolean
Select Operator
expressions:
@@ -78,7 +78,7 @@ STAGE PLANS:
alias: src2
Filter Operator
predicate:
- expr: (((key > 15) and (key < 25)) and key is not null)
+ expr: (((key > 15.0) and (key < 25.0)) and key is not null)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/load_dyn_part13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part13.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/load_dyn_part13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/load_dyn_part13.q.out Tue Jan 31 06:39:43 2012
@@ -60,7 +60,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 20)
+ expr: (key < 20.0)
type: boolean
Select Operator
expressions:
@@ -94,7 +94,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key > 20) and (key < 40))
+ expr: ((key > 20.0) and (key < 40.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out Tue Jan 31 06:39:43 2012
@@ -34,7 +34,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -57,7 +57,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -195,7 +195,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((_col4 > 15) and (_col4 < 25))
+ expr: ((_col4 > 15.0) and (_col4 < 25.0))
type: boolean
Select Operator
expressions:
@@ -303,7 +303,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -328,7 +328,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -543,7 +543,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((_col6 > 15) and (_col6 < 25))
+ expr: ((_col6 > 15.0) and (_col6 < 25.0))
type: boolean
Select Operator
expressions:
@@ -655,7 +655,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -678,7 +678,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -892,7 +892,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (((_col4 > 15) and (_col4 < 25)) and (_col6 = '2008-04-08'))
+ expr: (((_col4 > 15.0) and (_col4 < 25.0)) and (_col6 = '2008-04-08'))
type: boolean
Select Operator
expressions:
@@ -1004,7 +1004,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -1029,7 +1029,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -1167,7 +1167,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((_col6 > 15) and (_col6 < 25))
+ expr: ((_col6 > 15.0) and (_col6 < 25.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out Tue Jan 31 06:39:43 2012
@@ -37,7 +37,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Select Operator
expressions:
@@ -56,7 +56,7 @@ STAGE PLANS:
name: default.src_multi1
Filter Operator
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Select Operator
expressions:
@@ -201,7 +201,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Select Operator
expressions:
@@ -220,7 +220,7 @@ STAGE PLANS:
name: default.src_multi1
Filter Operator
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Select Operator
expressions:
@@ -419,7 +419,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Select Operator
expressions:
@@ -438,7 +438,7 @@ STAGE PLANS:
name: default.src_multi1
Filter Operator
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Select Operator
expressions:
@@ -615,7 +615,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Select Operator
expressions:
@@ -634,7 +634,7 @@ STAGE PLANS:
name: default.src_multi1
Filter Operator
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Select Operator
expressions:
@@ -865,7 +865,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key < 10) or ((key > 10) and (key < 20)))
+ expr: ((key < 10.0) or ((key > 10.0) and (key < 20.0)))
type: boolean
Select Operator
expressions:
@@ -1118,7 +1118,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key < 10) or ((key > 10) and (key < 20)))
+ expr: ((key < 10.0) or ((key > 10.0) and (key < 20.0)))
type: boolean
Select Operator
expressions:
@@ -1409,7 +1409,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key < 10) or ((key > 10) and (key < 20)))
+ expr: ((key < 10.0) or ((key > 10.0) and (key < 20.0)))
type: boolean
Select Operator
expressions:
@@ -1662,7 +1662,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key < 10) or ((key > 10) and (key < 20)))
+ expr: ((key < 10.0) or ((key > 10.0) and (key < 20.0)))
type: boolean
Select Operator
expressions:
@@ -1961,7 +1961,7 @@ STAGE PLANS:
Union
Filter Operator
predicate:
- expr: (_col0 < 10)
+ expr: (_col0 < 10.0)
type: boolean
Select Operator
expressions:
@@ -1980,7 +1980,7 @@ STAGE PLANS:
name: default.src_multi1
Filter Operator
predicate:
- expr: ((_col0 > 10) and (_col0 < 20))
+ expr: ((_col0 > 10.0) and (_col0 < 20.0))
type: boolean
Select Operator
expressions:
@@ -2010,7 +2010,7 @@ STAGE PLANS:
Union
Filter Operator
predicate:
- expr: (_col0 < 10)
+ expr: (_col0 < 10.0)
type: boolean
Select Operator
expressions:
@@ -2029,7 +2029,7 @@ STAGE PLANS:
name: default.src_multi1
Filter Operator
predicate:
- expr: ((_col0 > 10) and (_col0 < 20))
+ expr: ((_col0 > 10.0) and (_col0 < 20.0))
type: boolean
Select Operator
expressions:
@@ -2265,7 +2265,7 @@ STAGE PLANS:
Union
Filter Operator
predicate:
- expr: (_col0 < 10)
+ expr: (_col0 < 10.0)
type: boolean
Select Operator
expressions:
@@ -2284,7 +2284,7 @@ STAGE PLANS:
name: default.src_multi1
Filter Operator
predicate:
- expr: ((_col0 > 10) and (_col0 < 20))
+ expr: ((_col0 > 10.0) and (_col0 < 20.0))
type: boolean
Select Operator
expressions:
@@ -2314,7 +2314,7 @@ STAGE PLANS:
Union
Filter Operator
predicate:
- expr: (_col0 < 10)
+ expr: (_col0 < 10.0)
type: boolean
Select Operator
expressions:
@@ -2333,7 +2333,7 @@ STAGE PLANS:
name: default.src_multi1
Filter Operator
predicate:
- expr: ((_col0 > 10) and (_col0 < 20))
+ expr: ((_col0 > 10.0) and (_col0 < 20.0))
type: boolean
Select Operator
expressions:
@@ -2623,7 +2623,7 @@ STAGE PLANS:
Union
Filter Operator
predicate:
- expr: (_col0 < 10)
+ expr: (_col0 < 10.0)
type: boolean
Select Operator
expressions:
@@ -2642,7 +2642,7 @@ STAGE PLANS:
name: default.src_multi1
Filter Operator
predicate:
- expr: ((_col0 > 10) and (_col0 < 20))
+ expr: ((_col0 > 10.0) and (_col0 < 20.0))
type: boolean
Select Operator
expressions:
@@ -2672,7 +2672,7 @@ STAGE PLANS:
Union
Filter Operator
predicate:
- expr: (_col0 < 10)
+ expr: (_col0 < 10.0)
type: boolean
Select Operator
expressions:
@@ -2691,7 +2691,7 @@ STAGE PLANS:
name: default.src_multi1
Filter Operator
predicate:
- expr: ((_col0 > 10) and (_col0 < 20))
+ expr: ((_col0 > 10.0) and (_col0 < 20.0))
type: boolean
Select Operator
expressions:
@@ -2959,7 +2959,7 @@ STAGE PLANS:
Union
Filter Operator
predicate:
- expr: (_col0 < 10)
+ expr: (_col0 < 10.0)
type: boolean
Select Operator
expressions:
@@ -2978,7 +2978,7 @@ STAGE PLANS:
name: default.src_multi1
Filter Operator
predicate:
- expr: ((_col0 > 10) and (_col0 < 20))
+ expr: ((_col0 > 10.0) and (_col0 < 20.0))
type: boolean
Select Operator
expressions:
@@ -3008,7 +3008,7 @@ STAGE PLANS:
Union
Filter Operator
predicate:
- expr: (_col0 < 10)
+ expr: (_col0 < 10.0)
type: boolean
Select Operator
expressions:
@@ -3027,7 +3027,7 @@ STAGE PLANS:
name: default.src_multi1
Filter Operator
predicate:
- expr: ((_col0 > 10) and (_col0 < 20))
+ expr: ((_col0 > 10.0) and (_col0 < 20.0))
type: boolean
Select Operator
expressions:
@@ -3338,7 +3338,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key = 0)
+ expr: (key = 0.0)
type: boolean
Select Operator
expressions:
@@ -3355,7 +3355,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Filter Operator
predicate:
- expr: (key = 2)
+ expr: (key = 2.0)
type: boolean
Select Operator
expressions:
@@ -3372,7 +3372,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Filter Operator
predicate:
- expr: (key = 4)
+ expr: (key = 4.0)
type: boolean
Select Operator
expressions:
@@ -3510,7 +3510,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key = 0)
+ expr: (key = 0.0)
type: boolean
Select Operator
expressions:
@@ -3527,7 +3527,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Filter Operator
predicate:
- expr: (key = 2)
+ expr: (key = 2.0)
type: boolean
Select Operator
expressions:
@@ -3544,7 +3544,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Filter Operator
predicate:
- expr: (key = 4)
+ expr: (key = 4.0)
type: boolean
Select Operator
expressions:
@@ -3682,7 +3682,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key = 0)
+ expr: (key = 0.0)
type: boolean
Select Operator
expressions:
@@ -3699,7 +3699,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Filter Operator
predicate:
- expr: (key = 2)
+ expr: (key = 2.0)
type: boolean
Select Operator
expressions:
@@ -3716,7 +3716,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Filter Operator
predicate:
- expr: (key = 4)
+ expr: (key = 4.0)
type: boolean
Select Operator
expressions:
@@ -3854,7 +3854,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key = 0)
+ expr: (key = 0.0)
type: boolean
Select Operator
expressions:
@@ -3871,7 +3871,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Filter Operator
predicate:
- expr: (key = 2)
+ expr: (key = 2.0)
type: boolean
Select Operator
expressions:
@@ -3888,7 +3888,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Filter Operator
predicate:
- expr: (key = 4)
+ expr: (key = 4.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out Tue Jan 31 06:39:43 2012
@@ -18,7 +18,7 @@ STAGE PLANS:
alias: src1
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Reduce Output Operator
sort order:
@@ -33,7 +33,7 @@ STAGE PLANS:
alias: src2
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Reduce Output Operator
sort order:
Modified: hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out Tue Jan 31 06:39:43 2012
@@ -20,7 +20,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 100)
+ expr: (key < 100.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out Tue Jan 31 06:39:43 2012
@@ -28,7 +28,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 100)
+ expr: (key < 100.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out Tue Jan 31 06:39:43 2012
@@ -28,7 +28,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 100)
+ expr: (key < 100.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out Tue Jan 31 06:39:43 2012
@@ -20,7 +20,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key > 9999)
+ expr: (key > 9999.0)
type: boolean
Select Operator
Group By Operator
@@ -90,7 +90,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key > 9999)
+ expr: (key > 9999.0)
type: boolean
Select Operator
Group By Operator
@@ -161,7 +161,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key > 9999)
+ expr: (key > 9999.0)
type: boolean
Select Operator
Reduce Output Operator
@@ -252,7 +252,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key > 9999)
+ expr: (key > 9999.0)
type: boolean
Select Operator
Reduce Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out Tue Jan 31 06:39:43 2012
@@ -21,7 +21,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key > 9999)
+ expr: (key > 9999.0)
type: boolean
Select Operator
expressions:
@@ -141,7 +141,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key > 9999)
+ expr: (key > 9999.0)
type: boolean
Select Operator
expressions:
@@ -229,7 +229,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key > 9999)
+ expr: (key > 9999.0)
type: boolean
Select Operator
expressions:
@@ -340,7 +340,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key > 9999)
+ expr: (key > 9999.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out Tue Jan 31 06:39:43 2012
@@ -21,7 +21,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 9999)
+ expr: (key = 9999.0)
type: boolean
Select Operator
expressions:
@@ -137,7 +137,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 9999)
+ expr: (key = 9999.0)
type: boolean
Select Operator
expressions:
@@ -224,7 +224,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 9999)
+ expr: (key = 9999.0)
type: boolean
Select Operator
expressions:
@@ -328,7 +328,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 9999)
+ expr: (key = 9999.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out Tue Jan 31 06:39:43 2012
@@ -20,7 +20,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 9999)
+ expr: (key = 9999.0)
type: boolean
Select Operator
expressions:
@@ -116,7 +116,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 9999)
+ expr: (key = 9999.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/order2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/order2.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/order2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/order2.q.out Tue Jan 31 06:39:43 2012
@@ -45,7 +45,7 @@ STAGE PLANS:
Limit
Filter Operator
predicate:
- expr: (_col0 < 10)
+ expr: (_col0 < 10.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out Tue Jan 31 06:39:43 2012
@@ -264,7 +264,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((((_col4 > 15) and (_col4 < 25)) and (_col0 > 10)) and (_col0 < 20))
+ expr: ((((_col4 > 15.0) and (_col4 < 25.0)) and (_col0 > 10.0)) and (_col0 < 20.0))
type: boolean
Select Operator
expressions:
@@ -603,7 +603,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (((((_col4 > 15) and (_col4 < 25)) and (_col6 = '2008-04-08')) and (_col0 > 10)) and (_col0 < 20))
+ expr: (((((_col4 > 15.0) and (_col4 < 25.0)) and (_col6 = '2008-04-08')) and (_col0 > 10.0)) and (_col0 < 20.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/pcr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/pcr.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/pcr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/pcr.q.out Tue Jan 31 06:39:43 2012
@@ -4624,7 +4624,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (key = 11)
+ expr: (key = 11.0)
type: boolean
Select Operator
expressions:
@@ -4825,7 +4825,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (key = 11)
+ expr: (key = 11.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out Tue Jan 31 06:39:43 2012
@@ -20,11 +20,11 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 10)
+ expr: (key = 10.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 10)
+ expr: (key = 10.0)
type: boolean
Select Operator
expressions:
@@ -93,7 +93,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -114,7 +114,7 @@ STAGE PLANS:
alias: y
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -139,7 +139,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col4
Filter Operator
predicate:
- expr: (_col0 = 20)
+ expr: (_col0 = 20.0)
type: boolean
Select Operator
expressions:
@@ -222,7 +222,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 10)
+ expr: (key = 10.0)
type: boolean
Select Operator
expressions:
@@ -291,7 +291,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -312,7 +312,7 @@ STAGE PLANS:
alias: y
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Reduce Output Operator
key expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out Tue Jan 31 06:39:43 2012
@@ -84,7 +84,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
Filter Operator
predicate:
- expr: (_col0 < 100)
+ expr: (_col0 < 100.0)
type: boolean
Select Operator
expressions:
@@ -110,7 +110,7 @@ STAGE PLANS:
name: default.mi1
Filter Operator
predicate:
- expr: ((_col0 >= 100) and (_col0 < 200))
+ expr: ((_col0 >= 100.0) and (_col0 < 200.0))
type: boolean
Select Operator
expressions:
@@ -136,7 +136,7 @@ STAGE PLANS:
name: default.mi2
Filter Operator
predicate:
- expr: ((_col0 >= 200) and (_col0 < 300))
+ expr: ((_col0 >= 200.0) and (_col0 < 300.0))
type: boolean
Select Operator
expressions:
@@ -158,7 +158,7 @@ STAGE PLANS:
name: default.mi3
Filter Operator
predicate:
- expr: (_col0 >= 300)
+ expr: (_col0 >= 300.0)
type: boolean
Select Operator
expressions:
@@ -1391,7 +1391,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
Filter Operator
predicate:
- expr: (_col0 < 100)
+ expr: (_col0 < 100.0)
type: boolean
Select Operator
expressions:
@@ -1417,7 +1417,7 @@ STAGE PLANS:
name: default.mi1
Filter Operator
predicate:
- expr: ((_col0 >= 100) and (_col0 < 200))
+ expr: ((_col0 >= 100.0) and (_col0 < 200.0))
type: boolean
Select Operator
expressions:
@@ -1443,7 +1443,7 @@ STAGE PLANS:
name: default.mi2
Filter Operator
predicate:
- expr: ((_col0 >= 200) and (_col0 < 300))
+ expr: ((_col0 >= 200.0) and (_col0 < 300.0))
type: boolean
Select Operator
expressions:
@@ -1465,7 +1465,7 @@ STAGE PLANS:
name: default.mi3
Filter Operator
predicate:
- expr: (_col0 >= 300)
+ expr: (_col0 >= 300.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out Tue Jan 31 06:39:43 2012
@@ -32,7 +32,7 @@ STAGE PLANS:
alias: a
Filter Operator
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -53,7 +53,7 @@ STAGE PLANS:
alias: b
Filter Operator
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -80,7 +80,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col4, _col5
Filter Operator
predicate:
- expr: ((((_col0 > 10) and (_col0 < 20)) and (_col4 > 15)) and (_col4 < 25))
+ expr: ((((_col0 > 10.0) and (_col0 < 20.0)) and (_col4 > 15.0)) and (_col4 < 25.0))
type: boolean
Select Operator
expressions:
@@ -165,7 +165,7 @@ STAGE PLANS:
alias: a
Filter Operator
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -186,7 +186,7 @@ STAGE PLANS:
alias: b
Filter Operator
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -213,7 +213,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col4, _col5
Filter Operator
predicate:
- expr: ((_col4 > 15) and (_col4 < 25))
+ expr: ((_col4 > 15.0) and (_col4 < 25.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out Tue Jan 31 06:39:43 2012
@@ -60,7 +60,7 @@ STAGE PLANS:
Extract
Filter Operator
predicate:
- expr: (_col0 < 100)
+ expr: (_col0 < 100.0)
type: boolean
Select Operator
expressions:
@@ -231,7 +231,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Filter Operator
predicate:
- expr: (_col0 < 100)
+ expr: (_col0 < 100.0)
type: boolean
Reduce Output Operator
key expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out Tue Jan 31 06:39:43 2012
@@ -24,11 +24,11 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key = 100)
+ expr: (key = 100.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 100)
+ expr: (key = 100.0)
type: boolean
Select Operator
expressions:
@@ -90,11 +90,11 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key = 100)
+ expr: (key = 100.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 100)
+ expr: (key = 100.0)
type: boolean
Select Operator
expressions:
@@ -164,11 +164,11 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key = 100)
+ expr: (key = 100.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 100)
+ expr: (key = 100.0)
type: boolean
Select Operator
expressions:
@@ -181,7 +181,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col2, _col3
Filter Operator
predicate:
- expr: (_col3 <= 3)
+ expr: (_col3 <= 3.0)
type: boolean
Select Operator
expressions:
@@ -230,11 +230,11 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key = 100)
+ expr: (key = 100.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 100)
+ expr: (key = 100.0)
type: boolean
Select Operator
expressions:
@@ -247,7 +247,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col2, _col3
Filter Operator
predicate:
- expr: (_col3 <= 200)
+ expr: (_col3 <= 200.0)
type: boolean
Select Operator
expressions:
@@ -296,7 +296,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key = 100)
+ expr: (key = 100.0)
type: boolean
Select Operator
expressions:
@@ -358,7 +358,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key = 100)
+ expr: (key = 100.0)
type: boolean
Select Operator
expressions:
@@ -424,7 +424,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key = 100)
+ expr: (key = 100.0)
type: boolean
Select Operator
expressions:
@@ -437,7 +437,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col2, _col3
Filter Operator
predicate:
- expr: (_col3 <= 3)
+ expr: (_col3 <= 3.0)
type: boolean
Select Operator
expressions:
@@ -486,7 +486,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key = 100)
+ expr: (key = 100.0)
type: boolean
Select Operator
expressions:
@@ -499,7 +499,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col2, _col3
Filter Operator
predicate:
- expr: (_col3 <= 200)
+ expr: (_col3 <= 200.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown.q.out Tue Jan 31 06:39:43 2012
@@ -159,11 +159,11 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-PREHOOK: query: select * from ppr_test where ds = '1234'
+PREHOOK: query: select * from ppr_test where ds = '1234' order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test@ds=1234
#### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '1234'
+POSTHOOK: query: select * from ppr_test where ds = '1234' order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test@ds=1234
#### A masked pattern was here ####
@@ -175,13 +175,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd 1234
1234 1234
-PREHOOK: query: select * from ppr_test where ds = '1224'
+abcd 1234
+PREHOOK: query: select * from ppr_test where ds = '1224' order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test@ds=1224
#### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '1224'
+POSTHOOK: query: select * from ppr_test where ds = '1224' order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test@ds=1224
#### A masked pattern was here ####
@@ -193,13 +193,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd 1224
1224 1224
-PREHOOK: query: select * from ppr_test where ds = '1214'
+abcd 1224
+PREHOOK: query: select * from ppr_test where ds = '1214' order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test@ds=1214
#### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '1214'
+POSTHOOK: query: select * from ppr_test where ds = '1214' order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test@ds=1214
#### A masked pattern was here ####
@@ -211,13 +211,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd 1214
1214 1214
-PREHOOK: query: select * from ppr_test where ds = '12.4'
+abcd 1214
+PREHOOK: query: select * from ppr_test where ds = '12.4' order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test@ds=12.4
#### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '12.4'
+POSTHOOK: query: select * from ppr_test where ds = '12.4' order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test@ds=12.4
#### A masked pattern was here ####
@@ -229,13 +229,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd 12.4
12.4 12.4
-PREHOOK: query: select * from ppr_test where ds = '12+4'
+abcd 12.4
+PREHOOK: query: select * from ppr_test where ds = '12+4' order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test@ds=12+4
#### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '12+4'
+POSTHOOK: query: select * from ppr_test where ds = '12+4' order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test@ds=12+4
#### A masked pattern was here ####
@@ -247,13 +247,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd 12+4
12+4 12+4
-PREHOOK: query: select * from ppr_test where ds = '12:4'
+abcd 12+4
+PREHOOK: query: select * from ppr_test where ds = '12:4' order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test@ds=12%3A4
#### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '12:4'
+POSTHOOK: query: select * from ppr_test where ds = '12:4' order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test@ds=12%3A4
#### A masked pattern was here ####
@@ -265,13 +265,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd 12:4
12:4 12:4
-PREHOOK: query: select * from ppr_test where ds = '12%4'
+abcd 12:4
+PREHOOK: query: select * from ppr_test where ds = '12%4' order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test@ds=12%254
#### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '12%4'
+POSTHOOK: query: select * from ppr_test where ds = '12%4' order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test@ds=12%254
#### A masked pattern was here ####
@@ -283,13 +283,13 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd 12%4
12%4 12%4
-PREHOOK: query: select * from ppr_test where ds = '12*4'
+abcd 12%4
+PREHOOK: query: select * from ppr_test where ds = '12*4' order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test@ds=12%2A4
#### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '12*4'
+POSTHOOK: query: select * from ppr_test where ds = '12*4' order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test@ds=12%2A4
#### A masked pattern was here ####
@@ -301,12 +301,12 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-abcd 12*4
12*4 12*4
-PREHOOK: query: select * from ppr_test where ds = '12.*4'
+abcd 12*4
+PREHOOK: query: select * from ppr_test where ds = '12.*4' order by key
PREHOOK: type: QUERY
#### A masked pattern was here ####
-POSTHOOK: query: select * from ppr_test where ds = '12.*4'
+POSTHOOK: query: select * from ppr_test where ds = '12.*4' order by key
POSTHOOK: type: QUERY
#### A masked pattern was here ####
POSTHOOK: Lineage: ppr_test PARTITION(ds=12%4).key EXPRESSION []
Modified: hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown3.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown3.q.out Tue Jan 31 06:39:43 2012
@@ -18,7 +18,7 @@ STAGE PLANS:
alias: srcpart
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/quote1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/quote1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/quote1.q.out Tue Jan 31 06:39:43 2012
@@ -31,7 +31,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key >= 200) and (key < 300))
+ expr: ((key >= 200.0) and (key < 300.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out Tue Jan 31 06:39:43 2012
@@ -24,7 +24,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((rand(1) < 0.1) and (not ((key > 50) or (key < 10))))
+ expr: ((rand(1) < 0.1) and (not ((key > 50.0) or (key < 10.0))))
type: boolean
Select Operator
expressions:
@@ -138,7 +138,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (not ((key > 50) or (key < 10)))
+ expr: (not ((key > 50.0) or (key < 10.0)))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/rcfile_null_value.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/rcfile_null_value.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/rcfile_null_value.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/rcfile_null_value.q.out Tue Jan 31 06:39:43 2012
@@ -104,7 +104,7 @@ STAGE PLANS:
alias: src1
Filter Operator
predicate:
- expr: ((key > 10) and (key < 20))
+ expr: ((key > 10.0) and (key < 20.0))
type: boolean
Select Operator
expressions:
@@ -132,7 +132,7 @@ STAGE PLANS:
alias: src2
Filter Operator
predicate:
- expr: ((key > 15) and (key < 25))
+ expr: ((key > 15.0) and (key < 25.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out Tue Jan 31 06:39:43 2012
@@ -214,7 +214,7 @@ STAGE PLANS:
alias: a
Filter Operator
predicate:
- expr: (key = 103)
+ expr: (key = 103.0)
type: boolean
Reduce Output Operator
key expressions: