title: How to count records from multiple columns eliminating null values in hive table
body: <p>I'm using the below command to find the sum of records from 8 columns but getting null in the O/P as shown below.</p>
  
  <p><a href="https://i.stack.imgur.com/UFPQY.png" rel="nofollow noreferrer">Command part 1</a></p>
  
  <p><a href="https://i.stack.imgur.com/KQGO8.png" rel="nofollow noreferrer">command part 2</a></p>
  
  <p><a href="https://i.stack.imgur.com/uM9fm.png" rel="nofollow noreferrer">Output</a></p>
  
  <p>How can this be fixed?</p>