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:/
> 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
-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,
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