Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    sales and data analytics
    How Data Analytics Improves Lead Management and Sales Results
    9 Min Read
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
    big data and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Teradata Aster Standardizes Access to Hadoop with SQL-H
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Software > Hadoop > Teradata Aster Standardizes Access to Hadoop with SQL-H
AnalyticsHadoopSQL

Teradata Aster Standardizes Access to Hadoop with SQL-H

Mark Smith
Mark Smith
4 Min Read
SHARE

Using Hadoop just got easier, thanks to Teradata’s introduction of SQL-H, a new query interface to analyze data from Hadoop.  Most Hadoop access methods require preprocessing and staging of data from the Hadoop Distributed File System (HDFS) using technologies such as MapReduce.

Using Hadoop just got easier, thanks to Teradata’s introduction of SQL-H, a new query interface to analyze data from Hadoop.  Most Hadoop access methods require preprocessing and staging of data from the Hadoop Distributed File System (HDFS) using technologies such as MapReduce. These approaches require new skills and technologies, introducing more time and costs for users, which offset the benefits of Hadoop, which according to our big data benchmark research include increasing the speed of analysis. Teradata has announced support for SQL-H not only for its own Aster Database 5.0, which it expects to release in the third quarter, but also supporting the commercial version of Hadoop through Hortonworks.

Use of a familiar query interface, by contrast, reduces staffing and training issues required for learning more Hadoop-specific interfaces, which our research found to be the top two obstacles to big data analytics. Teradata Aster accomplishes this through utilizing use of HCatalog to get access to metadata that can be queried against using Aster SQL, ODBC, JDBC and ultimately any analytics or business intelligence tool, since the data then looks like a database table structure. The need to extract and store data from Hadoop into other database systems and thereby lose the computing power of Hadoop has been the Achilles heel of this big data technology. Analysts who want interactive and iterative discovery of their data now do not have to depend on the Hadoop Hive query language interface and can use more familiar tools like MicroStrategy and Tableau for analytics. Teradata Aster incorporates derivative analytics in its technology to be applied to data in Hadoop, including the customer and transaction data that, according to our research, top the list of types used. Its capabilities include analytics around paths, text, statistics, segmentation and broader customer interaction.

Teradata Aster has an advantage over EMC Greenplum, IBM and Oracle, which do not provide this level of direct integration with Hadoop today. Their approach requires data duplication and does not leverage the extended power of Hadoop and use of HCatalog for metadata knowledge about the data itself. I expect that if other vendors want to exploit the power of Hadoop they will need to expand their support of it over the coming year.

More Read

Email Gaining Ground, Says Forrester
Use this Strategic Approach to Maximize Your Data’s Value
Why Oh Why Is It So Difficult? Implementing Sales and Operations Planning
Predictive Analytics: 4 Primary Aspects of Predictive Analytics
Engaging Customers on Facebook

The introduction of SQL-H in Teradata Aster helps analysts streamline their analytics while reducing the custom coding and development required from IT staffers. Utilizing the Aster platform provides other computational processing advantages in its scale-out approach using a range of server technologies. According to our research, one-third of organizations plan to use Hadoop. For Teradata Aster, support for Hadoop builds on its existing big data support. Organizations looking to further exploit Hadoop  to analyze large volumes of data quickly should find Teradata Aster SQL-H a welcome advancement for their data and analytic options.

Regards,

Mark Smith – CEO & Chief Research Officer

Filed under: Big Data, Business Analytics, Business Intelligence (BI), Information Management (IM) Tagged: Aster, Big Data, CIO, Data, Hadoop, HortonWorks, Information Management, SQL-H, Teradata

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

sales and data analytics
How Data Analytics Improves Lead Management and Sales Results
Analytics Big Data Exclusive
ai in marketing
How AI and Smart Platforms Improve Email Marketing
Artificial Intelligence Exclusive Marketing
AI Document Verification for Legal Firms: Importance & Top Tools
AI Document Verification for Legal Firms: Importance & Top Tools
Artificial Intelligence Exclusive
AI supply chain
AI Tools Are Strengthening Global Supply Chains
Artificial Intelligence Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

Text Mining & Analytics – Correlating Social Intelligence with Traditional Data

5 Min Read

First Look – Starview

6 Min Read
Image
AnalyticsCulture/LeadershipData MiningDecision ManagementNewsPredictive Analytics

Business Analytics and Hollywood: A Match Made in Heaven?

5 Min Read

What Is a Data Scientist (and What Isn’t)?

7 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?