Managed Tables Vs External Tables in HIVE

HIVE is one of the Components of Hadoop built on top of HDFS and is a high level abstract language on top of MapReduce to process the data. HIVEQL is similar like SQL in dealing Structured Data. Question on Managed Tables and External tables is inevitable in every interview for Hadoop Developer.

The following are few differences of two tables in HIVE.

Managed Table	External Table
Default table of HIVE	These tables are external to the HIVE warehouse system
No need to use any extra Key Word at the time of Schema Definition	We have to use External, Location Key Words
When we drop table Metadata from Metastore removed and tabular data from warehouse also be removed completely.	Metadate will be removed but Tabular data will be persistent on HDFS path. It will not be removed.
Always stored the data in default HIVE location path	Stores the data in an external location other than warehouse location path (which specified by the user using Location key word).

Comments

Photo : Savitri during her last days

Even after 4 decades of her death, people are very much interested to watched her (Savitri) biopic. Mahanati turned to be stupendous success. On eve of remembering Savitri, here we posted Savitri photo. The photo seems her last days. The man stand behind Savitri is Gemini Ganeshan who married Savitri. It seems that she suffered bad days during her last days.

Jagan angry on Avanthi Srinivas on Bhimili meeting!

Avanthi Srinivas was joined in YSRCP in January this year. Avanthi joined in YSRCP seeking to contest as Bhimili Assembly segment in 2019 General Elections.

TRS and BJP Friendship - MIM is silent!

Congress is the main opposition to ruling TRS in Telangana State. TRS political movements too were against to Congress in the state. Recent developments reveal that TRS is the strong political Non-NDA alliance to the BJP. TRS proves it many times during the Parliament sessions. Party stall the proceedings in Lok Sabha in the name of Muslim Reservations. TRS agitation helps BJP to avoid No-Confidence Motion. KCR raises non-Congress and Non-BJP front and met many Congress alliance parties but not NDA's. Telngana Finance Minister was not attend in any Finance Ministers meeting against to 15th Finance meeting recommendations. TRS wants for SCS to Telangana when Congress Working Committee declared it's stand on giving SCS to Andhra Pradesh. All these developments uphold the rumors of possible alliance between BJP and TRS after 2019 General Elections. As per latest political development in New Delhi, that KCR held one hour long meeting with Prime Minister Naredra Modi on variou...

A2Z

Search This Blog