Support Questions
Find answers, ask questions, and share your expertise

How to find the count of NULL values in Hive

Explorer

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

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

View solution in original post

2 REPLIES 2

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

Explorer

@Shu . Thankyou so much . Second query worked

; ;