hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (Jira)" <>
Subject [jira] [Work logged] (HIVE-25278) HiveProjectJoinTransposeRule may do invalid transformations with windowing expressions
Date Tue, 06 Jul 2021 11:21:00 GMT


ASF GitHub Bot logged work on HIVE-25278:

                Author: ASF GitHub Bot
            Created on: 06/Jul/21 11:20
            Start Date: 06/Jul/21 11:20
    Worklog Time Spent: 10m 
      Work Description: kgyrtkirk merged pull request #2423:


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.

To unsubscribe, e-mail:

For queries about this service, please contact Infrastructure at:

Issue Time Tracking

    Worklog Id:     (was: 619124)
    Time Spent: 50m  (was: 40m)

> HiveProjectJoinTransposeRule may do invalid transformations with windowing expressions

> ---------------------------------------------------------------------------------------
>                 Key: HIVE-25278
>                 URL:
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Zoltan Haindrich
>            Assignee: Zoltan Haindrich
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 50m
>  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

View raw message