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

If you omit the overwrite clause while creating a hive table,what happens to file which are new and files which already exist?

753


what is (HS2) HiveServer2?

678


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

744


When you are dealing with static data instead of dynamic data?

736


Hive new version supported Hadoop Versions ?

604


What is the man difference between hbase and hive?

669


Explain the functionality of object-inspector.

722


What is Hive Present Version ?

1093


What is the use of explode in Hive?

730


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

703


In which scenario Hive is good fit?

982


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

719


Is hive a nosql database?

640


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

666


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

680