How to avoid x-Lock??

HyeontaeJu

Table AA is performed INSERT and UPDATE operations every second by the schedule program.
However, if another program accesses table AA and tries to perform an UPDATE operation, an X-Lock message occurs.
How to solve this problem?

Sankarmn

https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/ConceptsGuide/Components/Locks/AboutVerticaLocks.htm?zoom_highlight=X LOCK
Hope this Helps!