Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1088

Cannot insert data , while Index is empty string

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

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

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

      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??

        Attachments

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              Unassigned
              Reporter:
              mill_lmq minqiang.li

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment