[jira] [Updated] (HIVE-13081) Support for DELETE/UPDATE... JOIN

["Gopal V (JIRA)" <ji...@apache.org>]

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

Gopal V updated HIVE-13081:
---------------------------
    Component/s: Transactions

> Support for DELETE/UPDATE... JOIN
> ---------------------------------
>
>                 Key: HIVE-13081
>                 URL: https://issues.apache.org/jira/browse/HIVE-13081
>             Project: Hive
>          Issue Type: New Feature
>          Components: Transactions
>            Reporter: Fabian Tan
>            Priority: Minor
>
> I noticed that  DELETE.. join does not appear to work with Hive 1.x.
> For an example:
> hive> delete from t_bic_pel_order_acid LEFT OUTER JOIN t_bic_pel_order_poc7 ON (t_bic_pel_order_acid.order_no=t_bic_pel_order_poc7.order_no);
> FAILED: ParseException line 1:33 missing EOF at 'LEFT' near 't_bic_pel_order_acid'
> Looking at Hive's documentation, it does look like the DELETE syntax supported is only limited to DELETE from ..<where>, where there are no indicators that joins are supported.
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#Languag...
> I could not find any JIRA ticket or examples of other end users using this, therefore, I'm creating this ticket as a feature request to support DELETE/UPDATE .. JOIN



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