Apache Hive: Transferring data from existing table to another table...

which slave we have to upload the data into hadoop cluster...

how to drop partition metadata from hive, when partition is drop by using alter drop command...