Hi @Jayanthi R all you need to do is use the --hive-overwrite option in your sqoop import statement. Check the sqoop documentation for more advice: https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_importing_data_into_hive You will see a list of options in Table 8 that you can use when you import data into Hive.
If you're already tried this, can you let us know if you're having problems? If so, please paste the full error message.
If the target table is Hive table then you can use -hive-overwrite