日常写代码中发现,hive不能连续比较运算,记录一下:
错误写法:
hive> select 1<2<3;
OK
_c0
true
Time taken: 0.142 seconds, Fetched: 1 row(s)
hive> select 1<7<3;
OK
_c0
true
Time taken: 0.131 seconds, Fetched: 1 row(s)
hive> select -3<-2<-1;
OK
_c0
false
Time taken: 0.136 seconds, Fetched: 1 row(s)
正确写法:只能拆开来写
hive> select 1<2 and 2<3;
OK
_c0
true
Time taken: 0.129 seconds, Fetched: 1 row(s)
hive> select 1<7 and 7<3;
OK
_c0
false
Time taken: 0.346 seconds, Fetched: 1 row(s)
hive> select -3<-2 and -2<-1;
OK
_c0
true
Time taken: 0.159 seconds, Fetched: 1 row(s)