hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ser...@apache.org
Subject svn commit: r1669718 [16/29] - in /hive/branches/llap: ./ ant/src/org/apache/hadoop/hive/ant/ common/src/java/org/apache/hadoop/hive/common/ common/src/java/org/apache/hadoop/hive/common/type/ common/src/java/org/apache/hadoop/hive/conf/ common/src/jav...
Date Sat, 28 Mar 2015 00:22:27 GMT
Added: hive/branches/llap/ql/src/test/queries/clientpositive/interval_3.q
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/queries/clientpositive/interval_3.q?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/queries/clientpositive/interval_3.q (added)
+++ hive/branches/llap/ql/src/test/queries/clientpositive/interval_3.q Sat Mar 28 00:22:15 2015
@@ -0,0 +1,38 @@
+-- where clause
+select
+  l_orderkey, l_shipdate, l_receiptdate
+from lineitem
+  where (cast(l_shipdate as date) - date '1992-01-01') < interval '365 0:0:0' day to second
+order by l_orderkey;
+
+select
+  l_orderkey, l_shipdate, l_receiptdate
+from lineitem
+  where (cast(l_shipdate as date) + interval '1-0' year to month) <= date '1994-01-01'
+order by l_orderkey;
+
+select
+  l_orderkey, l_shipdate, l_receiptdate
+from lineitem
+  where (cast(l_shipdate as date) + interval '1-0' year to month) <= date '1994-01-01'
+    and (cast(l_receiptdate as date) - cast(l_shipdate as date)) < interval '10' day
+order by l_orderkey;
+
+
+-- joins
+select
+  a.l_orderkey, b.l_orderkey, a.interval1
+from
+  (
+    select
+      l_orderkey, l_shipdate, l_receiptdate, (cast(l_receiptdate as date) - cast(l_shipdate as date)) as interval1
+    from lineitem
+  ) a 
+  join
+  (
+    select
+      l_orderkey, l_shipdate, l_receiptdate, (cast(l_receiptdate as date) - date '1992-07-02') as interval2
+    from lineitem
+  ) b
+  on a.interval1 = b.interval2 and a.l_orderkey = b.l_orderkey
+order by a.l_orderkey;

Added: hive/branches/llap/ql/src/test/queries/clientpositive/interval_arithmetic.q
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/queries/clientpositive/interval_arithmetic.q?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/queries/clientpositive/interval_arithmetic.q (added)
+++ hive/branches/llap/ql/src/test/queries/clientpositive/interval_arithmetic.q Sat Mar 28 00:22:15 2015
@@ -0,0 +1,162 @@
+create table interval_arithmetic_1 (dateval date, tsval timestamp);
+insert overwrite table interval_arithmetic_1
+  select cast(ctimestamp1 as date), ctimestamp1 from alltypesorc;
+
+-- interval year-month arithmetic
+explain
+select
+  dateval,
+  dateval - interval '2-2' year to month,
+  dateval - interval '-2-2' year to month,
+  dateval + interval '2-2' year to month,
+  dateval + interval '-2-2' year to month,
+  - interval '2-2' year to month + dateval,
+  interval '2-2' year to month + dateval
+from interval_arithmetic_1
+limit 2;
+
+select
+  dateval,
+  dateval - interval '2-2' year to month,
+  dateval - interval '-2-2' year to month,
+  dateval + interval '2-2' year to month,
+  dateval + interval '-2-2' year to month,
+  - interval '2-2' year to month + dateval,
+  interval '2-2' year to month + dateval
+from interval_arithmetic_1
+limit 2;
+
+explain
+select
+  dateval,
+  dateval - date '1999-06-07',
+  date '1999-06-07' - dateval,
+  dateval - dateval
+from interval_arithmetic_1
+limit 2;
+
+select
+  dateval,
+  dateval - date '1999-06-07',
+  date '1999-06-07' - dateval,
+  dateval - dateval
+from interval_arithmetic_1
+limit 2;
+
+explain
+select
+  tsval,
+  tsval - interval '2-2' year to month,
+  tsval - interval '-2-2' year to month,
+  tsval + interval '2-2' year to month,
+  tsval + interval '-2-2' year to month,
+  - interval '2-2' year to month + tsval,
+  interval '2-2' year to month + tsval
+from interval_arithmetic_1
+limit 2;
+
+select
+  tsval,
+  tsval - interval '2-2' year to month,
+  tsval - interval '-2-2' year to month,
+  tsval + interval '2-2' year to month,
+  tsval + interval '-2-2' year to month,
+  - interval '2-2' year to month + tsval,
+  interval '2-2' year to month + tsval
+from interval_arithmetic_1
+limit 2;
+
+explain
+select
+  interval '2-2' year to month + interval '3-3' year to month,
+  interval '2-2' year to month - interval '3-3' year to month
+from interval_arithmetic_1
+limit 2;
+
+select
+  interval '2-2' year to month + interval '3-3' year to month,
+  interval '2-2' year to month - interval '3-3' year to month
+from interval_arithmetic_1
+limit 2;
+
+
+-- interval day-time arithmetic
+explain
+select
+  dateval,
+  dateval - interval '99 11:22:33.123456789' day to second,
+  dateval - interval '-99 11:22:33.123456789' day to second,
+  dateval + interval '99 11:22:33.123456789' day to second,
+  dateval + interval '-99 11:22:33.123456789' day to second,
+  -interval '99 11:22:33.123456789' day to second + dateval,
+  interval '99 11:22:33.123456789' day to second + dateval
+from interval_arithmetic_1
+limit 2;
+
+select
+  dateval,
+  dateval - interval '99 11:22:33.123456789' day to second,
+  dateval - interval '-99 11:22:33.123456789' day to second,
+  dateval + interval '99 11:22:33.123456789' day to second,
+  dateval + interval '-99 11:22:33.123456789' day to second,
+  -interval '99 11:22:33.123456789' day to second + dateval,
+  interval '99 11:22:33.123456789' day to second + dateval
+from interval_arithmetic_1
+limit 2;
+
+explain
+select
+  dateval,
+  tsval,
+  dateval - tsval,
+  tsval - dateval,
+  tsval - tsval
+from interval_arithmetic_1
+limit 2;
+
+select
+  dateval,
+  tsval,
+  dateval - tsval,
+  tsval - dateval,
+  tsval - tsval
+from interval_arithmetic_1
+limit 2;
+
+explain
+select
+  tsval,
+  tsval - interval '99 11:22:33.123456789' day to second,
+  tsval - interval '-99 11:22:33.123456789' day to second,
+  tsval + interval '99 11:22:33.123456789' day to second,
+  tsval + interval '-99 11:22:33.123456789' day to second,
+  -interval '99 11:22:33.123456789' day to second + tsval,
+  interval '99 11:22:33.123456789' day to second + tsval
+from interval_arithmetic_1
+limit 2;
+
+select
+  tsval,
+  tsval - interval '99 11:22:33.123456789' day to second,
+  tsval - interval '-99 11:22:33.123456789' day to second,
+  tsval + interval '99 11:22:33.123456789' day to second,
+  tsval + interval '-99 11:22:33.123456789' day to second,
+  -interval '99 11:22:33.123456789' day to second + tsval,
+  interval '99 11:22:33.123456789' day to second + tsval
+from interval_arithmetic_1
+limit 2;
+
+explain
+select
+  interval '99 11:22:33.123456789' day to second + interval '10 9:8:7.123456789' day to second,
+  interval '99 11:22:33.123456789' day to second - interval '10 9:8:7.123456789' day to second
+from interval_arithmetic_1
+limit 2;
+
+select
+  interval '99 11:22:33.123456789' day to second + interval '10 9:8:7.123456789' day to second,
+  interval '99 11:22:33.123456789' day to second - interval '10 9:8:7.123456789' day to second
+from interval_arithmetic_1
+limit 2;
+
+drop table interval_arithmetic_1;

Added: hive/branches/llap/ql/src/test/queries/clientpositive/interval_comparison.q
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/queries/clientpositive/interval_comparison.q?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/queries/clientpositive/interval_comparison.q (added)
+++ hive/branches/llap/ql/src/test/queries/clientpositive/interval_comparison.q Sat Mar 28 00:22:15 2015
@@ -0,0 +1,85 @@
+
+-- should all be true
+select
+  i1 = i1,
+  i1 = i2,
+  i1 >= i2,
+  i1 <= i2,
+  i3 = i3,
+  i3 = i4,
+  i3 <= i4,
+  i3 >= i4,
+  i1 < i3,
+  i3 > i1,
+  i1 != i3
+from (
+  select
+    interval '2-0' year to month as i1,
+    interval '2' year as i2,
+    interval '2-1' year to month as i3,
+    interval '25' month as i4
+  from src limit 1
+) q1;
+
+-- should all be false
+select
+  i1 != i1,
+  i1 != i2,
+  i1 < i2,
+  i1 > i2,
+  i1 = i3,
+  i1 > i3,
+  i1 >= i3,
+  i3 < i1,
+  i3 <= i1
+from (
+  select
+    interval '2-0' year to month as i1,
+    interval '2' year as i2,
+    interval '2-1' year to month as i3,
+    interval '25' month as i4
+  from src limit 1
+) q1;
+
+-- should all be true
+select
+  i1 = i1,
+  i1 = i2,
+  i1 >= i2,
+  i1 <= i2,
+  i3 = i3,
+  i3 = i4,
+  i3 <= i4,
+  i3 >= i4,
+  i1 < i3,
+  i3 > i1,
+  i1 != i3
+from (
+  select
+    interval '1 0:0:0' day to second as i1,
+    interval '24' hour as i2,
+    interval '1 0:0:1' day to second as i3,
+    interval '86401' second as i4
+  from src limit 1
+) q1;
+
+-- should all be false
+select
+  i1 != i1,
+  i1 != i2,
+  i1 < i2,
+  i1 > i2,
+  i1 = i3,
+  i1 > i3,
+  i1 >= i3,
+  i3 < i1,
+  i3 <= i1
+from (
+  select
+    interval '1 0:0:0' day to second as i1,
+    interval '24' hour as i2,
+    interval '1 0:0:1' day to second as i3,
+    interval '86401' second as i4
+  from src limit 1
+) q1;
+

Added: hive/branches/llap/ql/src/test/queries/clientpositive/udf_bitwise_shiftleft.q
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/queries/clientpositive/udf_bitwise_shiftleft.q?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/queries/clientpositive/udf_bitwise_shiftleft.q (added)
+++ hive/branches/llap/ql/src/test/queries/clientpositive/udf_bitwise_shiftleft.q Sat Mar 28 00:22:15 2015
@@ -0,0 +1,93 @@
+DESCRIBE FUNCTION shiftleft;
+DESC FUNCTION EXTENDED shiftleft;
+
+explain select shiftleft(4, 1);
+
+select
+shiftleft(a, 0),
+shiftleft(a, 1),
+shiftleft(a, 2),
+shiftleft(a, 3),
+shiftleft(a, 4),
+shiftleft(a, 5),
+shiftleft(a, 6),
+shiftleft(a, 7),
+shiftleft(a, 8),
+shiftleft(a, 13),
+shiftleft(a, 14),
+shiftleft(a, 29),
+shiftleft(a, 30),
+shiftleft(a, 61),
+shiftleft(a, 62)
+from (
+  select cast(4 as tinyint) a
+) t;
+
+select
+shiftleft(a, 0),
+shiftleft(a, 1),
+shiftleft(a, 2),
+shiftleft(a, 3),
+shiftleft(a, 4),
+shiftleft(a, 5),
+shiftleft(a, 6),
+shiftleft(a, 7),
+shiftleft(a, 8),
+shiftleft(a, 13),
+shiftleft(a, 14),
+shiftleft(a, 29),
+shiftleft(a, 30),
+shiftleft(a, 61),
+shiftleft(a, 62)
+from (
+  select cast(4 as smallint) a
+) t;
+
+select
+shiftleft(a, 0),
+shiftleft(a, 1),
+shiftleft(a, 2),
+shiftleft(a, 3),
+shiftleft(a, 4),
+shiftleft(a, 5),
+shiftleft(a, 6),
+shiftleft(a, 7),
+shiftleft(a, 8),
+shiftleft(a, 13),
+shiftleft(a, 14),
+shiftleft(a, 29),
+shiftleft(a, 30),
+shiftleft(a, 61),
+shiftleft(a, 62)
+from (
+  select cast(4 as int) a
+) t;
+
+select
+shiftleft(a, 0),
+shiftleft(a, 1),
+shiftleft(a, 2),
+shiftleft(a, 3),
+shiftleft(a, 4),
+shiftleft(a, 5),
+shiftleft(a, 6),
+shiftleft(a, 7),
+shiftleft(a, 8),
+shiftleft(a, 13),
+shiftleft(a, 14),
+shiftleft(a, 29),
+shiftleft(a, 30),
+shiftleft(a, 61),
+shiftleft(a, 62)
+from (
+  select cast(4 as bigint) a
+) t;
+
+select
+shiftleft(4, 33),
+shiftleft(4, 65),
+shiftleft(4, 4001),
+shiftleft(16, -2),
+shiftleft(4, cast(null as int)),
+shiftleft(cast(null as int), 4),
+shiftleft(cast(null as int), cast(null as int));
\ No newline at end of file

Added: hive/branches/llap/ql/src/test/queries/clientpositive/udf_bitwise_shiftright.q
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/queries/clientpositive/udf_bitwise_shiftright.q?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/queries/clientpositive/udf_bitwise_shiftright.q (added)
+++ hive/branches/llap/ql/src/test/queries/clientpositive/udf_bitwise_shiftright.q Sat Mar 28 00:22:15 2015
@@ -0,0 +1,78 @@
+DESCRIBE FUNCTION shiftright;
+DESC FUNCTION EXTENDED shiftright;
+
+explain select shiftright(4, 1);
+
+select
+shiftright(a, 0),
+shiftright(a, 1),
+shiftright(a, 2),
+shiftright(a, 3),
+shiftright(a, 4),
+shiftright(a, 5),
+shiftright(a, 6),
+shiftright(a, 31),
+shiftright(a, 32)
+from (
+  select cast(-128 as tinyint) a
+) t;
+
+select
+shiftright(a, 0),
+shiftright(a, 1),
+shiftright(a, 2),
+shiftright(a, 8),
+shiftright(a, 9),
+shiftright(a, 10),
+shiftright(a, 11),
+shiftright(a, 12),
+shiftright(a, 13),
+shiftright(a, 14),
+shiftright(a, 31),
+shiftright(a, 32)
+from (
+  select cast(-32768 as smallint) a
+) t;
+
+select
+shiftright(a, 0),
+shiftright(a, 1),
+shiftright(a, 2),
+shiftright(a, 24),
+shiftright(a, 25),
+shiftright(a, 26),
+shiftright(a, 27),
+shiftright(a, 28),
+shiftright(a, 29),
+shiftright(a, 30),
+shiftright(a, 31),
+shiftright(a, 32)
+from (
+  select cast(-2147483648 as int) a
+) t;
+
+select
+shiftright(a, 0),
+shiftright(a, 1),
+shiftright(a, 2),
+shiftright(a, 56),
+shiftright(a, 57),
+shiftright(a, 58),
+shiftright(a, 59),
+shiftright(a, 60),
+shiftright(a, 61),
+shiftright(a, 62),
+shiftright(a, 63),
+shiftright(a, 64)
+from (
+  select cast(-9223372036854775808 as bigint) a
+) t;
+
+select
+shiftright(1024, 33),
+shiftright(1024, 65),
+shiftright(1024, 4001),
+shiftright(1024, -2),
+shiftright(1024, cast(null as int)),
+shiftright(cast(null as int), 4),
+shiftright(cast(null as int), cast(null as int));
\ No newline at end of file

Added: hive/branches/llap/ql/src/test/queries/clientpositive/udf_bitwise_shiftrightunsigned.q
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/queries/clientpositive/udf_bitwise_shiftrightunsigned.q?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/queries/clientpositive/udf_bitwise_shiftrightunsigned.q (added)
+++ hive/branches/llap/ql/src/test/queries/clientpositive/udf_bitwise_shiftrightunsigned.q Sat Mar 28 00:22:15 2015
@@ -0,0 +1,53 @@
+DESCRIBE FUNCTION shiftrightunsigned;
+DESC FUNCTION EXTENDED shiftrightunsigned;
+
+explain select shiftrightunsigned(4, 1);
+
+select
+shiftrightunsigned(a, 0),
+shiftrightunsigned(a, 1),
+shiftrightunsigned(a, 2),
+shiftrightunsigned(a, 31),
+shiftrightunsigned(a, 32)
+from (
+  select cast(-128 as tinyint) a
+) t;
+
+select
+shiftrightunsigned(a, 0),
+shiftrightunsigned(a, 1),
+shiftrightunsigned(a, 2),
+shiftrightunsigned(a, 31),
+shiftrightunsigned(a, 32)
+from (
+  select cast(-32768 as smallint) a
+) t;
+
+select
+shiftrightunsigned(a, 0),
+shiftrightunsigned(a, 1),
+shiftrightunsigned(a, 2),
+shiftrightunsigned(a, 31),
+shiftrightunsigned(a, 32)
+from (
+  select cast(-2147483648 as int) a
+) t;
+
+select
+shiftrightunsigned(a, 0),
+shiftrightunsigned(a, 1),
+shiftrightunsigned(a, 2),
+shiftrightunsigned(a, 63),
+shiftrightunsigned(a, 64)
+from (
+  select cast(-9223372036854775808 as bigint) a
+) t;
+
+select
+shiftrightunsigned(1024, 33),
+shiftrightunsigned(1024, 65),
+shiftrightunsigned(1024, 4001),
+shiftrightunsigned(1024, -2),
+shiftrightunsigned(1024, cast(null as int)),
+shiftrightunsigned(cast(null as int), 4),
+shiftrightunsigned(cast(null as int), cast(null as int));
\ No newline at end of file

Modified: hive/branches/llap/ql/src/test/queries/clientpositive/udf_get_json_object.q
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/queries/clientpositive/udf_get_json_object.q?rev=1669718&r1=1669717&r2=1669718&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/queries/clientpositive/udf_get_json_object.q (original)
+++ hive/branches/llap/ql/src/test/queries/clientpositive/udf_get_json_object.q Sat Mar 28 00:22:15 2015
@@ -42,3 +42,24 @@ INSERT OVERWRITE TABLE dest2 SELECT '{"a
 SELECT * FROM dest2;
 
 SELECT get_json_object(c1, '$.a') FROM dest2;
+
+--root is array
+SELECT
+get_json_object('[1,2,3]', '$[0]'),
+get_json_object('[1,2,3]', '$.[0]'),
+get_json_object('[1,2,3]', '$.[1]'),
+get_json_object('[1,2,3]', '$[1]'),
+get_json_object('[1,2,3]', '$[2]'),
+get_json_object('[1,2,3]', '$[*]'),
+get_json_object('[1,2,3]', '$'),
+get_json_object('[{"k1":"v1"},{"k2":"v2"},{"k3":"v3"}]', '$[2]'),
+get_json_object('[{"k1":"v1"},{"k2":"v2"},{"k3":"v3"}]', '$[2].k3'),
+get_json_object('[[1,2,3],[4,5,6],[7,8,9]]', '$[1]'),
+get_json_object('[[1,2,3],[4,5,6],[7,8,9]]', '$[1][0]'),
+get_json_object('[{"k1":[{"k11":[1,2,3]}]}]', '$[0].k1[0].k11[1]');
+
+--null
+SELECT
+get_json_object('[1,2,3]', '[2]'),
+get_json_object('[1,2,3]', '$0'),
+get_json_object('[1,2,3]', '$[3]');
\ No newline at end of file

