As seen in the previous section, there is a lot involved to get a working MapReduce executable. I am a novice Java developer and it took me about four hours to get this working; for a non-developer, this would be a tougher task.
Hive enables business users who are typically aware of SQL and who are not MapReduce developers become more effective on using HDFS. Hive generates MapReduce code dynamically, based on the user's request. Hive comes preinstalled with HDInsight and HDP for Windows.
Hive syntax is very similar to MySQL.
Apache Hive is a data warehouse infrastructure built on top of Hadoop and provides easy querying, summarization, and analysis. Its SQL-like interface is called HiveQL. Hive was initially developed ...