question How to find the count of NULL values in Hive in Support Questions

How to find the count of NULL values in Hive

basil_paul — Sun, 06 Jan 2019 18:52:40 GMT

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

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

Shu_ashu — Sun, 06 Jan 2019 22:42:51 GMT

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";

basil_paul — Tue, 08 Jan 2019 11:39:41 GMT

@Shu . Thankyou so much . Second query worked