Skip to content

Instantly share code, notes, and snippets.

@randyzwitch

randyzwitch/201801_loadingfailure.sh

Created November 6, 2019 21:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save randyzwitch/b82823efd1eb575c27944bf1d1b4c2d3 to your computer and use it in GitHub Desktop.
Save randyzwitch/b82823efd1eb575c27944bf1d1b4c2d3 to your computer and use it in GitHub Desktop.
Download ZIP
Failure to load any records in OmniSci
Raw
201801_loadingfailure.sh
omnisql> copy baywheels_tripdata from 's3://baywheels-data/201801-fordgobike-tripdata.csv.zip';
Result
Loaded: 0 recs, Rejected: 94802 recs in 5.752000 secs
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment