Pigi project is solution for indexing problem in HBase (or any other column oriented database). Especially it provides mechanisms for maintaining one to many relations between objects stored in database (of course with some limitations). Actual list of Pigi features covers:
It's important to understand that Pigi is not SQL for HBase. In fact Pigi doesn't bring any script language. It's rather ORM-like Java framework.