1 Reply Latest reply on May 3, 2013 4:19 PM by Steven Hawkins

    Bulk insert in Teiid

    jane_lj Novice



      I have written the translator which can handle bulk insert, but I couldn't figure out how to send bulk insert command. I can't use "INSERT SELECT..." because we have to set the column value one by one, there is no data we can direct select then insert.


      Any idea?



        • 1. Re: Bulk insert in Teiid
          Steven Hawkins Master

          Just to make sure I understand correctly, what do you mean you have to set the column value one by one?


          Generally you would want to create a temporary table, then do an insert based upon a select from the temp table.


          Otherwise we should support multiple values via the VALUES, but haven't added that feature yet.