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.

PK Fans - Political and Private life

Pawan Kalyan fans attack Director Ram Gopal Varma's office for making parody film "Power Star" on their hero. RGV made a complaint and withdraw later for unknown reasons.

Who killed cricket in Pakistan?

Pakistan won the 1992 WC under the leadership of one of the greatest all-rounders in the world Imran Khan. Now, he is leading the country as Prime Minister of Pakistan. Every cricket lover in the country wants to see the glory in the gentleman game after Imran became PM for Pakistan. But his leadership can’t give any assurance to other nations to play the game in Pakistan. New Zealand abandoned the historic Pakistan tour just a few minutes after the first ball was to be bowled in the first ODI in Rawalpindi. Both teams have considered this series as preparation for the ICC T20 World Cup. Kiwis cites ‘Security threat’ to its players in Pakistan. There is a question that arises why NZ came and cancelled the visit. This is a massive blow to Pakistan cricket who wants to revive the game in the country. Prime Minister Imran Khan had spoken to New Zealand Prime Minister Jacinda Ardern and informed her about the security arrangements. Pakistan Cricket Board (PCB) fumes over Black Caps decisio...

A2Z

Search This Blog