Re: UPSERT null vlaues

2018-04-27 Thread James Taylor
Hi Stepan, Please post your complete DDL and indicate the version of Phoenix and HBase you’re using. Your example should work as expected barring declaration of the table as immutable or COL2 being part of the primary key. Thanks, James On Fri, Apr 27, 2018 at 6:13 AM Stepan Migunov <

UPSERT null vlaues

2018-04-27 Thread Stepan Migunov
Hi, Could you please clarify, how I can set a value to NULL? After upsert into temp.table (ROWKEY, COL1, COL2) values (100, "ABC", null); the value of COL2 still has a previous value (COL1 has "ABC" as expected). Or there is only one way - to set STORE_NULLS = true? Thanks, Stepan.