Added: hive/branches/llap/ql/src/test/queries/clientpositive/vector_date_1.q
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/queries/clientpositive/vector_date_1.q?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/queries/clientpositive/vector_date_1.q (added)
+++ hive/branches/llap/ql/src/test/queries/clientpositive/vector_date_1.q Sat Mar 28 00:22:15 2015
@@ -0,0 +1,184 @@
+
+set hive.vectorized.execution.enabled=true;
+set hive.fetch.task.conversion=minimal;
+
+drop table if exists vector_date_1;
+create table vector_date_1 (dt1 date, dt2 date) stored as orc;
+
+insert into table vector_date_1
+  select null, null from src limit 1;
+insert into table vector_date_1
+  select date '1999-12-31', date '2000-01-01' from src limit 1;
+insert into table vector_date_1
+  select date '2001-01-01', date '2001-06-01' from src limit 1;
+
+-- column-to-column comparison in select clause
+explain
+select
+  dt1, dt2,
+  -- should be all true
+  dt1 = dt1,
+  dt1 != dt2,
+  dt1 <= dt1,
+  dt1 <= dt2,
+  dt1 < dt2,
+  dt2 >= dt2,
+  dt2 >= dt1,
+  dt2 > dt1
+from vector_date_1 order by dt1;
+
+select
+  dt1, dt2,
+  -- should be all true
+  dt1 = dt1,
+  dt1 != dt2,
+  dt1 <= dt1,
+  dt1 <= dt2,
+  dt1 < dt2,
+  dt2 >= dt2,
+  dt2 >= dt1,
+  dt2 > dt1
+from vector_date_1 order by dt1;
+
+explain
+select
+  dt1, dt2,
+  -- should be all false
+  dt1 != dt1,
+  dt1 = dt2,
+  dt1 < dt1,
+  dt1 >= dt2,
+  dt1 > dt2,
+  dt2 > dt2,
+  dt2 <= dt1,
+  dt2 < dt1
+from vector_date_1 order by dt1;
+
+select
+  dt1, dt2,
+  -- should be all false
+  dt1 != dt1,
+  dt1 = dt2,
+  dt1 < dt1,
+  dt1 >= dt2,
+  dt1 > dt2,
+  dt2 > dt2,
+  dt2 <= dt1,
+  dt2 < dt1
+from vector_date_1 order by dt1;
+
+-- column-to-literal/literal-to-column comparison in select clause
+explain
+select
+  dt1,
+  -- should be all true
+  dt1 != date '1970-01-01',
+  dt1 >= date '1970-01-01',
+  dt1 > date '1970-01-01',
+  dt1 <= date '2100-01-01',
+  dt1 < date '2100-01-01',
+  date '1970-01-01' != dt1,
+  date '1970-01-01' <= dt1,
+  date '1970-01-01' < dt1
+from vector_date_1 order by dt1;
+
+select
+  dt1,
+  -- should be all true
+  dt1 != date '1970-01-01',
+  dt1 >= date '1970-01-01',
+  dt1 > date '1970-01-01',
+  dt1 <= date '2100-01-01',
+  dt1 < date '2100-01-01',
+  date '1970-01-01' != dt1,
+  date '1970-01-01' <= dt1,
+  date '1970-01-01' < dt1
+from vector_date_1 order by dt1;
+
+explain
+select
+  dt1,
+  -- should all be false
+  dt1 = date '1970-01-01',
+  dt1 <= date '1970-01-01',
+  dt1 < date '1970-01-01',
+  dt1 >= date '2100-01-01',
+  dt1 > date '2100-01-01',
+  date '1970-01-01' = dt1,
+  date '1970-01-01' >= dt1,
+  date '1970-01-01' > dt1
+from vector_date_1 order by dt1;
+
+select
+  dt1,
+  -- should all be false
+  dt1 = date '1970-01-01',
+  dt1 <= date '1970-01-01',
+  dt1 < date '1970-01-01',
+  dt1 >= date '2100-01-01',
+  dt1 > date '2100-01-01',
+  date '1970-01-01' = dt1,
+  date '1970-01-01' >= dt1,
+  date '1970-01-01' > dt1
+from vector_date_1 order by dt1;
+
+
+-- column-to-column comparisons in predicate
+-- all rows with non-null dt1 should be returned
+explain
+select
+  dt1, dt2
+from vector_date_1
+where
+  dt1 = dt1
+  and dt1 != dt2
+  and dt1 < dt2
+  and dt1 <= dt2
+  and dt2 > dt1
+  and dt2 >= dt1
+order by dt1;
+
+select
+  dt1, dt2
+from vector_date_1
+where
+  dt1 = dt1
+  and dt1 != dt2
+  and dt1 < dt2
+  and dt1 <= dt2
+  and dt2 > dt1
+  and dt2 >= dt1
+order by dt1;
+
+-- column-to-literal/literal-to-column comparison in predicate
+-- only a single row should be returned
+explain
+select
+  dt1, dt2
+from vector_date_1
+where
+  dt1 = date '2001-01-01'
+  and date '2001-01-01' = dt1
+  and dt1 != date '1970-01-01'
+  and date '1970-01-01' != dt1
+  and dt1 > date '1970-01-01'
+  and dt1 >= date '1970-01-01'
+  and date '1970-01-01' < dt1
+  and date '1970-01-01' <= dt1
+order by dt1;
+
+select
+  dt1, dt2
+from vector_date_1
+where
+  dt1 = date '2001-01-01'
+  and date '2001-01-01' = dt1
+  and dt1 != date '1970-01-01'
+  and date '1970-01-01' != dt1
+  and dt1 > date '1970-01-01'
+  and dt1 >= date '1970-01-01'
+  and date '1970-01-01' < dt1
+  and date '1970-01-01' <= dt1
+order by dt1;
+
+drop table vector_date_1;

Added: hive/branches/llap/ql/src/test/queries/clientpositive/vector_interval_1.q
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/queries/clientpositive/vector_interval_1.q?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/queries/clientpositive/vector_interval_1.q (added)
+++ hive/branches/llap/ql/src/test/queries/clientpositive/vector_interval_1.q Sat Mar 28 00:22:15 2015
@@ -0,0 +1,196 @@
+
+set hive.vectorized.execution.enabled=true;
+set hive.fetch.task.conversion=minimal;
+
+drop table if exists vector_interval_1;
+create table vector_interval_1 (ts timestamp, dt date, str1 string, str2 string) stored as orc;
+
+insert into vector_interval_1
+  select timestamp '2001-01-01 01:02:03', date '2001-01-01', '1-2', '1 2:3:4' from src limit 1;
+insert into vector_interval_1
+  select null, null, null, null from src limit 1;
+
+-- constants/cast from string
+explain
+select
+  str1,
+  interval '1-2' year to month, interval_year_month(str1),
+  interval '1 2:3:4' day to second, interval_day_time(str2)
+from vector_interval_1 order by str1;
+
+select
+  str1,
+  interval '1-2' year to month, interval_year_month(str1),
+  interval '1 2:3:4' day to second, interval_day_time(str2)
+from vector_interval_1 order by str1;
+
+
+-- interval arithmetic
+explain
+select
+  dt,
+  interval '1-2' year to month + interval '1-2' year to month,
+  interval_year_month(str1) + interval_year_month(str1),
+  interval '1-2' year to month + interval_year_month(str1),
+  interval '1-2' year to month - interval '1-2' year to month,
+  interval_year_month(str1) - interval_year_month(str1),
+  interval '1-2' year to month - interval_year_month(str1)
+from vector_interval_1 order by dt;
+
+select
+  dt,
+  interval '1-2' year to month + interval '1-2' year to month,
+  interval_year_month(str1) + interval_year_month(str1),
+  interval '1-2' year to month + interval_year_month(str1),
+  interval '1-2' year to month - interval '1-2' year to month,
+  interval_year_month(str1) - interval_year_month(str1),
+  interval '1-2' year to month - interval_year_month(str1)
+from vector_interval_1 order by dt;
+
+explain
+select
+  dt,
+  interval '1 2:3:4' day to second + interval '1 2:3:4' day to second,
+  interval_day_time(str2) + interval_day_time(str2),
+  interval '1 2:3:4' day to second + interval_day_time(str2),
+  interval '1 2:3:4' day to second - interval '1 2:3:4' day to second,
+  interval_day_time(str2) - interval_day_time(str2),
+  interval '1 2:3:4' day to second - interval_day_time(str2)
+from vector_interval_1 order by dt;
+
+select
+  dt,
+  interval '1 2:3:4' day to second + interval '1 2:3:4' day to second,
+  interval_day_time(str2) + interval_day_time(str2),
+  interval '1 2:3:4' day to second + interval_day_time(str2),
+  interval '1 2:3:4' day to second - interval '1 2:3:4' day to second,
+  interval_day_time(str2) - interval_day_time(str2),
+  interval '1 2:3:4' day to second - interval_day_time(str2)
+from vector_interval_1 order by dt;
+
+
+-- date-interval arithmetic
+explain
+select
+  dt,
+  dt + interval '1-2' year to month,
+  dt + interval_year_month(str1),
+  interval '1-2' year to month + dt,
+  interval_year_month(str1) + dt,
+  dt - interval '1-2' year to month,
+  dt - interval_year_month(str1),
+  dt + interval '1 2:3:4' day to second,
+  dt + interval_day_time(str2),
+  interval '1 2:3:4' day to second + dt,
+  interval_day_time(str2) + dt,
+  dt - interval '1 2:3:4' day to second,
+  dt - interval_day_time(str2)
+from vector_interval_1 order by dt;
+
+select
+  dt,
+  dt + interval '1-2' year to month,
+  dt + interval_year_month(str1),
+  interval '1-2' year to month + dt,
+  interval_year_month(str1) + dt,
+  dt - interval '1-2' year to month,
+  dt - interval_year_month(str1),
+  dt + interval '1 2:3:4' day to second,
+  dt + interval_day_time(str2),
+  interval '1 2:3:4' day to second + dt,
+  interval_day_time(str2) + dt,
+  dt - interval '1 2:3:4' day to second,
+  dt - interval_day_time(str2)
+from vector_interval_1 order by dt;
+
+
+-- timestamp-interval arithmetic
+explain
+select
+  ts,
+  ts + interval '1-2' year to month,
+  ts + interval_year_month(str1),
+  interval '1-2' year to month + ts,
+  interval_year_month(str1) + ts,
+  ts - interval '1-2' year to month,
+  ts - interval_year_month(str1),
+  ts + interval '1 2:3:4' day to second,
+  ts + interval_day_time(str2),
+  interval '1 2:3:4' day to second + ts,
+  interval_day_time(str2) + ts,
+  ts - interval '1 2:3:4' day to second,
+  ts - interval_day_time(str2)
+from vector_interval_1 order by ts;
+
+select
+  ts,
+  ts + interval '1-2' year to month,
+  ts + interval_year_month(str1),
+  interval '1-2' year to month + ts,
+  interval_year_month(str1) + ts,
+  ts - interval '1-2' year to month,
+  ts - interval_year_month(str1),
+  ts + interval '1 2:3:4' day to second,
+  ts + interval_day_time(str2),
+  interval '1 2:3:4' day to second + ts,
+  interval_day_time(str2) + ts,
+  ts - interval '1 2:3:4' day to second,
+  ts - interval_day_time(str2)
+from vector_interval_1 order by ts;
+
+
+-- timestamp-timestamp arithmetic
+explain
+select
+  ts,
+  ts - ts,
+  timestamp '2001-01-01 01:02:03' - ts,
+  ts - timestamp '2001-01-01 01:02:03'
+from vector_interval_1 order by ts;
+
+select
+  ts,
+  ts - ts,
+  timestamp '2001-01-01 01:02:03' - ts,
+  ts - timestamp '2001-01-01 01:02:03'
+from vector_interval_1 order by ts;
+
+
+-- date-date arithmetic
+explain
+select
+  dt,
+  dt - dt,
+  date '2001-01-01' - dt,
+  dt - date '2001-01-01'
+from vector_interval_1 order by dt;
+
+select
+  dt,
+  dt - dt,
+  date '2001-01-01' - dt,
+  dt - date '2001-01-01'
+from vector_interval_1 order by dt;
+
+
+-- date-timestamp arithmetic
+explain
+select
+  dt,
+  ts - dt,
+  timestamp '2001-01-01 01:02:03' - dt,
+  ts - date '2001-01-01',
+  dt - ts,
+  dt - timestamp '2001-01-01 01:02:03',
+  date '2001-01-01' - ts
+from vector_interval_1 order by dt;
+
+select
+  dt,
+  ts - dt,
+  timestamp '2001-01-01 01:02:03' - dt,
+  ts - date '2001-01-01',
+  dt - ts,
+  dt - timestamp '2001-01-01 01:02:03',
+  date '2001-01-01' - ts
+from vector_interval_1 order by dt;

