How to delete hive external table data | Hadoop Interview question
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; //
Watch video How to delete hive external table data | Hadoop Interview question online without registration, duration hours minute second in high quality. This video was added by user Learnomate Technologies 19 March 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,099 once and liked it 37 people.