How to delete hive external table data | Hadoop Interview question

Опубликовано: 05 Октябрь 2024
на канале: Learnomate Technologies

3,099

Enroll to the Oracle DBA real time interview Question
====================================================
https://learnomate.org/courses/oracle...

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

   • Starting NEW REAL TIME ORACLE DBA Batch

Registration

https:www.learnomate.org/register

WhatsApp me
https://wa.link/usfz52

Facebook Page
  / learnomate

LinkedIn
  / 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-tr...

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; //