how to count multiple column values in hive?

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP

how to count multiple column values in hive?



In hive table i have eight household members data. Columms are:


statusmem1,
statusmem2,
statusmem3,
statusmem4,
statusmem5,
statusmem6,
statusmem7,
statusmem8



In these columns the data mentioning the status of a houshold member like if status of statusmem1 is H(head) or W(spouce) etc.



Some of the columns have null values.
So, the question is how do I count number of values in those eight column. Not consider the null values.



So just tell me how can I count the multiple column values by excluding the null values in hive?




1 Answer
1



Count() does not count nulls, so, to count not null values, just use count(column):


Count()


select
count(statusmem1) as statusmem1_cnt,
count(statusmem2) as statusmem2_cnt,
count(statusmem3) as statusmem3_cnt,
count(statusmem4) as statusmem4_cnt,
count(statusmem5) as statusmem5_cnt,
count(statusmem6) as statusmem6_cnt,
count(statusmem7) as statusmem7_cnt,
count(statusmem8) as statusmem8_cnt
from tabele;






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Comments

Post a Comment

Popular posts from this blog

Executable numpy error

Image
Clash Royale CLAN TAG #URR8PPP Executable numpy error I'm trying to create an executable file for my code. I've already tried with cx_Freeze and with pyinstaller. Both gives me the same error, which is: "Missing required dependencies 0.format(missing_dependencies))" PS C:UsersGustavoDesktopbuildexe.win32-3.6> python AgendaOficial.py C:UsersGustavoAppDataLocalProgramsPythonPython36-32python.exe: can't open file 'AgendaOficial.py': [Errno 2] No such file or directory PS C:UsersGustavoDesktopbuildexe.win32-3.6> .AgendaOficial.exe Traceback (most recent call last): File "C:UsersGustavoAppDataLocalProgramsPythonPython36-32libsite-packagescx_Freezeinitscripts__startup__.py", line 14, in run module.run() File "C:UsersGustavoAppDataLocalProgramsPythonPython36-32libsite-packagescx_FreezeinitscriptsConsole.py", line 26, in run exec(code, m. dict ) File "AgendaOficial.py", line 8, in File "C:UsersGustavoAppDataLocal...
Read more

Trying to Print Gridster Items to PDF without overlapping contents

Image
Clash Royale CLAN TAG #URR8PPP Trying to Print Gridster Items to PDF without overlapping contents I want to print gridster items to pdf using chome browser. Unfortunately the item overlaps on next page. Is there any way to make gridster item go to next page if it doesnt fit in the current page when printing to pdf? Screenshot By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Read more

Hystrix command on request collapser fallback

Image
Clash Royale CLAN TAG #URR8PPP Hystrix command on request collapser fallback I have a scenario where I want to apply hystrix on the fallback (and process one-by-one) of a hystrix request collapser's batch method. The fallback method ( processEntryBatch_fallback ) is invoked. But the hystrix command ( processEntryBackup ) in turn the fallback invokes is not reported (doesn't even appear on dashboard). And the fallback method ( finalFallback ) is not invoked either. I would like to know what am I missing here ? I referred javanica documentation processEntryBatch_fallback processEntryBackup finalFallback @Service public class DummyService private static final Logger log = LoggerFactory.getLogger(DummyService.class); //batch processing method public void processEntry(List<String> msg) //batch processing throw new RuntimeException("Exception while batch processing"); //processing one-by-one @HystrixCommand(fallbackMethod="finalFallback") public ...
Read more