With IBM’s Big SQL technology, you can use InfoSphere® BigInsights™ to query HBase using industry-standard SQL. This two-part series focuses on creating tables, data-loading methods, and query handling. Here in Part 1, learn fundamental usage of IBM’s Big SQL technology for Hadoop over HBase by creating tables and examining ways to load data. Follow a basic storyline of migrating a relational table to HBase using Big SQL. Part 2 explores query handling, and how to connect to Big SQL via JDBC to run business intelligence and reporting tools, such as BIRT and Cognos®.
Author: Piotr Pruski, Benjamin Leonhardi, Deepa Remesh, Bruce Brown