Hacker News Reader

I uploaded these datasets to Google BigQuery in case anybody prefers to use that to go data-diving: https://bigquery.cloud.google.com/table/833682135931:nyctaxi... https://bigquery.cloud.google.com/table/833682135931:nyctaxi...

View on HN

This is great. Is there anyway you could use data types other than string? The way it's currently setup makes it hard to analyze.

Sure, it wouldn't be hard to re-load the data in a new dataset/table with more accurate types. Strings are just the default. I just wasn't sure how clean the data was and didn't want to debug bad data before loading. I was lazy basically.

But if you wanted to do it, it's pretty straightforward.

In the meantime I haven't found it to be too hard to just INTEGER(field) and FLOAT(field) wherever I need to.

Reply on news.ycombinator.com