You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Pengcheng Xiong (JIRA)" <ji...@apache.org> on 2016/11/08 18:42:58 UTC
[jira] [Created] (HIVE-15160) Can't group by an unselected column
Pengcheng Xiong created HIVE-15160:
--------------------------------------
Summary: Can't group by an unselected column
Key: HIVE-15160
URL: https://issues.apache.org/jira/browse/HIVE-15160
Project: Hive
Issue Type: Bug
Reporter: Pengcheng Xiong
Assignee: Pengcheng Xiong
If a grouping key hasn't been selected, Hive complains. For comparison, Postgres does not.
Example. Notice i_item_id is not selected:
{code}
select i_item_desc
,i_category
,i_class
,i_current_price
,sum(cs_ext_sales_price) as itemrevenue
,sum(cs_ext_sales_price)*100/sum(sum(cs_ext_sales_price)) over
(partition by i_class) as revenueratio
from catalog_sales
,item
,date_dim
where cs_item_sk = i_item_sk
and i_category in ('Jewelry', 'Sports', 'Books')
and cs_sold_date_sk = d_date_sk
and d_date between cast('2001-01-12' as date)
and (cast('2001-01-12' as date) + 30 days)
group by i_item_id
,i_item_desc
,i_category
,i_class
,i_current_price
order by i_category
,i_class
,i_item_id
,i_item_desc
,revenueratio
limit 100;
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)