Perhaps you’ve heard about Big SQL 3.0, IBM’s latest technology for SQL on Hadoop. ¬†Maybe you’ve read the white paper or watched the presentation recorded during a MeetUp at Hadoop Summit in June. ¬†They’re both good ways to get familiar with the basic concepts and features of Big SQL 3.0.
But what if you want to get beyond the buzz and test the technology yourself? ¬† Well, one of the easiest ways to do that is to download the free BigInsights Quick Start Edition VMware image.¬† Then you can follow the new Big SQL hands-on lab exercises published on Hadoop Dev. ¬†This first installment of Big SQL labs helps you get off to quick start.
- Lab 1 brings you up to speed on the BigInsights QSE environment and VMware image configuration.
- Lab 2 teaches you how to use the¬†Java SQL Shell (JSqsh), a command line interface for Big SQL. ¬†You’ll create tables, execute simple queries, and learn popular JSqsh commands.
- Lab 3¬†introduces you to Big SQL development with Eclipse.
- Lab 4 helps you explore more sophisticated query scenarios using a star schema style database environment with FACT and DIMENSION tables. ¬†You’ll create these tables, populate them with data, and query these tables using projections, restrictions, joins, aggregations, and other SQL expressions.
And that’s just the beginning. ¬† Over the next several weeks, you can expect to find more Big SQL 3.0 lab exercises written by developers for developers. ¬†Topics will include ¬†working with social media data using BigSheets and Big SQL, employing SerDes (serializers / deserializers), enhancing Big SQL security with fine-grained access control mechanisms (such as column masks and row permissions), collecting statistics for use by the query optimizer, and exploring data access plans.
Of course, if you want to read more about BigInsights and Big SQL 3.0, you can always visit the product Knowledge Center, which contains the official IBM documentation, including ample reference materials and tutorials on key tasks.