Added: hive/branches/llap/ql/src/test/queries/clientpositive/vector_interval_2.q
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/queries/clientpositive/vector_interval_2.q?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/queries/clientpositive/vector_interval_2.q (added)
+++ hive/branches/llap/ql/src/test/queries/clientpositive/vector_interval_2.q Sat Mar 28 00:22:15 2015
@@ -0,0 +1,530 @@
+set hive.vectorized.execution.enabled=true;
+set hive.fetch.task.conversion=minimal;
+
+drop table if exists vector_interval_2;
+create table vector_interval_2 (ts timestamp, dt date, str1 string, str2 string, str3 string, str4 string) stored as orc;
+
+insert into vector_interval_2
+  select timestamp '2001-01-01 01:02:03', date '2001-01-01', '1-2', '1-3', '1 2:3:4', '1 2:3:5' from src limit 1;
+insert into vector_interval_2
+  select null, null, null, null, null, null from src limit 1;
+
+
+-- interval comparisons in select clause
+
+explain
+select
+  str1,
+  -- Should all be true
+  interval_year_month(str1) = interval_year_month(str1),
+  interval_year_month(str1) <= interval_year_month(str1),
+  interval_year_month(str1) <= interval_year_month(str2),
+  interval_year_month(str1) < interval_year_month(str2),
+  interval_year_month(str1) >= interval_year_month(str1),
+  interval_year_month(str2) >= interval_year_month(str1),
+  interval_year_month(str2) > interval_year_month(str1),
+  interval_year_month(str1) != interval_year_month(str2),
+
+  interval_year_month(str1) = interval '1-2' year to month,
+  interval_year_month(str1) <= interval '1-2' year to month,
+  interval_year_month(str1) <= interval '1-3' year to month,
+  interval_year_month(str1) < interval '1-3' year to month,
+  interval_year_month(str1) >= interval '1-2' year to month,
+  interval_year_month(str2) >= interval '1-2' year to month,
+  interval_year_month(str2) > interval '1-2' year to month,
+  interval_year_month(str1) != interval '1-3' year to month,
+
+  interval '1-2' year to month = interval_year_month(str1),
+  interval '1-2' year to month <= interval_year_month(str1),
+  interval '1-2' year to month <= interval_year_month(str2),
+  interval '1-2' year to month < interval_year_month(str2),
+  interval '1-2' year to month >= interval_year_month(str1),
+  interval '1-3' year to month >= interval_year_month(str1),
+  interval '1-3' year to month > interval_year_month(str1),
+  interval '1-2' year to month != interval_year_month(str2)
+from vector_interval_2 order by str1;
+
+select
+  str1,
+  -- Should all be true
+  interval_year_month(str1) = interval_year_month(str1),
+  interval_year_month(str1) <= interval_year_month(str1),
+  interval_year_month(str1) <= interval_year_month(str2),
+  interval_year_month(str1) < interval_year_month(str2),
+  interval_year_month(str1) >= interval_year_month(str1),
+  interval_year_month(str2) >= interval_year_month(str1),
+  interval_year_month(str2) > interval_year_month(str1),
+  interval_year_month(str1) != interval_year_month(str2),
+
+  interval_year_month(str1) = interval '1-2' year to month,
+  interval_year_month(str1) <= interval '1-2' year to month,
+  interval_year_month(str1) <= interval '1-3' year to month,
+  interval_year_month(str1) < interval '1-3' year to month,
+  interval_year_month(str1) >= interval '1-2' year to month,
+  interval_year_month(str2) >= interval '1-2' year to month,
+  interval_year_month(str2) > interval '1-2' year to month,
+  interval_year_month(str1) != interval '1-3' year to month,
+
+  interval '1-2' year to month = interval_year_month(str1),
+  interval '1-2' year to month <= interval_year_month(str1),
+  interval '1-2' year to month <= interval_year_month(str2),
+  interval '1-2' year to month < interval_year_month(str2),
+  interval '1-2' year to month >= interval_year_month(str1),
+  interval '1-3' year to month >= interval_year_month(str1),
+  interval '1-3' year to month > interval_year_month(str1),
+  interval '1-2' year to month != interval_year_month(str2)
+from vector_interval_2 order by str1;
+
+explain
+select
+  str1,
+  -- Should all be false
+  interval_year_month(str1) != interval_year_month(str1),
+  interval_year_month(str1) >= interval_year_month(str2),
+  interval_year_month(str1) > interval_year_month(str2),
+  interval_year_month(str2) <= interval_year_month(str1),
+  interval_year_month(str2) < interval_year_month(str1),
+  interval_year_month(str1) != interval_year_month(str1),
+
+  interval_year_month(str1) != interval '1-2' year to month,
+  interval_year_month(str1) >= interval '1-3' year to month,
+  interval_year_month(str1) > interval '1-3' year to month,
+  interval_year_month(str2) <= interval '1-2' year to month,
+  interval_year_month(str2) < interval '1-2' year to month,
+  interval_year_month(str1) != interval '1-2' year to month,
+
+  interval '1-2' year to month != interval_year_month(str1),
+  interval '1-2' year to month >= interval_year_month(str2),
+  interval '1-2' year to month > interval_year_month(str2),
+  interval '1-3' year to month <= interval_year_month(str1),
+  interval '1-3' year to month < interval_year_month(str1),
+  interval '1-2' year to month != interval_year_month(str1)
+from vector_interval_2 order by str1;
+
+select
+  str1,
+  -- Should all be false
+  interval_year_month(str1) != interval_year_month(str1),
+  interval_year_month(str1) >= interval_year_month(str2),
+  interval_year_month(str1) > interval_year_month(str2),
+  interval_year_month(str2) <= interval_year_month(str1),
+  interval_year_month(str2) < interval_year_month(str1),
+  interval_year_month(str1) != interval_year_month(str1),
+
+  interval_year_month(str1) != interval '1-2' year to month,
+  interval_year_month(str1) >= interval '1-3' year to month,
+  interval_year_month(str1) > interval '1-3' year to month,
+  interval_year_month(str2) <= interval '1-2' year to month,
+  interval_year_month(str2) < interval '1-2' year to month,
+  interval_year_month(str1) != interval '1-2' year to month,
+
+  interval '1-2' year to month != interval_year_month(str1),
+  interval '1-2' year to month >= interval_year_month(str2),
+  interval '1-2' year to month > interval_year_month(str2),
+  interval '1-3' year to month <= interval_year_month(str1),
+  interval '1-3' year to month < interval_year_month(str1),
+  interval '1-2' year to month != interval_year_month(str1)
+from vector_interval_2 order by str1;
+
+explain
+select
+  str3,
+  -- Should all be true
+  interval_day_time(str3) = interval_day_time(str3),
+  interval_day_time(str3) <= interval_day_time(str3),
+  interval_day_time(str3) <= interval_day_time(str4),
+  interval_day_time(str3) < interval_day_time(str4),
+  interval_day_time(str3) >= interval_day_time(str3),
+  interval_day_time(str4) >= interval_day_time(str3),
+  interval_day_time(str4) > interval_day_time(str3),
+  interval_day_time(str3) != interval_day_time(str4),
+
+  interval_day_time(str3) = interval '1 2:3:4' day to second,
+  interval_day_time(str3) <= interval '1 2:3:4' day to second,
+  interval_day_time(str3) <= interval '1 2:3:5' day to second,
+  interval_day_time(str3) < interval '1 2:3:5' day to second,
+  interval_day_time(str3) >= interval '1 2:3:4' day to second,
+  interval_day_time(str4) >= interval '1 2:3:4' day to second,
+  interval_day_time(str4) > interval '1 2:3:4' day to second,
+  interval_day_time(str3) != interval '1 2:3:5' day to second,
+
+  interval '1 2:3:4' day to second = interval_day_time(str3),
+  interval '1 2:3:4' day to second <= interval_day_time(str3),
+  interval '1 2:3:4' day to second <= interval_day_time(str4),
+  interval '1 2:3:4' day to second < interval_day_time(str4),
+  interval '1 2:3:4' day to second >= interval_day_time(str3),
+  interval '1 2:3:5' day to second >= interval_day_time(str3),
+  interval '1 2:3:5' day to second > interval_day_time(str3),
+  interval '1 2:3:4' day to second != interval_day_time(str4)
+from vector_interval_2 order by str3;
+
+select
+  str3,
+  -- Should all be true
+  interval_day_time(str3) = interval_day_time(str3),
+  interval_day_time(str3) <= interval_day_time(str3),
+  interval_day_time(str3) <= interval_day_time(str4),
+  interval_day_time(str3) < interval_day_time(str4),
+  interval_day_time(str3) >= interval_day_time(str3),
+  interval_day_time(str4) >= interval_day_time(str3),
+  interval_day_time(str4) > interval_day_time(str3),
+  interval_day_time(str3) != interval_day_time(str4),
+
+  interval_day_time(str3) = interval '1 2:3:4' day to second,
+  interval_day_time(str3) <= interval '1 2:3:4' day to second,
+  interval_day_time(str3) <= interval '1 2:3:5' day to second,
+  interval_day_time(str3) < interval '1 2:3:5' day to second,
+  interval_day_time(str3) >= interval '1 2:3:4' day to second,
+  interval_day_time(str4) >= interval '1 2:3:4' day to second,
+  interval_day_time(str4) > interval '1 2:3:4' day to second,
+  interval_day_time(str3) != interval '1 2:3:5' day to second,
+
+  interval '1 2:3:4' day to second = interval_day_time(str3),
+  interval '1 2:3:4' day to second <= interval_day_time(str3),
+  interval '1 2:3:4' day to second <= interval_day_time(str4),
+  interval '1 2:3:4' day to second < interval_day_time(str4),
+  interval '1 2:3:4' day to second >= interval_day_time(str3),
+  interval '1 2:3:5' day to second >= interval_day_time(str3),
+  interval '1 2:3:5' day to second > interval_day_time(str3),
+  interval '1 2:3:4' day to second != interval_day_time(str4)
+from vector_interval_2 order by str3;
+
+explain
+select
+  str3,
+  -- Should all be false
+  interval_day_time(str3) != interval_day_time(str3),
+  interval_day_time(str3) >= interval_day_time(str4),
+  interval_day_time(str3) > interval_day_time(str4),
+  interval_day_time(str4) <= interval_day_time(str3),
+  interval_day_time(str4) < interval_day_time(str3),
+  interval_day_time(str3) != interval_day_time(str3),
+
+  interval_day_time(str3) != interval '1 2:3:4' day to second,
+  interval_day_time(str3) >= interval '1 2:3:5' day to second,
+  interval_day_time(str3) > interval '1 2:3:5' day to second,
+  interval_day_time(str4) <= interval '1 2:3:4' day to second,
+  interval_day_time(str4) < interval '1 2:3:4' day to second,
+  interval_day_time(str3) != interval '1 2:3:4' day to second,
+
+  interval '1 2:3:4' day to second != interval_day_time(str3),
+  interval '1 2:3:4' day to second >= interval_day_time(str4),
+  interval '1 2:3:4' day to second > interval_day_time(str4),
+  interval '1 2:3:5' day to second <= interval_day_time(str3),
+  interval '1 2:3:5' day to second < interval_day_time(str3),
+  interval '1 2:3:4' day to second != interval_day_time(str3)
+from vector_interval_2 order by str3;
+
+select
+  str3,
+  -- Should all be false
+  interval_day_time(str3) != interval_day_time(str3),
+  interval_day_time(str3) >= interval_day_time(str4),
+  interval_day_time(str3) > interval_day_time(str4),
+  interval_day_time(str4) <= interval_day_time(str3),
+  interval_day_time(str4) < interval_day_time(str3),
+  interval_day_time(str3) != interval_day_time(str3),
+
+  interval_day_time(str3) != interval '1 2:3:4' day to second,
+  interval_day_time(str3) >= interval '1 2:3:5' day to second,
+  interval_day_time(str3) > interval '1 2:3:5' day to second,
+  interval_day_time(str4) <= interval '1 2:3:4' day to second,
+  interval_day_time(str4) < interval '1 2:3:4' day to second,
+  interval_day_time(str3) != interval '1 2:3:4' day to second,
+
+  interval '1 2:3:4' day to second != interval_day_time(str3),
+  interval '1 2:3:4' day to second >= interval_day_time(str4),
+  interval '1 2:3:4' day to second > interval_day_time(str4),
+  interval '1 2:3:5' day to second <= interval_day_time(str3),
+  interval '1 2:3:5' day to second < interval_day_time(str3),
+  interval '1 2:3:4' day to second != interval_day_time(str3)
+from vector_interval_2 order by str3;
+
+
+-- interval expressions in predicates
+explain
+select ts from vector_interval_2
+where
+  interval_year_month(str1) = interval_year_month(str1)
+  and interval_year_month(str1) != interval_year_month(str2)
+  and interval_year_month(str1) <= interval_year_month(str2)
+  and interval_year_month(str1) < interval_year_month(str2)
+  and interval_year_month(str2) >= interval_year_month(str1)
+  and interval_year_month(str2) > interval_year_month(str1)
+
+  and interval_year_month(str1) = interval '1-2' year to month
+  and interval_year_month(str1) != interval '1-3' year to month
+  and interval_year_month(str1) <= interval '1-3' year to month
+  and interval_year_month(str1) < interval '1-3' year to month
+  and interval_year_month(str2) >= interval '1-2' year to month
+  and interval_year_month(str2) > interval '1-2' year to month
+
+  and interval '1-2' year to month = interval_year_month(str1)
+  and interval '1-2' year to month != interval_year_month(str2)
+  and interval '1-2' year to month <= interval_year_month(str2)
+  and interval '1-2' year to month < interval_year_month(str2)
+  and interval '1-3' year to month >= interval_year_month(str1)
+  and interval '1-3' year to month > interval_year_month(str1)
+order by ts;
+
+select ts from vector_interval_2
+where
+  interval_year_month(str1) = interval_year_month(str1)
+  and interval_year_month(str1) != interval_year_month(str2)
+  and interval_year_month(str1) <= interval_year_month(str2)
+  and interval_year_month(str1) < interval_year_month(str2)
+  and interval_year_month(str2) >= interval_year_month(str1)
+  and interval_year_month(str2) > interval_year_month(str1)
+
+  and interval_year_month(str1) = interval '1-2' year to month
+  and interval_year_month(str1) != interval '1-3' year to month
+  and interval_year_month(str1) <= interval '1-3' year to month
+  and interval_year_month(str1) < interval '1-3' year to month
+  and interval_year_month(str2) >= interval '1-2' year to month
+  and interval_year_month(str2) > interval '1-2' year to month
+
+  and interval '1-2' year to month = interval_year_month(str1)
+  and interval '1-2' year to month != interval_year_month(str2)
+  and interval '1-2' year to month <= interval_year_month(str2)
+  and interval '1-2' year to month < interval_year_month(str2)
+  and interval '1-3' year to month >= interval_year_month(str1)
+  and interval '1-3' year to month > interval_year_month(str1)
+order by ts;
+
+explain
+select ts from vector_interval_2
+where
+  interval_day_time(str3) = interval_day_time(str3)
+  and interval_day_time(str3) != interval_day_time(str4)
+  and interval_day_time(str3) <= interval_day_time(str4)
+  and interval_day_time(str3) < interval_day_time(str4)
+  and interval_day_time(str4) >= interval_day_time(str3)
+  and interval_day_time(str4) > interval_day_time(str3)
+
+  and interval_day_time(str3) = interval '1 2:3:4' day to second
+  and interval_day_time(str3) != interval '1 2:3:5' day to second
+  and interval_day_time(str3) <= interval '1 2:3:5' day to second
+  and interval_day_time(str3) < interval '1 2:3:5' day to second
+  and interval_day_time(str4) >= interval '1 2:3:4' day to second
+  and interval_day_time(str4) > interval '1 2:3:4' day to second
+
+  and interval '1 2:3:4' day to second = interval_day_time(str3)
+  and interval '1 2:3:4' day to second != interval_day_time(str4)
+  and interval '1 2:3:4' day to second <= interval_day_time(str4)
+  and interval '1 2:3:4' day to second < interval_day_time(str4)
+  and interval '1 2:3:5' day to second >= interval_day_time(str3)
+  and interval '1 2:3:5' day to second > interval_day_time(str3)
+order by ts;
+
+select ts from vector_interval_2
+where
+  interval_day_time(str3) = interval_day_time(str3)
+  and interval_day_time(str3) != interval_day_time(str4)
+  and interval_day_time(str3) <= interval_day_time(str4)
+  and interval_day_time(str3) < interval_day_time(str4)
+  and interval_day_time(str4) >= interval_day_time(str3)
+  and interval_day_time(str4) > interval_day_time(str3)
+
+  and interval_day_time(str3) = interval '1 2:3:4' day to second
+  and interval_day_time(str3) != interval '1 2:3:5' day to second
+  and interval_day_time(str3) <= interval '1 2:3:5' day to second
+  and interval_day_time(str3) < interval '1 2:3:5' day to second
+  and interval_day_time(str4) >= interval '1 2:3:4' day to second
+  and interval_day_time(str4) > interval '1 2:3:4' day to second
+
+  and interval '1 2:3:4' day to second = interval_day_time(str3)
+  and interval '1 2:3:4' day to second != interval_day_time(str4)
+  and interval '1 2:3:4' day to second <= interval_day_time(str4)
+  and interval '1 2:3:4' day to second < interval_day_time(str4)
+  and interval '1 2:3:5' day to second >= interval_day_time(str3)
+  and interval '1 2:3:5' day to second > interval_day_time(str3)
+order by ts;
+
+explain
+select ts from vector_interval_2
+where
+  date '2002-03-01' = dt + interval_year_month(str1)
+  and date '2002-03-01' <= dt + interval_year_month(str1)
+  and date '2002-03-01' >= dt + interval_year_month(str1)
+  and dt + interval_year_month(str1) = date '2002-03-01'
+  and dt + interval_year_month(str1) <= date '2002-03-01'
+  and dt + interval_year_month(str1) >= date '2002-03-01'
+  and dt != dt + interval_year_month(str1)
+
+  and date '2002-03-01' = dt + interval '1-2' year to month
+  and date '2002-03-01' <= dt + interval '1-2' year to month
+  and date '2002-03-01' >= dt + interval '1-2' year to month
+  and dt + interval '1-2' year to month = date '2002-03-01'
+  and dt + interval '1-2' year to month <= date '2002-03-01'
+  and dt + interval '1-2' year to month >= date '2002-03-01'
+  and dt != dt + interval '1-2' year to month
+order by ts;
+
+select ts from vector_interval_2
+where
+  date '2002-03-01' = dt + interval_year_month(str1)
+  and date '2002-03-01' <= dt + interval_year_month(str1)
+  and date '2002-03-01' >= dt + interval_year_month(str1)
+  and dt + interval_year_month(str1) = date '2002-03-01'
+  and dt + interval_year_month(str1) <= date '2002-03-01'
+  and dt + interval_year_month(str1) >= date '2002-03-01'
+  and dt != dt + interval_year_month(str1)
+
+  and date '2002-03-01' = dt + interval '1-2' year to month
+  and date '2002-03-01' <= dt + interval '1-2' year to month
+  and date '2002-03-01' >= dt + interval '1-2' year to month
+  and dt + interval '1-2' year to month = date '2002-03-01'
+  and dt + interval '1-2' year to month <= date '2002-03-01'
+  and dt + interval '1-2' year to month >= date '2002-03-01'
+  and dt != dt + interval '1-2' year to month
+order by ts;
+
+explain
+select ts from vector_interval_2
+where
+  timestamp '2002-03-01 01:02:03' = ts + interval '1-2' year to month
+  and timestamp '2002-03-01 01:02:03' <= ts + interval '1-2' year to month
+  and timestamp '2002-03-01 01:02:03' >= ts + interval '1-2' year to month
+  and timestamp '2002-04-01 01:02:03' != ts + interval '1-2' year to month
+  and timestamp '2002-02-01 01:02:03' < ts + interval '1-2' year to month
+  and timestamp '2002-04-01 01:02:03' > ts + interval '1-2' year to month
+
+  and ts + interval '1-2' year to month = timestamp '2002-03-01 01:02:03'
+  and ts + interval '1-2' year to month >= timestamp '2002-03-01 01:02:03'
+  and ts + interval '1-2' year to month <= timestamp '2002-03-01 01:02:03'
+  and ts + interval '1-2' year to month != timestamp '2002-04-01 01:02:03'
+  and ts + interval '1-2' year to month > timestamp '2002-02-01 01:02:03'
+  and ts + interval '1-2' year to month < timestamp '2002-04-01 01:02:03'
+
+  and ts = ts + interval '0' year
+  and ts != ts + interval '1' year
+  and ts <= ts + interval '1' year
+  and ts < ts + interval '1' year
+  and ts >= ts - interval '1' year
+  and ts > ts - interval '1' year
+order by ts;
+
+select ts from vector_interval_2
+where
+  timestamp '2002-03-01 01:02:03' = ts + interval '1-2' year to month
+  and timestamp '2002-03-01 01:02:03' <= ts + interval '1-2' year to month
+  and timestamp '2002-03-01 01:02:03' >= ts + interval '1-2' year to month
+  and timestamp '2002-04-01 01:02:03' != ts + interval '1-2' year to month
+  and timestamp '2002-02-01 01:02:03' < ts + interval '1-2' year to month
+  and timestamp '2002-04-01 01:02:03' > ts + interval '1-2' year to month
+
+  and ts + interval '1-2' year to month = timestamp '2002-03-01 01:02:03'
+  and ts + interval '1-2' year to month >= timestamp '2002-03-01 01:02:03'
+  and ts + interval '1-2' year to month <= timestamp '2002-03-01 01:02:03'
+  and ts + interval '1-2' year to month != timestamp '2002-04-01 01:02:03'
+  and ts + interval '1-2' year to month > timestamp '2002-02-01 01:02:03'
+  and ts + interval '1-2' year to month < timestamp '2002-04-01 01:02:03'
+
+  and ts = ts + interval '0' year
+  and ts != ts + interval '1' year
+  and ts <= ts + interval '1' year
+  and ts < ts + interval '1' year
+  and ts >= ts - interval '1' year
+  and ts > ts - interval '1' year
+order by ts;
+
+-- day to second expressions in predicate
+explain
+select ts from vector_interval_2
+where
+  timestamp '2001-01-01 01:02:03' = dt + interval '0 1:2:3' day to second
+  and timestamp '2001-01-01 01:02:03' != dt + interval '0 1:2:4' day to second
+  and timestamp '2001-01-01 01:02:03' <= dt + interval '0 1:2:3' day to second
+  and timestamp '2001-01-01 01:02:03' < dt + interval '0 1:2:4' day to second
+  and timestamp '2001-01-01 01:02:03' >= dt - interval '0 1:2:3' day to second
+  and timestamp '2001-01-01 01:02:03' > dt - interval '0 1:2:4' day to second
+
+  and dt + interval '0 1:2:3' day to second = timestamp '2001-01-01 01:02:03'
+  and dt + interval '0 1:2:4' day to second != timestamp '2001-01-01 01:02:03'
+  and dt + interval '0 1:2:3' day to second >= timestamp '2001-01-01 01:02:03'
+  and dt + interval '0 1:2:4' day to second > timestamp '2001-01-01 01:02:03'
+  and dt - interval '0 1:2:3' day to second <= timestamp '2001-01-01 01:02:03'
+  and dt - interval '0 1:2:4' day to second < timestamp '2001-01-01 01:02:03'
+
+  and ts = dt + interval '0 1:2:3' day to second
+  and ts != dt + interval '0 1:2:4' day to second
+  and ts <= dt + interval '0 1:2:3' day to second
+  and ts < dt + interval '0 1:2:4' day to second
+  and ts >= dt - interval '0 1:2:3' day to second
+  and ts > dt - interval '0 1:2:4' day to second
+order by ts;
+
+select ts from vector_interval_2
+where
+  timestamp '2001-01-01 01:02:03' = dt + interval '0 1:2:3' day to second
+  and timestamp '2001-01-01 01:02:03' != dt + interval '0 1:2:4' day to second
+  and timestamp '2001-01-01 01:02:03' <= dt + interval '0 1:2:3' day to second
+  and timestamp '2001-01-01 01:02:03' < dt + interval '0 1:2:4' day to second
+  and timestamp '2001-01-01 01:02:03' >= dt - interval '0 1:2:3' day to second
+  and timestamp '2001-01-01 01:02:03' > dt - interval '0 1:2:4' day to second
+
+  and dt + interval '0 1:2:3' day to second = timestamp '2001-01-01 01:02:03'
+  and dt + interval '0 1:2:4' day to second != timestamp '2001-01-01 01:02:03'
+  and dt + interval '0 1:2:3' day to second >= timestamp '2001-01-01 01:02:03'
+  and dt + interval '0 1:2:4' day to second > timestamp '2001-01-01 01:02:03'
+  and dt - interval '0 1:2:3' day to second <= timestamp '2001-01-01 01:02:03'
+  and dt - interval '0 1:2:4' day to second < timestamp '2001-01-01 01:02:03'
+
+  and ts = dt + interval '0 1:2:3' day to second
+  and ts != dt + interval '0 1:2:4' day to second
+  and ts <= dt + interval '0 1:2:3' day to second
+  and ts < dt + interval '0 1:2:4' day to second
+  and ts >= dt - interval '0 1:2:3' day to second
+  and ts > dt - interval '0 1:2:4' day to second
+order by ts;
+
+explain
+select ts from vector_interval_2
+where
+  timestamp '2001-01-01 01:02:03' = ts + interval '0' day
+  and timestamp '2001-01-01 01:02:03' != ts + interval '1' day
+  and timestamp '2001-01-01 01:02:03' <= ts + interval '1' day
+  and timestamp '2001-01-01 01:02:03' < ts + interval '1' day
+  and timestamp '2001-01-01 01:02:03' >= ts - interval '1' day
+  and timestamp '2001-01-01 01:02:03' > ts - interval '1' day
+
+  and ts + interval '0' day = timestamp '2001-01-01 01:02:03'
+  and ts + interval '1' day != timestamp '2001-01-01 01:02:03'
+  and ts + interval '1' day >= timestamp '2001-01-01 01:02:03'
+  and ts + interval '1' day > timestamp '2001-01-01 01:02:03'
+  and ts - interval '1' day <= timestamp '2001-01-01 01:02:03'
+  and ts - interval '1' day < timestamp '2001-01-01 01:02:03'
+
+  and ts = ts + interval '0' day
+  and ts != ts + interval '1' day
+  and ts <= ts + interval '1' day
+  and ts < ts + interval '1' day
+  and ts >= ts - interval '1' day
+  and ts > ts - interval '1' day
+order by ts;
+
+select ts from vector_interval_2
+where
+  timestamp '2001-01-01 01:02:03' = ts + interval '0' day
+  and timestamp '2001-01-01 01:02:03' != ts + interval '1' day
+  and timestamp '2001-01-01 01:02:03' <= ts + interval '1' day
+  and timestamp '2001-01-01 01:02:03' < ts + interval '1' day
+  and timestamp '2001-01-01 01:02:03' >= ts - interval '1' day
+  and timestamp '2001-01-01 01:02:03' > ts - interval '1' day
+
+  and ts + interval '0' day = timestamp '2001-01-01 01:02:03'
+  and ts + interval '1' day != timestamp '2001-01-01 01:02:03'
+  and ts + interval '1' day >= timestamp '2001-01-01 01:02:03'
+  and ts + interval '1' day > timestamp '2001-01-01 01:02:03'
+  and ts - interval '1' day <= timestamp '2001-01-01 01:02:03'
+  and ts - interval '1' day < timestamp '2001-01-01 01:02:03'
+
+  and ts = ts + interval '0' day
+  and ts != ts + interval '1' day
+  and ts <= ts + interval '1' day
+  and ts < ts + interval '1' day
+  and ts >= ts - interval '1' day
+  and ts > ts - interval '1' day
+order by ts;
+
+drop table vector_interval_2;

Modified: hive/branches/llap/ql/src/test/resources/orc-file-dump-bloomfilter.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/resources/orc-file-dump-bloomfilter.out?rev=1669718&r1=1669717&r2=1669718&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/resources/orc-file-dump-bloomfilter.out (original)
+++ hive/branches/llap/ql/src/test/resources/orc-file-dump-bloomfilter.out Sat Mar 28 00:22:15 2015
@@ -39,7 +39,7 @@ File Statistics:
   Column 3: count: 21000 hasNull: false min: Darkness, max: worst sum: 81761
 
 Stripes:
-  Stripe: offset: 3 data: 63765 rows: 5000 tail: 86 index: 845
+  Stripe: offset: 3 data: 63765 rows: 5000 tail: 98 index: 845
     Stream: column 0 section ROW_INDEX start: 3 length 17
     Stream: column 1 section ROW_INDEX start: 20 length 164
     Stream: column 2 section ROW_INDEX start: 184 length 173
@@ -67,17 +67,17 @@ Stripes:
       Entry 3: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
       Entry 4: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
       Stripe level merge: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
-  Stripe: offset: 64699 data: 63754 rows: 5000 tail: 86 index: 837
-    Stream: column 0 section ROW_INDEX start: 64699 length 17
-    Stream: column 1 section ROW_INDEX start: 64716 length 162
-    Stream: column 2 section ROW_INDEX start: 64878 length 171
-    Stream: column 3 section ROW_INDEX start: 65049 length 83
-    Stream: column 3 section BLOOM_FILTER start: 65132 length 404
-    Stream: column 1 section DATA start: 65536 length 20029
-    Stream: column 2 section DATA start: 85565 length 40035
-    Stream: column 3 section DATA start: 125600 length 3532
-    Stream: column 3 section LENGTH start: 129132 length 25
-    Stream: column 3 section DICTIONARY_DATA start: 129157 length 133
+  Stripe: offset: 64711 data: 63754 rows: 5000 tail: 98 index: 837
+    Stream: column 0 section ROW_INDEX start: 64711 length 17
+    Stream: column 1 section ROW_INDEX start: 64728 length 162
+    Stream: column 2 section ROW_INDEX start: 64890 length 171
+    Stream: column 3 section ROW_INDEX start: 65061 length 83
+    Stream: column 3 section BLOOM_FILTER start: 65144 length 404
+    Stream: column 1 section DATA start: 65548 length 20029
+    Stream: column 2 section DATA start: 85577 length 40035
+    Stream: column 3 section DATA start: 125612 length 3532
+    Stream: column 3 section LENGTH start: 129144 length 25
+    Stream: column 3 section DICTIONARY_DATA start: 129169 length 133
     Encoding column 0: DIRECT
     Encoding column 1: DIRECT_V2
     Encoding column 2: DIRECT_V2
