Files
@ 64645fa186a6
Branch filter:
Location: DA/monetdblite-experiments/hmda-dump.sql - annotation
64645fa186a6
2.4 KiB
application/sql
mc
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';
|