--! qt:dataset:srcpart | |
set hive.mapred.mode=nonstrict; | |
-- SORT_QUERY_RESULTS | |
explain extended | |
select * from srcpart a where a.ds='2008-04-08'; | |
select * from srcpart a where a.ds='2008-04-08'; | |
explain extended | |
select * from srcpart a where a.ds='2008-04-08' and key < 200; | |
select * from srcpart a where a.ds='2008-04-08' and key < 200; | |
explain extended | |
select * from srcpart a where a.ds='2008-04-08' and rand(100) < 0.1; | |
select * from srcpart a where a.ds='2008-04-08' and rand(100) < 0.1; |