python 实现提取某个索引中某个时间段的数据方法

Python  /  管理员 发布于 7年前   168

如下所示：

from elasticsearch import Elasticsearchimport datetimeimport timeimport dateutil.parserclass App(object): def __init__(self):  pass def _es_conn(self):  es = Elasticsearch()  return es def get_data(self, day,start,end):  index_ = "gather-apk-20180330"  query_dsl = {   "size": 10000,   "query": {    "bool": {     "must": [      {"range": {       "receiveTime": {        "gte": start.strftime('%Y-%m-%d %H:%M:%S'),        "lte": end.strftime('%Y-%m-%d %H:%M:%S'),        "format": "yyyy-MM-dd HH:mm:SS",        "time_zone": "+08:00"       }      }},      {       "term": {        "obd2_localnet_id": {         "value": "101000"        }       }      },      {       "term": {        "obd2_substation_name": {         "value": "石羊支局"        }       }      }     ]    }   },   "_source": ["mac", "iptvAccount", "obd2_substation_name", "obd2_company_name", "obd2_grid_name",      "receiveTime","streamBreak","kaNum"]  }  rs = self._es_conn().search(   index=index_,   body=query_dsl  )  if __name__ == '__main__': day = datetime.datetime.now() # the_day = day.strftime('%Y%m%d') start = datetime.datetime.strptime('20180330 09:53:00','%Y%m%d %H:%M:%S') end = datetime.datetime.strptime('20180330 15:44:00','%Y%m%d %H:%M:%S') app = App() app.get_data(day,start,end)

以上这篇python 实现提取某个索引中某个时间段的数据方法就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持。