hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sd...@apache.org
Subject 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/
Date Tue, 31 Jan 2012 06:39:47 GMT
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



Mime
View raw message