[
https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14388087#comment-14388087
]
Lefty Leverenz commented on HIVE-10160:
---------------------------------------
See the thread "ORDER BY clause in Hive" on [email protected]:
*
[http://mail-archives.apache.org/mod_mbox/hive-user/201503.mbox/%[email protected]%3e]
> Give a warning when grouping or ordering by a constant column
> -------------------------------------------------------------
>
> Key: HIVE-10160
> URL: https://issues.apache.org/jira/browse/HIVE-10160
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Lefty Leverenz
> Priority: Minor
>
> To avoid confusion, a warning should be issued when users specify column
> positions instead of names in a GROUP BY or ORDER BY clause (unless
> hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)