Question: how to calculate percentage in hive query?
Answer: Use below query to calculate the percentage: SELECT roll_no,CAST(subject1+subject2+subject3+subject4+subject5+subject6 AS float)/6.0 AS percentage.