Difference between Internal and External table in Hive - Interview question

Enroll to the Oracle DBA real time interview Question
====================================================
learnomate.org/courses/oracle...
WhatsApp me for Training - 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 - [phone]
Email - [e-mail]
Fees - 15k (300$)
Two installments can be available
Syllabus -
www.learnomate.org/syllabus
Review -
www.learnomate.org/reviews
UA-cam Channel
• Starting NEW REAL TIME...
Registration
https:www.learnomate.org/register
WhatsApp me
wa.link/usfz52
Facebook Page
/ learnomate
LinkedIn
/ ankushthavali Hive
==============
1)Managed Tables/Internal table
2)External tables
1)Managed Tables/Internal table Syntax
hive= CREATE TABLE IF NOT EXISTS table_type.Internal_Table ( eid int, name String,
designation String)
COMMENT 'Employee details'
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LINES TERMINATED BY '
'
STORED AS TEXTFILE;
2)External tables Syntax
Create External table
==============================
Hive=CREATE EXTERNAL TABLE table_type.External_table(eid int, name String,
designation String) Row format delimited Fields terminated by ',' LOCATION '/test';
#hadoop
#hive
#hivetables

[@manujkumarjoshi9342]

the satisfying and exact answer which most of the instructors escape because I think they are themselves not clear about the topic. Doing a good job brother.

[@learnomate]

Thanks 😊

[@karimullashaik5884]

Thank you !!! It really clarifies the difference between external and managed tables.

[@rajeshgadde7042]

Superb explanation

[@sureshraina321]

Excellent ☺️

[@rahulninawe4669]

Good one

[@ruxarmohammed6718]

great video. thanks

[@learnomate]

Thanks

[@sushmakudipudi2684]

How do you perform alter operation once external table is created, i can think of just drop and recreate to add some columns

[@chandramay]

How do you copy paste after double click?

[@techcloud3637]

Hi sir, im new to hadoop is there any source i can learn and practice all these concept

[@learnomate]

You can learn from blog, UA-cam. Subscribe to itvercity channel. They have very good video on Hadoop spark.