hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gopal V (JIRA)" <>
Subject [jira] [Updated] (HIVE-13081) Support for DELETE/UPDATE... JOIN
Date Thu, 18 Feb 2016 05:21:18 GMT


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

> Support for DELETE/UPDATE... JOIN
> ---------------------------------
>                 Key: HIVE-13081
>                 URL:
>             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.
> 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

View raw message