--! qt:dataset:src | |
set hive.fetch.task.conversion=more; | |
set hive.stats.column.autogather=true; | |
-- test for NaN (not-a-number) | |
create table tstTbl1(n double); | |
insert overwrite table tstTbl1 | |
select 'NaN' from src tablesample (1 rows); | |
select * from tstTbl1; | |
select round(n, 1) from tstTbl1; | |
select round(n) from tstTbl1; | |
-- 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); |