Hive 3.1.0 - A question related to NOTIFICATION_LOG table

2022-01-12 Thread Tale Hive
Hey guys. I used postgresql for hive database and the table NOTIFICATION_LOG is quite big since I upgraded from hive 1.2.1 to hive 3.1.0. Anyone knows what is the purpose of this NOTIFICATION_LOG table please ? Best regards. Tale

Is it safe to TRUNCATE TBL_COL_PRIVS

2022-01-13 Thread Tale Hive
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 ? C

Re: Is it safe to TRUNCATE TBL_COL_PRIVS

2022-01-14 Thread Tale Hive
. Tale Le ven. 14 janv. 2022 à 15:43, SG 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, wr