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

    Bulk insert in Teiid

    jane_lj Novice

      Hi,

       

      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?

       

      Thanks.

        • 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.