Re: So many SQL ROLLBACK commands on the Hive PostgreSQL table

2019-10-09 Thread Antunes, Fernando De Souza
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

Re: So many SQL ROLLBACK commands on the Hive PostgreSQL table

2019-10-09 Thread Peter Vary
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

So many SQL ROLLBACK commands on the Hive PostgreSQL table

2019-10-09 Thread Antunes, Fernando De Souza
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