[
https://issues.apache.org/jira/browse/HIVE-24622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
zhaolong updated HIVE-24622:
----------------------------
Description:
create table tbl1(id int,name string,company string) row format delimited
fields terminated by ',' stored as textfile;
insert into tbl1 values(1,'xxx','xxx');
insert into tbl1 values(2,'yyy','yyy');
set hive.cbo.enable=false;
select count(id) FROM tbl1 GROUP BY id,name ORDER BY id desc;
!image-2021-01-12-15-41-06-394.png!
> Invalid column ref error in order by when using group by
> --------------------------------------------------------
>
> Key: HIVE-24622
> URL: https://issues.apache.org/jira/browse/HIVE-24622
> Project: Hive
> Issue Type: Bug
> Affects Versions: 3.1.0, 4.0.0
> Reporter: zhaolong
> Priority: Major
> Attachments: image-2021-01-12-15-41-06-394.png
>
>
> create table tbl1(id int,name string,company string) row format delimited
> fields terminated by ',' stored as textfile;
> insert into tbl1 values(1,'xxx','xxx');
> insert into tbl1 values(2,'yyy','yyy');
> set hive.cbo.enable=false;
> select count(id) FROM tbl1 GROUP BY id,name ORDER BY id desc;
> !image-2021-01-12-15-41-06-394.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
