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?



What is difference between internal and external tables in hive?..

Answer / 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

More Apache Hive Interview Questions

Is there a date data type in Hive?

0 Answers  


Is Hive supports Temporary Tables?

0 Answers  


How can you prevent a large job from running for a long time? What do u think is more popular among the developers - Pig or Hive?

0 Answers  


What is the prerequisite for Apache Hive installation?

0 Answers  


In which scenario Hive is good fit?

0 Answers  


Explain how Hive Deserialize and serialize the data?

0 Answers  


Explain about Hive Buckets with Example ?

2 Answers  


Can you give us some examples, how Hadoop is used in real time environment?

0 Answers  


What is the significance of ‘IF EXISTS” clause while dropping a table?

0 Answers  


In case of embedded Hive, can the same metastore be used by multiple users?

0 Answers  


When executing Hive queries in different directories, why is metastore_db created in all places from where Hive is launched?

0 Answers  


Mention what is ObjectInspector functionality in Hive?

0 Answers  


Categories