Influxdata
/
docs-v2
mirror of https://github.com/influxdata/docs-v2.git
1
0
Fork 0
Code Issues Projects Releases Wiki Activity
docs-v2/content/influxdb3/cloud-serverless/reference/internals/arrow-flightsql.md

3.2 KiB
Raw Permalink Blame History

title description menu weight related
Arrow Flight SQL The InfluxDB SQL implementation uses **Arrow Flight SQL** to query InfluxDB and return results.
influxdb3_cloud_serverless
parent
InfluxDB Cloud internals
101
/influxdb3/cloud-serverless/reference/sql/
/influxdb3/cloud-serverless/reference/client-libraries/flight/

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