Re: Data is being inserted even though an INSERT INTO query fails

2021-12-09 Thread Antoni Ivanov
Thanks for the answers so far. We have asked a few follow up questions in https://issues.apache.org/jira/browse/IMPALA-11014 If someone can spare the time to look at them I’d be pretty grateful. Regards, Antoni From: Wenzhe Zhou Reply to: "user@impala.apache.org" Date: Friday, 19 November

Re: Data is being inserted even though an INSERT INTO query fails

2021-11-19 Thread Wenzhe Zhou
Kudu supports transactions for "insert" and "CTAS" now. But transactions for "UPDATE/UPSERT/DELETE" are not done yet. Wenzhe Zhou wz...@cloudera.com 408-568-0101 On Fri, Nov 19, 2021 at 6:57 AM Csaba Ringhofer wrote: > Hi! > > i have added a comment to the Jira. > Generally INSERTs in Impala

Re: Data is being inserted even though an INSERT INTO query fails

2021-11-19 Thread Csaba Ringhofer
Hi! i have added a comment to the Jira. Generally INSERTs in Impala are not really atomic, unless we use Hive ACID tables or Iceberg (I am not sure about Kudu). - Csaba On Tue, Nov 16, 2021 at 12:36 PM Antoni Ivanov wrote: > Hi, > > > > Are insert queries supposed to be atomic ? > > > >

Re: Data is being inserted even though an INSERT INTO query fails

2021-11-16 Thread Antoni Ivanov
Hi, Are insert queries supposed to be atomic ? Thanks, Antoni From: Antoni Ivanov Reply to: "user@impala.apache.org" Date: Friday, 12 November 2021, 12:52 To: "user@impala.apache.org" Subject: Data is being inserted even though an INSERT INTO query fails Hi, A colleague of mine opened

Data is being inserted even though an INSERT INTO query fails

2021-11-12 Thread Antoni Ivanov
Hi, A colleague of mine opened https://issues.apache.org/jira/browse/IMPALA-11014 It seems there a bug in Impala which can cause insert query to populate data even if it fails. That seems pretty serious since it violates atomicity of single query operation. Are you aware of this (we tried to