How to find the count of NULL values in Hive

[#1]

Query:

select 2gusage,count(2gusage) from demo group by 2gusage;

Output:

MID 765153

HIGH 18095461

LOW 119069472

NULL 25997075

I tried the below query to find the count of NULL values

Query

select count(*) from demo where 2gusage is 'NULL';

Output

0

Kindly help me out with the query to find the count of NULL values

[#2 · Accepted solution]

@Basil Paul

1.Try with below query:

select count(*) from demo where 2gusage is NULL;

2.If literal NULL is in your data for 2gusage column then use the below query:

select count(*) from demo where 2gusage = "NULL";

[#3]

@Shu . Thankyou so much . Second query worked