hive中null值得查询

select
count(CASE WHEN client_sex = ‘M’ THEN client_sex ELSE NULL END),
count(CASE WHEN client_sex = ‘F’ THEN client_sex ELSE NULL END),
count(CASE WHEN client_sex =’\\N’ THEN 1 ELSE NULL END),
from_unixtime(unix_timestamp(),’yyyy-MM-dd HH:mm:ss’)
from ta_index_policy_sales_detail;