As part of my current project, we deployed 100+ hive tables. I am trying to find list of all hive tables in a particular database that are missing compute stats. For an individual table, I used SHOW PARTITIONS table_name. Is there anyway I can find for all hive tables that are missing stats?
Asked
Active
Viewed 281 times
1
-
1I checked that question before posting my query. Not the one I am looking for. I am trying to find list of tables where #Rows = -1 – vvazza Aug 06 '19 at 15:57
-
do you have access to hive metastore in order to take the information from there? – F.Lazarescu Aug 07 '19 at 06:13
-
1No, only admins have access to hive metastore – vvazza Aug 07 '19 at 12:48