Split Alphanumeric string using presto

Fill rows with previous data until new data occurs

AWS Athena: Handling big numbers

How to optimize your Presto SQL Query that contains 13 CTEs using the WITH clause?

Unable to connect port 8080 in presto-cli

LIKE or REGEX trouble

How to "transpose" date data into columns in SQL?

Presto: Time difference in minutes between two timestamps only for working hours

Presto: I have a column in the same table as the data which specifies the time zone I want to offset my dates to

Merging similar Athena (Presto) queries

When using Presto to read TPCH table stored as Parquet format, Presto says column type is incorrect

Reset a cumulative sum (w/o aprior knowledge of reset points) in SQL

SQL: Crosstab equivalent in Presto

array_intersect giving performance issue in presto

Extract negative integers from JSON

SQL: Select rows if it fuzzy matches with corresponding column

sql window function not giving me the right output

Athena DateDiff

How to fix full outer join of two tables when not all values exist in both tables

How to store UTC datetime/timestamp and time zone in Presto for easy local time conversion?

How do I convert a sequence file to parquet format

Presto / MySQL - Regex to check column values are alphanumeric or not

Presto convert a timestamp without time zone to epoch

Athena sub-query and LEFT JOIN data scanned optimization

how i can make left join work only when the number of records in the first table more or equal the number of records in the second table?

Count length of consecutive duplicate values for each id

Access denied - EMR Presto - File Based Authorization

How to query ambiguous data types in Athena?

Unable to write Spark's DataFrame to hive using presto

Presto: Removing last element from variable length array

Case when statement not working as an aggregate expression

How do you check what version of Presto you are using?

Presto with Spring Boot

Filter sql records based on a json stored as string value in a column?

Setting up presto server on mac os locally not accessible in localhost

Pyhive Presto insert select * from not running

How to convert seconds as int to HHH:MM:SS format in SQL (presto)?

How to format seconds as integer into HH:MM:SS in Presto

how i can set null values in left join in presto with the max values from the right joined table

Why do I always get 0 records as output while reading from dtap:// hive table in Presto?

Percentage calculation from another column sql / presto

Creating pivot table to show counts and add missing months as columns

Presto: Convert vachar to datetime 2019-03-01 08:13:50,704

How to write local orc file using Presto

How is deprecated.legacy-timestamp supposed to work in Presto 0.220?

cast and left functions in Athena

Extracting from Json in AWS Athena or Presto

What is the option for presto to map multiple row to single file in S3?

How to create Hive table with Azure WASB storage using account and account-key?

Presto query performance via Hue on AWS EMR

how to transfer column names to replace the number in the colums in presto

How to iterate over Presto ARRAY(MAP(VARCHAR, VARCHAR))

Compare same column by different partition dates

Interpolating missing values in SQL

Pivot in aws athena

Amazon Athena Query Avro Data

How to query json file located at s3 using presto

In Athena how do I query a member of a struct in an array in a struct?

How call date_trunc function in amazon Athena?

Geospatial Clustering using Presto

Array of arrays to column in Presto

How do I use rpresto to connect to a database using https?

Querying struct fields from AWS Athena/Presto

Convert date in string format to date data type

Using Array data type in Vertica

Insert overwrite directory using Presto like Hive

Multiple columns returned by subquery are not yet supported

Aggregation with limited time range from another table presto

How to determine number of days in a month in Presto?

How do I convert 20190801 to Aug-2019

Not able to read column from Presto with datatype ROW

Sum of values for distinct pairs (order independent) and nodes in Presto

Apply decreasing rate to SQL gaps and islands problem

Regular expression to get a string between two strings in Javascript based regex from Presto. The 2 strings are bookended by quotes

Presto sql case if- can I choose just a few case and have the original output for other results?

Athena unnest json array of string within another json array of structs

How to extract nested JSON objects in presto?

Fastest way to add column at runtime that is same for all rows in AWS Athena / SQL

Presto MySQL Connector: 'DROP TABLE is disabled in this catalog'

Understanding query execution time in Presto

How to merge rows by a similar column via levenshtein distance

How to take substring before "," or "-" or " "?

How to make up a column with select in sql

Parse JSON from Presto varchar column fails

presto + all presto machines failes on No service providers of type io.prestosql.spi.Plugin

Retrieving bucketting value in WITH statement for subsequent SELECT

Getting day of week from date column in prestosql?

Trying to feed the results from a subquery as a string into the main query

Two SQL queries take a lot of time difference in Presto

Athena: Rename columns while creating table from Json data

How to configure Apache Kafka with SSL in Presto

Equivalent of Hive Lateral view outer Explode in Athena (Presto) CROSS JOIN UNNEST

presto: convert array to rows?

AWS Glue (or Athena or Presto) - Changing Decimal Format

Presto - most current record before date

How to read bulk volume of data from database by using spring/java

AWS Athena SELECT * not allowed in queries without FROM clause

Vlookup equilivant in presto sql

How to execute multiple statements in Presto?

How to increment timestamp using number of seconds from another column in Presto?