aws-athena 命令

常用示例

说明

aws athena manages Amazon Athena, an interactive query service for analyzing data in Amazon S3 using standard SQL. Athena is serverless, requiring no infrastructure setup. Queries are executed asynchronously via start-query-execution, which returns a query execution ID. Use get-query-execution to check status and get-query-results to retrieve results once complete. Results are also stored in the specified S3 output location. Workgroups organize queries and control settings like result locations, encryption, and query limits. The --query-execution-context parameter specifies which database and data catalog to query against. Athena uses the AWS Glue Data Catalog to store table metadata, or you can use an external Hive metastore. Tables are created over data in S3 using DDL statements like CREATE EXTERNAL TABLE.

参数

start-query-execution

Execute a SQL query asynchronously

get-query-execution

Get information about a query execution

get-query-results

Retrieve results of a completed query

stop-query-execution

Cancel a running query

list-query-executions

List query execution IDs

list-databases

List databases in a data catalog

list-table-metadata

List tables in a database

create-work-group

Create a workgroup for queries

get-work-group

Get workgroup configuration

--query-string _sql_

SQL statement to execute

--query-execution-id _id_

Identifier of query execution

--work-group _name_

Workgroup to run the query in

--query-execution-context _context_

Database and catalog context (Database=db,Catalog=catalog)

--result-configuration _config_

Output location and encryption settings (OutputLocation=s3://path/)

--max-results _n_

Maximum results to return

--next-token _token_

Pagination token from a previous response

--catalog-name _name_

Data catalog to query (e.g., AwsDataCatalog)