Files
@ da44a6058868
Branch filter:
Location: DA/monetdblite-experiments/hmda-dump.sql - annotation
da44a6058868
2.4 KiB
application/sql
plots
0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a 0a35fe431f8a | COPY SELECT * FROM hmda_06 SAMPLE 10000 INTO '/scratch/hannes/hmda/hmda_06_1.csv';
COPY SELECT * FROM hmda_06 SAMPLE 100000 INTO '/scratch/hannes/hmda/hmda_06_2.csv';
COPY SELECT * FROM hmda_06 SAMPLE 1000000 INTO '/scratch/hannes/hmda/hmda_06_3.csv';
COPY SELECT * FROM hmda_06 SAMPLE 10000000 INTO '/scratch/hannes/hmda/hmda_06_4.csv';
COPY SELECT * FROM hmda_06 INTO '/scratch/hannes/hmda/hmda_06_f.csv';
COPY SELECT * FROM hmda_07 SAMPLE 10000 INTO '/scratch/hannes/hmda/hmda_07_1.csv';
COPY SELECT * FROM hmda_07 SAMPLE 100000 INTO '/scratch/hannes/hmda/hmda_07_2.csv';
COPY SELECT * FROM hmda_07 SAMPLE 1000000 INTO '/scratch/hannes/hmda/hmda_07_3.csv';
COPY SELECT * FROM hmda_07 SAMPLE 10000000 INTO '/scratch/hannes/hmda/hmda_07_4.csv';
COPY SELECT * FROM hmda_07 INTO '/scratch/hannes/hmda/hmda_07_f.csv';
COPY SELECT * FROM hmda_08 SAMPLE 10000 INTO '/scratch/hannes/hmda/hmda_08_1.csv';
COPY SELECT * FROM hmda_08 SAMPLE 100000 INTO '/scratch/hannes/hmda/hmda_08_2.csv';
COPY SELECT * FROM hmda_08 SAMPLE 1000000 INTO '/scratch/hannes/hmda/hmda_08_3.csv';
COPY SELECT * FROM hmda_08 SAMPLE 10000000 INTO '/scratch/hannes/hmda/hmda_08_4.csv';
COPY SELECT * FROM hmda_08 INTO '/scratch/hannes/hmda/hmda_08_f.csv';
COPY SELECT * FROM hmda_09 SAMPLE 10000 INTO '/scratch/hannes/hmda/hmda_09_1.csv';
COPY SELECT * FROM hmda_09 SAMPLE 100000 INTO '/scratch/hannes/hmda/hmda_09_2.csv';
COPY SELECT * FROM hmda_09 SAMPLE 1000000 INTO '/scratch/hannes/hmda/hmda_09_3.csv';
COPY SELECT * FROM hmda_09 SAMPLE 10000000 INTO '/scratch/hannes/hmda/hmda_09_4.csv';
COPY SELECT * FROM hmda_09 INTO '/scratch/hannes/hmda/hmda_09_f.csv';
COPY SELECT * FROM hmda_10 SAMPLE 10000 INTO '/scratch/hannes/hmda/hmda_10_1.csv';
COPY SELECT * FROM hmda_10 SAMPLE 100000 INTO '/scratch/hannes/hmda/hmda_10_2.csv';
COPY SELECT * FROM hmda_10 SAMPLE 1000000 INTO '/scratch/hannes/hmda/hmda_10_3.csv';
COPY SELECT * FROM hmda_10 SAMPLE 10000000 INTO '/scratch/hannes/hmda/hmda_10_4.csv';
COPY SELECT * FROM hmda_10 INTO '/scratch/hannes/hmda/hmda_10_f.csv';
COPY SELECT * FROM hmda_11 SAMPLE 10000 INTO '/scratch/hannes/hmda/hmda_11_1.csv';
COPY SELECT * FROM hmda_11 SAMPLE 100000 INTO '/scratch/hannes/hmda/hmda_11_2.csv';
COPY SELECT * FROM hmda_11 SAMPLE 1000000 INTO '/scratch/hannes/hmda/hmda_11_3.csv';
COPY SELECT * FROM hmda_11 SAMPLE 10000000 INTO '/scratch/hannes/hmda/hmda_11_4.csv';
COPY SELECT * FROM hmda_11 INTO '/scratch/hannes/hmda/hmda_11_f.csv';
|