elasticsearch请求语法示例

POST ise_test_20181128/_search
{
“query”: {
“match”: {
“requestId”: {
“query”: “763B759F-EC31-4C69-A2CB-F9041963CC47”
}
}
}
}

GET _search
POST ise_test_20181128/_search
{
“query”: {
“match”: {
“ImageList.Image.MotorVehicleList.VehicleBrand”: {
“query”: “丰田”
}
}
}
}

//聚合-AVG
POST ise_test_20181128/_search?size=0
{
“aggs”: {
“NAME”: {
“avg”: {
“field”: “ImageList.Image.MotorVehicleList.PlateReliability”
}
}
}
}

GET ise_test_20181128/_search
{
“size”: 0,
“aggs” : {
“load_time_ranks” : {
“percentile_ranks” : {
“field” : “ImageList.Image.MotorVehicleList.PlateReliability”,
“values” : [0.6, 0.8]
}
}
}
}
//聚合
post ise_test_20181128/imgelist
{
“name”:“grg”
}

post ise_test_20181128/imgelist
{
“ImageList”: [
{
“Image”: {
“FaceList”: [],
“ImageInfo”: {},
“MotorVehicleList”: [
{
“AppearTime”: “”,
“BrandReliability”: 0.001750629860907793,
“Calling”: 0,
“CarOfVehicle”: “”,
“CopilotCalling”: 0,
“CopilotSafetyBelt”: 0,
“DescOfFrontItem”: “”,
“DescOfRearItem”: “”,
“DeviceID”: “44010000001320000005”,
“Direction”: 0,
“DirvingStatusCode”: “”,
“DisapperaTime”: “”,
“FilmColor”: “0”,
“HasPlate”: “1”,
“HitMarkInfo”: “”,
“InfoKind”: 1,
“IsAltered”: “0”,
“IsCovered”: “0”,
“IsDecked”: “0”,
“IsModified”: false,
“IsSupicious”: “0”,
“LaneNo”: 1,
“LeftTopX”: 1587,
“LeftTopY”: 166,
“MarkTime”: “”,
“MotorVehicleID”: “440000000025000000060720181128101320154440215444”,
“NameOfPassedRoad”: “”,
“NumOfPassenger”: 0,
“PassTime”: “20181128101320”,
“PlateCharReliability”: “”,
“PlateClass”: “0”,
“PlateColor”: “5”,
“PlateNo”: “粤AN73Q7”,
“PlateNoAttach”: “”,
“PlateReliability”: 0.9951339364051819,
“RearviewMirror”: “”,
“RightBtmX”: 2448,
“RightBtmY”: 995,
“SafetyBelt”: 1,
“SideOfVehicle”: “”,
“SourceID”: “”,
“Speed”: 0,
“StorageUrl1”: “http://10.2.5.15/group1/M00/08/1A/CgIFD1v97SiAYix4AAPRfOAG0tQ270.jpg”,
“StorageUrl2”: “”,
“StorageUrl3”: “”,
“StorageUrl4”: “”,
“StorageUrl5”: “”,
“Sunvisor”: 0,
“TollgateID”: “”,
“UsingPropertiesCode”: “”,
“VehicleBodyDesc”: “”,
“VehicleBrand”: “讴歌”,
“VehicleChassis”: “”,
“VehicleClass”: “3”,
“VehicleColor”: “1”,
“VehicleColorDepth”: “0”,
“VehicleDoor”: “”,
“VehicleFrontItem”: “”,
“VehicleHeight”: 0,
“VehicleHood”: “”,
“VehicleLength”: 0,
“VehicleModel”: “讴歌-RDX”,
“VehicleRearItem”: “”,
“VehicleRoof”: “”,
“VehicleShielding”: “”,
“VehicleStyles”: “2013”,
“VehicleTrunk”: “”,
“VehicleWheel”: “”,
“VehicleWidth”: 0,
“VehicleWindow”: “”,
“WheelPrintedPattern”: “”
}
],
“PersonList”: []
}
}
],
“MsgCategory”: “analysisResult”,
“command”: “vehicle”,
“moduleCode”: “44000000002500000006”,
“requestId”: “E3E4841A-03E3-49C6-BB27-CBA33EAEC3AF”,
“taskId”: “”
}

