### Install Pinot Quickstart Batch

Source: https://docs.pinot.apache.org/build-with-pinot/connectors-clients-apis/client-libraries/golang.md

Follow this command to install and start Pinot locally for batch processing.

```bash
bin/quick-start-batch.sh
```

--------------------------------

### Build and Run Go Client Example

Source: https://docs.pinot.apache.org/build-with-pinot/connectors-clients-apis/client-libraries/golang.md

Build and execute the example application to query from the Pinot batch quickstart.

```bash
go build ./examples/batch-quickstart
./batch-quickstart
```

--------------------------------

### Start Pinot with Docker Quickstart

Source: https://docs.pinot.apache.org/build-with-pinot/connectors-clients-apis/bi-tools/metabase.md

Use the Pinot Docker image to run a quickstart instance. This command starts a multi-stage Pinot cluster.

```bash
docker run -d --name pinot-quickstart -p 9000:9000 -p 8000:8000 -p 8080:8080 apachepinot/pinot:latest  QuickStart -type MULTI_STAGE
```

--------------------------------

### Execute Pinot Quickstart Hybrid Example

Source: https://docs.pinot.apache.org/build-with-pinot/connectors-clients-apis/client-libraries/python.md

Run the Python script to query the running Pinot Hybrid Quickstart instance.

```bash
python3 examples/pinot-quickstart-hybrid.py
```

--------------------------------

### Run Hybrid Quick Start with Brew

Source: https://docs.pinot.apache.org/start-here/quick-start.md

For users who have installed Pinot via Homebrew, this command initiates the hybrid quick start example. It's a convenient way to test hybrid data processing on macOS.

```bash
pinot-admin QuickStart -type hybrid
```

--------------------------------

### Start Multi-Cluster Quick Start with Brew

Source: https://docs.pinot.apache.org/start-here/quick-start.md

For users who have installed Pinot via Homebrew, this command starts the multi-cluster quick start example, enabling tests for cross-cluster querying.

```bash
pinot-admin QuickStart -type MULTI_CLUSTER
```

--------------------------------

### Execute Pinot Quickstart Batch Example

Source: https://docs.pinot.apache.org/build-with-pinot/connectors-clients-apis/client-libraries/python.md

Run the provided Python script to interact with the running Pinot Batch Quickstart instance.

```bash
python3 examples/pinot-quickstart-batch.py
```

--------------------------------

### Run Pinot Materialized View Quickstart

Source: https://docs.pinot.apache.org/build-with-pinot/querying-and-sql/materialized-views.md

Use the bundled quickstart to set up a local example that creates an MV, runs the minion task, and validates queries.

```bash
bin/pinot-admin.sh QuickStart -type MATERIALIZED_VIEW
```

--------------------------------

### Start Pinot with Partial Upsert (Brew)

Source: https://docs.pinot.apache.org/start-here/quick-start.md

If you have Pinot installed via Homebrew, use this command to launch a QuickStart instance with partial upsert enabled. This is a convenient option for macOS users.

```bash
pinot-admin QuickStart -type PARTIAL_UPSERT
```

--------------------------------

### Run Null Handling Quick Start with Launcher Scripts

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Execute this command from the Pinot installation directory to start the null handling quick start using provided scripts.

```bash
./bin/pinot-admin.sh QuickStart -type NULL_HANDLING
```

--------------------------------

### Start Batch Multi-Directory Quick Start with Brew

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Use this command if you have Pinot installed via Homebrew to start the Quick Start with multi-directory tiered storage.

```bash
pinot-admin QuickStart -type BATCH_MULTIDIR
```

--------------------------------

### Start Pinot Hybrid Quickstart with Docker

Source: https://docs.pinot.apache.org/build-with-pinot/connectors-clients-apis/client-libraries/python.md

Run the Pinot Hybrid Quickstart using Docker, exposing the controller and broker ports.

```bash
docker run \
  --name pinot-quickstart \
  -p 2123:2123 \
  -p 9000:9000 \
  -p 8000:8000 \
  apachepinot/pinot:latest QuickStart -type hybrid
```

--------------------------------

### Run Upsert JSON Quick Start with Brew

Source: https://docs.pinot.apache.org/start-here/quick-start.md

If Pinot is installed via Homebrew, use this command to run the upsert JSON quick start example. It simplifies the setup process for macOS users.

```bash
pinot-admin QuickStart -type upsert_json_index
```

--------------------------------

### Run Logical Table Quick Start with Launcher Scripts

