/AWS1/CL_ATHQUERYEXECUTION

Information about a single instance of a query execution.

CONSTRUCTOR

IMPORTING

Optional arguments:

iv_queryexecutionid TYPE /AWS1/ATHQUERYEXECUTIONID /AWS1/ATHQUERYEXECUTIONID

The unique identifier for each query execution.

iv_query TYPE /AWS1/ATHQUERYSTRING /AWS1/ATHQUERYSTRING

The SQL query statements which the query execution ran.

iv_statementtype TYPE /AWS1/ATHSTATEMENTTYPE /AWS1/ATHSTATEMENTTYPE

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.

io_managedqueryresultsconf TYPE REF TO /AWS1/CL_ATHMANAGEDQUERYRSSC00 /AWS1/CL_ATHMANAGEDQUERYRSSC00

The configuration for storing results in Athena owned storage, which includes whether this feature is enabled; whether encryption configuration, if any, is used for encrypting query results.

io_resultconfiguration TYPE REF TO /AWS1/CL_ATHRESULTCONF /AWS1/CL_ATHRESULTCONF

The location in Amazon S3 where query and calculation results are stored and the encryption option, if any, used for query results. These are known as "client-side settings". If workgroup settings override client-side settings, then the query uses the location for the query results and the encryption configuration that are specified for the workgroup.

io_resultreuseconfiguration TYPE REF TO /AWS1/CL_ATHRESULTREUSECONF /AWS1/CL_ATHRESULTREUSECONF

Specifies the query result reuse behavior that was used for the query.

io_queryexecutioncontext TYPE REF TO /AWS1/CL_ATHQUERYEXECCONTEXT /AWS1/CL_ATHQUERYEXECCONTEXT

The database in which the query execution occurred.

io_status TYPE REF TO /AWS1/CL_ATHQUERYEXECSTATUS /AWS1/CL_ATHQUERYEXECSTATUS

The completion date, current state, submission time, and state change reason (if applicable) for the query execution.

io_statistics TYPE REF TO /AWS1/CL_ATHQUERYEXECSTATS /AWS1/CL_ATHQUERYEXECSTATS

Query execution statistics, such as the amount of data scanned, the amount of time that the query took to process, and the type of statement that was run.

iv_workgroup TYPE /AWS1/ATHWORKGROUPNAME /AWS1/ATHWORKGROUPNAME

The name of the workgroup in which the query ran.

io_engineversion TYPE REF TO /AWS1/CL_ATHENGINEVERSION /AWS1/CL_ATHENGINEVERSION

The engine version that executed the query.

it_executionparameters TYPE /AWS1/CL_ATHEXECUTIONPARAMS_W=>TT_EXECUTIONPARAMETERS TT_EXECUTIONPARAMETERS

A list of values for the parameters in a query. The values are applied sequentially to the parameters in the query in the order in which the parameters occur. The list of parameters is not returned in the response.

iv_substatementtype TYPE /AWS1/ATHSTRING /AWS1/ATHSTRING

The kind of query statement that was run.

io_queryrsltss3accgrantsconf TYPE REF TO /AWS1/CL_ATHQUERYRSSS3ACCGRA00 /AWS1/CL_ATHQUERYRSSS3ACCGRA00

Specifies whether Amazon S3 access grants are enabled for query results.

---

Queryable Attributes

QueryExecutionId

The unique identifier for each query execution.

Accessible with the following methods

Method	Description
GET_QUERYEXECUTIONID()	Getter for QUERYEXECUTIONID, with configurable default
ASK_QUERYEXECUTIONID()	Getter for QUERYEXECUTIONID w/ exceptions if field has no va
HAS_QUERYEXECUTIONID()	Determine if QUERYEXECUTIONID has a value

Query

The SQL query statements which the query execution ran.

Accessible with the following methods

Method	Description
GET_QUERY()	Getter for QUERY, with configurable default
ASK_QUERY()	Getter for QUERY w/ exceptions if field has no value
HAS_QUERY()	Determine if QUERY has a value

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.

Accessible with the following methods

Method	Description
GET_STATEMENTTYPE()	Getter for STATEMENTTYPE, with configurable default
ASK_STATEMENTTYPE()	Getter for STATEMENTTYPE w/ exceptions if field has no value
HAS_STATEMENTTYPE()	Determine if STATEMENTTYPE has a value

ManagedQueryResultsConfiguration

The configuration for storing results in Athena owned storage, which includes whether this feature is enabled; whether encryption configuration, if any, is used for encrypting query results.

Accessible with the following methods

Method	Description
GET_MANAGEDQUERYRESULTSCONF()	Getter for MANAGEDQUERYRESULTSCONF

ResultConfiguration

The location in Amazon S3 where query and calculation results are stored and the encryption option, if any, used for query results. These are known as "client-side settings". If workgroup settings override client-side settings, then the query uses the location for the query results and the encryption configuration that are specified for the workgroup.

Accessible with the following methods

Method	Description
GET_RESULTCONFIGURATION()	Getter for RESULTCONFIGURATION

ResultReuseConfiguration

Specifies the query result reuse behavior that was used for the query.

Accessible with the following methods

Method	Description
GET_RESULTREUSECONFIGURATION()	Getter for RESULTREUSECONFIGURATION

QueryExecutionContext

The database in which the query execution occurred.

Accessible with the following methods

Method	Description
GET_QUERYEXECUTIONCONTEXT()	Getter for QUERYEXECUTIONCONTEXT

Status

The completion date, current state, submission time, and state change reason (if applicable) for the query execution.

Accessible with the following methods

Method	Description
GET_STATUS()	Getter for STATUS

Statistics

Query execution statistics, such as the amount of data scanned, the amount of time that the query took to process, and the type of statement that was run.

Accessible with the following methods

Method	Description
GET_STATISTICS()	Getter for STATISTICS

WorkGroup

The name of the workgroup in which the query ran.

Accessible with the following methods

Method	Description
GET_WORKGROUP()	Getter for WORKGROUP, with configurable default
ASK_WORKGROUP()	Getter for WORKGROUP w/ exceptions if field has no value
HAS_WORKGROUP()	Determine if WORKGROUP has a value

EngineVersion

The engine version that executed the query.

Accessible with the following methods

Method	Description
GET_ENGINEVERSION()	Getter for ENGINEVERSION

ExecutionParameters

A list of values for the parameters in a query. The values are applied sequentially to the parameters in the query in the order in which the parameters occur. The list of parameters is not returned in the response.

Accessible with the following methods

Method	Description
GET_EXECUTIONPARAMETERS()	Getter for EXECUTIONPARAMETERS, with configurable default
ASK_EXECUTIONPARAMETERS()	Getter for EXECUTIONPARAMETERS w/ exceptions if field has no
HAS_EXECUTIONPARAMETERS()	Determine if EXECUTIONPARAMETERS has a value

SubstatementType

The kind of query statement that was run.

Accessible with the following methods

Method	Description
GET_SUBSTATEMENTTYPE()	Getter for SUBSTATEMENTTYPE, with configurable default
ASK_SUBSTATEMENTTYPE()	Getter for SUBSTATEMENTTYPE w/ exceptions if field has no va
HAS_SUBSTATEMENTTYPE()	Determine if SUBSTATEMENTTYPE has a value

QueryResultsS3AccessGrantsConfiguration

Specifies whether Amazon S3 access grants are enabled for query results.

Accessible with the following methods

Method	Description
GET_QUERYRSSS3ACCGRANTSCONF()	Getter for QUERYRESULTSS3ACCGRANTSCONF

Public Local Types In This Class

Internal table types, representing arrays and maps of this class, are defined as local types:

TT_QUERYEXECUTIONLIST

TYPES TT_QUERYEXECUTIONLIST TYPE STANDARD TABLE OF REF TO /AWS1/CL_ATHQUERYEXECUTION WITH DEFAULT KEY
.