Quartz's query: query_billing total duration of the query

[gshif]

test quartz's query (defined in https://github.com/influxdata/quartz/blob/cloud-two-dev/lib/quartz/two/billing/organization_usage.ex):

 def get_query_duration(org_id, start, stop) do
    """
    from(bucket: "system_usage")
    |> range(start: #{start}, stop: #{stop})
    |> filter(fn: (r) =>
    r.org_id != ""
    and r.org_id == "#{org_id}"
    and r._measurement == "queryd_billing"
    and r._field == "total_duration_us"
    )
    |> group()
    |> aggregateWindow(every: 1h, fn: sum)
    |> keep(columns: ["_time", "_value", "_start"])
    |> fill(column: "_value", value: 0)
    |> rename(columns: {_value: "duration_us"})
    |> yield(name: "duration_us")
    """
  end

[gshif]

• [x] Run two queries for about 10 seconds each (using sleep() function) to get data from bucket1 and buket2, when both of the buckets belong to the same org and buckets have data.
• [ ] Start querying bucket1 of the org1, but kill the query in the middle of the run. Query duration should be reported. I am not sure there is a way to cancel running query. I can cancel a request using timeout, but it won't cancel the query in the back-end. Posted a question in #flux channel
• [x] Start querying bucket1 using incorrect query. Query duration reported as 0.
• [ ] Run multiple queries to get data from bucket1 and bucket2 of the org2. Query duration should be reported.
• [x] Run query that does not return any data whether bucket is empty or data was filtered. Query duration should be reported.

[gshif]

Based on the code and conversation with Balaji, query duration will be reported all the time whether query was successful or failed.