[jira] [Comment Edited] (HIVE-18375) Cannot ORDER by subquery fields unless they are selected

2018-01-05 Thread Paul Jackson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16313657#comment-16313657 ] Paul Jackson edited comment on HIVE-18375 at 1/5/18 6:49 PM: - [~pxiong] I'm

[jira] [Commented] (HIVE-18375) Cannot ORDER by subquery fields unless they are selected

2018-01-05 Thread Paul Jackson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16313657#comment-16313657 ] Paul Jackson commented on HIVE-18375: - [~pxiong] I'm referring to the for queries in this comment:

[jira] [Commented] (HIVE-18375) Cannot ORDER by subquery fields unless they are selected

2018-01-04 Thread Paul Jackson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16312359#comment-16312359 ] Paul Jackson commented on HIVE-18375: - There is no doubt these are the same issue. What do you think

[jira] [Commented] (HIVE-18375) Cannot ORDER by subquery fields unless they are selected

2018-01-04 Thread Paul Jackson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16312051#comment-16312051 ] Paul Jackson commented on HIVE-18375: - This seems related. Posting as a comment, but perhaps it should

[jira] [Updated] (HIVE-18334) Cannot JOIN ON result of COALESCE

2018-01-04 Thread Paul Jackson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Jackson updated HIVE-18334: Component/s: Query Processor > Cannot JOIN ON result of COALESCE >

[jira] [Updated] (HIVE-18375) Cannot ORDER by subquery fields unless they are selected

2018-01-04 Thread Paul Jackson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Jackson updated HIVE-18375: Description: Give these tables: {code:SQL} CREATE TABLE employees ( emp_no INT,

[jira] [Updated] (HIVE-18334) Cannot JOIN ON result of COALESCE

2017-12-22 Thread Paul Jackson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Jackson updated HIVE-18334: Description: A join is returning no results when the ON clause is equating the results of two