Apache IoTDB is a time series database designed for IoT data, with efficient storage and query capabilities for massive time series data.
Installation
Required packages: apache-iotdb
Connection String
iotdb://{username}:{password}@{hostname}:{port}/| Parameter | Description |
|---|---|
| username | Database username (default: root) |
| password | Database password (default: root) |
| hostname | IP address or hostname |
| port | Default 6667 |
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Notes
The IoTDB SQLAlchemy dialect was written to integrate with Apache Superset. IoTDB uses a hierarchical data model, which is reorganized into a relational model for SQL queries.