404

[ Avaa Bypassed ]




Upload:

Command:

botdev@3.136.11.217: ~ $
**To create a named query**

The following ``create-named-query`` example creates a saved query in the ``AthenaAdmin`` workgroup that queries the ``flights_parquet`` table for flights from Seattle to New York in January, 2016 whose departure and arrival were both delayed by more than ten minutes. Because the airport code values in the table are strings that include double quotes (for example, "SEA"), they are escaped by backslashes and surrounded by single quotes. ::

    aws athena create-named-query \
        --name "SEA to JFK delayed flights Jan 2016" \
        --description "Both arrival and departure delayed more than 10 minutes." \
        --database sampledb \
        --query-string "SELECT flightdate, carrier, flightnum, origin, dest, depdelayminutes, arrdelayminutes FROM sampledb.flights_parquet WHERE yr = 2016 AND month = 1 AND origin = '\"SEA\"' AND dest = '\"JFK\"' AND depdelayminutes > 10 AND arrdelayminutes > 10" \
        --work-group AthenaAdmin

Output::

    {
        "NamedQueryId": "a1b2c3d4-5678-90ab-cdef-EXAMPLE11111"
    }

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