Hive should support
select 1 where 1
currently it throws an execption (at least with mr)...complaining about Integer / Boolean casting difficulties.
Current behaviour is a bit inconsistent; because using tez / vectorization this is supported.
Error: java.lang.RuntimeException: Hive Runtime Error while closing operators: java.lang.Integer cannot be cast to java.lang.Boolean
Non-boolean expression in WHERE should be rejected
An empty where condition leads to vectorization exceptions instead of throwing a compile time error