• l

    Luc Girardin

    7 months ago
    I am trying to retrieve all the records at a given weekday and time (e.g. every Sunday at 1pm). Alas, the SAMPLE BY 7d ALIGN TO CALENDAR WITH OFFSET only takes a time offset (and not days) and alternatively the WHERE ts IN clause only take arguments starting with year (and not weekday/time). Any thought on how to tackle this?!?
    l
    Alex Pelagenko
    5 replies
    Copy to Clipboard
  • j

    John

    7 months ago
    Hi everyone. Applying a query with a round function on the grouped output as follows:
    select state, round(sum(fire_size),2) as area from fires_symbols group by state order by state;
    The output has some groups rounded, others not. see attached. Any reason for this?
    j
    Alex Pelagenko
    +2
    9 replies
    Copy to Clipboard
  • Clovis Warlop

    Clovis Warlop

    7 months ago
    Hi all, I'm trying to try out QuestDB but i got {"status":"No space left [size=33554432, fd=97]"} when uploading 25GB CSV (the instance has 150GB SDD space)
    Clovis Warlop
    Vlad
    +2
    11 replies
    Copy to Clipboard
  • Clovis Warlop

    Clovis Warlop

    7 months ago
    Another question: Is it possible to join data based on time?
    Clovis Warlop
    Bolek Ziobrowski
    +1
    15 replies
    Copy to Clipboard
  • Clovis Warlop

    Clovis Warlop

    7 months ago
    Question: How would i1. group data by time 2. sum a field 3. asof join it with a second table to add an additional field?
    Clovis Warlop
    Imre
    26 replies
    Copy to Clipboard
  • Domnic Amalan

    Domnic Amalan

    7 months ago
    is there method to invoke db lifecycle hooks
    Domnic Amalan
    Andrey Pechkurov
    3 replies
    Copy to Clipboard
  • Akshay Hartalkar

    Akshay Hartalkar

    7 months ago
    Hi, can i have table level access control, eg: i only need to give read access to a table, and write to another
    Akshay Hartalkar
    Ben Gamble
    +2
    16 replies
    Copy to Clipboard
  • Clovis Warlop

    Clovis Warlop

    7 months ago
    Hi i'm getting "db has no time column: no time column found" on grafana, any reason why?
    Clovis Warlop
    Imre
    8 replies
    Copy to Clipboard
  • PONG LI

    PONG LI

    7 months ago
    Just found a strange issue today,
    first()
    is not returning the first item, please help: (1st screenshot) My table design (2nd screenshot) Normal select with shows the first row is 2021-12-17T08:00:00 (3rd screenshot) Select
    first()
    from above
    select
    result, return 2021-12-19T08:00:00
    PONG LI
    Andrey Pechkurov
    +1
    7 replies
    Copy to Clipboard
  • Akshay Hartalkar

    Akshay Hartalkar

    7 months ago
    Hi all, what are the fastest* configuration to insert data via ILP
    Akshay Hartalkar
    Alex Pelagenko
    3 replies
    Copy to Clipboard