[PHOENIX-1088] Cannot insert data , while Index is empty string

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 4.0.0
• Fix Version/s: 4.1.0
• Labels: Index

Environment

hadoop (2.3.0+cdh5.0.0+548)
hbase(0.96.1.1+cdh5.0.0+60)

• Assignee: Unassigned
• Reporter: minqiang.li
• Created: 15/Jul/14 08:09
• Updated: 21/Nov/15 02:17
• Resolved: 09/Aug/14 01:26

Description

This is my create Table DDL.
create table TAB_PS_XDR ( K VARCHAR NOT NULL PRIMARY KEY, A VARCHAR, B VARCHAR, C VARCHAR, D VARCHAR, V VARCHAR) COMPRESSION='SNAPPY',SALT_BUCKETS=12,TTL='7200',VERSIONS='5';

create index CALLING_NUMBER on TAB_PS_XDR (A);

create index CALLED_NUMBER on TAB_PS_XDR (B);

create index IMSI on TAB_PS_XDR (C);

create index IMEI on TAB_PS_XDR (D);

And then I begin insert data to test DB.

UPSERT INTO TAB_PS_XDR VALUES('aaaaaaacbaa11','', '','','1','1');
UPSERT INTO TAB_PS_XDR VALUES('bbaaaabbaa11','', '','','1','1');
UPSERT INTO TAB_PS_XDR VALUES('ccaaaaccbaa11','', '','','1','1');
UPSERT INTO TAB_PS_XDR VALUES('dDaaaadcbaa11','', '','','1','1');

after insert data, i check the number of rows:
select count from tab_px_xdr ;
the result is no change.

and then change my sql like this:
UPSERT INTO TAB_PS_XDR VALUES('aaaaaaacbaa11','', '','1','','1');
UPSERT INTO TAB_PS_XDR VALUES('bbaaaabbaa11','', '','1','','1');
UPSERT INTO TAB_PS_XDR VALUES('ccaaaaccbaa11','', '','1','','1');
UPSERT INTO TAB_PS_XDR VALUES('dDaaaadcbaa11','', '','1','','1');

check the result is ok.
why??