Skip to content

Instantly share code, notes, and snippets.

@firemonk9

firemonk9/data_gen.sql

Created September 28, 2020 20:28
Show Gist options
  • Save firemonk9/7d390938f5e0bb09c12c1bb2aa0eb07f to your computer and use it in GitHub Desktop.
Save firemonk9/7d390938f5e0bb09c12c1bb2aa0eb07f to your computer and use it in GitHub Desktop.
Download ZIP
sample sql code to generate volume data
Raw
data_gen.sql
CREATE TABLE dataq_demo.large_test (num1 bigint, num2 double precision, num3 double precision);
INSERT INTO dataq_demo.large_test (num1, num2, num3)
SELECT round(random()*10), random(), random()*142
FROM generate_series(1, 20000000) s(i);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment