[03:18:15] PROBLEM - WDQS SPARQL on wdqs1006 is CRITICAL: CRITICAL - Socket timeout after 10 seconds https://wikitech.wikimedia.org/wiki/Wikidata_query_service/Runbook [03:23:01] RECOVERY - WDQS SPARQL on wdqs1006 is OK: HTTP OK: HTTP/1.1 200 OK - 691 bytes in 8.186 second response time https://wikitech.wikimedia.org/wiki/Wikidata_query_service/Runbook [05:02:48] Hi, yesterday I was asking about doing SQL queries on the Wikidata replica clusters, but I was told that you can't do it in a way analogous to SPARQL because the entire content of the item is in a JSON blob. However, Quarry seems to be able to do queries: https://meta.wikimedia.org/wiki/Research:Quarry Am I misunderstanding something? Is it not [05:02:48] what I was looking for? [08:05:12] sdesalcala: you can query the sql tables using quarry, but that doesn't help you query wikidata because the content in wikidata is not stored as sql tables [08:06:19] it's stored as a json blob, as you're aware, and, as I understand it, the servers that quarry uses don't include that json blob (presumably because it's huge and you can't query it efficiently from sql anyway) [08:07:46] I'm sorry, but then I don't understand... then what can you do with Quarry? The example queries they give seem to be very "SPARQL"-y, in the sense that they seem to be quering the database [08:09:14] example of what I'm talking about: https://quarry.wmflabs.org/query/3351 [08:11:34] you can do things like find out which pages in wikipedia are in a particular category or use a particular template or when they were last edited [08:12:29] and yes, there is *some* data in sql, the labels, descriptions and sitelinks iirc, but if you want to do something like find all humans, that's not possible [08:15:28] I see, thank you so much for the clarification.