Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to find the count of NULL values in Hive

Solved Go to solution

How to find the count of NULL values in Hive

New Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to find the count of NULL values in Hive

Super Guru
@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";
2 REPLIES 2

Re: How to find the count of NULL values in Hive

Super Guru
@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";
Highlighted

Re: How to find the count of NULL values in Hive

New Contributor

@Shu . Thankyou so much . Second query worked

Don't have an account?
Coming from Hortonworks? Activate your account here