摘要： Alter TableMost table properties can be altered with Alter Table statements, which change metadata about the table but not the data itself. These statements can be used to fix mistakes in schema, move partition locations and so on.1. Renamign a Table: hive> alter table log_messages rename to logm 阅读全文

摘要： External Tables However, managed tables are less convinent for sharing with other tools. For example, suppose we have data that is created and used primarily by Pig or other tools, but we want to run some quries against it, but not give Hive ownership of the data. So we can define an external table 阅读全文