facebook-graph-api - facebook react 将按 aggs 术语 elasticsearch 分组-6ren

facebook-graph-api - facebook react 将按 aggs 术语 elasticsearch 分组

转载作者：行者123 更新时间：2023-12-02 23:24:10

我正在研究 Facebook 分析，这是一个查询，它应该从 Facebook 页面帖子中获取 react 摘要，
注意:posts json 是因为它被插入到 elastic-search db

{
  "query": {
    "match": {
      "from.id": "[Page-id]"
    }
  },
     "aggs": {
       "summary_reaction": {
         "terms": {
           "field": "reactions.data.type.keyword"
         }
       }
     }
   }

唯一的问题是查询返回唯一计数，而它应该考虑所有反应。

我的结果是

"aggregations": {
    "reaction_summary": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 0,
      "buckets": [
        {
          "key": "LIKE",
          "doc_count": 2
        },
        {
          "key": "HAHA",
          "doc_count": 1
        }
      ]
    }
  }

这是示例 json

{
  "took": 4,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "failed": 0
  },
  "hits": {
    "total": 3,
    "max_score": 6.158189,
    "hits": [
      {
        "_index": "facebook_page",
        "_type": "post",
        "_id": "AV1RMRKSSM3OTvGpqzx7",
        "_score": 6.158189,
        "_source": {
          "reactions": {
            "paging": {
              "cursors": {
                "after": "TVRFMk9EYzVOekl5TWpjMU5USTJPakUxTURBek1EVTNOREU2TWpVME1EazJNVFl4TXc9PQZDZD",
                "before": "TVRFMk9EYzVOekl5TWpjMU5USTJPakUxTURBek1EVTNOREU2TWpVME1EazJNVFl4TXc9PQZDZD"
              }
            },
            "data": [
              {
                "pic_large": "https://fb-s-d-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p200x200/20108099_116879808942184_8792637908147052517_n.png?oh=4dcc9a9bbdfc965eb477a14775f31448&oe=5A0BCFB5&__gda__=1510661157_f329dd30b13490dbae8d05d3aa45d79f",
                "type": "LIKE",
                "id": "116879722275526",
                "name": "Moojaa"
              }
            ]
          },
          "from": {
            "picture": {
              "data": {
                "url": "https://fb-s-d-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p50x50/20108099_116879808942184_8792637908147052517_n.png?oh=24cc256b24e5da70f306afcf784a636d&oe=59FBA1D4&__gda__=1509895651_44acee6189c7c1cb6eed023a6e742d1a",
                "is_silhouette": false
              }
            },
            "name": "Moojaa",
            "id": "116879722275526"
          },
          "coordinates": {},
          "created_time": "2017-07-17T15:35:35+0000",
          "message": "Kuthey e Moojaa",
          "type": "status",
          "id": "116879722275526_116886608941504"
        }
      },
      {
        "_index": "facebook_page",
        "_type": "post",
        "_id": "AV1RMRViSM3OTvGpqzx8",
        "_score": 6.158189,
        "_source": {
          "reactions": {
            "paging": {
              "cursors": {
                "after": "TVRFMk9EYzVOekl5TWpjMU5USTJPakUxTURBek1EUTBNRGc2TWpVME1EazJNVFl4TXc9PQZDZD",
                "before": "TVRBd01ERTFOREl5TkRrNE56Y3dPakUxTURBek1EUTFNams2TWpVME1EazJNVFl4TXc9PQZDZD"
              }
            },
            "data": [
              {
                "pic_large": "https://fb-s-a-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p200x200/16864759_114731265717623_8811777667276972672_n.jpg?oh=836c6d5145bc8023d3ac60e0dfd42bde&oe=5A00D0DC&__gda__=1509885772_ad8923f4369250c2c2051c5e9293331f",
                "type": "LIKE",
                "id": "111467022710714",
                "name": "Ram Singh Shankar"
              },
              {
                "pic_large": "https://fb-s-d-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p200x200/20108099_116879808942184_8792637908147052517_n.png?oh=4dcc9a9bbdfc965eb477a14775f31448&oe=5A0BCFB5&__gda__=1510661157_f329dd30b13490dbae8d05d3aa45d79f",
                "type": "LIKE",
                "id": "116879722275526",
                "name": "Moojaa"
              }
            ]
          },
          "from": {
            "picture": {
              "data": {
                "url": "https://fb-s-d-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p50x50/20108099_116879808942184_8792637908147052517_n.png?oh=24cc256b24e5da70f306afcf784a636d&oe=59FBA1D4&__gda__=1509895651_44acee6189c7c1cb6eed023a6e742d1a",
                "is_silhouette": false
              }
            },
            "name": "Moojaa",
            "id": "116879722275526"
          },
          "coordinates": {},
          "comments": {
            "paging": {
              "cursors": {
                "after": "WTI5dGJXVnVkRjlqZAFhKemIzSTZANVEUyT0RneE5UUTRPVFF5TURFd09qRTFNREF6TURRMk5Eaz0ZD",
                "before": "WTI5dGJXVnVkRjlqZAFhKemIzSTZANVEUyT0RneE5EUXlNamMxTXpVME9qRTFNREF6TURRMk1URT0ZD"
              }
            },
            "data": [
              {
                "message": "test",
                "from": {
                  "picture": {
                    "data": {
                      "url": "https://fb-s-a-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p200x200/16864759_114731265717623_8811777667276972672_n.jpg?oh=836c6d5145bc8023d3ac60e0dfd42bde&oe=5A00D0DC&__gda__=1509885772_ad8923f4369250c2c2051c5e9293331f",
                      "is_silhouette": false
                    }
                  },
                  "name": "Ram Singh Shankar",
                  "id": "111467022710714"
                },
                "id": "116880885608743_116881442275354"
              },
              {
                "message": "test 2",
                "from": {
                  "picture": {
                    "data": {
                      "url": "https://fb-s-a-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p200x200/16864759_114731265717623_8811777667276972672_n.jpg?oh=836c6d5145bc8023d3ac60e0dfd42bde&oe=5A00D0DC&__gda__=1509885772_ad8923f4369250c2c2051c5e9293331f",
                      "is_silhouette": false
                    }
                  },
                  "name": "Ram Singh Shankar",
                  "id": "111467022710714"
                },
                "id": "116880885608743_116881548942010"
              }
            ]
          },
          "created_time": "2017-07-17T15:13:23+0000",
          "message": "another Mooja",
          "type": "status",
          "id": "116879722275526_116880885608743"
        }
      },
      {
        "_index": "facebook_page",
        "_type": "post",
        "_id": "AV1RMRgtSM3OTvGpqzx9",
        "_score": 6.158189,
        "_source": {
          "reactions": {
            "paging": {
              "cursors": {
                "after": "TVRBd01ERTFOREl5TkRrNE56Y3dPakUxTURBek1EUXpPRGM2TnpnNE5qUTRNRE0zT1RFek16RXkZD",
                "before": "TVRFMk9EYzVOekl5TWpjMU5USTJPakUxTURBek1EUTVOVEk2TnpnNE5qUTRNRE0zT1RFek16RXkZD"
              }
            },
            "data": [
              {
                "pic_large": "https://fb-s-d-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p200x200/20108099_116879808942184_8792637908147052517_n.png?oh=4dcc9a9bbdfc965eb477a14775f31448&oe=5A0BCFB5&__gda__=1510661157_f329dd30b13490dbae8d05d3aa45d79f",
                "type": "HAHA",
                "id": "116879722275526",
                "name": "Moojaa"
              },
              {
                "pic_large": "https://fb-s-a-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p200x200/16864759_114731265717623_8811777667276972672_n.jpg?oh=836c6d5145bc8023d3ac60e0dfd42bde&oe=5A00D0DC&__gda__=1509885772_ad8923f4369250c2c2051c5e9293331f",
                "type": "HAHA",
                "id": "111467022710714",
                "name": "Ram Singh Shankar"
              }
            ]
          },
          "from": {
            "picture": {
              "data": {
                "url": "https://fb-s-d-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p50x50/20108099_116879808942184_8792637908147052517_n.png?oh=24cc256b24e5da70f306afcf784a636d&oe=59FBA1D4&__gda__=1509895651_44acee6189c7c1cb6eed023a6e742d1a",
                "is_silhouette": false
              }
            },
            "name": "Moojaa",
            "id": "116879722275526"
          },
          "coordinates": {},
          "comments": {
            "paging": {
              "cursors": {
                "after": "WTI5dGJXVnVkRjlqZAFhKemIzSTZANVEUyT0RneE9ESTFOakE0TmpRNU9qRTFNREF6TURRM05EYz0ZD",
                "before": "WTI5dGJXVnVkRjlqZAFhKemIzSTZANVEUyT0RneE5UVTRPVFF5TURBNU9qRTFNREF6TURRMk5UUT0ZD"
              }
            },
            "data": [
              {
                "message": "test 3",
                "from": {
                  "picture": {
                    "data": {
                      "url": "https://fb-s-d-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p200x200/20108099_116879808942184_8792637908147052517_n.png?oh=4dcc9a9bbdfc965eb477a14775f31448&oe=5A0BCFB5&__gda__=1510661157_f329dd30b13490dbae8d05d3aa45d79f",
                      "is_silhouette": false
                    }
                  },
                  "name": "Moojaa",
                  "id": "116879722275526"
                },
                "id": "116880192275479_116881558942009"
              },
              {
                "message": "test ram",
                "from": {
                  "picture": {
                    "data": {
                      "url": "https://fb-s-a-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p200x200/16864759_114731265717623_8811777667276972672_n.jpg?oh=836c6d5145bc8023d3ac60e0dfd42bde&oe=5A00D0DC&__gda__=1509885772_ad8923f4369250c2c2051c5e9293331f",
                      "is_silhouette": false
                    }
                  },
                  "name": "Ram Singh Shankar",
                  "id": "111467022710714"
                },
                "id": "116880192275479_116881578942007"
              },
              {
                "message": "test singh",
                "from": {
                  "picture": {
                    "data": {
                      "url": "https://fb-s-a-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p200x200/16864759_114731265717623_8811777667276972672_n.jpg?oh=836c6d5145bc8023d3ac60e0dfd42bde&oe=5A00D0DC&__gda__=1509885772_ad8923f4369250c2c2051c5e9293331f",
                      "is_silhouette": false
                    }
                  },
                  "name": "Ram Singh Shankar",
                  "id": "111467022710714"
                },
                "id": "116880192275479_116881598942005"
              },
              {
                "message": "khair",
                "from": {
                  "picture": {
                    "data": {
                      "url": "https://fb-s-d-a.akamaihd.net/h-ak-fbx/v/t1.0-1/p200x200/20108099_116879808942184_8792637908147052517_n.png?oh=4dcc9a9bbdfc965eb477a14775f31448&oe=5A0BCFB5&__gda__=1510661157_f329dd30b13490dbae8d05d3aa45d79f",
                      "is_silhouette": false
                    }
                  },
                  "name": "Moojaa",
                  "id": "116879722275526"
                },
                "id": "116880192275479_116881825608649"
              }
            ]
          },
          "created_time": "2017-07-17T15:10:12+0000",
          "message": "Testing my Mooja",
          "type": "status",
          "id": "116879722275526_116880192275479"
        }
      }
    ]
  }
}

