---
name: iot 
start_time: "2018-01-01T00:00:00Z"
end_time: "2018-01-01T12:00:00Z"
data:
  type: bulk_data_file_loader
query_tests:
  # influxql versions (http means influxql)
  - {"type": "build_query_file", "format": "http", "use_case": "window-agg", "query_type": "min"}
  - {"type": "build_query_file", "format": "http", "use_case": "window-agg", "query_type": "mean"}
  - {"type": "build_query_file", "format": "http", "use_case": "window-agg", "query_type": "max"}
  - {"type": "build_query_file", "format": "http", "use_case": "window-agg", "query_type": "first"}
  - {"type": "build_query_file", "format": "http", "use_case": "window-agg", "query_type": "last"}
  - {"type": "build_query_file", "format": "http", "use_case": "window-agg", "query_type": "count"}
  - {"type": "build_query_file", "format": "http", "use_case": "window-agg", "query_type": "sum"}
  - {"type": "build_query_file", "format": "http", "use_case": "group-agg", "query_type": "min"}
  - {"type": "build_query_file", "format": "http", "use_case": "group-agg", "query_type": "mean"}
  - {"type": "build_query_file", "format": "http", "use_case": "group-agg", "query_type": "max"}
  - {"type": "build_query_file", "format": "http", "use_case": "group-agg", "query_type": "first"}
  - {"type": "build_query_file", "format": "http", "use_case": "group-agg", "query_type": "last"}
  - {"type": "build_query_file", "format": "http", "use_case": "group-agg", "query_type": "count"}
  - {"type": "build_query_file", "format": "http", "use_case": "group-agg", "query_type": "sum"}
  - {"type": "build_query_file", "format": "http", "use_case": "bare-agg", "query_type": "min"}
  - {"type": "build_query_file", "format": "http", "use_case": "bare-agg", "query_type": "mean"}
  - {"type": "build_query_file", "format": "http", "use_case": "bare-agg", "query_type": "max"}
  - {"type": "build_query_file", "format": "http", "use_case": "bare-agg", "query_type": "first"}
  - {"type": "build_query_file", "format": "http", "use_case": "bare-agg", "query_type": "last"}
  - {"type": "build_query_file", "format": "http", "use_case": "bare-agg", "query_type": "count"}
  - {"type": "build_query_file", "format": "http", "use_case": "bare-agg", "query_type": "sum"}
  - {"type": "build_query_file", "format": "http", "use_case": "ungrouped-agg", "query_type": "min"}
  - {"type": "build_query_file", "format": "http", "use_case": "ungrouped-agg", "query_type": "mean"}
  - {"type": "build_query_file", "format": "http", "use_case": "ungrouped-agg", "query_type": "max"}
  - {"type": "build_query_file", "format": "http", "use_case": "ungrouped-agg", "query_type": "first"}
  - {"type": "build_query_file", "format": "http", "use_case": "ungrouped-agg", "query_type": "last"}
  - {"type": "build_query_file", "format": "http", "use_case": "ungrouped-agg", "query_type": "count"}
  - {"type": "build_query_file", "format": "http", "use_case": "ungrouped-agg", "query_type": "sum"}

  - {"type": "build_query_file", "format": "http", "use_case": "iot", "query_type": "fast-query-small-data"}
  - {"type": "build_query_file", "format": "http", "use_case": "iot", "query_type": "standalone-filter"}
  - {"type": "build_query_file", "format": "http", "use_case": "iot", "query_type": "aggregate-keep"}
  - {"type": "build_query_file", "format": "http", "use_case": "iot", "query_type": "aggregate-drop"}
  - {"type": "build_query_file", "format": "http", "use_case": "iot", "query_type": "sorted-pivot"}

  - {"type": "build_query_file", "format": "http", "use_case": "group-window-transpose-low-card", "query_type": "min"}
  - {"type": "build_query_file", "format": "http", "use_case": "group-window-transpose-low-card", "query_type": "mean"}
  - {"type": "build_query_file", "format": "http", "use_case": "group-window-transpose-low-card", "query_type": "max"}
  - {"type": "build_query_file", "format": "http", "use_case": "group-window-transpose-low-card", "query_type": "first"}
  - {"type": "build_query_file", "format": "http", "use_case": "group-window-transpose-low-card", "query_type": "last"}
  - {"type": "build_query_file", "format": "http", "use_case": "group-window-transpose-low-card", "query_type": "count"}
  - {"type": "build_query_file", "format": "http", "use_case": "group-window-transpose-low-card", "query_type": "sum"}

  # flux versions
  - {"type": "build_query_file", "format": "flux-http", "use_case": "window-agg", "query_type": "min"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "window-agg", "query_type": "mean"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "window-agg", "query_type": "max"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "window-agg", "query_type": "first"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "window-agg", "query_type": "last"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "window-agg", "query_type": "count"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "window-agg", "query_type": "sum"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-agg", "query_type": "min"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-agg", "query_type": "mean"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-agg", "query_type": "max"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-agg", "query_type": "first"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-agg", "query_type": "last"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-agg", "query_type": "count"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-agg", "query_type": "sum"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "bare-agg", "query_type": "min"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "bare-agg", "query_type": "mean"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "bare-agg", "query_type": "max"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "bare-agg", "query_type": "first"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "bare-agg", "query_type": "last"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "bare-agg", "query_type": "count"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "bare-agg", "query_type": "sum"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "ungrouped-agg", "query_type": "min"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "ungrouped-agg", "query_type": "mean"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "ungrouped-agg", "query_type": "max"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "ungrouped-agg", "query_type": "first"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "ungrouped-agg", "query_type": "last"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "ungrouped-agg", "query_type": "count"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "ungrouped-agg", "query_type": "sum"}

  - {"type": "build_query_file", "format": "flux-http", "use_case": "iot", "query_type": "fast-query-small-data"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "iot", "query_type": "standalone-filter"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "iot", "query_type": "aggregate-keep"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "iot", "query_type": "aggregate-drop"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "iot", "query_type": "sorted-pivot"}

  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-window-transpose-low-card", "query_type": "min"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-window-transpose-low-card", "query_type": "mean"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-window-transpose-low-card", "query_type": "max"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-window-transpose-low-card", "query_type": "first"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-window-transpose-low-card", "query_type": "last"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-window-transpose-low-card", "query_type": "count"}
  - {"type": "build_query_file", "format": "flux-http", "use_case": "group-window-transpose-low-card", "query_type": "sum"}
