Naresh P R created HIVE-26054:
---------------------------------
Summary: Distinct + Groupby with column alias is failing
Key: HIVE-26054
URL: https://issues.apache.org/jira/browse/HIVE-26054
Project: Hive
Issue Type: Bug
Reporter: Naresh P R
After [HIVE-16924|https://issues.apache.org/jira/browse/HIVE-16924], below
query is failing.
{code:java}
create table table1 (col1 bigint, col2 string);
create table table2 (t2_col1 string);
Select distinct col1 as alias_col1
from table1
where col2 = (SELECT max(t2_col1) as currentdate from table2 limit 1)
order by col1;
Error: Error while compiling statement: FAILED: SemanticException Line 0:-1
Unsupported SubQuery Expression '1': Only SubQuery expressions that are top
level conjuncts are allowed (state=42000,code=40000) {code}
Workaround is either remove distinct column alias "alias_col1" or use alias in
order by.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
