hiveql - How to find 5 or more consecutive days in presto

Question

I have the date as below. Here 10/02 and 10/05 should be consider as consecutive days because 10/3 and 10/04 is weekend. And I need to find total number of consecutive days for the occurrence of C1.

C1 C2 C3 date
1  a  b  10/01/2020
1  a  b  10/02/2020
1  a  b  10/05/2020  
1  a  b  10/06/2020  
1  a  b  10/07/2020  
1  a  b  10/08/2020  
1  a  b  10/09/2020  
1  a  b  10/12/2020

question from:https://stackoverflow.com/questions/65878754/how-to-find-5-or-more-consecutive-days-in-presto

Answer 1

Waitting for answers