Top "Amazon-athena" questions

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

Converting Unix epoch time to extended ISO8601

I have 3 tables I would like to work on using the date, however one of the tables includes the date …

datetime hadoop presto amazon-athena
How to pivot rows into columns in AWS Athena?

I'm new to AWS Athena and trying to pivot some rows into columns, similar to the top answer in this …

sql amazon-web-services pivot amazon-athena
Unnesting in SQL (Athena): How to convert array of structs into an array of values plucked from the structs?

I am taking samples from a Bayesian statistical model, serializing them with Avro, uploading them to S3, and querying them …

sql row avro amazon-athena unnest
AWS Athena create table and partition

I stored my sensor data in S3 (write data every 5 minutes): farm_iot/sensor_data/farm/farm0001/sensor01/1541252701443 1541252701443 is a …

amazon-web-services amazon-s3 hive amazon-athena
Add a partition on glue table via API on AWS?

I have an S3 bucket which is constantly being filled with new data, I am using Athena and Glue to …

amazon-web-services amazon-s3 amazon-athena aws-glue
use SQL inside AWS Glue pySpark script

I want to use AWS Glue to convert some csv data to orc. The ETL job I created generated the …

amazon-web-services pyspark pyspark-sql amazon-athena aws-glue
AWS Glue issue with double quote and commas

I have this CSV file: reference,address V7T452F4H9,"12410 W 62TH ST, AA D" The following options are …

hadoop hive presto amazon-athena aws-glue
Athena query fails with boto3 (S3 location invalid)

I'm trying to execute a query in Athena, but it fails. Code: client.start_query_execution(QueryString="CREATE DATABASE IF …

python amazon-s3 boto3 amazon-athena