--! qt:dataset:src
set hive.fetch.task.conversion=more;
set hive.stats.column.autogather=false;

-- test for NaN (not-a-number)
create table tstTbl1_n0(n double);

insert overwrite table tstTbl1_n0
select 'NaN' from src tablesample (1 rows);

select * from tstTbl1_n0;

select round(n, 1) from tstTbl1_n0;
select round(n) from tstTbl1_n0;

-- test for Infinity
select round(1/0), round(1/0, 2), round(1.0/0.0), round(1.0/0.0, 2) from src tablesample (1 rows);