Top "Presto" questions

Presto equivalent of MySQL group_concat

I'm new to Presto and looking to get the same functionality as the group_concat function in MySQL. Are the …

mysql presto group-concat trino

How to cross join unnest a JSON array in Presto

Given a table that contains a column of JSON like this: {"payload":[{"type":"b","value":"9"}, {"type":"a","value":"8"}]} {"payload":[{"type":"…

json hadoop hive presto

How to get date_diff from previous rows in Presto?

I'm trying to get a diff_date from Presto from this data. timespent | 2016-04-09T00:09:07.232Z | 1000 | general timespent | 2016-04…

sql presto

How to export result of select statement in prestodb.io

Two things. How can I execute an sql statement without "presto-cli-0.56-executable.jar", for example I want to provide a …

presto

Presto create table with 'with' queries

typically to create a table in Presto (from existing db tables), I do: create table abc as ( select... ) But to …

sql presto

Amazon Athena - Converting Timestamp to Date?

Looking at the Date/Time Athena documentation, I don't see a function to do this, which surprises me. The closest …

sql amazon-athena presto

Presto array contains an element that likes some pattern

For example, one column in my table is an array, I want to check if that column contains an element …

sql presto

LATERAL VIEW EXPLODE in presto

New to presto, any pointer how can I use LATERAL VIEW EXPLODE in presto for below table. I need to …

amazon-web-services hive cloud presto trino

Checking if a map or array is empty in Presto?

How do I check if a map has no keys in Presto? If I have a way to check if …

sql presto

Issues with JSON_EXTRACT in Presto for keys containing ' ' character

I'm using Presto(0.163) to query data and am trying to extract fields from a json. I have a json like …

sql presto