ES 聚合

1.企业 发表专利数量趋势

GET patent/patent_data/_search
{
    "size": 0,
    "query": { "bool": { "must": [ { "range": { "application_date": { "gte": "2008","lte":"2018","format": "yyyy" } } }, { "term": { "applicants.name.original.keyword": "国家电网公司" } } ] } },
    "aggs": { "by_key1": { "date_histogram": { "field": "application_date", "interval": "year", "format": "yyyy" , "order": { "_key": "desc" } } } }
}

2.高校发表论文数量趋势

GET paper/paper_data/_search
{
    "size": 0,
    "query": { "bool": { "must": [ { "term": { "mechanism.keyword": "浙江大学" } }, { "range": { "publishTime": { "gte": "2008","lte":"2018","format": "yyyy" } } } ] } },
    "aggs": { "by_key1": { "date_histogram": { "field": "publishTime", "interval": "year", "format": "yyyy" , "order": { "_key": "desc" } } } }
}

3.专家发表专利数量趋势

GET patent/patent_data/_search
{
    "size": 0,
    "query": { "bool": { "must": [ { "term": { "inventors.name.original.keyword": "刘涛" } }, { "range": { "application_date": { "gte": "2008","lte":"2018","format": "yyyy" } } } ] } },
    "aggs": { "by_key1": { "date_histogram": { "field": "application_date", "interval": "year", "format": "yyyy" , "order": { "_key": "desc" } } } }
}

4.专家发表论文 数量趋势

GET paper/paper_data/_search
{
    "size": 0,
    "query": { "bool": { "must": [ { "term": { "authors.name": "李健" } }, { "range": { "publishTime": { "gte": "2008", "lte": "2019", "format": "yyyy" } } } ] } }
    "aggs": { "by_key1": { "date_histogram": { "field": "publishTime", "interval": "year", "format": "yyyy", "order": { "_key": "desc" } }, "aggs": { "by_key2": { "terms": { "field": "magazine.keyword" } } } } }
}

5.高校专利top10专家

GET hut_patent/patent_data/_search
{
    "size":0,
    "query": { "bool": { "must": [ { "term": { "applicants.name.original.keyword":"湖南工业大学" } } ] } }, 
    "aggs":{ "by_key1":{ "terms":{ "field":"inventors.name.original.keyword", "order":{ "_count":"desc" }, "size": 10 } } }
}

6.高校/论文top10专家

GET hut_paper/paper_data/_search
{
    "size":0,
    "query": { "bool": { "must": [ { "term": { "mechanism.keyword":"湖南工业大学" } } ] } }, 
    "aggs":{ "by_key1":{ "terms":{ "field":"authors.name", "order":{ "_count":"desc" }, "size": 10 } } }
}

7.专家论文的技术关键字词云

GET paper/paper_data/_search
{
    "size":0,
     "query": { "bool": { "must": [ { "term": { "authors.name":"刘涛" } } ] } },
   "aggs":{ "by_key1":{ "terms":{ "field":"keywords.keyword", "order":{ "_count":"desc" }, "exclude": "(.){1,2}", "size": 80 }  } }
}

8.专家 top10 专利合作作者

 GET patent/patent_data/_search
{
    "size": 0,
    "query": { "bool": { "must": [ { "term": { "inventors.name.original.keyword":"刘涛" } } ] } },
    "aggs": { "by_key1": { "terms": { "field": "inventors.name.original.keyword" } } }
}

9.专家 top10 论文合作作者

GET paper/paper_data/_search
{
    "size":0,
     "query": { "bool": { "must": [ { "term": { "authors.name":"刘涛" } } ] } },
    "aggs": { "by_key1": { "terms": { "field": "authors.name" } } }
}