@@ -95,17 +95,17 @@ Stripes:
       Entry 3: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
       Entry 4: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
       Stripe level merge: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
-  Stripe: offset: 129376 data: 63766 rows: 5000 tail: 86 index: 841
-    Stream: column 0 section ROW_INDEX start: 129376 length 17
-    Stream: column 1 section ROW_INDEX start: 129393 length 159
-    Stream: column 2 section ROW_INDEX start: 129552 length 171
-    Stream: column 3 section ROW_INDEX start: 129723 length 90
-    Stream: column 3 section BLOOM_FILTER start: 129813 length 404
-    Stream: column 1 section DATA start: 130217 length 20029
-    Stream: column 2 section DATA start: 150246 length 40035
-    Stream: column 3 section DATA start: 190281 length 3544
-    Stream: column 3 section LENGTH start: 193825 length 25
-    Stream: column 3 section DICTIONARY_DATA start: 193850 length 133
+  Stripe: offset: 129400 data: 63766 rows: 5000 tail: 98 index: 841
+    Stream: column 0 section ROW_INDEX start: 129400 length 17
+    Stream: column 1 section ROW_INDEX start: 129417 length 159
+    Stream: column 2 section ROW_INDEX start: 129576 length 171
+    Stream: column 3 section ROW_INDEX start: 129747 length 90
+    Stream: column 3 section BLOOM_FILTER start: 129837 length 404
+    Stream: column 1 section DATA start: 130241 length 20029
+    Stream: column 2 section DATA start: 150270 length 40035
+    Stream: column 3 section DATA start: 190305 length 3544
+    Stream: column 3 section LENGTH start: 193849 length 25
+    Stream: column 3 section DICTIONARY_DATA start: 193874 length 133
     Encoding column 0: DIRECT
     Encoding column 1: DIRECT_V2
     Encoding column 2: DIRECT_V2
@@ -123,17 +123,17 @@ Stripes:
       Entry 3: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
       Entry 4: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
       Stripe level merge: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
-  Stripe: offset: 194069 data: 63796 rows: 5000 tail: 86 index: 844
-    Stream: column 0 section ROW_INDEX start: 194069 length 17
-    Stream: column 1 section ROW_INDEX start: 194086 length 162
-    Stream: column 2 section ROW_INDEX start: 194248 length 170
-    Stream: column 3 section ROW_INDEX start: 194418 length 91
-    Stream: column 3 section BLOOM_FILTER start: 194509 length 404
-    Stream: column 1 section DATA start: 194913 length 20029
-    Stream: column 2 section DATA start: 214942 length 40035
-    Stream: column 3 section DATA start: 254977 length 3574
-    Stream: column 3 section LENGTH start: 258551 length 25
-    Stream: column 3 section DICTIONARY_DATA start: 258576 length 133
+  Stripe: offset: 194105 data: 63796 rows: 5000 tail: 98 index: 844
+    Stream: column 0 section ROW_INDEX start: 194105 length 17
+    Stream: column 1 section ROW_INDEX start: 194122 length 162
+    Stream: column 2 section ROW_INDEX start: 194284 length 170
+    Stream: column 3 section ROW_INDEX start: 194454 length 91
+    Stream: column 3 section BLOOM_FILTER start: 194545 length 404
+    Stream: column 1 section DATA start: 194949 length 20029
+    Stream: column 2 section DATA start: 214978 length 40035
+    Stream: column 3 section DATA start: 255013 length 3574
+    Stream: column 3 section LENGTH start: 258587 length 25
+    Stream: column 3 section DICTIONARY_DATA start: 258612 length 133
     Encoding column 0: DIRECT
     Encoding column 1: DIRECT_V2
     Encoding column 2: DIRECT_V2
