Hive query output error


#1

hive> create table daily_revenue as
select order_date, sum(order_item_subtotal) daily_revenue
from orders join order_items on
order_id = order_item_order_id
group by order_date;

output> Query ID = cloudera_20180323115454_7aff9398-59bd-4492-82e6-fa065251134e
Total jobs = 2
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask


#2

Hi @skshady,
Are you trying in Cloudera VM or Itversity labs. If labs it worked for me.
Please refer the below screenshot in labs.