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. In Part 1, you explored Big SQL technology for Hadoop over HBase by creating tables and examining ways to load data. In this article, learn about query handling and how to connect to Big SQL via JDBC to run business intelligence and reporting tools such as BIRT or Cognos®.

Author: Piotr Pruski, Benjamin Leonhardi, Deepa Remesh, Bruce Brown

Link: http://www.ibm.com/developerworks/library/bd-bigsqlhbase2/index.html

PDF: http://www.ibm.com/developerworks/library/bd-bigsqlhbase2/bd-bigsqlhbase2-pdf.pdf

Link to Part 1: http://www.ibm.com/developerworks/library/bd-bigsqlhbase1/

Join The Discussion

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