Introduction: Hive is a data warehouse system to store structured data on Hadoop file system. It facilitates ad-hoc queries and the analysis of large datasets stored in Hadoop and provides an easy query to the data by executing Hadoop MapReduce plans. By default, Hive stores metadata in an embedded Apache Derby database, and other client/server [...]