7 Replies Latest reply: Apr 13, 2012 9:10 AM by Mark Addleman RSS

Continuous Executions and INSERT INTO... SELECT...

Mark Addleman Expert

I'm woefully behind on my experiments with Teiid's latest features so I thought I'd run this by you instead...  How will Teiid repond to a statement of the form:

INSERT INTO translator_a.t (a,b,c) SELECT a,b,c FROM translator_b.t

Assuming SELECT a,b,c FROM translator_b.t is a continuous execution?  I'm hoping that the insert would be on-going until the continuous execution comes to an end. 

 

I think would introduce an interesting commit scope problem that is probably best handled by translator_b with a hint: /* commit_every_n(1000) */ or /* commit_every_ms(200) */