hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From xu...@apache.org
Subject svn commit: r1539530 [2/4] - in /hive/trunk: common/src/java/org/apache/hadoop/hive/common/type/ common/src/java/org/apache/hive/common/util/ common/src/test/org/apache/hadoop/hive/common/type/ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/or...
Date Thu, 07 Nov 2013 05:57:39 GMT
Added: hive/trunk/ql/src/test/results/clientpositive/alter_char1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_char1.q.out?rev=1539530&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_char1.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_char1.q.out Thu Nov  7 05:57:37 2013
@@ -0,0 +1,199 @@
+PREHOOK: query: drop table alter_char_1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table alter_char_1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table alter_char_1 (key string, value string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table alter_char_1 (key string, value string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@alter_char_1
+PREHOOK: query: insert overwrite table alter_char_1
+  select key, value from src order by key limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@alter_char_1
+POSTHOOK: query: insert overwrite table alter_char_1
+  select key, value from src order by key limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@alter_char_1
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select * from alter_char_1 order by key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_char_1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from alter_char_1 order by key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_char_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_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: -- change column to char
+alter table alter_char_1 change column value value char(20)
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@alter_char_1
+PREHOOK: Output: default@alter_char_1
+POSTHOOK: query: -- change column to char
+alter table alter_char_1 change column value value char(20)
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: default@alter_char_1
+POSTHOOK: Output: default@alter_char_1
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: -- contents should still look the same
+select * from alter_char_1 order by key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_char_1
+#### A masked pattern was here ####
+POSTHOOK: query: -- contents should still look the same
+select * from alter_char_1 order by key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_char_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_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: -- change column to smaller char
+alter table alter_char_1 change column value value char(3)
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@alter_char_1
+PREHOOK: Output: default@alter_char_1
+POSTHOOK: query: -- change column to smaller char
+alter table alter_char_1 change column value value char(3)
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: default@alter_char_1
+POSTHOOK: Output: default@alter_char_1
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: -- value column should be truncated now
+select * from alter_char_1 order by key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_char_1
+#### A masked pattern was here ####
+POSTHOOK: query: -- value column should be truncated now
+select * from alter_char_1 order by key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_char_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0	val
+0	val
+0	val
+10	val
+100	val
+PREHOOK: query: -- change back to bigger char
+alter table alter_char_1 change column value value char(20)
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@alter_char_1
+PREHOOK: Output: default@alter_char_1
+POSTHOOK: query: -- change back to bigger char
+alter table alter_char_1 change column value value char(20)
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: default@alter_char_1
+POSTHOOK: Output: default@alter_char_1
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: -- column values should be full size again
+select * from alter_char_1 order by key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_char_1
+#### A masked pattern was here ####
+POSTHOOK: query: -- column values should be full size again
+select * from alter_char_1 order by key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_char_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_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: -- add char column
+alter table alter_char_1 add columns (key2 int, value2 char(10))
+PREHOOK: type: ALTERTABLE_ADDCOLS
+PREHOOK: Input: default@alter_char_1
+PREHOOK: Output: default@alter_char_1
+POSTHOOK: query: -- add char column
+alter table alter_char_1 add columns (key2 int, value2 char(10))
+POSTHOOK: type: ALTERTABLE_ADDCOLS
+POSTHOOK: Input: default@alter_char_1
+POSTHOOK: Output: default@alter_char_1
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select * from alter_char_1 order by key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_char_1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from alter_char_1 order by key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_char_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0	val_0               	NULL	NULL
+0	val_0               	NULL	NULL
+0	val_0               	NULL	NULL
+10	val_10              	NULL	NULL
+100	val_100             	NULL	NULL
+PREHOOK: query: insert overwrite table alter_char_1
+  select key, value, key, value from src order by key limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@alter_char_1
+POSTHOOK: query: insert overwrite table alter_char_1
+  select key, value, key, value from src order by key limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@alter_char_1
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.key2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select * from alter_char_1 order by key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_char_1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from alter_char_1 order by key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_char_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.key2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0	val_0               	0	val_0     
+0	val_0               	0	val_0     
+0	val_0               	0	val_0     
+10	val_10              	10	val_10    
+100	val_100             	100	val_100   
+PREHOOK: query: drop table alter_char_1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@alter_char_1
+PREHOOK: Output: default@alter_char_1
+POSTHOOK: query: drop table alter_char_1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@alter_char_1
+POSTHOOK: Output: default@alter_char_1
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.key2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char_1.value2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]

Added: hive/trunk/ql/src/test/results/clientpositive/alter_char2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_char2.q.out?rev=1539530&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_char2.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_char2.q.out Thu Nov  7 05:57:37 2013
@@ -0,0 +1,97 @@
+PREHOOK: query: -- alter column type, with partitioned table
+drop table if exists alter_char2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: -- alter column type, with partitioned table
+drop table if exists alter_char2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table alter_char2 (
+  c1 char(255)
+) partitioned by (hr int)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table alter_char2 (
+  c1 char(255)
+) partitioned by (hr int)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@alter_char2
+PREHOOK: query: insert overwrite table alter_char2 partition (hr=1)
+  select value from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@alter_char2@hr=1
+POSTHOOK: query: insert overwrite table alter_char2 partition (hr=1)
+  select value from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@alter_char2@hr=1
+POSTHOOK: Lineage: alter_char2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select c1, length(c1) from alter_char2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_char2
+PREHOOK: Input: default@alter_char2@hr=1
+#### A masked pattern was here ####
+POSTHOOK: query: select c1, length(c1) from alter_char2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_char2
+POSTHOOK: Input: default@alter_char2@hr=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_char2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+val_238                                                                                                                                                                                                                                                        	7
+PREHOOK: query: alter table alter_char2 change column c1 c1 char(10)
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@alter_char2
+PREHOOK: Output: default@alter_char2
+POSTHOOK: query: alter table alter_char2 change column c1 c1 char(10)
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: default@alter_char2
+POSTHOOK: Output: default@alter_char2
+POSTHOOK: Lineage: alter_char2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select hr, c1, length(c1) from alter_char2 where hr = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_char2
+PREHOOK: Input: default@alter_char2@hr=1
+#### A masked pattern was here ####
+POSTHOOK: query: select hr, c1, length(c1) from alter_char2 where hr = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_char2
+POSTHOOK: Input: default@alter_char2@hr=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_char2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+1	val_238   	7
+PREHOOK: query: insert overwrite table alter_char2 partition (hr=2)
+  select key from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@alter_char2@hr=2
+POSTHOOK: query: insert overwrite table alter_char2 partition (hr=2)
+  select key from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@alter_char2@hr=2
+POSTHOOK: Lineage: alter_char2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char2 PARTITION(hr=2).c1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+PREHOOK: query: select hr, c1, length(c1) from alter_char2 where hr = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_char2
+PREHOOK: Input: default@alter_char2@hr=1
+#### A masked pattern was here ####
+POSTHOOK: query: select hr, c1, length(c1) from alter_char2 where hr = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_char2
+POSTHOOK: Input: default@alter_char2@hr=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_char2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char2 PARTITION(hr=2).c1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+1	val_238   	7
+PREHOOK: query: select hr, c1, length(c1) from alter_char2 where hr = 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_char2
+PREHOOK: Input: default@alter_char2@hr=2
+#### A masked pattern was here ####
+POSTHOOK: query: select hr, c1, length(c1) from alter_char2 where hr = 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_char2
+POSTHOOK: Input: default@alter_char2@hr=2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_char2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: alter_char2 PARTITION(hr=2).c1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+2	238       	3

Added: hive/trunk/ql/src/test/results/clientpositive/char_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/char_1.q.out?rev=1539530&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/char_1.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/char_1.q.out Thu Nov  7 05:57:37 2013
@@ -0,0 +1,196 @@
+PREHOOK: query: drop table char1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table char1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table char1_1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table char1_1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table char1 (key char(10), value char(20))
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table char1 (key char(10), value char(20))
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@char1
+PREHOOK: query: create table char1_1 (key string, value string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table char1_1 (key string, value string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@char1_1
+PREHOOK: query: -- load from file
+load data local inpath '../../data/files/srcbucket0.txt' overwrite into table char1
+PREHOOK: type: LOAD
+PREHOOK: Output: default@char1
+POSTHOOK: query: -- load from file
+load data local inpath '../../data/files/srcbucket0.txt' overwrite into table char1
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@char1
+PREHOOK: query: select * from char1 order by key, value limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from char1 order by key, value limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char1
+#### A masked pattern was here ####
+0         	val_0               
+0         	val_0               
+PREHOOK: query: -- insert overwrite, from same/different length char
+insert overwrite table char1
+  select cast(key as char(10)), cast(value as char(15)) from src order by key, value limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@char1
+POSTHOOK: query: -- insert overwrite, from same/different length char
+insert overwrite table char1
+  select cast(key as char(10)), cast(value as char(15)) from src order by key, value limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@char1
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select key, value from char1 order by key, value
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char1
+#### A masked pattern was here ####
+POSTHOOK: query: select key, value from char1 order by key, value
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0         	val_0               
+0         	val_0               
+PREHOOK: query: -- insert overwrite, from string
+insert overwrite table char1
+  select key, value from src order by key, value limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@char1
+POSTHOOK: query: -- insert overwrite, from string
+insert overwrite table char1
+  select key, value from src order by key, value limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@char1
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select key, value from char1 order by key, value
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char1
+#### A masked pattern was here ####
+POSTHOOK: query: select key, value from char1 order by key, value
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0         	val_0               
+0         	val_0               
+PREHOOK: query: -- insert string from char
+insert overwrite table char1_1
+  select key, value from char1 order by key, value limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char1
+PREHOOK: Output: default@char1_1
+POSTHOOK: query: -- insert string from char
+insert overwrite table char1_1
+  select key, value from char1 order by key, value limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char1
+POSTHOOK: Output: default@char1_1
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1_1.key SIMPLE [(char1)char1.FieldSchema(name:key, type:char(10), comment:null), ]
+POSTHOOK: Lineage: char1_1.value SIMPLE [(char1)char1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: select key, value from char1_1 order by key, value
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char1_1
+#### A masked pattern was here ####
+POSTHOOK: query: select key, value from char1_1 order by key, value
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char1_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1_1.key SIMPLE [(char1)char1.FieldSchema(name:key, type:char(10), comment:null), ]
+POSTHOOK: Lineage: char1_1.value SIMPLE [(char1)char1.FieldSchema(name:value, type:char(20), comment:null), ]
+0         	val_0               
+0         	val_0               
+PREHOOK: query: -- respect string length
+insert overwrite table char1 
+  select key, cast(value as char(3)) from src order by key, value limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@char1
+POSTHOOK: query: -- respect string length
+insert overwrite table char1 
+  select key, cast(value as char(3)) from src order by key, value limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@char1
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1_1.key SIMPLE [(char1)char1.FieldSchema(name:key, type:char(10), comment:null), ]
+POSTHOOK: Lineage: char1_1.value SIMPLE [(char1)char1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: select key, value from char1 order by key, value
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char1
+#### A masked pattern was here ####
+POSTHOOK: query: select key, value from char1 order by key, value
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1_1.key SIMPLE [(char1)char1.FieldSchema(name:key, type:char(10), comment:null), ]
+POSTHOOK: Lineage: char1_1.value SIMPLE [(char1)char1.FieldSchema(name:value, type:char(20), comment:null), ]
+0         	val                 
+0         	val                 
+PREHOOK: query: drop table char1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@char1
+PREHOOK: Output: default@char1
+POSTHOOK: query: drop table char1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@char1
+POSTHOOK: Output: default@char1
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1_1.key SIMPLE [(char1)char1.FieldSchema(name:key, type:char(10), comment:null), ]
+POSTHOOK: Lineage: char1_1.value SIMPLE [(char1)char1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: drop table char1_1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@char1_1
+PREHOOK: Output: default@char1_1
+POSTHOOK: query: drop table char1_1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@char1_1
+POSTHOOK: Output: default@char1_1
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char1_1.key SIMPLE [(char1)char1.FieldSchema(name:key, type:char(10), comment:null), ]
+POSTHOOK: Lineage: char1_1.value SIMPLE [(char1)char1.FieldSchema(name:value, type:char(20), comment:null), ]

Added: hive/trunk/ql/src/test/results/clientpositive/char_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/char_2.q.out?rev=1539530&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/char_2.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/char_2.q.out Thu Nov  7 05:57:37 2013
@@ -0,0 +1,131 @@
+PREHOOK: query: drop table char_2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table char_2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table char_2 (
+  key char(10),
+  value char(20)
+)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table char_2 (
+  key char(10),
+  value char(20)
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@char_2
+PREHOOK: query: insert overwrite table char_2 select * from src
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@char_2
+POSTHOOK: query: insert overwrite table char_2 select * from src
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@char_2
+POSTHOOK: Lineage: char_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_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: char_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_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 char_2
+group by value
+order by value asc
+limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char_2
+#### A masked pattern was here ####
+POSTHOOK: query: -- should match the query from src
+select value, sum(cast(key as int)), count(*) numrows
+from char_2
+group by value
+order by value asc
+limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char_2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: char_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_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: char_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_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 char_2
+group by value
+order by value desc
+limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char_2
+#### A masked pattern was here ####
+POSTHOOK: query: -- should match the query from src
+select value, sum(cast(key as int)), count(*) numrows
+from char_2
+group by value
+order by value desc
+limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char_2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: char_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_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 char_2
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@char_2
+PREHOOK: Output: default@char_2
+POSTHOOK: query: drop table char_2
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@char_2
+POSTHOOK: Output: default@char_2
+POSTHOOK: Lineage: char_2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]

Added: hive/trunk/ql/src/test/results/clientpositive/char_cast.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/char_cast.q.out?rev=1539530&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/char_cast.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/char_cast.q.out Thu Nov  7 05:57:37 2013
@@ -0,0 +1,247 @@
+PREHOOK: query: -- Cast from char 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
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- Cast from char 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
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+11	11	11	11	11.0	11.0	11
+PREHOOK: query: select
+  cast(cast('11' as char(10)) as tinyint),
+  cast(cast('11' as char(10)) as smallint),
+  cast(cast('11' as char(10)) as int),
+  cast(cast('11' as char(10)) as bigint),
+  cast(cast('11.00' as char(10)) as float),
+  cast(cast('11.00' as char(10)) as double),
+  cast(cast('11.00' as char(10)) as decimal)
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  cast(cast('11' as char(10)) as tinyint),
+  cast(cast('11' as char(10)) as smallint),
+  cast(cast('11' as char(10)) as int),
+  cast(cast('11' as char(10)) as bigint),
+  cast(cast('11.00' as char(10)) as float),
+  cast(cast('11.00' as char(10)) as double),
+  cast(cast('11.00' as char(10)) as decimal)
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+11	11	11	11	11.0	11.0	11
+PREHOOK: query: 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
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: 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
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+2011-01-01	2011-01-01 01:02:03
+PREHOOK: query: select
+  cast(cast('2011-01-01' as char(10)) as date),
+  cast(cast('2011-01-01 01:02:03' as char(30)) as timestamp)
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  cast(cast('2011-01-01' as char(10)) as date),
+  cast(cast('2011-01-01 01:02:03' as char(30)) as timestamp)
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+2011-01-01	2011-01-01 01:02:03
+PREHOOK: query: -- no tests from string/char to boolean, that conversion doesn't look useful
+select
+  cast(cast('abc123' as string) as string),
+  cast(cast('abc123' as string) as varchar(10)),
+  cast(cast('abc123' as string) as char(10))
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- no tests from string/char to boolean, that conversion doesn't look useful
+select
+  cast(cast('abc123' as string) as string),
+  cast(cast('abc123' as string) as varchar(10)),
+  cast(cast('abc123' as string) as char(10))
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+abc123	abc123	abc123    
+PREHOOK: query: select
+  cast(cast('abc123' as char(10)) as string),
+  cast(cast('abc123' as char(10)) as varchar(10)),
+  cast(cast('abc123' as char(10)) as char(10))
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  cast(cast('abc123' as char(10)) as string),
+  cast(cast('abc123' as char(10)) as varchar(10)),
+  cast(cast('abc123' as char(10)) as char(10))
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+abc123	abc123	abc123    
+PREHOOK: query: select
+  cast(cast('abc123' as varchar(10)) as string),
+  cast(cast('abc123' as varchar(10)) as varchar(10)),
+  cast(cast('abc123' as varchar(10)) as char(10))
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  cast(cast('abc123' as varchar(10)) as string),
+  cast(cast('abc123' as varchar(10)) as varchar(10)),
+  cast(cast('abc123' as varchar(10)) as char(10))
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+abc123	abc123	abc123    
+PREHOOK: query: -- cast from other types to char
+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
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- cast from other types to char
+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
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+11	11	11	11	11.0	11.0	11
+PREHOOK: query: select
+  cast(cast(11 as tinyint) as char(10)),
+  cast(cast(11 as smallint) as char(10)),
+  cast(cast(11 as int) as char(10)),
+  cast(cast(11 as bigint) as char(10)),
+  cast(cast(11.00 as float) as char(10)),
+  cast(cast(11.00 as double) as char(10)),
+  cast(cast(11.00 as decimal) as char(10))
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  cast(cast(11 as tinyint) as char(10)),
+  cast(cast(11 as smallint) as char(10)),
+  cast(cast(11 as int) as char(10)),
+  cast(cast(11 as bigint) as char(10)),
+  cast(cast(11.00 as float) as char(10)),
+  cast(cast(11.00 as double) as char(10)),
+  cast(cast(11.00 as decimal) as char(10))
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+11        	11        	11        	11        	11.0      	11.0      	11        
+PREHOOK: query: select
+  cast(date '2011-01-01' as string),
+  cast(timestamp('2011-01-01 01:02:03') as string)
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  cast(date '2011-01-01' as string),
+  cast(timestamp('2011-01-01 01:02:03') as string)
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+2011-01-01	2011-01-01 01:02:03
+PREHOOK: query: select
+  cast(date '2011-01-01' as char(10)),
+  cast(timestamp('2011-01-01 01:02:03') as char(30))
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  cast(date '2011-01-01' as char(10)),
+  cast(timestamp('2011-01-01 01:02:03') as char(30))
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+2011-01-01	2011-01-01 01:02:03           
+PREHOOK: query: select
+  cast(true as string),
+  cast(false as string)
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  cast(true as string),
+  cast(false as string)
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+TRUE	FALSE
+PREHOOK: query: select
+  cast(true as char(10)),
+  cast(false as char(10))
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  cast(true as char(10)),
+  cast(false as char(10))
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+TRUE      	FALSE     

Added: hive/trunk/ql/src/test/results/clientpositive/char_comparison.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/char_comparison.q.out?rev=1539530&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/char_comparison.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/char_comparison.q.out Thu Nov  7 05:57:37 2013
@@ -0,0 +1,105 @@
+PREHOOK: query: -- Should all be true
+select
+  cast('abc' as char(10)) =  cast('abc' as char(10)),
+  cast('abc' as char(10)) <= cast('abc' as char(10)),
+  cast('abc' as char(10)) >= cast('abc' as char(10)),
+  cast('abc' as char(10)) <  cast('abd' as char(10)),
+  cast('abc' as char(10)) >  cast('abb' as char(10)),
+  cast('abc' as char(10)) <> cast('abb' as char(10))
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- Should all be true
+select
+  cast('abc' as char(10)) =  cast('abc' as char(10)),
+  cast('abc' as char(10)) <= cast('abc' as char(10)),
+  cast('abc' as char(10)) >= cast('abc' as char(10)),
+  cast('abc' as char(10)) <  cast('abd' as char(10)),
+  cast('abc' as char(10)) >  cast('abb' as char(10)),
+  cast('abc' as char(10)) <> cast('abb' as char(10))
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true	true	true	true	true	true
+PREHOOK: query: -- Different char lengths should still compare the same
+select
+  cast('abc' as char(10)) =  cast('abc' as char(3)),
+  cast('abc' as char(10)) <= cast('abc' as char(3)),
+  cast('abc' as char(10)) >= cast('abc' as char(3)),
+  cast('abc' as char(10)) <  cast('abd' as char(3)),
+  cast('abc' as char(10)) >  cast('abb' as char(3)),
+  cast('abc' as char(10)) <> cast('abb' as char(3))
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- Different char lengths should still compare the same
+select
+  cast('abc' as char(10)) =  cast('abc' as char(3)),
+  cast('abc' as char(10)) <= cast('abc' as char(3)),
+  cast('abc' as char(10)) >= cast('abc' as char(3)),
+  cast('abc' as char(10)) <  cast('abd' as char(3)),
+  cast('abc' as char(10)) >  cast('abb' as char(3)),
+  cast('abc' as char(10)) <> cast('abb' as char(3))
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true	true	true	true	true	true
+PREHOOK: query: -- Should work with string types as well
+select
+  cast('abc' as char(10)) =  'abc',
+  cast('abc' as char(10)) <= 'abc',
+  cast('abc' as char(10)) >= 'abc',
+  cast('abc' as char(10)) <  'abd',
+  cast('abc' as char(10)) >  'abb',
+  cast('abc' as char(10)) <> 'abb'
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- Should work with string types as well
+select
+  cast('abc' as char(10)) =  'abc',
+  cast('abc' as char(10)) <= 'abc',
+  cast('abc' as char(10)) >= 'abc',
+  cast('abc' as char(10)) <  'abd',
+  cast('abc' as char(10)) >  'abb',
+  cast('abc' as char(10)) <> 'abb'
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true	true	true	true	true	true
+PREHOOK: query: -- leading space is significant for char
+select
+  cast(' abc' as char(10)) <> cast('abc' as char(10))
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- leading space is significant for char
+select
+  cast(' abc' as char(10)) <> cast('abc' as char(10))
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true
+PREHOOK: query: -- trailing space is not significant for char
+select
+  cast('abc ' as char(10)) = cast('abc' as char(10))
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- trailing space is not significant for char
+select
+  cast('abc ' as char(10)) = cast('abc' as char(10))
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true

Added: hive/trunk/ql/src/test/results/clientpositive/char_join1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/char_join1.q.out?rev=1539530&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/char_join1.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/char_join1.q.out Thu Nov  7 05:57:37 2013
@@ -0,0 +1,134 @@
+PREHOOK: query: drop table char_join1_ch1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table char_join1_ch1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table char_join1_ch2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table char_join1_ch2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table char_join1_str
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table char_join1_str
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table  char_join1_ch1 (
+  c1 int,
+  c2 char(10)
+)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table  char_join1_ch1 (
+  c1 int,
+  c2 char(10)
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@char_join1_ch1
+PREHOOK: query: create table  char_join1_ch2 (
+  c1 int,
+  c2 char(20)
+)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table  char_join1_ch2 (
+  c1 int,
+  c2 char(20)
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@char_join1_ch2
+PREHOOK: query: create table  char_join1_str (
+  c1 int,
+  c2 string
+)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table  char_join1_str (
+  c1 int,
+  c2 string
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@char_join1_str
+PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table char_join1_ch1
+PREHOOK: type: LOAD
+PREHOOK: Output: default@char_join1_ch1
+POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table char_join1_ch1
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@char_join1_ch1
+PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table char_join1_ch2
+PREHOOK: type: LOAD
+PREHOOK: Output: default@char_join1_ch2
+POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table char_join1_ch2
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@char_join1_ch2
+PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table char_join1_str
+PREHOOK: type: LOAD
+PREHOOK: Output: default@char_join1_str
+POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table char_join1_str
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@char_join1_str
+PREHOOK: query: -- Join char with same length char
+select * from char_join1_ch1 a join char_join1_ch1 b on (a.c2 = b.c2) order by a.c1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char_join1_ch1
+#### A masked pattern was here ####
+POSTHOOK: query: -- Join char with same length char
+select * from char_join1_ch1 a join char_join1_ch1 b on (a.c2 = b.c2) order by a.c1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char_join1_ch1
+#### A masked pattern was here ####
+1	abc       	1	abc       
+1	abc       	2	abc       
+2	abc       	1	abc       
+2	abc       	2	abc       
+3	 abc      	3	 abc      
+PREHOOK: query: -- Join char with different length char
+select * from char_join1_ch1 a join char_join1_ch2 b on (a.c2 = b.c2) order by a.c1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char_join1_ch1
+PREHOOK: Input: default@char_join1_ch2
+#### A masked pattern was here ####
+POSTHOOK: query: -- Join char with different length char
+select * from char_join1_ch1 a join char_join1_ch2 b on (a.c2 = b.c2) order by a.c1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char_join1_ch1
+POSTHOOK: Input: default@char_join1_ch2
+#### A masked pattern was here ####
+1	abc       	1	abc                 
+1	abc       	2	abc                 
+2	abc       	1	abc                 
+2	abc       	2	abc                 
+3	 abc      	3	 abc                
+PREHOOK: query: -- Join char with string
+select * from char_join1_ch1 a join char_join1_str b on (a.c2 = b.c2) order by a.c1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char_join1_ch1
+PREHOOK: Input: default@char_join1_str
+#### A masked pattern was here ####
+POSTHOOK: query: -- Join char with string
+select * from char_join1_ch1 a join char_join1_str b on (a.c2 = b.c2) order by a.c1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char_join1_ch1
+POSTHOOK: Input: default@char_join1_str
+#### A masked pattern was here ####
+1	abc       	1	abc
+2	abc       	1	abc
+3	 abc      	3	 abc
+PREHOOK: query: drop table char_join1_ch1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@char_join1_ch1
+PREHOOK: Output: default@char_join1_ch1
+POSTHOOK: query: drop table char_join1_ch1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@char_join1_ch1
+POSTHOOK: Output: default@char_join1_ch1
+PREHOOK: query: drop table char_join1_ch2
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@char_join1_ch2
+PREHOOK: Output: default@char_join1_ch2
+POSTHOOK: query: drop table char_join1_ch2
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@char_join1_ch2
+POSTHOOK: Output: default@char_join1_ch2
+PREHOOK: query: drop table char_join1_str
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@char_join1_str
+PREHOOK: Output: default@char_join1_str
+POSTHOOK: query: drop table char_join1_str
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@char_join1_str
+POSTHOOK: Output: default@char_join1_str

Added: hive/trunk/ql/src/test/results/clientpositive/char_nested_types.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/char_nested_types.q.out?rev=1539530&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/char_nested_types.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/char_nested_types.q.out Thu Nov  7 05:57:37 2013
@@ -0,0 +1,343 @@
+PREHOOK: query: drop table char_nested_1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table char_nested_1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table char_nested_array
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table char_nested_array
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table char_nested_map
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table char_nested_map
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table char_nested_struct
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table char_nested_struct
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table char_nested_cta
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table char_nested_cta
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table char_nested_view
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table char_nested_view
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table char_nested_1 (key int, value char(20))
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table char_nested_1 (key int, value char(20))
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@char_nested_1
+PREHOOK: query: insert overwrite table char_nested_1
+  select key, value from src order by key limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@char_nested_1
+POSTHOOK: query: insert overwrite table char_nested_1
+  select key, value from src order by key limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@char_nested_1
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: -- arrays
+create table char_nested_array (c1 array<char(20)>)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: -- arrays
+create table char_nested_array (c1 array<char(20)>)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@char_nested_array
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table char_nested_array
+  select array(value, value) from char_nested_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char_nested_1
+PREHOOK: Output: default@char_nested_array
+POSTHOOK: query: insert overwrite table char_nested_array
+  select array(value, value) from char_nested_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char_nested_1
+POSTHOOK: Output: default@char_nested_array
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: describe char_nested_array
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe char_nested_array
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+c1                  	array<char(20)>     	None                
+PREHOOK: query: select * from char_nested_array
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char_nested_array
+#### A masked pattern was here ####
+POSTHOOK: query: select * from char_nested_array
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char_nested_array
+#### A masked pattern was here ####
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+["val_0               ","val_0               "]
+PREHOOK: query: -- maps
+create table char_nested_map (c1 map<int, char(20)>)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: -- maps
+create table char_nested_map (c1 map<int, char(20)>)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@char_nested_map
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: insert overwrite table char_nested_map
+  select map(key, value) from char_nested_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char_nested_1
+PREHOOK: Output: default@char_nested_map
+POSTHOOK: query: insert overwrite table char_nested_map
+  select map(key, value) from char_nested_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char_nested_1
+POSTHOOK: Output: default@char_nested_map
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: describe char_nested_map
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe char_nested_map
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+c1                  	map<int,char(20)>   	None                
+PREHOOK: query: select * from char_nested_map
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char_nested_map
+#### A masked pattern was here ####
+POSTHOOK: query: select * from char_nested_map
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char_nested_map
+#### A masked pattern was here ####
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+{0:"val_0               "}
+PREHOOK: query: -- structs
+create table char_nested_struct (c1 struct<a:int, b:char(20), c:string>)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: -- structs
+create table char_nested_struct (c1 struct<a:int, b:char(20), c:string>)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@char_nested_struct
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: insert overwrite table char_nested_struct
+  select named_struct('a', key,
+                      'b', value,
+                      'c', cast(value as string))
+  from char_nested_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char_nested_1
+PREHOOK: Output: default@char_nested_struct
+POSTHOOK: query: insert overwrite table char_nested_struct
+  select named_struct('a', key,
+                      'b', value,
+                      'c', cast(value as string))
+  from char_nested_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char_nested_1
+POSTHOOK: Output: default@char_nested_struct
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: describe char_nested_struct
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe char_nested_struct
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+c1                  	struct<a:int,b:char(20),c:string>	None                
+PREHOOK: query: select * from char_nested_struct
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char_nested_struct
+#### A masked pattern was here ####
+POSTHOOK: query: select * from char_nested_struct
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char_nested_struct
+#### A masked pattern was here ####
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+{"a":0,"b":"val_0               ","c":"val_0"}
+PREHOOK: query: -- nested type with create table as
+create table char_nested_cta as 
+  select * from char_nested_struct
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@char_nested_struct
+POSTHOOK: query: -- nested type with create table as
+create table char_nested_cta as 
+  select * from char_nested_struct
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@char_nested_struct
+POSTHOOK: Output: default@char_nested_cta
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: describe char_nested_cta
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe char_nested_cta
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+c1                  	struct<a:int,b:char(20),c:string>	None                
+PREHOOK: query: select * from char_nested_cta
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char_nested_cta
+#### A masked pattern was here ####
+POSTHOOK: query: select * from char_nested_cta
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char_nested_cta
+#### A masked pattern was here ####
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+{"a":0,"b":"val_0               ","c":"val_0"}
+PREHOOK: query: -- nested type with view
+create table char_nested_view as 
+  select * from char_nested_struct
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@char_nested_struct
+POSTHOOK: query: -- nested type with view
+create table char_nested_view as 
+  select * from char_nested_struct
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@char_nested_struct
+POSTHOOK: Output: default@char_nested_view
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: describe char_nested_view
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe char_nested_view
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+c1                  	struct<a:int,b:char(20),c:string>	None                
+PREHOOK: query: select * from char_nested_view
+PREHOOK: type: QUERY
+PREHOOK: Input: default@char_nested_view
+#### A masked pattern was here ####
+POSTHOOK: query: select * from char_nested_view
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@char_nested_view
+#### A masked pattern was here ####
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+{"a":0,"b":"val_0               ","c":"val_0"}
+PREHOOK: query: drop table char_nested_1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@char_nested_1
+PREHOOK: Output: default@char_nested_1
+POSTHOOK: query: drop table char_nested_1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@char_nested_1
+POSTHOOK: Output: default@char_nested_1
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: drop table char_nested_array
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@char_nested_array
+PREHOOK: Output: default@char_nested_array
+POSTHOOK: query: drop table char_nested_array
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@char_nested_array
+POSTHOOK: Output: default@char_nested_array
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: drop table char_nested_map
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@char_nested_map
+PREHOOK: Output: default@char_nested_map
+POSTHOOK: query: drop table char_nested_map
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@char_nested_map
+POSTHOOK: Output: default@char_nested_map
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: drop table char_nested_struct
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@char_nested_struct
+PREHOOK: Output: default@char_nested_struct
+POSTHOOK: query: drop table char_nested_struct
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@char_nested_struct
+POSTHOOK: Output: default@char_nested_struct
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: drop table char_nested_cta
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@char_nested_cta
+PREHOOK: Output: default@char_nested_cta
+POSTHOOK: query: drop table char_nested_cta
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@char_nested_cta
+POSTHOOK: Output: default@char_nested_cta
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+PREHOOK: query: drop table char_nested_view
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@char_nested_view
+PREHOOK: Output: default@char_nested_view
+POSTHOOK: query: drop table char_nested_view
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@char_nested_view
+POSTHOOK: Output: default@char_nested_view
+POSTHOOK: Lineage: char_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: char_nested_array.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_map.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]
+POSTHOOK: Lineage: char_nested_struct.c1 EXPRESSION [(char_nested_1)char_nested_1.FieldSchema(name:key, type:int, comment:null), (char_nested_1)char_nested_1.FieldSchema(name:value, type:char(20), comment:null), ]



Mime
View raw message