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.

Suchi Leaks Next Target - Samantha

Wikileaks created huge political uproar among Indian Politics and Bureaucrats. Suchi leaks causes disturbances both in Tollywood and Kollywood. Female Singer Suchitra discloses personal issues of celebrities in Telugu and Tamil. She leaked few photographs of Heros and Heroines who spend their personal time in private parties. Karthik, husband of Suchitra responded on leaks that she was not mentally firm. Few actors in particular Tamanna, Trisha, Dhanush, Anirudh and Rana were feel uncomfortable on these leaks. Trisha reacted on Photo of Rana who kissed her said that it was just peck between two friends. There was nothing more beyond that. Suchitra said that she was raped by Dhanush and Anirudh after the party in the night. In her another leak, Tamanna was too raped by Dhanush. As per buzz, Suchi's next leak will be related to Heroine Samantha. Earlier, Samantha had love affair with Hero Siddhartha. Both were participated in Rahu-Kethu pooja in Srikalahasti. There were many go...

Girl signed on 100/- Stamp Paper for getting 5K!

YSRCP Govt gave notification for more than 2.6 lakh jobs for Village Volunteers and was selected through interview process. All unemployed youth from SSC to Graduate were applied for the posts.

A2Z

Search This Blog