April 15, 2013

Teradata SQL-H

As vendors so often do, Teradata has caused itself some naming confusion. SQL-H was introduced as a facility of Teradata Aster, to complement SQL-MR.* But while SQL-MR is in essence a set of SQL extensions, SQL-H is not. Rather, SQL-H is a transparency interface that makes Hadoop data responsive to the same code that would work on Teradata Aster …

*Speaking of confusion — Teradata Aster seems to use the spellings SQL/MR and SQL-MR interchangeably.

… except that now there’s also a SQL-H for regular Teradata systems as well. While it has the same general features and benefits as SQL-H for Teradata Aster, the details are different, since the underlying systems are.

I hope that’s clear. 🙂


2 Responses to “Teradata SQL-H”

  1. Steve Wooledge on April 16th, 2013 12:02 am

    Marketing and engineering aren’t always 100% aligned. 🙂 Despite any branding confusion, we are focused on extending the value of SQL and–as you pointed out in our last discussion–the vast number of BI tools that can now access advanced analytics (with SQL-MapReduce) and data in Hadoop (with SQL-H). To clarify a little bit more the differences of the SQL-* capabilities:

    SQL-MapReduce is a set of extensions to SQL which enable running MapReduce code through SQL. This enables non-programmers to start doing analytics with SQL and MapReduce. Using SQL-MapReduce, Aster provides its discovery portfolio of analytic functions – for path/pattern analysis, relationship and graph analysis, stats and machine learning, transformations, text analysis and more.

    SQL-H is technology which allows integrating the Teradata Database (or Aster Database) with Hadoop at the data and metadata layer. It integrates with Hadoop metadata (via HCatalog) and makes the tables defined in Hadoop accessible by the database. These tables from Hadoop can now be accessed through the mature DBMS – i.e. they inherit the entire implementation of ANSI SQL, enterprise-grade security, workload management and more from the database. The implementation of SQL-H in Teradata Database brings robust analytical capabilities of the Teradata RDBMS to data in Hadoop. More here: http://www.asterdata.com/blog/2013/04/the-enterprise-approach-to-interactive-sql-on-hadoop-data-teradata-sql-h/

  2. Charles Kibirango on September 23rd, 2013 12:34 pm

    I am in England, in the United Kingdom.
    I am interested in Teradata SQL-MR and Teradata SQL-H training and the other content that comes with those courses. Are those courses available here in the UK via Teradata Corp?

Leave a Reply

Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:


Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.