Combining SQL Analytics with Hadoop

MapR Technologies, Inc., a provider of a distribution for Apache Hadoop, is including Apache Drill 1.0 in the MapR Distribution.

Providing self-service SQL analytics without requiring pre-defined schema definitions, Drill helps enable business analysts to explore and understand data. It enables interactivity with data from both legacy transactional systems and new data sources, such as Internet of Things (IOT) sensors, web click-streams, and other semi-structured data, along with support for business intelligence and data visualization tools. Drill also provides integrated granular security and governance capabilities required for multi-tenant data lakes or enterprise data hubs.

“Backed by a vibrant open source community, Apache Drill combines on-the-fly schema discovery with the familiarity of ANSI SQL so analysts can interactively explore any type of data in a self-service fashion,” said Anil Gadre, senior vice president, product management, MapR Technologies. “We believe features such as the new Drill Explorer are instrumental in defining new use cases for big data and speeding time-to-value. For the first time, users do not need to know the schema before analyzing data, which enables a much larger group within organizations to derive value from their big data much faster.”

Drill also supports analysis of IoT data, which typically has large volumes of complex/semi-structured data (such as JSON) and is highly dynamic since data sources can be from hundreds and thousands of devices, with each dataset potentially having a different format. Drill is designed to effectively handle such datasets.

According to MapR, the partner ecosystem is embracing Apache Drill, and companies, such as Information Builders, JReport (Jinfonet Software), MicroStrategy, Qlik, SAP, Simba, Tableau and TIBCO, are working closely with MapR and the Drill community to interoperate BI tools with Drill through standard ODBC/JDBC connectivity. 

Image courtesy of Shutterstock.


Subscribe to Big Data Quarterly E-Edition