Choosing Your SQL Access Strategy for Hadoop

Archived Published: 20 February 2014 ID: G00256407

Analyst(s): |

Not a Gartner Client?

Want more research like this?
Learn the benefits of becoming a Gartner client.

contact us online


The development of SQL interfaces within the Hadoop stack and tools with their own interfaces enables ad hoc data analysis by a broader range of users, reducing the need for scarce development talent. This analysis offers guidance to information managers evaluating this rapidly changing space.

Table of Contents

  • Introduction
  • Analysis
    • Evaluate the SQL Interface Landscape to Understand Available Products and Their Differences
      • Hive-Based SQL
      • Direct SQL Execution
      • DBMS External Tables
    • Do Not Rely on Published Benchmarks as Realistic Performance Comparisons — Conduct a POC
    • SQL Interfaces for Apache Hadoop Could Exist in Tools, DBMSs and/or Within the Hadoop Stack
      • Despite the Hype, It Is Not Real Time
      • Tool Support
      • Portability
  • Gartner Recommended Reading
© 2014 Gartner, Inc. and/or its Affiliates. All Rights Reserved. Reproduction and distribution of this publication in any form without prior written permission is forbidden. The information contained herein has been obtained from sources believed to be reliable. Gartner disclaims all warranties as to the accuracy, completeness or adequacy of such information. Although Gartners research may discuss legal issues related to the information technology business, Gartner does not provide legal advice or services and its research should not be construed or used as such. Gartner shall have no liability for errors, omissions or inadequacies in the information contained herein or for interpretations thereof. The opinions expressed herein are subject to change without notice.

Free Research

Discover what 12,000 CIOs and Senior IT leaders already know.

Free Access

Why Gartner

Gartner delivers the technology-related insight you need to make the right decisions, every day.

Find out more

Call +1 855-515-4486 or contact us

to become a Gartner client.