Re: UPSERT null vlaues

2018-04-28 Thread James Taylor
The contract with immutable tables is that a row will never be partially updated (including setting a column to null). Phoenix can’t enforce this and retain the perf gain it gives you, so it’s on an honor system instead. Attempts to set a value to null are stripped out rather than potentially

Go Avatica/Phoenix database/sql driver 3.0.0 released

2018-04-28 Thread Francis Chuang
We recently released Apache Calcite Avatica Go 3.0.0. avatica-go is a Go database/sql driver for Avatica that also contains an adapter for Phoenix. The 3.0.0 release is the first release under the Apache Foundation since the code has been donated. If you are using the Boostport/avatica

RE: UPSERT null vlaues

2018-04-28 Thread Stepan Migunov
Thank you James, it was “immutable”. I didn't know that it affects. *From:* James Taylor [mailto:jamestay...@apache.org] *Sent:* Friday, April 27, 2018 5:37 PM *To:* user@phoenix.apache.org *Subject:* Re: UPSERT null vlaues Hi Stepan, Please post your complete DDL and indicate the version