2015-07-21 20:35:17,359 INFO org.apache.hadoop.hive.metastore.HiveMetaStore: Starting hive metastore on port 9083 ......... 2015-07-21 20:44:44,495 INFO org.apache.sentry.hdfs.MetastorePlugin: #### Metastore Plugin initialization complete !! 2015-07-21 20:44:44,495 INFO org.apache.sentry.hdfs.MetastorePlugin: #### Finished flushing queued updates to Sentry !!You can see that HMS started at 8:35PM, and finished the sync at almost 8:45PM. The cause: One possible cause of the issue is:
- Sentry HDFS sync is enabled
- There are lots of tables or tables with lots of partitions (hundreds of thousands of partitions)
- If possible, drop the tables that you do not need
- If you need to keep the tables that have lots of partitions, try to merge those partitions if possible, by copying data into a new table with merged partitions
- If there are hundreds of thousands of partitions that you can not merge, then it is time to redesign your tables so that less partitions could be used