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.

{{% cite %}}-- Arrow Flight SQL documentation{{% /cite %}}

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

{{% caption %}} For command descriptions, see the Arrow Flight SQL RPC methods documentation. {{% /caption %}}

Message	Supported
CommandGetCatalogs	{{% icon "check" %}}
CommandGetDbSchemas	{{% icon "check" %}}
CommandGetTables	{{% icon "check" %}}
CommandGetTableTypes	{{% icon "check" %}}
CommandGetSqlInfo	{{% icon "check" %}}
CommandGetPrimaryKeys	{{% icon "check" %}}
CommandGetExportedKeys	{{% icon "check" %}}
CommandGetImportedKeys	{{% icon "check" %}}
CommandGetCrossReference	{{% icon "check" %}}
CommandGetXdbcTypeInfo

Flight SQL query execution commands

{{% caption %}} For command descriptions, see the Arrow Flight SQL RPC methods documentation. {{% /caption %}}

Message	Supported
ActionCreatePreparedStatementRequest
ActionCreatePreparedSubstraitPlanRequest
ActionClosePreparedStatementRequest
ActionBeginTransactionRequest
ActionBeginSavepointRequest
ActionBeginSavepointResult
ActionEndTransactionRequest
ActionEndSavepointRequest
CommandStatementQuery	{{% icon "check" %}}
CommandStatementSubstraitPlan
CommandPreparedStatementQuery	{{% icon "check" %}}
CommandPreparedStatementUpdate
ActionCancelQueryRequest