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

2019-10-10 Thread Antunes, Fernando De Souza
uot;user@hive.apache.org" Date: Thursday, 10 October 2019 04:37 To: "user@hive.apache.org" Subject: Re: So many SQL ROLLBACK commands on the Hive PostgreSQL table **This Message originated from a Non-ArcelorMittal source** Hi Fernando, My guess is that this is the query: https:/

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

2019-10-10 Thread Peter Vary
> from Hive program. (???) > > From: Peter Vary mailto:pv...@cloudera.com>> > Reply-To: "user@hive.apache.org <mailto:user@hive.apache.org>" > mailto:user@hive.apache.org>> > Date: Wednesday, 9 October 2019 08:32 > To: "user@hive.apache.org <m

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

2019-10-09 Thread Antunes, Fernando De Souza
-To: "user@hive.apache.org" Date: Wednesday, 9 October 2019 08:32 To: "user@hive.apache.org" Subject: Re: So many SQL ROLLBACK commands on the Hive PostgreSQL table **This Message originated from a Non-ArcelorMittal source** Hi Fernando, Checked the comapaction_queue related one,

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