question Re: cloudera live: tutorial exercise 2: "time out" for any select query in Archives of Support Questions (Read Only)

cloudera live: tutorial exercise 2: "time out" for any select query

malidou — Sun, 16 Aug 2015 19:30:56 GMT

Whene i lance execution of query bellow given in the tutorial exercise 2:
"
-- Most popular product categories
select c.category_name, count(order_item_quantity) as count
from order_items oi
inner join products p on oi.order_item_product_id = p.product_id
inner join categories c on c.category_id = p.product_category_id
group by c.category_name
order by count desc
limit 10;
"

i get the following message :

Your query has the following error(s): timed out

and this message is for any select query that i attempt to execute.

help please.

Re: cloudera live: tutorial exercise 2: "time out" for any select query

malidou — Sun, 16 Aug 2015 21:19:42 GMT

Solved by increasing the RAM

Re: cloudera live: tutorial exercise 2: "time out" for any select query

cjervis — Mon, 17 Aug 2015 12:13:53 GMT

I am happy to see that you solved the issue. Thank you for sharing your solution. 🙂