You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Alexander Pivovarov (JIRA)" <ji...@apache.org> on 2015/02/01 07:20:34 UTC

[jira] [Updated] (HIVE-9532) add support for quantified predicates

     [ https://issues.apache.org/jira/browse/HIVE-9532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alexander Pivovarov updated HIVE-9532:
--------------------------------------
    Description: 
allow a quantified predicate using ALL/ANY/SOME
{code}
select rnum, c1, c2 from tjoin2 where 20 > some (select c1 from tjoin1)

Error while compiling statement: FAILED: ParseException line 1:50 cannot recognize input near 'select' 'c1' 'from' in function specification
{code}

  was:
allow a quantified predicate using ALL/ANY/SOME

select rnum, c1, c2 from tjoin2 where 20 > some ( select c1 from tjoin1)

Error while compiling statement: FAILED: ParseException line 1:50 cannot recognize input near 'select' 'c1' 'from' in function specification


> add support for quantified predicates 
> --------------------------------------
>
>                 Key: HIVE-9532
>                 URL: https://issues.apache.org/jira/browse/HIVE-9532
>             Project: Hive
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: N Campbell
>
> allow a quantified predicate using ALL/ANY/SOME
> {code}
> select rnum, c1, c2 from tjoin2 where 20 > some (select c1 from tjoin1)
> Error while compiling statement: FAILED: ParseException line 1:50 cannot recognize input near 'select' 'c1' 'from' in function specification
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)