Let's get hands on with SQL for Hadoop & HBase - Developer Day

  • February 4, 2014 · 11:00 AM
  • IBM



Hive is a runtime Hadoop® support structure that allows anyone who is already fluent with SQL (which is commonplace for relational database developers) to leverage the Hadoop platform right out of the gate.  Hive allows SQL developers to write Hive Query Language (HQL) statements that are similar to  standard SQL statements.  HQL statements are broken down by the Hive service into MapReduce jobs and executed across a Hadoop cluster.

IBM® Big SQL is a data warehouse system for Hadoop that you use to summarize, query, and analyze data.  Big SQL provides SQL access to data that is stored in InfoSphere® BigInsights™ by using JDBC or ODBC connections.  Big SQL provides broad SQL support that is typical of commercial databases. You can issue JDBC queries or ODBC queries to access data that is stored in InfoSphere BigInsights, in the same way that you access databases from your enterprise applications.

You can use Big SQL to issue queries of any size, including concurrent queries. Big SQL provides support for large ad-hoc queries by using MapReduce parallelism and point queries, which are low-latency queries that return information quickly to reduce response time and provide improved access to data.  

HBase is a column-oriented database management system that runs on top of HDFS. It is well suited for sparse data sets, which are common in many big data use cases. Unlike relational database systems, HBase does not support a structured query language like SQL; in fact, HBase isn’t a relational data store at all.  HBase applications are typically written in Java much like a MapReduce application or in other languages by using Apache Thrift.  However, HBase can be queried with SQL when combined with Hive and or Big SQL!

Apache Accumulo, like HBase, derives from Google's BigTable technology.  While the two technologies are similar in architecture, Accumulo excels in security right down to the cell level.  Attendees will receive an introduction to Apache Accumulo and hear about IBM's Accumulo research project.

Join us from 11:00am - 6:00pm on February the 4th to learn about Big SQL, Hive and HBase. Register at: http://ibm.co/19APszk

Attendees will learn how these three technologies complement each other and experience hands-on 

lab exercises to enhance your understanding.  Attendees will leverage the BigInsights Quick Start Edition for all lab exercises and be able to continue using the Hadoop based technology after the Meetup.

You must register at: http://ibm.co/19APszk in order to guarantee a seat at this Big Data Developer Day event.

Join or login to comment.

  • xiaofei k.

    Big data is the bright future of data.

    November 30

  • Ann V.

    Extremely valuable

    February 4, 2014

  • Jose Luis M.

    do we need to bring a laptop for the lab exercises? any software we need to have pre-installed ?

    February 2, 2014

  • Tarun

    Registered but i received an email saying my registration is pending

    January 27, 2014

  • IBM Big D.

    SEATING IS LIMITED - REGISTER NOW. http://ibm.co/19APszk

    January 23, 2014

  • Raviteja V.

    Can we have it on weekend?

    January 16, 2014

    • IBM Big D.

      Unfortunately, we cannot hold this event on the weekend.

      January 23, 2014

People in this
Meetup are also in:

Imagine having a community behind you

Get started Learn more

We just grab a coffee and speak French. Some people have been coming every week for months... it creates a kind of warmth to the group.

Rafaël, started French Conversation Group

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy