Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in presto

Parameterized SQL in Presto on Presto CLI

presto trino

Reference to a field of a row object

presto trino

Get specific values from JSON column in Presto

How to extract only the hour from a timestamp in sql?

sql presto

Does Trino (formerly Presto) INSERT work with CTEs?

presto trino

How to exclude items from search using NOT LIKE and % in Presto SQL?

sql presto

query to remove everything between 1st and 2nd hypen for string in column

sql postgresql psql presto

Getting day of week from date column in prestosql?

Convert array(double) to varchar in Presto

sql presto trino

Presto (Athena) loading of a CSV file with quote-escaped commas

csv amazon-athena presto

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

sql json presto amazon-athena

Presto query: UNNEST a column which is of ARRAY type

sql presto

How to check Trino version with SQL query?

sql version presto trino

UNNEST returns no rows for empty array

How can I hash a string to a bigint in presto?

hash presto varbinary trino

How to find peak and valley in running sequence in sql

sql amazon-athena presto

Presto Unnest varchar array field

sql arrays presto unnest

AWS Athena (Presto) - multiple WITH statements