@@ -151,17 +151,17 @@ Stripes:
       Entry 3: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
       Entry 4: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
       Stripe level merge: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
-  Stripe: offset: 258795 data: 12940 rows: 1000 tail: 78 index: 432
-    Stream: column 0 section ROW_INDEX start: 258795 length 12
-    Stream: column 1 section ROW_INDEX start: 258807 length 38
-    Stream: column 2 section ROW_INDEX start: 258845 length 41
-    Stream: column 3 section ROW_INDEX start: 258886 length 40
-    Stream: column 3 section BLOOM_FILTER start: 258926 length 301
-    Stream: column 1 section DATA start: 259227 length 4007
-    Stream: column 2 section DATA start: 263234 length 8007
-    Stream: column 3 section DATA start: 271241 length 768
-    Stream: column 3 section LENGTH start: 272009 length 25
-    Stream: column 3 section DICTIONARY_DATA start: 272034 length 133
+  Stripe: offset: 258843 data: 12940 rows: 1000 tail: 90 index: 432
+    Stream: column 0 section ROW_INDEX start: 258843 length 12
+    Stream: column 1 section ROW_INDEX start: 258855 length 38
+    Stream: column 2 section ROW_INDEX start: 258893 length 41
+    Stream: column 3 section ROW_INDEX start: 258934 length 40
+    Stream: column 3 section BLOOM_FILTER start: 258974 length 301
+    Stream: column 1 section DATA start: 259275 length 4007
+    Stream: column 2 section DATA start: 263282 length 8007
+    Stream: column 3 section DATA start: 271289 length 768
+    Stream: column 3 section LENGTH start: 272057 length 25
+    Stream: column 3 section DICTIONARY_DATA start: 272082 length 133
     Encoding column 0: DIRECT
     Encoding column 1: DIRECT_V2
     Encoding column 2: DIRECT_V2
@@ -172,6 +172,6 @@ Stripes:
       Entry 0: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
       Stripe level merge: numHashFunctions: 4 bitCount: 6272 popCount: 138 loadFactor: 0.022 expectedFpp: 2.343647E-7
 
-File length: 272790 bytes
+File length: 272850 bytes
 Padding length: 0 bytes
 Padding ratio: 0%

Modified: hive/branches/llap/ql/src/test/resources/orc-file-dump-bloomfilter2.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/resources/orc-file-dump-bloomfilter2.out?rev=1669718&r1=1669717&r2=1669718&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/resources/orc-file-dump-bloomfilter2.out (original)
+++ hive/branches/llap/ql/src/test/resources/orc-file-dump-bloomfilter2.out Sat Mar 28 00:22:15 2015
@@ -39,7 +39,7 @@ File Statistics:
   Column 3: count: 21000 hasNull: false min: Darkness, max: worst sum: 81761
 
 Stripes:
-  Stripe: offset: 3 data: 63765 rows: 5000 tail: 85 index: 6935
+  Stripe: offset: 3 data: 63765 rows: 5000 tail: 97 index: 6935
     Stream: column 0 section ROW_INDEX start: 3 length 17
     Stream: column 1 section ROW_INDEX start: 20 length 164
     Stream: column 2 section ROW_INDEX start: 184 length 173
@@ -67,17 +67,17 @@ Stripes:
       Entry 3: numHashFunctions: 7 bitCount: 9600 popCount: 4971 loadFactor: 0.5178 expectedFpp: 0.009981772
       Entry 4: numHashFunctions: 7 bitCount: 9600 popCount: 4949 loadFactor: 0.5155 expectedFpp: 0.009676614
       Stripe level merge: numHashFunctions: 7 bitCount: 9600 popCount: 9347 loadFactor: 0.9736 expectedFpp: 0.829482
-  Stripe: offset: 70788 data: 63754 rows: 5000 tail: 85 index: 6917
-    Stream: column 0 section ROW_INDEX start: 70788 length 17
-    Stream: column 1 section ROW_INDEX start: 70805 length 162
-    Stream: column 2 section ROW_INDEX start: 70967 length 171
-    Stream: column 2 section BLOOM_FILTER start: 71138 length 6484
-    Stream: column 3 section ROW_INDEX start: 77622 length 83
-    Stream: column 1 section DATA start: 77705 length 20029
-    Stream: column 2 section DATA start: 97734 length 40035
-    Stream: column 3 section DATA start: 137769 length 3532
-    Stream: column 3 section LENGTH start: 141301 length 25
-    Stream: column 3 section DICTIONARY_DATA start: 141326 length 133
+  Stripe: offset: 70800 data: 63754 rows: 5000 tail: 97 index: 6917
+    Stream: column 0 section ROW_INDEX start: 70800 length 17
+    Stream: column 1 section ROW_INDEX start: 70817 length 162
+    Stream: column 2 section ROW_INDEX start: 70979 length 171
+    Stream: column 2 section BLOOM_FILTER start: 71150 length 6484
+    Stream: column 3 section ROW_INDEX start: 77634 length 83
+    Stream: column 1 section DATA start: 77717 length 20029
+    Stream: column 2 section DATA start: 97746 length 40035
+    Stream: column 3 section DATA start: 137781 length 3532
+    Stream: column 3 section LENGTH start: 141313 length 25
+    Stream: column 3 section DICTIONARY_DATA start: 141338 length 133
     Encoding column 0: DIRECT
     Encoding column 1: DIRECT_V2
     Encoding column 2: DIRECT_V2
@@ -95,17 +95,17 @@ Stripes:
       Entry 3: numHashFunctions: 7 bitCount: 9600 popCount: 4962 loadFactor: 0.5169 expectedFpp: 0.009855959
       Entry 4: numHashFunctions: 7 bitCount: 9600 popCount: 4966 loadFactor: 0.5173 expectedFpp: 0.009911705
       Stripe level merge: numHashFunctions: 7 bitCount: 9600 popCount: 9344 loadFactor: 0.9733 expectedFpp: 0.8276205
-  Stripe: offset: 141544 data: 63766 rows: 5000 tail: 85 index: 6924
-    Stream: column 0 section ROW_INDEX start: 141544 length 17
-    Stream: column 1 section ROW_INDEX start: 141561 length 159
-    Stream: column 2 section ROW_INDEX start: 141720 length 171
-    Stream: column 2 section BLOOM_FILTER start: 141891 length 6487
-    Stream: column 3 section ROW_INDEX start: 148378 length 90
-    Stream: column 1 section DATA start: 148468 length 20029
-    Stream: column 2 section DATA start: 168497 length 40035
-    Stream: column 3 section DATA start: 208532 length 3544
-    Stream: column 3 section LENGTH start: 212076 length 25
-    Stream: column 3 section DICTIONARY_DATA start: 212101 length 133
+  Stripe: offset: 141568 data: 63766 rows: 5000 tail: 97 index: 6924
+    Stream: column 0 section ROW_INDEX start: 141568 length 17
+    Stream: column 1 section ROW_INDEX start: 141585 length 159
+    Stream: column 2 section ROW_INDEX start: 141744 length 171
+    Stream: column 2 section BLOOM_FILTER start: 141915 length 6487
+    Stream: column 3 section ROW_INDEX start: 148402 length 90
+    Stream: column 1 section DATA start: 148492 length 20029
+    Stream: column 2 section DATA start: 168521 length 40035
+    Stream: column 3 section DATA start: 208556 length 3544
+    Stream: column 3 section LENGTH start: 212100 length 25
+    Stream: column 3 section DICTIONARY_DATA start: 212125 length 133
     Encoding column 0: DIRECT
     Encoding column 1: DIRECT_V2
     Encoding column 2: DIRECT_V2
@@ -123,17 +123,17 @@ Stripes:
       Entry 3: numHashFunctions: 7 bitCount: 9600 popCount: 4943 loadFactor: 0.5149 expectedFpp: 0.009594797
       Entry 4: numHashFunctions: 7 bitCount: 9600 popCount: 4930 loadFactor: 0.5135 expectedFpp: 0.009419539
       Stripe level merge: numHashFunctions: 7 bitCount: 9600 popCount: 9333 loadFactor: 0.9722 expectedFpp: 0.82082444
-  Stripe: offset: 212319 data: 63796 rows: 5000 tail: 85 index: 6925
-    Stream: column 0 section ROW_INDEX start: 212319 length 17
-    Stream: column 1 section ROW_INDEX start: 212336 length 162
-    Stream: column 2 section ROW_INDEX start: 212498 length 170
-    Stream: column 2 section BLOOM_FILTER start: 212668 length 6485
-    Stream: column 3 section ROW_INDEX start: 219153 length 91
-    Stream: column 1 section DATA start: 219244 length 20029
-    Stream: column 2 section DATA start: 239273 length 40035
-    Stream: column 3 section DATA start: 279308 length 3574
-    Stream: column 3 section LENGTH start: 282882 length 25
-    Stream: column 3 section DICTIONARY_DATA start: 282907 length 133
+  Stripe: offset: 212355 data: 63796 rows: 5000 tail: 97 index: 6925
+    Stream: column 0 section ROW_INDEX start: 212355 length 17
+    Stream: column 1 section ROW_INDEX start: 212372 length 162
+    Stream: column 2 section ROW_INDEX start: 212534 length 170
+    Stream: column 2 section BLOOM_FILTER start: 212704 length 6485
+    Stream: column 3 section ROW_INDEX start: 219189 length 91
+    Stream: column 1 section DATA start: 219280 length 20029
+    Stream: column 2 section DATA start: 239309 length 40035
+    Stream: column 3 section DATA start: 279344 length 3574
+    Stream: column 3 section LENGTH start: 282918 length 25
+    Stream: column 3 section DICTIONARY_DATA start: 282943 length 133
     Encoding column 0: DIRECT
     Encoding column 1: DIRECT_V2
     Encoding column 2: DIRECT_V2
@@ -151,17 +151,17 @@ Stripes:
       Entry 3: numHashFunctions: 7 bitCount: 9600 popCount: 4941 loadFactor: 0.5147 expectedFpp: 0.009567649
       Entry 4: numHashFunctions: 7 bitCount: 9600 popCount: 4993 loadFactor: 0.5201 expectedFpp: 0.010295142
       Stripe level merge: numHashFunctions: 7 bitCount: 9600 popCount: 9353 loadFactor: 0.9743 expectedFpp: 0.8332165
