Re: JDBC Table Sink doesn't seem to sink to database.

2019-10-18 Thread John Smith
So it looks like newer versions have this. The 1.8 branch you can have similar functionality if you enable checkpointing. There's a few things to look at that could be confusing if using 1.8. JDBCOuputFormat: Only works with batch size interval and works with Row. JDBCSinkFunction: Uses JDBCOuputF

Re: JDBC Table Sink doesn't seem to sink to database.

2019-10-17 Thread Rong Rong
Splendid. Thanks for following up and moving the discussion forward :-) -- Rong On Thu, Oct 17, 2019 at 11:38 AM John Smith wrote: > I recorded two: > Time interval: https://issues.apache.org/jira/browse/FLINK-14442 > Checkpointing: https://issues.apache.org/jira/browse/FLINK-14443 > > > On Thu

Re: JDBC Table Sink doesn't seem to sink to database.

2019-10-17 Thread John Smith
I recorded two: Time interval: https://issues.apache.org/jira/browse/FLINK-14442 Checkpointing: https://issues.apache.org/jira/browse/FLINK-14443 On Thu, 17 Oct 2019 at 14:00, Rong Rong wrote: > Yes, I think having a time interval execution (for the AppendableSink) > should be a good idea. > Ca

Re: JDBC Table Sink doesn't seem to sink to database.

2019-10-17 Thread Rong Rong
Yes, I think having a time interval execution (for the AppendableSink) should be a good idea. Can you please open a Jira issue[1] for further discussion. -- Rong [1] https://issues.apache.org/jira/projects/FLINK/issues On Thu, Oct 17, 2019 at 9:48 AM John Smith wrote: > Yes correct, I set it t

Re: JDBC Table Sink doesn't seem to sink to database.

2019-10-17 Thread John Smith
Yes correct, I set it to batch interval = 1 and it works fine. Anyways I think the JDBC sink could have some improvements like batchInterval + time interval execution. So if the batch doesn't fill up then execute what ever is left on that time interval. On Thu, 17 Oct 2019 at 12:22, Rong Rong wro

Re: JDBC Table Sink doesn't seem to sink to database.

2019-10-17 Thread Rong Rong
Hi John, You are right. IMO the batch interval setting is used for increasing the JDBC execution performance purpose. The reason why your INSERT INTO statement with a `non_existing_table` the exception doesn't happen is because the JDBCAppendableSink does not check table existence beforehand. That

Re: JDBC Table Sink doesn't seem to sink to database.

2019-10-16 Thread John Smith
Ok I think I found it. it's the batch interval setting. From what I see, if we want "realtime" stream to the database we have to set it to 1 other wise the sink will wait until, the batch interval count is reached. The batch interval mechanism doesn't see correct? If the default size is 5000 and y

JDBC Table Sink doesn't seem to sink to database.

2019-10-15 Thread John Smith
Hi, using 1.8.0 I have the following job: https://pastebin.com/ibZUE8Qx So the job does the following steps... 1- Consume from Kafka and return JsonObject 2- Map JsonObject to MyPojo 3- Convert The stream to a table 4- Insert the table to JDBC sink table 5- Print the table. - The job seems to wo