Recent questions tagged presto

0 votes

1.0k views

1 answer

presto - Python SQL formatting -- omitting one where clause based on conditions

I would need to write a SQL question based on conditions: in Condition 1: SELECT * FROM table_1 WHERE col_1 ... /python-sql-formatting-omitting-one-where-clause-based-on-conditions...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

906 views

1 answer

presto - how to extract last 25 hours data using updatedate using prestodb

I am trying to extract data from my table last 25 hours records in the presto database but I am unable to get ... /how-to-extract-last-25-hours-data-using-updatedate-using-prestodb...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

918 views

1 answer

presto - Counting the number of rows between transitions of values in SQL

I have rows with user_id, timestamps and YES / NO answer. I want to count how many streaks (consecutive rows) ... /counting-the-number-of-rows-between-transitions-of-values-in-sql...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

4.5k views

1 answer

presto - date_add for timestamp in Hive

im currently running a query in presto db which has a condition like below: x.created_date > date_add('day',-15,y. ... 11-24T21:08:20.046000 Any help would be appreciated.Thank you...

asked Jan 25, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags