xtrmstep
commented
4 years ago test application
@App:name('test')
@App:statistics(enable='true', include='*.*')
-- SOURCES
define stream inp_stream (
id int,
value string
);
-- TABLES
@store(type = 'rdbms',
jdbc.url = "${POSTGRE_HOST}${POSTGRE_DB}",
username = "${POSTGRE_USER}",
password = "${POSTGRE_PASS}",
jdbc.driver.name = "org.postgresql.Driver",
table.name = "_tbl")
define table tbl_table (
id int,
value int
);
-- PROCESSING
@info(name='_tmp')
from inp_stream
select
id,
cast(default(value,'-1'), 'int') as value
insert into _tmp;
@info(name='tbl_table')
from _tmp as e left outer join tbl_table as t
on e.id==t.id
select
e.id,
e.value
update or insert into tbl_table
set
tbl_table.value=value
on tbl_table.id==id;
ngocdangrby
Hi,
I'm using 5.1.2 version of docker Siddhi runner.
I've got a code which looks very simple
tbl_table is RDBMS store in Siddhi app and maps to table in PostgreSQL. The field has integer type in DB. In Siddhi this field has type int.
This code throws an error:
is it possible to trace the error more deeply to get more information what's wrong?