專案

一般

配置概況

下載 (1.53 KB)

工作單 #202 » udid_top10_merchant_id.txt

marlboro chu, 2025-06-30 01:38

 
curl -X PUT "http://192.168.10.106:19200/_ingest/pipeline/add_timestamp" -H "Content-Type: application/json" -u "elastic:elastic16313302" -d '
{
"processors": [
{
"set": {
"field": "timestamp",
"value": "{{_ingest.timestamp}}"
}
}
]
}
'


curl -X PUT "http://192.168.10.106:19200/_transform/top10_udid_acctno_merchant_id_smartfds_predict_transformed" -H "Content-Type: application/json" -u "elastic:elastic16313302" -d '
{
"source": {
"index": [
"smartfds_predict"
],
"query": {
"range": {
"create_datetime": {
"gte": "now-180d/d",
"lte": "now/d"
}
}
}
},
"dest": {
"index": "top10_udid_acctno_merchant_id_smartfds_predict",
"pipeline": "add_timestamp"
},
"pivot": {
"group_by": {
"operator_id": {
"terms": {
"field": "operator_id"
}
},
"institute_id": {
"terms": {
"field": "institute_id"
}
},
"merchant_id": {
"terms": {
"field": "merchant_id.keyword"
}
},
"udid": {
"terms": {
"field": "diiaInfo__deviceInfo__udid"
}
}
},
"aggregations": {
"distinct_acctNumbers": {
"cardinality": {
"field": "txInfo__acctNumber"
}
}
}
},
"settings": {}
}
'

curl -X POST "http://192.168.10.106:19200/_transform/top10_udid_acctno_merchant_id_smartfds_predict_transformed/_start"
(2-2/2)