From 274da5d3994e9f1a4ddabf2d3ddba06c5db1aa73 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Wed, 1 Jul 2020 16:34:13 -0700 Subject: commit example of an elasticsearch SQL query --- extra/elasticsearch/sql_queries.md | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 extra/elasticsearch/sql_queries.md (limited to 'extra/elasticsearch') diff --git a/extra/elasticsearch/sql_queries.md b/extra/elasticsearch/sql_queries.md new file mode 100644 index 00000000..3ea168e5 --- /dev/null +++ b/extra/elasticsearch/sql_queries.md @@ -0,0 +1,8 @@ + +Top missing OA journals by `container_id`: + + POST _xpack/sql?format=txt + { + "query": "SELECT container_id, count(*) from fatcat_release WHERE preservation = 'none' AND is_oa = true GROUP BY container_id ORDER BY count(*) DESC LIMIT 20" + } + -- cgit v1.2.3