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

Clarify about the smb join in hive?

712


Differentiate between describe and describe extended?

740


Explain Clustering in Hive?

750


What are the different collection type in Hive?

747


Explain the Differences between Hive and Spark SQL?

753


Is hive a nosql database?

681


What is the difference between piglatin and hiveql?

705


What are the three different modes in which hive can be run?

733


Which java class handles the output record encoding into files which result from Hive queries?

705


Explain Data Type Conversion in Hive?

761


What is the utilization of hcatalog?

720


What are collection data types in Hive?

771


If you run a select * query in hive, why does it not run mapreduce?

787


How to skip header rows from a table in Hive?

864


What will be the result when you do cast(‘abc’ as int)?

805