[
https://issues.apache.org/jira/browse/HIVE-25278?focusedWorklogId=614450&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-614450
]
ASF GitHub Bot logged work on HIVE-25278:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 24/Jun/21 11:19
Start Date: 24/Jun/21 11:19
Worklog Time Spent: 10m
Work Description: kgyrtkirk commented on pull request #2423:
URL: https://github.com/apache/hive/pull/2423#issuecomment-867554905
definetly; the two rules seemed almost identical!
opened: HIVE-25285
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 614450)
Time Spent: 0.5h (was: 20m)
> HiveProjectJoinTransposeRule may do invalid transformations with windowing
> expressions
> ---------------------------------------------------------------------------------------
>
> Key: HIVE-25278
> URL: https://issues.apache.org/jira/browse/HIVE-25278
> Project: Hive
> Issue Type: Bug
> Reporter: Zoltan Haindrich
> Assignee: Zoltan Haindrich
> Priority: Major
> Labels: pull-request-available
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> running
> {code}
> create table table1 (acct_num string, interest_rate decimal(10,7)) stored as
> orc;
> create table table2 (act_id string) stored as orc;
> CREATE TABLE temp_output AS
> SELECT act_nbr, row_num
> FROM (SELECT t2.act_id as act_nbr,
> row_number() over (PARTITION BY trim(acct_num) ORDER BY interest_rate DESC)
> AS row_num
> FROM table1 t1
> INNER JOIN table2 t2
> ON trim(acct_num) = t2.act_id) t
> WHERE t.row_num = 1;
> {code}
> may result in error like:
> {code}
> Error: Error while compiling statement: FAILED: SemanticException Line 0:-1
> Invalid column reference 'interest_rate': (possible column names are:
> interest_rate, trim) (state=42000,code=40000)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
