Hive: Add partitions for existing folder structure

by

Use msck repair table command: 

MSCK [REPAIR] TABLE tablename;

or 

ALTER TABLE tablename RECOVER PARTITIONS;

if you are running Hive on EMR.

Read more details about both commands here: RECOVER PARTITIONS

More Related Contents:

  1. How does Hadoop process records split across block boundaries?
  2. What is the difference between partitioning and bucketing a table in Hive ?
  3. Difference between Hive internal tables and external tables?
  4. How to transpose/pivot data in hive?
  5. How does Hadoop Namenode failover process works?
  6. Name node is in safe mode. Not able to leave
  7. How to fix corrupt HDFS FIles
  8. Sqoop import : composite primary key and textual primary key
  9. How to delete and update a record in Hive
  10. Hadoop java.io.IOException: Mkdirs failed to create /some/path
  11. Spark on yarn concept understanding
  12. Hive unable to manually set number of reducers
  13. How to update table in Hive 0.13?
  14. how many mappers and reduces will get created for a partitoned table in hive
  15. Namenode not getting started
  16. How to load data to hive from HDFS without removing the source file?
  17. Spark iterate HDFS directory
  18. Default Namenode port of HDFS is 50070.But I have come across at some places 8020 or 9000 [closed]
  19. How does Hadoop perform input splits?
  20. Loading Data from a .txt file to Table Stored as ORC in Hive
  21. Hadoop: …be replicated to 0 nodes instead of minReplication (=1). There are 1 datanode(s) running and no node(s) are excluded in this operation
  22. Default number of reducers
  23. Create HIVE Table with multi character delimiter
  24. Job queue for Hive action in oozie
  25. Difference between Pig and Hive? Why have both? [closed]
  26. Difference between HBase and Hadoop/HDFS
  27. What is Hive: Return Code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
  28. Difference between hadoop fs -put and hadoop fs -copyFromLocal
  29. Behavior of the parameter “mapred.min.split.size” in HDFS
  30. Hive Data Retrieval Queries: Difference between CLUSTER BY, ORDER BY, and SORT BY

Leave a Comment