404

[ Avaa Bypassed ]




Upload:

Command:

botdev@3.136.11.217: ~ $
**To return the results of a query**

The following ``get-query-results`` example returns the results of the query that has the specified query ID. ::

    aws athena get-query-results \
        --query-execution-id a1b2c3d4-5678-90ab-cdef-EXAMPLE11111

Output::

    {
        "ResultSet": {
            "Rows": [
                {
                    "Data": [
                        {
                            "VarCharValue": "date"
                        },
                        {
                            "VarCharValue": "location"
                        },
                        {
                            "VarCharValue": "browser"
                        },
                        {
                            "VarCharValue": "uri"
                        },
                        {
                            "VarCharValue": "status"
                        }
                    ]
                },
                {
                    "Data": [
                        {
                            "VarCharValue": "2014-07-05"
                        },
                        {
                            "VarCharValue": "SFO4"
                        },
                        {
                            "VarCharValue": "Safari"
                        },
                        {
                            "VarCharValue": "/test-image-2.jpeg"
                        },
                        {
                            "VarCharValue": "200"
                        }
                    ]
                },
                {
                    "Data": [
                        {
                            "VarCharValue": "2014-07-05"
                        },
                        {
                            "VarCharValue": "SFO4"
                        },
                        {
                            "VarCharValue": "Opera"
                        },
                        {
                            "VarCharValue": "/test-image-2.jpeg"
                        },
                        {
                            "VarCharValue": "200"
                        }
                    ]
                },
                {
                    "Data": [
                        {
                            "VarCharValue": "2014-07-05"
                        },
                        {
                            "VarCharValue": "SFO4"
                        },
                        {
                            "VarCharValue": "Firefox"
                        },
                        {
                            "VarCharValue": "/test-image-3.jpeg"
                        },
                        {
                            "VarCharValue": "200"
                        }
                    ]
                },
                {
                    "Data": [
                        {
                            "VarCharValue": "2014-07-05"
                        },
                        {
                            "VarCharValue": "SFO4"
                        },
                        {
                            "VarCharValue": "Lynx"
                        },
                        {
                            "VarCharValue": "/test-image-3.jpeg"
                        },
                        {
                            "VarCharValue": "200"
                        }
                    ]
                },
                {
                    "Data": [
                        {
                            "VarCharValue": "2014-07-05"
                        },
                        {
                            "VarCharValue": "SFO4"
                        },
                        {
                            "VarCharValue": "IE"
                        },
                        {
                            "VarCharValue": "/test-image-2.jpeg"
                        },
                        {
                            "VarCharValue": "200"
                        }
                    ]
                },
                {
                    "Data": [
                        {
                            "VarCharValue": "2014-07-05"
                        },
                        {
                            "VarCharValue": "SFO4"
                        },
                        {
                            "VarCharValue": "Opera"
                        },
                        {
                            "VarCharValue": "/test-image-1.jpeg"
                        },
                        {
                            "VarCharValue": "200"
                        }
                    ]
                },
                {
                    "Data": [
                        {
                            "VarCharValue": "2014-07-05"
                        },
                        {
                            "VarCharValue": "SFO4"
                        },
                        {
                            "VarCharValue": "Chrome"
                        },
                        {
                            "VarCharValue": "/test-image-3.jpeg"
                        },
                        {
                            "VarCharValue": "200"
                        }
                    ]
                },
                {
                    "Data": [
                        {
                            "VarCharValue": "2014-07-05"
                        },
                        {
                            "VarCharValue": "SFO4"
                        },
                        {
                            "VarCharValue": "Firefox"
                        },
                        {
                            "VarCharValue": "/test-image-2.jpeg"
                        },
                        {
                            "VarCharValue": "200"
                        }
                    ]
                },
                {
                    "Data": [
                        {
                            "VarCharValue": "2014-07-05"
                        },
                        {
                            "VarCharValue": "SFO4"
                        },
                        {
                            "VarCharValue": "Chrome"
                        },
                        {
                            "VarCharValue": "/test-image-3.jpeg"
                        },
                        {
                            "VarCharValue": "200"
                        }
                    ]
                },
                {
                    "Data": [
                        {
                            "VarCharValue": "2014-07-05"
                        },
                        {
                            "VarCharValue": "SFO4"
                        },
                        {
                            "VarCharValue": "IE"
                        },
                        {
                            "VarCharValue": "/test-image-2.jpeg"
                        },
                        {
                            "VarCharValue": "200"
                        }
                    ]
                }
            ],
            "ResultSetMetadata": {
                "ColumnInfo": [
                    {
                        "CatalogName": "hive",
                        "SchemaName": "",
                        "TableName": "",
                        "Name": "date",
                        "Label": "date",
                        "Type": "date",
                        "Precision": 0,
                        "Scale": 0,
                        "Nullable": "UNKNOWN",
                        "CaseSensitive": false
                    },
                    {
                        "CatalogName": "hive",
                        "SchemaName": "",
                        "TableName": "",
                        "Name": "location",
                        "Label": "location",
                        "Type": "varchar",
                        "Precision": 2147483647,
                    "Data": [
    
                        "Scale": 0,
                        "Nullable": "UNKNOWN",
                        "CaseSensitive": true
                    },
                    {
                        "CatalogName": "hive",
                        "SchemaName": "",
                        "TableName": "",
                        "Name": "browser",
                        "Label": "browser",
                        "Type": "varchar",
                        "Precision": 2147483647,
                        "Scale": 0,
                        "Nullable": "UNKNOWN",
                        "CaseSensitive": true
                    },
                    {
                        "CatalogName": "hive",
                        "SchemaName": "",
                        "TableName": "",
                        "Name": "uri",
                        "Label": "uri",
                        "Type": "varchar",
                        "Precision": 2147483647,
                        "Scale": 0,
                        "Nullable": "UNKNOWN",
                        "CaseSensitive": true
                    },
                    {
                        "CatalogName": "hive",
                        "SchemaName": "",
                        "TableName": "",
                        "Name": "status",
                        "Label": "status",
                        "Type": "integer",
                        "Precision": 10,
                        "Scale": 0,
                        "Nullable": "UNKNOWN",
                        "CaseSensitive": false
                    }
                ]
            }
        },
        "UpdateCount": 0
    }

For more information, see `Working with Query Results, Output Files, and Query History <https://docs.aws.amazon.com/athena/latest/ug/querying.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