我有这个JSON：

{"index":{"_index":"companydatabase"}}  
{"FirstName":"ELVA","LastName":"RECHKEMMER","Designation":"CEO","Salary":"154000","DateOfJoining":"1993-01-11","Address":"8417 Blue Spring St. Port Orange, FL 32127","Gender":"Female","Age":62,"MaritalStatus":"Unmarried","Interests":["Body Building","Illusion","Protesting","Taxidermy","TV watching","Cartooning","Skateboarding"]}
{"index":{"_index":"companydatabase"}}  
{"FirstName":"JENNEFER","LastName":"WENIG","Designation":"President","Salary":"110000","DateOfJoining":"2013-02-07","Address":"16 Manor Station Court Huntsville, AL 35803","Gender":"Female","Age":45,"MaritalStatus":"Unmarried","Interests":["String Figures","Working on cars","Button Collecting","Surf Fishing"]}
{"index":{"_index":"companydatabase"}}

etc

我需要获得男性员工和女性员工的平均值进行比较
Salary字段的类型是Text，因此我进行了Map，将字段转换为Integer
我的代码是：

mapping_type = {
    'mappings': {
        'properties': {
            'Adress': {
                'type': 'text',
                'fields': {
                    'keyword': {
                        'type': 'keyword', 
                        'ignore_above': 256
                    }
                }
            },
            'Age': {
                'type': 'long'
            },
            'DateOfJoining': {
                'type': 'date'
            },
            'Designation': {
                'type': 'text',
                'fields': {
                    'keyword': {
                        'type': 'keyword', 
                        'ignore_above': 256
                    }
                }
            },
            'FirstName': {
                'type': 'text',
                'fields': {
                    'keyword': {
                        'type': 'keyword', 
                        'ignore_above': 256
                    }
                }
            },
            'Gender': {
                'type': 'text',
                'fields': {
                    'keyword': {
                        'type': 'keyword', 
                        'ignore_above': 256
                    }
                }
            },
            'Interest': {
                'type': 'text',
                'fields': {
                    'keyword': {
                        'type': 'keyword', 
                        'ignore_above': 256
                    }
                }
            },
            'LastName': {
                'type': 'text',
                'fields': {
                    'keyword': {
                        'type': 'keyword', 
                        'ignore_above': 256
                    }
                }
            },
            'MaritalStatus': {
                'type': 'text',
                'fields': {
                    'keyword': {
                        'type': 'keyword', 
                        'ignore_above': 256
                    }
                }
            },
            'Salary': {
                'type': 'integer'
            }
        }
    }
}

es.indices.delete(index="companydatabase",ignore=[400,404])
es.indices.create(index="companydatabase",body=mapping_type)

及以后

request_body={
    "size": 0,
    "aggs": {
        "salary_by_job": {
            "terms": {
                "field": "Designation.keyword"
            },
            "aggs": {
                "salary_by_gender": {
                    "terms": {
                        "field": "Gender.keyword"
                    },
                    "aggs": {
                        "average_salary": {
                            "avg": {
                                "field": "Salary"
                            }
                        }
                    }
                }
            }
        }
    }
}

JSON(es.search(index="companydatabase", body=request_body))

但是密码把我
...点击：
点击次数：[] 0条
最大评分：空...
我需要一个号码，显然不是空的。
感谢您的帮助：）