Skip to content

Instantly share code, notes, and snippets.

@ajw0100
Created August 27, 2015 17:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ajw0100/985809cfa6a1d62b5a3c to your computer and use it in GitHub Desktop.
Save ajw0100/985809cfa6a1d62b5a3c to your computer and use it in GitHub Desktop.
Decimal Binary
------- ------
0 0000000000000000
205 0000000011001101 Interleave the min(compressed_val) for each
205 0000000011001101 sort key column and we get the min(minvalue)
0 0000000000000000 from stv_blocklist
-------------------------------------------------------------------------------
1711302150 0000000000000000000000000000000001100110000000000110011000000110
1023 0000001111111111
1023 0000001111111111 Interleave the max(compressed_val) for each
1023 0000001111111111 sort key column and we get the max(maxvalue)
1023 0000001111111111 from stv_blocklist
-------------------------------------------------------------------------------
1099511627775 0000000000000000000000001111111111111111111111111111111111111111
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment