Lab Performance


#1

Hi,
I am facing some performance issues in the lab with hive queries. my queries are taking more than 5 minutes to run. Is there any performance issues at this moment? This happening from last 2 days

My Query:
select o.order_id,o.order_date,o.order_status,oi.order_item_subtotal,round(sum(oi.order_item_subtotal),2) as daily_revenue,
oi.order_item_subtotal/round(sum(oi.order_item_subtotal),2) as pct_revenue
from orders o join order_items oi
on o.order_id=oi.order_item_order_id
where order_status in(‘CLOSED’,‘COMPLETE’)
group by o.order_id,o.order_date,o.order_status,oi.order_item_subtotal
distribute by o.order_date sort by o.order_date, daily_revenue desc limit 10;


#2

@sivakumarchv It is working fine now. Please check once.


#3

@annapurna
no difference. it still the same.


#4

Any update on this ticket?


#5

Here is my query for today:

total run time for below query is 5 mins 30 Seconds .is this usual time?

select * from(
select o.order_id,o.order_date,oi.order_item_order_id,o.order_status,oi.order_item_subtotal,round(sum(oi.order_item_subtotal) over(partition by oi.order_item_order_id),2) as daily_revenue,
oi.order_item_subtotal/round(sum(oi.order_item_subtotal) over(partition by oi.order_item_order_id),2) as pct_revenue,
rank() over(partition by o.order_id order by oi.order_item_subtotal desc) as rnk_order,
dense_rank() over(partition by o.order_id order by oi.order_item_subtotal desc) as dnse_rnk_order
from orders o join order_items oi
on o.order_id=oi.order_item_order_id
where order_status in(‘CLOSED’,‘COMPLETE’)) a
where a.daily_revenue>1000
distribute by order_date sort by order_date, daily_revenue desc lmit 10;


#6

@annapurna @itversity : is there any update on this?