Arrow Flight SQL
The InfluxDB SQL implementation uses Arrow Flight SQL to query InfluxDB and return results.
Arrow Flight SQL is a protocol for interacting with SQL databases using the Arrow in-memory format and the Flight RPC framework.
Flight SQL uses the RPC methods defined in the in Flight RPC framework and provides various commands that pair those methods with request and response messages. The InfluxDB Flight SQL implementation supports the following Flight SQL commands:
Flight SQL metadata commands
For command descriptions, see the Arrow Flight SQL RPC methods documentation.
| Message | Supported |
|---|---|
| CommandGetCatalogs | |
| CommandGetDbSchemas | |
| CommandGetTables | |
| CommandGetTableTypes | |
| CommandGetSqlInfo | |
| CommandGetPrimaryKeys | |
| CommandGetExportedKeys | |
| CommandGetImportedKeys | |
| CommandGetCrossReference | |
| CommandGetXdbcTypeInfo |
Flight SQL query execution commands
For command descriptions, see the Arrow Flight SQL RPC methods documentation.
| Message | Supported |
|---|---|
| ActionCreatePreparedStatementRequest | |
| ActionCreatePreparedSubstraitPlanRequest | |
| ActionClosePreparedStatementRequest | |
| ActionBeginTransactionRequest | |
| ActionBeginSavepointRequest | |
| ActionBeginSavepointResult | |
| ActionEndTransactionRequest | |
| ActionEndSavepointRequest | |
| CommandStatementQuery | |
| CommandStatementSubstraitPlan | |
| CommandPreparedStatementQuery | |
| CommandPreparedStatementUpdate | |
| ActionCancelQueryRequest |
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.