SQL in Hadoop: The Real Deal


Today, Actian announced availability of the new Hadoop SQL Edition of its Actian Analytics Platform along with the impressive high performance SQL on (make that “in”) Hadoop capability (code named:  Vortex).

While every vendor under the sun seems to be plugging their solution as the best way to access Hadoop data, it reminds me of the medicine shows of “wild west days” where traveling horse and wagon teams would peddle their “miracle cure” medications between various entertainment acts.  Now, of course, instead of horses, it’s with teams of elephants.

The challenge with these SQL on Hadoop “snake oil elixir” vendors is that they all fall short of delivering what the millions of SQL users are looking for when they ask for SQL access.  If you look closely, you will quickly see that these “elixir” salesmen fall into one of 3 buckets (make that bottles):  1) marketing hype – claim to be SQL on Hadoop but require you to move data out of Hadoop into another database, 2) wrappers – offer mature SQL support but data is stored outside of HDFS in yet another file system, 3) integrated but immature – run natively in Hadoop but SQL support is limited, immature and not enterprise-ready.

SQL users want “industrialized” SQL which means they want mature enterprise-ready solutions that are fast, secure, reliable and can scale for all of their users and applications.  Plus, they want to be able to use the full SQL language without constraints.   And, they want to run SQL on the freshest Hadoop data which means they don’t want to have to move data out of Hadoop into another database each time they want to run a query.

Actian’s approach to SQL on Hadoop is the real deal.  That’s why we refer to it as, “SQL in Hadoop.” It’s mature SQL and fully integrated into Hadoop.  Actian has taken the world’s fastest TPC-benchmarked analytic database (Actian Vector) and extended it to run inside Hadoop natively via YARN.   Industrialized SQL in Hadoop is married with an analytics & data science workbench enabling users to discover nuggets of valuable data hidden in Hadoop and make it accessible to all their SQL users.   In essence, Actian has transformed Hadoop from a low cost data storage lake into a high performance analytics platform.

So, stop looking for the miracle “SQL on Hadoop” elixir.   Get “SQL in Hadoop,” the true medicine your organization needs to get real value from all your Hadoop data.

Here’s a checklist of useful information about the new Actian Analytics Platform – Hadoop SQL Edition:

1)      Press Announcement

2)      AAP – Hadoop SQL Edition Webpage

3)      AAP – Hadoop SQL Edition Product Brochure

4)      Vector in Hadoop Datasheet

5)      Technical White Paper

About James Hare

Jim Hare is Senior Director of Product Marketing for the Actian Analytics Platform helping organizations transform big data into business value. Prior to Actian, he was Director of Marketing at IBM responsible for go-to-market strategy and messaging for the big data platform. Prior to joining IBM in 2008, Jim was vice-president of product marketing and business development at Celequest, a California-based operational business intelligence vendor, which was acquired by Cognos in 2007. He has over 16 years of experience in enterprise software and deep experience in business intelligence, business process management, business activity monitoring, big data, and automated software testing & monitoring. Jim holds a MS in Systems Management from the University of Southern California, and an undergraduate degree from the University of Colorado at Boulder. When he is not heads down focused on finding new ways to use big data, you will find Jim with his amazing wife and daughter and sometimes on the ski slope (when there is snow) or improvising at his piano.

View all posts by James Hare →

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>