404

[ Avaa Bypassed ]




Upload:

Command:

botdev@3.16.139.76: ~ $
**To return information about one or more query executions**

The following ``batch-get-query-execution`` example returns query execution information for the queries that have the specified query IDs. ::

    aws athena batch-get-query-execution \
        --query-execution-ids a1b2c3d4-5678-90ab-cdef-EXAMPLE11111 a1b2c3d4-5678-90ab-cdef-EXAMPLE22222

Output::

    {
        "QueryExecutions": [
            {
                "QueryExecutionId": "a1b2c3d4-5678-90ab-cdef-EXAMPLE11111",
                "Query": "create database if not exists webdata",
                "StatementType": "DDL",
                "ResultConfiguration": {
                    "OutputLocation": "s3://awsdoc-example-bucket/a1b2c3d4-5678-90ab-cdef-EXAMPLE11111.txt"
                },
                "QueryExecutionContext": {},
                "Status": {
                    "State": "SUCCEEDED",
                    "SubmissionDateTime": 1593470720.592,
                    "CompletionDateTime": 1593470720.902
                },
                "Statistics": {
                    "EngineExecutionTimeInMillis": 232,
                    "DataScannedInBytes": 0,
                    "TotalExecutionTimeInMillis": 310,
                "ResultConfiguration": {
    
                    "QueryQueueTimeInMillis": 50,
                    "ServiceProcessingTimeInMillis": 28
                },
                "WorkGroup": "AthenaAdmin"
            },
            {
                "QueryExecutionId": "a1b2c3d4-5678-90ab-cdef-EXAMPLE22222",
                "Query": "select date, location, browser, uri, status from cloudfront_logs where method = 'GET' and status = 200 and location like 'SFO%' limit 10",
                "StatementType": "DML",
                "ResultConfiguration": {
                    "OutputLocation": "s3://awsdoc-example-bucket/a1b2c3d4-5678-90ab-cdef-EXAMPLE22222.csv"
                },
                "QueryExecutionContext": {
                    "Database": "mydatabase",
                    "Catalog": "awsdatacatalog"
                },
                "Status": {
                    "State": "SUCCEEDED",
                    "SubmissionDateTime": 1593469842.665,
                    "CompletionDateTime": 1593469846.486
                },
                "Statistics": {
                    "EngineExecutionTimeInMillis": 3600,
                    "DataScannedInBytes": 203089,
                    "TotalExecutionTimeInMillis": 3821,
                    "QueryQueueTimeInMillis": 267,
                    "QueryPlanningTimeInMillis": 1175
                },
                "WorkGroup": "AthenaAdmin"
            }
        ],
        "UnprocessedQueryExecutionIds": []
    }

For more information, see `Running SQL Queries Using Amazon Athena <https://docs.aws.amazon.com/athena/latest/ug/querying-athena-tables.html>`__ in the *Amazon Athena User Guide*.

Filemanager

Name Type Size Permission Actions
batch-get-named-query.rst File 2.07 KB 0644
batch-get-query-execution.rst File 2.86 KB 0644
create-data-catalog.rst File 710 B 0644
create-named-query.rst File 1.23 KB 0644
create-work-group.rst File 1.23 KB 0644
delete-data-catalog.rst File 457 B 0644
delete-named-query.rst File 450 B 0644
delete-work-group.rst File 444 B 0644
get-data-catalog.rst File 949 B 0644
get-database.rst File 796 B 0644
get-named-query.rst File 916 B 0644
get-query-execution.rst File 1.6 KB 0644
get-query-results.rst File 10.02 KB 0644
get-table-metadata.rst File 2.1 KB 0644
get-work-group.rst File 973 B 0644
list-data-catalogs.rst File 844 B 0644
list-databases.rst File 1.02 KB 0644
list-named-queries.rst File 636 B 0644
list-query-executions.rst File 1.15 KB 0644
list-table-metadata.rst File 4.8 KB 0644
list-tags-for-resource.rst File 1.64 KB 0644
list-work-groups.rst File 965 B 0644
start-query-execution.rst File 2.32 KB 0644
stop-query-execution.rst File 456 B 0644
tag-resource.rst File 790 B 0644
untag-resource.rst File 710 B 0644
update-data-catalog.rst File 739 B 0644
update-work-group.rst File 753 B 0644