Typedefs
Variant supporting all possible types on SQL info.
Map SQL info identifier to its value.
Enums
The result of cancelling a query.
Values:
The action to take if the target table of an ingestion does not exist.
Values:
The action to take if the target table of an ingestion already exists.
Values:
Functions
#include <arrow/flight/sql/types.h>
Options to be set in the SqlInfo.
Public Types
Predefined info values for GetSqlInfo.
Values:
Retrieves a UTF-8 string with the name of the Flight SQL Server.
Retrieves a UTF-8 string with the native version of the Flight SQL Server.
Retrieves a UTF-8 string with the Arrow format version of the Flight SQL Server.
Retrieves a boolean value indicating whether the Flight SQL Server is read only.
Returns:
false: if read-write
true: if read only
Retrieves a boolean value indicating whether the Flight SQL Server supports executing SQL queries.
Note that the absence of this info (as opposed to a false value) does not necessarily mean that SQL is not supported, as this property was not originally defined.
Retrieves a boolean value indicating whether the Flight SQL Server supports executing Substrait plans.
Retrieves a string value indicating the minimum supported Substrait version, or null if Substrait is not supported.
Retrieves a string value indicating the maximum supported Substrait version, or null if Substrait is not supported.
Retrieves an int32 indicating whether the Flight SQL Server supports the BeginTransaction, EndTransaction, BeginSavepoint, and EndSavepoint actions.
Even if this is not supported, the database may still support explicit âBEGIN TRANSACTIONâ/âCOMMITâ SQL statements (see SQL_TRANSACTIONS_SUPPORTED); this property is only about whether the server implements the Flight SQL API endpoints.
The possible values are listed in SqlSupportedTransaction.
Retrieves a boolean value indicating whether the Flight SQL Server supports explicit query cancellation (the CancelQuery action).
Retrieves a boolean value indicating whether the Flight SQL Server supports executing bulk ingestion.
Retrieves a boolean value indicating whether the Flight SQL Server supports transactions for bulk ingestion.
Retrieves an int32 value indicating the timeout (in milliseconds) for prepared statement handles.
If 0, there is no timeout.
Retrieves an int32 value indicating the timeout (in milliseconds) for transactions, since transactions are not tied to a connection.
If 0, there is no timeout.
Retrieves a boolean value indicating whether the Flight SQL Server supports CREATE and DROP of catalogs.
Returns:
false: if it doesnât support CREATE and DROP of catalogs.
true: if it supports CREATE and DROP of catalogs.
Retrieves a boolean value indicating whether the Flight SQL Server supports CREATE and DROP of schemas.
Returns:
false: if it doesnât support CREATE and DROP of schemas.
true: if it supports CREATE and DROP of schemas.
Indicates whether the Flight SQL Server supports CREATE and DROP of tables.
Returns:
false: if it doesnât support CREATE and DROP of tables.
true: if it supports CREATE and DROP of tables.
Retrieves a int32 value representing the enum ordinal for the case sensitivity of catalog, table and schema names.
The possible values are listed in arrow.flight.protocol.sql.SqlSupportedCaseSensitivity.
Retrieves a UTF-8 string with the supported character(s) used to surround a delimited identifier.
Retrieves a int32 value representing the enum ordinal for the case sensitivity of quoted identifiers.
The possible values are listed in arrow.flight.protocol.sql.SqlSupportedCaseSensitivity.
Retrieves a boolean value indicating whether all tables are selectable.
Returns:
false: if not all tables are selectable or if none are;
true: if all tables are selectable.
Retrieves the null ordering used by the database as a int32 ordinal value.
Returns a int32 ordinal for the null ordering being used, as described in arrow.flight.protocol.sql.SqlNullOrdering.
Retrieves a UTF-8 string list with values of the supported keywords.
Retrieves a UTF-8 string list with values of the supported numeric functions.
Retrieves a UTF-8 string list with values of the supported string functions.
Retrieves a UTF-8 string list with values of the supported system functions.
Retrieves a UTF-8 string list with values of the supported datetime functions.
Retrieves the UTF-8 string that can be used to escape wildcard characters.
This is the string that can be used to escape â_â or ââ in the catalog search parameters that are a pattern (and therefore use one of the wildcard characters). The â_â character represents any single character; the ââ character represents any sequence of zero or more characters.
Retrieves a UTF-8 string with all the âextraâ characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
Retrieves a boolean value indicating whether column aliasing is supported.
If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required.
Returns:
false: if column aliasing is unsupported;
true: if column aliasing is supported.
Retrieves a boolean value indicating whether concatenations between null and non-null values being null are supported.
Returns:
false: if concatenations between null and non-null values being null are unsupported;
true: if concatenations between null and non-null values being null are supported.
Retrieves a map where the key is the type to convert from and the value is a list with the types to convert to, indicating the supported conversions.
Each key and each item on the list value is a value to a predefined type on SqlSupportsConvert enum. The returned map will be: map<int32, list<int32>>
Retrieves a boolean value indicating whether, when table correlation names are supported, they are restricted to being different from the names of the tables.
Returns:
false: if table correlation names are unsupported;
true: if table correlation names are supported.
Retrieves a boolean value indicating whether, when table correlation names are supported, they are restricted to being different from the names of the tables.
Returns:
false: if different table correlation names are unsupported;
true: if different table correlation names are supported
Retrieves a boolean value indicating whether expressions in ORDER BY lists are supported.
Returns:
false: if expressions in ORDER BY are unsupported;
true: if expressions in ORDER BY are supported;
Retrieves a boolean value indicating whether using a column that is not in the SELECT statement in a GROUP BY clause is supported.
Returns:
false: if using a column that is not in the SELECT statement in a GROUP BY clause is unsupported;
true: if using a column that is not in the SELECT statement in a GROUP BY clause is supported.
Retrieves the supported GROUP BY commands as an int32 bitmask.
The returned bitmask should be parsed in order to retrieve the supported commands.
return 0 (0b0) => [] (GROUP BY is unsupported);
return 1 (0b1) => [SQL_GROUP_BY_UNRELATED];
return 2 (0b10) => [SQL_GROUP_BY_BEYOND_SELECT];
return 3 (0b11) => [SQL_GROUP_BY_UNRELATED, SQL_GROUP_BY_BEYOND_SELECT].
Valid GROUP BY types are described under arrow.flight.protocol.sql.SqlSupportedGroupBy.
Retrieves a boolean value indicating whether specifying a LIKE escape clause is supported.
Returns:
false: if specifying a LIKE escape clause is unsupported;
true: if specifying a LIKE escape clause is supported.
Retrieves a boolean value indicating whether columns may be defined as non-nullable.
Returns:
false: if columns cannot be defined as non-nullable;
true: if columns may be defined as non-nullable.
Retrieves the supported SQL grammar level as per the ODBC specification.
Returns an int32 bitmask value representing the supported SQL grammar level. The returned bitmask should be parsed in order to retrieve the supported grammar levels.
For instance:
return 0 (0b0) => [] (SQL grammar is unsupported);
return 1 (0b1) => [SQL_MINIMUM_GRAMMAR];
return 2 (0b10) => [SQL_CORE_GRAMMAR];
return 3 (0b11) => [SQL_MINIMUM_GRAMMAR, SQL_CORE_GRAMMAR];
return 4 (0b100) => [SQL_EXTENDED_GRAMMAR];
return 5 (0b101) => [SQL_MINIMUM_GRAMMAR, SQL_EXTENDED_GRAMMAR];
return 6 (0b110) => [SQL_CORE_GRAMMAR, SQL_EXTENDED_GRAMMAR];
return 7 (0b111) => [SQL_MINIMUM_GRAMMAR, SQL_CORE_GRAMMAR, SQL_EXTENDED_GRAMMAR].
Valid SQL grammar levels are described under arrow.flight.protocol.sql.SupportedSqlGrammar.
Retrieves the supported ANSI92 SQL grammar level as per the ODBC specification.
Returns an int32 bitmask value representing the supported ANSI92 SQL grammar level. The returned bitmask should be parsed in order to retrieve the supported grammar levels.
For instance:
return 0 (0b0) => [] (ANSI92 SQL grammar is unsupported);
return 1 (0b1) => [ANSI92_ENTRY_SQL];
return 2 (0b10) => [ANSI92_INTERMEDIATE_SQL];
return 3 (0b11) => [ANSI92_ENTRY_SQL, ANSI92_INTERMEDIATE_SQL];
return 4 (0b100) => [ANSI92_FULL_SQL];
return 5 (0b101) => [ANSI92_ENTRY_SQL, ANSI92_FULL_SQL];
return 6 (0b110) => [ANSI92_INTERMEDIATE_SQL, ANSI92_FULL_SQL];
return 7 (0b111) => [ANSI92_ENTRY_SQL, ANSI92_INTERMEDIATE_SQL, ANSI92_FULL_SQL].
Valid ANSI92 SQL grammar levels are described under arrow.flight.protocol.sql.SupportedAnsi92SqlGrammarLevel.
Retrieves a boolean value indicating whether the SQL Integrity Enhancement Facility is supported.
Returns:
false: if the SQL Integrity Enhancement Facility is supported;
true: if the SQL Integrity Enhancement Facility is supported.
Retrieves the support level for SQL OUTER JOINs as an int32 ordinal, as described in arrow.flight.protocol.sql.SqlOuterJoinsSupportLevel.
Retrieves a UTF-8 string with the preferred term for âschemaâ.
Retrieves a UTF-8 string with the preferred term for âprocedureâ.
Retrieves a UTF-8 string with the preferred term for âcatalogâ.
Retrieves a boolean value indicating whether a catalog appears at the start of a fully qualified table name.
false: if a catalog does not appear at the start of a fully qualified table name;
true: if a catalog appears at the start of a fully qualified table name.
Retrieves the supported actions for a SQL database schema as an int32 bitmask value.
Returns an int32 bitmask value representing the supported actions for a SQL schema. The returned bitmask should be parsed in order to retrieve the supported actions for a SQL schema.
For instance:
return 0 (0b0) => [] (no supported actions for SQL schema);
return 1 (0b1) => [SQL_ELEMENT_IN_PROCEDURE_CALLS];
return 2 (0b10) => [SQL_ELEMENT_IN_INDEX_DEFINITIONS];
return 3 (0b11) => [SQL_ELEMENT_IN_PROCEDURE_CALLS, SQL_ELEMENT_IN_INDEX_DEFINITIONS];
return 4 (0b100) => [SQL_ELEMENT_IN_PRIVILEGE_DEFINITIONS];
return 5 (0b101) => [SQL_ELEMENT_IN_PROCEDURE_CALLS, SQL_ELEMENT_IN_PRIVILEGE_DEFINITIONS];
return 6 (0b110) => [SQL_ELEMENT_IN_INDEX_DEFINITIONS, SQL_ELEMENT_IN_PRIVILEGE_DEFINITIONS];
return 7 (0b111) => [SQL_ELEMENT_IN_PROCEDURE_CALLS, SQL_ELEMENT_IN_INDEX_DEFINITIONS, SQL_ELEMENT_IN_PRIVILEGE_DEFINITIONS].
Valid actions for a SQL schema described under arrow.flight.protocol.sql.SqlSupportedElementActions.
Retrieves the supported actions for a SQL catalog as an int32 bitmask value.
Returns an int32 bitmask value representing the supported actions for a SQL catalog. The returned bitmask should be parsed in order to retrieve the supported actions for a SQL catalog.
For instance:
return 0 (0b0) => [] (no supported actions for SQL catalog);
return 1 (0b1) => [SQL_ELEMENT_IN_PROCEDURE_CALLS];
return 2 (0b10) => [SQL_ELEMENT_IN_INDEX_DEFINITIONS];
return 3 (0b11) => [SQL_ELEMENT_IN_PROCEDURE_CALLS, SQL_ELEMENT_IN_INDEX_DEFINITIONS];
return 4 (0b100) => [SQL_ELEMENT_IN_PRIVILEGE_DEFINITIONS];
return 5 (0b101) => [SQL_ELEMENT_IN_PROCEDURE_CALLS, SQL_ELEMENT_IN_PRIVILEGE_DEFINITIONS];
return 6 (0b110) => [SQL_ELEMENT_IN_INDEX_DEFINITIONS, SQL_ELEMENT_IN_PRIVILEGE_DEFINITIONS];
return 7 (0b111) => [SQL_ELEMENT_IN_PROCEDURE_CALLS, SQL_ELEMENT_IN_INDEX_DEFINITIONS, SQL_ELEMENT_IN_PRIVILEGE_DEFINITIONS].
Valid actions for a SQL catalog are described under arrow.flight.protocol.sql.SqlSupportedElementActions.
Retrieves the supported SQL positioned commands as an int32 bitmask value.
Returns an int32 bitmask value representing the supported SQL positioned commands. The returned bitmask should be parsed in order to retrieve the supported SQL positioned commands.
For instance:
return 0 (0b0) => [] (no supported SQL positioned commands);
return 1 (0b1) => [SQL_POSITIONED_DELETE];
return 2 (0b10) => [SQL_POSITIONED_UPDATE];
return 3 (0b11) => [SQL_POSITIONED_DELETE, SQL_POSITIONED_UPDATE].
Valid SQL positioned commands are described under arrow.flight.protocol.sql.SqlSupportedPositionedCommands.
Retrieves a boolean value indicating whether SELECT FOR UPDATE statements are supported.
Returns:
false: if SELECT FOR UPDATE statements are unsupported;
true: if SELECT FOR UPDATE statements are supported.
Retrieves a boolean value indicating whether stored procedure calls that use the stored procedure escape syntax are supported.
Returns:
false: if stored procedure calls that use the stored procedure escape syntax are unsupported;
true: if stored procedure calls that use the stored procedure escape syntax are supported.
Retrieves the types of supported SQL subqueries as an int32 bitmask value.
Returns an int32 bitmask value representing the supported SQL subqueries. The returned bitmask should be parsed in order to retrieve the supported SQL subqueries.
For instance:
return 0 (0b0) => [] (no supported SQL subqueries);
return 1 (0b1) => [SQL_SUBQUERIES_IN_COMPARISONS];
return 2 (0b10) => [SQL_SUBQUERIES_IN_EXISTS];
return 3 (0b11) => [SQL_SUBQUERIES_IN_COMPARISONS, SQL_SUBQUERIES_IN_EXISTS];
return 4 (0b100) => [SQL_SUBQUERIES_IN_INS];
return 5 (0b101) => [SQL_SUBQUERIES_IN_COMPARISONS, SQL_SUBQUERIES_IN_INS];
return 6 (0b110) => [SQL_SUBQUERIES_IN_COMPARISONS, SQL_SUBQUERIES_IN_EXISTS];
return 7 (0b111) => [SQL_SUBQUERIES_IN_COMPARISONS, SQL_SUBQUERIES_IN_EXISTS, SQL_SUBQUERIES_IN_INS];
return 8 (0b1000) => [SQL_SUBQUERIES_IN_QUANTIFIEDS];
return 9 (0b1001) => [SQL_SUBQUERIES_IN_COMPARISONS, SQL_SUBQUERIES_IN_QUANTIFIEDS];
return 10 (0b1010) => [SQL_SUBQUERIES_IN_EXISTS, SQL_SUBQUERIES_IN_QUANTIFIEDS];
return 11 (0b1011) => [SQL_SUBQUERIES_IN_COMPARISONS, SQL_SUBQUERIES_IN_EXISTS, SQL_SUBQUERIES_IN_QUANTIFIEDS];
return 12 (0b1100) => [SQL_SUBQUERIES_IN_INS, SQL_SUBQUERIES_IN_QUANTIFIEDS];
return 13 (0b1101) => [SQL_SUBQUERIES_IN_COMPARISONS, SQL_SUBQUERIES_IN_INS, SQL_SUBQUERIES_IN_QUANTIFIEDS];
return 14 (0b1110) => [SQL_SUBQUERIES_IN_EXISTS, SQL_SUBQUERIES_IN_INS, SQL_SUBQUERIES_IN_QUANTIFIEDS];
return 15 (0b1111) => [SQL_SUBQUERIES_IN_COMPARISONS, SQL_SUBQUERIES_IN_EXISTS, SQL_SUBQUERIES_IN_INS, SQL_SUBQUERIES_IN_QUANTIFIEDS];
â¦
Valid SQL subqueries are described under arrow.flight.protocol.sql.SqlSupportedSubqueries.
Retrieves a boolean value indicating whether correlated subqueries are supported.
Returns:
false: if correlated subqueries are unsupported;
true: if correlated subqueries are supported.
Retrieves the supported SQL UNION features as an int32 bitmask value.
Returns an int32 bitmask value representing the supported SQL UNIONs. The returned bitmask should be parsed in order to retrieve the supported SQL UNIONs.
For instance:
return 0 (0b0) => [] (no supported SQL positioned commands);
return 1 (0b1) => [SQL_UNION];
return 2 (0b10) => [SQL_UNION_ALL];
return 3 (0b11) => [SQL_UNION, SQL_UNION_ALL].
Valid SQL union operators are described under arrow.flight.protocol.sql.SqlSupportedUnions.
Retrieves a int64 value representing the maximum number of hex characters allowed in an inline binary literal.
Retrieves a int64 value representing the maximum number of characters allowed for a character literal.
Retrieves a int64 value representing the maximum number of characters allowed for a column name.
Retrieves a int64 value representing the maximum number of columns allowed in a GROUP BY clause.
Retrieves a int64 value representing the maximum number of columns allowed in an index.
Retrieves a int64 value representing the maximum number of columns allowed in an ORDER BY clause.
Retrieves a int64 value representing the maximum number of columns allowed in a SELECT list.
Retrieves a int64 value representing the maximum number of columns allowed in a table.
Retrieves a int64 value representing the maximum number of concurrent connections possible.
Retrieves a int64 value the maximum number of characters allowed in a cursor name.
Retrieves a int64 value representing the maximum number of bytes allowed for an index, including all of the parts of the index.
Retrieves a int64 value representing the maximum number of characters allowed in a procedure name.
Retrieves a int64 value representing the maximum number of bytes allowed in a single row.
Retrieves a int64 value representing the maximum number of characters allowed in a catalog name.
Retrieves a int64 value representing the maximum number of bytes allowed in a single row.
Retrieves a boolean indicating whether the return value for the JDBC method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.
Returns:
false: if return value for the JDBC method getMaxRowSize does not include the SQL data types LONGVARCHAR and LONGVARBINARY;
true: if return value for the JDBC method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.
Retrieves a int32 value representing the maximum number of characters allowed for an SQL statement; a result of 0 (zero) means that there is no limit or the limit is not known.
Retrieves a int32 value representing the maximum number of active statements that can be open at the same time.
Retrieves a int32 value representing the maximum number of characters allowed in a table name.
Retrieves a int32 value representing the maximum number of tables allowed in a SELECT statement.
Retrieves a int32 value representing the maximum number of characters allowed in a user name.
Retrieves this databaseâs default transaction isolation level as described in arrow.flight.protocol.sql.SqlTransactionIsolationLevel.
Returns a int32 ordinal for the SQL transaction isolation level.
Retrieves a boolean value indicating whether transactions are supported.
If not, invoking the method commit is a noop, and the isolation level is arrow.flight.protocol.sql.SqlTransactionIsolationLevel.TRANSACTION_NONE.
Returns:
false: if transactions are unsupported;
true: if transactions are supported.
Retrieves the supported transactions isolation levels, if transactions are supported.
Returns an int32 bitmask value representing the supported transactions isolation levels. The returned bitmask should be parsed in order to retrieve the supported transactions isolation levels.
For instance:
return 0 (0b0) => [] (no supported SQL transactions isolation levels);
return 1 (0b1) => [SQL_TRANSACTION_NONE];
return 2 (0b10) => [SQL_TRANSACTION_READ_UNCOMMITTED];
return 3 (0b11) => [SQL_TRANSACTION_NONE, SQL_TRANSACTION_READ_UNCOMMITTED];
return 4 (0b100) => [SQL_TRANSACTION_REPEATABLE_READ];
return 5 (0b101) => [SQL_TRANSACTION_NONE, SQL_TRANSACTION_REPEATABLE_READ];
return 6 (0b110) => [SQL_TRANSACTION_READ_UNCOMMITTED, SQL_TRANSACTION_REPEATABLE_READ];
return 7 (0b111) => [SQL_TRANSACTION_NONE, SQL_TRANSACTION_READ_UNCOMMITTED, SQL_TRANSACTION_REPEATABLE_READ];
return 8 (0b1000) => [SQL_TRANSACTION_REPEATABLE_READ];
return 9 (0b1001) => [SQL_TRANSACTION_NONE, SQL_TRANSACTION_REPEATABLE_READ];
return 10 (0b1010) => [SQL_TRANSACTION_READ_UNCOMMITTED, SQL_TRANSACTION_REPEATABLE_READ];
return 11 (0b1011) => [SQL_TRANSACTION_NONE, SQL_TRANSACTION_READ_UNCOMMITTED, SQL_TRANSACTION_REPEATABLE_READ];
return 12 (0b1100) => [SQL_TRANSACTION_REPEATABLE_READ, SQL_TRANSACTION_REPEATABLE_READ];
return 13 (0b1101) => [SQL_TRANSACTION_NONE, SQL_TRANSACTION_REPEATABLE_READ, SQL_TRANSACTION_REPEATABLE_READ];
return 14 (0b1110) => [SQL_TRANSACTION_READ_UNCOMMITTED, SQL_TRANSACTION_REPEATABLE_READ, SQL_TRANSACTION_REPEATABLE_READ];
return 15 (0b1111) => [SQL_TRANSACTION_NONE, SQL_TRANSACTION_READ_UNCOMMITTED, SQL_TRANSACTION_REPEATABLE_READ, SQL_TRANSACTION_REPEATABLE_READ];
return 16 (0b10000) => [SQL_TRANSACTION_SERIALIZABLE];
â¦
Valid SQL positioned commands are described under arrow.flight.protocol.sql.SqlTransactionIsolationLevel.
Retrieves a boolean value indicating whether a data definition statement within a transaction forces the transaction to commit.
Returns:
false: if a data definition statement within a transaction does not force the transaction to commit;
true: if a data definition statement within a transaction forces the transaction to commit.
Retrieves a boolean value indicating whether a data definition statement within a transaction is ignored.
Returns:
false: if a data definition statement within a transaction is taken into account;
true: a data definition statement within a transaction is ignored.
Retrieves an int32 bitmask value representing the supported result set types.
The returned bitmask should be parsed in order to retrieve the supported result set types.
For instance:
return 0 (0b0) => [] (no supported result set types);
return 1 (0b1) => [SQL_RESULT_SET_TYPE_UNSPECIFIED];
return 2 (0b10) => [SQL_RESULT_SET_TYPE_FORWARD_ONLY];
return 3 (0b11) => [SQL_RESULT_SET_TYPE_UNSPECIFIED, SQL_RESULT_SET_TYPE_FORWARD_ONLY];
return 4 (0b100) => [SQL_RESULT_SET_TYPE_SCROLL_INSENSITIVE];
return 5 (0b101) => [SQL_RESULT_SET_TYPE_UNSPECIFIED, SQL_RESULT_SET_TYPE_SCROLL_INSENSITIVE];
return 6 (0b110) => [SQL_RESULT_SET_TYPE_FORWARD_ONLY, SQL_RESULT_SET_TYPE_SCROLL_INSENSITIVE];
return 7 (0b111) => [SQL_RESULT_SET_TYPE_UNSPECIFIED, SQL_RESULT_SET_TYPE_FORWARD_ONLY, SQL_RESULT_SET_TYPE_SCROLL_INSENSITIVE];
return 8 (0b1000) => [SQL_RESULT_SET_TYPE_SCROLL_SENSITIVE];
â¦
Valid result set types are described under arrow.flight.protocol.sql.SqlSupportedResultSetType.
Returns an int32 bitmask value representing the concurrency types supported by the server for SqlSupportedResultSetType.SQL_RESULT_SET_TYPE_UNSPECIFIED.
For instance:
return 0 (0b0) => [] (no supported concurrency types for this result set type)
return 1 (0b1) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED]
return 2 (0b10) => [SQL_RESULT_SET_CONCURRENCY_READ_ONLY]
return 3 (0b11) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED, SQL_RESULT_SET_CONCURRENCY_READ_ONLY]
return 4 (0b100) => [SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
return 5 (0b101) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED, SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
return 6 (0b110) => [SQL_RESULT_SET_CONCURRENCY_READ_ONLY, SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
return 7 (0b111) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED, SQL_RESULT_SET_CONCURRENCY_READ_ONLY, SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
Valid result set types are described under arrow.flight.protocol.sql.SqlSupportedResultSetConcurrency.
Returns an int32 bitmask value representing the concurrency types supported by the server for SqlSupportedResultSetType.SQL_RESULT_SET_TYPE_FORWARD_ONLY.
For instance:
return 0 (0b0) => [] (no supported concurrency types for this result set type)
return 1 (0b1) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED]
return 2 (0b10) => [SQL_RESULT_SET_CONCURRENCY_READ_ONLY]
return 3 (0b11) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED, SQL_RESULT_SET_CONCURRENCY_READ_ONLY]
return 4 (0b100) => [SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
return 5 (0b101) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED, SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
return 6 (0b110) => [SQL_RESULT_SET_CONCURRENCY_READ_ONLY, SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
return 7 (0b111) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED, SQL_RESULT_SET_CONCURRENCY_READ_ONLY, SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
Valid result set types are described under arrow.flight.protocol.sql.SqlSupportedResultSetConcurrency.
Returns an int32 bitmask value representing the concurrency types supported by the server for SqlSupportedResultSetType.SQL_RESULT_SET_TYPE_SCROLL_SENSITIVE.
For instance:
return 0 (0b0) => [] (no supported concurrency types for this result set type)
return 1 (0b1) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED]
return 2 (0b10) => [SQL_RESULT_SET_CONCURRENCY_READ_ONLY]
return 3 (0b11) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED, SQL_RESULT_SET_CONCURRENCY_READ_ONLY]
return 4 (0b100) => [SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
return 5 (0b101) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED, SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
return 6 (0b110) => [SQL_RESULT_SET_CONCURRENCY_READ_ONLY, SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
return 7 (0b111) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED, SQL_RESULT_SET_CONCURRENCY_READ_ONLY, SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
Valid result set types are described under arrow.flight.protocol.sql.SqlSupportedResultSetConcurrency.
Returns an int32 bitmask value representing concurrency types supported by the server for SqlSupportedResultSetType.SQL_RESULT_SET_TYPE_SCROLL_INSENSITIVE.
For instance:
return 0 (0b0) => [] (no supported concurrency types for this result set type)
return 1 (0b1) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED]
return 2 (0b10) => [SQL_RESULT_SET_CONCURRENCY_READ_ONLY]
return 3 (0b11) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED, SQL_RESULT_SET_CONCURRENCY_READ_ONLY]
return 4 (0b100) => [SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
return 5 (0b101) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED, SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
return 6 (0b110) => [SQL_RESULT_SET_CONCURRENCY_READ_ONLY, SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
return 7 (0b111) => [SQL_RESULT_SET_CONCURRENCY_UNSPECIFIED, SQL_RESULT_SET_CONCURRENCY_READ_ONLY, SQL_RESULT_SET_CONCURRENCY_UPDATABLE]
Valid result set types are described under arrow.flight.protocol.sql.SqlSupportedResultSetConcurrency.
Retrieves a boolean value indicating whether this database supports batch updates.
- false: if this database does not support batch updates; - true: if this database supports batch updates.
Retrieves a boolean value indicating whether this database supports savepoints.
Returns: - false: if this database does not support savepoints; - true: if this database supports savepoints.
Retrieves a boolean value indicating whether named parameters are supported in callable statements.
Returns:
false: if named parameters in callable statements are unsupported;
true: if named parameters in callable statements are supported.
Retrieves a boolean value indicating whether updates made to a LOB are made on a copy or directly to the LOB.
Returns:
false: if updates made to a LOB are made directly to the LOB;
true: if updates made to a LOB are made on a copy.
Retrieves a boolean value indicating whether invoking user-defined or vendor functions using the stored procedure escape syntax is supported.
Returns:
false: if invoking user-defined or vendor functions using the stored procedure escape syntax is unsupported;
true: if invoking user-defined or vendor functions using the stored procedure escape syntax is supported.
The level of support for Flight SQL transaction RPCs.
Values:
Unknown/not indicated/no support.
Transactions, but not savepoints.
Transactions and savepoints.
Indicate whether something (e.g. an identifier) is case-sensitive.
Values:
Indicate how nulls are sorted.
Values:
Type identifiers used to indicate support for converting between types.
Values:
#include <arrow/flight/sql/types.h>
A SQL table reference, optionally containing tableâs catalog and db_schema.
Public Members
The tableâs catalog.
The tableâs database schema.
The table name.
#include <arrow/flight/sql/types.h>
A Substrait plan to be executed, along with associated metadata.
Public Members
The serialized plan.
The Substrait release, e.g. â0.12.0â.
#include <arrow/flight/sql/types.h>
Options for table definition behavior of bulk ingestion.
Flight client with Flight SQL semantics.
Wraps a Flight client to provide the Flight SQL RPC calls.
Public Functions
Execute a SQL query on the server.
options â [in] RPC-layer hints for this call.
query â [in] The UTF8-encoded SQL query to be executed.
transaction â [in] A transaction to associate this query with.
The FlightInfo describing where to access the dataset.
Execute a Substrait plan that returns a result set on the server.
options â [in] RPC-layer hints for this call.
plan â [in] The plan to be executed.
transaction â [in] A transaction to associate this query with.
The FlightInfo describing where to access the dataset.
Get the result set schema from the server.
Get the result set schema from the server.
Execute an update query on the server.
options â [in] RPC-layer hints for this call.
query â [in] The UTF8-encoded SQL query to be executed.
transaction â [in] A transaction to associate this query with.
The quantity of rows affected by the operation.
Execute a Substrait plan that does not return a result set on the server.
options â [in] RPC-layer hints for this call.
plan â [in] The plan to be executed.
transaction â [in] A transaction to associate this query with.
The FlightInfo describing where to access the dataset.
Execute a bulk ingestion to the server.
options â [in] RPC-layer hints for this call.
reader â [in] The records to ingest.
table_definition_options â [in] The behavior for handling the table definition.
table â [in] The destination table to load into.
schema â [in] The DB schema of the destination table.
catalog â [in] The catalog of the destination table.
temporary â [in] Use a temporary table.
transaction â [in] Ingest as part of this transaction.
ingest_options â [in] Additional, backend-specific options.
The number of rows ingested to the server.
Request a list of catalogs.
options â [in] RPC-layer hints for this call.
The FlightInfo describing where to access the dataset.
Get the catalogs schema from the server (should be identical to SqlSchema::GetCatalogsSchema).
Request a list of database schemas.
options â [in] RPC-layer hints for this call.
catalog â [in] The catalog.
db_schema_filter_pattern â [in] The schema filter pattern.
The FlightInfo describing where to access the dataset.
Get the database schemas schema from the server (should be identical to SqlSchema::GetDbSchemasSchema).
Given a flight ticket and schema, request to be sent the stream.
Returns record batch stream reader
options â [in] Per-RPC options
ticket â [in] The flight ticket to use
The returned RecordBatchReader
Request a list of tables.
options â [in] RPC-layer hints for this call.
catalog â [in] The catalog.
db_schema_filter_pattern â [in] The schema filter pattern.
table_filter_pattern â [in] The table filter pattern.
include_schema â [in] True to include the schema upon return, false to not include the schema.
table_types â [in] The table types to include.
The FlightInfo describing where to access the dataset.
Get the tables schema from the server (should be identical to SqlSchema::GetTablesSchema).
Request the primary keys for a table.
options â [in] RPC-layer hints for this call.
table_ref â [in] The table reference.
The FlightInfo describing where to access the dataset.
Get the primary keys schema from the server (should be identical to SqlSchema::GetPrimaryKeysSchema).
Retrieves a description about the foreign key columns that reference the primary key columns of the given table.
options â [in] RPC-layer hints for this call.
table_ref â [in] The table reference.
The FlightInfo describing where to access the dataset.
Get the exported keys schema from the server (should be identical to SqlSchema::GetExportedKeysSchema).
Retrieves the foreign key columns for the given table.
options â [in] RPC-layer hints for this call.
table_ref â [in] The table reference.
The FlightInfo describing where to access the dataset.
Get the imported keys schema from the server (should be identical to SqlSchema::GetImportedKeysSchema).
Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table).
options â [in] RPC-layer hints for this call.
pk_table_ref â [in] The table reference that exports the key.
fk_table_ref â [in] The table reference that imports the key.
The FlightInfo describing where to access the dataset.
Get the cross reference schema from the server (should be identical to SqlSchema::GetCrossReferenceSchema).
Request a list of table types.
options â [in] RPC-layer hints for this call.
The FlightInfo describing where to access the dataset.
Get the table types schema from the server (should be identical to SqlSchema::GetTableTypesSchema).
Request the information about all the data types supported.
options â [in] RPC-layer hints for this call.
The FlightInfo describing where to access the dataset.
Request the information about all the data types supported.
options â [in] RPC-layer hints for this call.
data_type â [in] The data type to search for as filtering.
The FlightInfo describing where to access the dataset.
Get the type info schema from the server (should be identical to SqlSchema::GetXdbcTypeInfoSchema).
Request a list of SQL information.
options â [in] RPC-layer hints for this call.
sql_info â [in] the SQL info required.
The FlightInfo describing where to access the dataset.
Get the SQL information schema from the server (should be identical to SqlSchema::GetSqlInfoSchema).
Create a prepared statement object.
options â [in] RPC-layer hints for this call.
query â [in] The query that will be executed.
transaction â [in] A transaction to associate this query with.
The created prepared statement.
Create a prepared statement object.
options â [in] RPC-layer hints for this call.
plan â [in] The Substrait plan that will be executed.
transaction â [in] A transaction to associate this query with.
The created prepared statement.
Call the underlying Flight clientâs GetFlightInfo.
Call the underlying Flight clientâs GetSchema.
Begin a new transaction.
Create a new savepoint within a transaction.
options â [in] RPC-layer hints for this call.
transaction â [in] The parent transaction.
name â [in] A friendly name for the savepoint.
Commit a transaction.
After this, the transaction and all associated savepoints will be invalidated.
options â [in] RPC-layer hints for this call.
transaction â [in] The transaction.
Release a savepoint.
After this, the savepoint (and all savepoints created after it) will be invalidated.
options â [in] RPC-layer hints for this call.
savepoint â [in] The savepoint.
Rollback a transaction.
After this, the transaction and all associated savepoints will be invalidated.
options â [in] RPC-layer hints for this call.
transaction â [in] The transaction.
Rollback a savepoint.
After this, the savepoint will still be valid, but all savepoints created after it will be invalidated.
options â [in] RPC-layer hints for this call.
savepoint â [in] The savepoint.
Explicitly cancel a FlightInfo.
options â [in] RPC-layer hints for this call.
request â [in] The CancelFlightInfoRequest.
Arrow result with a canceled result.
Explicitly cancel a query.
Deprecated since 13.0.0. Use CancelFlightInfo() instead. If you can assume that a server requires 13.0.0 or later, you can always use CancelFlightInfo(). Otherwise, you may need to use CancelQuery() and/or CancelFlightInfo().
options â [in] RPC-layer hints for this call.
info â [in] The FlightInfo of the query to cancel.
Sets session options.
options â [in] RPC-layer hints for this call.
request â [in] The session options to set.
Gets current session options.
options â [in] RPC-layer hints for this call.
request â [in] The (empty) GetSessionOptions request object.
Explicitly closes the session if applicable.
options â [in] RPC-layer hints for this call.
request â [in] The (empty) CloseSession request object.
Extends the expiration of a FlightEndpoint.
options â [in] RPC-layer hints for this call.
request â [in] The RenewFlightEndpointRequest.
Arrow result with a renewed FlightEndpoint
Explicitly shut down and clean up the client.
Wrapper around FlightClient::DoGet.
Wrapper around FlightClient::DoPut.
Donât call this directly.
A prepared statement that can be executed.
Public Functions
Create a new prepared statement.
However, applications should generally use FlightSqlClient::Prepare.
Default destructor for the PreparedStatement class.
The destructor will call the Close method from the class in order, to send a request to close the PreparedStatement. NOTE: It is best to explicitly close the PreparedStatement, otherwise errors canât be caught.
Executes the prepared statement query on the server.
A FlightInfo object representing the stream(s) to fetch.
Executes the prepared statement update query on the server.
The number of rows affected.
Retrieve the parameter schema from the query.
The parameter schema from the query.
Retrieve the ResultSet schema from the query.
The ResultSet schema from the query.
Set a RecordBatch that contains the parameters that will be bound.
Set a RecordBatchReader that contains the parameters that will be bound.
Re-request the result set schema from the server (should be identical to dataset_schema).
Close the prepared statement so the server can free up any resources.
After this, the prepared statement may not be used anymore.
Check if the prepared statement is closed.
The state of the prepared statement.
The base class for Flight SQL servers.
Applications should subclass this class and override the virtual methods declared on this class.
Subclassed by arrow::flight::sql::example::SQLiteFlightSqlServer
Flight RPC handlers
Applications should not override these methods; they implement the Flight SQL protocol.
Retrieve the schema and an access plan for the indicated descriptor.
context â [in] The call context.
request â [in] the dataset request, whether a named dataset or command
info â [out] the returned flight info provider
Retrieve the schema for the indicated descriptor.
context â [in] The call context.
request â [in] the dataset request, whether a named dataset or command
schema â [out] the returned flight schema provider
Get a stream of IPC payloads to put on the wire.
context â [in] The call context.
request â [in] an opaque ticket
stream â [out] the returned stream provider
Process a stream of IPC payloads sent from a client.
context â [in] The call context.
reader â [in] a sequence of uploaded record batches
writer â [in] send metadata back to the client
Retrieve the list of available actions.
context â [in] The call context.
actions â [out] a vector of available action types
Execute an action, return stream of zero or more results.
context â [in] The call context.
action â [in] the action to execute, with type and body
result â [out] the result iterator
Flight SQL methods
Applications should override these methods to implement the Flight SQL endpoints.
Get a FlightInfo for executing a SQL query.
context â [in] Per-call context.
command â [in] The StatementQuery object containing the SQL statement.
descriptor â [in] The descriptor identifying the data stream.
The FlightInfo describing where to access the dataset.
Get a FlightInfo for executing a Substrait plan.
context â [in] Per-call context.
command â [in] The StatementSubstraitPlan object containing the plan.
descriptor â [in] The descriptor identifying the data stream.
The FlightInfo describing where to access the dataset.
Get a FlightDataStream containing the query results.
context â [in] Per-call context.
command â [in] The StatementQueryTicket containing the statement handle.
The FlightDataStream containing the results.
Get a FlightInfo for executing an already created prepared statement.
context â [in] Per-call context.
command â [in] The PreparedStatementQuery object containing the prepared statement handle.
descriptor â [in] The descriptor identifying the data stream.
The FlightInfo describing where to access the dataset.
Get a FlightDataStream containing the prepared statement query results.
context â [in] Per-call context.
command â [in] The PreparedStatementQuery object containing the prepared statement handle.
The FlightDataStream containing the results.
Get a FlightInfo for listing catalogs.
context â [in] Per-call context.
descriptor â [in] The descriptor identifying the data stream.
The FlightInfo describing where to access the dataset.
Get the schema of the result set of a query.
context â [in] Per-call context.
command â [in] The StatementQuery containing the SQL query.
descriptor â [in] The descriptor identifying the data stream.
The schema of the result set.
Get the schema of the result set of a Substrait plan.
context â [in] Per-call context.
command â [in] The StatementQuery containing the plan.
descriptor â [in] The descriptor identifying the data stream.
The schema of the result set.
Get the schema of the result set of a prepared statement.
context â [in] Per-call context.
command â [in] The PreparedStatementQuery containing the prepared statement handle.
descriptor â [in] The descriptor identifying the data stream.
The schema of the result set.
Get a FlightDataStream containing the list of catalogs.
context â [in] Per-call context.
An interface for sending data back to the client.
Gets a FlightInfo for retrieving other information (See TypeInfo).
context â [in] Per-call context.
command â [in] An optional filter for on the data type.
descriptor â [in] The descriptor identifying the data stream.
Gets a FlightDataStream containing information about the data types supported.
context â [in] Per-call context.
command â [in] The GetXdbcTypeInfo object which may contain filter for the date type to be search for.
Get a FlightInfo for retrieving other information (See SqlInfo).
context â [in] Per-call context.
command â [in] The GetSqlInfo object containing the list of SqlInfo to be returned.
descriptor â [in] The descriptor identifying the data stream.
The FlightInfo describing where to access the dataset.
Get a FlightDataStream containing the list of SqlInfo results.
context â [in] Per-call context.
command â [in] The GetSqlInfo object containing the list of SqlInfo to be returned.
The FlightDataStream containing the results.
Get a FlightInfo for listing schemas.
context â [in] Per-call context.
command â [in] The GetDbSchemas object which may contain filters for catalog and schema name.
descriptor â [in] The descriptor identifying the data stream.
The FlightInfo describing where to access the dataset.
Get a FlightDataStream containing the list of schemas.
context â [in] Per-call context.
command â [in] The GetDbSchemas object which may contain filters for catalog and schema name.
The FlightDataStream containing the results.
Get a FlightInfo for listing tables.
context â [in] Per-call context.
command â [in] The GetTables object which may contain filters for catalog, schema and table names.
descriptor â [in] The descriptor identifying the data stream.
The FlightInfo describing where to access the dataset.
Get a FlightDataStream containing the list of tables.
context â [in] Per-call context.
command â [in] The GetTables object which may contain filters for catalog, schema and table names.
The FlightDataStream containing the results.
Get a FlightInfo to extract information about the table types.
context â [in] Per-call context.
descriptor â [in] The descriptor identifying the data stream.
The FlightInfo describing where to access the dataset.
Get a FlightDataStream containing the data related to the table types.
context â [in] Per-call context.
The FlightDataStream containing the results.
Get a FlightInfo to extract information about primary and foreign keys.
context â [in] Per-call context.
command â [in] The GetPrimaryKeys object with necessary information to execute the request.
descriptor â [in] The descriptor identifying the data stream.
The FlightInfo describing where to access the dataset.
Get a FlightDataStream containing the data related to the primary and foreign keys.
context â [in] Per-call context.
command â [in] The GetPrimaryKeys object with necessary information to execute the request.
The FlightDataStream containing the results.
Get a FlightInfo to extract information about foreign and primary keys.
context â [in] Per-call context.
command â [in] The GetExportedKeys object with necessary information to execute the request.
descriptor â [in] The descriptor identifying the data stream.
The FlightInfo describing where to access the dataset.
Get a FlightDataStream containing the data related to the foreign and primary keys.
context â [in] Per-call context.
command â [in] The GetExportedKeys object with necessary information to execute the request.
The FlightDataStream containing the results.
Get a FlightInfo to extract information about foreign and primary keys.
context â [in] Per-call context.
command â [in] The GetImportedKeys object with necessary information to execute the request.
descriptor â [in] The descriptor identifying the data stream.
The FlightInfo describing where to access the dataset.
Get a FlightDataStream containing the data related to the foreign and primary keys.
context â [in] Per-call context.
command â [in] The GetImportedKeys object with necessary information to execute the request.
The FlightDataStream containing the results.
Get a FlightInfo to extract information about foreign and primary keys.
context â [in] Per-call context.
command â [in] The GetCrossReference object with necessary information to execute the request.
descriptor â [in] The descriptor identifying the data stream.
The FlightInfo describing where to access the dataset.
Get a FlightDataStream containing the data related to the foreign and primary keys.
context â [in] Per-call context.
command â [in] The GetCrossReference object with necessary information to execute the request.
The FlightDataStream containing the results.
Execute an update SQL statement.
context â [in] The call context.
command â [in] The StatementUpdate object containing the SQL statement.
The changed record count.
Execute an update Substrait plan.
context â [in] The call context.
command â [in] The StatementSubstraitPlan object containing the plan.
The changed record count.
Create a prepared statement from a given SQL statement.
context â [in] The call context.
request â [in] The ActionCreatePreparedStatementRequest object containing the SQL statement.
A ActionCreatePreparedStatementResult containing the dataset and parameter schemas and a handle for created statement.
Create a prepared statement from a Substrait plan.
context â [in] The call context.
request â [in] The ActionCreatePreparedSubstraitPlanRequest object containing the Substrait plan.
A ActionCreatePreparedStatementResult containing the dataset and parameter schemas and a handle for created statement.
Close a prepared statement.
context â [in] The call context.
request â [in] The ActionClosePreparedStatementRequest object containing the prepared statement handle.
Bind parameters to given prepared statement.
context â [in] The call context.
command â [in] The PreparedStatementQuery object containing the prepared statement handle.
reader â [in] A sequence of uploaded record batches.
writer â [in] Send metadata back to the client.
Execute an update SQL prepared statement.
context â [in] The call context.
command â [in] The PreparedStatementUpdate object containing the prepared statement handle.
reader â [in] a sequence of uploaded record batches.
The changed record count.
Execute a bulk ingestion.
context â [in] The call context.
command â [in] The StatementIngest object containing the ingestion request.
reader â [in] a sequence of uploaded record batches.
The changed record count.
Begin a new transaction.
context â [in] The call context.
request â [in] Request parameters.
The transaction ID.
Create a new savepoint.
context â [in] The call context.
request â [in] Request parameters.
The savepoint ID.
Release/rollback a savepoint.
context â [in] The call context.
request â [in] The savepoint.
Commit/rollback a transaction.
context â [in] The call context.
request â [in] The transaction.
Attempt to explicitly cancel a FlightInfo.
context â [in] The call context.
request â [in] The CancelFlightInfoRequest.
The cancellation result.
Set server session option(s).
context â [in] The call context.
request â [in] The session options to set.
Get server session option(s).
context â [in] The call context.
request â [in] Request object.
Close/invalidate the session.
context â [in] The call context.
request â [in] Request object.
Attempt to explicitly cancel a query.
Deprecated in 13.0.0. You just need to implement CancelFlightInfo() to support both the CancelFlightInfo action (for newer clients) and the CancelQuery action (for older clients).
context â [in] The call context.
request â [in] The query to cancel.
The cancellation result.
Attempt to explicitly renew a FlightEndpoint.
context â [in] The call context.
request â [in] The RenewFlightEndpointRequest.
The renew result.
Utility methods
Register a new SqlInfo result, making it available when calling GetSqlInfo.
id â [in] the SqlInfo identifier.
result â [in] the result.
A utility function to create a ticket (a opaque binary token that the server uses to identify this query) for a statement query.
Intended for Flight SQL server implementations.
statement_handle â [in] The statement handle that will originate the ticket.
The parsed ticket as an string.
Auxiliary class containing all Schemas used on Flight SQL.
Public Static Functions
Get the Schema used on GetCatalogs response.
The default schema template.
Get the Schema used on GetDbSchemas response.
The default schema template.
Get the Schema used on GetTables response when included schema flags is set to false.
The default schema template.
Get the Schema used on GetTables response when included schema flags is set to true.
The default schema template.
Get the Schema used on GetTableTypes response.
The default schema template.
Get the Schema used on GetPrimaryKeys response when included schema flags is set to true.
The default schema template.
Get the Schema used on GetImportedKeys response.
The default schema template.
Get the Schema used on GetImportedKeys response.
The default schema template.
Get the Schema used on GetCrossReference response.
The default schema template.
Get the Schema used on GetXdbcTypeInfo response.
The default schema template.
Get the Schema used on GetSqlInfo response.
The default schema template.
Simple struct wrappers for various protocol messages, used to avoid exposing Protobuf types in the API.
#include <arrow/flight/sql/server.h>
A SQL query.
Public Members
The SQL query.
The transaction ID, if specified (else a blank string).
#include <arrow/flight/sql/server.h>
A Substrait plan to execute.
Public Members
The Substrait plan.
The transaction ID, if specified (else a blank string).
#include <arrow/flight/sql/server.h>
A SQL update query.
Public Members
The SQL query.
The transaction ID, if specified (else a blank string).
#include <arrow/flight/sql/server.h>
A request to execute a query.
Public Members
The server-generated opaque identifier for the query.
#include <arrow/flight/sql/server.h>
A prepared query statement.
Public Members
The server-generated opaque identifier for the statement.
#include <arrow/flight/sql/server.h>
A prepared update statement.
Public Members
The server-generated opaque identifier for the statement.
#include <arrow/flight/sql/server.h>
A bulk ingestion request.
Public Members
The behavior for handling the table definition.
The destination table to load into.
The DB schema of the destination table.
:
The catalog of the destination table.
Use a temporary table.
Ingest as part of this transaction.
Additional, backend-specific options.
#include <arrow/flight/sql/server.h>
A request to fetch server metadata.
Public Members
A list of metadata IDs to fetch.
#include <arrow/flight/sql/server.h>
A request to list database schemas.
Public Members
An optional database catalog to filter on.
An optional database schema to filter on.
#include <arrow/flight/sql/server.h>
A request to list database tables.
Public Members
An optional database catalog to filter on.
An optional database schema to filter on.
An optional table name to filter on.
A list of table types to filter on.
Whether to include the Arrow schema in the response.
#include <arrow/flight/sql/server.h>
A request to get SQL data type information.
Public Members
A specific SQL type ID to fetch information about.
#include <arrow/flight/sql/server.h>
A request to list primary keys of a table.
Public Members
The given table.
#include <arrow/flight/sql/server.h>
A request to list foreign key columns referencing primary key columns of a table.
Public Members
The given table.
#include <arrow/flight/sql/server.h>
A request to list foreign keys of a table.
Public Members
The given table.
#include <arrow/flight/sql/server.h>
A request to list foreign key columns of a table that reference columns in a given parent table.
Public Members
The parent table (the one containing referenced columns).
The foreign table (for which foreign key columns will be listed).
#include <arrow/flight/sql/server.h>
A request to start a new transaction.
#include <arrow/flight/sql/server.h>
A request to create a new savepoint.
#include <arrow/flight/sql/server.h>
The result of starting a new savepoint.
#include <arrow/flight/sql/server.h>
The result of starting a new transaction.
#include <arrow/flight/sql/server.h>
A request to end a savepoint.
#include <arrow/flight/sql/server.h>
A request to end a transaction.
#include <arrow/flight/sql/server.h>
An explicit request to cancel a running query.
#include <arrow/flight/sql/server.h>
A request to create a new prepared statement.
Public Members
The SQL query.
The transaction ID, if specified (else a blank string).
#include <arrow/flight/sql/server.h>
A request to create a new prepared statement with a Substrait plan.
Public Members
The serialized Substrait plan.
The transaction ID, if specified (else a blank string).
#include <arrow/flight/sql/server.h>
A request to close a prepared statement.
Public Members
The server-generated opaque identifier for the statement.
#include <arrow/flight/sql/server.h>
The result of creating a new prepared statement.
Public Members
The schema of the query results, if applicable.
The schema of the query parameters, if applicable.
The server-generated opaque identifier for the statement.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4