Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Component/s: DAS Docs
    • Labels:
      None
    • Environment:

      windows 10, DAS 3.0.1, Siddhi

    • Severity:
      Major
    • Estimated Complexity:
      Moderate
    • Test cases added:
      Yes

      Description

      I want read the postgres table from siddhi, and I am using a Trigger:

      @From(eventtable='rdbms', jdbc.url='jdbc:postgresql://localhost:5432/pruebabg', username='postgres', password='Easysoft16', driver.name='org.postgresql.Driver', table.name='Trazablack')
      define table Trazablack (sensorValue double);

      define trigger FiveMinTriggerStream at every 10 min;

      from FiveMinTriggerStream join Trazablack as t
      select t.sensorValue as sensorValue
      insert into StreamBlack;

      But, I have a problem, the query is run every 10 minutes, I need to run when a new event arrives.

      is this possible?

      from sensorStream#window.length(2)
      JOIN StreamBlack#window.length(1)
      on sensorStream.sensorValue==StreamBlack.sensorValue
      select sensorStream.meta_timestamp, sensorStream.meta_sensorName, sensorStream.correlation_longitude,
      sensorStream.correlation_latitude, sensorStream.sensorValue as valor1, StreamBlack.sensorValue as valor2
      insert INTO StreamPaso;

      from sensorStream#window.length(2)
      LEFT OUTER JOIN StreamBlack#window.length(1)
      on sensorStream.sensorValue==StreamBlack.sensorValue
      select sensorStream.meta_timestamp, sensorStream.meta_sensorName, sensorStream.correlation_longitude,
      sensorStream.correlation_latitude, sensorStream.sensorValue as valor1, StreamBlack.sensorValue as valor2
      insert INTO StreamPaso;

        Attachments

          Activity

            People

            • Assignee:
              rukshani@wso2.com Rukshani Weerasinha
              Reporter:
              roby.rubiano@gmail.com ROBY HERNAN RUBIANO
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: