Top "Amazon-athena" questions

Amazon Athena is a service for running SQL queries against data stored on Amazon S3.

How to Create Dataframe from AWS Athena using Boto3 get_query_results method

I'm using AWS Athena to query raw data from S3. Since Athena writes the query output into S3 output bucket …

python pandas amazon-web-services dataframe amazon-athena
Athena vs Redshift Spectrum

I am kind of evaluating Athena & Redshift Spectrum. Both serve the same purpose, Spectrum needs a Redshift cluster in …

amazon-web-services amazon-redshift amazon-athena amazon-redshift-spectrum
Nested Query Alternatives in AWS Athena

I am running a query that gives a non-overlapping set of first_party_id's - ids that are associated with …

sql amazon-web-services presto amazon-athena
Split one row into multiple rows based on comma-separated string column

I have a table like below with columns A(int) and B(string): A B 1 a,b,c 2 d,e 3 …

sql amazon-athena presto
Athena: Query exhausted resources at scale factor

I am running a query like: SELECT f.*, p.countryName, p.airportName, a.name AS agentName FROM ( SELECT f.outboundlegid, …

sql amazon-web-services query-optimization amazon-athena presto
How to read quoted CSV with NULL values into Amazon Athena

I'm trying to create an external table in Athena using quoted CSV file stored on S3. The problem is, that …

amazon-athena
random sample of size N in Athena

I'm trying to obtain a random sample of N rows from Athena. But since the table from which I want …

presto amazon-athena
How to Query parquet data from Amazon Athena?

Athena creates a temporary table using fields in S3 table. I have done this using JSON data. Could you help …

amazon-web-services parquet amazon-athena
Athena date_parse for date with optional millisecond field

I have date in S3 using which I created an Athena table. I have some date entries in S3 in …

sql amazon-athena presto
Amazon Athena - Column cannot be resolved on basic SQL WHERE query

I am currently evaluating Amazon Athena and Amazon S3. I have created a database (testdb) with one table (awsevaluationtable). The …

amazon-web-services amazon-s3 amazon-athena