How to delete hive external table data | Hadoop Interview question

Enroll to the Oracle DBA real time interview Question ==================================================== https://learnomate.org/courses/oracle-dba-interview-question/ WhatsApp me for Training - https://wa.link/gi7fv2 Starting new Oracle DBA batch in next week. Please connect with me if you are interested. Batch will start from next week Time - 9am ist (11:30 PM EST) Duration - 45 days Daily one hour Contact - +91 9960262955 Email - [email protected] Fees - 15k (300$) Two installments can be available Syllabus - https://www.learnomate.org/syllabus Review - https://www.learnomate.org/reviews YouTube Channel https://youtu.be/cFHMTPEtUG0 Registration https:www.learnomate.org/register WhatsApp me https://wa.link/usfz52 Facebook Page https://www.facebook.com/learnomate/ LinkedIn https://www.linkedin.com/in/ankushthavali/ An external table describes the metadata / schema on external files. External table files can be accessed and managed by processes outside of Hive. External tables can access data stored in sources such as Azure Storage Volumes (ASV) or remote HDFS locations. Training: https://blognow.in/oracle-dba-best-training-center-in-pune/ In this video, how to delete the data from External hive tables. 1)You can easily delete the files from his location. dfs -rmr /user/hive/warehouse/database_name.db/table_name;*** 2) You have to change the external to internal table before drop it: example beeline ALTER TABLE $tablename SET TBLPROPERTIES('EXTERNAL'='False'); // make the table as internal and then: drop table $tablename; //