Difference between Internal and External table in Hive - Interview question 

Enroll to the Oracle DBA real time interview Question
====================================================
learnomate.org...
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 - +91 9960262955
Email - ankush.thavali@gmail.com
Fees - 15k (300$)
Two installments can be available
Syllabus -
www.learnomate...
Review -
www.learnomate...
RU-vid 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