You can read more about the Amazon Athena service from Jeff’s blog post during the service release in November.Īfter releasing the initial features of the Amazon Athena service, the Athena team kept with the Amazon tradition of focusing on the customer by working diligently to make your customer experience with the service better. Additionally, by using the JDBC driver you can run queries programmatically from your desired BI tools. You can write Hive-compliant DDL statements and ANSI SQL statements in the Athena Query Editor from the AWS Management Console, from SQL clients such as SQL Workbench by downloading and taking advantage of the Athena JDBC driver.
Athena enables the performant query access to datasets stored in Amazon Simple Storage Service (S3) with structured and unstructured data formats. At Athena’s core is Presto, a distributed SQL engine to run queries with ANSI SQL support and Apache Hive which allows Athena to work with popular data formats like CSV, JSON, ORC, Avro, and Parquet and adds common Data Definition Language (DDL) operations like create, drop, and alter tables. A service that provides AWS customers the power to easily analyze and query large amounts of data stored in Amazon S3.Īmazon Athena is a serverless interactive query service that enables users to easily analyze data in Amazon S3 using standard SQL. This service is none other than Amazon Athena which I think of as a managed service that is attempting “to leap tall queries in a single bound” with querying of object storage. In November of last year, we brought a service to the market that we hoped would be a major step toward helping those who have the need to securely access and examine massive amounts of data on a daily basis.
0 kommentar(er)