Source: https://docs.pinot.apache.org/architecture-and-concepts/components/table/logical-table.md

Executes the Pinot quick start example for logical tables using the provided launcher scripts. This is an alternative to Docker for running the quick start locally.

```bash
./bin/pinot-admin.sh QuickStart -type LOGICAL_TABLE
```

--------------------------------

### Start Lookup Join with Brew

Source: https://docs.pinot.apache.org/start-here/quick-start.md

If you have Pinot installed via Homebrew, use this command to start a cluster for the lookup join example.

```bash
pinot-admin QuickStart -type LOOKUP_JOIN
```

--------------------------------

### Run Logical Table Quick Start with Docker

Source: https://docs.pinot.apache.org/architecture-and-concepts/components/table/logical-table.md

Launches the Pinot quick start example specifically for logical tables using Docker. This command starts a Pinot instance and runs the quick start script configured for logical table functionality.

```bash
docker run \
    -p 9000:9000 \
    apachepinot/pinot:latest QuickStart \
    -type LOGICAL_TABLE
```

--------------------------------

### Start Pinot Batch Quickstart with Docker

Source: https://docs.pinot.apache.org/build-with-pinot/connectors-clients-apis/client-libraries/python.md

Run the Pinot Batch Quickstart using Docker. This command exposes the necessary ports for the controller and broker.

```bash
docker run \
  --name pinot-quickstart \
  -p 2123:2123 \
  -p 9000:9000 \
  -p 8000:8000 \
  apachepinot/pinot:latest QuickStart -type batch
```

--------------------------------

### Start Stream Processing with Complex Data Types (Brew)

Source: https://docs.pinot.apache.org/start-here/quick-start.md

If you installed Pinot via Homebrew, use this command to run the quick start for stream processing with complex data types. This is a convenient way to launch the example.

```bash
pinot-admin QuickStart -type stream_complex_type
```

--------------------------------

### Start GitHub Events Quick Start with Launcher Scripts

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Execute this command to start the GitHub Events demo using Pinot's provided launcher scripts. Ensure you are in the Pinot installation directory.

```bash
./bin/pinot-admin.sh QuickStart -type GITHUB_EVENTS
```

--------------------------------

### Run Pinot Join Example with Docker

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Use this command to start Pinot with a join example using Docker. This sets up Zookeeper, Controller, Broker, and Server in a single container.

```bash
docker run \
    -p 9000:9000 \
    apachepinot/pinot:latest QuickStart \
    -type join
```

--------------------------------

### Run Hybrid Quick Start with Launcher Scripts

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Use this command to run the hybrid stream and batch processing quick start example with Pinot's launcher scripts. This method is suitable for environments where Docker is not preferred.

```bash
./bin/pinot-admin.sh QuickStart -type hybrid
```

--------------------------------

### Run Upsert JSON Quick Start with Docker

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Use this command to start Pinot and run the upsert JSON quick start example using Docker. This sets up Kafka, Zookeeper, Pinot components, creates a table, launches a stream, and publishes data.

```bash
docker run \
    -p 9000:9000 \
    apachepinot/pinot:latest QuickStart \
    -type upsert_json_index
```

--------------------------------

### Start Pinot Quickstart Docker Container

Source: https://docs.pinot.apache.org/tutorials/getting-started/redash.md

Run this command in a new terminal to spin up an Apache Pinot Docker container in quick start mode with a baseball stats dataset.

```bash
docker run \
  --name pinot-quickstart \
  -p 2123:2123 \
  -p 9000:9000 \
  -p 8000:8000 \
  apachepinot/pinot:1.5.0 QuickStart -type batch
```

--------------------------------

### Run Hybrid Quick Start with Docker

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Start Pinot and run the hybrid stream and batch processing quick start example using Docker. This command initiates Kafka, Zookeeper, Pinot, creates a table, and sets up data ingestion pipelines.

```bash
docker run \
    -p 9000:9000 \
    apachepinot/pinot:latest QuickStart \
    -type hybrid
```

--------------------------------

### Run Null Handling Quick Start with Brew

Source: https://docs.pinot.apache.org/start-here/quick-start.md

If Pinot is installed via Homebrew, use this command to launch the null handling quick start.

```bash
pinot-admin QuickStart -type NULL_HANDLING
```

--------------------------------

### Start Lookup Join with Launcher Scripts

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Execute this command using Pinot's launcher scripts to start a cluster for the lookup join example.

```bash
./bin/pinot-admin.sh QuickStart -type LOOKUP_JOIN
```

--------------------------------

