首页 > 编程 > Python > 正文

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

2019-11-25 13:20:38
字体:
来源:转载
供稿:网友

如下所示:

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 实现提取某个索引中某个时间段的数据方法就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持武林网。

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表