You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/09/15 19:23:55 UTC
svn commit: r1523463 [2/5] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/common/type/
common/src/test/org/apache/hadoop/hive/common/type/ data/files/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/parse/ ql...
Added: hive/trunk/ql/src/test/queries/clientnegative/invalid_varchar_length_3.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/invalid_varchar_length_3.q?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/invalid_varchar_length_3.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/invalid_varchar_length_3.q Sun Sep 15 17:23:53 2013
@@ -0,0 +1,3 @@
+drop table if exists invalid_varchar_length_3;
+create table invalid_varchar_length_3 (c1 varchar(0));
+
Added: hive/trunk/ql/src/test/queries/clientpositive/alter_varchar1.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/alter_varchar1.q?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/alter_varchar1.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/alter_varchar1.q Sun Sep 15 17:23:53 2013
@@ -0,0 +1,32 @@
+drop table alter_varchar_1;
+
+create table alter_varchar_1 (key string, value string);
+insert overwrite table alter_varchar_1
+ select key, value from src limit 5;
+
+select * from alter_varchar_1;
+
+-- change column to varchar
+alter table alter_varchar_1 change column value value varchar(20);
+-- contents should still look the same
+select * from alter_varchar_1;
+
+-- change column to smaller varchar
+alter table alter_varchar_1 change column value value varchar(3);
+-- value column should be truncated now
+select * from alter_varchar_1;
+
+-- change back to bigger varchar
+alter table alter_varchar_1 change column value value varchar(20);
+-- column values should be full size again
+select * from alter_varchar_1;
+
+-- add varchar column
+alter table alter_varchar_1 add columns (key2 int, value2 varchar(10));
+select * from alter_varchar_1;
+
+insert overwrite table alter_varchar_1
+ select key, value, key, value from src limit 5;
+select * from alter_varchar_1;
+
+drop table alter_varchar_1;
Added: hive/trunk/ql/src/test/queries/clientpositive/ctas_varchar.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/ctas_varchar.q?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/ctas_varchar.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/ctas_varchar.q Sun Sep 15 17:23:53 2013
@@ -0,0 +1,22 @@
+drop table ctas_varchar_1;
+drop table ctas_varchar_2;
+drop view ctas_varchar_3;
+
+create table ctas_varchar_1 (key varchar(10), value string);
+insert overwrite table ctas_varchar_1
+ select key, value from src sort by key, value limit 5;
+
+-- create table as with varchar column
+create table ctas_varchar_2 as select key, value from ctas_varchar_1;
+
+-- view with varchar column
+create view ctas_varchar_3 as select key, value from ctas_varchar_2;
+
+select key, value from ctas_varchar_1;
+select * from ctas_varchar_2;
+select * from ctas_varchar_3;
+
+
+drop table ctas_varchar_1;
+drop table ctas_varchar_2;
+drop view ctas_varchar_3;
Added: hive/trunk/ql/src/test/queries/clientpositive/partition_varchar1.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/partition_varchar1.q?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/partition_varchar1.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/partition_varchar1.q Sun Sep 15 17:23:53 2013
@@ -0,0 +1,43 @@
+drop table partition_varchar_1;
+
+create table partition_varchar_1 (key string, value varchar(20)) partitioned by (dt varchar(10), region int);
+
+insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=1)
+ select * from src limit 10;
+insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=2)
+ select * from src limit 5;
+insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=1)
+ select * from src limit 20;
+insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=10)
+ select * from src limit 11;
+
+select distinct dt from partition_varchar_1;
+select * from partition_varchar_1 where dt = '2000-01-01' and region = 2 order by key,value;
+
+-- 15
+select count(*) from partition_varchar_1 where dt = '2000-01-01';
+-- 5
+select count(*) from partition_varchar_1 where dt = '2000-01-01' and region = 2;
+-- 11
+select count(*) from partition_varchar_1 where dt = '2013-08-08' and region = 10;
+-- 30
+select count(*) from partition_varchar_1 where region = 1;
+-- 0
+select count(*) from partition_varchar_1 where dt = '2000-01-01' and region = 3;
+-- 0
+select count(*) from partition_varchar_1 where dt = '1999-01-01';
+
+-- Try other comparison operations
+
+-- 20
+select count(*) from partition_varchar_1 where dt > '2000-01-01' and region = 1;
+-- 10
+select count(*) from partition_varchar_1 where dt < '2000-01-02' and region = 1;
+-- 20
+select count(*) from partition_varchar_1 where dt >= '2000-01-02' and region = 1;
+-- 10
+select count(*) from partition_varchar_1 where dt <= '2000-01-01' and region = 1;
+-- 20
+select count(*) from partition_varchar_1 where dt <> '2000-01-01' and region = 1;
+
+drop table partition_varchar_1;
Added: hive/trunk/ql/src/test/queries/clientpositive/varchar_1.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/varchar_1.q?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/varchar_1.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/varchar_1.q Sun Sep 15 17:23:53 2013
@@ -0,0 +1,32 @@
+drop table varchar1;
+drop table varchar1_1;
+
+create table varchar1 (key varchar(10), value varchar(20));
+create table varchar1_1 (key string, value string);
+
+-- load from file
+load data local inpath '../data/files/srcbucket0.txt' overwrite into table varchar1;
+select * from varchar1 limit 2;
+
+-- insert overwrite, from same/different length varchar
+insert overwrite table varchar1
+ select cast(key as varchar(10)), cast(value as varchar(15)) from src limit 2;
+select key, value from varchar1;
+
+-- insert overwrite, from string
+insert overwrite table varchar1
+ select key, value from src limit 2;
+select key, value from varchar1;
+
+-- insert string from varchar
+insert overwrite table varchar1_1
+ select key, value from varchar1 limit 2;
+select key, value from varchar1_1;
+
+-- respect string length
+insert overwrite table varchar1
+ select key, cast(value as varchar(3)) from src limit 2;
+select key, value from varchar1;
+
+drop table varchar1;
+drop table varchar1_1;
Added: hive/trunk/ql/src/test/queries/clientpositive/varchar_2.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/varchar_2.q?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/varchar_2.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/varchar_2.q Sun Sep 15 17:23:53 2013
@@ -0,0 +1,36 @@
+drop table varchar_2;
+
+create table varchar_2 (
+ key varchar(10),
+ value varchar(20)
+);
+
+insert overwrite table varchar_2 select * from src;
+
+select value, sum(cast(key as int)), count(*) numrows
+from src
+group by value
+order by value asc
+limit 5;
+
+-- should match the query from src
+select value, sum(cast(key as int)), count(*) numrows
+from varchar_2
+group by value
+order by value asc
+limit 5;
+
+select value, sum(cast(key as int)), count(*) numrows
+from src
+group by value
+order by value desc
+limit 5;
+
+-- should match the query from src
+select value, sum(cast(key as int)), count(*) numrows
+from varchar_2
+group by value
+order by value desc
+limit 5;
+
+drop table varchar_2;
Added: hive/trunk/ql/src/test/queries/clientpositive/varchar_cast.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/varchar_cast.q?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/varchar_cast.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/varchar_cast.q Sun Sep 15 17:23:53 2013
@@ -0,0 +1,84 @@
+
+-- Cast from varchar to other data types
+select
+ cast(cast('11' as string) as tinyint),
+ cast(cast('11' as string) as smallint),
+ cast(cast('11' as string) as int),
+ cast(cast('11' as string) as bigint),
+ cast(cast('11.00' as string) as float),
+ cast(cast('11.00' as string) as double),
+ cast(cast('11.00' as string) as decimal)
+from src limit 1;
+
+select
+ cast(cast('11' as varchar(10)) as tinyint),
+ cast(cast('11' as varchar(10)) as smallint),
+ cast(cast('11' as varchar(10)) as int),
+ cast(cast('11' as varchar(10)) as bigint),
+ cast(cast('11.00' as varchar(10)) as float),
+ cast(cast('11.00' as varchar(10)) as double),
+ cast(cast('11.00' as varchar(10)) as decimal)
+from src limit 1;
+
+select
+ cast(cast('2011-01-01' as string) as date),
+ cast(cast('2011-01-01 01:02:03' as string) as timestamp)
+from src limit 1;
+
+select
+ cast(cast('2011-01-01' as varchar(10)) as date),
+ cast(cast('2011-01-01 01:02:03' as varchar(30)) as timestamp)
+from src limit 1;
+
+-- no tests from string/varchar to boolean, that conversion doesn't look useful
+select
+ cast(cast('abc123' as string) as string),
+ cast(cast('abc123' as string) as varchar(10))
+from src limit 1;
+
+select
+ cast(cast('abc123' as varchar(10)) as string),
+ cast(cast('abc123' as varchar(10)) as varchar(10))
+from src limit 1;
+
+-- cast from other types to varchar
+select
+ cast(cast(11 as tinyint) as string),
+ cast(cast(11 as smallint) as string),
+ cast(cast(11 as int) as string),
+ cast(cast(11 as bigint) as string),
+ cast(cast(11.00 as float) as string),
+ cast(cast(11.00 as double) as string),
+ cast(cast(11.00 as decimal) as string)
+from src limit 1;
+
+select
+ cast(cast(11 as tinyint) as varchar(10)),
+ cast(cast(11 as smallint) as varchar(10)),
+ cast(cast(11 as int) as varchar(10)),
+ cast(cast(11 as bigint) as varchar(10)),
+ cast(cast(11.00 as float) as varchar(10)),
+ cast(cast(11.00 as double) as varchar(10)),
+ cast(cast(11.00 as decimal) as varchar(10))
+from src limit 1;
+
+select
+ cast(date '2011-01-01' as string),
+ cast(timestamp('2011-01-01 01:02:03') as string)
+from src limit 1;
+
+select
+ cast(date '2011-01-01' as varchar(10)),
+ cast(timestamp('2011-01-01 01:02:03') as varchar(30))
+from src limit 1;
+
+select
+ cast(true as string),
+ cast(false as string)
+from src limit 1;
+
+select
+ cast(true as varchar(10)),
+ cast(false as varchar(10))
+from src limit 1;
+
Added: hive/trunk/ql/src/test/queries/clientpositive/varchar_comparison.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/varchar_comparison.q?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/varchar_comparison.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/varchar_comparison.q Sun Sep 15 17:23:53 2013
@@ -0,0 +1,40 @@
+
+-- Should all be true
+select
+ cast('abc' as varchar(10)) = cast('abc' as varchar(10)),
+ cast('abc' as varchar(10)) <= cast('abc' as varchar(10)),
+ cast('abc' as varchar(10)) >= cast('abc' as varchar(10)),
+ cast('abc' as varchar(10)) < cast('abd' as varchar(10)),
+ cast('abc' as varchar(10)) > cast('abb' as varchar(10)),
+ cast('abc' as varchar(10)) <> cast('abb' as varchar(10))
+from src limit 1;
+
+-- Different varchar lengths should still compare the same
+select
+ cast('abc' as varchar(10)) = cast('abc' as varchar(3)),
+ cast('abc' as varchar(10)) <= cast('abc' as varchar(3)),
+ cast('abc' as varchar(10)) >= cast('abc' as varchar(3)),
+ cast('abc' as varchar(10)) < cast('abd' as varchar(3)),
+ cast('abc' as varchar(10)) > cast('abb' as varchar(3)),
+ cast('abc' as varchar(10)) <> cast('abb' as varchar(3))
+from src limit 1;
+
+-- Should work with string types as well
+select
+ cast('abc' as varchar(10)) = 'abc',
+ cast('abc' as varchar(10)) <= 'abc',
+ cast('abc' as varchar(10)) >= 'abc',
+ cast('abc' as varchar(10)) < 'abd',
+ cast('abc' as varchar(10)) > 'abb',
+ cast('abc' as varchar(10)) <> 'abb'
+from src limit 1;
+
+-- leading space is significant for varchar
+select
+ cast(' abc' as varchar(10)) <> cast('abc' as varchar(10))
+from src limit 1;
+
+-- trailing space is significant for varchar
+select
+ cast('abc ' as varchar(10)) <> cast('abc' as varchar(10))
+from src limit 1;
Added: hive/trunk/ql/src/test/queries/clientpositive/varchar_join1.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/varchar_join1.q?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/varchar_join1.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/varchar_join1.q Sun Sep 15 17:23:53 2013
@@ -0,0 +1,35 @@
+drop table varchar_join1_vc1;
+drop table varchar_join1_vc2;
+drop table varchar_join1_str;
+
+create table varchar_join1_vc1 (
+ c1 int,
+ c2 varchar(10)
+);
+
+create table varchar_join1_vc2 (
+ c1 int,
+ c2 varchar(20)
+);
+
+create table varchar_join1_str (
+ c1 int,
+ c2 string
+);
+
+load data local inpath '../data/files/vc1.txt' into table varchar_join1_vc1;
+load data local inpath '../data/files/vc1.txt' into table varchar_join1_vc2;
+load data local inpath '../data/files/vc1.txt' into table varchar_join1_str;
+
+-- Join varchar with same length varchar
+select * from varchar_join1_vc1 a join varchar_join1_vc1 b on (a.c2 = b.c2) order by a.c1;
+
+-- Join varchar with different length varchar
+select * from varchar_join1_vc1 a join varchar_join1_vc2 b on (a.c2 = b.c2) order by a.c1;
+
+-- Join varchar with string
+select * from varchar_join1_vc1 a join varchar_join1_str b on (a.c2 = b.c2) order by a.c1;
+
+drop table varchar_join1_vc1;
+drop table varchar_join1_vc2;
+drop table varchar_join1_str;
Added: hive/trunk/ql/src/test/queries/clientpositive/varchar_nested_types.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/varchar_nested_types.q?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/varchar_nested_types.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/varchar_nested_types.q Sun Sep 15 17:23:53 2013
@@ -0,0 +1,53 @@
+drop table varchar_nested_1;
+drop table varchar_nested_array;
+drop table varchar_nested_map;
+drop table varchar_nested_struct;
+drop table varchar_nested_cta;
+drop table varchar_nested_view;
+
+create table varchar_nested_1 (key int, value varchar(20));
+insert overwrite table varchar_nested_1
+ select key, value from src limit 5;
+
+-- arrays
+create table varchar_nested_array (c1 array<varchar(20)>);
+insert overwrite table varchar_nested_array
+ select array(value, value) from varchar_nested_1;
+describe varchar_nested_array;
+select * from varchar_nested_array;
+
+-- maps
+create table varchar_nested_map (c1 map<int, varchar(20)>);
+insert overwrite table varchar_nested_map
+ select map(key, value) from varchar_nested_1;
+describe varchar_nested_map;
+select * from varchar_nested_map;
+
+-- structs
+create table varchar_nested_struct (c1 struct<a:int, b:varchar(20), c:string>);
+insert overwrite table varchar_nested_struct
+ select named_struct('a', key,
+ 'b', value,
+ 'c', cast(value as string))
+ from varchar_nested_1;
+describe varchar_nested_struct;
+select * from varchar_nested_struct;
+
+-- nested type with create table as
+create table varchar_nested_cta as
+ select * from varchar_nested_struct;
+describe varchar_nested_cta;
+select * from varchar_nested_cta;
+
+-- nested type with view
+create table varchar_nested_view as
+ select * from varchar_nested_struct;
+describe varchar_nested_view;
+select * from varchar_nested_view;
+
+drop table varchar_nested_1;
+drop table varchar_nested_array;
+drop table varchar_nested_map;
+drop table varchar_nested_struct;
+drop table varchar_nested_cta;
+drop table varchar_nested_view;
Added: hive/trunk/ql/src/test/queries/clientpositive/varchar_udf1.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/varchar_udf1.q?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/varchar_udf1.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/varchar_udf1.q Sun Sep 15 17:23:53 2013
@@ -0,0 +1,156 @@
+drop table varchar_udf_1;
+
+create table varchar_udf_1 (c1 string, c2 string, c3 varchar(10), c4 varchar(20));
+insert overwrite table varchar_udf_1
+ select key, value, key, value from src limit 5;
+
+-- UDFs with varchar support
+select
+ concat(c1, c2),
+ concat(c3, c4),
+ concat(c1, c2) = concat(c3, c4)
+from varchar_udf_1 limit 1;
+
+select
+ upper(c2),
+ upper(c4),
+ upper(c2) = upper(c4)
+from varchar_udf_1 limit 1;
+
+select
+ lower(c2),
+ lower(c4),
+ lower(c2) = lower(c4)
+from varchar_udf_1 limit 1;
+
+-- Scalar UDFs
+select
+ ascii(c2),
+ ascii(c4),
+ ascii(c2) = ascii(c4)
+from varchar_udf_1 limit 1;
+
+select
+ concat_ws('|', c1, c2),
+ concat_ws('|', c3, c4),
+ concat_ws('|', c1, c2) = concat_ws('|', c3, c4)
+from varchar_udf_1 limit 1;
+
+select
+ decode(encode(c2, 'US-ASCII'), 'US-ASCII'),
+ decode(encode(c4, 'US-ASCII'), 'US-ASCII'),
+ decode(encode(c2, 'US-ASCII'), 'US-ASCII') = decode(encode(c4, 'US-ASCII'), 'US-ASCII')
+from varchar_udf_1 limit 1;
+
+select
+ instr(c2, '_'),
+ instr(c4, '_'),
+ instr(c2, '_') = instr(c4, '_')
+from varchar_udf_1 limit 1;
+
+select
+ length(c2),
+ length(c4),
+ length(c2) = length(c4)
+from varchar_udf_1 limit 1;
+
+select
+ locate('a', 'abcdabcd', 3),
+ locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3),
+ locate('a', 'abcdabcd', 3) = locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3)
+from varchar_udf_1 limit 1;
+
+select
+ lpad(c2, 15, ' '),
+ lpad(c4, 15, ' '),
+ lpad(c2, 15, ' ') = lpad(c4, 15, ' ')
+from varchar_udf_1 limit 1;
+
+select
+ ltrim(c2),
+ ltrim(c4),
+ ltrim(c2) = ltrim(c4)
+from varchar_udf_1 limit 1;
+
+select
+ regexp(c2, 'val'),
+ regexp(c4, 'val'),
+ regexp(c2, 'val') = regexp(c4, 'val')
+from varchar_udf_1 limit 1;
+
+select
+ regexp_extract(c2, 'val_([0-9]+)', 1),
+ regexp_extract(c4, 'val_([0-9]+)', 1),
+ regexp_extract(c2, 'val_([0-9]+)', 1) = regexp_extract(c4, 'val_([0-9]+)', 1)
+from varchar_udf_1 limit 1;
+
+select
+ regexp_replace(c2, 'val', 'replaced'),
+ regexp_replace(c4, 'val', 'replaced'),
+ regexp_replace(c2, 'val', 'replaced') = regexp_replace(c4, 'val', 'replaced')
+from varchar_udf_1 limit 1;
+
+select
+ reverse(c2),
+ reverse(c4),
+ reverse(c2) = reverse(c4)
+from varchar_udf_1 limit 1;
+
+select
+ rpad(c2, 15, ' '),
+ rpad(c4, 15, ' '),
+ rpad(c2, 15, ' ') = rpad(c4, 15, ' ')
+from varchar_udf_1 limit 1;
+
+select
+ rtrim(c2),
+ rtrim(c4),
+ rtrim(c2) = rtrim(c4)
+from varchar_udf_1 limit 1;
+
+select
+ sentences('See spot run. See jane run.'),
+ sentences(cast('See spot run. See jane run.' as varchar(50)))
+from varchar_udf_1 limit 1;
+
+select
+ split(c2, '_'),
+ split(c4, '_')
+from varchar_udf_1 limit 1;
+
+select
+ str_to_map('a:1,b:2,c:3',',',':'),
+ str_to_map(cast('a:1,b:2,c:3' as varchar(20)),',',':')
+from varchar_udf_1 limit 1;
+
+select
+ substr(c2, 1, 3),
+ substr(c4, 1, 3),
+ substr(c2, 1, 3) = substr(c4, 1, 3)
+from varchar_udf_1 limit 1;
+
+select
+ trim(c2),
+ trim(c4),
+ trim(c2) = trim(c4)
+from varchar_udf_1 limit 1;
+
+
+-- Aggregate Functions
+select
+ compute_stats(c2, 16),
+ compute_stats(c4, 16)
+from varchar_udf_1;
+
+select
+ min(c2),
+ min(c4)
+from varchar_udf_1;
+
+select
+ max(c2),
+ max(c4)
+from varchar_udf_1;
+
+
+drop table varchar_udf_1;
Added: hive/trunk/ql/src/test/queries/clientpositive/varchar_union1.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/varchar_union1.q?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/varchar_union1.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/varchar_union1.q Sun Sep 15 17:23:53 2013
@@ -0,0 +1,47 @@
+drop table varchar_union1_vc1;
+drop table varchar_union1_vc2;
+drop table varchar_union1_str;
+
+create table varchar_union1_vc1 (
+ c1 int,
+ c2 varchar(10)
+);
+
+create table varchar_union1_vc2 (
+ c1 int,
+ c2 varchar(20)
+);
+
+create table varchar_union1_str (
+ c1 int,
+ c2 string
+);
+
+load data local inpath '../data/files/vc1.txt' into table varchar_union1_vc1;
+load data local inpath '../data/files/vc1.txt' into table varchar_union1_vc2;
+load data local inpath '../data/files/vc1.txt' into table varchar_union1_str;
+
+-- union varchar with same length varchar
+select * from (
+ select * from varchar_union1_vc1
+ union all
+ select * from varchar_union1_vc1 limit 1
+) q1 sort by c1;
+
+-- union varchar with different length varchar
+select * from (
+ select * from varchar_union1_vc1
+ union all
+ select * from varchar_union1_vc2 limit 1
+) q1 sort by c1;
+
+-- union varchar with string
+select * from (
+ select * from varchar_union1_vc1
+ union all
+ select * from varchar_union1_str limit 1
+) q1 sort by c1;
+
+drop table varchar_union1_vc1;
+drop table varchar_union1_vc2;
+drop table varchar_union1_str;
Added: hive/trunk/ql/src/test/results/clientnegative/invalid_varchar_length_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/invalid_varchar_length_1.q.out?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/invalid_varchar_length_1.q.out (added)
+++ hive/trunk/ql/src/test/results/clientnegative/invalid_varchar_length_1.q.out Sun Sep 15 17:23:53 2013
@@ -0,0 +1,5 @@
+PREHOOK: query: drop table if exists invalid_varchar_length_1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists invalid_varchar_length_1
+POSTHOOK: type: DROPTABLE
+FAILED: SemanticException org.apache.hadoop.hive.serde2.SerDeException: Length 1000000 exceeds max varchar length of 65535
Added: hive/trunk/ql/src/test/results/clientnegative/invalid_varchar_length_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/invalid_varchar_length_2.q.out?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/invalid_varchar_length_2.q.out (added)
+++ hive/trunk/ql/src/test/results/clientnegative/invalid_varchar_length_2.q.out Sun Sep 15 17:23:53 2013
@@ -0,0 +1 @@
+FAILED: RuntimeException Error creating type parameters for varchar(100000): org.apache.hadoop.hive.serde2.SerDeException: Error creating type params for varchar: org.apache.hadoop.hive.serde2.SerDeException: Length 100000 exceeds max varchar length of 65535
Added: hive/trunk/ql/src/test/results/clientnegative/invalid_varchar_length_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/invalid_varchar_length_3.q.out?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/invalid_varchar_length_3.q.out (added)
+++ hive/trunk/ql/src/test/results/clientnegative/invalid_varchar_length_3.q.out Sun Sep 15 17:23:53 2013
@@ -0,0 +1,5 @@
+PREHOOK: query: drop table if exists invalid_varchar_length_3
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists invalid_varchar_length_3
+POSTHOOK: type: DROPTABLE
+FAILED: SemanticException org.apache.hadoop.hive.serde2.SerDeException: VARCHAR length must be positive
Added: hive/trunk/ql/src/test/results/clientpositive/alter_varchar1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_varchar1.q.out?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_varchar1.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_varchar1.q.out Sun Sep 15 17:23:53 2013
@@ -0,0 +1,199 @@
+PREHOOK: query: drop table alter_varchar_1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table alter_varchar_1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table alter_varchar_1 (key string, value string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table alter_varchar_1 (key string, value string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@alter_varchar_1
+PREHOOK: query: insert overwrite table alter_varchar_1
+ select key, value from src limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@alter_varchar_1
+POSTHOOK: query: insert overwrite table alter_varchar_1
+ select key, value from src limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@alter_varchar_1
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select * from alter_varchar_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from alter_varchar_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+238 val_238
+86 val_86
+311 val_311
+27 val_27
+165 val_165
+PREHOOK: query: -- change column to varchar
+alter table alter_varchar_1 change column value value varchar(20)
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@alter_varchar_1
+PREHOOK: Output: default@alter_varchar_1
+POSTHOOK: query: -- change column to varchar
+alter table alter_varchar_1 change column value value varchar(20)
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: default@alter_varchar_1
+POSTHOOK: Output: default@alter_varchar_1
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: -- contents should still look the same
+select * from alter_varchar_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: query: -- contents should still look the same
+select * from alter_varchar_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+238 val_238
+86 val_86
+311 val_311
+27 val_27
+165 val_165
+PREHOOK: query: -- change column to smaller varchar
+alter table alter_varchar_1 change column value value varchar(3)
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@alter_varchar_1
+PREHOOK: Output: default@alter_varchar_1
+POSTHOOK: query: -- change column to smaller varchar
+alter table alter_varchar_1 change column value value varchar(3)
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: default@alter_varchar_1
+POSTHOOK: Output: default@alter_varchar_1
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: -- value column should be truncated now
+select * from alter_varchar_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: query: -- value column should be truncated now
+select * from alter_varchar_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+238 val
+86 val
+311 val
+27 val
+165 val
+PREHOOK: query: -- change back to bigger varchar
+alter table alter_varchar_1 change column value value varchar(20)
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@alter_varchar_1
+PREHOOK: Output: default@alter_varchar_1
+POSTHOOK: query: -- change back to bigger varchar
+alter table alter_varchar_1 change column value value varchar(20)
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: default@alter_varchar_1
+POSTHOOK: Output: default@alter_varchar_1
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: -- column values should be full size again
+select * from alter_varchar_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: query: -- column values should be full size again
+select * from alter_varchar_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+238 val_238
+86 val_86
+311 val_311
+27 val_27
+165 val_165
+PREHOOK: query: -- add varchar column
+alter table alter_varchar_1 add columns (key2 int, value2 varchar(10))
+PREHOOK: type: ALTERTABLE_ADDCOLS
+PREHOOK: Input: default@alter_varchar_1
+PREHOOK: Output: default@alter_varchar_1
+POSTHOOK: query: -- add varchar column
+alter table alter_varchar_1 add columns (key2 int, value2 varchar(10))
+POSTHOOK: type: ALTERTABLE_ADDCOLS
+POSTHOOK: Input: default@alter_varchar_1
+POSTHOOK: Output: default@alter_varchar_1
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select * from alter_varchar_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from alter_varchar_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+238 val_238 NULL NULL
+86 val_86 NULL NULL
+311 val_311 NULL NULL
+27 val_27 NULL NULL
+165 val_165 NULL NULL
+PREHOOK: query: insert overwrite table alter_varchar_1
+ select key, value, key, value from src limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@alter_varchar_1
+POSTHOOK: query: insert overwrite table alter_varchar_1
+ select key, value, key, value from src limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@alter_varchar_1
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.key2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select * from alter_varchar_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from alter_varchar_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.key2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+238 val_238 238 val_238
+86 val_86 86 val_86
+311 val_311 311 val_311
+27 val_27 27 val_27
+165 val_165 165 val_165
+PREHOOK: query: drop table alter_varchar_1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@alter_varchar_1
+PREHOOK: Output: default@alter_varchar_1
+POSTHOOK: query: drop table alter_varchar_1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@alter_varchar_1
+POSTHOOK: Output: default@alter_varchar_1
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.key2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar_1.value2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Added: hive/trunk/ql/src/test/results/clientpositive/ctas_varchar.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_varchar.q.out?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_varchar.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_varchar.q.out Sun Sep 15 17:23:53 2013
@@ -0,0 +1,126 @@
+PREHOOK: query: drop table ctas_varchar_1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table ctas_varchar_1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table ctas_varchar_2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table ctas_varchar_2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop view ctas_varchar_3
+PREHOOK: type: DROPVIEW
+POSTHOOK: query: drop view ctas_varchar_3
+POSTHOOK: type: DROPVIEW
+PREHOOK: query: create table ctas_varchar_1 (key varchar(10), value string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table ctas_varchar_1 (key varchar(10), value string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@ctas_varchar_1
+PREHOOK: query: insert overwrite table ctas_varchar_1
+ select key, value from src sort by key, value limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@ctas_varchar_1
+POSTHOOK: query: insert overwrite table ctas_varchar_1
+ select key, value from src sort by key, value limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@ctas_varchar_1
+POSTHOOK: Lineage: ctas_varchar_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ctas_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: -- create table as with varchar column
+create table ctas_varchar_2 as select key, value from ctas_varchar_1
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@ctas_varchar_1
+POSTHOOK: query: -- create table as with varchar column
+create table ctas_varchar_2 as select key, value from ctas_varchar_1
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@ctas_varchar_1
+POSTHOOK: Output: default@ctas_varchar_2
+POSTHOOK: Lineage: ctas_varchar_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ctas_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: -- view with varchar column
+create view ctas_varchar_3 as select key, value from ctas_varchar_2
+PREHOOK: type: CREATEVIEW
+POSTHOOK: query: -- view with varchar column
+create view ctas_varchar_3 as select key, value from ctas_varchar_2
+POSTHOOK: type: CREATEVIEW
+POSTHOOK: Output: default@ctas_varchar_3
+POSTHOOK: Lineage: ctas_varchar_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ctas_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select key, value from ctas_varchar_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@ctas_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: query: select key, value from ctas_varchar_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@ctas_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: ctas_varchar_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ctas_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0 val_0
+0 val_0
+0 val_0
+10 val_10
+100 val_100
+PREHOOK: query: select * from ctas_varchar_2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@ctas_varchar_2
+#### A masked pattern was here ####
+POSTHOOK: query: select * from ctas_varchar_2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@ctas_varchar_2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: ctas_varchar_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ctas_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0 val_0
+0 val_0
+0 val_0
+10 val_10
+100 val_100
+PREHOOK: query: select * from ctas_varchar_3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@ctas_varchar_2
+PREHOOK: Input: default@ctas_varchar_3
+#### A masked pattern was here ####
+POSTHOOK: query: select * from ctas_varchar_3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@ctas_varchar_2
+POSTHOOK: Input: default@ctas_varchar_3
+#### A masked pattern was here ####
+POSTHOOK: Lineage: ctas_varchar_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ctas_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0 val_0
+0 val_0
+0 val_0
+10 val_10
+100 val_100
+PREHOOK: query: drop table ctas_varchar_1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@ctas_varchar_1
+PREHOOK: Output: default@ctas_varchar_1
+POSTHOOK: query: drop table ctas_varchar_1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@ctas_varchar_1
+POSTHOOK: Output: default@ctas_varchar_1
+POSTHOOK: Lineage: ctas_varchar_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ctas_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: drop table ctas_varchar_2
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@ctas_varchar_2
+PREHOOK: Output: default@ctas_varchar_2
+POSTHOOK: query: drop table ctas_varchar_2
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@ctas_varchar_2
+POSTHOOK: Output: default@ctas_varchar_2
+POSTHOOK: Lineage: ctas_varchar_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ctas_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: drop view ctas_varchar_3
+PREHOOK: type: DROPVIEW
+PREHOOK: Input: default@ctas_varchar_3
+PREHOOK: Output: default@ctas_varchar_3
+POSTHOOK: query: drop view ctas_varchar_3
+POSTHOOK: type: DROPVIEW
+POSTHOOK: Input: default@ctas_varchar_3
+POSTHOOK: Output: default@ctas_varchar_3
+POSTHOOK: Lineage: ctas_varchar_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ctas_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Added: hive/trunk/ql/src/test/results/clientpositive/partition_varchar1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/partition_varchar1.q.out?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/partition_varchar1.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/partition_varchar1.q.out Sun Sep 15 17:23:53 2013
@@ -0,0 +1,369 @@
+PREHOOK: query: drop table partition_varchar_1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table partition_varchar_1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table partition_varchar_1 (key string, value varchar(20)) partitioned by (dt varchar(10), region int)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table partition_varchar_1 (key string, value varchar(20)) partitioned by (dt varchar(10), region int)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@partition_varchar_1
+PREHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=1)
+ select * from src limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@partition_varchar_1@dt=2000-01-01/region=1
+POSTHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=1)
+ select * from src limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@partition_varchar_1@dt=2000-01-01/region=1
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=2)
+ select * from src limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@partition_varchar_1@dt=2000-01-01/region=2
+POSTHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=2)
+ select * from src limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@partition_varchar_1@dt=2000-01-01/region=2
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=1)
+ select * from src limit 20
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@partition_varchar_1@dt=2013-08-08/region=1
+POSTHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=1)
+ select * from src limit 20
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@partition_varchar_1@dt=2013-08-08/region=1
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=10)
+ select * from src limit 11
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@partition_varchar_1@dt=2013-08-08/region=10
+POSTHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=10)
+ select * from src limit 11
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@partition_varchar_1@dt=2013-08-08/region=10
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select distinct dt from partition_varchar_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_varchar_1
+PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
+PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
+PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
+PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=10
+#### A masked pattern was here ####
+POSTHOOK: query: select distinct dt from partition_varchar_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_varchar_1
+POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
+POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
+POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
+POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=10
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+2000-01-01
+2013-08-08
+PREHOOK: query: select * from partition_varchar_1 where dt = '2000-01-01' and region = 2 order by key,value
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_varchar_1
+PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: query: select * from partition_varchar_1 where dt = '2000-01-01' and region = 2 order by key,value
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_varchar_1
+POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+165 val_165 2000-01-01 2
+238 val_238 2000-01-01 2
+27 val_27 2000-01-01 2
+311 val_311 2000-01-01 2
+86 val_86 2000-01-01 2
+PREHOOK: query: -- 15
+select count(*) from partition_varchar_1 where dt = '2000-01-01'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_varchar_1
+PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
+PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: query: -- 15
+select count(*) from partition_varchar_1 where dt = '2000-01-01'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_varchar_1
+POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
+POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+15
+PREHOOK: query: -- 5
+select count(*) from partition_varchar_1 where dt = '2000-01-01' and region = 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_varchar_1
+PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: query: -- 5
+select count(*) from partition_varchar_1 where dt = '2000-01-01' and region = 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_varchar_1
+POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+5
+PREHOOK: query: -- 11
+select count(*) from partition_varchar_1 where dt = '2013-08-08' and region = 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_varchar_1
+PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=10
+#### A masked pattern was here ####
+POSTHOOK: query: -- 11
+select count(*) from partition_varchar_1 where dt = '2013-08-08' and region = 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_varchar_1
+POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=10
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+11
+PREHOOK: query: -- 30
+select count(*) from partition_varchar_1 where region = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_varchar_1
+PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
+PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 30
+select count(*) from partition_varchar_1 where region = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_varchar_1
+POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
+POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+30
+PREHOOK: query: -- 0
+select count(*) from partition_varchar_1 where dt = '2000-01-01' and region = 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 0
+select count(*) from partition_varchar_1 where dt = '2000-01-01' and region = 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0
+PREHOOK: query: -- 0
+select count(*) from partition_varchar_1 where dt = '1999-01-01'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 0
+select count(*) from partition_varchar_1 where dt = '1999-01-01'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_varchar_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0
+PREHOOK: query: -- Try other comparison operations
+
+-- 20
+select count(*) from partition_varchar_1 where dt > '2000-01-01' and region = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_varchar_1
+PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: query: -- Try other comparison operations
+
+-- 20
+select count(*) from partition_varchar_1 where dt > '2000-01-01' and region = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_varchar_1
+POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+20
+PREHOOK: query: -- 10
+select count(*) from partition_varchar_1 where dt < '2000-01-02' and region = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_varchar_1
+PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 10
+select count(*) from partition_varchar_1 where dt < '2000-01-02' and region = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_varchar_1
+POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+10
+PREHOOK: query: -- 20
+select count(*) from partition_varchar_1 where dt >= '2000-01-02' and region = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_varchar_1
+PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 20
+select count(*) from partition_varchar_1 where dt >= '2000-01-02' and region = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_varchar_1
+POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+20
+PREHOOK: query: -- 10
+select count(*) from partition_varchar_1 where dt <= '2000-01-01' and region = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_varchar_1
+PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 10
+select count(*) from partition_varchar_1 where dt <= '2000-01-01' and region = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_varchar_1
+POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+10
+PREHOOK: query: -- 20
+select count(*) from partition_varchar_1 where dt <> '2000-01-01' and region = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_varchar_1
+PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 20
+select count(*) from partition_varchar_1 where dt <> '2000-01-01' and region = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_varchar_1
+POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+20
+PREHOOK: query: drop table partition_varchar_1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@partition_varchar_1
+PREHOOK: Output: default@partition_varchar_1
+POSTHOOK: query: drop table partition_varchar_1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@partition_varchar_1
+POSTHOOK: Output: default@partition_varchar_1
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Added: hive/trunk/ql/src/test/results/clientpositive/varchar_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/varchar_1.q.out?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/varchar_1.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/varchar_1.q.out Sun Sep 15 17:23:53 2013
@@ -0,0 +1,196 @@
+PREHOOK: query: drop table varchar1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table varchar1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table varchar1_1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table varchar1_1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table varchar1 (key varchar(10), value varchar(20))
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table varchar1 (key varchar(10), value varchar(20))
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@varchar1
+PREHOOK: query: create table varchar1_1 (key string, value string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table varchar1_1 (key string, value string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@varchar1_1
+PREHOOK: query: -- load from file
+load data local inpath '../data/files/srcbucket0.txt' overwrite into table varchar1
+PREHOOK: type: LOAD
+PREHOOK: Output: default@varchar1
+POSTHOOK: query: -- load from file
+load data local inpath '../data/files/srcbucket0.txt' overwrite into table varchar1
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@varchar1
+PREHOOK: query: select * from varchar1 limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@varchar1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from varchar1 limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@varchar1
+#### A masked pattern was here ####
+474 val_475
+62 val_63
+PREHOOK: query: -- insert overwrite, from same/different length varchar
+insert overwrite table varchar1
+ select cast(key as varchar(10)), cast(value as varchar(15)) from src limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@varchar1
+POSTHOOK: query: -- insert overwrite, from same/different length varchar
+insert overwrite table varchar1
+ select cast(key as varchar(10)), cast(value as varchar(15)) from src limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@varchar1
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select key, value from varchar1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@varchar1
+#### A masked pattern was here ####
+POSTHOOK: query: select key, value from varchar1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@varchar1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+238 val_238
+86 val_86
+PREHOOK: query: -- insert overwrite, from string
+insert overwrite table varchar1
+ select key, value from src limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@varchar1
+POSTHOOK: query: -- insert overwrite, from string
+insert overwrite table varchar1
+ select key, value from src limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@varchar1
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select key, value from varchar1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@varchar1
+#### A masked pattern was here ####
+POSTHOOK: query: select key, value from varchar1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@varchar1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+238 val_238
+86 val_86
+PREHOOK: query: -- insert string from varchar
+insert overwrite table varchar1_1
+ select key, value from varchar1 limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@varchar1
+PREHOOK: Output: default@varchar1_1
+POSTHOOK: query: -- insert string from varchar
+insert overwrite table varchar1_1
+ select key, value from varchar1 limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@varchar1
+POSTHOOK: Output: default@varchar1_1
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1_1.key SIMPLE [(varchar1)varchar1.FieldSchema(name:key, type:varchar(10), comment:null), ]
+POSTHOOK: Lineage: varchar1_1.value SIMPLE [(varchar1)varchar1.FieldSchema(name:value, type:varchar(20), comment:null), ]
+PREHOOK: query: select key, value from varchar1_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@varchar1_1
+#### A masked pattern was here ####
+POSTHOOK: query: select key, value from varchar1_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@varchar1_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1_1.key SIMPLE [(varchar1)varchar1.FieldSchema(name:key, type:varchar(10), comment:null), ]
+POSTHOOK: Lineage: varchar1_1.value SIMPLE [(varchar1)varchar1.FieldSchema(name:value, type:varchar(20), comment:null), ]
+238 val_238
+86 val_86
+PREHOOK: query: -- respect string length
+insert overwrite table varchar1
+ select key, cast(value as varchar(3)) from src limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@varchar1
+POSTHOOK: query: -- respect string length
+insert overwrite table varchar1
+ select key, cast(value as varchar(3)) from src limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@varchar1
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1_1.key SIMPLE [(varchar1)varchar1.FieldSchema(name:key, type:varchar(10), comment:null), ]
+POSTHOOK: Lineage: varchar1_1.value SIMPLE [(varchar1)varchar1.FieldSchema(name:value, type:varchar(20), comment:null), ]
+PREHOOK: query: select key, value from varchar1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@varchar1
+#### A masked pattern was here ####
+POSTHOOK: query: select key, value from varchar1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@varchar1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1_1.key SIMPLE [(varchar1)varchar1.FieldSchema(name:key, type:varchar(10), comment:null), ]
+POSTHOOK: Lineage: varchar1_1.value SIMPLE [(varchar1)varchar1.FieldSchema(name:value, type:varchar(20), comment:null), ]
+238 val
+86 val
+PREHOOK: query: drop table varchar1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@varchar1
+PREHOOK: Output: default@varchar1
+POSTHOOK: query: drop table varchar1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@varchar1
+POSTHOOK: Output: default@varchar1
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1_1.key SIMPLE [(varchar1)varchar1.FieldSchema(name:key, type:varchar(10), comment:null), ]
+POSTHOOK: Lineage: varchar1_1.value SIMPLE [(varchar1)varchar1.FieldSchema(name:value, type:varchar(20), comment:null), ]
+PREHOOK: query: drop table varchar1_1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@varchar1_1
+PREHOOK: Output: default@varchar1_1
+POSTHOOK: query: drop table varchar1_1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@varchar1_1
+POSTHOOK: Output: default@varchar1_1
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar1_1.key SIMPLE [(varchar1)varchar1.FieldSchema(name:key, type:varchar(10), comment:null), ]
+POSTHOOK: Lineage: varchar1_1.value SIMPLE [(varchar1)varchar1.FieldSchema(name:value, type:varchar(20), comment:null), ]
Added: hive/trunk/ql/src/test/results/clientpositive/varchar_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/varchar_2.q.out?rev=1523463&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/varchar_2.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/varchar_2.q.out Sun Sep 15 17:23:53 2013
@@ -0,0 +1,131 @@
+PREHOOK: query: drop table varchar_2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table varchar_2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table varchar_2 (
+ key varchar(10),
+ value varchar(20)
+)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table varchar_2 (
+ key varchar(10),
+ value varchar(20)
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@varchar_2
+PREHOOK: query: insert overwrite table varchar_2 select * from src
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@varchar_2
+POSTHOOK: query: insert overwrite table varchar_2 select * from src
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@varchar_2
+POSTHOOK: Lineage: varchar_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar_2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select value, sum(cast(key as int)), count(*) numrows
+from src
+group by value
+order by value asc
+limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select value, sum(cast(key as int)), count(*) numrows
+from src
+group by value
+order by value asc
+limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: Lineage: varchar_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar_2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+val_0 0 3
+val_10 10 1
+val_100 200 2
+val_103 206 2
+val_104 208 2
+PREHOOK: query: -- should match the query from src
+select value, sum(cast(key as int)), count(*) numrows
+from varchar_2
+group by value
+order by value asc
+limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@varchar_2
+#### A masked pattern was here ####
+POSTHOOK: query: -- should match the query from src
+select value, sum(cast(key as int)), count(*) numrows
+from varchar_2
+group by value
+order by value asc
+limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@varchar_2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: varchar_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar_2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+val_0 0 3
+val_10 10 1
+val_100 200 2
+val_103 206 2
+val_104 208 2
+PREHOOK: query: select value, sum(cast(key as int)), count(*) numrows
+from src
+group by value
+order by value desc
+limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select value, sum(cast(key as int)), count(*) numrows
+from src
+group by value
+order by value desc
+limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: Lineage: varchar_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar_2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+val_98 196 2
+val_97 194 2
+val_96 96 1
+val_95 190 2
+val_92 92 1
+PREHOOK: query: -- should match the query from src
+select value, sum(cast(key as int)), count(*) numrows
+from varchar_2
+group by value
+order by value desc
+limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@varchar_2
+#### A masked pattern was here ####
+POSTHOOK: query: -- should match the query from src
+select value, sum(cast(key as int)), count(*) numrows
+from varchar_2
+group by value
+order by value desc
+limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@varchar_2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: varchar_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar_2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+val_98 196 2
+val_97 194 2
+val_96 96 1
+val_95 190 2
+val_92 92 1
+PREHOOK: query: drop table varchar_2
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@varchar_2
+PREHOOK: Output: default@varchar_2
+POSTHOOK: query: drop table varchar_2
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@varchar_2
+POSTHOOK: Output: default@varchar_2
+POSTHOOK: Lineage: varchar_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: varchar_2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]