[
https://issues.apache.org/jira/browse/HIVE-26054?focusedWorklogId=835302&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-835302
]
ASF GitHub Bot logged work on HIVE-26054:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 22/Dec/22 13:02
Start Date: 22/Dec/22 13:02
Worklog Time Spent: 10m
Work Description: kasakrisz opened a new pull request, #3891:
URL: https://github.com/apache/hive/pull/3891
<!--
Thanks for sending a pull request! Here are some tips for you:
1. If this is your first time, please read our contributor guidelines:
https://cwiki.apache.org/confluence/display/Hive/HowToContribute
2. Ensure that you have created an issue on the Hive project JIRA:
https://issues.apache.org/jira/projects/HIVE/summary
3. Ensure you have added or run the appropriate tests for your PR:
4. If the PR is unfinished, add '[WIP]' in your PR title, e.g.,
'[WIP]HIVE-XXXXX: Your PR title ...'.
5. Be sure to keep the PR description updated to reflect all changes.
6. Please write your PR title to summarize what this PR proposes.
7. If possible, provide a concise example to reproduce the issue for a
faster review.
-->
### What changes were proposed in this pull request?
Add order/sort by expressions to Project expressions and Project RowResolver
when generating Project RelNode
### Why are the changes needed?
To support complex expressions in order by clause which are not projected in
presence of distinct and group by.
### Does this PR introduce _any_ user-facing change?
Yes. Without this patch Hive throws exception when an order by key is not
just a column reference but some more complex expression and the query has
distinct or group by. This patch enables compiling such queries.
### How was this patch tested?
```
mvn test -Dtest.output.overwrite -Dtest=TestMiniLlapLocalCliDriver
-Dqfile=distinct_order_by.q,distinct_windowing_2.q,order_by_expr_2.q -pl
itests/qtest -Pitests
```
Issue Time Tracking
-------------------
Worklog Id: (was: 835302)
Time Spent: 1h (was: 50m)
> 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
> Assignee: Krisztian Kasa
> Priority: Major
> Labels: pull-request-available
> Time Spent: 1h
> Remaining Estimate: 0h
>
> 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.10#820010)
