You can translate the question and the replies:

Is it possible to CUD (Insert/Update/Delete) in denodo query editor ?

Hi, there I want you to let me know this question. Is it possible to CUD (Insert/Update/Delete) in denodo query editor ? especially impala. I've tested this in denodo express. - insert ok - update, delete now allowed how about denodo platform version ? thanks.
user
01-05-2022 21:26:06 -0400
code

1 Answer

Hello, Generally, Denodo supports this kind of Insert/Update/Delete statements. One of the requirements is however, that the data source needs to support the operation and the view needs to be updatable. If we speak about Impala, this source does not support update statements and therefore it would not be possible to do this operation against that data source. One exception to that is if you use Impala with Kudu, then the update statements are supported and it would then also work from Denodo. For more information on what views are updateable, I would refer to the documentation page [Inserts, Updates and Deletes Over Views](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/inserts_updates_and_deletes_over_views/inserts_updates_and_deletes_over_views). For differences between Denodo Express 8.0 and Denodo Platform 8.0 you could also check[ this Data sheet](https://www.denodo.com/en/system/files/document-attachments/ds-denodoexpress8.0-01.pdf). Hope this helps!
Denodo Team
04-05-2022 08:24:27 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here