Create HIVE partitioned table HDFS location assistance
You can use MSCK REPAIR to automatically discover the partitions.Take a look at the doc: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-RecoverPartitions(MSCKREPAIRTABLE)