hive类型转化错误,会错误提示指定分区参数

select 
*
from TRAD_LIST t
WHERE t.dt >= '2017-10-18'
and t.dt <= '2017-11-01'
and t.con_level = 'a'  -- 这个字段类型是数字
LIMIT 10;
FAILED: SemanticException Queries against partitioned tables 
without a partition filter are disabled for safety reasons. If you know 
what you are doing, please make sure that 
hive.strict.checks.large.query is set to false and that 
hive.mapred.mode is not set to 'strict' to enable them. No partition 
predicate for Alias "t" Table
原文地址:https://www.cnblogs.com/linn/p/7804197.html