Skip to main content

Posts

Showing posts with the label Hive Interview QA

Hive interview QA

Apache Hive data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL.  1) What is the definition of Hive? What is the present version of Hive and explain about ACID transactions in Hive?  Answer) Hive is an open source data warehouse system. We can use Hive for analyzing and querying in large data sets of Hadoop files. Its similar to SQL. Hive supports ACID transactions: The full form of ACID is Atomicity, Consistency, Isolation, and Durability. ACID transactions are provided at the row levels, there are Insert, Delete, and Update options so that Hive supports ACID transaction. Insert Delete Update 2)Explain what is a Hive variable. What do we use it for?  Answer)Hive variable is basically created in the Hive environment that is referenced by Hive scripting languages. It provides to pass some values to the hive queries when the query starts executing. It uses the source command....