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 does the overwrite keyword denote in Hive load statement?

Answer Posted / rajasekhar

suppose in the current table in hive we are having 3 columns and data is there. If we r adding
one more column then data will be show as null for the new column to overcome this we are using overwrite keyword.
using overwrite keyword data will be loaded with the new table schema.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there a date data type in Hive?

698


What do you mean by schema on reading?

668


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

647


Why do we need hive?

684


How is HCatalog different from Hive?

633


What is the default maximum dynamic partition that can be created by a mapper reducer? How can you change it?

670


If you run hive as a server, what are the available mechanism for connecting it from application?

844


How to change the column data type in hive? Explain rlike in hive.

642


How do you write your own SerDe?

717


Can you define serde in hive?

629


What is the man difference between hbase and hive?

620


How can I delete the above index named index_bonuspay?

688


How can client interact with Hive?

646


What is bag?

635


Difference between external table and internal table in HIVE ?

873