UBI 查询 DSL 示例查询
您可以使用 OpenSearch 搜索查询语言 查询 DSL 来编写用户行为洞察 (UBI) 查询。以下示例返回每个 action_name
事件发生的次数。有关更全面的分析查询,请参阅 UBI SQL 查询示例。
请求示例
GET ubi_events/_search
{
"size":0,
"aggs":{
"event_types":{
"terms": {
"field":"action_name",
"size":10
}
}
}
}
示例响应
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 10000,
"relation": "gte"
},
"max_score": null,
"hits": []
},
"aggregations": {
"event_types": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "brand_filter",
"doc_count": 3084
},
{
"key": "product_hover",
"doc_count": 3068
},
{
"key": "button_click",
"doc_count": 3054
},
{
"key": "product_sort",
"doc_count": 3012
},
{
"key": "on_search",
"doc_count": 3010
},
{
"key": "type_filter",
"doc_count": 2925
},
{
"key": "login",
"doc_count": 2433
},
{
"key": "logout",
"doc_count": 1447
},
{
"key": "new_user_entry",
"doc_count": 207
}
]
}
}
}
您可以在 OpenSearch Dashboards 的 查询工作台 中运行上述查询。
带有示例数据的演示工作台可在此处找到:http://chorus-opensearch-edition.dev.o19s.com:5601/app/OpenSearch-query-workbench。