[jira] [Updated] (HIVE-24915) Distribute by with sort by clause when used with constant as the first parameter for sort produces wrong result.

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-24915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

ASF GitHub Bot updated HIVE-24915:
----------------------------------
    Labels: pull-request-available  (was: )

> Distribute by with sort by clause when used with constant as the first parameter for sort produces wrong result.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-24915
>                 URL: https://issues.apache.org/jira/browse/HIVE-24915
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 2.3.4
>            Reporter: Suprith
>            Assignee: Suprith
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Distribute by with sort by clause when used with constant as the first parameter for sort produces wrong result.
> Example: 
> {code:java}
>  SELECT 
>     t.time,
>     'a' as const
>   FROM
>     (SELECT 1591819264 as time
>     UNION ALL
>     SELECT 1591819265 as time) t
>   DISTRIBUTE by const
>   sort by const, t.time
> {code}
> Produces
>  
> |{color:#000000}*time*{color}|{color:#000000}*const*{color}|
> | NULL|{color:#000000}a{color}|
> | NULL|{color:#000000}a{color}|
> Instead it should produce:
> |{color:#000000}*time*{color}|{color:#000000}*const*{color}|
> |{color:#000000}*1591819264*{color}|{color:#000000}a{color}|
> |{color:#000000}*1591819265*{color}|{color:#000000}a{color}|
> Incorrect sort columns are used while creating ReduceSink https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java#L9066
>  
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)