Enroll to the Oracle DBA real time interview Question
====================================================
https://learnomate.org/courses/oracle-dba-interview-question/
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
https://youtu.be/cFHMTPEtUG0
Registration
https:www.learnomate.org/register
WhatsApp me
https://wa.link/usfz52
Facebook Page
https://www.facebook.com/learnomate/
LinkedIn
https://www.linkedin.com/in/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
