Presto is an open source distributed SQL query engine for running analytic queries against data sources of all sizes ranging from gigabytes to petabytes.
I'm on presto and have a date formatted as varchar that looks like - 7/14/2015 8:22:39 AM I've looked the presto docs …
sql prestoI'm pretty sure the following query used to work for me on Presto: select segment, sum(count) from modeling_trends …
prestoIs there any analog of NVL in Presto DB? I need to check if a field is NULL and return …
sql presto amazon-athenaI have the following query that I am trying to run on Athena. SELECT observation_date, COUNT(*) AS count FROM …
sql amazon-web-services amazon-athena prestotried the below syntax none of them helped to convert a string type column to date select INVC_,APIDT,APDDT …
date presto amazon-athenaI have some issue while formatting a timestamp with Amazon Athena service. select date_format(current_timestamp, 'y') Returns just …
amazon-web-services presto amazon-athenaI'm using the latest(0.117) Presto and trying to execute CROSS JOIN UNNEST with complex JSON array like this. [{"id": 1, "value":"…
jsonpath prestoAt Amazon Athena, I want to extract only the character string "2017-07-27" from the character string "2017-07-27 12:10:08". SELECT …
amazon-athena prestoI like to convert my timestamp columns to date and time format. How should I write the query from presto? …
sql presto trinoI have timestamps stored in time since epoch (ms) and I would like to query and display results using a …
presto