I have data regarding gender of people under 8 columns:
mem1;mem2;mem3;mem4;mem5;mem6;mem7;mem8
MALE;FMALE;UNKN;MALE;FMALE;FMALE;MALE;MALE
Now I want to find out the frequency of male, fmale, unkn using hive. Something like
MALE 4
FMALE 3
UNKN 1
I'm new to Hive but I know we need to use group by. Can someone please help me with the query?
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)