Import only one columns and maintain the current data in the table

[roberto-abril]

I have a table of documents and I want import only one column and add to the current data, without lost the rest of columns.

I think is a good option when you need export, do several process with the data, and then import to crate.

Thk.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[chaudum]

hi @robertoabril as @seut already mentioned in the email, this is not possible right now. however, UPDATE using subselect is in our backlog already.

[hlcianfagna]

Hi @roberto-abril , I realise it has been a while, but as this ticket is still open I thought it would be good to update it in case anyone else comes across this, I think the approach described in https://community.cratedb.com/t/update-from-joined-table/488 may work for what you wanted to do, please take a look and let us know if that is not the case. Thank you.