Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Hive LLAP Technical Preview Enables Sub-Second SQL on Hadoop and More

DZone's Guide to

Hive LLAP Technical Preview Enables Sub-Second SQL on Hadoop and More

Major upgrade to Hive 2 that speeds up queries on massive data to sub-second using LLAP for analytics.

· Big Data Zone ·
Free Resource

The open source HPCC Systems platform is a proven, easy to use solution for managing data at scale. Visit our Easy Guide to learn more about this completely free platform, test drive some code in the online Playground, and get started today.

The most significant new feature in Apache Hive 2, to be included in the upcoming HDP 2.5 release is a technical preview of LLAP (Live Long and Process). LLAP enables as fast as sub-second SQL analytics on Hadoop by intelligently caching data in memory with persistent servers that instantly process SQL queries. Since LLAP is an evolution of the Hive architecture it does all this with the same comprehensive ANSI standard SQL support and proven scale that Hive has long been known for.

Hive-2-diagram-1

LLAP Key Benefits

  • LLAP enables as fast as sub-second query in Hive by keeping all data and servers running and in-memory all the time, while retaining the ability to scale elastically within a YARN cluster.
  • LLAP, along with Apache Ranger enables fine-grained security for the Hadoop ecosystem, including data masking and filtering, by providing interfaces for external clients like Spark to read.
  • LLAP is great for cloud because it caches data in memory and keeps it compressed, overcoming long cloud storage access times and stretching the amount of data you can fit in RAM.

Even better, you can try the LLAP technical preview for yourself in the HDP 2.5 Technical Preview Sandbox, get started here http://hortonworks.com/tech-preview-hdp-2-5/

Managing data at scale doesn’t have to be hard. Find out how the completely free, open source HPCC Systems platform makes it easier to update, easier to program, easier to integrate data, and easier to manage clusters. Download and get started today.

Topics:
technical news ,in-memory data ,big data ,hortonworks ,hadoop ,hive

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}