text: {
    "version" : "6.0.0",
    "timestamp" : 1589386993189,
    "path" : "query-validation-tests/histogram.json",
    "schemas" : {
      "CTAS_S2_0.Aggregate.Aggregate.Materialize" : {
        "schema" : "`ID` BIGINT KEY, `ID` BIGINT, `VALUE` STRING, `KSQL_AGG_VARIABLE_0` MAP<STRING, BIGINT>",
        "serdeOptions" : [ ]
      },
      "CTAS_S2_0.KsqlTopic.Source" : {
        "schema" : "`ID` BIGINT KEY, `VALUE` STRING",
        "serdeOptions" : [ ]
      },
      "CTAS_S2_0.S2" : {
        "schema" : "`ID` BIGINT KEY, `COUNTS` MAP<STRING, BIGINT>",
        "serdeOptions" : [ ]
      },
      "CTAS_S2_0.Aggregate.GroupBy" : {
        "schema" : "`ID` BIGINT KEY, `ID` BIGINT, `VALUE` STRING",
        "serdeOptions" : [ ]
      }
    },
    "testCase" : {
      "name" : "histogram string - AVRO",
      "inputs" : [ {
        "topic" : "test_topic",
        "key" : 0,
        "value" : {
          "VALUE" : "foo"
        }
      }, {
        "topic" : "test_topic",
        "key" : 100,
        "value" : {
          "VALUE" : "baz"
        }
      }, {
        "topic" : "test_topic",
        "key" : 0,
        "value" : {
          "VALUE" : "bar"
        }
      }, {
        "topic" : "test_topic",
        "key" : 100,
        "value" : {
          "VALUE" : "baz"
        }
      }, {
        "topic" : "test_topic",
        "key" : 100,
        "value" : {
          "VALUE" : "foo"
        }
      } ],
      "outputs" : [ {
        "topic" : "S2",
        "key" : 0,
        "value" : {
          "COUNTS" : {
            "foo" : 1
          }
        }
      }, {
        "topic" : "S2",
        "key" : 100,
        "value" : {
          "COUNTS" : {
            "baz" : 1
          }
        }
      }, {
        "topic" : "S2",
        "key" : 0,
        "value" : {
          "COUNTS" : {
            "foo" : 1,
            "bar" : 1
          }
        }
      }, {
        "topic" : "S2",
        "key" : 100,
        "value" : {
          "COUNTS" : {
            "baz" : 2
          }
        }
      }, {
        "topic" : "S2",
        "key" : 100,
        "value" : {
          "COUNTS" : {
            "baz" : 2,
            "foo" : 1
          }
        }
      } ],
      "topics" : [ {
        "name" : "test_topic",
        "schema" : {
          "type" : "record",
          "name" : "KsqlDataSourceSchema",
          "namespace" : "io.confluent.ksql.avro_schemas",
          "fields" : [ {
            "name" : "VALUE",
            "type" : [ "null", "string" ],
            "default" : null
          } ],
          "connect.name" : "io.confluent.ksql.avro_schemas.KsqlDataSourceSchema"
        },
        "format" : "AVRO",
        "replicas" : 1,
        "numPartitions" : 4
      }, {
        "name" : "S2",
        "replicas" : 1,
        "numPartitions" : 4
      } ],
      "statements" : [ "CREATE STREAM TEST (ID BIGINT KEY, VALUE varchar) WITH (kafka_topic='test_topic', value_format='AVRO');", "CREATE TABLE S2 as SELECT ID, histogram(value) as counts FROM test group by id;" ],
      "post" : {
        "sources" : [ {
          "name" : "TEST",
          "type" : "STREAM",
          "schema" : "`ID` BIGINT KEY, `VALUE` STRING",
          "keyFormat" : {
            "format" : "KAFKA"
          },
          "serdeOptions" : [ ]
        }, {
          "name" : "S2",
          "type" : "TABLE",
          "schema" : "`ID` BIGINT KEY, `COUNTS` MAP<STRING, BIGINT>",
          "keyFormat" : {
            "format" : "KAFKA"
          },
          "serdeOptions" : [ ]
        } ],
        "topics" : {
          "topics" : [ {
            "name" : "_confluent-ksql-some.ksql.service.idquery_CTAS_S2_0-Aggregate-Aggregate-Materialize-changelog",
            "keyFormat" : {
              "formatInfo" : {
                "format" : "KAFKA"
              }
            },
            "valueFormat" : {
              "format" : "AVRO"
            }
          }, {
            "name" : "test_topic",
            "keyFormat" : {
              "formatInfo" : {
                "format" : "KAFKA"
              }
            },
            "valueFormat" : {
              "format" : "AVRO"
            },
            "partitions" : 4
          }, {
            "name" : "S2",
            "keyFormat" : {
              "formatInfo" : {
                "format" : "KAFKA"
              }
            },
            "valueFormat" : {
              "format" : "AVRO"
            },
            "partitions" : 4
          } ]
        }
      }
    }
  }