curl -Xpost “http://10.2.5.203:9200/ise_test_20181128/imgelist” -H ‘Content-Type: application/json’ -d’
{
“name”:“grg”
}’

curl -Xpost “http://10.2.5.203:9200/ise_test_20181128/imgelist” -H ‘Content-Type: application/json’ -d’
{
“ImageList”: [
{
“Image”: {
“FaceList”: [],
“ImageInfo”: {},
“MotorVehicleList”: [
{
“AppearTime”: “”,
“BrandReliability”: 0.001750629860907793,
“Calling”: 0,
“CarOfVehicle”: “”,
“CopilotCalling”: 0,
“CopilotSafetyBelt”: 0,
“DescOfFrontItem”: “”,
“DescOfRearItem”: “”,
“DeviceID”: “44010000001320000005”,
“Direction”: 0,
“DirvingStatusCode”: “”,
“DisapperaTime”: “”,
“FilmColor”: “0”,
“HasPlate”: “1”,
“HitMarkInfo”: “”,
“InfoKind”: 1,
“IsAltered”: “0”,
“IsCovered”: “0”,
“IsDecked”: “0”,
“IsModified”: false,
“IsSupicious”: “0”,
“LaneNo”: 1,
“LeftTopX”: 1587,
“LeftTopY”: 166,
“MarkTime”: “”,
“MotorVehicleID”: “440000000025000000060720181128101320154440215444”,
“NameOfPassedRoad”: “”,
“NumOfPassenger”: 0,
“PassTime”: “20181128101320”,
“PlateCharReliability”: “”,
“PlateClass”: “0”,
“PlateColor”: “5”,
“PlateNo”: “粤AN73Q7”,
“PlateNoAttach”: “”,
“PlateReliability”: 0.9951339364051819,
“RearviewMirror”: “”,
“RightBtmX”: 2448,
“RightBtmY”: 995,
“SafetyBelt”: 1,
“SideOfVehicle”: “”,
“SourceID”: “”,
“Speed”: 0.0,
“StorageUrl1”: “http://10.2.5.15/group1/M00/08/1A/CgIFD1v97SiAYix4AAPRfOAG0tQ270.jpg”,
“StorageUrl2”: “”,
“StorageUrl3”: “”,
“StorageUrl4”: “”,
“StorageUrl5”: “”,
“Sunvisor”: 0,
“TollgateID”: “”,
“UsingPropertiesCode”: “”,
“VehicleBodyDesc”: “”,
“VehicleBrand”: “讴歌”,
“VehicleChassis”: “”,
“VehicleClass”: “3”,
“VehicleColor”: “1”,
“VehicleColorDepth”: “0”,
“VehicleDoor”: “”,
“VehicleFrontItem”: “”,
“VehicleHeight”: 0,
“VehicleHood”: “”,
“VehicleLength”: 0,
“VehicleModel”: “讴歌-RDX”,
“VehicleRearItem”: “”,
“VehicleRoof”: “”,
“VehicleShielding”: “”,
“VehicleStyles”: “2013”,
“VehicleTrunk”: “”,
“VehicleWheel”: “”,
“VehicleWidth”: 0,
“VehicleWindow”: “”,
“WheelPrintedPattern”: “”
}
],
“PersonList”: []
}
}
],
“MsgCategory”: “analysisResult”,
“command”: “vehicle”,
“moduleCode”: “44000000002500000006”,
“requestId”: “E3E4841A-03E3-49C6-BB27-CBA33EAEC3AF”,
“taskId”: “”
}’

{
“MsgCategory”:“analysisResult”,
“moduleCode”:“44000000002500000006”,
“requestId”:“E3E4841A-03E3-49C6-BB27-CBA33EAEC3AF”,
“command”:“vehicle”,
“taskId”:"",
“ImageList”:[
{
“FaceList”:[

        ],
        "ImageInfo":{

        },
        "MotorVehicleList":[
            {
                "AppearTime":"",
                "BrandReliability":"904ED174ED7A429E91F3CAAAD251D71B",
                "MotorVehicleID":"CAEEFB23BC924E018FF171FF2EFA6301",
                "DescOfRearItem":"",
                "DeviceID":"24840D554E3143D780AE995CE5F80797",
                "LaneNo":"FEA364D6A6AE498F8C628584249589EC",
                "Calling":0,
                "PlateColor":9,
                "PassTime":1545613416470,
                "DescOfFrontItem":"",
                "PlateNo":"粤AN73Q7"
            }
        ]
    }
]

}

{
“MsgCategory”:“analysisResult”,
“moduleCode”:“44000000002500000006”,
“requestId”:“E3E4841A-03E3-49C6-BB27-CBA33EAEC3AF”,
“command”:“vehicle”,
“taskId”:"",
“ImageList”:[
{
“Image”:{
“FaceList”:[

            ],
            "ImageInfo":{

            },
            "MotorVehicleList":[
                {
                    "AppearTime":"",
                    "BrandReliability":"AAE4106AD551405A8F30A8C95C4A0BF8",
                    "MotorVehicleID":"73AC61769B3C4FA3A6DD27693C6BCB08",
                    "DescOfRearItem":"",
                    "DeviceID":"FD41F68141F84B00A075A51C766EEF45",
                    "LaneNo":"45EC900649904F8F97088BE82DBEA30E",
                    "Calling":0,
                    "PlateColor":9,
                    "PassTime":1545614053809,
                    "DescOfFrontItem":"",
                    "PlateNo":"粤AN73Q7"
                }
            ]
        }
    }
]

}

PUT ise_test_20181128/_mapping/imgelist
{
“properties”: {
“interests”:{
“type”: “text”,
“fielddata”: true
}
}
}

GET ise_test_20181128/_search
{
“query”: {
“bool”: {
“must”: [
{
“match”: {
“ImageList.Image.MotorVehicleList.PlateNo”: “京”
}
}
]
}
}
}

GET ise_test_20181128/_search
{
“query”: {
“term”: {
“ImageList.Image.MotorVehicleList.PlateNo.keyword”: {
“value”: “京F832ZA”
}
}
}
}

GET ise_test_20181128/_search
{
“query”: {
“bool”: {
“filter”:[
{
“term”: {
“ImageList.Image.MotorVehicleList.DeviceID”: “44010000001320000005”
}
, “range”: {
“ImageList.Image.MotorVehicleList.PassTime”: {
“gte”: 20181127070836,
“lte”: 20181127080836
}
}
}
]
}
}
}

#相同车牌相同设备DeviceID
GET ise_test_20181128/_search
{
“query”: {
“bool”: {
“must”: [
{
“match”: {
“ImageList.Image.MotorVehicleList.DeviceID”: “44010000001320000005”
}
},
{
“query_string”: {
“default_field”: “ImageList.Image.MotorVehicleList.PlateNo”,
“query”: “渝K5F6H8”
}
}
]
}
}
}

#相同车牌相同ID
GET ise_test_20181128/_search
{
“query”: {
“bool”: {
“must”: [
{ “match”: { “ImageList.Image.MotorVehicleList.PlateNo”: “粤A3LJ29” }},
{
“match”: {
“ImageList.Image.MotorVehicleList.MotorVehicleID”: “44000000002500000006072018112707084610929802109298”
}
}
]
}
}
}

#一个小时内相同DeviceID设备号通过车辆
GET ise_test_20181128/_search
{
“query”: {
“bool”: {
“must”: [
{
“range”: {
“ImageList.Image.MotorVehicleList.PassTime”: {
“gte”: 20181127070836,
“lte”: 20181127080836
}
}
},
{
“query_string”: {
“default_field”: “ImageList.Image.MotorVehicleList.DeviceID.keyword”,
“query”: “44010000001320000005”
}
}
]
}
}
}

#一个小时内相同车牌号通过次数
GET ise_test_20181128/_search
{
“query”: {
“bool”: {
“must”: [
{
“range”: {
“ImageList.Image.MotorVehicleList.PassTime”: {
“gte”: 20181127070836,
“lte”: 20181127080836
}
}
},
{
“query_string”: {
“default_field”: “ImageList.Image.MotorVehicleList.PlateNo.keyword”,
“query”: “粤AV4488”
}
}
]
}
}
}

GET ise_test_20181128/_search
{
“size”: 0,
“aggs” : {
“PassTime_ranges” : {
“range” : {
“field” : “ImageList.Image.MotorVehicleList.PassTime.keyword”,
“ranges” : [
{ “to” : 20181128101319 },
{ “from” : 20181128101319, “to” : 20181128101329 },
{ “from” : 20181128101329 }
]
}
}
}
}