-  Stripe: offset: 283125 data: 12940 rows: 1000 tail: 78 index: 1468
-    Stream: column 0 section ROW_INDEX start: 283125 length 12
-    Stream: column 1 section ROW_INDEX start: 283137 length 38
-    Stream: column 2 section ROW_INDEX start: 283175 length 41
-    Stream: column 2 section BLOOM_FILTER start: 283216 length 1337
-    Stream: column 3 section ROW_INDEX start: 284553 length 40
-    Stream: column 1 section DATA start: 284593 length 4007
-    Stream: column 2 section DATA start: 288600 length 8007
-    Stream: column 3 section DATA start: 296607 length 768
-    Stream: column 3 section LENGTH start: 297375 length 25
-    Stream: column 3 section DICTIONARY_DATA start: 297400 length 133
+  Stripe: offset: 283173 data: 12940 rows: 1000 tail: 90 index: 1468
+    Stream: column 0 section ROW_INDEX start: 283173 length 12
+    Stream: column 1 section ROW_INDEX start: 283185 length 38
+    Stream: column 2 section ROW_INDEX start: 283223 length 41
+    Stream: column 2 section BLOOM_FILTER start: 283264 length 1337
+    Stream: column 3 section ROW_INDEX start: 284601 length 40
+    Stream: column 1 section DATA start: 284641 length 4007
+    Stream: column 2 section DATA start: 288648 length 8007
+    Stream: column 3 section DATA start: 296655 length 768
+    Stream: column 3 section LENGTH start: 297423 length 25
+    Stream: column 3 section DICTIONARY_DATA start: 297448 length 133
     Encoding column 0: DIRECT
     Encoding column 1: DIRECT_V2
     Encoding column 2: DIRECT_V2
@@ -172,6 +172,6 @@ Stripes:
       Entry 0: numHashFunctions: 7 bitCount: 9600 popCount: 4948 loadFactor: 0.5154 expectedFpp: 0.00966294
       Stripe level merge: numHashFunctions: 7 bitCount: 9600 popCount: 4948 loadFactor: 0.5154 expectedFpp: 0.00966294
 
-File length: 298155 bytes
+File length: 298215 bytes
 Padding length: 0 bytes
 Padding ratio: 0%

Modified: hive/branches/llap/ql/src/test/resources/orc-file-dump-dictionary-threshold.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/resources/orc-file-dump-dictionary-threshold.out?rev=1669718&r1=1669717&r2=1669718&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/resources/orc-file-dump-dictionary-threshold.out (original)
+++ hive/branches/llap/ql/src/test/resources/orc-file-dump-dictionary-threshold.out Sat Mar 28 00:22:15 2015
@@ -39,7 +39,7 @@ File Statistics:
   Column 3: count: 21000 hasNull: false min: Darkness,-230 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788-19204-19254-19518-19596-19786-19874-19904-20390-20752-20936 sum: 6910238
 
 Stripes:
-  Stripe: offset: 3 data: 151108 rows: 5000 tail: 68 index: 718
+  Stripe: offset: 3 data: 151108 rows: 5000 tail: 80 index: 718
     Stream: column 0 section ROW_INDEX start: 3 length 17
     Stream: column 1 section ROW_INDEX start: 20 length 162
     Stream: column 2 section ROW_INDEX start: 182 length 174
@@ -70,15 +70,15 @@ Stripes:
       Entry 2: count: 1000 hasNull: false min: Darkness,-230-368-488-586-862-930-1686-2044 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660 sum: 75448 positions: 13595,4780,0,1554,14
       Entry 3: count: 1000 hasNull: false min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788 sum: 104868 positions: 31432,228,0,2372,90
       Entry 4: count: 1000 hasNull: false min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744 sum: 136158 positions: 54111,5096,0,3354,108
-  Stripe: offset: 151897 data: 336358 rows: 5000 tail: 69 index: 954
-    Stream: column 0 section ROW_INDEX start: 151897 length 17
-    Stream: column 1 section ROW_INDEX start: 151914 length 153
-    Stream: column 2 section ROW_INDEX start: 152067 length 169
-    Stream: column 3 section ROW_INDEX start: 152236 length 615
-    Stream: column 1 section DATA start: 152851 length 20029
-    Stream: column 2 section DATA start: 172880 length 40035
-    Stream: column 3 section DATA start: 212915 length 270789
-    Stream: column 3 section LENGTH start: 483704 length 5505
+  Stripe: offset: 151909 data: 336358 rows: 5000 tail: 81 index: 954
+    Stream: column 0 section ROW_INDEX start: 151909 length 17
+    Stream: column 1 section ROW_INDEX start: 151926 length 153
+    Stream: column 2 section ROW_INDEX start: 152079 length 169
+    Stream: column 3 section ROW_INDEX start: 152248 length 615
+    Stream: column 1 section DATA start: 152863 length 20029
+    Stream: column 2 section DATA start: 172892 length 40035
+    Stream: column 3 section DATA start: 212927 length 270789
+    Stream: column 3 section LENGTH start: 483716 length 5505
     Encoding column 0: DIRECT
     Encoding column 1: DIRECT_V2
     Encoding column 2: DIRECT_V2
@@ -101,15 +101,15 @@ Stripes:
       Entry 2: count: 1000 hasNull: false min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988 sum: 224740 positions: 80822,9756,0,1945,222
       Entry 3: count: 1000 hasNull: false min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984 sum: 252094 positions: 137149,4496,0,3268,48
       Entry 4: count: 1000 hasNull: false min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938 sum: 281404 positions: 197972,6590,0,4064,342
-  Stripe: offset: 489278 data: 558031 rows: 5000 tail: 69 index: 1181
-    Stream: column 0 section ROW_INDEX start: 489278 length 17
-    Stream: column 1 section ROW_INDEX start: 489295 length 166
-    Stream: column 2 section ROW_INDEX start: 489461 length 171
-    Stream: column 3 section ROW_INDEX start: 489632 length 827
-    Stream: column 1 section DATA start: 490459 length 20029
-    Stream: column 2 section DATA start: 510488 length 40035
-    Stream: column 3 section DATA start: 550523 length 492258
-    Stream: column 3 section LENGTH start: 1042781 length 5709
+  Stripe: offset: 489302 data: 558031 rows: 5000 tail: 81 index: 1181
+    Stream: column 0 section ROW_INDEX start: 489302 length 17
+    Stream: column 1 section ROW_INDEX start: 489319 length 166
+    Stream: column 2 section ROW_INDEX start: 489485 length 171
+    Stream: column 3 section ROW_INDEX start: 489656 length 827
+    Stream: column 1 section DATA start: 490483 length 20029
+    Stream: column 2 section DATA start: 510512 length 40035
+    Stream: column 3 section DATA start: 550547 length 492258
+    Stream: column 3 section LENGTH start: 1042805 length 5709
     Encoding column 0: DIRECT
     Encoding column 1: DIRECT_V2
     Encoding column 2: DIRECT_V2
@@ -132,15 +132,15 @@ Stripes:
       Entry 2: count: 1000 hasNull: false min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976 sum: 386538 posit
 ions: 170641,3422,0,2077,162
       Entry 3: count: 1000 hasNull: false min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802
 -12976-13216-13246-13502-13766 sum: 421660 positions: 268420,9960,0,3369,16
       Entry 4: count: 1000 hasNull: false min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298
 -12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974 sum: 453606 positions: 377916,1620,0,4041,470
-  Stripe: offset: 1048559 data: 792850 rows: 5000 tail: 69 index: 1369
-    Stream: column 0 section ROW_INDEX start: 1048559 length 17
-    Stream: column 1 section ROW_INDEX start: 1048576 length 153
-    Stream: column 2 section ROW_INDEX start: 1048729 length 172
-    Stream: column 3 section ROW_INDEX start: 1048901 length 1027
-    Stream: column 1 section DATA start: 1049928 length 20029
-    Stream: column 2 section DATA start: 1069957 length 40035
-    Stream: column 3 section DATA start: 1109992 length 727038
-    Stream: column 3 section LENGTH start: 1837030 length 5748
+  Stripe: offset: 1048595 data: 792850 rows: 5000 tail: 81 index: 1369
+    Stream: column 0 section ROW_INDEX start: 1048595 length 17
+    Stream: column 1 section ROW_INDEX start: 1048612 length 153
+    Stream: column 2 section ROW_INDEX start: 1048765 length 172
+    Stream: column 3 section ROW_INDEX start: 1048937 length 1027
+    Stream: column 1 section DATA start: 1049964 length 20029
+    Stream: column 2 section DATA start: 1069993 length 40035
+    Stream: column 3 section DATA start: 1110028 length 727038
+    Stream: column 3 section LENGTH start: 1837066 length 5748
     Encoding column 0: DIRECT
     Encoding column 1: DIRECT_V2
     Encoding column 2: DIRECT_V2
@@ -163,15 +163,15 @@ Stripes:
       Entry 2: count: 1000 hasNull: false min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9
 650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878 sum: 568274 positions: 263111,206,0,1926,462
       Entry 3: count: 1000 hasNull: false min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210-17268-17786-17962-18214 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-91
 28-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788 sum: 594578 positions: 407371,8480,0,3444,250
       Entry 4: count: 1000 hasNull: false min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210-17268-17786-17962-18214-18444-18446-18724-18912-18952-19164 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8
 390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788-19204-19254-19518-19596-19786-19874-19904 sum: 631944 positions: 562094,3058,0,4643,292
-  Stripe: offset: 1842847 data: 188033 rows: 1000 tail: 67 index: 841
-    Stream: column 0 section ROW_INDEX start: 1842847 length 12
-    Stream: column 1 section ROW_INDEX start: 1842859 length 38
-    Stream: column 2 section ROW_INDEX start: 1842897 length 41
-    Stream: column 3 section ROW_INDEX start: 1842938 length 750
-    Stream: column 1 section DATA start: 1843688 length 4007
-    Stream: column 2 section DATA start: 1847695 length 8007
-    Stream: column 3 section DATA start: 1855702 length 174759
-    Stream: column 3 section LENGTH start: 2030461 length 1260
+  Stripe: offset: 1842895 data: 188033 rows: 1000 tail: 79 index: 841
+    Stream: column 0 section ROW_INDEX start: 1842895 length 12
+    Stream: column 1 section ROW_INDEX start: 1842907 length 38
+    Stream: column 2 section ROW_INDEX start: 1842945 length 41
+    Stream: column 3 section ROW_INDEX start: 1842986 length 750
+    Stream: column 1 section DATA start: 1843736 length 4007
+    Stream: column 2 section DATA start: 1847743 length 8007
+    Stream: column 3 section DATA start: 1855750 length 174759
+    Stream: column 3 section LENGTH start: 2030509 length 1260
     Encoding column 0: DIRECT
     Encoding column 1: DIRECT_V2
     Encoding column 2: DIRECT_V2
@@ -183,6 +183,6 @@ Stripes:
     Row group indices for column 3:
       Entry 0: count: 1000 hasNull: false min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210-17268-17786-17962-18214-18444-18446-18724-18912-18952-19164-19348-19400-19546-19776-19896-20084 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-
 7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788-19204-19254-19518-19596-19786-19874-19904-20390-20752-20936 sum: 670762 positions: 0,0,0,0,0
 
-File length: 2033643 bytes
+File length: 2033704 bytes
 Padding length: 0 bytes
 Padding ratio: 0%



Mime
View raw message