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

--! qt:dataset:src
set hive.mapred.mode=nonstrict;

set hive.compat=latest;

-- With ansi sql arithmetic enabled, int / int => exact numeric type
explain select cast(key as int) / cast(key as int) from src limit 1;
select cast(key as int) / cast(key as int) from src limit 1;


set hive.compat=0.12;

-- With ansi sql arithmetic disabled, int / int => double
explain select cast(key as int) / cast(key as int) from src limit 1;
select cast(key as int) / cast(key as int) from src limit 1;