phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Can't add null value to a secondary indexed tableThis topic is a duplicate of another discussion.
Date Thu, 20 Feb 2014 16:50:05 GMT
Hi Job,
Thanks for reporting this and thanks for all the detail. Please file a
JIRA. If you could put together a unit test, that would be helpful.
Thanks!
James

On Thursday, February 20, 2014, Job Thomas <jobt@suntecgroup.com> wrote:

>
>  Hi All
> I have  created a Phoenix table like this
>
> CREATE TABLE DEMO(R VARCHAR PRIMARY KEY,A DOUBLE,C VARCHAR);
>
> Then created index
>
> CREATE INDEX DEMO_idx ON DEMO (A) INCLUDE(C);
>
> upsert into DEMO  values('cc1',null,'abc');
>
> select * from DEMO;
> No Data Found !!
>
> Problem is when adding null value to the second column(A)
>
> If a created  index without include key
> CREATE INDEX DEMO_idx ON DEMO (A) ;
>                       (OR)
> CREATE INDEX DEMO_idx ON DEMO (A,C);
>
> The same will work properly.
>
> What will be the reason with include and null value insert?
>
>
> Thanks in advance,
> Jom M Thomas
>  Thanks & Regards,
> Job M Thomas| Platform & Technology
>

Mime
View raw message