Posted by
akashrn5 on
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/DISCUSSION-Support-MERGE-INTO-SQL-API-tp103140p103148.html
Hi,
+1
Thanks for proposing the idea.
Please consider the below points in design and coding
please try to update the below points to design
1. when there are multiple whenMatched conditions what happens? it should be
in order
2. validations like when matched can have either update or delete, this
validation
3. when the condition is not present for when matched, then how to update or
delete complete data,
example can be given, how the sql will look like
4. how to update all columns of target table from source table and how the
sql will be and validations can be there
5. validation for whenNot matched to have only insert
6. what happens when the columns does not match from source and target
7. how to insert complete data.
Please try to mention all these in design documents, can add section for all
the validation to take care.
One section can be to mention the examples.
By this way design will be very good and easy to understand.
Thanks
Regards,
Akash R Nilugal
--
Sent from:
http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/