Skip to content

Instantly share code, notes, and snippets.

@randyzwitch

randyzwitch/june_2019.sql

Created November 6, 2019 21:56
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/5609672af3641333c8498d000ef575eb to your computer and use it in GitHub Desktop.
Save randyzwitch/5609672af3641333c8498d000ef575eb to your computer and use it in GitHub Desktop.
Download ZIP
June 2019 file fails
Raw
june_2019.sql
omnisql> copy baywheels_tripdata from 's3://baywheels-data/201905-baywheels-tripdata.csv.zip';
Result
Loaded: 182163 recs, Rejected: 0 recs in 2.440000 secs
omnisql> copy baywheels_tripdata from 's3://baywheels-data/201906-baywheels-tripdata.csv.zip';
Result
Loader truncated due to reject count. Processed : 0 recs, Rejected: 191772 recs in 8.323000 secs
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment