Query
Parseable uses Apache DataFusion as its query engine, providing PostgreSQL-compatible SQL for telemetry data analysis.
How It Works
- Query is parsed and an execution plan is created
- Data manifest file filters relevant Parquet files based on column metadata and time range
- DataFusion reads only the required data via S3
GetRangeAPI - Results are returned with minimal I/O and cost
Supported Functions
Parseable supports all DataFusion SQL functions:
- Aggregate Functions - COUNT, SUM, AVG, etc.
- Window Functions - ROW_NUMBER, RANK, etc.
- Scalar Functions - String, Math, Date/Time, etc.
Key Capabilities
| Feature | Description |
|---|---|
| PostgreSQL syntax | Familiar SQL with regex operators (~, ~*, !~, !~*) |
| Query analysis | EXPLAIN ANALYZE for performance insights |
| Time-range filtering | Efficient filtering via p_timestamp |
| AI query builder | Natural language to SQL (Enterprise) |
References:
- SQL Editor User Guide - Query examples and usage
- Text to SQL - AI-powered query generation
- Query API - REST API documentation
Was this page helpful?