Apache Druid · JSON Structure

Apache Druid Sql Query Response Structure

Response from the Apache Druid SQL API with query results and metadata.

Type: object Properties: 5
AnalyticsApacheDatabaseKafkaOLAPOpen-SourceReal-TimeSQLTime Series

SqlQueryResponse is a JSON Structure definition published by Apache Druid, describing 5 properties. It conforms to the https://json-structure.org/meta/core/v0/# meta-schema.

Properties

queryId columns columnTypes sqlTypes results

Meta-schema: https://json-structure.org/meta/core/v0/#

JSON Structure

Raw ↑
{
  "$schema": "https://json-structure.org/meta/core/v0/#",
  "$id": "https://raw.githubusercontent.com/api-evangelist/apache-druid/refs/heads/main/json-structure/apache-druid-sql-query-response-structure.json",
  "name": "SqlQueryResponse",
  "description": "Response from the Apache Druid SQL API with query results and metadata.",
  "type": "object",
  "properties": {
    "queryId": {
      "type": "string",
      "description": "Unique ID assigned to this query.",
      "example": "abc-123-def-456"
    },
    "columns": {
      "type": "array",
      "description": "Column names in result order.",
      "items": {
        "type": "string"
      },
      "example": [
        "__time",
        "page",
        "added"
      ]
    },
    "columnTypes": {
      "type": "array",
      "description": "Column Druid types.",
      "items": {
        "type": "string"
      },
      "example": [
        "TIMESTAMP",
        "STRING",
        "LONG"
      ]
    },
    "sqlTypes": {
      "type": "array",
      "description": "Column SQL types.",
      "items": {
        "type": "string"
      },
      "example": [
        "TIMESTAMP",
        "VARCHAR",
        "BIGINT"
      ]
    },
    "results": {
      "type": "array",
      "description": "Query result rows (format depends on resultFormat).",
      "items": {
        "type": "object"
      }
    }
  }
}

Work with this as data

Every JSON Structure here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for json structure

4 MCP tools reach this
  • find_json_structuresBrowse and filter every JSON Structure in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This JSON Structure
curl "https://apis.io/api/v1/json-structures/apache-druid-sql-query-response-structure"
All json structure
curl "https://apis.io/api/v1/json-structures?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.