Eight Ways to Put Hadoop to Work in Any IT Department Despite the fact that, from a technical perspective, Hadoop is closely aligned with the MapReduce interface for accessing data stored in Hadoop, the primary mechanism for interacting with all that data is still going to be SQL, which for all intents and purposes is […]
Eight Ways to Put Hadoop to Work in Any IT Department
Despite the fact that, from a technical perspective, Hadoop is closely aligned with the MapReduce interface for accessing data stored in Hadoop, the primary mechanism for interacting with all that data is still going to be SQL, which for all intents and purposes is the lingua franca of enterprise IT.
In recognition of that reality, Altiscale, a provider of Hadoop as a service in the cloud, this week added support for SQL-on-Hadoop running on the Altiscale Data Cloud.
The new Altiscale offering consists of the Hive 0.13 + Tez SQL query engine running on top of the Hadoop Distributed File System, a Web-based SQL query tool for accessing Hive, and ODBC interfaces that Altiscale has licensed from Simba Technologies.
Hive has essentially become a de facto standard for providing SQL access to Hadoop. The Tez engine now allows SQL queries to be executed using YARN (Yet Another Resource Negotiator) on a Hadoop to process SQL requests more efficiently, thereby masking the more arcane MapReduce interface from end users and developers alike.
Steve Kishi, vice president of product management for Altiscale, says that while it’s true that there are probably more instances of Hadoop running on premise than in the cloud today, once enterprise IT organizations begin to run those applications in production, they will increasingly look to take advantage of the economics of storing large amounts of data in the cloud.
The degree to which that will occur, of course, remains to be seen. The one thing that is for certain is that regardless of where Hadoop is running, the way it will be most commonly accessed is SQL.
Michael Vizard is a seasoned IT journalist, with nearly 30 years of experience writing and editing about enterprise IT issues. He is a contributor to publications including Programmableweb, IT Business Edge, CIOinsight and UBM Tech. He formerly was editorial director for Ziff-Davis Enterprise, where he launched the company’s custom content division, and has also served as editor in chief for CRN and InfoWorld. He also has held editorial positions at PC Week, Computerworld and Digital Review.
The go-to resource for IT professionals from all corners of the tech world looking for cutting edge technology solutions that solve their unique business challenges. We aim to help these professionals grow their knowledge base and authority in their field with the top news and trends in the technology space.
Property of TechnologyAdvice. © 2025 TechnologyAdvice. All Rights Reserved
Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.
