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

 

posted on 2017-11-08 15:16  凌度  阅读(2986)  评论(0编辑  收藏  举报