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

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

    Mark Addleman Master

      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) */