Skip to content

Instantly share code, notes, and snippets.

@staslev
Created February 2, 2014 16:24
Show Gist options
  • Save staslev/8770842 to your computer and use it in GitHub Desktop.
Save staslev/8770842 to your computer and use it in GitHub Desktop.
q -t "select c6,c17,c26,c11,cast(c2 /15000 as integer) * 15000, count(*) from filtered_output.txt where c2 >=TIME_STAMP_A and c2 <= TIME_STAMP_B group by c6,c17,c26,c11,cast(c2 /15000 as integer) * 15000"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment