ql/src/test/queries/clientpositive/varchar_cast.q

--! qt:dataset:src
set hive.fetch.task.conversion=more;

-- Cast from varchar to other data types
select
  cast(cast('11' as string) as tinyint),
  cast(cast('11' as string) as smallint),
  cast(cast('11' as string) as int),
  cast(cast('11' as string) as bigint),
  cast(cast('11.00' as string) as float),
  cast(cast('11.00' as string) as double),
  cast(cast('11.00' as string) as decimal)
from src limit 1;

select
  cast(cast('11' as varchar(10)) as tinyint),
  cast(cast('11' as varchar(10)) as smallint),
  cast(cast('11' as varchar(10)) as int),
  cast(cast('11' as varchar(10)) as bigint),
  cast(cast('11.00' as varchar(10)) as float),
  cast(cast('11.00' as varchar(10)) as double),
  cast(cast('11.00' as varchar(10)) as decimal)
from src limit 1;

select
  cast(cast('2011-01-01' as string) as date),
  cast(cast('2011-01-01 01:02:03' as string) as timestamp)
from src limit 1;

select
  cast(cast('2011-01-01' as varchar(10)) as date),
  cast(cast('2011-01-01 01:02:03' as varchar(30)) as timestamp)
from src limit 1;

-- no tests from string/varchar to boolean, that conversion doesn't look useful
select
  cast(cast('abc123' as string) as string),
  cast(cast('abc123' as string) as varchar(10))
from src limit 1;

select
  cast(cast('abc123' as varchar(10)) as string),
  cast(cast('abc123' as varchar(10)) as varchar(10))
from src limit 1;

-- cast from other types to varchar
select
  cast(cast(11 as tinyint) as string),
  cast(cast(11 as smallint) as string),
  cast(cast(11 as int) as string),
  cast(cast(11 as bigint) as string),
  cast(cast(11.00 as float) as string),
  cast(cast(11.00 as double) as string),
  cast(cast(11.00 as decimal) as string)
from src limit 1;

select
  cast(cast(11 as tinyint) as varchar(10)),
  cast(cast(11 as smallint) as varchar(10)),
  cast(cast(11 as int) as varchar(10)),
  cast(cast(11 as bigint) as varchar(10)),
  cast(cast(11.00 as float) as varchar(10)),
  cast(cast(11.00 as double) as varchar(10)),
  cast(cast(11.00 as decimal) as varchar(10))
from src limit 1;

select
  cast(date '2011-01-01' as string),
  cast(timestamp('2011-01-01 01:02:03') as string)
from src limit 1;

select
  cast(date '2011-01-01' as varchar(10)),
  cast(timestamp('2011-01-01 01:02:03') as varchar(30))
from src limit 1;

select
  cast(true as string),
  cast(false as string)
from src limit 1;

select
  cast(true as varchar(10)),
  cast(false as varchar(10))
from src limit 1;