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

What are the different components of a Hive query processor?

1423


Can we change the data type of a column in a hive table?

703


How do you specify the table creator name when creating a table in hive?

692


Hive new version supported Hadoop Versions ?

604


List the various options available with the Hive command?

905


TRIM function in Hive with example?

726


What happened after creating a table in hive ?

731


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

799


Explain ALTER Table statement in Hive?

711


Explain Data Type Conversion in Hive?

723


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

701


What is the current version of Hive?

768


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

785


What is Hive Data Definition language?

975


What will happen in case you have not issued the command?

762