[ https://issues.apache.org/jira/browse/HIVE-784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13614982#comment-13614982 ]
Sun Rui commented on HIVE-784: ------------------------------ Guido, you may try project-panthera-ase@github, which is an open source effort for HIVE-3472. It can support correlated/un-correlated subqueries and selection from multiple tables without any join operator now. Instead of directly modifying the HiveQL grammar and query processor to support subqueries, the project incorporates a PL/SQL parser for SQL input and performs semantically identical transformation on the PL/SQL parser output for execution by the query processor. > Support uncorrelated subqueries in the WHERE clause > --------------------------------------------------- > > Key: HIVE-784 > URL: https://issues.apache.org/jira/browse/HIVE-784 > Project: Hive > Issue Type: New Feature > Components: Query Processor > Reporter: Ning Zhang > Assignee: Ning Zhang > > Hive currently only support views in the FROM-clause, some Facebook use cases > suggest that Hive should support subqueries such as those connected by > IN/EXISTS in the WHERE-clause. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira