Difference between Internal and External table in Hive - 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   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 '\n'
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