### Start Lookup Join with Docker

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Use this command to start a Pinot cluster with Docker for the lookup join example. Ensure port 9000 is available.

```bash
docker run \
    -p 9000:9000 \
    apachepinot/pinot:latest QuickStart \
    -type LOOKUP_JOIN
```

--------------------------------

### Run Pinot with Sorted Column Indexing (Brew)

Source: https://docs.pinot.apache.org/start-here/quick-start.md

This command, used with a Brew installation, starts a Pinot quick start to demonstrate sorted column indexing. It's a convenient way to test this feature.

```bash
pinot-admin QuickStart -type SORTED
```

--------------------------------

### Start Pinot with Realtime Minion Cleanup (Launcher Scripts)

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Run this command via launcher scripts to start Pinot with realtime minion cleanup enabled. This setup is for stream processing with continuous segment optimization.

```bash
./bin/pinot-admin.sh QuickStart -type realtime_minion
```

--------------------------------

### Start Pinot Cluster with Multi-Stage Query Engine (Launcher Scripts)

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Use these launcher scripts to start a Pinot cluster with the multi-stage query engine enabled. This setup includes pre-created tables and data ingestion jobs.

```bash
./bin/pinot-admin.sh QuickStart -type MULTI_STAGE
```

--------------------------------

### Start Pinot Cluster with Multi-Stage Query Engine (Brew)

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Use this Brew command to start a Pinot cluster with the multi-stage query engine enabled. This setup includes pre-created tables and data ingestion jobs.

```bash
pinot-admin QuickStart -type MULTI_STAGE
```

--------------------------------

### Run Pinot with Sorted Column Indexing (Docker)

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Start Pinot with Docker for a quick start demonstrating sorted column indexing. This setup includes creating a table with sorted column configuration and ingesting a generated dataset.

```bash
docker run \
    -p 9000:9000 \
    apachepinot/pinot:latest QuickStart \
    -type SORTED
```

--------------------------------

### Pinot Quickstart for Materialized Views

Source: https://docs.pinot.apache.org/build-with-pinot/querying-and-sql/materialized-views.md

The Pinot quickstart provides a local example to set up a base table, create an MV, run a minion task, and compare results between the base table and the MV. It's useful for validating direct MV queries and testing transparent rewrite behavior.

```APIDOC
## Try the bundled quickstart

Pinot ships a full local example that loads the base table, creates the MV table, runs the minion task, and compares base-table answers with MV-table re-aggregation:

```bash
bin/pinot-admin.sh QuickStart -type MATERIALIZED_VIEW
```

The quickstart creates `airlineStatsMv`, triggers `MaterializedViewTask`, and gives you a local setup for validating direct MV queries. After you enable the broker rewrite switch, it is also a convenient way to test transparent rewrite behavior.
```

--------------------------------

### Start Colocated Join with Brew

Source: https://docs.pinot.apache.org/start-here/quick-start.md

If you have Pinot installed via Homebrew, use this command to start a cluster for the colocated join example.

```bash
pinot-admin QuickStart -type COLOCATED_JOIN
```

--------------------------------

### Start Stream Processing with Upsert (Brew)

Source: https://docs.pinot.apache.org/start-here/quick-start.md

For users who installed Pinot using Homebrew, this command initiates the quick start for stream processing with upsert. It's a straightforward way to run the example.

```bash
pinot-admin QuickStart -type upsert
```

--------------------------------

### Example GET Request for /query_range

Source: https://docs.pinot.apache.org/build-with-pinot/querying-and-sql/time-series-queries.md

Demonstrates how to make a GET request to the /query_range endpoint using curl. Parameters like language, query, start, end, and step are passed as URL-encoded data.

```bash
curl -G 'http://localhost:8099/timeseries/api/v1/query_range' \
  --data-urlencode 'language=promql' \
  --data-urlencode 'query=sum(rate(myMetric[5m]))' \
  --data-urlencode 'start=1700000000' \
  --data-urlencode 'end=1700003600' \
  --data-urlencode 'step=60s'
```

--------------------------------

### RealtimeProvisioningHelper Command Example

Source: https://docs.pinot.apache.org/operate-pinot/tuning/realtime.md

This command demonstrates how to invoke the RealtimeProvisioningHelper with various parameters to analyze optimal configurations for a real-time table.

