hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Mollitor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-21727) Allow For Ordinal Substitution
Date Tue, 14 May 2019 15:56:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-21727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16839576#comment-16839576
] 

David Mollitor commented on HIVE-21727:
---------------------------------------

h5. hive.groupby.position.alias
 * Default Value: {{false}}
 * Added In: Hive 2.2.0 with HIVE-15797

Whether to enable using Column Position Alias in [GROUP BY|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+GroupBy].
h5. hive.orderby.position.alias
 * Default Value: {{true}}
 * Added In: Hive 2.2.0 with HIVE-15797

Whether to enable using Column Position Alias in [ORDER BY|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SortBy#LanguageManualSortBy-SyntaxofOrderBy].

 

Do you know why 'orderby' is 'false' and 'groupby' is 'true'?

> Allow For Ordinal Substitution 
> -------------------------------
>
>                 Key: HIVE-21727
>                 URL: https://issues.apache.org/jira/browse/HIVE-21727
>             Project: Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 4.0.0, 3.2.0
>            Reporter: David Mollitor
>            Priority: Major
>
> Impala allows for ordinal substitution.  Add a compatible feature to Hive to allow Hive
to be more compatible with Impala.  Allows for more of a drop-in replacement.
> [IMPALA-8548]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message