Hello. Thanks. I disabled this property but I was not sure if I was able to delete afterwards. Thanks for your information.
As a note, I also have spark jobs on my cluster, so I also had to modify the hive-site used by these spark jobs, otherwise the tables were still populated. Best regards. Tale Le ven. 14 janv. 2022 à 15:43, SG <simhadri...@gmail.com> a écrit : > 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 >> >
