Gartner Research

Choosing Your SQL Access Strategy for Hadoop

Published: 20 February 2014

ID: G00256407

Analyst(s): Merv Adrian , Nick Heudecker

Summary

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
  • Key Challenges

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

©2019 Gartner, Inc. and/or its affiliates. All rights reserved. Gartner is a registered trademark of Gartner, Inc. and its affiliates. This publication may not be reproduced or distributed in any form without Gartner’s prior written permission. It consists of the opinions of Gartner’s research organization, which should not be construed as statements of fact. While the information contained in this publication has been obtained from sources believed to be reliable, Gartner disclaims all warranties as to the accuracy, completeness or adequacy of such information. Although Gartner research may address legal and financial issues, Gartner does not provide legal or investment advice and its research should not be construed or used as such. Your access and use of this publication are governed by Gartner’s Usage Policy. Gartner prides itself on its reputation for independence and objectivity. Its research is produced independently by its research organization without input or influence from any third party. For further information, see Guiding Principles on Independence and Objectivity.

Already have a Gartner Account?

Become a client