O'Reilly logo

HDInsight Essentials by Rajesh Nadipalli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Hive solution

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.

Note

Hive syntax is very similar to MySQL.

Overview of Hive

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required