@Ravikumar Kumashi If you don't want to loss the source data copy while loading then the best way would be to create external table over that existing hdfs directory OR you can also make a copy of your source directory and create an external hive table that should point to new dir location. hadoop fs -cp /path/old/hivetable /path/new/hivetable create external table table_name ( id int, myfields string ) location '/path/new/hivetable'; ... View more