SQL query to get week number from date while setting week starting from Sunday


how to search between currentdate's fix time and interver -10days in presto

Presto integration with hive is not working

Amazon Athena table creation issue

Aggregate arrays element-wise in presto/athena

Athena geospatial SQL joins never complete

Why SQL query returns values that should be filtered out by condition in Presto?

Using Presto with custom SQL like DSL

convert '19th October 2018' into date in Presto/SQL

Is there a way to pull data-range in AWS Athena when the timestamp is big int using mySQL & PrestoDB?

prestodb - java.net.SocketTimeoutException: Read timed out when querying hive


Presto SQL - distinct in selective group by

is there any issue in select query after executing delete query in presto cli?

Presto Agents not showing up in Presto discovery UI

How to query hdfs file with presto

PRESTO SQL: How to query value in max datetime in each txn and fill other that not select to null value

SQL partially order results

How to convert list of comma separated Ids into their name?

SQL to get next monday in Presto

Force athena/presto to respect ordering of files from S3

failed: com.facebook.presto.spi.type.BigintType

Joining on a timestamp within 30 seconds of each other?

Cannot query a hive avro table with nested levels Presto

How to add two maps of key to values(array) together in Presto?

How to query nested fields in MongoDB using Presto

How to use a SQL variable and iterate through unique values?

32- or 64-bits float division with PrestoSQL

Use user login credentials as default credential with Apache Zeppelin

Presto/SQL find next value that meets a condition

Is there a unique row indentifier in Presto SQL?

Cast fixed date into multiple time zones

Presto - Calculating TP90 on daily basis

Amazon Athena partition with colon(:) is not working

AWS Athena: extract and partition by value of a field from array of JSON records

Presto: how to specify time interval using the current date and timezone

Is there any way to apply loop in a presto query

How to extract day/month/year etc from varchar date field, using Presto?

Presto query to exclude rows based on the value in a specific column

Array of JSON in Athena is read incorrectly and can't be unnested

Comparison query on nested date partition in Presto/Athena

NOT IN implementation of Presto v.s Spark SQL

presto syntax for csv external table with array in one of the fields

Hive metastore with alluxio storage in parquet data type problem

how to set session property when executing pd.to_sql? {error:"Required field 'numDVs' is unset! }

Search for exact string value in JSON

How to implement jdbc driver for presto

Query target conditions

anyway to support session level connector configuration for presto

How to achieve "INSERT IGNORE" using PRESTO

How to group and sum by dates without specifying each one manually in SQL

Multi-Level Serving Tree vs Directed Acyclic Graph

Hive table with nested JSON as string value

SQL :Fill null date and null value in the rol

Looking for sequences without duplicates - SQL

Connecting R and Presto using LDAP https authentication

Capture strings inside escaped quotes

SQL: How to query value in max datetime in each ID and fill null value with previous value

Combine rows based on column value

How to get table names from Presto query using presto-parser?

Presto: Create new columns with some default values

sql how to show increment as fraction of total increment

How to show incremental changes in SQL

SQL: join with an equal key and nearest key (similar to Pandas's merge as of)

Presto latest version 0.224 is slower when execute the queries

Finding most common elements of column of arrays in Presto

What permission does a Presto CLI command inside a shell script require in order to be able to execute

I have some problems with mybatis, when I query presto data

back/front filling values in SQL

Split and search comma separated column in Presto (AWS Athena)

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