PREHOOK: query: -- 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
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- 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
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 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
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: 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
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 varchar(10)) as date),
  cast(cast('2011-01-01 01:02:03' as varchar(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 varchar(10)) as date),
  cast(cast('2011-01-01 01:02:03' as varchar(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/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
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- 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
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
abc123	abc123
PREHOOK: query: select
  cast(cast('abc123' as varchar(10)) as string),
  cast(cast('abc123' as varchar(10)) as varchar(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))
from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
abc123	abc123
PREHOOK: query: -- 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
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- 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
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 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
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: 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
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 varchar(10)),
  cast(timestamp('2011-01-01 01:02:03') as varchar(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 varchar(10)),
  cast(timestamp('2011-01-01 01:02:03') as varchar(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 varchar(10)),
  cast(false as varchar(10))
from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: select
  cast(true as varchar(10)),
  cast(false as varchar(10))
from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
TRUE	FALSE