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. 🙂
Categories: Data integration and middleware, Data warehousing, Emulation, transparency, portability, Hadoop, SQL/Hadoop integration, Teradata
Subscribe to our complete feed!
Comments
2 Responses to “Teradata SQL-H”
Leave a Reply
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/
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?