按星期几筛选，按小时聚合

zujrkrfu  于 2021-06-14  发布在  ElasticSearch
关注(0)|答案(1)|浏览(488)

对于我的硕士，我有一个编程课程，我必须与ElasticSearch工作。我有一个数据集，有几百万个ubereat订单。每个记录都由日期时间、餐厅、取货点和下车点组成。我必须区分不同的日期，并报告特定日期的订单数量。所以，举个例子，我设法找到了圣诞节每小时的订单数量。
我还设法找到了全年周一、周二、周三等的订单总量。现在，我要把这两者结合起来。我需要知道在星期一，星期二，星期三等，在9:00到10:00，10:00到11:00，11:00到12:00之间，全年下了多少订单。我已经包括了我的尝试。但是，我得到了一个错误：
requesterror（400，'parsing\u exception'，'[bool]查询格式错误，应为[end\u object]，但找到了[field\u name]'）
有人知道如何组合这个查询和聚合吗？

  1. search_body = {
  2.  'size': 0,
  3.  'query': {
  4.     'range':{
  5.         'dateTime':{
  6.             'gte': "2018-12-25 00:00:00",
  7.             'lte': "2018-12-26 00:00:00"
  8.         }
  9.     }
  10. },
  11.     "aggs": {
  12.     "orders_per_date": {
  13.       "date_histogram": {
  14.         "field": "dateTime",
  15.         "calendar_interval": "hour"
  16.       }
  17.     }
  18.  }
  19. }
  21. search_body = {
  22.       "size": 0,
  23.       "aggs": {
  24.             "total_orders_per_day_of_week": {
  25.                   "terms": {
  26.                         "script": {
  27.                               "lang": "painless",
  28.                               "source": "doc['dateTime'].value.dayOfWeek"
  29.                         }
  30.                   }
  32. search_body = {
  33.   "size": 0,
  34.   "query": {
  35.     "bool": {
  36.       "filter": {
  37.         "script": {
  38.           "script": {
  39.             "source": "doc['dateTime'].value.dayOfWeek",
  40.             "lang": "painless"
  41.           }
  42.         }
  43.       }
  44.      },
  45.       "aggs": {
  46.           "total_order_per_hour_per_day": {
  47.             "date_histogram": {
  48.               "field": "dateTime",
  49.               "calendar_interval": "hour"
  50.              }
  51.             }
  52.         }
  53.     }
  54. }
  56. [2020-10-10T15:06:57,628][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] version[7.9.2], pid[10380], build[default/zip/d34da0ea4a966c4e49417f2da2f244e3e97b4e6e/2020-09-23T00:45:33.626720Z], OS[Windows 10/10.0/amd64], JVM[AdoptOpenJDK/OpenJDK 64-Bit Server VM/15/15+36]
  57. [2020-10-10T15:06:57,644][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] JVM home [C:\Users\leand\Desktop\elasticsearch-7.9.2\jdk]
  58. [2020-10-10T15:06:57,644][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] JVM arguments [-Des.networkaddress.cache.ttl=60, -Des.networkaddress.cache.negative.ttl=10, -XX:+AlwaysPreTouch, -Xss1m, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djna.nosys=true, -XX:-OmitStackTraceInFastThrow, -XX:+ShowCodeDetailsInExceptionMessages, -Dio.netty.noUnsafe=true, -Dio.netty.noKeySetOptimization=true, -Dio.netty.recycler.maxCapacityPerThread=0, -Dio.netty.allocator.numDirectArenas=0, -Dlog4j.shutdownHookEnabled=false, -Dlog4j2.disable.jmx=true, -Djava.locale.providers=SPI,COMPAT, -Xms1g, -Xmx1g, -XX:+UseG1GC, -XX:G1ReservePercent=25, -XX:InitiatingHeapOccupancyPercent=30, -Djava.io.tmpdir=C:\Users\leand\AppData\Local\Temp\elasticsearch, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=data, -XX:ErrorFile=logs/hs_err_pid%p.log, -Xlog:gc*,gc+age=trace,safepoint:file=logs/gc.log:utctime,pid,tags:filecount=32,filesize=64m, -XX:MaxDirectMemorySize=536870912, -Delasticsearch, -Des.path.home=C:\Users\leand\Desktop\elasticsearch-7.9.2, -Des.path.conf=C:\Users\leand\Desktop\elasticsearch-7.9.2\config, -Des.distribution.flavor=default, -Des.distribution.type=zip, -Des.bundled_jdk=true]
  59. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [aggs-matrix-stats]
  60. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [analysis-common]
  61. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [constant-keyword]
  62. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [flattened]
  63. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [frozen-indices]
  64. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [ingest-common]
  65. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [ingest-geoip]
  66. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [ingest-user-agent]
  67. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [kibana]
  68. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [lang-expression]
  69. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [lang-mustache]
  70. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [lang-painless]
  71. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [mapper-extras]
  72. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [parent-join]
  73. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [percolator]
  74. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [rank-eval]
  75. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [reindex]
  76. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [repository-url]
  77. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [search-business-rules]
  78. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [searchable-snapshots]
  79. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [spatial]
  80. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [tasks]
  81. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [transform]
  82. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [transport-netty4]
  83. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [vectors]
  84. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [wildcard]
  85. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-analytics]
  86. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-async]
  87. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-async-search]
  88. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-autoscaling]
  89. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-ccr]
  90. [2020-10-10T15:07:03,707][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-core]
  91. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-data-streams]
  92. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-deprecation]
  93. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-enrich]
  94. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-eql]
  95. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-graph]
  96. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-identity-provider]
  97. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-ilm]
  98. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-logstash]
  99. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-ml]
  100. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-monitoring]
  101. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-ql]
  102. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-rollup]
  103. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-security]
  104. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-sql]
  105. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-stack]
  106. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-voting-only-node]
  107. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-watcher]
  108. [2020-10-10T15:07:03,723][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] no plugins loaded
  109. [2020-10-10T15:07:04,046][INFO ][o.e.e.NodeEnvironment    ] [DESKTOP-1OP6K1E] using [1] data paths, mounts [[(C:)]], net usable_space [128.5gb], net total_space [232.4gb], types [NTFS]
  110. [2020-10-10T15:07:04,047][INFO ][o.e.e.NodeEnvironment    ] [DESKTOP-1OP6K1E] heap size [1gb], compressed ordinary object pointers [true]
  111. [2020-10-10T15:07:04,295][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] node name [DESKTOP-1OP6K1E], node ID [m3Cz932jSqOozhQ0ua9OVg], cluster name [elasticsearch]
  112. [2020-10-10T15:07:07,389][INFO ][o.e.x.m.p.l.CppLogMessageHandler] [DESKTOP-1OP6K1E] [controller/1928] [Main.cc@114] controller (64 bit): Version 7.9.2 (Build 6a60f0cf2dd5a5) Copyright (c) 2020 Elasticsearch BV
  113. [2020-10-10T15:07:07,907][INFO ][o.e.x.s.a.s.FileRolesStore] [DESKTOP-1OP6K1E] parsed [0] roles from file [C:\Users\leand\Desktop\elasticsearch-7.9.2\config\roles.yml]
  114. [2020-10-10T15:07:08,789][INFO ][o.e.t.NettyAllocator     ] [DESKTOP-1OP6K1E] creating NettyAllocator with the following configs: [name=unpooled, factors={es.unsafe.use_unpooled_allocator=false, g1gc_enabled=true, g1gc_region_size=1mb, heap_size=1gb}]
  115. [2020-10-10T15:07:08,850][INFO ][o.e.d.DiscoveryModule    ] [DESKTOP-1OP6K1E] using discovery type [zen] and seed hosts providers [settings]
  116. [2020-10-10T15:07:09,244][WARN ][o.e.g.DanglingIndicesState] [DESKTOP-1OP6K1E] gateway.auto_import_dangling_indices is disabled, dangling indices will not be automatically detected or imported and must be managed manually
  117. [2020-10-10T15:07:09,658][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] initialized
  118. [2020-10-10T15:07:09,658][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] starting ...
  119. [2020-10-10T15:07:09,824][INFO ][o.e.t.TransportService   ] [DESKTOP-1OP6K1E] publish_address {127.0.0.1:9300}, bound_addresses {127.0.0.1:9300}, {[::1]:9300}
  120. [2020-10-10T15:07:10,226][WARN ][o.e.b.BootstrapChecks    ] [DESKTOP-1OP6K1E] the default discovery settings are unsuitable for production use; at least one of [discovery.seed_hosts, discovery.seed_providers, cluster.initial_master_nodes] must be configured
  121. [2020-10-10T15:07:10,228][INFO ][o.e.c.c.Coordinator      ] [DESKTOP-1OP6K1E] cluster UUID [O_T444u1TtOptSi2tnYMHA]
  122. [2020-10-10T15:07:10,239][INFO ][o.e.c.c.ClusterBootstrapService] [DESKTOP-1OP6K1E] no discovery configuration found, will perform best-effort cluster bootstrapping after [3s] unless existing master is discovered
  123. [2020-10-10T15:07:10,319][INFO ][o.e.c.s.MasterService    ] [DESKTOP-1OP6K1E] elected-as-master ([1] nodes joined)[{DESKTOP-1OP6K1E}{m3Cz932jSqOozhQ0ua9OVg}{JqCVbGVRQe69M_eiFTrlaw}{127.0.0.1}{127.0.0.1:9300}{dilmrt}{ml.machine_memory=17108164608, xpack.installed=true, transform.node=true, ml.max_open_jobs=20} elect leader, _BECOME_MASTER_TASK_, _FINISH_ELECTION_], term: 13, version: 327, delta: master node changed {previous [], current [{DESKTOP-1OP6K1E}{m3Cz932jSqOozhQ0ua9OVg}{JqCVbGVRQe69M_eiFTrlaw}{127.0.0.1}{127.0.0.1:9300}{dilmrt}{ml.machine_memory=17108164608, xpack.installed=true, transform.node=true, ml.max_open_jobs=20}]}
  124. [2020-10-10T15:07:10,449][INFO ][o.e.c.s.ClusterApplierService] [DESKTOP-1OP6K1E] master node changed {previous [], current [{DESKTOP-1OP6K1E}{m3Cz932jSqOozhQ0ua9OVg}{JqCVbGVRQe69M_eiFTrlaw}{127.0.0.1}{127.0.0.1:9300}{dilmrt}{ml.machine_memory=17108164608, xpack.installed=true, transform.node=true, ml.max_open_jobs=20}]}, term: 13, version: 327, reason: Publication{term=13, version=327}
  125. [2020-10-10T15:07:10,513][INFO ][o.e.h.AbstractHttpServerTransport] [DESKTOP-1OP6K1E] publish_address {127.0.0.1:9200}, bound_addresses {127.0.0.1:9200}, {[::1]:9200}
  126. [2020-10-10T15:07:10,515][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] started
  127. [2020-10-10T15:07:10,787][INFO ][o.e.l.LicenseService     ] [DESKTOP-1OP6K1E] license [f3871a4a-f01a-4943-bfa6-86c1a1c10ff6] mode [basic] - valid
  128. [2020-10-10T15:07:10,789][INFO ][o.e.x.s.s.SecurityStatusChangeListener] [DESKTOP-1OP6K1E] Active license is now [BASIC]; Security is disabled
  129. [2020-10-10T15:07:10,799][INFO ][o.e.g.GatewayService     ] [DESKTOP-1OP6K1E] recovered [7] indices into cluster_state
  130. [2020-10-10T15:07:13,147][INFO ][o.e.c.r.a.AllocationService] [DESKTOP-1OP6K1E] Cluster health status changed from [RED] to [YELLOW] (reason: [shards started [[reken][0]]]).
  131. [2020-10-10T16:18:00,511][INFO ][o.e.x.m.p.NativeController] [DESKTOP-1OP6K1E] Native controller process has stopped - no new native processes can be started
  132. [2020-10-10T16:18:00,511][INFO ][o.e.b.Bootstrap          ] [DESKTOP-1OP6K1E] running graceful exit on windows
  133. [2020-10-10T16:18:00,511][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] stopping ...
  134. [2020-10-10T16:18:00,511][INFO ][o.e.x.w.WatcherService   ] [DESKTOP-1OP6K1E] stopping watch service, reason [shutdown initiated]
  135. [2020-10-10T16:18:00,511][INFO ][o.e.x.w.WatcherLifeCycleService] [DESKTOP-1OP6K1E] watcher has stopped and shutdown
  136. [2020-10-10T16:18:00,662][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] stopped
  137. [2020-10-10T16:18:00,662][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] closing ...
  138. [2020-10-10T16:18:00,676][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] closed
  139. [2020-10-10T16:53:40,977][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] version[7.9.2], pid[4416], build[default/zip/d34da0ea4a966c4e49417f2da2f244e3e97b4e6e/2020-09-23T00:45:33.626720Z], OS[Windows 10/10.0/amd64], JVM[AdoptOpenJDK/OpenJDK 64-Bit Server VM/15/15+36]
  140. [2020-10-10T16:53:40,977][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] JVM home [C:\Users\leand\Desktop\elasticsearch-7.9.2\jdk]
  141. [2020-10-10T16:53:40,977][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] JVM arguments [-Des.networkaddress.cache.ttl=60, -Des.networkaddress.cache.negative.ttl=10, -XX:+AlwaysPreTouch, -Xss1m, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djna.nosys=true, -XX:-OmitStackTraceInFastThrow, -XX:+ShowCodeDetailsInExceptionMessages, -Dio.netty.noUnsafe=true, -Dio.netty.noKeySetOptimization=true, -Dio.netty.recycler.maxCapacityPerThread=0, -Dio.netty.allocator.numDirectArenas=0, -Dlog4j.shutdownHookEnabled=false, -Dlog4j2.disable.jmx=true, -Djava.locale.providers=SPI,COMPAT, -Xms1g, -Xmx1g, -XX:+UseG1GC, -XX:G1ReservePercent=25, -XX:InitiatingHeapOccupancyPercent=30, -Djava.io.tmpdir=C:\Users\leand\AppData\Local\Temp\elasticsearch, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=data, -XX:ErrorFile=logs/hs_err_pid%p.log, -Xlog:gc*,gc+age=trace,safepoint:file=logs/gc.log:utctime,pid,tags:filecount=32,filesize=64m, -XX:MaxDirectMemorySize=536870912, -Delasticsearch, -Des.path.home=C:\Users\leand\Desktop\elasticsearch-7.9.2, -Des.path.conf=C:\Users\leand\Desktop\elasticsearch-7.9.2\config, -Des.distribution.flavor=default, -Des.distribution.type=zip, -Des.bundled_jdk=true]
  142. [2020-10-10T16:53:43,025][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [aggs-matrix-stats]
  143. [2020-10-10T16:53:43,025][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [analysis-common]
  144. [2020-10-10T16:53:43,025][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [constant-keyword]
  145. [2020-10-10T16:53:43,025][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [flattened]
  146. [2020-10-10T16:53:43,026][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [frozen-indices]
  147. [2020-10-10T16:53:43,026][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [ingest-common]
  148. [2020-10-10T16:53:43,026][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [ingest-geoip]
  149. [2020-10-10T16:53:43,026][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [ingest-user-agent]
  150. [2020-10-10T16:53:43,026][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [kibana]
  151. [2020-10-10T16:53:43,027][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [lang-expression]
  152. [2020-10-10T16:53:43,027][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [lang-mustache]
  153. [2020-10-10T16:53:43,027][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [lang-painless]
  154. [2020-10-10T16:53:43,027][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [mapper-extras]
  155. [2020-10-10T16:53:43,027][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [parent-join]
  156. [2020-10-10T16:53:43,028][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [percolator]
  157. [2020-10-10T16:53:43,028][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [rank-eval]
  158. [2020-10-10T16:53:43,028][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [reindex]
  159. [2020-10-10T16:53:43,029][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [repository-url]
  160. [2020-10-10T16:53:43,029][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [search-business-rules]
  161. [2020-10-10T16:53:43,030][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [searchable-snapshots]
  162. [2020-10-10T16:53:43,030][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [spatial]
  163. [2020-10-10T16:53:43,031][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [tasks]
  164. [2020-10-10T16:53:43,031][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [transform]
  165. [2020-10-10T16:53:43,031][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [transport-netty4]
  166. [2020-10-10T16:53:43,032][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [vectors]
  167. [2020-10-10T16:53:43,032][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [wildcard]
  168. [2020-10-10T16:53:43,032][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-analytics]
  169. [2020-10-10T16:53:43,033][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-async]
  170. [2020-10-10T16:53:43,033][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-async-search]
  171. [2020-10-10T16:53:43,034][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-autoscaling]
  172. [2020-10-10T16:53:43,036][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-ccr]
  173. [2020-10-10T16:53:43,036][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-core]
  174. [2020-10-10T16:53:43,037][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-data-streams]
  175. [2020-10-10T16:53:43,037][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-deprecation]
  176. [2020-10-10T16:53:43,038][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-enrich]
  177. [2020-10-10T16:53:43,038][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-eql]
  178. [2020-10-10T16:53:43,038][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-graph]
  179. [2020-10-10T16:53:43,039][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-identity-provider]
  180. [2020-10-10T16:53:43,039][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-ilm]
  181. [2020-10-10T16:53:43,039][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-logstash]
  182. [2020-10-10T16:53:43,040][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-ml]
  183. [2020-10-10T16:53:43,040][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-monitoring]
  184. [2020-10-10T16:53:43,040][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-ql]
  185. [2020-10-10T16:53:43,041][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-rollup]
  186. [2020-10-10T16:53:43,041][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-security]
  187. [2020-10-10T16:53:43,041][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-sql]
  188. [2020-10-10T16:53:43,042][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-stack]
  189. [2020-10-10T16:53:43,042][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-voting-only-node]
  190. [2020-10-10T16:53:43,043][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] loaded module [x-pack-watcher]
  191. [2020-10-10T16:53:43,043][INFO ][o.e.p.PluginsService     ] [DESKTOP-1OP6K1E] no plugins loaded
  192. [2020-10-10T16:53:43,312][INFO ][o.e.e.NodeEnvironment    ] [DESKTOP-1OP6K1E] using [1] data paths, mounts [[(C:)]], net usable_space [128.5gb], net total_space [232.4gb], types [NTFS]
  193. [2020-10-10T16:53:43,312][INFO ][o.e.e.NodeEnvironment    ] [DESKTOP-1OP6K1E] heap size [1gb], compressed ordinary object pointers [true]
  194. [2020-10-10T16:53:43,455][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] node name [DESKTOP-1OP6K1E], node ID [m3Cz932jSqOozhQ0ua9OVg], cluster name [elasticsearch]
  195. [2020-10-10T16:53:46,137][INFO ][o.e.x.m.p.l.CppLogMessageHandler] [DESKTOP-1OP6K1E] [controller/516] [Main.cc@114] controller (64 bit): Version 7.9.2 (Build 6a60f0cf2dd5a5) Copyright (c) 2020 Elasticsearch BV
  196. [2020-10-10T16:53:46,617][INFO ][o.e.x.s.a.s.FileRolesStore] [DESKTOP-1OP6K1E] parsed [0] roles from file [C:\Users\leand\Desktop\elasticsearch-7.9.2\config\roles.yml]
  197. [2020-10-10T16:53:47,342][INFO ][o.e.t.NettyAllocator     ] [DESKTOP-1OP6K1E] creating NettyAllocator with the following configs: [name=unpooled, factors={es.unsafe.use_unpooled_allocator=false, g1gc_enabled=true, g1gc_region_size=1mb, heap_size=1gb}]
  198. [2020-10-10T16:53:47,389][INFO ][o.e.d.DiscoveryModule    ] [DESKTOP-1OP6K1E] using discovery type [zen] and seed hosts providers [settings]
  199. [2020-10-10T16:53:47,717][WARN ][o.e.g.DanglingIndicesState] [DESKTOP-1OP6K1E] gateway.auto_import_dangling_indices is disabled, dangling indices will not be automatically detected or imported and must be managed manually
  200. [2020-10-10T16:53:48,016][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] initialized
  201. [2020-10-10T16:53:48,016][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] starting ...
  202. [2020-10-10T16:53:48,138][INFO ][o.e.t.TransportService   ] [DESKTOP-1OP6K1E] publish_address {127.0.0.1:9300}, bound_addresses {127.0.0.1:9300}, {[::1]:9300}
  203. [2020-10-10T16:53:48,425][WARN ][o.e.b.BootstrapChecks    ] [DESKTOP-1OP6K1E] the default discovery settings are unsuitable for production use; at least one of [discovery.seed_hosts, discovery.seed_providers, cluster.initial_master_nodes] must be configured
  204. [2020-10-10T16:53:48,425][INFO ][o.e.c.c.Coordinator      ] [DESKTOP-1OP6K1E] cluster UUID [O_T444u1TtOptSi2tnYMHA]
  205. [2020-10-10T16:53:48,438][INFO ][o.e.c.c.ClusterBootstrapService] [DESKTOP-1OP6K1E] no discovery configuration found, will perform best-effort cluster bootstrapping after [3s] unless existing master is discovered
  206. [2020-10-10T16:53:48,506][INFO ][o.e.c.s.MasterService    ] [DESKTOP-1OP6K1E] elected-as-master ([1] nodes joined)[{DESKTOP-1OP6K1E}{m3Cz932jSqOozhQ0ua9OVg}{aSryhp_tSaaO7aY4dTPcvg}{127.0.0.1}{127.0.0.1:9300}{dilmrt}{ml.machine_memory=17108164608, xpack.installed=true, transform.node=true, ml.max_open_jobs=20} elect leader, _BECOME_MASTER_TASK_, _FINISH_ELECTION_], term: 14, version: 345, delta: master node changed {previous [], current [{DESKTOP-1OP6K1E}{m3Cz932jSqOozhQ0ua9OVg}{aSryhp_tSaaO7aY4dTPcvg}{127.0.0.1}{127.0.0.1:9300}{dilmrt}{ml.machine_memory=17108164608, xpack.installed=true, transform.node=true, ml.max_open_jobs=20}]}
  207. [2020-10-10T16:53:48,616][INFO ][o.e.c.s.ClusterApplierService] [DESKTOP-1OP6K1E] master node changed {previous [], current [{DESKTOP-1OP6K1E}{m3Cz932jSqOozhQ0ua9OVg}{aSryhp_tSaaO7aY4dTPcvg}{127.0.0.1}{127.0.0.1:9300}{dilmrt}{ml.machine_memory=17108164608, xpack.installed=true, transform.node=true, ml.max_open_jobs=20}]}, term: 14, version: 345, reason: Publication{term=14, version=345}
  208. [2020-10-10T16:53:48,667][INFO ][o.e.h.AbstractHttpServerTransport] [DESKTOP-1OP6K1E] publish_address {127.0.0.1:9200}, bound_addresses {127.0.0.1:9200}, {[::1]:9200}
  209. [2020-10-10T16:53:48,683][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] started
  210. [2020-10-10T16:53:48,854][INFO ][o.e.l.LicenseService     ] [DESKTOP-1OP6K1E] license [f3871a4a-f01a-4943-bfa6-86c1a1c10ff6] mode [basic] - valid
  211. [2020-10-10T16:53:48,870][INFO ][o.e.x.s.s.SecurityStatusChangeListener] [DESKTOP-1OP6K1E] Active license is now [BASIC]; Security is disabled
  212. [2020-10-10T16:53:48,870][INFO ][o.e.g.GatewayService     ] [DESKTOP-1OP6K1E] recovered [7] indices into cluster_state
  213. [2020-10-10T16:53:50,353][INFO ][o.e.c.r.a.AllocationService] [DESKTOP-1OP6K1E] Cluster health status changed from [RED] to [YELLOW] (reason: [shards started [[persons][0]]]).
  214. [2020-10-10T16:56:35,690][INFO ][o.e.x.m.p.NativeController] [DESKTOP-1OP6K1E] Native controller process has stopped - no new native processes can be started
  215. [2020-10-10T16:56:35,705][INFO ][o.e.b.Bootstrap          ] [DESKTOP-1OP6K1E] running graceful exit on windows
  216. [2020-10-10T16:56:35,705][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] stopping ...
  217. [2020-10-10T16:56:35,705][INFO ][o.e.x.w.WatcherService   ] [DESKTOP-1OP6K1E] stopping watch service, reason [shutdown initiated]
  218. [2020-10-10T16:56:35,705][INFO ][o.e.x.w.WatcherLifeCycleService] [DESKTOP-1OP6K1E] watcher has stopped and shutdown
  219. [2020-10-10T16:56:36,058][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] stopped
  220. [2020-10-10T16:56:36,058][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] closing ...
  221. [2020-10-10T16:56:36,073][INFO ][o.e.n.Node               ] [DESKTOP-1OP6K1E] closed
elasticsearchDateTimeHistogramelasticsearch-painlessdate-histogram

1条答案

按热度按时间
aelbi1ox

aelbi1ox1#

requesterror（400，'parsing\u exception'，'[bool]查询格式错误，应为[end\u object]，但找到了[field\u name]'）
这个错误清楚地表明查询的格式不正确。查询块需要关闭，然后聚合块就在那里。
尝试此搜索查询：

  1. {
  2.   "size": 0,
  3.   "query": {
  4.     "bool": {
  5.       "filter": {
  6.         "script": {
  7.           "script": {
  8.             "source": "doc['dateTime'].value.dayOfWeek",
  9.             "lang": "painless"
  10.           }
  11.         }
  12.       }
  13.     }
  14.   },                     <-- note the curly brackets
  15.   "aggs": {
  16.     "total_order_per_hour_per_day": {
  17.       "date_histogram": {
  18.         "field": "dateTime",
  19.         "calendar_interval": "hour"
  20.       }
  21.     }
  22.   }
  23. }
展开查看全部
赞(0）分享  回复(0）举报  2021-06-14
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com