```bash
RealtimeProvisioningHelperCommand -tableConfigFile /Users/ssubrama/tmp/samza/realtimeTableConfig.json -numPartitions 16 -pushFrequency null -numHosts 8,6,10 -numHours 6,12,18,24 -sampleCompletedSegmentDir /Users/ssubrama/tmp/samza/TestSamzaAnalyticsFeatures_1593411480000_1593500340000_0/ -ingestionRate 100 -maxUsableHostMemory 10G -retentionHours 72
```

--------------------------------

### Example HTTP GET Request for Documentation Query

Source: https://docs.pinot.apache.org/tutorials/deep-storage/use-s3-and-pinot-in-docker.md

This snippet shows the format of an HTTP GET request to query documentation dynamically. Use the 'ask' parameter for your specific question and the optional 'goal' parameter to guide the AI's response.

```bash
GET https://docs.pinot.apache.org/tutorials/deep-storage/use-s3-and-pinot-in-docker.md?ask=<question>&goal=<endgoal>
```

--------------------------------

### Start Batch Multi-Directory Quick Start with Launcher Scripts

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Execute this command to launch the Pinot Quick Start with multi-directory tiered storage support using the provided launcher scripts.

```bash
./bin/pinot-admin.sh QuickStart -type BATCH_MULTIDIR
```

--------------------------------

### Run Pinot with Basic Authentication (Brew)

Source: https://docs.pinot.apache.org/start-here/quick-start.md

This command is used to start Pinot with basic authentication when installed via Brew. It simplifies the setup process for authenticated operations.

```bash
pinot-admin QuickStart -type AUTH
```

--------------------------------

### Query Pinot Batch Quickstart with Different SQL

Source: https://docs.pinot.apache.org/build-with-pinot/connectors-clients-apis/client-libraries/python.md

Demonstrates various SQL queries against the Pinot Batch Quickstart, including simple selects, aggregations with GROUP BY, and ordered results.

```text
Sending SQL to Pinot: SELECT * FROM baseballStats LIMIT 5
[0, 11, 0, 0, 0, 0, 0, 0, 0, 0, 'NL', 11, 11, 'aardsda01', 'David Allan', 1, 0, 0, 0, 0, 0, 0, 'CHN', 0, 2004]
[2, 45, 0, 0, 0, 0, 0, 0, 0, 0, 'NL', 45, 43, 'aardsda01', 'David Allan', 1, 0, 0, 0, 1, 0, 0, 'CHN', 0, 2006]
[0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'AL', 25, 2, 'aardsda01', 'David Allan', 1, 0, 0, 0, 0, 0, 0, 'CHA', 0, 2007]
[1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 'AL', 47, 5, 'aardsda01', 'David Allan', 1, 0, 0, 0, 0, 0, 1, 'BOS', 0, 2008]
[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'AL', 73, 3, 'aardsda01', 'David Allan', 1, 0, 0, 0, 0, 0, 0, 'SEA', 0, 2009]

Sending SQL to Pinot: SELECT playerName, sum(runs) FROM baseballStats WHERE yearID>=2000 GROUP BY playerName LIMIT 5
['Scott Michael', 26.0]
['Justin Morgan', 0.0]
['Jason Andre', 0.0]
['Jeffrey Ellis', 0.0]
['Maximiliano R.', 16.0]

Sending SQL to Pinot: SELECT playerName,sum(runs) AS sum_runs FROM baseballStats WHERE yearID>=2000 GROUP BY playerName ORDER BY sum_runs DESC LIMIT 5
['Adrian', 1820.0]
['Jose Antonio', 1692.0]
['Rafael', 1565.0]
['Brian Michael', 1500.0]
['Alexander Emmanuel', 1426.0]
```

--------------------------------

### Start Pinot Server with Configuration File

Source: https://docs.pinot.apache.org/reference/configuration-reference/server.md

Use this command to start a Pinot Server instance, specifying the path to its configuration file.

```bash
bin/pinot-admin.sh StartServer -configFileName /path/to/server.conf
```

--------------------------------

### Start Pinot with Geospatial Support (Brew)

Source: https://docs.pinot.apache.org/start-here/quick-start.md

For users with Pinot installed via Homebrew, this command launches a QuickStart environment with geospatial capabilities enabled. It simplifies testing geospatial features on macOS.

```bash
pinot-admin QuickStart -type GEOSPATIAL
```

--------------------------------

### Run Pinot Join Example with Launcher Scripts

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Execute the join example using Pinot's provided launcher scripts. Ensure you are in the Pinot directory.

```bash
./bin/pinot-admin.sh QuickStart -type join
```

--------------------------------

### Start Time Series Quick Start with Brew

