hive函数之~关系运算

hive> select 1 from tableName where 1=1;

hive> select 1 from tableName where 1 <> 2;

hive> select 1 from tableName where 1 < 2;

hive> select 1 from tableName where 1 < = 1;

hive> select 1 from tableName where 2 > 1;

hive> select 1 from tableName where 1 >= 1;

1

hive> select * from tableName;

OK

2011111209 00:00:00     2011111209

hive> select a, b, a<b, a>b, a=b from tableName;

2011111209 00:00:00     2011111209      false   true    false

hive> select 1 from tableName where null is null;

hive> select 1 from tableName where 1 is not null;

hive> select 1 from tableName where ‘football‘ like ‘foot%‘;

hive> select 1 from tableName where ‘football‘ like ‘foot____‘;

<strong>注意：否定比较时候用NOT A LIKE B</strong>

hive> select 1 from tableName where not ‘football‘ like ‘fff%‘;

hive> select 1 from tableName where ‘footbar‘ rlike ‘^f.*r$‘;

1

注意：判断一个字符串是否全为数字：

hive>select 1 from tableName where ‘123456‘ rlike ‘^\\d+$‘;

1

hive> select 1 from tableName where ‘123456aa‘ rlike ‘^\\d+$‘;

hive> select 1 from tableName where ‘footbar‘ REGEXP ‘^f.*r$‘;

1