Stack Overflow
Stack Overflow

Questions tagged [pipelinedb]

Questions related to PipelineDB - A PostgreSQL extension for high-performance time-series aggregation

51 questions
0
votes
1 answer

PipelineDB, get counts for top K items

How to calculate frequencies of top K values in the stream? Let's say we have a stream CREATE STREAM stream ( value number ); And we inserted ten rows INSERT INTO stream (value) VALUES (1) INSERT INTO stream (value) VALUES (1) INSERT INTO stream…
Alexey Petrushin
  • 1,311
  • 3
  • 10
  • 24
0
votes
1 answer

pipelinedb consuming kafka topic

When I create a stream in the pipeline and it starts consuming of a topic, it does not appear in the active consmidores of my topic, what do I do so that it appears there? No consumer appears How I created the stream CREATE STREAM…
luiz kava
  • 187
  • 1
  • 2
  • 14
0
votes
1 answer

Custom PipelineDB extension

Currently I can see support for kafka and kinesis, is it possible to add custom protocol extension to pipelinedb ? If yes, where can I find some guidelines to write it. - Thanks
nishant pathak
  • 342
  • 1
  • 4
  • 17
0
votes
1 answer

select values in json into other json (Postgres)

I have the following JSON { "eventSummaryList": [ { "customer": "189256", "data":…
luiz kava
  • 187
  • 1
  • 2
  • 14
0
votes
0 answers

PipelineDB: window functions

Looking at the docs Create continuous view it's possible to create something like CREATE CONTINUOUS VIEW cv AS SELECT ticketid, status, avg(status_duration) OVER w FROM stream WINDOW w AS (PARTITION BY ticketid); But I get the…
AnaG
  • 17
  • 1
  • 5
0
votes
1 answer

Compiling PipelineDB on RaspberryPi 2

I'm trying to compile PipelineDB on a RasberryPi 2 running Raspbian. I followed the instructions and installed ZeroMQ. I get this error: In file included from ../../../../src/include/pgstat.h:18:0, from…
rmsmm
  • 1
0
votes
1 answer

PipelineDB Continuous View Failed Assertion !(ActiveSnapshotSet())

I have two continuous views: tikets2 and second_view CREATE CONTINUOUS VIEW tickets2 AS SELECT ticketid, TO_TIMESTAMP(min(event_time)::double precision /1000000) as t0, keyed_min(event_time, status) as t0_status, …
AnaG
  • 17
  • 1
  • 5
0
votes
1 answer

PipelineDB for OLTP and Streaming

I read that PipelineDB is a drop-in replacement for Postgresql. Can I run my standard OLTP data on it without any performance repucussions then?
Jason
  • 2,006
  • 3
  • 21
  • 36
0
votes
1 answer

PipelineDB consumer from KAFKA JSON with array

My kafka send the following json '{ "eventSummaryList": [ { "customer": 1, "data":…
luiz kava
  • 187
  • 1
  • 2
  • 14
0
votes
1 answer

Edit continuous view sliding windows in pipelinedb

I create a continuous view and fill it with my streams. Now I want to change my old sliding window or change this name.
mrash
  • 883
  • 7
  • 18
0
votes
1 answer

how to build pipeline_kafka extension

i'm currently trying to compile the pipeline_kafka extension from Github to add it to my pipelinedb instance but i'm running in a problem neither i nor google seems to be able to solve. when i execute make command i get the following…
RootOfProblem
  • 357
  • 1
  • 3
  • 11
0
votes
1 answer

Is it possible to add PostGIS to PipelineDB?

Os:ubuntu 14.04 64bit I'm trying to connect QGIS with pipelineDB. Homepage says it supports postGIS, but I couldn't find way to do it. Older version has something like "loading PipelineDB extensions" during its init period while the 0.9.1 version I…
GSaint
  • 23
  • 1
  • 4
0
votes
1 answer

Is it possible to implement a trigger (or sth. similar) to detect an event

I have a continous view based on a stream. In the CV some data is aggregated (e.g. average and maximum value of the last 2 minutes). Is it possible to implement a trigger (or sth. similar) to detect an event, such as the max. value increases above a…
Pemburu
  • 1
  • 2
0
votes
1 answer

Changing a table into a continuous view - issue with dependent continuous views

We're refactoring the structure of our tables and views and one of the improvements is changing one table (which is updated "manually" from a java class) to a continuous view. The name of the view has to be the same with the old table and the old…
iosifv
  • 1,153
  • 1
  • 10
  • 26
0
votes
1 answer

view a stream PipelineDB like a log

I am new to pipelineDB and i'm trying to debug stuff around. I am using the official pipelinedb/pipelinedb docker image for that. I think it would be helpful if I could view one of the streams in a "tail -f" manner. Any suggestions on how I could…
iosifv
  • 1,153
  • 1
  • 10
  • 26
1 2
3
4