Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is difference between internal and external tables in hive?

Answer Posted / rajasekhar

if you drop a table in internal mode then table schema and files get deleted.
If you drop a table in external mode then table shema will be gone but files will be present.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain Clustering in Hive?

660


Explain when to use explode in Hive?

647


How hive can improve performance with orc format tables?

674


What are the views in Hive?

625


Wherever (Different Directory) I run the hive query, it creates new metastore_db, please explain the reason for it?

711


Explain REPEAT function in Hive with example?

731


How to change a column data type in Hive?

646


Differentiate between PigLatin and Hive?

653


Mention what is ObjectInspector functionality in Hive?

707


How do you list all databases whose name starts with p?

637


Is it possible to change the default location of Managed Tables in Hive, if so how?

681


What do you understand by hive?

650


What happened after creating a table in hive ?

673


What are the components of a Hive query processor?

687


What is the maximum size of string data type supported by Hive?

743