最佳答案

您必须将 react 中的数据设置为 nested type并且您可以对数据进行嵌套聚合以获取该类型的所有计数。

映射

PUT facebook_index1
{
  "mappings": {
    "document_type" : {
      "properties": {
        "reactions" : {
          "type": "object",
          "properties": {
            "data" : {
              "type" : "nested",
              "properties" : {
                "type" : {
                  "type" : "keyword"
                }
              }
            }
          }
        }
      }
    }
  }
}

询问

使用 nested aggs聚合数据类型。

POST facebook_index1/_search
{
  "size": 0,
  "aggs": {
    "nested_data_aggs": {
      "nested": {
        "path": "reactions.data"
      },
      "aggs": {
        "summary_reaction": {
          "terms": {
            "field": "reactions.data.type",
            "size": 10
          }
        }
      }
    }
  }
}

希望这有效

关于facebook-graph-api - facebook react 将按 aggs 术语 elasticsearch 分组，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/45161398/

文章推荐： json - ConvertFrom-Json是否尊重-ErrorAction

文章推荐： swagger - 通过Swagger/OpenAPI为additionalProperties指定多种类型

文章推荐： sql-server - 如何在检查约束中引用其他表？

文章推荐： powershell - 变量内每行的Powershell

graph - 分布式 tensorflow : the difference between In-graph replication and Between-graph replication
我对这两个概念感到困惑:In-graph replication和 Between-graph replication阅读 Replicated training 时在 tensorflow 的官方
graph - 分布式 tensorflow : the difference between In-graph replication and Between-graph replication
我对这两个概念感到困惑:In-graph replication和 Between-graph replication阅读 Replicated training 时在 tensorflow 的官方
graph - graph.windows.net 和 graph.microsoft.com 之间有什么区别？
我正在尝试使用 https://graph.windows.net/{teantId}/users/[email protected]/thumbnailPhoto?api-version=1.6 访
indexing - Julia /Graphs.jl : creating graph using graph() and arguments
我正在尝试使用 Graphs.jl 模块从 Julia 中的图中获取子图。我有图，并将其顶点和边存储到列表中，然后我的算法在该列表中移动并删除不属于新子图的节点和边。到这一部分，一切正常，在整个算法之
graph - Arangodb Graph，该用哪个
我是 Arangodb 的新手。我对使用哪个图形 API 感到困惑。我可以在 http://localhost:8529/ url 看到一张图。官方视频讨论了 Gremlin(我也安装了它)。然后就是
microsoft-graph-api - 如何使用 Graph API 读取 Azure B2C 自定义属性(适用于 Azure AD Graph)
截至今天，文档建议使用 Microsoft Graph 而不是 Azure AD Graph API 来访问 Azure AD/B2C 资源。之前，通过 Azure AD Graph API，我们可
azure - [从 Azure AD Graph 迁移到 Microsoft Graph] : how to get the parameters to use the Microsoft Graph API
我们希望将 .NET 应用从使用 Azure AD Graph 迁移到 Microsoft Graph API。目前我们正在使用包 Microsoft.WindowsAzure.Configurati
graph - 为什么 GraphQL 中的 "graph"？
也许我遗漏了什么，但我不知道为什么 GraphQL 的标题中有 graph。我猜这与 Graph Theory 有关和 graph并且可以看到某种联系，但如果有人能用简单的术语解释它就太好了。最佳
facebook-graph-api - Graph API中缺少页面的已连接Instagram帐户字段
我正在尝试使用API使用户的Facebook Pages具有已关联的Instagram企业帐户: https://graph.facebook.com/v2.7/me/accounts?field
graph - 如何导出 Mathematica Graph 对象的更高分辨率图像？
如何导出我通过调用 GraphPlot 获得的输出的调整大小版本 (或 TreePlot 如果它们产生不同的输出)到 jpg 文件？目前，我只是调用 Export[file_name, G]在哪里
graph - cosmos db graph api如何检查边缘是否存在并更新？
如何在使用 gremlin 查询创建边缘之前检查边缘是否已存在？如何更新现有边缘而不是删除并重新创建？最佳答案我不确定您是否还在寻找答案；然而，简单的答案是 Cosmos DB 在 Gremlin
xcode - 使用 Xcode Memory Graph Debugger 时出现 "Memory Graph Debugger: no serialized memory graph received from LeakAgent"错误
我使用的是 Xcode 10.2.1 和 macOS Catalina Developer Beta 2。每当我尝试使用内存图调试器时，我都会收到此错误: Memory Graph Debugger:
facebook-graph-api - Graph API错误＃200，即使具有正确的权限
我正在设置一个机器人以在Facebook页面上自动发布。但是，当我运行脚本时，图形API会引发以下错误: Graph returned an error: (#200) Requires either
microsoft-graph-api - Microsoft Graph-使用umlaut和其他unicode字符进行过滤
如何制定包含非英语字符(例如日耳曼语Umlauts)的Microsoft Graph /myOrganization/users OData查询？例子: 我的租户中有一个名为“ThomasMülle
facebook-graph-api - Facebook Graph API中用于定位的国家和城市列表
我正在寻找发布目标帖子时可以与Facebook Graph API一起使用的国家/州/城市列表。我在this页面上找到了一个JSON文件，但是该文件无法正确解析，我也怀疑它是否可以用于发布目标，因为
facebook-graph-api - Graph API 的共享数
关于 Graph API，帖子的分享数、帖子见解的分享数和页面上显示的分享数不相同。我假设这些代表相同的计数。我的假设错了吗？来自帖子: https://graph.facebook.com/XXX
microsoft-graph-api - Microsoft Graph - 为什么访问另一个网站集中的子网站需要根网站读取权限？
我正在尝试访问作为嵌套子站点一部分的列表的项目，如下所示: https://{mytenant}.sharepoint.com/ vendorSiteCollection/ v
facebook-graph-api - Graph API 调用次数限制
我打算开发一个应用程序，但开发人员告诉我每个 IP 每 600 秒有 600 次调用的限制。该应用程序有很多场景，这还不够。有没有办法以某种方式增加限制？或者 Facebook 是否提供任何高级帐户或
graph - Neo4j Graph DB - 伦敦地铁规划师 - 找不到路径
我在 Neo4j 中创建了一张伦敦地铁 map 。站点通过 :CONNECTED_TO 关系连接，时间值表示停止之间需要多长时间(目前这些是我为测试输入的随机值)。位于多条线路上的车站每条线路都有一个
microsoft-graph-api - MS Graph - 获取所有用户
我正在尝试拉回所有用户的列表，我的预期结果将是大约 20,000 个用户。图表似乎将我限制为 1000。图调用https://graph.microsoft.com/v1.0/users返回 10

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

facebook-graph-api - facebook react 将按 aggs 术语 elasticsearch 分组