marklit/bigint_uuid.py

Last active August 22, 2017 20:10

Star (3) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/marklit/b3f362bc382a448cae73.js"></script>
Save marklit/b3f362bc382a448cae73 to your computer and use it in GitHub Desktop.

Download ZIP

UUIDs that fit in the AWS Redshift BIGINT field type

Raw

bigint_uuid.py

	import hashlib
	import uuid


	int(hashlib.sha1(str(uuid.uuid4()).replace('-', '')).hexdigest(), 16) % 2147483647

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment