marregui

Gets a T-Shirt when competed by a member of the community

Hola @lookharm , yes please!. If you need help or get stuck, do let me know, here or in Slack :)

Hi @lookharm , Indeed you found the entry point into the issue. In QuestDB you can navigate to the webconsole, type simply the table name and hit run. This acts...

Note, the test above will fail, you need to make it a failing test, the code is just a hint.

QuestDB's parser views SQL as a functional language. Some modern languages, like elixir, have parenthesis as optional, particularly when there are no parameters for the function. We work that way...

The semantics of the queries: - `select * from tab`: You can think of tab as a cursor over the selected fields for table **tab**. - `select *`: The parser...

I have updated discussion https://github.com/questdb/questdb/discussions/1162 with a preliminary spec for window functions. Query _numero 1_ is an approximation to what needs to be achieved, _numero 2_: ```sql create table tank(id...

Hi @toomuchio why would these queries not be suitable? 1. samples tank in buckets of 1 minute, calculates de difference between the last and first values in the group: ```sql...

Hi @ErichHeinemann and @toomuchio , In QuestDB, to get the delta of a column between two timestamps at intervals of 1 sec, you need a table that has a designated...

Hi, Two exemplifying examples in the codebase on how to use timestamps: https://github.com/questdb/questdb/blob/master/core/src/test/java/io/questdb/cutlass/pgwire/PGJobContextTest.java#L5934 https://github.com/questdb/questdb/blob/master/core/src/test/java/io/questdb/cutlass/pgwire/PGJobContextTest.java#L6059 It is a feature :P