Apache Drill query to group by in Apache HBase

first_query.sql

0: jdbc:drill:zk=local> SELECT CONVERT_FROM(row_key, 'UTF8') AS clickid, 
. . . . . . . . . . . >        CONVERT_FROM(clicks.clickinfo.studentid, 'UTF8') AS studentid, 
. . . . . . . . . . . >        CONVERT_FROM(clicks.clickinfo.`time`, 'UTF8') AS `time`,
. . . . . . . . . . . >        CONVERT_FROM(clicks.clickinfo.url, 'UTF8') AS url 
. . . . . . . . . . . > FROM hbase.clicks WHERE clicks.clickinfo.url LIKE '%google%'; 
+----------+------------+---------------------------+------------------------+
| clickid  | studentid  |           time            |          url           |
+----------+------------+---------------------------+------------------------+
| click1   | student1   | 2014-01-01 12:01:01.0001  | http://www.google.com  |
| click3   | null       | 2014-01-01 01:02:01.0001  | http://www.google.com  |
| click6   | null       | 2013-02-01 12:01:01.0001  | http://www.google.com  |
+----------+------------+---------------------------+------------------------+
3 rows selected (2.24 seconds)