404

[ Avaa Bypassed ]




Upload:

Command:

botdev@3.149.253.148: ~ $
**To  list the metadata for tables in the specified database of a data catalog**

The following ``list-table-metadata`` example returns metadata information for a maximum of two tables in the ``geography`` database of the ``AwsDataCatalog`` data catalog. ::

    aws athena list-table-metadata \
        --catalog-name AwsDataCatalog \
        --database-name geography \
        --max-items 2

Output::

    {
        "TableMetadataList": [
            {
                "Name": "country_codes",
                "CreateTime": 1586553454.0,
                "TableType": "EXTERNAL_TABLE",
                "Columns": [
                    {
                        "Name": "country",
                        "Type": "string",
                        "Comment": "geo id"
                    },
                    {
                        "Name": "alpha-2 code",
                        "Type": "string",
                        "Comment": "geo id2"
                    },
                    {
                        "Name": "alpha-3 code",
                        "Type": "string",
                        "Comment": "state name"
                    },
                    {
                        "Name": "numeric code",
                        "Type": "bigint",
                        "Comment": ""
                    },
                    {
                        "Name": "latitude",
                        "Type": "bigint",
                        "Comment": "location (latitude)"
                    },
                    {
                        "Name": "longitude",
                        "Type": "bigint",
                        "Comment": "location (longitude)"
                    }
                ],
                "Parameters": {
                    "areColumnsQuoted": "false",
                    "classification": "csv",
                    "columnsOrdered": "true",
                    "delimiter": ",",
                    "has_encrypted_data": "false",
                    "inputformat": "org.apache.hadoop.mapred.TextInputFormat",
                    "location": "s3://awsdoc-example-bucket/csv/countrycode",
                    "outputformat": "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat",
                    "serde.param.field.delim": ",",
                    "serde.serialization.lib": "org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe",
                    "skip.header.line.count": "1",
                    "typeOfData": "file"
                }
            },
            {
                "Name": "county_populations",
                "CreateTime": 1586553446.0,
                "TableType": "EXTERNAL_TABLE",
                "Columns": [
                    {
                        "Name": "id",
                        "Type": "string",
                        "Comment": "geo id"
                    },
                    {
                        "Name": "country",
    
                        "Name": "id2",
                        "Type": "string",
                        "Comment": "geo id2"
                    },
                    {
                        "Name": "county",
                        "Type": "string",
                        "Comment": "county name"
                    },
                    {
                        "Name": "state",
                        "Type": "string",
                        "Comment": "state name"
                    },
                    {
                        "Name": "population estimate 2018",
                        "Type": "string",
                        "Comment": ""
                    }
                ],
                "Parameters": {
                    "areColumnsQuoted": "false",
                    "classification": "csv",
                    "columnsOrdered": "true",
                    "delimiter": ",",
                    "has_encrypted_data": "false",
                    "inputformat": "org.apache.hadoop.mapred.TextInputFormat",
                    "location": "s3://awsdoc-example-bucket/csv/CountyPopulation",
                    "outputformat": "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat",
                    "serde.param.field.delim": ",",
                    "serde.serialization.lib": "org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe",
                    "skip.header.line.count": "1",
                    "typeOfData": "file"
                }
            }
        ],
        "NextToken": "eyJOZXh0VG9rZW4iOiBudWxsLCAiYm90b190cnVuY2F0ZV9hbW91bnQiOiAyfQ=="
    }

For more information, see `Showing Metadata for All Tables in a Database: list-table-metadata <https://docs.aws.amazon.com/athena/latest/ug/datastores-hive-cli.html#datastores-hive-cli-showing-all-table-metadata>`__ 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