|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/aws-athena/
课程评论：没有评论
课程名称：AWS Athena - 互动式SQL接口 课程概述：Amazon Athena是一种互动式查询服务，旨在利用标准SQL轻松分析存储在Amazon S3中的数据。Athena是无服务器的，用户无需管理基础设施，并且只需为实际运行的查询付费。在本课程中，您将学习以下内容： - 创建数据库 - 创建表 - 从文件创建表 - 从S3桶查询数据 - CTAS（创建表为选择） - 分区和桶 - 处理结构化、非结构化和半结构化数据 - 使用TEXTFILE、PARQUET、JSON、ORC和AVRO格式存储数据 Athena的使用非常简单，用户只需指向Amazon S3中的数据，定义模式，然后使用标准SQL开始查询。大多数查询结果在几秒钟内返回。借助Athena，无需复杂的ETL作业来准备分析数据，这使得具有SQL技能的任何人都能快速分析大规模数据集。 Athena与AWS Glue数据目录无缝集成，允许创建统一的元数据存储库，爬虫可以发现数据源的模式，并用新的和修改后的表及分区定义填充目录，以及维护架构版本管理。Amazon Athena使用Presto，支持ANSI SQL，并能处理多种标准数据格式，包括CSV、JSON、ORC、Avro和Parquet。Athena非常适合交互式查询，也可以处理复杂的分析，包括大联合、窗口函数和数组。 Amazon Athena具备高度可用性，执行查询时利用多个设施和每个设施中的多个设备的计算资源。Athena以Amazon S3作为其基础数据存储，使您的数据具有高度的可用性和耐用性。
Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.In this course you will work with,• Creating a database• Creating tables• Create table out of a file• Querying the data from S3 bucket• CTAS (Create Table As Select)• Partitions and Bucketing• Interact with structured, unstructured and semi structured data• Store the data in TEXTFILE, PARQUET, JSON, ORC and AVRO formats Athena is easy to use. Simply point to your data in Amazon S3, define the schema, and start querying using standard SQL. Most results are delivered within seconds. With Athena, there's no need for complex ETL jobs to prepare your data for analysis. This makes it easy for anyone with SQL skills to quickly analyze large-scale datasets.Athena is out-of-the-box integrated with AWS Glue Data Catalog, allowing you to create a unified metadata repository across various services, crawl data sources to discover schemas and populate your Catalog with new and modified table and partition definitions, and maintain schema versioning. Amazon Athena uses Presto with ANSI SQL support and works with a variety of standard data formats, including CSV, JSON, ORC, Avro, and Parquet. Athena is ideal for interactive querying and can also handle complex analysis, including large joins, window functions, and arrays. Amazon Athena is highly available; and executes queries using compute resources across multiple facilities and multiple devices in each facility. Amazon Athena uses Amazon S3 as its underlying data store, making your data highly available and durable.
