在Hive SQL中, AND 是比 OR 的优先级要高的,如何证明?
写个判断语句测试
输入:
select case when 1>0 and 0>1 then "true" else "false" end;
输出:
`+-----------------------------------------------------------+--+`
`| CASE WHEN ((1 > 0) AND (0 > 1)) THEN true ELSE false END |`
`+-----------------------------------------------------------+--+`
`| false |`
`+-----------------------------------------------------------+--+`
把and放在or左边,不加括号
输入:
select case when 1>0 and 0>1 or 1>0 then "true" else "false" end;`select case when 1>0 and 0>1 or 1>0 then "true" else "false" end;`
输出:
`+------------------------------------------------------------------------+--+`
`| CASE WHEN (((1 > 0) AND (0 > 1)) OR (1 > 0)) THEN true ELSE false END |`
`+------------------------------------------------------------------------+--+`
`| true |`
`+------------------------------------------------------------------------+--+`
从左到右执行
把or放在and左边,不加括号
输入:
select case when 1>0 or 0>1 and 1>0 then "true" else "false" end;
输出:
`+------------------------------------------------------------------------+--+`
`| CASE WHEN ((1 > 0) OR ((0 > 1) AND (1 > 0))) THEN true ELSE false END |`
`+------------------------------------------------------------------------+--+`
`| true |`
`+------------------------------------------------------------------------+--+`
虽然or在左侧,但是先执行的and语句。
综上:在HiveSQL中,and的优先级比or高。
我的博客