Is there a way to use column alias declared earlier later in the query? I have something like this
select item_id,
sum(sales) as total_sales,
sum(cost) as total_cost
total_sales - total_cost as total_profit
from table A
group by item_id,total_profit;
I tried using
SET hive.groupby.orderby.position.alias=true;
but doesn't work.
I know I can do this in Teradata so I am hoping there must be some way to do this in Hive as well.
thanks,
Manoj Agrawal