Yahoo India Web Search

Sign In

Search results

  1. People also ask

  2. Videos

    View all

  3. docs.aws.amazon.com › athena › latestWhat is Amazon Athena? - Amazon Athena - docs.aws.amazon.com

    Sep 13, 2024 · Amazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon Simple Storage Service (Amazon S3) using standard SQL. With a few actions in the AWS Management Console, you can point Athena at your data stored in Amazon S3 and begin using standard SQL to run ad-hoc queries and get results in seconds.

    • SQL

      Learn about the DML and DDL statements used in Athena SQL....

    • Setting Up

      Attach managed policies for Athena. Athena managed policies...

  4. aws.amazon.com › blogs › big-dataAnalyzing Data in S3 using Amazon Athena

    • Creating Tables
    • Partitioning Data
    • Converting Data to Columnar Formats
    • Summary

    If you are familiar with Apache Hive, you may find creating tables on Athena to be familiar. You can create tables by writing the DDL statement on the query editor, or by using the wizard or JDBC driver. Copy and paste the following DDL statement in the Athena query editor to create a table. Note the regular expression specified in the CREATE TABLE...

    See full list on aws.amazon.com

    Customers often store their data in time-series formats and need to query specific items within a day, month, or year. Without a partition, Athena scans the entire table while executing queries. With partitioning, you can restrict Athena to specific partitions, thus reducing the amount of data scanned, lowering costs, and improving performance. Ath...

    See full list on aws.amazon.com

    Athena allows you to use open source columnar formats such as Apache Parquet and Apache ORC. Converting your data to columnar formats not only helps you improve query performance, but also save on costs. There are several ways to convert data into columnar format. In this post, you can take advantage of a PySpark script, about 20 lines long, runnin...

    See full list on aws.amazon.com

    Amazon Athena allows you to analyze data in S3 using standard SQL, without the need to manage any infrastructure. You can also access Athena via a business intelligence tool, by using the JDBC driver. Athena charges you on the amount of data scanned per query. As was evident from this post, converting your data into open source formats not only all...

    See full list on aws.amazon.com

  5. www.lastweekinaws.com › blog › what-is-amazon-athenaWhat is Amazon Athena? An Introduction and Walkthrough

    Apr 23, 2021 · How does Athena work? You start with data stored as objects in S3. Data can be in a variety of structured or semi-structured formats, including plaintext files like CSV and JSON, application and AWS service logs, and columnar files like Apache Parquet and Apache ORC .

  6. www.pluralsight.com › resources › blogAmazon Athena, Explained: What is it, and When ... - Pluralsight

    Sep 11, 2023 · Amazon Athena is an ANSI-standard query tool that allows you to query data, including big data, in two straightforward steps: Connecting directly to data sources such as Amazon Simple Storage Service (S3) Using the AWS intuitive GUI option or the command line to interactively query data using the Structured Query Language (SQL)

  7. www.cloudzero.com › blog › aws-athenaWhat Is AWS Athena? Here’s Everything You Need To Know

    Aug 28, 2023 · What Does Amazon Athena Do? AWS Athena is best described as an interactive query service that’s capable of seamlessly using standard Structured Query Language (SQL) to analyze data stored in the Amazon Simple Storage Service (Amazon S3).

  8. aws.amazon.com › athena › featuresAmazon Athena Features – Serverless Interactive Query Service ...

    Amazon Athena is an interactive query service that makes it simple to analyze data directly in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to setup or manage, and you can choose to pay based on the queries you run or compute needed by your queries.

  9. www.geeksforgeeks.org › aws-athenaGuide to AWS Athena: Create, Manage, and Optimize Costs

    Jun 3, 2024 · Athena is based on Presto, a distributed SQL query engine, and it can query data in Amazon S3 fast using conventional SQL syntax. There is no infrastructure to handle with Athena, so you can focus on analyzing data at scale. To have more idea of AWS Ethena, let us understand the architecture first.