text: {
    "version" : "5.5.0",
    "timestamp" : 1581572105208,
    "path" : "query-validation-tests/url.json",
    "schemas" : {
      "CSAS_OUTPUT_0.KsqlTopic.Source" : {
        "schema" : "`ROWKEY` STRING KEY, `URL` STRING",
        "serdeOptions" : [ ]
      },
      "CSAS_OUTPUT_0.OUTPUT" : {
        "schema" : "`ROWKEY` STRING KEY, `PARAM_A` STRING, `PARAM_B` STRING",
        "serdeOptions" : [ ]
      }
    },
    "testCase" : {
      "name" : "extract a parameter from a URL using URL_EXTRACT_PARAMETER - JSON",
      "inputs" : [ {
        "topic" : "test_topic",
        "key" : "1",
        "value" : {
          "url" : "http://www.test.com/?one=a&two=b&three"
        },
        "timestamp" : 0
      } ],
      "outputs" : [ {
        "topic" : "OUTPUT",
        "key" : "1",
        "value" : {
          "PARAM_A" : "a",
          "PARAM_B" : "b"
        },
        "timestamp" : 0
      } ],
      "topics" : [ {
        "name" : "OUTPUT",
        "replicas" : 1,
        "numPartitions" : 4
      }, {
        "name" : "test_topic",
        "replicas" : 1,
        "numPartitions" : 4
      } ],
      "statements" : [ "CREATE STREAM TEST (URL STRING) WITH (KAFKA_TOPIC='test_topic', VALUE_FORMAT='JSON');", "CREATE STREAM OUTPUT AS SELECT\n  URL_EXTRACT_PARAMETER(TEST.URL, 'one') PARAM_A,\n  URL_EXTRACT_PARAMETER(TEST.URL, 'two') PARAM_B\nFROM TEST TEST\nEMIT CHANGES;" ],
      "post" : {
        "sources" : [ {
          "name" : "OUTPUT",
          "type" : "STREAM",
          "schema" : "`ROWKEY` STRING KEY, `PARAM_A` STRING, `PARAM_B` STRING",
          "keyFormat" : {
            "format" : "KAFKA"
          },
          "serdeOptions" : [ ]
        }, {
          "name" : "TEST",
          "type" : "STREAM",
          "schema" : "`ROWKEY` STRING KEY, `URL` STRING",
          "keyFormat" : {
            "format" : "KAFKA"
          },
          "serdeOptions" : [ ]
        } ],
        "topics" : {
          "topics" : [ {
            "name" : "test_topic",
            "keyFormat" : {
              "formatInfo" : {
                "format" : "KAFKA"
              }
            },
            "valueFormat" : {
              "format" : "JSON"
            },
            "partitions" : 4
          }, {
            "name" : "OUTPUT",
            "keyFormat" : {
              "formatInfo" : {
                "format" : "KAFKA"
              }
            },
            "valueFormat" : {
              "format" : "JSON"
            },
            "partitions" : 4
          } ]
        }
      }
    }
  }