Bulk insert in Teiid

[jane_lj]

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.

[shawkins]

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.