QuestDB SAMPLE BY documentation is missing w for weekly

[pumuckelo]

To reproduce

I was assuming that SAMPLE BY weekly (w) is not supported. I also read some stackoverflow articles where it was described as not being supported

I ran this query though and its working fine

  SELECT 
                        time,
                        symbol,
                        first(open) as open,
                        max(high) as high,
                        min(low) as low,
                        last(close) as close,
                        sum(volume) as volume
                    FROM candles 
                    WHERE symbol = 'NQ'
                    SAMPLE BY 1w ALIGN TO CALENDAR
                    ORDER BY time

QuestDB version:

8.1.1

OS, in case of Docker specify Docker and the Host OS:

Official docker image

File System, in case of Docker specify Host File System:

.

Full Name:

Abdou

Affiliation:

None

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response

[pumuckelo]

@goodroot why was the commit reverted?