File: f1db-citus.load

package info (click to toggle)
pgloader 3.6.9-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 12,040 kB
  • sloc: sql: 32,321; lisp: 14,792; makefile: 439; sh: 85; python: 26
file content (19 lines) | stat: -rw-r--r-- 708 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
load database
  from mysql://root@localhost/f1db?useSSL=false
  into pgsql://localhost:9700/dim

  with reset no sequences

  distribute f1db.circuits as reference table
  distribute f1db.constructorResults using raceId
  distribute f1db.constructors as reference table
  distribute f1db.constructorStandings using raceId
  distribute f1db.drivers as reference table
  distribute f1db.driverStandings using raceId
  distribute f1db.lapTimes using raceId
  distribute f1db.pitStops using raceId
  distribute f1db.qualifying using raceId
  distribute f1db.races as reference table
  distribute f1db.results using raceId
  distribute f1db.seasons as reference table
  distribute f1db.status as reference table;