DROP TABLE IF EXISTS DECIMAL_PRECISION; CREATE TABLE DECIMAL_PRECISION(dec decimal) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS TEXTFILE; SELECT * from DECIMAL_PRECISION WHERE dec > 1234567890123456789.0123456789bd; DROP TABLE DECIMAL_PRECISION;