News for hackers. Stuff that matters.
Re:Google makes BigQuery available in Sheets by spaceheretostay on Friday April 12, 2019 @01:58AM (#19642344)
All this fancy stuff, but where's my Sets at? Google took down the website like 15 years ago. I used that thing daily. Then they put it into Google Sheets. You could type "apple" then "pear" then "orange" and then select cells, drag, and you'd get a list of fruits! Some you never heard of before!

I looked around and Google has a patent on it, and seemingly no public implementation. This makes me super sad because I honestly considered Sets one of the most useful exploration and ideation tools ever created.

BigQuery in Sheets, cool I guess? I want Sets back.

Re:Google makes BigQuery available in Sheets by steve19 on Friday April 12, 2019 @02:26AM (#19642473)
Re:Google makes BigQuery available in Sheets by appleflaxen on Saturday April 13, 2019 @05:02AM (#19651883)
that's the same functionality, but the results are not as good.

I put in: fat obese porcine

I get: wild-type hyperactive amnesic misshapen narcissistic slimy cancerous motile putrid gravid

Re:Google makes BigQuery available in Sheets by mej10 on Saturday April 13, 2019 @12:10PM (#19653829)
I wonder how enforceable that patent is.
Re:Google makes BigQuery available in Sheets by Amazonerh on Saturday April 13, 2019 @06:58AM (#19652229)
What's a use case for this?
Re:Google makes BigQuery available in Sheets by hnuser123456 on Friday April 12, 2019 @05:32AM (#19643369)
Still not as cool as Google Squared, where 10 years ago, you could create rows of any nouns and cols of any adjectives, and it would automagically research and fill out all the data for you according to its best guess. Create rows of car models, cols of price, seating, horsepower, safety rating, stuff like that.
Re:Google makes BigQuery available in Sheets by dannyw on Friday April 12, 2019 @08:34AM (#19644193)
That’s all in Google Knowledge Graph. They dropped it because it makes finding information too easy. And hence, competitor search engines could get info out of it super cheaply.
Re:Google makes BigQuery available in Sheets by burke on Friday April 12, 2019 @01:42PM (#19647155)
This reason is so much more disappointing than what I had previously assumed.
Re:Google makes BigQuery available in Sheets by nevir on Friday April 12, 2019 @02:38PM (#19647746)
Seems unlikely to be the real reason
Re:Google makes BigQuery available in Sheets by arbie on Sunday April 14, 2019 @04:29PM (#19661512)
Seems convincing. Likely the same reasoning behind removing Real-Time results.
Re:Google makes BigQuery available in Sheets by edraferi on Friday April 12, 2019 @10:42AM (#19645187)
Boo! I’d love to have nice hooks into Knowledge Graph.
Re:Google makes BigQuery available in Sheets by londons_explore on Friday April 12, 2019 @04:48AM (#19643153)
I don't know how Google's implementation of sets worked, but a simple implementation you could do yourself in a Jupiter notebook is to load up some pretrained word vectors, normalize all vectors, look up the vectors for all words in your seed set, take the mean of them, and then look for the nearest neighbours.

Stick it on a website and then the rest of the world can use it too!

Re:Google makes BigQuery available in Sheets by davnn on Friday April 12, 2019 @05:25AM (#19643330)