4 ms·
Very cool, thanks! Looking forward to playing around with this. FYI, you named a column a reserved sql keyword ('by'). For future reference, and for others rea
by rm999 11y ago
Very cool, thanks! Looking forward to playing around with this.
FYI, you named a column a reserved sql keyword ('by'). For future reference, and for others reading this: this is bad database design and makes it harder to use the table. You can get around this by wrapping the column name in brackets, like:
>select ... where [by] = ...
- fhoffa 11y agoI didn't name the column "by", I just gave the field the name that the API uses for it. And to make everyone's lives easier (including mine), I copied the [by] column to an [author] column, so you can do a >select ... where author = ... instead :)
- malkia 11y agoOh, first I thought there is some difference and did this: SELECT * FROM [fh-bigquery:hackernews.stories] WHERE [by] != author