String catalogName
The catalog to which the query results belong.
String schemaName
The schema name (database name) to which the query results belong.
String tableName
The table name for the query results.
String name
The name of the column.
String label
A column label.
String type
The data type of the column.
Integer precision
For DECIMAL
data types, specifies the total number of digits, up to 38. For performance reasons, we
recommend up to 18 digits.
Integer scale
For DECIMAL
data types, specifies the total number of digits in the fractional part of the value.
Defaults to 0.
String nullable
Indicates the column's nullable status.
Boolean caseSensitive
Indicates whether values in the column are case-sensitive.
String name
The plain language name for the query.
String description
A brief explanation of the query.
String database
The database to which the query belongs.
String queryString
The text of the query itself. In other words, all query statements.
String clientRequestToken
A unique case-sensitive string used to ensure the request to create the query is idempotent (executes only once).
If another CreateNamedQuery
request is received, the same response is returned and another query is
not created. If a parameter has changed, for example, the QueryString
, an error is returned.
This token is listed as not required because AWS SDKs (for example the AWS SDK for Java) auto-generate the token for users. If you are not using the AWS SDK or the AWS CLI, you must provide this token or the action will fail.
String namedQueryId
The unique ID of the query.
String varCharValue
The value of the datum.
String namedQueryId
The unique ID of the query to delete.
String encryptionOption
Indicates whether Amazon S3 server-side encryption with Amazon S3-managed keys (SSE-S3
), server-side
encryption with KMS-managed keys (SSE-KMS
), or client-side encryption with KMS-managed keys
(CSE-KMS) is used.
String kmsKey
For SSE-KMS
and CSE-KMS
, this is the KMS key ARN or ID.
String namedQueryId
The unique ID of the query. Use ListNamedQueries to get query IDs.
NamedQuery namedQuery
Information about the query.
String queryExecutionId
The unique ID of the query execution.
QueryExecution queryExecution
Information about the query execution.
String athenaErrorCode
String name
The plain-language name of the query.
String description
A brief description of the query.
String database
The database to which the query belongs.
String queryString
The SQL query statements that comprise the query.
String namedQueryId
The unique identifier of the query.
String queryExecutionId
The unique identifier for each query execution.
String query
The SQL query statements which the query execution ran.
String statementType
The type of query statement that was run. DDL
indicates DDL query statements. DML
indicates DML (Data Manipulation Language) query statements, such as CREATE TABLE AS SELECT
.
UTILITY
indicates query statements other than DDL and DML, such as SHOW CREATE TABLE
,
or DESCRIBE <table>
.
ResultConfiguration resultConfiguration
The location in Amazon S3 where query results were stored and the encryption option, if any, used for query results.
QueryExecutionContext queryExecutionContext
The database in which the query execution occurred.
QueryExecutionStatus status
The completion date, current state, submission time, and state change reason (if applicable) for the query execution.
QueryExecutionStatistics statistics
The amount of data scanned during the query execution and the amount of time that it took to execute, and the type of statement that was run.
String database
The name of the database.
String state
The state of query execution. QUEUED
state is listed but is not used by Athena and is reserved for
future use. RUNNING
indicates that the query has been submitted to the service, and Athena will
execute the query as soon as resources are available. SUCCEEDED
indicates that the query completed
without error. FAILED
indicates that the query experienced an error and did not complete processing.
CANCELLED
indicates that user input interrupted query execution.
String stateChangeReason
Further detail about the status of the query.
Date submissionDateTime
The date and time that the query was submitted.
Date completionDateTime
The date and time that the query completed.
String outputLocation
The location in Amazon S3 where your query results are stored, such as s3://path/to/query/bucket/
.
For more information, see Queries and Query
Result Files.
EncryptionConfiguration encryptionConfiguration
If query results are encrypted in Amazon S3, indicates the encryption option used (for example,
SSE-KMS
or CSE-KMS
) and key information.
List<E> rows
The rows in the table.
ResultSetMetadata resultSetMetadata
The metadata that describes the column structure and data types of a table of query results.
String queryString
The SQL query statements to be executed.
String clientRequestToken
A unique case-sensitive string used to ensure the request to create the query is idempotent (executes only once).
If another StartQueryExecution
request is received, the same response is returned and another query
is not created. If a parameter has changed, for example, the QueryString
, an error is returned.
This token is listed as not required because AWS SDKs (for example the AWS SDK for Java) auto-generate the token for users. If you are not using the AWS SDK or the AWS CLI, you must provide this token or the action will fail.
QueryExecutionContext queryExecutionContext
The database within which the query executes.
ResultConfiguration resultConfiguration
Specifies information about where and how to save the results of the query execution.
String queryExecutionId
The unique ID of the query that ran as a result of this request.
String queryExecutionId
The unique ID of the query execution to stop.
String reason
String namedQueryId
The unique identifier of the named query.
String errorCode
The error code returned when the processing request for the named query failed, if applicable.
String errorMessage
The error message returned when the processing request for the named query failed, if applicable.
String queryExecutionId
The unique identifier of the query execution.
String errorCode
The error code returned when the query execution failed to process, if applicable.
String errorMessage
The error message returned when the query execution failed to process, if applicable.
Copyright © 2018. All rights reserved.