Fabian Tan created HIVE-13081:
---------------------------------
Summary: Support for DELETE/UPDATE... JOIN
Key: HIVE-13081
URL: https://issues.apache.org/jira/browse/HIVE-13081
Project: Hive
Issue Type: New Feature
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)
