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 [2/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/cluster.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/cluster.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/cluster.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/cluster.q.out Tue Jan 31 06:39:43 2012
@@ -20,7 +20,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 10)
+ expr: (key = 10.0)
type: boolean
Select Operator
expressions:
@@ -88,7 +88,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Select Operator
expressions:
@@ -156,7 +156,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Select Operator
expressions:
@@ -224,7 +224,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Select Operator
expressions:
@@ -292,7 +292,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Select Operator
expressions:
@@ -360,7 +360,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Select Operator
expressions:
@@ -428,7 +428,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Select Operator
expressions:
@@ -519,7 +519,7 @@ STAGE PLANS:
Extract
Filter Operator
predicate:
- expr: (_col0 = 20)
+ expr: (_col0 = 20.0)
type: boolean
Select Operator
expressions:
@@ -572,7 +572,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -593,7 +593,7 @@ STAGE PLANS:
alias: y
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -698,7 +698,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -719,7 +719,7 @@ STAGE PLANS:
alias: y
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -830,7 +830,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -851,7 +851,7 @@ STAGE PLANS:
alias: y
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -962,7 +962,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -983,7 +983,7 @@ STAGE PLANS:
alias: y
Filter Operator
predicate:
- expr: (key = 20)
+ expr: (key = 20.0)
type: boolean
Reduce Output Operator
key expressions:
@@ -1099,7 +1099,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 100)
+ expr: (key < 100.0)
type: boolean
Select Operator
expressions:
@@ -1135,7 +1135,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key > 100)
+ expr: (key > 100.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/create_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_view.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_view.q.out Tue Jan 31 06:39:43 2012
@@ -186,7 +186,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key = 18)
+ expr: (key = 18.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out Tue Jan 31 06:39:43 2012
@@ -79,7 +79,7 @@ STAGE PLANS:
Forward
Filter Operator
predicate:
- expr: (KEY._col0 >= 5)
+ expr: (KEY._col0 >= 5.0)
type: boolean
Group By Operator
aggregations:
@@ -129,7 +129,7 @@ STAGE PLANS:
name: default.dest_g2
Filter Operator
predicate:
- expr: (KEY._col0 < 5)
+ expr: (KEY._col0 < 5.0)
type: boolean
Group By Operator
aggregations:
@@ -480,7 +480,7 @@ STAGE PLANS:
Forward
Filter Operator
predicate:
- expr: (KEY._col0 >= 5)
+ expr: (KEY._col0 >= 5.0)
type: boolean
Group By Operator
aggregations:
@@ -530,7 +530,7 @@ STAGE PLANS:
name: default.dest_g2
Filter Operator
predicate:
- expr: (KEY._col0 < 5)
+ expr: (KEY._col0 < 5.0)
type: boolean
Group By Operator
aggregations:
@@ -723,7 +723,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
Filter Operator
predicate:
- expr: (KEY._col0 >= 5)
+ expr: (KEY._col0 >= 5.0)
type: boolean
Group By Operator
aggregations:
Modified: hive/trunk/ql/src/test/results/clientpositive/having.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/having.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/having.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/having.q.out Tue Jan 31 06:39:43 2012
@@ -113,7 +113,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key <> 302)
+ expr: (key <> 302.0)
type: boolean
Select Operator
expressions:
@@ -792,7 +792,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key > 300)
+ expr: (key > 300.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto.q.out Tue Jan 31 06:39:43 2012
@@ -83,7 +83,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Select Operator
expressions:
@@ -176,11 +176,11 @@ STAGE PLANS:
TableScan
alias: default__src_src_index__
filterExpr:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Filter Operator
predicate:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Select Operator
expressions:
@@ -218,11 +218,11 @@ STAGE PLANS:
TableScan
alias: src
filterExpr:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Filter Operator
predicate:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out Tue Jan 31 06:39:43 2012
@@ -62,11 +62,11 @@ STAGE PLANS:
TableScan
alias: temp
filterExpr:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_file_format.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_file_format.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_file_format.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_file_format.q.out Tue Jan 31 06:39:43 2012
@@ -43,11 +43,11 @@ STAGE PLANS:
TableScan
alias: default__src_src_index__
filterExpr:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
@@ -85,11 +85,11 @@ STAGE PLANS:
TableScan
alias: src
filterExpr:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
@@ -175,11 +175,11 @@ STAGE PLANS:
TableScan
alias: default__src_src_index__
filterExpr:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
@@ -217,11 +217,11 @@ STAGE PLANS:
TableScan
alias: src
filterExpr:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out Tue Jan 31 06:39:43 2012
@@ -25,7 +25,7 @@ STAGE PLANS:
alias: a
Filter Operator
predicate:
- expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90))
+ expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -46,7 +46,7 @@ STAGE PLANS:
alias: b
Filter Operator
predicate:
- expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100))
+ expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -262,11 +262,11 @@ STAGE PLANS:
TableScan
alias: default__srcpart_srcpart_index__
filterExpr:
- expr: (((((key > 70) and (key < 90)) and (key > 80)) and (key < 100)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
+ expr: (((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
type: boolean
Filter Operator
predicate:
- expr: (((((key > 70) and (key < 90)) and (key > 80)) and (key < 100)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
+ expr: (((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
type: boolean
Select Operator
expressions:
@@ -349,11 +349,11 @@ STAGE PLANS:
TableScan
alias: a
filterExpr:
- expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90))
+ expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0))
type: boolean
Filter Operator
predicate:
- expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90))
+ expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -373,11 +373,11 @@ STAGE PLANS:
TableScan
alias: b
filterExpr:
- expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100))
+ expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0))
type: boolean
Filter Operator
predicate:
- expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100))
+ expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -445,11 +445,11 @@ STAGE PLANS:
TableScan
alias: default__src_src_index__
filterExpr:
- expr: (((((key > 80) and (key < 100)) and (key > 70)) and (key < 90)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
+ expr: (((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
type: boolean
Filter Operator
predicate:
- expr: (((((key > 80) and (key < 100)) and (key > 70)) and (key < 90)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
+ expr: (((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out Tue Jan 31 06:39:43 2012
@@ -25,7 +25,7 @@ STAGE PLANS:
alias: a
Filter Operator
predicate:
- expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90))
+ expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -46,7 +46,7 @@ STAGE PLANS:
alias: b
Filter Operator
predicate:
- expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100))
+ expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -264,11 +264,11 @@ STAGE PLANS:
TableScan
alias: default__srcpart_srcpart_index__
filterExpr:
- expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100))
+ expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0))
type: boolean
Filter Operator
predicate:
- expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100))
+ expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0))
type: boolean
Select Operator
expressions:
@@ -306,11 +306,11 @@ STAGE PLANS:
TableScan
alias: a
filterExpr:
- expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90))
+ expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0))
type: boolean
Filter Operator
predicate:
- expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90))
+ expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -330,11 +330,11 @@ STAGE PLANS:
TableScan
alias: b
filterExpr:
- expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100))
+ expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0))
type: boolean
Filter Operator
predicate:
- expr: ((((key > 70) and (key < 90)) and (key > 80)) and (key < 100))
+ expr: ((((key > 70.0) and (key < 90.0)) and (key > 80.0)) and (key < 100.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -413,11 +413,11 @@ STAGE PLANS:
TableScan
alias: default__src_src_index__
filterExpr:
- expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90))
+ expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0))
type: boolean
Filter Operator
predicate:
- expr: ((((key > 80) and (key < 100)) and (key > 70)) and (key < 90))
+ expr: ((((key > 80.0) and (key < 100.0)) and (key > 70.0)) and (key < 90.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_multiple.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_multiple.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_multiple.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_multiple.q.out Tue Jan 31 06:39:43 2012
@@ -67,11 +67,11 @@ STAGE PLANS:
TableScan
alias: default__src_src_key_index__
filterExpr:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
@@ -109,11 +109,11 @@ STAGE PLANS:
TableScan
alias: src
filterExpr:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_partitioned.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_partitioned.q.out Tue Jan 31 06:39:43 2012
@@ -55,11 +55,11 @@ STAGE PLANS:
TableScan
alias: default__srcpart_src_part_index__
filterExpr:
- expr: ((key = 86) and (ds = '2008-04-09'))
+ expr: ((key = 86.0) and (ds = '2008-04-09'))
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
@@ -97,11 +97,11 @@ STAGE PLANS:
TableScan
alias: srcpart
filterExpr:
- expr: ((key = 86) and (ds = '2008-04-09'))
+ expr: ((key = 86.0) and (ds = '2008-04-09'))
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out Tue Jan 31 06:39:43 2012
@@ -23,7 +23,7 @@ STAGE PLANS:
alias: a
Filter Operator
predicate:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -42,7 +42,7 @@ STAGE PLANS:
alias: b
Filter Operator
predicate:
- expr: ((key > 70) and (key < 90))
+ expr: ((key > 70.0) and (key < 90.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -173,11 +173,11 @@ STAGE PLANS:
TableScan
alias: default__src_src_index__
filterExpr:
- expr: (((key > 70) and (key < 90)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
+ expr: (((key > 70.0) and (key < 90.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
type: boolean
Filter Operator
predicate:
- expr: (((key > 70) and (key < 90)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
+ expr: (((key > 70.0) and (key < 90.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
type: boolean
Select Operator
expressions:
@@ -260,11 +260,11 @@ STAGE PLANS:
TableScan
alias: a
filterExpr:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Filter Operator
predicate:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -282,11 +282,11 @@ STAGE PLANS:
TableScan
alias: b
filterExpr:
- expr: ((key > 70) and (key < 90))
+ expr: ((key > 70.0) and (key < 90.0))
type: boolean
Filter Operator
predicate:
- expr: ((key > 70) and (key < 90))
+ expr: ((key > 70.0) and (key < 90.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -354,11 +354,11 @@ STAGE PLANS:
TableScan
alias: default__src_src_index__
filterExpr:
- expr: (((key > 80) and (key < 100)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
+ expr: (((key > 80.0) and (key < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
type: boolean
Filter Operator
predicate:
- expr: (((key > 80) and (key < 100)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
+ expr: (((key > 80.0) and (key < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_unused.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_unused.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_unused.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_unused.q.out Tue Jan 31 06:39:43 2012
@@ -42,11 +42,11 @@ STAGE PLANS:
TableScan
alias: src
filterExpr:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Filter Operator
predicate:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Select Operator
expressions:
@@ -134,11 +134,11 @@ STAGE PLANS:
TableScan
alias: src
filterExpr:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Filter Operator
predicate:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Select Operator
expressions:
@@ -226,11 +226,11 @@ STAGE PLANS:
TableScan
alias: src
filterExpr:
- expr: ((key < 10) or (key > 480))
+ expr: ((key < 10.0) or (key > 480.0))
type: boolean
Filter Operator
predicate:
- expr: ((key < 10) or (key > 480))
+ expr: ((key < 10.0) or (key > 480.0))
type: boolean
Select Operator
expressions:
@@ -363,11 +363,11 @@ STAGE PLANS:
TableScan
alias: src
filterExpr:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Filter Operator
predicate:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Select Operator
expressions:
@@ -502,11 +502,11 @@ STAGE PLANS:
TableScan
alias: srcpart
filterExpr:
- expr: (((ds = '2008-04-09') and (hr = 12)) and (key < 10))
+ expr: (((ds = '2008-04-09') and (hr = 12.0)) and (key < 10.0))
type: boolean
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 10.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_update.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_update.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_update.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_update.q.out Tue Jan 31 06:39:43 2012
@@ -268,11 +268,11 @@ STAGE PLANS:
TableScan
alias: default__temp_temp_index__
filterExpr:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
@@ -310,11 +310,11 @@ STAGE PLANS:
TableScan
alias: temp
filterExpr:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_bitmap3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_bitmap3.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_bitmap3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_bitmap3.q.out Tue Jan 31 06:39:43 2012
@@ -149,7 +149,7 @@ STAGE PLANS:
alias: default__src_src1_index__
Filter Operator
predicate:
- expr: (key = 0)
+ expr: (key = 0.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto.q.out Tue Jan 31 06:39:43 2012
@@ -168,7 +168,7 @@ STAGE PLANS:
alias: default__src_src1_index__
Filter Operator
predicate:
- expr: (key = 0)
+ expr: (key = 0.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out Tue Jan 31 06:39:43 2012
@@ -54,11 +54,11 @@ STAGE PLANS:
TableScan
alias: default__srcpart_src_part_index__
filterExpr:
- expr: ((key = 86) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
+ expr: ((key = 86.0) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
type: boolean
Filter Operator
predicate:
- expr: ((key = 86) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
+ expr: ((key = 86.0) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
type: boolean
Select Operator
expressions:
@@ -141,11 +141,11 @@ STAGE PLANS:
TableScan
alias: srcpart
filterExpr:
- expr: ((key = 86) and (ds = '2008-04-09'))
+ expr: ((key = 86.0) and (ds = '2008-04-09'))
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_bitmap_compression.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_bitmap_compression.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_bitmap_compression.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_bitmap_compression.q.out Tue Jan 31 06:39:43 2012
@@ -42,11 +42,11 @@ STAGE PLANS:
TableScan
alias: default__src_src_index__
filterExpr:
- expr: (((key > 80) and (key < 100)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
+ expr: (((key > 80.0) and (key < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
type: boolean
Filter Operator
predicate:
- expr: (((key > 80) and (key < 100)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
+ expr: (((key > 80.0) and (key < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps)))
type: boolean
Select Operator
expressions:
@@ -129,11 +129,11 @@ STAGE PLANS:
TableScan
alias: src
filterExpr:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Filter Operator
predicate:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_compression.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_compression.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_compression.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_compression.q.out Tue Jan 31 06:39:43 2012
@@ -43,11 +43,11 @@ STAGE PLANS:
TableScan
alias: default__src_src_index__
filterExpr:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Filter Operator
predicate:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Select Operator
expressions:
@@ -85,11 +85,11 @@ STAGE PLANS:
TableScan
alias: src
filterExpr:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Filter Operator
predicate:
- expr: ((key > 80) and (key < 100))
+ expr: ((key > 80.0) and (key < 100.0))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_stale.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_stale.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_stale.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_stale.q.out Tue Jan 31 06:39:43 2012
@@ -84,11 +84,11 @@ STAGE PLANS:
TableScan
alias: temp
filterExpr:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/index_stale_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_stale_partitioned.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_stale_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_stale_partitioned.q.out Tue Jan 31 06:39:43 2012
@@ -108,11 +108,11 @@ STAGE PLANS:
TableScan
alias: temp
filterExpr:
- expr: ((key = 86) and (foo = 'bar'))
+ expr: ((key = 86.0) and (foo = 'bar'))
type: boolean
Filter Operator
predicate:
- expr: (key = 86)
+ expr: (key = 86.0)
type: boolean
Select Operator
expressions:
Added: hive/trunk/ql/src/test/results/clientpositive/infer_const_type.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/infer_const_type.q.out?rev=1238175&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/infer_const_type.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/infer_const_type.q.out Tue Jan 31 06:39:43 2012
@@ -0,0 +1,356 @@
+PREHOOK: query: DROP TABLE infertypes
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE infertypes
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE infertypes(ti TINYINT, si SMALLINT, i INT, bi BIGINT, fl FLOAT, db DOUBLE, str STRING)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE infertypes(ti TINYINT, si SMALLINT, i INT, bi BIGINT, fl FLOAT, db DOUBLE, str STRING)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@infertypes
+PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/infer_const_type.txt' OVERWRITE INTO TABLE infertypes
+PREHOOK: type: LOAD
+PREHOOK: Output: default@infertypes
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/infer_const_type.txt' OVERWRITE INTO TABLE infertypes
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@infertypes
+PREHOOK: query: SELECT * FROM infertypes
+PREHOOK: type: QUERY
+PREHOOK: Input: default@infertypes
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM infertypes
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@infertypes
+#### A masked pattern was here ####
+127 32767 12345 -12345 906.0 -307.0 1234
+126 32767 12345 -12345 906.0 -307.0 1234
+126 32767 12345 -12345 906.0 -307.0 1.57
+PREHOOK: query: EXPLAIN SELECT * FROM infertypes WHERE
+ ti = '127' AND
+ si = 32767 AND
+ i = '12345' AND
+ bi = '-12345' AND
+ fl = '0906' AND
+ db = '-307' AND
+ str = 1234
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT * FROM infertypes WHERE
+ ti = '127' AND
+ si = 32767 AND
+ i = '12345' AND
+ bi = '-12345' AND
+ fl = '0906' AND
+ db = '-307' AND
+ str = 1234
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME infertypes))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (AND (AND (AND (AND (AND (AND (= (TOK_TABLE_OR_COL ti) '127') (= (TOK_TABLE_OR_COL si) 32767)) (= (TOK_TABLE_OR_COL i) '12345')) (= (TOK_TABLE_OR_COL bi) '-12345')) (= (TOK_TABLE_OR_COL fl) '0906')) (= (TOK_TABLE_OR_COL db) '-307')) (= (TOK_TABLE_OR_COL str) 1234)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ infertypes
+ TableScan
+ alias: infertypes
+ Filter Operator
+ predicate:
+ expr: (((((((ti = 127) and (si = 32767)) and (i = 12345)) and (bi = -12345)) and (fl = 906.0)) and (db = -307.0)) and (str = 1234.0))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: ti
+ type: tinyint
+ expr: si
+ type: smallint
+ expr: i
+ type: int
+ expr: bi
+ type: bigint
+ expr: fl
+ type: float
+ expr: db
+ type: double
+ expr: str
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT * FROM infertypes WHERE
+ ti = '127' AND
+ si = 32767 AND
+ i = '12345' AND
+ bi = '-12345' AND
+ fl = '0906' AND
+ db = '-307' AND
+ str = 1234
+PREHOOK: type: QUERY
+PREHOOK: Input: default@infertypes
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM infertypes WHERE
+ ti = '127' AND
+ si = 32767 AND
+ i = '12345' AND
+ bi = '-12345' AND
+ fl = '0906' AND
+ db = '-307' AND
+ str = 1234
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@infertypes
+#### A masked pattern was here ####
+127 32767 12345 -12345 906.0 -307.0 1234
+PREHOOK: query: -- all should return false as all numbers exceeed the largest number
+-- which could be represented by the corresponding type
+-- and string_col = long_const should return false
+EXPLAIN SELECT * FROM infertypes WHERE
+ ti = '128' OR
+ si = 32768 OR
+ i = '2147483648' OR
+ bi = '9223372036854775808' OR
+ fl = 'float' OR
+ db = 'double'
+PREHOOK: type: QUERY
+POSTHOOK: query: -- all should return false as all numbers exceeed the largest number
+-- which could be represented by the corresponding type
+-- and string_col = long_const should return false
+EXPLAIN SELECT * FROM infertypes WHERE
+ ti = '128' OR
+ si = 32768 OR
+ i = '2147483648' OR
+ bi = '9223372036854775808' OR
+ fl = 'float' OR
+ db = 'double'
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME infertypes))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (OR (OR (OR (OR (OR (= (TOK_TABLE_OR_COL ti) '128') (= (TOK_TABLE_OR_COL si) 32768)) (= (TOK_TABLE_OR_COL i) '2147483648')) (= (TOK_TABLE_OR_COL bi) '9223372036854775808')) (= (TOK_TABLE_OR_COL fl) 'float')) (= (TOK_TABLE_OR_COL db) 'double')))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ infertypes
+ TableScan
+ alias: infertypes
+ Filter Operator
+ predicate:
+ expr: (((((false or false) or false) or false) or false) or false)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: ti
+ type: tinyint
+ expr: si
+ type: smallint
+ expr: i
+ type: int
+ expr: bi
+ type: bigint
+ expr: fl
+ type: float
+ expr: db
+ type: double
+ expr: str
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT * FROM infertypes WHERE
+ ti = '128' OR
+ si = 32768 OR
+ i = '2147483648' OR
+ bi = '9223372036854775808' OR
+ fl = 'float' OR
+ db = 'double'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@infertypes
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM infertypes WHERE
+ ti = '128' OR
+ si = 32768 OR
+ i = '2147483648' OR
+ bi = '9223372036854775808' OR
+ fl = 'float' OR
+ db = 'double'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@infertypes
+#### A masked pattern was here ####
+PREHOOK: query: -- for the query like: int_col = double, should return false
+EXPLAIN SELECT * FROM infertypes WHERE
+ ti = '127.0' OR
+ si = 327.0 OR
+ i = '-100.0'
+PREHOOK: type: QUERY
+POSTHOOK: query: -- for the query like: int_col = double, should return false
+EXPLAIN SELECT * FROM infertypes WHERE
+ ti = '127.0' OR
+ si = 327.0 OR
+ i = '-100.0'
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME infertypes))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (OR (OR (= (TOK_TABLE_OR_COL ti) '127.0') (= (TOK_TABLE_OR_COL si) 327.0)) (= (TOK_TABLE_OR_COL i) '-100.0')))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ infertypes
+ TableScan
+ alias: infertypes
+ Filter Operator
+ predicate:
+ expr: ((false or false) or false)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: ti
+ type: tinyint
+ expr: si
+ type: smallint
+ expr: i
+ type: int
+ expr: bi
+ type: bigint
+ expr: fl
+ type: float
+ expr: db
+ type: double
+ expr: str
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT * FROM infertypes WHERE
+ ti = '127.0' OR
+ si = 327.0 OR
+ i = '-100.0'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@infertypes
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM infertypes WHERE
+ ti = '127.0' OR
+ si = 327.0 OR
+ i = '-100.0'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@infertypes
+#### A masked pattern was here ####
+PREHOOK: query: EXPLAIN SELECT * FROM infertypes WHERE
+ ti < '127.0' AND
+ i > '100.0' AND
+ str = 1.57
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT * FROM infertypes WHERE
+ ti < '127.0' AND
+ i > '100.0' AND
+ str = 1.57
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME infertypes))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (AND (AND (< (TOK_TABLE_OR_COL ti) '127.0') (> (TOK_TABLE_OR_COL i) '100.0')) (= (TOK_TABLE_OR_COL str) 1.57)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ infertypes
+ TableScan
+ alias: infertypes
+ Filter Operator
+ predicate:
+ expr: (((ti < 127.0) and (i > 100.0)) and (str = 1.57))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: ti
+ type: tinyint
+ expr: si
+ type: smallint
+ expr: i
+ type: int
+ expr: bi
+ type: bigint
+ expr: fl
+ type: float
+ expr: db
+ type: double
+ expr: str
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT * FROM infertypes WHERE
+ ti < '127.0' AND
+ i > '100.0' AND
+ str = 1.57
+PREHOOK: type: QUERY
+PREHOOK: Input: default@infertypes
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM infertypes WHERE
+ ti < '127.0' AND
+ i > '100.0' AND
+ str = 1.57
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@infertypes
+#### A masked pattern was here ####
+126 32767 12345 -12345 906.0 -307.0 1.57
+PREHOOK: query: DROP TABLE infertypes
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@infertypes
+PREHOOK: Output: default@infertypes
+POSTHOOK: query: DROP TABLE infertypes
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@infertypes
+POSTHOOK: Output: default@infertypes
Modified: hive/trunk/ql/src/test/results/clientpositive/input11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input11.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input11.q.out Tue Jan 31 06:39:43 2012
@@ -31,7 +31,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/input11_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input11_limit.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/input12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input12.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input12.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input12.q.out Tue Jan 31 06:39:43 2012
@@ -55,7 +55,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 100)
+ expr: (key < 100.0)
type: boolean
Select Operator
expressions:
@@ -81,7 +81,7 @@ STAGE PLANS:
name: default.dest1
Filter Operator
predicate:
- expr: ((key >= 100) and (key < 200))
+ expr: ((key >= 100.0) and (key < 200.0))
type: boolean
Select Operator
expressions:
@@ -107,7 +107,7 @@ STAGE PLANS:
name: default.dest2
Filter Operator
predicate:
- expr: (key >= 200)
+ expr: (key >= 200.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/input13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input13.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input13.q.out Tue Jan 31 06:39:43 2012
@@ -61,7 +61,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (key < 100)
+ expr: (key < 100.0)
type: boolean
Select Operator
expressions:
@@ -87,7 +87,7 @@ STAGE PLANS:
name: default.dest1
Filter Operator
predicate:
- expr: ((key >= 100) and (key < 200))
+ expr: ((key >= 100.0) and (key < 200.0))
type: boolean
Select Operator
expressions:
@@ -113,7 +113,7 @@ STAGE PLANS:
name: default.dest2
Filter Operator
predicate:
- expr: ((key >= 200) and (key < 300))
+ expr: ((key >= 200.0) and (key < 300.0))
type: boolean
Select Operator
expressions:
@@ -135,7 +135,7 @@ STAGE PLANS:
name: default.dest3
Filter Operator
predicate:
- expr: (key >= 300)
+ expr: (key >= 300.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/input14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input14.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input14.q.out Tue Jan 31 06:39:43 2012
@@ -50,7 +50,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Filter Operator
predicate:
- expr: (_col0 < 100)
+ expr: (_col0 < 100.0)
type: boolean
Reduce Output Operator
key expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out Tue Jan 31 06:39:43 2012
@@ -96,7 +96,7 @@ STAGE PLANS:
Limit
Filter Operator
predicate:
- expr: (_col0 < 100)
+ expr: (_col0 < 100.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/input18.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input18.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input18.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input18.q.out Tue Jan 31 06:39:43 2012
@@ -54,7 +54,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Filter Operator
predicate:
- expr: (_col0 < 100)
+ expr: (_col0 < 100.0)
type: boolean
Reduce Output Operator
key expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input1_limit.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:
@@ -58,7 +58,7 @@ STAGE PLANS:
type: string
Filter Operator
predicate:
- expr: (key < 100)
+ expr: (key < 100.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out Tue Jan 31 06:39:43 2012
@@ -20,7 +20,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key < 300)
+ expr: (key < 300.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/input42.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input42.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input42.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input42.q.out Tue Jan 31 06:39:43 2012
@@ -1184,7 +1184,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (key < 200)
+ expr: (key < 200.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out Tue Jan 31 06:39:43 2012
@@ -33,7 +33,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/input_part2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out Tue Jan 31 06:39:43 2012
@@ -45,7 +45,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((key < 100) and (ds = '2008-04-08'))
+ expr: ((key < 100.0) and (ds = '2008-04-08'))
type: boolean
Select Operator
expressions:
@@ -96,7 +96,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((key < 100) and (ds = '2008-04-09'))
+ expr: ((key < 100.0) and (ds = '2008-04-09'))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out Tue Jan 31 06:39:43 2012
@@ -31,7 +31,7 @@ STAGE PLANS:
alias: x
Filter Operator
predicate:
- expr: (key < 100)
+ expr: (key < 100.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out Tue Jan 31 06:39:43 2012
@@ -32,7 +32,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (key < 100)
+ expr: (key < 100.0)
type: boolean
Select Operator
expressions:
@@ -85,7 +85,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (key < 100)
+ expr: (key < 100.0)
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/insert1_overwrite_partitions.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert1_overwrite_partitions.q.out?rev=1238175&r1=1238174&r2=1238175&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert1_overwrite_partitions.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/insert1_overwrite_partitions.q.out Tue Jan 31 06:39:43 2012
@@ -23,13 +23,13 @@ POSTHOOK: query: CREATE TABLE destinTabl
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@destinTable
PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE destinTable PARTITION (ds='2011-11-11', hr='11') if not exists
-SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one limit 5
+SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one desc, two desc limit 5
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE destinTable PARTITION (ds='2011-11-11', hr='11') if not exists
-SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one limit 5
+SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one desc, two desc limit 5
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME destinTable) (TOK_PARTSPEC (TOK_PARTVAL ds '2011-11-11') (TOK_PARTVAL hr '11'))) TOK_IFNOTEXISTS) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (AND (= (TOK_TABLE_OR_COL ds) '2011-11-11') (= (TOK_TABLE_OR_COL hr) '11'))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL one))) (TOK_LIMIT 5)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME destinTable) (TOK_PARTSPEC (TOK_PARTVAL ds '2011-11-11') (TOK_PARTVAL hr '11'))) TOK_IFNOTEXISTS) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (AND (= (TOK_TABLE_OR_COL ds) '2011-11-11') (= (TOK_TABLE_OR_COL hr) '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
@@ -55,7 +55,9 @@ STAGE PLANS:
key expressions:
expr: _col0
type: string
- sort order: +
+ expr: _col1
+ type: string
+ sort order: --
tag: -1
value expressions:
expr: _col0
@@ -80,7 +82,9 @@ STAGE PLANS:
key expressions:
expr: _col0
type: string
- sort order: +
+ expr: _col1
+ type: string
+ sort order: --
tag: -1
value expressions:
expr: _col0
@@ -117,70 +121,70 @@ STAGE PLANS:
PREHOOK: query: INSERT OVERWRITE TABLE destinTable PARTITION (ds='2011-11-11', hr='11') if not exists
-SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one limit 5
+SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one desc, two desc limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@sourcetable@ds=2011-11-11/hr=11
PREHOOK: Output: default@destintable@ds=2011-11-11/hr=11
POSTHOOK: query: INSERT OVERWRITE TABLE destinTable PARTITION (ds='2011-11-11', hr='11') if not exists
-SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one limit 5
+SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one desc, two desc limit 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@sourcetable@ds=2011-11-11/hr=11
POSTHOOK: Output: default@destintable@ds=2011-11-11/hr=11
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).one SIMPLE [(sourcetable)sourcetable.FieldSchema(name:one, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).two SIMPLE [(sourcetable)sourcetable.FieldSchema(name:two, type:string, comment:null), ]
-PREHOOK: query: select one,two from destinTable
+PREHOOK: query: select one,two from destinTable order by one desc, two desc
PREHOOK: type: QUERY
PREHOOK: Input: default@destintable@ds=2011-11-11/hr=11
#### A masked pattern was here ####
-POSTHOOK: query: select one,two from destinTable
+POSTHOOK: query: select one,two from destinTable order by one desc, two desc
POSTHOOK: type: QUERY
POSTHOOK: Input: default@destintable@ds=2011-11-11/hr=11
#### A masked pattern was here ####
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).one SIMPLE [(sourcetable)sourcetable.FieldSchema(name:one, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).two SIMPLE [(sourcetable)sourcetable.FieldSchema(name:two, type:string, comment:null), ]
-0 val_0
-0 val_0
-0 val_0
-10 val_10
-100 val_100
+98 val_98
+98 val_98
+97 val_97
+97 val_97
+96 val_96
PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE destinTable PARTITION (ds='2011-11-11', hr='11') if not exists
-SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='12' order by one limit 5
+SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='12' order by one desc, two desc limit 5
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE destinTable PARTITION (ds='2011-11-11', hr='11') if not exists
-SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='12' order by one limit 5
+SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='12' order by one desc, two desc limit 5
POSTHOOK: type: QUERY
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).one SIMPLE [(sourcetable)sourcetable.FieldSchema(name:one, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).two SIMPLE [(sourcetable)sourcetable.FieldSchema(name:two, type:string, comment:null), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME destinTable) (TOK_PARTSPEC (TOK_PARTVAL ds '2011-11-11') (TOK_PARTVAL hr '11'))) TOK_IFNOTEXISTS) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (AND (= (TOK_TABLE_OR_COL ds) '2011-11-11') (= (TOK_TABLE_OR_COL hr) '12'))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL one))) (TOK_LIMIT 5)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME destinTable) (TOK_PARTSPEC (TOK_PARTVAL ds '2011-11-11') (TOK_PARTVAL hr '11'))) TOK_IFNOTEXISTS) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (AND (= (TOK_TABLE_OR_COL ds) '2011-11-11') (= (TOK_TABLE_OR_COL hr) '12'))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL one)) (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL two))) (TOK_LIMIT 5)))
STAGE DEPENDENCIES:
STAGE PLANS:
STAGE PLANS:
PREHOOK: query: INSERT OVERWRITE TABLE destinTable PARTITION (ds='2011-11-11', hr='11') if not exists
-SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='12' order by one limit 5
+SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='12' order by one desc, two desc limit 5
PREHOOK: type: QUERY
POSTHOOK: query: INSERT OVERWRITE TABLE destinTable PARTITION (ds='2011-11-11', hr='11') if not exists
-SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='12' order by one limit 5
+SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='12' order by one desc, two desc limit 5
POSTHOOK: type: QUERY
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).one SIMPLE [(sourcetable)sourcetable.FieldSchema(name:one, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).two SIMPLE [(sourcetable)sourcetable.FieldSchema(name:two, type:string, comment:null), ]
-PREHOOK: query: select one,two from destinTable
+PREHOOK: query: select one,two from destinTable order by one desc, two desc
PREHOOK: type: QUERY
PREHOOK: Input: default@destintable@ds=2011-11-11/hr=11
#### A masked pattern was here ####
-POSTHOOK: query: select one,two from destinTable
+POSTHOOK: query: select one,two from destinTable order by one desc, two desc
POSTHOOK: type: QUERY
POSTHOOK: Input: default@destintable@ds=2011-11-11/hr=11
#### A masked pattern was here ####
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).one SIMPLE [(sourcetable)sourcetable.FieldSchema(name:one, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).two SIMPLE [(sourcetable)sourcetable.FieldSchema(name:two, type:string, comment:null), ]
-0 val_0
-0 val_0
-0 val_0
-10 val_10
-100 val_100
+98 val_98
+98 val_98
+97 val_97
+97 val_97
+96 val_96
PREHOOK: query: drop table destinTable
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@destintable
@@ -198,14 +202,14 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@destinTable
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).one SIMPLE [(sourcetable)sourcetable.FieldSchema(name:one, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).two SIMPLE [(sourcetable)sourcetable.FieldSchema(name:two, type:string, comment:null), ]
-PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE destinTable SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one limit 5
+PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE destinTable SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one desc, two desc limit 5
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE destinTable SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one limit 5
+POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE destinTable SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one desc, two desc limit 5
POSTHOOK: type: QUERY
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).one SIMPLE [(sourcetable)sourcetable.FieldSchema(name:one, type:string, comment:null), ]
POSTHOOK: Lineage: destintable PARTITION(ds=2011-11-11,hr=11).two SIMPLE [(sourcetable)sourcetable.FieldSchema(name:two, type:string, comment:null), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME destinTable))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (AND (= (TOK_TABLE_OR_COL ds) '2011-11-11') (= (TOK_TABLE_OR_COL hr) '11'))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL one))) (TOK_LIMIT 5)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME sourceTable))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME destinTable))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL one)) (TOK_SELEXPR (TOK_TABLE_OR_COL two))) (TOK_WHERE (AND (= (TOK_TABLE_OR_COL ds) '2011-11-11') (= (TOK_TABLE_OR_COL hr) '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
@@ -231,7 +235,9 @@ STAGE PLANS:
key expressions:
expr: _col0
type: string
- sort order: +
+ expr: _col1
+ type: string
+ sort order: --
tag: -1
value expressions:
expr: _col0
@@ -256,7 +262,9 @@ STAGE PLANS:
key expressions:
expr: _col0
type: string
- sort order: +
+ expr: _col1
+ type: string
+ sort order: --
tag: -1
value expressions:
expr: _col0
@@ -289,11 +297,11 @@ STAGE PLANS:
Stats-Aggr Operator
-PREHOOK: query: INSERT OVERWRITE TABLE destinTable SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one limit 5
+PREHOOK: query: INSERT OVERWRITE TABLE destinTable SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one desc, two desc limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@sourcetable@ds=2011-11-11/hr=11
PREHOOK: Output: default@destintable
-POSTHOOK: query: INSERT OVERWRITE TABLE destinTable SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one limit 5
+POSTHOOK: query: INSERT OVERWRITE TABLE destinTable SELECT one,two FROM sourceTable WHERE ds='2011-11-11' AND hr='11' order by one desc, two desc limit 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@sourcetable@ds=2011-11-11/hr=11
POSTHOOK: Output: default@destintable