Top "Presto" questions

Presto is an open source distributed SQL query engine for running analytic queries against data sources of all sizes ranging from gigabytes to petabytes.

Presto: cast array<struct<key:string,value:array<string>>> into map<string,array<string>>

I have a table like name string address string timezone string one_key_value array<struct<key:string,…

sql hive presto
How to cast varchar to MAP(VARCHAR,VARCHAR) in presto

I have table in presto, one column named ("mappings") have key-value pair as string select mappings from hello; Ex: {"foo": "…

cassandra presto
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
Turn Presto columns to rows via rotation

This is the desired input and desired output. I'm unfamiliar with the terms used in SQL or Presto and the …

sql string pivot presto
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