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