Choosing Your SQL Access Strategy for Hadoop


Archived Published: 20 February 2014 ID: G00256407

Analyst(s): |

Purchase this Document

Price: $195.00 USD (PAGES: 7)

To purchase this document, you will need to register or sign in above.

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

  • 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.

Why Gartner

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

Find out more