Hi Peter, thanks for the support.
Every select count(*) from TXNS where txn_state = 'o' runs fine if I run it
from psql. No ROLLBACK happens after.
Maybe the result , I’m only seeing 0 (zero), trigger the ROLLBACK command
from Hive program. (???)
From: Peter Vary
Reply-To: "user@hive.apach
Hi Fernando,
Checked the comapaction_queue related one, and that is definitely normal.
Checked the txn related one, and that seems more interesting. I would try to
run the query above against you HMS DB - my guess that is failing with some
error.
Peter
> On Oct 9, 2019, at 12:56, Antunes, Fern
Hi,
I took some time to observe what Hive is doing with its PostgreSQL tables the
figure out what is the impact in the case of PostgreSQL failure.
In logs, something catches me up. There are many ROLLBACK commands for SELECT
commands (sample below).
Is it normal or something is wrong?
I am u