blob: 267cdf9054d2badc30fa0eee61fb46b1a84fd4b1 [file] [log] [blame]
set hive.mapred.mode=nonstrict;
set hive.explain.user=false;
SET hive.vectorized.execution.enabled=true;
set hive.fetch.task.conversion=none;
DROP TABLE IF EXISTS int_txt;
CREATE TABLE int_txt (`i` int);
LOAD DATA LOCAL INPATH '../../data/files/decimal_10_0.txt' OVERWRITE INTO TABLE int_txt;
select count(*)
from
int_txt
where
(( 1.0 * i) / ( 1.0 * i)) > 1.2;
DROP TABLE IF EXISTS int_txt;