Top "Amazon-athena" questions

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

AWS Glue: crawler misinterprets timestamps as strings. GLUE ETL meant to convert strings to timestamps makes them NULL

I have been playing around with AWS Glue for some quick analytics by following the tutorial here While I have …

amazon-web-services amazon-s3 amazon-athena aws-glue
Checking array in Athena

I have a table in Athena where one of the columns is of type array<string>. However, when …

arrays amazon-athena
Athena query results at specific path on S3

I am aware that running a saved Athena query stores results in an Amazon S3 location based on the name …

amazon-web-services amazon-s3 amazon-athena
How to delete / drop multiple tables in AWS athena?

I am trying to drop few tables from Athena and I cannot run multiple DROP queries at same time. Is …

amazon-web-services amazon-athena
Athena DateDiff

I am trying to do what I think is a simple date diff function but for some reason, my unit …

datediff presto amazon-athena
Amazon Athena and compressed S3 files

I have an S3 bucket with several zipped CSV files (utilization logs.) I'd like to query this data with Athena, …

amazon-web-services amazon-athena
Connecting with Athena using Python and pyathenajdbc

I am trying to connect to AWS Athena using python. I am trying to use pyathenajdbc to achieve this task. …

python amazon-web-services amazon-athena
SHOW PARTITIONS with order by in Amazon Athena

I have this query: SHOW PARTITIONS tablename; Result is: dt=2018-01-12 dt=2018-01-20 dt=2018-05-21 dt=2018-04…

amazon-athena
Offloading data files from Amazon Redshift to Amazon S3 in Parquet format

I would like to unload data files from Amazon Redshift to Amazon S3 in Apache Parquet format inorder to query …

amazon-redshift parquet amazon-athena amazon-redshift-spectrum
Duplicate results in an AWS Athena (Presto) DISTINCT SQL Query?

I have a bunch of files on S3 that contain just MD5s, one per line. I created an AWS …

hive duplicates presto amazon-athena