[ https://issues.apache.org/jira/browse/HIVE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Navis reassigned HIVE-2954: --------------------------- Assignee: Navis > The statement fails when a column part of an ORDER BY is not specified in the > SELECT. > ------------------------------------------------------------------------------------- > > Key: HIVE-2954 > URL: https://issues.apache.org/jira/browse/HIVE-2954 > Project: Hive > Issue Type: Improvement > Components: SQL > Affects Versions: 0.8.1 > Reporter: Mauro Cazzari > Assignee: Navis > > Given the following table: > CREATE TABLE `DBCSTB32` (`aaa` DOUBLE,`bbb` STRING,`ccc` STRING,`ddd` DOUBLE) > ROW FORMAT > DELIMITED FIELDS TERMINATED BY '\001' STORED AS TEXTFILE; > The following statement fails: > select TXT_1`aaa`, TXT_1.`bbb` > from `DBCSTB32` TXT_1 > order by TXT_1.`bbb` asc, TXT_1.`aaa` asc, TXT_1.`ccc` asc > ERROR: java.sql.SQLException: Query returned non-zero code: 10, cause: > FAILED: Error in > semantic analysis: Line 1:104 Invalid column reference '`ccc`' > Adding `ccc` to the selected list of columns fixes the problem. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira