MySQL date_format( date, '%Y-%m-%d %h') as `day-hour` equivalent in Presto

Presto: Extract values from a string column, which is similar to map, but not a map

SQL to find IDs which never had a column value

Presto LDAP Integration

Presto array contains value from another column (Superset SQL Query)

Prometheus Presto-Exporter Configuration on Kubernetes

How to deal with a column that has varchar values as well as large numbers that show up as scientific format?

How to transpose result?

Trying to deploy Presto and the page wont load when i try to access the console

Presto - how is there an alternative to to_char like postgresql?

How to convert data into this form in SQL :

Presto, encode array of integers into binary and loading as byte string

Convert YYYYMMDD to day in presto/hive

Presto query: Find the key with maximum value in a map

Group by from the elements of array in AWS Athena

Amazon Athena: How to drop all partitions at once

convert yyyyMMdd string into datetime in apache presto

How to distribute a file across presto cluster in kuebernetes

Assistance in refreshing data in athena table

athena presto - multiple columns from long to wide

Week starting date from date in an older version of Presto

Group time period within a time period based on majority of duration

Presto + Error opening Hive split when running presto query’s

How to divide two aggregates to get a percentage

What is best way join 2 table?

How to convert a varchar datetime to timestamp in Athena (Presto)?

How to increase query execution time of Presto in Spark

Presto / AWS Athena : create Array of different types inside the SELECT

How to use case statements to return different pulls in sql?

Converting time stored as INT to VARCHAR in Presto

Presto LDAP Authentication

Extract values from json_array in Athena

extract text between = and & using regex in presto sql

Getting date from String in Presto SQL

In SQL, is there a way to split up a column in SQL that is stored as a list?

Selecting decimal(17,4) column from hive throws error in presto

QuickSight could not generate any output column after applying transformation Error

How Apache Presto Verifier works?

How to work with a monthly interval of the last month in Athena (Presto)?

force presto execute sql fragment (a view with where conditions ) in target database

Get value from a dictionary string in Athena query

Which query is best in join tables by datediff?

SQL aggregation, get string value from column

sql; concatenate MIN(price) and MAX(price) into column?

aws athena SQL query; get unique count of column2 for each unique column1

split a file path into its constituent paths in Hive/Presto

Presto query: UNNEST a column which is of ARRAY type

How to calculate percentage of total in Athena (Presto)?

Presto throw "Document does not contain key clusterTime" for every MongoDB query

Allocation via SQL - Retaining repeating decimals for the sum()

Presto SQL / Athena: select between times across different days

Athena/Presto SQL aggregate information for each day on historical data

Extract Json in Presto

How to convert String to date in Presto SQL engine?

SQL — take Top 3 values from GROUP BY

Is there a way to create a date or timestamp output column from a varchar

How to convert varchar unixcode to a timestamp in SQL

Query existing (partioned) Avro files with Presto

Perform SQL queries on Avro files

how to show comment in presto after creating a table?

Nodejs Stream routing to S3 from Presto

Presto/Spark SQL skip partition on reading 1 row instead of whole partitions

Athena/Presto - UNNEST MAP to columns

Effective way To use Count and JOIN in PRESTO CASE statements

Effective way in PRESTO to Result output with Boolean values

Presto equivalent of CONCAT_WS

Presto change current catalog

SQL — get all rows where column A's date is a multiple of 7 days apart from column B's date

SQL - Group two rows by columns that value and null on different columns

Convert column of arrays to table of K,V pairs in Presto

SQL - subtract items in column from each other, based on ranking in 2nd column and aggregated by a 3rd column

Presto RestAPI with OpenID

ODBC driver options for Presto?

SQL - RANK() with multiple WHERE and GROUP BY

Select column value and next highest column value in SQL

SQL Session ID generation by two columns

Display purchase_date for each product_id that exists in both stores

how to format number separated by comma for every three integer digits in presto

Ignore numeric values in string, Presto

Presto odbc failing to read timestamp fileds in HIVE

Is there a way to group by part of a datetime column in SQL?

How to format a number as percentage with 2 decimal places in Presto?

Converting string to timestamp issues sql

How to deal with a column that has just date (%m-%d-%Y) and datetime ('%m-%d-%Y %H:%i') records in the same column in AWS Athena?

SQL: find records whose given field has different string values in consecutive days

how to convert TIMESTAMP WITH TIMEZONE to TIMESTAMP but keeping local time in SQL

AWS Athena (Presto) how to transpose map to columns

anyway to configure a URL prefix for prestosql web UI

CROSS APPLY function in Presto/AWS

Presto Unnest varchar array field

Aggregate by week using (Sun - Sat)

How to successfully convert string to date type in AWS Athena?

Is there a way to sort output data in SQL using custom groupings?

How to get Continuous date in Presto with start date in one column and end date in another column

Using Presto HLL to count rolling wau, mau

How convert rows to map in presto?

How can I use the most recent exchange rate date when the exchange rate dates are blank?

How to interpolate Time series data using Linear interpolation on big datasets in Presto?

Convert flat JSON structure to table

Conversion of timestamp/varchar column to bigint in presto which contains two different date formats