Skip to content

Instantly share code, notes, and snippets.

@bcambel

bcambel/group_by.sql

Created December 1, 2015 20:46
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save bcambel/84c06c6c048652c6245e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save bcambel/84c06c6c048652c6245e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
group_by.sql
0: jdbc:drill:zk=local> SELECT count(CONVERT_FROM(row_key, 'UTF8')) AS clickid,
. . . . . . . . . . . > CONVERT_FROM(clicks.clickinfo.url, 'UTF8') AS url
. . . . . . . . . . . > FROM hbase.clicks
. . . . . . . . . . . > GROUP BY clicks.clickinfo.url;
+----------+-------------------------+
| clickid | url |
+----------+-------------------------+
| 3 | http://www.google.com |
| 2 | http://www.ask.com |
| 3 | http://www.amazon.com |
| 1 | http://www.reuters.com |
+----------+-------------------------+
4 rows selected (3.066 seconds)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment