I’ll post this as an answer purely to support the conversation – Tim Mahy , nawroth , and CraigTP have suggested viable databases. CouchDB would be my preferred due to the use of Erlang, but there are others out there. I’d say ACID does not contradict or negate the concept of NoSQL… While there seems … Read more
You can use row_number or full join. This is example using row_number: insert overwrite table_1 select customer_id, items, price, updated_date from ( select customer_id, items, price, updated_date, row_number() over(partition by customer_id order by new_flag desc) rn from ( select customer_id, items, price, updated_date, 0 as new_flag from table_1 union all select customer_id, items, price, updated_date, … Read more
ACID is a set of properties that you would like to apply when modifying a database. Atomicity Consistency Isolation Durability A transaction is a set of related changes which is used to achieve some of the ACID properties. Transactions are tools to achieve the ACID properties. Atomicity means that you can guarantee that all of … Read more
What gives this away is the word transaction. It is evident by the statement that the query was attempting to change at least one row in one or more InnoDB tables. Since you know the query, all the tables being accessed are candidates for being the culprit. From there, you should be able to run … Read more