sql-scripts/load.sql at main · MonetDBSolutions/sql-scripts · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
COPY OFFSET 2 INTO name_basics FROM '/home/john/Projects/imdb/data/name.basics.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';

COPY OFFSET 2 INTO title_akas FROM '/home/john/Projects/imdb/data/title.akas.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';

COPY OFFSET 2 INTO title_basics FROM '/home/john/Projects/imdb/data/title.basics.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';

COPY OFFSET 2 INTO title_crew FROM '/home/john/Projects/imdb/data/title.crew.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';

COPY OFFSET 2 INTO title_episode FROM '/home/john/Projects/imdb/data/title.episode.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';

COPY OFFSET 2 INTO title_principals FROM '/home/john/Projects/imdb/data/title.principals.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';

COPY OFFSET 2 INTO title_ratings FROM '/home/john/Projects/imdb/data/title.ratings.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';