mysql - 我在 Mysql 的查询中编写了这个查询，但它在 Hive 中不起作用。它向我显示一个错误

Question

select c.customer_id,concat(c.customer_fname,' ',c.customer_lname) as fullname, o.order_customer_id,o.order_status from 
customers c left outer join orders o on (c.customer_id = o.order_customer_id) 
group by o.order_status

Answer 1

您可以尝试以下查询:

select 
 c.customer_id,
 concat(c.customer_fname,' ',c.customer_lname) as fullname,
 o.order_customer_id,
 o.order_status 
from 
 customers c left outer join orders o on (c.customer_id = o.order_customer_id) 
 group by c.customer_id,concat(c.customer_fname,' ',c.customer_lname),o.order_customer_id, o.order_status

正如其他 stackies 已经建议的那样，您的 group by 语句中缺少列。所有非聚合列应包含在 group by 中。