You can disable privilege synchroniser in by setting hive.privilege.synchronizer to false in hs2. This will stop populating tbl_col_prvis, tbl_privs and db_privs table.
On Thu, 13 Jan 2022, 22:25 Tale Hive, <tale2.h...@gmail.com> wrote: > Hey guys. > > I use hive 3.1.0. > > I contact you because I have a table inside the postgresql database of > hive which is really big. Around 40 GB ! This is the table named > TBL_COL_PRIVS. > > I checked and I think this table is just used in the information_schema > database. > > Is there purpose to this table ? > Can I truncate it ? > How can I disable the feeding of this table TBL_COL_PRIVS please ? > > Thank you in advance. > > best regards. > > Tale >
