"use strict";(self.webpackChunk=self.webpackChunk||[]).push([[53],{1109:e=>{e.exports=JSON.parse('{"pluginId":"default","version":"current","label":"Next","banner":null,"badge":false,"noIndex":false,"className":"docs-version-current","isLast":true,"docsSidebars":{"docs":[{"type":"category","label":"Getting started","items":[{"type":"link","label":"Introduction to Apache Druid","href":"/docs/latest/design/","docId":"design/index"},{"type":"link","label":"Quickstart (local)","href":"/docs/latest/tutorials/","docId":"tutorials/index"},{"type":"link","label":"Single server deployment","href":"/docs/latest/operations/single-server","docId":"operations/single-server"},{"type":"link","label":"Clustered deployment","href":"/docs/latest/tutorials/cluster","docId":"tutorials/cluster"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Tutorials","items":[{"type":"link","label":"Load files using SQL","href":"/docs/latest/tutorials/tutorial-msq-extern","docId":"tutorials/tutorial-msq-extern"},{"type":"link","label":"Load from Apache Kafka","href":"/docs/latest/tutorials/tutorial-kafka","docId":"tutorials/tutorial-kafka"},{"type":"link","label":"Load from Apache Hadoop","href":"/docs/latest/tutorials/tutorial-batch-hadoop","docId":"tutorials/tutorial-batch-hadoop"},{"type":"link","label":"Query data","href":"/docs/latest/tutorials/tutorial-query","docId":"tutorials/tutorial-query"},{"type":"link","label":"Aggregate data with rollup","href":"/docs/latest/tutorials/tutorial-rollup","docId":"tutorials/tutorial-rollup"},{"type":"link","label":"Theta sketches","href":"/docs/latest/tutorials/tutorial-sketches-theta","docId":"tutorials/tutorial-sketches-theta"},{"type":"link","label":"Configure data retention","href":"/docs/latest/tutorials/tutorial-retention","docId":"tutorials/tutorial-retention"},{"type":"link","label":"Update existing data","href":"/docs/latest/tutorials/tutorial-update-data","docId":"tutorials/tutorial-update-data"},{"type":"link","label":"Compact segments","href":"/docs/latest/tutorials/tutorial-compaction","docId":"tutorials/tutorial-compaction"},{"type":"link","label":"Deleting data","href":"/docs/latest/tutorials/tutorial-delete-data","docId":"tutorials/tutorial-delete-data"},{"type":"link","label":"Write an ingestion spec","href":"/docs/latest/tutorials/tutorial-ingestion-spec","docId":"tutorials/tutorial-ingestion-spec"},{"type":"link","label":"Transform input data","href":"/docs/latest/tutorials/tutorial-transform-spec","docId":"tutorials/tutorial-transform-spec"},{"type":"link","label":"Convert ingestion spec to SQL","href":"/docs/latest/tutorials/tutorial-msq-convert-spec","docId":"tutorials/tutorial-msq-convert-spec"},{"type":"link","label":"Run with Docker","href":"/docs/latest/tutorials/docker","docId":"tutorials/docker"},{"type":"link","label":"Kerberized HDFS deep storage","href":"/docs/latest/tutorials/tutorial-kerberos-hadoop","docId":"tutorials/tutorial-kerberos-hadoop"},{"type":"link","label":"Get to know Query view","href":"/docs/latest/tutorials/tutorial-sql-query-view","docId":"tutorials/tutorial-sql-query-view"},{"type":"link","label":"Unnesting arrays","href":"/docs/latest/tutorials/tutorial-unnest-arrays","docId":"tutorials/tutorial-unnest-arrays"},{"type":"link","label":"Query from deep storage","href":"/docs/latest/tutorials/tutorial-query-deep-storage","docId":"tutorials/tutorial-query-deep-storage"},{"type":"link","label":"Jupyter Notebook tutorials","href":"/docs/latest/tutorials/tutorial-jupyter-index","docId":"tutorials/tutorial-jupyter-index"},{"type":"link","label":"Docker for tutorials","href":"/docs/latest/tutorials/tutorial-jupyter-docker","docId":"tutorials/tutorial-jupyter-docker"},{"type":"link","label":"JDBC connector","href":"/docs/latest/tutorials/tutorial-jdbc","docId":"tutorials/tutorial-jdbc"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Design","items":[{"type":"link","label":"Design","href":"/docs/latest/design/architecture","docId":"design/architecture"},{"type":"link","label":"Segments","href":"/docs/latest/design/segments","docId":"design/segments"},{"type":"link","label":"Processes and servers","href":"/docs/latest/design/processes","docId":"design/processes"},{"type":"link","label":"Deep storage","href":"/docs/latest/design/deep-storage","docId":"design/deep-storage"},{"type":"link","label":"Metadata storage","href":"/docs/latest/design/metadata-storage","docId":"design/metadata-storage"},{"type":"link","label":"ZooKeeper","href":"/docs/latest/design/zookeeper","docId":"design/zookeeper"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Ingestion","items":[{"type":"link","label":"Overview","href":"/docs/latest/ingestion/","docId":"ingestion/index"},{"type":"category","label":"Ingestion concepts","items":[{"type":"link","label":"Source input formats","href":"/docs/latest/ingestion/data-formats","docId":"ingestion/data-formats"},{"type":"link","label":"Input sources","href":"/docs/latest/ingestion/input-sources","docId":"ingestion/input-sources"},{"type":"link","label":"Schema model","href":"/docs/latest/ingestion/schema-model","docId":"ingestion/schema-model"},{"type":"link","label":"Rollup","href":"/docs/latest/ingestion/rollup","docId":"ingestion/rollup"},{"type":"link","label":"Partitioning","href":"/docs/latest/ingestion/partitioning","docId":"ingestion/partitioning"},{"type":"link","label":"Task reference","href":"/docs/latest/ingestion/tasks","docId":"ingestion/tasks"}],"collapsed":true,"collapsible":true},{"type":"category","label":"SQL-based batch","items":[{"type":"link","label":"SQL-based ingestion","href":"/docs/latest/multi-stage-query/","docId":"multi-stage-query/index"},{"type":"link","label":"Key concepts","href":"/docs/latest/multi-stage-query/concepts","docId":"multi-stage-query/concepts"},{"type":"link","label":"Security","href":"/docs/latest/multi-stage-query/security","docId":"multi-stage-query/security"},{"type":"link","label":"Examples","href":"/docs/latest/multi-stage-query/examples","docId":"multi-stage-query/examples"},{"type":"link","label":"Reference","href":"/docs/latest/multi-stage-query/reference","docId":"multi-stage-query/reference"},{"type":"link","label":"Known issues","href":"/docs/latest/multi-stage-query/known-issues","docId":"multi-stage-query/known-issues"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Streaming","items":[{"type":"link","label":"Apache Kafka ingestion","href":"/docs/latest/development/extensions-core/kafka-ingestion","docId":"development/extensions-core/kafka-ingestion"},{"type":"link","label":"Apache Kafka supervisor","href":"/docs/latest/development/extensions-core/kafka-supervisor-reference","docId":"development/extensions-core/kafka-supervisor-reference"},{"type":"link","label":"Apache Kafka operations","href":"/docs/latest/development/extensions-core/kafka-supervisor-operations","docId":"development/extensions-core/kafka-supervisor-operations"},{"type":"link","label":"Amazon Kinesis","href":"/docs/latest/development/extensions-core/kinesis-ingestion","docId":"development/extensions-core/kinesis-ingestion"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Classic batch","items":[{"type":"link","label":"JSON-based batch","href":"/docs/latest/ingestion/native-batch","docId":"ingestion/native-batch"},{"type":"link","label":"Hadoop-based","href":"/docs/latest/ingestion/hadoop","docId":"ingestion/hadoop"}],"collapsed":true,"collapsible":true},{"type":"link","label":"Ingestion spec reference","href":"/docs/latest/ingestion/ingestion-spec","docId":"ingestion/ingestion-spec"},{"type":"link","label":"Schema design tips","href":"/docs/latest/ingestion/schema-design","docId":"ingestion/schema-design"},{"type":"link","label":"Troubleshooting FAQ","href":"/docs/latest/ingestion/faq","docId":"ingestion/faq"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Data management","items":[{"type":"link","label":"Overview","href":"/docs/latest/data-management/","docId":"data-management/index"},{"type":"link","label":"Data updates","href":"/docs/latest/data-management/update","docId":"data-management/update"},{"type":"link","label":"Data deletion","href":"/docs/latest/data-management/delete","docId":"data-management/delete"},{"type":"link","label":"Schema changes","href":"/docs/latest/data-management/schema-changes","docId":"data-management/schema-changes"},{"type":"category","label":"Compaction","items":[{"type":"link","label":"Automatic compaction","href":"/docs/latest/data-management/automatic-compaction","docId":"data-management/automatic-compaction"},{"type":"link","label":"Manual compaction","href":"/docs/latest/data-management/manual-compaction","docId":"data-management/manual-compaction"}],"collapsed":true,"collapsible":true,"href":"/docs/latest/data-management/compaction"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Querying","items":[{"type":"category","label":"Druid SQL","items":[{"type":"link","label":"Overview and syntax","href":"/docs/latest/querying/sql","docId":"querying/sql"},{"type":"link","label":"Tips for writing good queries","href":"/docs/latest/querying/tips-good-queries","docId":"querying/tips-good-queries"},{"type":"link","label":"Query from deep storage","href":"/docs/latest/querying/query-deep-storage","docId":"querying/query-deep-storage"},{"type":"link","label":"SQL data types","href":"/docs/latest/querying/sql-data-types","docId":"querying/sql-data-types"},{"type":"link","label":"Operators","href":"/docs/latest/querying/sql-operators","docId":"querying/sql-operators"},{"type":"link","label":"Scalar functions","href":"/docs/latest/querying/sql-scalar","docId":"querying/sql-scalar"},{"type":"link","label":"Aggregation functions","href":"/docs/latest/querying/sql-aggregations","docId":"querying/sql-aggregations"},{"type":"link","label":"Window functions","href":"/docs/latest/querying/sql-window-functions","docId":"querying/sql-window-functions"},{"type":"link","label":"Array functions","href":"/docs/latest/querying/sql-array-functions","docId":"querying/sql-array-functions"},{"type":"link","label":"Multi-value string functions","href":"/docs/latest/querying/sql-multivalue-string-functions","docId":"querying/sql-multivalue-string-functions"},{"type":"link","label":"JSON functions","href":"/docs/latest/querying/sql-json-functions","docId":"querying/sql-json-functions"},{"type":"link","label":"All functions","href":"/docs/latest/querying/sql-functions","docId":"querying/sql-functions"},{"type":"link","label":"SQL query context","href":"/docs/latest/querying/sql-query-context","docId":"querying/sql-query-context"},{"type":"link","label":"SQL metadata tables","href":"/docs/latest/querying/sql-metadata-tables","docId":"querying/sql-metadata-tables"},{"type":"link","label":"SQL query translation","href":"/docs/latest/querying/sql-translation","docId":"querying/sql-translation"}],"collapsed":true,"collapsible":true},{"type":"link","label":"Native queries","href":"/docs/latest/querying/","docId":"querying/querying"},{"type":"link","label":"Query execution","href":"/docs/latest/querying/query-execution","docId":"querying/query-execution"},{"type":"link","label":"Troubleshooting","href":"/docs/latest/querying/troubleshooting","docId":"querying/troubleshooting"},{"type":"category","label":"Concepts","items":[{"type":"link","label":"Datasources","href":"/docs/latest/querying/datasource","docId":"querying/datasource"},{"type":"link","label":"Joins","href":"/docs/latest/querying/joins","docId":"querying/joins"},{"type":"link","label":"Lookups","href":"/docs/latest/querying/lookups","docId":"querying/lookups"},{"type":"link","label":"Multi-value dimensions","href":"/docs/latest/querying/multi-value-dimensions","docId":"querying/multi-value-dimensions"},{"type":"link","label":"Arrays","href":"/docs/latest/querying/arrays","docId":"querying/arrays"},{"type":"link","label":"Nested columns","href":"/docs/latest/querying/nested-columns","docId":"querying/nested-columns"},{"type":"link","label":"Multitenancy","href":"/docs/latest/querying/multitenancy","docId":"querying/multitenancy"},{"type":"link","label":"Query caching","href":"/docs/latest/querying/caching","docId":"querying/caching"},{"type":"link","label":"Using query caching","href":"/docs/latest/querying/using-caching","docId":"querying/using-caching"},{"type":"link","label":"Query context","href":"/docs/latest/querying/query-context","docId":"querying/query-context"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Native query types","items":[{"type":"link","label":"Timeseries","href":"/docs/latest/querying/timeseriesquery","docId":"querying/timeseriesquery"},{"type":"link","label":"TopN","href":"/docs/latest/querying/topnquery","docId":"querying/topnquery"},{"type":"link","label":"GroupBy","href":"/docs/latest/querying/groupbyquery","docId":"querying/groupbyquery"},{"type":"link","label":"Scan","href":"/docs/latest/querying/scan-query","docId":"querying/scan-query"},{"type":"link","label":"Search","href":"/docs/latest/querying/searchquery","docId":"querying/searchquery"},{"type":"link","label":"TimeBoundary","href":"/docs/latest/querying/timeboundaryquery","docId":"querying/timeboundaryquery"},{"type":"link","label":"SegmentMetadata","href":"/docs/latest/querying/segmentmetadataquery","docId":"querying/segmentmetadataquery"},{"type":"link","label":"DatasourceMetadata","href":"/docs/latest/querying/datasourcemetadataquery","docId":"querying/datasourcemetadataquery"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Native query components","items":[{"type":"link","label":"Filters","href":"/docs/latest/querying/filters","docId":"querying/filters"},{"type":"link","label":"Granularities","href":"/docs/latest/querying/granularities","docId":"querying/granularities"},{"type":"link","label":"Dimensions","href":"/docs/latest/querying/dimensionspecs","docId":"querying/dimensionspecs"},{"type":"link","label":"Aggregations","href":"/docs/latest/querying/aggregations","docId":"querying/aggregations"},{"type":"link","label":"Post-aggregations","href":"/docs/latest/querying/post-aggregations","docId":"querying/post-aggregations"},{"type":"link","label":"Expressions","href":"/docs/latest/querying/math-expr","docId":"querying/math-expr"},{"type":"link","label":"Having filters (groupBy)","href":"/docs/latest/querying/having","docId":"querying/having"},{"type":"link","label":"Sorting and limiting (groupBy)","href":"/docs/latest/querying/limitspec","docId":"querying/limitspec"},{"type":"link","label":"Sorting (topN)","href":"/docs/latest/querying/topnmetricspec","docId":"querying/topnmetricspec"},{"type":"link","label":"String comparators","href":"/docs/latest/querying/sorting-orders","docId":"querying/sorting-orders"},{"type":"link","label":"Virtual columns","href":"/docs/latest/querying/virtual-columns","docId":"querying/virtual-columns"},{"type":"link","label":"Spatial filters","href":"/docs/latest/querying/geo","docId":"querying/geo"}],"collapsed":true,"collapsible":true}],"collapsed":true,"collapsible":true},{"type":"category","label":"API reference","items":[{"type":"link","label":"Overview","href":"/docs/latest/api-reference/","docId":"api-reference/api-reference"},{"type":"category","label":"HTTP APIs","items":[{"type":"link","label":"Druid SQL","href":"/docs/latest/api-reference/sql-api","docId":"api-reference/sql-api"},{"type":"link","label":"SQL-based ingestion","href":"/docs/latest/api-reference/sql-ingestion-api","docId":"api-reference/sql-ingestion-api"},{"type":"link","label":"JSON querying","href":"/docs/latest/api-reference/json-querying-api","docId":"api-reference/json-querying-api"},{"type":"link","label":"Tasks","href":"/docs/latest/api-reference/tasks-api","docId":"api-reference/tasks-api"},{"type":"link","label":"Supervisors","href":"/docs/latest/api-reference/supervisor-api","docId":"api-reference/supervisor-api"},{"type":"link","label":"Retention rules","href":"/docs/latest/api-reference/retention-rules-api","docId":"api-reference/retention-rules-api"},{"type":"link","label":"Data management","href":"/docs/latest/api-reference/data-management-api","docId":"api-reference/data-management-api"},{"type":"link","label":"Automatic compaction","href":"/docs/latest/api-reference/automatic-compaction-api","docId":"api-reference/automatic-compaction-api"},{"type":"link","label":"Lookups","href":"/docs/latest/api-reference/lookups-api","docId":"api-reference/lookups-api"},{"type":"link","label":"Service status","href":"/docs/latest/api-reference/service-status-api","docId":"api-reference/service-status-api"},{"type":"link","label":"Dynamic configuration","href":"/docs/latest/api-reference/dynamic-configuration-api","docId":"api-reference/dynamic-configuration-api"},{"type":"link","label":"Legacy metadata","href":"/docs/latest/api-reference/legacy-metadata-api","docId":"api-reference/legacy-metadata-api"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Java APIs","items":[{"type":"link","label":"SQL JDBC driver","href":"/docs/latest/api-reference/sql-jdbc","docId":"api-reference/sql-jdbc"}],"collapsed":true,"collapsible":true}],"collapsed":true,"collapsible":true},{"type":"category","label":"Configuration","items":[{"type":"link","label":"Configuration reference","href":"/docs/latest/configuration/","docId":"configuration/index"},{"type":"link","label":"Extensions","href":"/docs/latest/configuration/extensions","docId":"configuration/extensions"},{"type":"link","label":"Logging","href":"/docs/latest/configuration/logging","docId":"configuration/logging"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Operations","items":[{"type":"link","label":"Web console","href":"/docs/latest/operations/web-console","docId":"operations/web-console"},{"type":"link","label":"Java runtime","href":"/docs/latest/operations/java","docId":"operations/java"},{"type":"link","label":"Durable storage","href":"/docs/latest/operations/durable-storage","docId":"operations/durable-storage"},{"type":"category","label":"Security","items":[{"type":"link","label":"Security overview","href":"/docs/latest/operations/security-overview","docId":"operations/security-overview"},{"type":"link","label":"User authentication and authorization","href":"/docs/latest/operations/security-user-auth","docId":"operations/security-user-auth"},{"type":"link","label":"LDAP auth","href":"/docs/latest/operations/auth-ldap","docId":"operations/auth-ldap"},{"type":"link","label":"Password providers","href":"/docs/latest/operations/password-provider","docId":"operations/password-provider"},{"type":"link","label":"Dynamic Config Providers","href":"/docs/latest/operations/dynamic-config-provider","docId":"operations/dynamic-config-provider"},{"type":"link","label":"TLS support","href":"/docs/latest/operations/tls-support","docId":"operations/tls-support"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Performance tuning","items":[{"type":"link","label":"Basic cluster tuning","href":"/docs/latest/operations/basic-cluster-tuning","docId":"operations/basic-cluster-tuning"},{"type":"link","label":"Segment size optimization","href":"/docs/latest/operations/segment-optimization","docId":"operations/segment-optimization"},{"type":"link","label":"Mixed workloads","href":"/docs/latest/operations/mixed-workloads","docId":"operations/mixed-workloads"},{"type":"link","label":"HTTP compression","href":"/docs/latest/operations/http-compression","docId":"operations/http-compression"},{"type":"link","label":"Automated metadata cleanup","href":"/docs/latest/operations/clean-metadata-store","docId":"operations/clean-metadata-store"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Monitoring","items":[{"type":"link","label":"Request logging","href":"/docs/latest/operations/request-logging","docId":"operations/request-logging"},{"type":"link","label":"Metrics","href":"/docs/latest/operations/metrics","docId":"operations/metrics"},{"type":"link","label":"Alerts","href":"/docs/latest/operations/alerts","docId":"operations/alerts"}],"collapsed":true,"collapsible":true},{"type":"link","label":"High availability","href":"/docs/latest/operations/high-availability","docId":"operations/high-availability"},{"type":"link","label":"Rolling updates","href":"/docs/latest/operations/rolling-updates","docId":"operations/rolling-updates"},{"type":"link","label":"Using rules to drop and retain data","href":"/docs/latest/operations/rule-configuration","docId":"operations/rule-configuration"},{"type":"link","label":"Migrate from firehose","href":"/docs/latest/operations/migrate-from-firehose","docId":"operations/migrate-from-firehose"},{"type":"link","label":"Working with different versions of Apache Hadoop","href":"/docs/latest/operations/other-hadoop","docId":"operations/other-hadoop"},{"type":"category","label":"Misc","items":[{"type":"link","label":"dump-segment tool","href":"/docs/latest/operations/dump-segment","docId":"operations/dump-segment"},{"type":"link","label":"reset-cluster tool","href":"/docs/latest/operations/reset-cluster","docId":"operations/reset-cluster"},{"type":"link","label":"insert-segment-to-db tool","href":"/docs/latest/operations/insert-segment-to-db","docId":"operations/insert-segment-to-db"},{"type":"link","label":"pull-deps tool","href":"/docs/latest/operations/pull-deps","docId":"operations/pull-deps"},{"type":"link","label":"Deep storage migration","href":"/docs/latest/operations/deep-storage-migration","docId":"operations/deep-storage-migration"},{"type":"link","label":"Export Metadata Tool","href":"/docs/latest/operations/export-metadata","docId":"operations/export-metadata"},{"type":"link","label":"Metadata Migration","href":"/docs/latest/operations/metadata-migration","docId":"operations/metadata-migration"},{"type":"link","label":"Content for build.sbt","href":"/docs/latest/operations/use_sbt_to_build_fat_jar","docId":"operations/use_sbt_to_build_fat_jar"}],"collapsed":true,"collapsible":true}],"collapsed":true,"collapsible":true},{"type":"category","label":"Development","items":[{"type":"link","label":"Developing on Druid","href":"/docs/latest/development/overview","docId":"development/overview"},{"type":"link","label":"Creating extensions","href":"/docs/latest/development/modules","docId":"development/modules"},{"type":"link","label":"JavaScript functionality","href":"/docs/latest/development/javascript","docId":"development/javascript"},{"type":"link","label":"Build from source","href":"/docs/latest/development/build","docId":"development/build"},{"type":"link","label":"Versioning","href":"/docs/latest/development/versioning","docId":"development/versioning"},{"type":"link","label":"Contribute to Druid docs","href":"/docs/latest/development/contribute-to-docs","docId":"development/contribute-to-docs"},{"type":"link","label":"Experimental features","href":"/docs/latest/development/experimental","docId":"development/experimental"}],"collapsed":true,"collapsible":true},{"type":"category","label":"Misc","items":[{"type":"link","label":"Papers","href":"/docs/latest/misc/papers-and-talks","docId":"misc/papers-and-talks"}],"collapsed":true,"collapsible":true}]},"docs":{"api-reference/api-reference":{"id":"api-reference/api-reference","title":"API reference","description":"\x3c!--","sidebar":"docs"},"api-reference/automatic-compaction-api":{"id":"api-reference/automatic-compaction-api","title":"Automatic compaction API","description":"\x3c!--","sidebar":"docs"},"api-reference/data-management-api":{"id":"api-reference/data-management-api","title":"Data management API","description":"\x3c!--","sidebar":"docs"},"api-reference/dynamic-configuration-api":{"id":"api-reference/dynamic-configuration-api","title":"Dynamic configuration API","description":"\x3c!--","sidebar":"docs"},"api-reference/json-querying-api":{"id":"api-reference/json-querying-api","title":"JSON querying API","description":"\x3c!--","sidebar":"docs"},"api-reference/legacy-metadata-api":{"id":"api-reference/legacy-metadata-api","title":"Legacy metadata API","description":"\x3c!--","sidebar":"docs"},"api-reference/lookups-api":{"id":"api-reference/lookups-api","title":"Lookups API","description":"\x3c!--","sidebar":"docs"},"api-reference/retention-rules-api":{"id":"api-reference/retention-rules-api","title":"Retention rules API","description":"\x3c!--","sidebar":"docs"},"api-reference/service-status-api":{"id":"api-reference/service-status-api","title":"Service status API","description":"\x3c!--","sidebar":"docs"},"api-reference/sql-api":{"id":"api-reference/sql-api","title":"Druid SQL API","description":"\x3c!--","sidebar":"docs"},"api-reference/sql-ingestion-api":{"id":"api-reference/sql-ingestion-api","title":"SQL-based ingestion API","description":"\x3c!--","sidebar":"docs"},"api-reference/sql-jdbc":{"id":"api-reference/sql-jdbc","title":"SQL JDBC driver API","description":"\x3c!--","sidebar":"docs"},"api-reference/supervisor-api":{"id":"api-reference/supervisor-api","title":"Supervisor API","description":"\x3c!--","sidebar":"docs"},"api-reference/tasks-api":{"id":"api-reference/tasks-api","title":"Tasks API","description":"\x3c!--","sidebar":"docs"},"comparisons/druid-vs-elasticsearch":{"id":"comparisons/druid-vs-elasticsearch","title":"Apache Druid vs Elasticsearch","description":"\x3c!--"},"comparisons/druid-vs-key-value":{"id":"comparisons/druid-vs-key-value","title":"Apache Druid vs. Key/Value Stores (HBase/Cassandra/OpenTSDB)","description":"\x3c!--"},"comparisons/druid-vs-kudu":{"id":"comparisons/druid-vs-kudu","title":"Apache Druid vs Kudu","description":"\x3c!--"},"comparisons/druid-vs-redshift":{"id":"comparisons/druid-vs-redshift","title":"Apache Druid vs Redshift","description":"\x3c!--"},"comparisons/druid-vs-spark":{"id":"comparisons/druid-vs-spark","title":"Apache Druid vs Spark","description":"\x3c!--"},"comparisons/druid-vs-sql-on-hadoop":{"id":"comparisons/druid-vs-sql-on-hadoop","title":"Apache Druid vs SQL-on-Hadoop","description":"\x3c!--"},"configuration/extensions":{"id":"configuration/extensions","title":"Extensions","description":"\x3c!--","sidebar":"docs"},"configuration/human-readable-byte":{"id":"configuration/human-readable-byte","title":"Human-readable Byte Configuration Reference","description":"\x3c!--"},"configuration/index":{"id":"configuration/index","title":"Configuration reference","description":"\x3c!--","sidebar":"docs"},"configuration/logging":{"id":"configuration/logging","title":"Logging","description":"\x3c!--","sidebar":"docs"},"data-management/automatic-compaction":{"id":"data-management/automatic-compaction","title":"Automatic compaction","description":"\x3c!--","sidebar":"docs"},"data-management/compaction":{"id":"data-management/compaction","title":"Compaction","description":"Defines compaction and automatic compaction (auto-compaction or autocompaction) for segment optimization. Use cases and strategies for compaction. Describes compaction task configuration.","sidebar":"docs"},"data-management/delete":{"id":"data-management/delete","title":"Data deletion","description":"\x3c!--","sidebar":"docs"},"data-management/index":{"id":"data-management/index","title":"Data management","description":"\x3c!--","sidebar":"docs"},"data-management/manual-compaction":{"id":"data-management/manual-compaction","title":"Manual compaction","description":"\x3c!--","sidebar":"docs"},"data-management/schema-changes":{"id":"data-management/schema-changes","title":"Schema changes","description":"\x3c!--","sidebar":"docs"},"data-management/update":{"id":"data-management/update","title":"Data updates","description":"\x3c!--","sidebar":"docs"},"design/architecture":{"id":"design/architecture","title":"Design","description":"\x3c!--","sidebar":"docs"},"design/broker":{"id":"design/broker","title":"Broker","description":"\x3c!--"},"design/coordinator":{"id":"design/coordinator","title":"Coordinator Process","description":"\x3c!--"},"design/deep-storage":{"id":"design/deep-storage","title":"Deep storage","description":"\x3c!--","sidebar":"docs"},"design/extensions-contrib/dropwizard":{"id":"design/extensions-contrib/dropwizard","title":"Dropwizard metrics emitter","description":"\x3c!--"},"design/historical":{"id":"design/historical","title":"Historical Process","description":"\x3c!--"},"design/index":{"id":"design/index","title":"Introduction to Apache Druid","description":"\x3c!--","sidebar":"docs"},"design/indexer":{"id":"design/indexer","title":"Indexer Process","description":"\x3c!--"},"design/indexing-service":{"id":"design/indexing-service","title":"Indexing Service","description":"\x3c!--"},"design/metadata-storage":{"id":"design/metadata-storage","title":"Metadata storage","description":"\x3c!--","sidebar":"docs"},"design/middlemanager":{"id":"design/middlemanager","title":"MiddleManager Process","description":"\x3c!--"},"design/overlord":{"id":"design/overlord","title":"Overlord Process","description":"\x3c!--"},"design/peons":{"id":"design/peons","title":"Peons","description":"\x3c!--"},"design/processes":{"id":"design/processes","title":"Processes and servers","description":"\x3c!--","sidebar":"docs"},"design/router":{"id":"design/router","title":"Router Process","description":"\x3c!--"},"design/segments":{"id":"design/segments","title":"Segments","description":"\x3c!--","sidebar":"docs"},"design/zookeeper":{"id":"design/zookeeper","title":"ZooKeeper","description":"\x3c!--","sidebar":"docs"},"development/build":{"id":"development/build","title":"Build from source","description":"\x3c!--","sidebar":"docs"},"development/contribute-to-docs":{"id":"development/contribute-to-docs","title":"Contribute to Druid docs","description":"\x3c!--","sidebar":"docs"},"development/experimental":{"id":"development/experimental","title":"Experimental features","description":"\x3c!--","sidebar":"docs"},"development/experimental-features":{"id":"development/experimental-features","title":"Experimental features","description":"\x3c!--"},"development/extensions-contrib/aliyun-oss":{"id":"development/extensions-contrib/aliyun-oss","title":"Aliyun OSS","description":"\x3c!--"},"development/extensions-contrib/ambari-metrics-emitter":{"id":"development/extensions-contrib/ambari-metrics-emitter","title":"Ambari Metrics Emitter","description":"\x3c!--"},"development/extensions-contrib/cassandra":{"id":"development/extensions-contrib/cassandra","title":"Apache Cassandra","description":"\x3c!--"},"development/extensions-contrib/cloudfiles":{"id":"development/extensions-contrib/cloudfiles","title":"Rackspace Cloud Files","description":"\x3c!--"},"development/extensions-contrib/compressed-big-decimal":{"id":"development/extensions-contrib/compressed-big-decimal","title":"Compressed Big Decimal","description":"\x3c!--"},"development/extensions-contrib/distinctcount":{"id":"development/extensions-contrib/distinctcount","title":"DistinctCount Aggregator","description":"\x3c!--"},"development/extensions-contrib/gce-extensions":{"id":"development/extensions-contrib/gce-extensions","title":"GCE Extensions","description":"\x3c!--"},"development/extensions-contrib/graphite":{"id":"development/extensions-contrib/graphite","title":"Graphite Emitter","description":"\x3c!--"},"development/extensions-contrib/iceberg":{"id":"development/extensions-contrib/iceberg","title":"Iceberg extension","description":"\x3c!--"},"development/extensions-contrib/influx":{"id":"development/extensions-contrib/influx","title":"InfluxDB Line Protocol Parser","description":"\x3c!--"},"development/extensions-contrib/influxdb-emitter":{"id":"development/extensions-contrib/influxdb-emitter","title":"InfluxDB Emitter","description":"\x3c!--"},"development/extensions-contrib/k8s-jobs":{"id":"development/extensions-contrib/k8s-jobs","title":"MM-less Druid in K8s","description":"\x3c!--"},"development/extensions-contrib/kafka-emitter":{"id":"development/extensions-contrib/kafka-emitter","title":"Kafka Emitter","description":"\x3c!--"},"development/extensions-contrib/materialized-view":{"id":"development/extensions-contrib/materialized-view","title":"Materialized View","description":"\x3c!--"},"development/extensions-contrib/momentsketch-quantiles":{"id":"development/extensions-contrib/momentsketch-quantiles","title":"Moment Sketches for Approximate Quantiles module","description":"\x3c!--"},"development/extensions-contrib/moving-average-query":{"id":"development/extensions-contrib/moving-average-query","title":"Moving Average Query","description":"\x3c!--"},"development/extensions-contrib/opentsdb-emitter":{"id":"development/extensions-contrib/opentsdb-emitter","title":"OpenTSDB Emitter","description":"\x3c!--"},"development/extensions-contrib/prometheus":{"id":"development/extensions-contrib/prometheus","title":"Prometheus Emitter","description":"\x3c!--"},"development/extensions-contrib/redis-cache":{"id":"development/extensions-contrib/redis-cache","title":"Druid Redis Cache","description":"\x3c!--"},"development/extensions-contrib/sqlserver":{"id":"development/extensions-contrib/sqlserver","title":"Microsoft SQLServer","description":"\x3c!--"},"development/extensions-contrib/statsd":{"id":"development/extensions-contrib/statsd","title":"StatsD Emitter","description":"\x3c!--"},"development/extensions-contrib/tdigestsketch-quantiles":{"id":"development/extensions-contrib/tdigestsketch-quantiles","title":"T-Digest Quantiles Sketch module","description":"\x3c!--"},"development/extensions-contrib/thrift":{"id":"development/extensions-contrib/thrift","title":"Thrift","description":"\x3c!--"},"development/extensions-contrib/time-min-max":{"id":"development/extensions-contrib/time-min-max","title":"Timestamp Min/Max aggregators","description":"\x3c!--"},"development/extensions-core/approximate-histograms":{"id":"development/extensions-core/approximate-histograms","title":"Approximate Histogram aggregators","description":"\x3c!--"},"development/extensions-core/avro":{"id":"development/extensions-core/avro","title":"Apache Avro","description":"\x3c!--"},"development/extensions-core/azure":{"id":"development/extensions-core/azure","title":"Microsoft Azure","description":"\x3c!--"},"development/extensions-core/bloom-filter":{"id":"development/extensions-core/bloom-filter","title":"Bloom Filter","description":"\x3c!--"},"development/extensions-core/datasketches-extension":{"id":"development/extensions-core/datasketches-extension","title":"DataSketches extension","description":"\x3c!--"},"development/extensions-core/datasketches-hll":{"id":"development/extensions-core/datasketches-hll","title":"DataSketches HLL Sketch module","description":"\x3c!--"},"development/extensions-core/datasketches-kll":{"id":"development/extensions-core/datasketches-kll","title":"DataSketches KLL Sketch module","description":"\x3c!--"},"development/extensions-core/datasketches-quantiles":{"id":"development/extensions-core/datasketches-quantiles","title":"DataSketches Quantiles Sketch module","description":"\x3c!--"},"development/extensions-core/datasketches-theta":{"id":"development/extensions-core/datasketches-theta","title":"DataSketches Theta Sketch module","description":"\x3c!--"},"development/extensions-core/datasketches-tuple":{"id":"development/extensions-core/datasketches-tuple","title":"DataSketches Tuple Sketch module","description":"\x3c!--"},"development/extensions-core/druid-aws-rds":{"id":"development/extensions-core/druid-aws-rds","title":"Druid AWS RDS Module","description":"\x3c!--"},"development/extensions-core/druid-basic-security":{"id":"development/extensions-core/druid-basic-security","title":"Basic Security","description":"\x3c!--"},"development/extensions-core/druid-kerberos":{"id":"development/extensions-core/druid-kerberos","title":"Kerberos","description":"\x3c!--"},"development/extensions-core/druid-lookups":{"id":"development/extensions-core/druid-lookups","title":"Cached Lookup Module","description":"\x3c!--"},"development/extensions-core/druid-pac4j":{"id":"development/extensions-core/druid-pac4j","title":"Druid pac4j based Security extension","description":"\x3c!--"},"development/extensions-core/druid-ranger-security":{"id":"development/extensions-core/druid-ranger-security","title":"Apache Ranger Security","description":"\x3c!--"},"development/extensions-core/examples":{"id":"development/extensions-core/examples","title":"Extension Examples","description":"\x3c!--"},"development/extensions-core/google":{"id":"development/extensions-core/google","title":"Google Cloud Storage","description":"\x3c!--"},"development/extensions-core/hdfs":{"id":"development/extensions-core/hdfs","title":"HDFS","description":"\x3c!--"},"development/extensions-core/kafka-extraction-namespace":{"id":"development/extensions-core/kafka-extraction-namespace","title":"Apache Kafka Lookups","description":"\x3c!--"},"development/extensions-core/kafka-ingestion":{"id":"development/extensions-core/kafka-ingestion","title":"Apache Kafka ingestion","description":"Overview of the Kafka indexing service for Druid. Includes example supervisor specs to help you get started.","sidebar":"docs"},"development/extensions-core/kafka-supervisor-operations":{"id":"development/extensions-core/kafka-supervisor-operations","title":"Apache Kafka supervisor operations reference","description":"Reference topic for running and maintaining Apache Kafka supervisors","sidebar":"docs"},"development/extensions-core/kafka-supervisor-reference":{"id":"development/extensions-core/kafka-supervisor-reference","title":"Apache Kafka supervisor reference","description":"Reference topic for Apache Kafka supervisors","sidebar":"docs"},"development/extensions-core/kinesis-ingestion":{"id":"development/extensions-core/kinesis-ingestion","title":"Amazon Kinesis ingestion","description":"\x3c!--","sidebar":"docs"},"development/extensions-core/kubernetes":{"id":"development/extensions-core/kubernetes","title":"Kubernetes","description":"\x3c!--"},"development/extensions-core/lookups-cached-global":{"id":"development/extensions-core/lookups-cached-global","title":"Globally Cached Lookups","description":"\x3c!--"},"development/extensions-core/mysql":{"id":"development/extensions-core/mysql","title":"MySQL Metadata Store","description":"\x3c!--"},"development/extensions-core/orc":{"id":"development/extensions-core/orc","title":"ORC Extension","description":"\x3c!--"},"development/extensions-core/parquet":{"id":"development/extensions-core/parquet","title":"Apache Parquet Extension","description":"\x3c!--"},"development/extensions-core/postgresql":{"id":"development/extensions-core/postgresql","title":"PostgreSQL Metadata Store","description":"\x3c!--"},"development/extensions-core/protobuf":{"id":"development/extensions-core/protobuf","title":"Protobuf","description":"\x3c!--"},"development/extensions-core/s3":{"id":"development/extensions-core/s3","title":"S3-compatible","description":"\x3c!--"},"development/extensions-core/simple-client-sslcontext":{"id":"development/extensions-core/simple-client-sslcontext","title":"Simple SSLContext Provider Module","description":"\x3c!--"},"development/extensions-core/stats":{"id":"development/extensions-core/stats","title":"Stats aggregator","description":"\x3c!--"},"development/extensions-core/test-stats":{"id":"development/extensions-core/test-stats","title":"Test Stats Aggregators","description":"\x3c!--"},"development/javascript":{"id":"development/javascript","title":"JavaScript programming guide","description":"\x3c!--","sidebar":"docs"},"development/modules":{"id":"development/modules","title":"Creating extensions","description":"\x3c!--","sidebar":"docs"},"development/overview":{"id":"development/overview","title":"Developing on Apache Druid","description":"\x3c!--","sidebar":"docs"},"development/versioning":{"id":"development/versioning","title":"Versioning","description":"\x3c!--","sidebar":"docs"},"ingestion/data-formats":{"id":"ingestion/data-formats","title":"Source input formats","description":"\x3c!--","sidebar":"docs"},"ingestion/faq":{"id":"ingestion/faq","title":"Ingestion troubleshooting FAQ","description":"\x3c!--","sidebar":"docs"},"ingestion/hadoop":{"id":"ingestion/hadoop","title":"Hadoop-based ingestion","description":"\x3c!--","sidebar":"docs"},"ingestion/index":{"id":"ingestion/index","title":"Ingestion overview","description":"\x3c!--","sidebar":"docs"},"ingestion/ingestion-spec":{"id":"ingestion/ingestion-spec","title":"Ingestion spec reference","description":"Reference for the configuration options in the ingestion spec.","sidebar":"docs"},"ingestion/input-sources":{"id":"ingestion/input-sources","title":"Input sources","description":"\x3c!--","sidebar":"docs"},"ingestion/native-batch":{"id":"ingestion/native-batch","title":"JSON-based batch","description":"\x3c!--","sidebar":"docs"},"ingestion/native-batch-firehose":{"id":"ingestion/native-batch-firehose","title":"JSON-based batch ingestion with firehose (Deprecated)","description":"\x3c!--"},"ingestion/native-batch-simple-task":{"id":"ingestion/native-batch-simple-task","title":"JSON-based batch simple task indexing","description":"\x3c!--"},"ingestion/partitioning":{"id":"ingestion/partitioning","title":"Partitioning","description":"Describes time chunk and secondary partitioning in Druid. Provides guidance to choose a secondary partition dimension.","sidebar":"docs"},"ingestion/rollup":{"id":"ingestion/rollup","title":"Data rollup","description":"Introduces rollup as a concept. Provides suggestions to maximize the benefits of rollup. Differentiates between perfect and best-effort rollup.","sidebar":"docs"},"ingestion/schema-design":{"id":"ingestion/schema-design","title":"Schema design tips","description":"\x3c!--","sidebar":"docs"},"ingestion/schema-model":{"id":"ingestion/schema-model","title":"Druid schema model","description":"Introduces concepts of datasources, primary timestamp, dimensions, and metrics.","sidebar":"docs"},"ingestion/standalone-realtime":{"id":"ingestion/standalone-realtime","title":"Realtime Process","description":"\x3c!--"},"ingestion/tasks":{"id":"ingestion/tasks","title":"Task reference","description":"\x3c!--","sidebar":"docs"},"ingestion/tranquility":{"id":"ingestion/tranquility","title":"Tranquility","description":"\x3c!--"},"misc/papers-and-talks":{"id":"misc/papers-and-talks","title":"Papers","description":"\x3c!--","sidebar":"docs"},"multi-stage-query/concepts":{"id":"multi-stage-query/concepts","title":"SQL-based ingestion concepts","description":"\x3c!--","sidebar":"docs"},"multi-stage-query/examples":{"id":"multi-stage-query/examples","title":"SQL-based ingestion query examples","description":"\x3c!--","sidebar":"docs"},"multi-stage-query/index":{"id":"multi-stage-query/index","title":"SQL-based ingestion","description":"Introduces multi-stage query architecture and its task engine","sidebar":"docs"},"multi-stage-query/known-issues":{"id":"multi-stage-query/known-issues","title":"SQL-based ingestion known issues","description":"\x3c!--","sidebar":"docs"},"multi-stage-query/reference":{"id":"multi-stage-query/reference","title":"SQL-based ingestion reference","description":"\x3c!--","sidebar":"docs"},"multi-stage-query/security":{"id":"multi-stage-query/security","title":"SQL-based ingestion security","description":"\x3c!--","sidebar":"docs"},"operations/alerts":{"id":"operations/alerts","title":"Alerts","description":"\x3c!--","sidebar":"docs"},"operations/auth":{"id":"operations/auth","title":"Authentication and Authorization","description":"\x3c!--"},"operations/auth-ldap":{"id":"operations/auth-ldap","title":"Configure LDAP authentication","description":"\x3c!--","sidebar":"docs"},"operations/basic-cluster-tuning":{"id":"operations/basic-cluster-tuning","title":"Basic cluster tuning","description":"\x3c!--","sidebar":"docs"},"operations/clean-metadata-store":{"id":"operations/clean-metadata-store","title":"Automated cleanup for metadata records","description":"Defines a strategy to maintain Druid metadata store performance by automatically removing leftover records for deleted entities: datasources, supervisors, rules, compaction configuration, audit records, etc. Most applicable to databases with \'high-churn\' datasources.","sidebar":"docs"},"operations/deep-storage-migration":{"id":"operations/deep-storage-migration","title":"Deep storage migration","description":"\x3c!--","sidebar":"docs"},"operations/dump-segment":{"id":"operations/dump-segment","title":"dump-segment tool","description":"\x3c!--","sidebar":"docs"},"operations/durable-storage":{"id":"operations/durable-storage","title":"Durable storage for the multi-stage query engine","description":"\x3c!--","sidebar":"docs"},"operations/dynamic-config-provider":{"id":"operations/dynamic-config-provider","title":"Dynamic Config Providers","description":"\x3c!--","sidebar":"docs"},"operations/export-metadata":{"id":"operations/export-metadata","title":"Export Metadata Tool","description":"\x3c!--","sidebar":"docs"},"operations/high-availability":{"id":"operations/high-availability","title":"High availability","description":"\x3c!--","sidebar":"docs"},"operations/http-compression":{"id":"operations/http-compression","title":"HTTP compression","description":"\x3c!--","sidebar":"docs"},"operations/insert-segment-to-db":{"id":"operations/insert-segment-to-db","title":"insert-segment-to-db tool","description":"\x3c!--","sidebar":"docs"},"operations/java":{"id":"operations/java","title":"Java runtime","description":"\x3c!--","sidebar":"docs"},"operations/kubernetes":{"id":"operations/kubernetes","title":"kubernetes","description":"\x3c!--"},"operations/metadata-migration":{"id":"operations/metadata-migration","title":"Metadata Migration","description":"\x3c!--","sidebar":"docs"},"operations/metrics":{"id":"operations/metrics","title":"Metrics","description":"\x3c!--","sidebar":"docs"},"operations/migrate-from-firehose":{"id":"operations/migrate-from-firehose","title":"Migrate from firehose to input source ingestion (legacy)","description":"\x3c!--","sidebar":"docs"},"operations/mixed-workloads":{"id":"operations/mixed-workloads","title":"Configure Druid for mixed workloads","description":"\x3c!--","sidebar":"docs"},"operations/other-hadoop":{"id":"operations/other-hadoop","title":"Working with different versions of Apache Hadoop","description":"\x3c!--","sidebar":"docs"},"operations/password-provider":{"id":"operations/password-provider","title":"Password providers","description":"\x3c!--","sidebar":"docs"},"operations/pull-deps":{"id":"operations/pull-deps","title":"pull-deps tool","description":"\x3c!--","sidebar":"docs"},"operations/request-logging":{"id":"operations/request-logging","title":"Request logging","description":"\x3c!--","sidebar":"docs"},"operations/reset-cluster":{"id":"operations/reset-cluster","title":"reset-cluster tool","description":"\x3c!--","sidebar":"docs"},"operations/rolling-updates":{"id":"operations/rolling-updates","title":"Rolling updates","description":"\x3c!--","sidebar":"docs"},"operations/rule-configuration":{"id":"operations/rule-configuration","title":"Using rules to drop and retain data","description":"\x3c!--","sidebar":"docs"},"operations/security-overview":{"id":"operations/security-overview","title":"Security overview","description":"Overiew of Apache Druid security. Includes best practices, configuration instructions, a description of the security model and documentation on how to report security issues.","sidebar":"docs"},"operations/security-user-auth":{"id":"operations/security-user-auth","title":"User authentication and authorization","description":"\x3c!--","sidebar":"docs"},"operations/segment-optimization":{"id":"operations/segment-optimization","title":"Segment size optimization","description":"\x3c!--","sidebar":"docs"},"operations/single-server":{"id":"operations/single-server","title":"Single server deployment","description":"\x3c!--","sidebar":"docs"},"operations/tls-support":{"id":"operations/tls-support","title":"TLS support","description":"\x3c!--","sidebar":"docs"},"operations/use_sbt_to_build_fat_jar":{"id":"operations/use_sbt_to_build_fat_jar","title":"Content for build.sbt","description":"\x3c!--","sidebar":"docs"},"operations/web-console":{"id":"operations/web-console","title":"Web console","description":"\x3c!--","sidebar":"docs"},"querying/aggregations":{"id":"querying/aggregations","title":"Aggregations","description":"\x3c!--","sidebar":"docs"},"querying/arrays":{"id":"querying/arrays","title":"Arrays","description":"\x3c!--","sidebar":"docs"},"querying/caching":{"id":"querying/caching","title":"Query caching","description":"Describes Apache Druid per-segment and whole-query cache types. Identifies services where you can enable caching and suggestions for caching strategy.","sidebar":"docs"},"querying/datasource":{"id":"querying/datasource","title":"Datasources","description":"\x3c!--","sidebar":"docs"},"querying/datasourcemetadataquery":{"id":"querying/datasourcemetadataquery","title":"DatasourceMetadata queries","description":"\x3c!--","sidebar":"docs"},"querying/dimensionspecs":{"id":"querying/dimensionspecs","title":"Query dimensions","description":"\x3c!--","sidebar":"docs"},"querying/filters":{"id":"querying/filters","title":"Query filters","description":"\x3c!--","sidebar":"docs"},"querying/geo":{"id":"querying/geo","title":"Spatial filters","description":"\x3c!--","sidebar":"docs"},"querying/granularities":{"id":"querying/granularities","title":"Query granularities","description":"\x3c!--","sidebar":"docs"},"querying/groupbyquery":{"id":"querying/groupbyquery","title":"GroupBy queries","description":"\x3c!--","sidebar":"docs"},"querying/having":{"id":"querying/having","title":"Having filters (groupBy)","description":"\x3c!--","sidebar":"docs"},"querying/hll-old":{"id":"querying/hll-old","title":"Cardinality/HyperUnique aggregators","description":"\x3c!--"},"querying/joins":{"id":"querying/joins","title":"Joins","description":"\x3c!--","sidebar":"docs"},"querying/limitspec":{"id":"querying/limitspec","title":"Sorting and limiting (groupBy)","description":"\x3c!--","sidebar":"docs"},"querying/lookups":{"id":"querying/lookups","title":"Lookups","description":"\x3c!--","sidebar":"docs"},"querying/math-expr":{"id":"querying/math-expr","title":"Expressions","description":"\x3c!--","sidebar":"docs"},"querying/multi-value-dimensions":{"id":"querying/multi-value-dimensions","title":"Multi-value dimensions","description":"\x3c!--","sidebar":"docs"},"querying/multitenancy":{"id":"querying/multitenancy","title":"Multitenancy considerations","description":"\x3c!--","sidebar":"docs"},"querying/nested-columns":{"id":"querying/nested-columns","title":"Nested columns","description":"\x3c!--","sidebar":"docs"},"querying/post-aggregations":{"id":"querying/post-aggregations","title":"Post-aggregations","description":"\x3c!--","sidebar":"docs"},"querying/query-context":{"id":"querying/query-context","title":"Query context","description":"\x3c!--","sidebar":"docs"},"querying/query-deep-storage":{"id":"querying/query-deep-storage","title":"Query from deep storage","description":"\x3c!--","sidebar":"docs"},"querying/query-execution":{"id":"querying/query-execution","title":"Query execution","description":"\x3c!--","sidebar":"docs"},"querying/querying":{"id":"querying/querying","title":"Native queries","description":"\x3c!--","sidebar":"docs"},"querying/scan-query":{"id":"querying/scan-query","title":"Scan queries","description":"\x3c!--","sidebar":"docs"},"querying/searchquery":{"id":"querying/searchquery","title":"Search queries","description":"\x3c!--","sidebar":"docs"},"querying/segmentmetadataquery":{"id":"querying/segmentmetadataquery","title":"SegmentMetadata queries","description":"\x3c!--","sidebar":"docs"},"querying/select-query":{"id":"querying/select-query","title":"Select queries","description":"\x3c!--"},"querying/sorting-orders":{"id":"querying/sorting-orders","title":"String comparators","description":"\x3c!--","sidebar":"docs"},"querying/sql":{"id":"querying/sql","title":"Druid SQL overview","description":"\x3c!--","sidebar":"docs"},"querying/sql-aggregations":{"id":"querying/sql-aggregations","title":"SQL aggregation functions","description":"\x3c!--","sidebar":"docs"},"querying/sql-array-functions":{"id":"querying/sql-array-functions","title":"SQL ARRAY functions","description":"\x3c!--","sidebar":"docs"},"querying/sql-data-types":{"id":"querying/sql-data-types","title":"SQL data types","description":"\x3c!--","sidebar":"docs"},"querying/sql-functions":{"id":"querying/sql-functions","title":"All Druid SQL functions","description":"\x3c!--","sidebar":"docs"},"querying/sql-json-functions":{"id":"querying/sql-json-functions","title":"SQL JSON functions","description":"\x3c!--","sidebar":"docs"},"querying/sql-metadata-tables":{"id":"querying/sql-metadata-tables","title":"SQL metadata tables","description":"\x3c!--","sidebar":"docs"},"querying/sql-multivalue-string-functions":{"id":"querying/sql-multivalue-string-functions","title":"SQL multi-value string functions","description":"\x3c!--","sidebar":"docs"},"querying/sql-operators":{"id":"querying/sql-operators","title":"Druid SQL Operators","description":"\x3c!--","sidebar":"docs"},"querying/sql-query-context":{"id":"querying/sql-query-context","title":"SQL query context","description":"\x3c!--","sidebar":"docs"},"querying/sql-scalar":{"id":"querying/sql-scalar","title":"SQL scalar functions","description":"\x3c!--","sidebar":"docs"},"querying/sql-translation":{"id":"querying/sql-translation","title":"SQL query translation","description":"\x3c!--","sidebar":"docs"},"querying/sql-window-functions":{"id":"querying/sql-window-functions","title":"Window functions","description":"\x3c!--","sidebar":"docs"},"querying/timeboundaryquery":{"id":"querying/timeboundaryquery","title":"TimeBoundary queries","description":"\x3c!--","sidebar":"docs"},"querying/timeseriesquery":{"id":"querying/timeseriesquery","title":"Timeseries queries","description":"\x3c!--","sidebar":"docs"},"querying/tips-good-queries":{"id":"querying/tips-good-queries","title":"Tips for writing good queries in Druid","description":"\x3c!--","sidebar":"docs"},"querying/topnmetricspec":{"id":"querying/topnmetricspec","title":"Sorting (topN)","description":"\x3c!--","sidebar":"docs"},"querying/topnquery":{"id":"querying/topnquery","title":"TopN queries","description":"\x3c!--","sidebar":"docs"},"querying/troubleshooting":{"id":"querying/troubleshooting","title":"Troubleshooting query execution in Druid","description":"\x3c!--","sidebar":"docs"},"querying/using-caching":{"id":"querying/using-caching","title":"Using query caching","description":"\x3c!--","sidebar":"docs"},"querying/virtual-columns":{"id":"querying/virtual-columns","title":"Virtual columns","description":"\x3c!--","sidebar":"docs"},"tutorials/cluster":{"id":"tutorials/cluster","title":"Clustered deployment","description":"\x3c!--","sidebar":"docs"},"tutorials/docker":{"id":"tutorials/docker","title":"Run with Docker","description":"\x3c!--","sidebar":"docs"},"tutorials/index":{"id":"tutorials/index","title":"Quickstart (local)","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-batch":{"id":"tutorials/tutorial-batch","title":"Load a file","description":"\x3c!--"},"tutorials/tutorial-batch-hadoop":{"id":"tutorials/tutorial-batch-hadoop","title":"Load batch data using Apache Hadoop","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-batch-native":{"id":"tutorials/tutorial-batch-native","title":"Load data with native batch ingestion","description":"\x3c!--"},"tutorials/tutorial-compaction":{"id":"tutorials/tutorial-compaction","title":"Compact segments","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-delete-data":{"id":"tutorials/tutorial-delete-data","title":"Tutorial: Deleting data","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-ingestion-spec":{"id":"tutorials/tutorial-ingestion-spec","title":"Write an ingestion spec","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-jdbc":{"id":"tutorials/tutorial-jdbc","title":"Use the JDBC driver to query Druid","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-jupyter-docker":{"id":"tutorials/tutorial-jupyter-docker","title":"Docker for Jupyter Notebook tutorials","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-jupyter-index":{"id":"tutorials/tutorial-jupyter-index","title":"Jupyter Notebook tutorials","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-kafka":{"id":"tutorials/tutorial-kafka","title":"Load streaming data from Apache Kafka","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-kerberos-hadoop":{"id":"tutorials/tutorial-kerberos-hadoop","title":"Configure Apache Druid to use Kerberized Apache Hadoop as deep storage","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-msq-convert-spec":{"id":"tutorials/tutorial-msq-convert-spec","title":"Convert an ingestion spec for SQL-based ingestion","description":"How to convert an ingestion spec to a query for SQL-based ingestion in the web console.","sidebar":"docs"},"tutorials/tutorial-msq-extern":{"id":"tutorials/tutorial-msq-extern","title":"Load files with SQL-based ingestion","description":"How to generate a query that references externally hosted data","sidebar":"docs"},"tutorials/tutorial-query":{"id":"tutorials/tutorial-query","title":"Query data","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-query-deep-storage":{"id":"tutorials/tutorial-query-deep-storage","title":"Tutorial: Query from deep storage","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-retention":{"id":"tutorials/tutorial-retention","title":"Configure data retention","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-rollup":{"id":"tutorials/tutorial-rollup","title":"Aggregate data with rollup","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-sketches-theta":{"id":"tutorials/tutorial-sketches-theta","title":"Approximations with Theta sketches","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-sql-query-view":{"id":"tutorials/tutorial-sql-query-view","title":"Get to know Query view","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-transform-spec":{"id":"tutorials/tutorial-transform-spec","title":"Transform input data","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-unnest-arrays":{"id":"tutorials/tutorial-unnest-arrays","title":"Unnest arrays within a column","description":"\x3c!--","sidebar":"docs"},"tutorials/tutorial-update-data":{"id":"tutorials/tutorial-update-data","title":"Update existing data","description":"\x3c!--","sidebar":"docs"}}}')}}]);