• j

    javier ramirez

    5 months ago
    Hi. Anyone here using QuestDB as a streaming sink for Apache Flink? If so, are you using the JDBC or the InfluxDB connector? Thanks!
    j
    Nicolas Hourcard
    +1
    16 replies
    Copy to Clipboard
  • Sergey Georgiev

    Sergey Georgiev

    5 months ago
    Hi, I'm looking for a way to execute SQL queries in transaction. First to check if the data already exist in the table and then to insert it if it not exist. Can you advice me how to do this?
    Sergey Georgiev
    1 replies
    Copy to Clipboard
  • Newskooler

    Newskooler

    5 months ago
    Hi 👋 I am wondering does anyone have experience with resampling streaming data? By this I mean - imagine you are stream data and then at a specific trigger (it can be time or it can be a specific data value) it aggregates the streamed data and dumps it into a table?🤔
    Newskooler
    h
    3 replies
    Copy to Clipboard
  • t

    Tihomir Dimov

    5 months ago
    Hi 👋 I am getting error while dropping a partition. My table has daily partitions and a websocket is saving data all the time in the table. When I run:
    ALTER TABLE test_table DROP PARTITION LIST '2022-03-28';
    I am getting the following error:
    Could not publish writer ALTER TABLE task [table=test_table]ALTER TABLE test_table DROP PARTITION LIST '2022-03-28';
    Error from logs:
    2022-03-31T14:33:37.947461Z E i.q.c.CairoEngine could not publish writer task [table=test_table,instance42,seqCursor=-1]
    The strange thing is that dropping partition from this table worked ~20 times in the past days. Any ideas how to fix it?
    t
    Vlad
    +1
    6 replies
    Copy to Clipboard
  • x

    xrust01

    5 months ago
    Hello, please can I ask about the timeline of implementing nanosecond timestamps? (https://github.com/questdb/questdb/issues/344) Thank you!
    x
    Nicolas Hourcard
    5 replies
    Copy to Clipboard
  • Newskooler

    Newskooler

    5 months ago
    👋 I noticed that
    SAMPLE BY
    with
    ALIGN TO CALENDAR
    provides the start of the timestamp period. 1. I wonder - why is that the choice (pandas in python has the same choice)? 2. Is there a way to specify the end of the timestamp (i.e. the start of the next period as a timestamp)?
    Newskooler
    Vlad
    13 replies
    Copy to Clipboard
  • Newskooler

    Newskooler

    5 months ago
    👋 Is there a way to compute the returns from a single column time-series via an SQL query (i.e.
    (row_n - row_n-1) / row_n-1
    )
    Newskooler
    Bolek Ziobrowski
    23 replies
    Copy to Clipboard
  • l

    Luc Girardin

    5 months ago
    I am wondering if there is a difference in performance between Intel (Xeon), AMD (EPYC), or even Apple M1 when used for QuestDB. Did any of you ran some benchmarks?
    l
    Andrey Pechkurov
    4 replies
    Copy to Clipboard
  • Walter Z

    Walter Z

    5 months ago
    is there any place to get architechure diagram of QuestDB
    Walter Z
    Andrey Pechkurov
    +1
    7 replies
    Copy to Clipboard
  • Samyoga Bhattarai

    Samyoga Bhattarai

    5 months ago
    Hi everyone, I wanted to know if there is anyway to store geojson data to questdb
    Samyoga Bhattarai
    1 replies
    Copy to Clipboard