# StarTree Docs ## Home - [index](https://docs.startree.ai/index.md) - [StarTree Cloud (191 pages)](https://docs.startree.ai/_llms/star-tree-cloud.md): Documentation for StarTree Cloud. ## Integrations ### Integrations - [Integrations](https://docs.startree.ai/integrations/home.md): Connect StarTree to your streaming and batch sources, lakehouse catalogs, language clients, and BI tools — every integration in one place. - [Streaming Sources](https://docs.startree.ai/integrations/streaming.md): Real-time sources that feed native Pinot tables. - [Batch Sources](https://docs.startree.ai/integrations/batch.md): Batch sources copied into Pinot segments. - [External Tables](https://docs.startree.ai/integrations/external-tables.md): Iceberg catalogs and raw Parquet queried in place. - [Message Formats & Decoders](https://docs.startree.ai/integrations/formats.md): Payload formats on the streaming ingestion path. - [Language Clients & APIs](https://docs.startree.ai/integrations/clients.md): Query StarTree Cloud from your application. - [Visualization & BI](https://docs.startree.ai/integrations/visualization.md): Connect BI tools to StarTree Cloud. - [Export](https://docs.startree.ai/integrations/export.md): Write Pinot data back to your lake. ## Powered by AI ### Capabilities - [Overview](https://docs.startree.ai/corecapabilities/ai/overview.md) #### MCP Server - [Overview](https://docs.startree.ai/corecapabilities/ai/mcp/overview.md) - [Installation](https://docs.startree.ai/corecapabilities/ai/mcp/installation.md) - [Claude Desktop](https://docs.startree.ai/corecapabilities/ai/mcp/claude.md) - [Librechat](https://docs.startree.ai/corecapabilities/ai/mcp/librechat.md) - [Cursor IDE](https://docs.startree.ai/corecapabilities/ai/mcp/cursor.md) #### AI Query Analyzer - [Query Analyzer](https://docs.startree.ai/corecapabilities/ai/query-analyzer/overview.md) - [How to Use Query Analyzer](https://docs.startree.ai/corecapabilities/ai/query-analyzer/usage.md) - [Query Analyzer API Reference](https://docs.startree.ai/corecapabilities/ai/query-analyzer/api-reference.md): REST API reference for the Query Analyzer static and runtime analysis endpoints. - [Understanding Recommendations](https://docs.startree.ai/corecapabilities/ai/query-analyzer/reading-results.md) - [Security and Compliance](https://docs.startree.ai/corecapabilities/ai/query-analyzer/security-and-compliance.md): Security controls, data privacy, and compliance posture for Query Analyzer in StarTree Cloud. ##### Proactive Analyzer - [Proactive Analyzer](https://docs.startree.ai/corecapabilities/ai/query-analyzer/proactive-analyzer/overview.md): A scheduled job that finds your most expensive queries from real traffic and analyzes them automatically — no query submission required. - [Proactive Analyzer Configuration and Limitations](https://docs.startree.ai/corecapabilities/ai/query-analyzer/proactive-analyzer/configuration.md): Configuration keys, the API endpoints, and current known limitations for Proactive Analyzer. ## ThirdEye ### Get Started - [Getting Started with ThirdEye](https://docs.startree.ai/thirdeye/getting-started/free-tier-tutorial.md) #### Installation - [StarTree ThirdEye Use Case Planning Template](https://docs.startree.ai/thirdeye/getting-started/use-case-template.md) - [StarTree ThirdEye Getting Started Checklist](https://docs.startree.ai/thirdeye/getting-started/getting-started-checklist.md) - [Install ThirdEye](https://docs.startree.ai/thirdeye/getting-started/install-thirdeye.md) - [ThirdEye Infrastructure Requirements](https://docs.startree.ai/thirdeye/getting-started/infrastructure-requirements.md) - [ThirdEye Data Requirements](https://docs.startree.ai/thirdeye/getting-started/data-requirements.md) - [Create your First Alert](https://docs.startree.ai/thirdeye/getting-started/create-your-first-alert.md) - [Alert Configuration Examples](https://docs.startree.ai/thirdeye/getting-started/alert-create-examples.md) ### Notifications #### Concepts - [Anomaly Detection Algorithms](https://docs.startree.ai/thirdeye/concepts-data-alerts-notifications/concepts-anomaly-detection-algorithms.md) - [Top contributor algorithm](https://docs.startree.ai/thirdeye/concepts-data-alerts-notifications/concepts-top-contributor-algorithm.md) - [Anomaly Merger Rules](https://docs.startree.ai/thirdeye/concepts-data-alerts-notifications/concepts-anomaly-merger-rules.md) - [Mutable Data](https://docs.startree.ai/thirdeye/concepts-data-alerts-notifications/concepts-mutable-data.md) - [Heatmaps](https://docs.startree.ai/thirdeye/concepts-data-alerts-notifications/concepts-heatmaps.md) ### Architecture - [ThirdEye Architecture](https://docs.startree.ai/thirdeye/concepts-thirdeye-components/concepts-thirdeye-architecture.md) - [ThirdEye Entities](https://docs.startree.ai/thirdeye/concepts-thirdeye-components/concepts-thirdeye-entities.md) - [ThirdEye Worker Management](https://docs.startree.ai/thirdeye/concepts-thirdeye-components/concepts-thirdeye-worker-management.md) ### Operators - [Overview](https://docs.startree.ai/thirdeye/operators.md) - [DataFetcher](https://docs.startree.ai/thirdeye/operators/data-fetcher.md) - [Dimension Exploration](https://docs.startree.ai/thirdeye/operators/dimension-exploration.md) - [EventFetcher](https://docs.startree.ai/thirdeye/operators/event-fetcher.md) - [SqlExecution](https://docs.startree.ai/thirdeye/operators/sql-operator.md) - [TimeIndexFiller](https://docs.startree.ai/thirdeye/operators/time-index-filler.md) #### AnomalyDetector - [AnomalyDetector](https://docs.startree.ai/thirdeye/operators/anomaly-detector.md) - [ABSOLUTE_CHANGE](https://docs.startree.ai/thirdeye/operators/anomaly-detector/absolute.md) - [ETS](https://docs.startree.ai/thirdeye/operators/anomaly-detector/ets.md) - [REMOTE_HTTP](https://docs.startree.ai/thirdeye/operators/anomaly-detector/http.md) - [MATRIX_PROFILE](https://docs.startree.ai/thirdeye/operators/anomaly-detector/matrix_profile.md) - [MEAN_VARIANCE](https://docs.startree.ai/thirdeye/operators/anomaly-detector/mean_variance.md) - [OFFSET_AGGREGATION](https://docs.startree.ai/thirdeye/operators/anomaly-detector/offset_aggregation.md) - [PERCENTAGE_CHANGE](https://docs.startree.ai/thirdeye/operators/anomaly-detector/percentage.md) - [THRESHOLD](https://docs.startree.ai/thirdeye/operators/anomaly-detector/threshold.md) #### Dimension Drift - [Dimension Drift Operators](https://docs.startree.ai/thirdeye/operators/dimension-drift.md) - [Static Drift Operator](https://docs.startree.ai/thirdeye/operators/dimension-drift/static-drift-operator.md) - [Lookback Drift Operator](https://docs.startree.ai/thirdeye/operators/dimension-drift/lookback-drift-operator.md) #### PostProcessor - [PostProcessor](https://docs.startree.ai/thirdeye/operators/post-processor.md) - [ANOMALY_MERGER](https://docs.startree.ai/thirdeye/operators/post-processor/anomaly_merger.md) - [COLD_START](https://docs.startree.ai/thirdeye/operators/post-processor/cold_start.md) - [DETECTOR](https://docs.startree.ai/thirdeye/operators/post-processor/detector.md) - [EVENTS](https://docs.startree.ai/thirdeye/operators/post-processor/events.md) - [IMPACT](https://docs.startree.ai/thirdeye/operators/post-processor/impact.md) - [THRESHOLD](https://docs.startree.ai/thirdeye/operators/post-processor/threshold.md) - [TIME_OF_WEEK](https://docs.startree.ai/thirdeye/operators/post-processor/time_of_week.md) ### How-To Guides - [Use Pre-Computed Time Columns](https://docs.startree.ai/thirdeye/how-tos/optimize/optimize_queries_with_precomputed_timebuckets.md) - [Subscription Groups and Notification Systems](https://docs.startree.ai/thirdeye/how-tos/add_notification.md) - [Use Anomaly Filters to Tune Alerts](https://docs.startree.ai/thirdeye/how-tos/alert-tuning.md) - [How to perform root cause analysis](https://docs.startree.ai/thirdeye/how-tos/perform-root-cause-analysis.md) - [Manage Holiday Effects with StarTree ETS](https://docs.startree.ai/thirdeye/how-tos/manage-holiday-effect.md) - [How to use the ThirdEye API](https://docs.startree.ai/thirdeye/how-tos/use-the-api.md) #### Add a Datasource - [Connect a Data Source](https://docs.startree.ai/thirdeye/how-tos/database.md) - [Managed Pinot as a ThirdEye Datasource](https://docs.startree.ai/thirdeye/how-tos/database/startree-pinot.md) - [Pinot SQL as a ThirdEye Datasource](https://docs.startree.ai/thirdeye/how-tos/database/pinot-sql.md) - [Pinot as a ThirdEye Datasource](https://docs.startree.ai/thirdeye/how-tos/database/pinot.md) #### Create Alerts - [How to Use the Alert Creation UI](https://docs.startree.ai/thirdeye/how-tos/alert/how-to-use-alert-creation-ui.md) - [Alert Templates](https://docs.startree.ai/thirdeye/how-tos/alert/use-templates.md) - [Multiple Inputs Alerts](https://docs.startree.ai/thirdeye/how-tos/alert/multiple-inputs-alerts.md) - [Manage Missing Data](https://docs.startree.ai/thirdeye/how-tos/alert/manage-missing-data.md) - [Derived Metric Alerts](https://docs.startree.ai/thirdeye/how-tos/alert/derived-metric-alert.md) #### ThirdEye Recipes - [Monitoring Ad Campaign Performance](https://docs.startree.ai/thirdeye/how-tos/thirdeye_recipes/ad_campaign_performance_monitoring.md) - [Monitoring Consumer Product User Experience KPIs](https://docs.startree.ai/thirdeye/how-tos/thirdeye_recipes/consumer_product_user_experience.md) - [Monitoring Store Sales KPI for an eCommerce Retail Store](https://docs.startree.ai/thirdeye/how-tos/thirdeye_recipes/eCommerce_store_sales.md) - [Using Role-Based Access Control with ThirdEye](https://docs.startree.ai/thirdeye/how-tos/thirdeye_recipes/rbac-recipe.md) - [Monitoring Rideshare Booking Metrics for Customer Satisfaction](https://docs.startree.ai/thirdeye/how-tos/thirdeye_recipes/rideshare_recipe.md) ### Templates #### StarTree Templates - [startree-absolute-rule](https://docs.startree.ai/thirdeye/templates/startree-absolute-rule.md) - [startree-absolute-rule-dx](https://docs.startree.ai/thirdeye/templates/startree-absolute-rule-dx.md) - [startree-absolute-rule-percentile-dx](https://docs.startree.ai/thirdeye/templates/startree-absolute-rule-percentile-dx.md) - [startree-absolute-rule-percentile-query-dx](https://docs.startree.ai/thirdeye/templates/startree-absolute-rule-percentile-query-dx.md) - [startree-absolute-rule-query-dx](https://docs.startree.ai/thirdeye/templates/startree-absolute-rule-query-dx.md) - [startree-drift-continuous](https://docs.startree.ai/thirdeye/templates/startree-drift-continuous.md) - [startree-drift-continuous-dx](https://docs.startree.ai/thirdeye/templates/startree-drift-continuous-dx.md) - [startree-drift-continuous-query-dx](https://docs.startree.ai/thirdeye/templates/startree-drift-continuous-query-dx.md) - [startree-drift-discrete](https://docs.startree.ai/thirdeye/templates/startree-drift-discrete.md) - [startree-drift-discrete-dx](https://docs.startree.ai/thirdeye/templates/startree-drift-discrete-dx.md) - [startree-drift-discrete-query-dx](https://docs.startree.ai/thirdeye/templates/startree-drift-discrete-query-dx.md) - [startree-ets](https://docs.startree.ai/thirdeye/templates/startree-ets.md) - [startree-ets-dx](https://docs.startree.ai/thirdeye/templates/startree-ets-dx.md) - [startree-ets-percentile](https://docs.startree.ai/thirdeye/templates/startree-ets-percentile.md) - [startree-ets-percentile-dx](https://docs.startree.ai/thirdeye/templates/startree-ets-percentile-dx.md) - [startree-ets-percentile-query-dx](https://docs.startree.ai/thirdeye/templates/startree-ets-percentile-query-dx.md) - [startree-ets-query-dx](https://docs.startree.ai/thirdeye/templates/startree-ets-query-dx.md) - [startree-ets-ratio](https://docs.startree.ai/thirdeye/templates/startree-ets-ratio.md) - [startree-ets-ratio-dx](https://docs.startree.ai/thirdeye/templates/startree-ets-ratio-dx.md) - [startree-ets-ratio-percentile](https://docs.startree.ai/thirdeye/templates/startree-ets-ratio-percentile.md) - [startree-ets-ratio-percentile-dx](https://docs.startree.ai/thirdeye/templates/startree-ets-ratio-percentile-dx.md) - [startree-ets-ratio-percentile-query-dx](https://docs.startree.ai/thirdeye/templates/startree-ets-ratio-percentile-query-dx.md) - [startree-ets-ratio-query-dx](https://docs.startree.ai/thirdeye/templates/startree-ets-ratio-query-dx.md) - [startree-experimental-mean-variance-with-mask](https://docs.startree.ai/thirdeye/templates/startree-experimental-mean-variance-with-mask.md) - [startree-experimental-mean-variance-with-mask-dx](https://docs.startree.ai/thirdeye/templates/startree-experimental-mean-variance-with-mask-dx.md) - [startree-experimental-mean-variance-with-mask-percentile](https://docs.startree.ai/thirdeye/templates/startree-experimental-mean-variance-with-mask-percentile.md) - [startree-experimental-mean-variance-with-mask-percentile-dx](https://docs.startree.ai/thirdeye/templates/startree-experimental-mean-variance-with-mask-percentile-dx.md) - [startree-experimental-mean-variance-with-mask-percentile-query-dx](https://docs.startree.ai/thirdeye/templates/startree-experimental-mean-variance-with-mask-percentile-query-dx.md) - [startree-experimental-mean-variance-with-mask-query-dx](https://docs.startree.ai/thirdeye/templates/startree-experimental-mean-variance-with-mask-query-dx.md) - [startree-matrix-profile](https://docs.startree.ai/thirdeye/templates/startree-matrix-profile.md) - [startree-matrix-profile-dx](https://docs.startree.ai/thirdeye/templates/startree-matrix-profile-dx.md) - [startree-matrix-profile-percentile](https://docs.startree.ai/thirdeye/templates/startree-matrix-profile-percentile.md) - [startree-matrix-profile-percentile-dx](https://docs.startree.ai/thirdeye/templates/startree-matrix-profile-percentile-dx.md) - [startree-matrix-profile-percentile-query-dx](https://docs.startree.ai/thirdeye/templates/startree-matrix-profile-percentile-query-dx.md) - [startree-matrix-profile-query-dx](https://docs.startree.ai/thirdeye/templates/startree-matrix-profile-query-dx.md) - [startree-mean-variance](https://docs.startree.ai/thirdeye/templates/startree-mean-variance.md) - [startree-mean-variance-dx](https://docs.startree.ai/thirdeye/templates/startree-mean-variance-dx.md) - [startree-mean-variance-percentile](https://docs.startree.ai/thirdeye/templates/startree-mean-variance-percentile.md) - [startree-mean-variance-percentile-dx](https://docs.startree.ai/thirdeye/templates/startree-mean-variance-percentile-dx.md) - [startree-mean-variance-percentile-query-dx](https://docs.startree.ai/thirdeye/templates/startree-mean-variance-percentile-query-dx.md) - [startree-mean-variance-query-dx](https://docs.startree.ai/thirdeye/templates/startree-mean-variance-query-dx.md) - [startree-mstl](https://docs.startree.ai/thirdeye/templates/startree-mstl.md) - [startree-mstl-dx](https://docs.startree.ai/thirdeye/templates/startree-mstl-dx.md) - [startree-mstl-percentile](https://docs.startree.ai/thirdeye/templates/startree-mstl-percentile.md) - [startree-mstl-percentile-dx](https://docs.startree.ai/thirdeye/templates/startree-mstl-percentile-dx.md) - [startree-mstl-percentile-query-dx](https://docs.startree.ai/thirdeye/templates/startree-mstl-percentile-query-dx.md) - [startree-mstl-query-dx](https://docs.startree.ai/thirdeye/templates/startree-mstl-query-dx.md) - [startree-offset-aggregation](https://docs.startree.ai/thirdeye/templates/startree-offset-aggregation.md) - [startree-offset-aggregation-dx](https://docs.startree.ai/thirdeye/templates/startree-offset-aggregation-dx.md) - [startree-offset-aggregation-percentile](https://docs.startree.ai/thirdeye/templates/startree-offset-aggregation-percentile.md) - [startree-offset-aggregation-percentile-dx](https://docs.startree.ai/thirdeye/templates/startree-offset-aggregation-percentile-dx.md) - [startree-offset-aggregation-percentile-query-dx](https://docs.startree.ai/thirdeye/templates/startree-offset-aggregation-percentile-query-dx.md) - [startree-offset-aggregation-query-dx](https://docs.startree.ai/thirdeye/templates/startree-offset-aggregation-query-dx.md) - [startree-percentage-rule](https://docs.startree.ai/thirdeye/templates/startree-percentage-rule.md) - [startree-percentage-rule-dx](https://docs.startree.ai/thirdeye/templates/startree-percentage-rule-dx.md) - [startree-percentage-rule-percentile](https://docs.startree.ai/thirdeye/templates/startree-percentage-rule-percentile.md) - [startree-percentage-rule-percentile-dx](https://docs.startree.ai/thirdeye/templates/startree-percentage-rule-percentile-dx.md) - [startree-percentage-rule-percentile-query-dx](https://docs.startree.ai/thirdeye/templates/startree-percentage-rule-percentile-query-dx.md) - [startree-percentage-rule-query-dx](https://docs.startree.ai/thirdeye/templates/startree-percentage-rule-query-dx.md) - [startree-remote-http](https://docs.startree.ai/thirdeye/templates/startree-remote-http.md) - [startree-remote-http-dx](https://docs.startree.ai/thirdeye/templates/startree-remote-http-dx.md) - [startree-remote-http-percentile](https://docs.startree.ai/thirdeye/templates/startree-remote-http-percentile.md) - [startree-remote-http-percentile-dx](https://docs.startree.ai/thirdeye/templates/startree-remote-http-percentile-dx.md) - [startree-remote-http-percentile-query-dx](https://docs.startree.ai/thirdeye/templates/startree-remote-http-percentile-query-dx.md) - [startree-remote-http-query-dx](https://docs.startree.ai/thirdeye/templates/startree-remote-http-query-dx.md) - [startree-threshold](https://docs.startree.ai/thirdeye/templates/startree-threshold.md) - [startree-threshold-dx](https://docs.startree.ai/thirdeye/templates/startree-threshold-dx.md) - [startree-threshold-percentile](https://docs.startree.ai/thirdeye/templates/startree-threshold-percentile.md) - [startree-threshold-percentile-dx](https://docs.startree.ai/thirdeye/templates/startree-threshold-percentile-dx.md) - [startree-threshold-percentile-query-dx](https://docs.startree.ai/thirdeye/templates/startree-threshold-percentile-query-dx.md) - [startree-threshold-query-dx](https://docs.startree.ai/thirdeye/templates/startree-threshold-query-dx.md) ### Other Operations - [Access Control in ThirdEye](https://docs.startree.ai/thirdeye/access-control-in-thirdeye.md) - [Frequently Asked Questions](https://docs.startree.ai/thirdeye/troubleshooting/faq.md) - [ThirdEye Observability and Monitoring](https://docs.startree.ai/thirdeye/troubleshooting/thirdeye-observability-and-monitoring.md) - [Alert Configuration and Execution](https://docs.startree.ai/thirdeye/alert-configuration.md) - [Dimension exploration](https://docs.startree.ai/thirdeye/dimension-exploration.md) - [Scaling Workers](https://docs.startree.ai/thirdeye/worker-scaling.md) - [ThirdEye Dimensions Recommender](https://docs.startree.ai/thirdeye/cohort-recommender.md) - [Aggregation Functions](https://docs.startree.ai/thirdeye/rca-aggregation-functions.md) - [Resources](https://docs.startree.ai/thirdeye/resources/presentations.md) ## Apache Pinot Recipes ### Recipes - [Download Recipes](https://docs.startree.ai/recipes/recipes.md) - [Clickstream Analytics Dashboard with StarTree Cloud Free Tier and Streamlit](https://docs.startree.ai/recipes/real-time-clickstream-dashboard-guide.md) #### Batch Ingestion - [Importing CSV files with columns containing spaces](https://docs.startree.ai/recipes/csv-files-spaces-column-names.md) - [Import data files from different directories](https://docs.startree.ai/recipes/import-data-files-different-directories.md) - [Ingest CSV files from a S3 bucket](https://docs.startree.ai/recipes/ingest-csv-files-from-s3.md): In this recipe, we will learn how Apache Pinot can be configured to ingest CSV files from an AWS S3 bucket. - [Ingesting JSON files](https://docs.startree.ai/recipes/ingest-json-files.md) - [Ingest Parquet files from an S3 Bucket into Pinot Using Spark](https://docs.startree.ai/recipes/ingest-parquet-files-from-s3-using-spark.md) - [Backfill offline segment](https://docs.startree.ai/recipes/backfill.md): In this Apache Pinot recipe we'll learn how to backfill a segment moved from a real-time to offline table using the real-time to offline job. #### Streaming Ingestion - [Ingesting JSON files from Kafka](https://docs.startree.ai/recipes/ingest-json-files-kafka.md): In this recipe, we'll learn how to ingest JSON documents from Apache Kafka into Apache Pinot. - [Connecting to Kafka with SASL Authentication](https://docs.startree.ai/recipes/kafka-sasl.md): In this guide we'll learn how to configure Apache Pinot to work with Kafka using SASL authentication. - [Connecting to Kafka with SSL and SASL Authentication](https://docs.startree.ai/recipes/kafka-ssl-sasl.md) - [Ingest GitHub API Events using Kinesis](https://docs.startree.ai/recipes/github-events-stream-kinesis.md) - [Ingest from Apache Pulsar](https://docs.startree.ai/recipes/pulsar.md): In this Apache Pinot Recipe, we'll learn how to ingest data from Apache Pulsar. - [Configuring the Segment Threshold](https://docs.startree.ai/recipes/configuring-segment-threshold.md): In this guide we'll learn how to configure the segment threshold for flushing data in Apache Pinot real-time tables. - [Ingesting Avro Messages](https://docs.startree.ai/recipes/ingest-avro.md) - [Ingest CDC Data using PostgreSQL, Kafka, and Debezium](https://docs.startree.ai/recipes/debezium-cdc.md) - [Replicating DynamoDB to Apache Pinot](https://docs.startree.ai/recipes/dynamodb-pinot-cdc.md) - [How to pause and resume ingestion of a stream](https://docs.startree.ai/recipes/pause-resume-consumption.md) #### Transformation Functions - [Groovy Transformation Functions](https://docs.startree.ai/recipes/groovy-transformation-functions.md) - [JSON Transformation Functions](https://docs.startree.ai/recipes/json-transformation-functions.md) - [Chaining Transformation Functions](https://docs.startree.ai/recipes/chaining-transformation-functions.md) - [Filtering records during ingestion](https://docs.startree.ai/recipes/filtering-ingestion.md) - [Converting DateTime Strings to Timestamps](https://docs.startree.ai/recipes/datetime-string-to-timestamp.md) - [How to Combine Source Fields into one Column](https://docs.startree.ai/recipes/combine-fields.md) #### Deep Storage - [Using MinIO as Deep Store for an Offline Table](https://docs.startree.ai/recipes/minio-deep-store.md) - [How to use Google Cloud Storage as a Deep Store](https://docs.startree.ai/recipes/google-cloud-storage-deep-store.md) #### Upserts - [Full Upserts in Pinot](https://docs.startree.ai/recipes/upserts-full.md) - [Partial Upserts in Pinot](https://docs.startree.ai/recipes/upserts-partial.md) #### Real-Time-Offline Job - [How to manually schedule real-time to offline job](https://docs.startree.ai/recipes/real-time-offline-job.md) - [Automatically schedule real-time to offline job](https://docs.startree.ai/recipes/real-time-offline-job-automatic-scheduling.md) - [Upserts and the real-time to offline job](https://docs.startree.ai/recipes/upserts-real-time-offline-job.md) #### JSON Documents - [How to unnest arrays in JSON documents](https://docs.startree.ai/recipes/json-unnest.md) - [How to rename fields when unnesting arrays or flattening objects in JSON documents](https://docs.startree.ai/recipes/json-unnest-rename-fields.md) - [How to flatten objects in JSON documents](https://docs.startree.ai/recipes/json-flatten.md) - [How to index a JSON column](https://docs.startree.ai/recipes/json-index.md) - [How to update a JSON index](https://docs.startree.ai/recipes/json-update-index.md) #### Geospatial - [Storing Geospatial Objects](https://docs.startree.ai/recipes/geospatial.md) - [Indexing Geospatial Points](https://docs.startree.ai/recipes/geospatial-indexing.md) - [Default Value for Geospatial Columns](https://docs.startree.ai/recipes/geospatial-default-value.md) #### Merge and Roll Up - [Merge Small Segments in Offline Tables](https://docs.startree.ai/recipes/merge-small-segments.md) - [Merge Real-Time Segments in Real-Time Tables](https://docs.startree.ai/recipes/merge-segments-realtime.md) #### Other - [Lookup-Based Join Support](https://docs.startree.ai/recipes/lookup-joins.md) - [Infer Pinot Schema from JSON Data](https://docs.startree.ai/recipes/infer-schema-json-data.md) - [Infer Pinot Schema from Avro Schema](https://docs.startree.ai/recipes/infer-schema-avro.md) - [How to Get the Time Boundary for a Hybrid Table](https://docs.startree.ai/recipes/time-boundary-hybrid-table.md) - [How to Handle Null Values](https://docs.startree.ai/recipes/handle-null-values.md) - [Extract Parts of Date](https://docs.startree.ai/recipes/extract-parts-of-date.md) - [How to Query a Table by Segment](https://docs.startree.ai/recipes/query-by-segment.md) - [How to Force Commit Consuming Segments](https://docs.startree.ai/recipes/force-commit.md) - [Using a Star-Tree Index](https://docs.startree.ai/recipes/startree-index.md) - [Managed Offline Flow](https://docs.startree.ai/recipes/managed-offline-flow.md) - [Real-Time RAG Pinot](https://docs.startree.ai/recipes/genai.md) - [How to fix host names](https://docs.startree.ai/recipes/fixed-hostname.md) - [How to Remove a Server](https://docs.startree.ai/recipes/removing-server.md) - [How to Check Segment to Server Assignment](https://docs.startree.ai/recipes/segment-assignment.md) - [API Reference (246 pages)](https://docs.startree.ai/_llms/api-reference.md): Documentation for API Reference. ## OpenAPI Specs - [openapi](/api-reference/openapi.json) - [openapi](/openapi.yaml) > The links below point to documentation indexes. Follow each `/_llms/` index recursively until you reach documentation pages. ## Indexes - [StarTree Cloud (191 pages)](https://docs.startree.ai/_llms/star-tree-cloud.md): Documentation for StarTree Cloud. - [API Reference (246 pages)](https://docs.startree.ai/_llms/api-reference.md): Documentation for API Reference.