Step1: Update a column with null/'' value . Upsert into abc.tablename (Rowkeycombo1, Rowkeycombo2, columnname) values (123,to_date('1988-08-06'),null);
This works fine and the column then appears to have no data while doing a select.
Step2:Update the same column with a valid value. Upsert into abc.tablename (Rowkeycombo1, Rowkeycombo2, columnname) values (123,to_date('1988-08-06'),'TRYVAL'); Shows 1 row affected but the column still appears null/empty.
However there is no issue while updating a column which has a valid value to any other value.
I'm very new to Phoenix and hbase so I'm at a loss here.
Hello, I know this is aged topic... but I have the same issue.
is there any setting to configure in order to update previously "not stored column" with a new "not null" value?
can anybody give me some clues please? thanks
@frankthel, as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.
This a BUG from Phoenix
if I use upsert with null value, it "insert" the field with 0x00 0x00 bytes values and we cannot change
Please check the above BUG jira