I`m trying to calculate CR(Conversion Rate) of column name 'action_type'.
The column 'action_type' is allocated to string values as follows...
- 1 : sale
- 2 : click
So, I think the conversion rate is '(SUM(sale) / SUM(click)) * 100".
The values '1'(sale) and '2'(click) are in the same column 'action_type'.
How do I write a sql query in hive?
Thank you!