404

[ Avaa Bypassed ]




Upload:

Command:

botdev@3.136.11.217: ~ $
**To return metadata information about a table**

The following ``get-table-metadata`` example returns metadata information about the ``counties`` table, including  including column names and their datatypes, from the ``sampledb`` database of the ``AwsDataCatalog`` data catalog. ::

    aws athena get-table-metadata \
        --catalog-name AwsDataCatalog \
        --database-name sampledb \
        --table-name counties

Output::

    {
        "TableMetadata": {
            "Name": "counties",
            "CreateTime": 1593559968.0,
            "LastAccessTime": 0.0,
            "TableType": "EXTERNAL_TABLE",
            "Columns": [
                {
                    "Name": "name",
                    "Type": "string",
                    "Comment": "from deserializer"
                },
                {
                    "Name": "boundaryshape",
                    "Type": "binary",
                    "Comment": "from deserializer"
                },
                {
                    "Name": "motto",
                    "Type": "string",
                    "Comment": "from deserializer"
                },
                {
                    "Name": "population",
                    "Type": "int",
                    "Comment": "from deserializer"
                }
            ],
            "PartitionKeys": [],
            "Parameters": {
                "EXTERNAL": "TRUE",
                "inputformat": "com.esri.json.hadoop.EnclosedJsonInputFormat",
                "location": "s3://awsdoc-example-bucket/json",
                "outputformat": "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat",
                "serde.param.serialization.format": "1",
                "serde.serialization.lib": "com.esri.hadoop.hive.serde.JsonSerde",
                "transient_lastDdlTime": "1593559968"
            }
        }
    }

For more information, see `Showing Table Details: get-table-metadata <https://docs.aws.amazon.com/athena/latest/ug/datastores-hive-cli.html#datastores-hive-cli-showing-details-of-a-table>`__ 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