Hive query to get sum of all the positive values and negative values of a column into two different columns

Assume that we have a table as below:

Need to write a query to get sum of the positive values and negative values as below:

SELECT CASE WHEN column_name>0 THEN SUM(column_name) END AS positive_sum, CASE WHEN column_name<0 THEN SUM (column_name) END AS negative_sum FROM table;

Please comment if this is useful.