Source: https://docs.pinot.apache.org/start-here/quick-start.md

If Pinot is installed via Homebrew, use this command to start the Quick Start for time series data.

```bash
pinot-admin QuickStart -type time_series
```

--------------------------------

### Install Azure CLI using Homebrew

Source: https://docs.pinot.apache.org/start-here/install/managed-kubernetes/azure.md

Installs the Azure Command-Line Interface. Alternatively, follow the official Azure CLI installation guide.

```bash
brew update && brew install azure-cli
```

--------------------------------

### Start GitHub Events Quick Start with Brew

Source: https://docs.pinot.apache.org/start-here/quick-start.md

If Pinot is installed via Homebrew, use this command to initiate the GitHub Events quick start.

```bash
pinot-admin QuickStart -type GITHUB_EVENTS
```

--------------------------------

### Start Batch Multi-Directory Quick Start with Docker

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Use this command to start the Pinot Quick Start with multi-directory tiered storage enabled using Docker. Ensure port 9000 is available.

```bash
docker run \
    -p 9000:9000 \
    apachepinot/pinot:latest QuickStart \
    -type BATCH_MULTIDIR
```

--------------------------------

### Run Pinot Join Example with Brew

Source: https://docs.pinot.apache.org/start-here/quick-start.md

If Pinot is installed via Homebrew, use this command to run the join example.

```bash
pinot-admin QuickStart -type join
```

--------------------------------

### Get Hour from UTC Timezone

Source: https://docs.pinot.apache.org/functions/datetime/timezonehour.md

This example shows how to get the hour offset for the Coordinated Universal Time (UTC) timezone.

```sql
SELECT timezoneHour('UTC') AS hour
FROM ignoreMe
```

--------------------------------

### Quick Start GitHub Events Stream Setup

Source: https://docs.pinot.apache.org/tutorials/getting-started/github-events-stream.md

A simplified command to set up the GitHub events stream, including all necessary steps. Requires a GitHub personal access token.

```bash
$ bin/pinot-admin.sh GitHubEventsQuickStart \
  -personalAccessToken <your_github_personal_access_token>
```

--------------------------------

### Start Broker with Configuration File

Source: https://docs.pinot.apache.org/build-with-pinot/querying-and-sql/multi-cluster-querying.md

Start the Pinot broker using a configuration file that includes multi-cluster settings.

```bash
bin/pinot-admin.sh StartBroker \
  -configFileName /path/to/broker.conf
```

--------------------------------

### Run Upsert JSON Quick Start with Launcher Scripts

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Execute this command to run the upsert JSON quick start example using Pinot's launcher scripts. This is an alternative to Docker for setting up the environment and data flow.

```bash
./bin/pinot-admin.sh QuickStart -type upsert_json_index
```

--------------------------------

### Run TPC-H Quick Start with Brew

Source: https://docs.pinot.apache.org/start-here/quick-start.md

If Pinot is installed via Homebrew, use this command to launch the TPC-H quick start.

```bash
pinot-admin QuickStart -type TPCH
```

--------------------------------

### Run Pinot Logical Table Example with Brew

Source: https://docs.pinot.apache.org/start-here/quick-start.md

If Pinot is installed via Homebrew, use this command to run the logical table example.

```bash
pinot-admin QuickStart -type LOGICAL_TABLE
```

--------------------------------

### Dynamic Documentation Query Example

Source: https://docs.pinot.apache.org/develop-and-contribute/plugin-architecture/write-custom-plugins.md

Example of how to query documentation dynamically using an HTTP GET request with 'ask' and optional 'goal' parameters.

```http
GET https://docs.pinot.apache.org/develop-and-contribute/plugin-architecture/write-custom-plugins.md?ask=<question>&goal=<endgoal>
```

--------------------------------

### Start Pinot Server Instance

Source: https://docs.pinot.apache.org/operate-pinot/deployment/cli.md

Use this command to start a Pinot server instance on a specified host. Ensure data directory, ZooKeeper address, cluster name, and configuration file path are correctly provided.

```bash
pinot-admin.sh StartServer -dataDir /path/to/data/dir -zkAddress localhost:2181 -clusterName PinotCluster -configFileName /path/to/server.conf
```

--------------------------------

### Start Metabase with Pinot Plugin

Source: https://docs.pinot.apache.org/build-with-pinot/connectors-clients-apis/bi-tools/metabase.md

Run Metabase with the downloaded Pinot plugin. Ensure you are in the /tmp/metabase directory.

