Skip to content

Instantly share code, notes, and snippets.

@robjshaw

robjshaw/stash analytics via apache drill

Last active January 12, 2016 22:46
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save robjshaw/6feb62fe0005c5907d85 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save robjshaw/6feb62fe0005c5907d85 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
stash analytics via apache drill
curl -u xxxxxx:xxxx
https://stash.xxxxxxxx.net/rest/api/1.0/projects/AB/repos/xxxxxxxx/pull-requests?state=MERGED\&limit=100
> t.txt
jdbc:drill:zk=local> SELECT count(*), t.flatdata.author.`user`.`emailAddress`
FROM (SELECT FLATTEN(`values`) as flatdata FROM dfs.rob.`t.json`) t
GROUP BY t.flatdata.author.`user`.`emailAddress`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment