gistfile1.txt

{
  "type": "index_parallel",
  "spec": {
    "dataSchema": {
      "dataSource": "visitor_events-sessions-test1",
      "timestampSpec": {
        "column": "timestamp",
        "format": "auto"
      },
      "dimensionsSpec": {
        "dimensions": ["site_id", "environment_name"]
      },
      "metricsSpec": [
        { "type": "doubleSum", "name": "count", "fieldName": "count" },
        { "type": "thetaSketch", "name": "visitor_id_sketch", "fieldName": "visitor_id" }
      ],
      "granularitySpec": {
        "segmentGranularity": "day",
        "queryGranularity": "hour",
        "intervals": [
          "2020-05-18/2020-05-21"
        ]
      }
    },
    "ioConfig": {
      "type": "index_parallel",
      "inputSource": {
        "type": "druid",
        "dataSource": "visitor_events-sessions-v2",
        "interval": "2020-05-01/2020-06-01",
        "dimensions": ["site_id", "environment_name", "visitor_id"],
        "metrics": ["count"]
      }
    },
    "tuningConfig": {
      "type": "index_parallel"
    }
  }
}