```bash
cd /tmp/metabase
java --add-opens java.base/java.nio=ALL-UNNAMED -jar metabase.jar
```

--------------------------------

### Streaming Quick Start with Launcher Scripts

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Use these launcher scripts to set up a streaming data ingestion pipeline with Pinot. This includes starting Kafka, Zookeeper, and Pinot components, creating a table, and publishing data to a Kafka topic for consumption.

```bash
./bin/pinot-admin.sh QuickStart -type stream
```

--------------------------------

### Start Colocated Join with Launcher Scripts

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Execute this command using Pinot's launcher scripts to start a cluster for the colocated join example.

```bash
./bin/pinot-admin.sh QuickStart -type COLOCATED_JOIN
```

--------------------------------

### Start Minion Command Line Usage

Source: https://docs.pinot.apache.org/architecture-and-concepts/components/cluster/minion.md

This displays the available arguments for starting a Pinot minion using the command line. Ensure Zookeeper is set up before starting.

```bash
Usage: StartMinion
    -help                                                   : Print this message. (required=false)
    -minionHost               <String>                      : Host name for minion. (required=false)
    -minionPort               <int>                         : Port number to start the minion at. (required=false)
    -zkAddress                <http>                        : HTTP address of Zookeeper. (required=false)
    -clusterName              <String>                      : Pinot cluster name. (required=false)
    -configFileName           <Config File Name>            : Minion Starter Config file. (required=false)
```

--------------------------------

### Start Colocated Join with Docker

Source: https://docs.pinot.apache.org/start-here/quick-start.md

Use this command to start a Pinot cluster with Docker for the colocated join example. Ensure port 9000 is available.

```bash
docker run \
    -p 9000:9000 \
    apachepinot/pinot:latest QuickStart \
    -type COLOCATED_JOIN
```

--------------------------------

### Get Substring with Start and End Index - SQL

Source: https://docs.pinot.apache.org/functions/string/substr.md

Extracts a substring from the specified start index up to, but not including, the specified end index. Indices are zero-based.

```sql
select SUBSTR('Pinot', 0, 2) AS name
FROM ignoreMe
```

--------------------------------

### Bootstrap an example Pinot table

Source: https://docs.pinot.apache.org/build-with-pinot/connectors-clients-apis/query-engines/trino.md

Creates an example table in Pinot. Note: Before a specific PR, table names needed to be lowercase.

```bash
bin/pinot-admin.sh BootstrapTable -dir examples/batch/airlineStats
```

--------------------------------

### Querying Documentation via HTTP GET

Source: https://docs.pinot.apache.org/operate-pinot/segment-management/segment-reload.md

This example demonstrates how to query the documentation dynamically using an HTTP GET request with 'ask' and optional 'goal' parameters.

```http
GET https://docs.pinot.apache.org/operate-pinot/segment-management/segment-reload.md?ask=<question>&goal=<endgoal>
```

--------------------------------

### Start Pinot Controller with Configuration File

Source: https://docs.pinot.apache.org/reference/configuration-reference/controller.md

This command starts the Pinot Controller and specifies the path to its configuration file.

```bash
bin/pinot-admin.sh StartController -configFileName /path/to/controller.conf
```

--------------------------------

### ConfigurationException Example for Duplicate Keys

Source: https://docs.pinot.apache.org/reference/configuration-reference/server.md

This example shows the format of a ConfigurationException that is thrown when duplicate keys are found in the server configuration file, starting from Apache Pinot 1.3.0.

```text
ConfigurationException: Duplicate key found in /path/to/server.conf at line 10 and line 15: pinot.server.netty.port
```

--------------------------------

### StartServer Command Line Arguments

Source: https://docs.pinot.apache.org/architecture-and-concepts/components/cluster/server.md

Lists the available command-line arguments for starting a Pinot server. Use these to configure host, port, data directories, and Zookeeper connection.

```shell
Usage: StartServer
	-serverHost               <String>                      : Host name for controller. (required=false)
	-serverPort               <int>                         : Port number to start the server at. (required=false)
	-serverAdminPort          <int>                         : Port number to serve the server admin API at. (required=false)
	-dataDir                  <string>                      : Path to directory containing data. (required=false)
	-segmentDir               <string>                      : Path to directory containing segments. (required=false)
	-zkAddress                <http>                        : Http address of Zookeeper. (required=false)
	-clusterName              <String>                      : Pinot cluster name. (required=false)
	-configFileName           <Config File Name>            : Broker Starter Config file. (required=false)
	-help                                                   : Print this message. (required=false)
```