GitHub user vinodkc opened a pull request:
https://github.com/apache/incubator-carbondata/pull/720
[CARBONDATA-642] Delete Subquery is not working while creating and loading
2 tables
This PR handles following problem
**Problem**: In carbon delete statement, JOIN is not supported to delete
using 2 or more tables.
**Analysis**: Carbon delete query parsing is failing, when JOIN existing in
delete query. For example âDELETE FROM Table1 t1 INNER JOIN Table2 t2 ON
t1.ID = t2.ID;â
**Solution**: Change the parser logic of delete statement to support all
valid delete statements [including joins]
- new unit test case added
- Manual testing done
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/vinodkc/incubator-carbondata Br_CARBONDATA-642
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-carbondata/pull/720.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #720
----
commit 178b24df6ecf8da5ce8c6a963449ff6fb53139fb
Author: Vinod K C <[email protected]>
Date: 2017-04-01T16:59:15Z
Problem: In carbon delete statement, JOIN is not supported to delete using
2 or more tables.
Analysis: Carbon delete query parsing is failing, when JOIN existing in
delete query. For example âDELETE FROM Table1 t1 INNER JOIN Table2 t2 ON
t1.ID = t2.ID;â
Solution: Change the parser logic of delete statement to support all valid
delete statements [including joins]
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---