Apache Pinot Docs
Search…
latest
Introduction
Basics
Concepts
Architecture
Components
Getting Started
Import Data
Indexing
Releases
Recipes
For Users
Query
APIs
External Clients
Tutorials
For Developers
Basics
Advanced
Plugins
Design Documents
For Operators
Deployment and Monitoring
Command-Line Interface (CLI)
Configuration Recommendation Engine
Tutorials
Configuration Reference
Cluster
Controller
Broker
Server
Table
Schema
Ingestion Job Spec
Monitoring Metrics
Functions
RESOURCES
Community
Team
Blogs
Presentations
Videos
Integrations
Tableau
Trino
ThirdEye
Superset
Presto
Powered By GitBook
Cluster

Cluster Configs Definition

These are the properties that be set at the cluster level.
Property
Default
Description
allowParticipantAutoJoin
true
This is a Helix Property that allows any Pinot Server/Broker/Controller to automatically join the cluster. This is true by default. Operators can set this to false for more control. If you set this to false, you will have to explicitly invoke /Instance/addInstance API. This property is checked when a Pinot node starts and has no effect once the node is connected to the cluster.
enable.case.insensitive
false
By default, Pinot queries are case sensitive. Table name, column name, etc must be case sensitive. This is because the schema is still optional for batch tables. If you have a schema, you can set this to true and pinot will accept any case for table names and columns. This property is applicable to the broker and is read only when the broker starts. Changing this property will required broker to be restarted.
pinot.broker.enable.query.limit.override
false
This allows operators to protect the Pinot cluster against bad queries with large limits. By setting this to true, if Pinot broker override query limit when it is larger than broker config:pinot.broker.query.response.limit (Default is 2147483647).E.g. If setpinot.broker.query.response.limit=1000 in Broker conf, then querySELECT * FROM myTable LIMIT 25000will be override to SELECT * FROM myTable LIMIT 1000.
default.hyperloglog.log2m
8
This is a special config to override for hyperloglog that is used for approximate distinct count. Default value is 8.
queryConsoleOnlyView
false
Only show query console for controller web UI, this is useful when you don't want to expose cluster or ZK UI to Users.

Cluster Configs APIs

get
http://<controller>:<port>/cluster/configs
List All Cluster Configs
post
http://<controller>:<port>/cluster/configs
Update Cluster Configs
Example:
Previous
Performance Optimization Configurations
Next - Configuration Reference
Controller
Last modified 30d ago
Copy link
Outline
Cluster Configs Definition
Cluster Configs APIs
get
List All Cluster Configs
post
Update Cluster Configs