phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacob Isaac (Jira)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-5476) Multiple EMPTY_COLUMN cells exists when column families of include columns are different.
Date Sun, 15 Sep 2019 20:15:00 GMT
Jacob Isaac created PHOENIX-5476:
------------------------------------

             Summary: Multiple EMPTY_COLUMN cells exists when column families of include columns
are different.
                 Key: PHOENIX-5476
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5476
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.15.0
            Reporter: Jacob Isaac


To reproduce -

CREATE TABLE IF NOT EXISTS "TEST_ENTITY"."T_T000004"(OID CHAR(15) NOT NULL,KP CHAR(3) NOT
NULL,COL1 VARCHAR,A.COL2 VARCHAR,B.COL3 VARCHAR CONSTRAINT pk PRIMARY KEY (OID,KP)) MULTI_TENANT=true,COLUMN_ENCODED_BYTES=0;

CREATE VIEW IF NOT EXISTS "TEST_ENTITY"."V_T000004"(ID CHAR(15) NOT NULL,COL4 VARCHAR,COL5
VARCHAR,A.COL6 VARCHAR CONSTRAINT pk PRIMARY KEY (ID)) AS SELECT * FROM "TEST_ENTITY"."T_T000004"
WHERE KP = '0EC';

CREATE INDEX IF NOT EXISTS IDX_V_T000004 ON "TEST_ENTITY"."V_T000004"(COL4) INCLUDE (COL6)
;

CREATE VIEW IF NOT EXISTS "TEST_ENTITY"."0EC"(B.COL7 VARCHAR,COL8 VARCHAR,COL9 VARCHAR) AS
SELECT * FROM "TEST_ENTITY"."V_T000004" ;
CREATE INDEX IF NOT EXISTS IDX_0EC ON "TEST_ENTITY"."0EC"(COL9) INCLUDE (COL7) ;


UPSERT INTO "TEST_ENTITY"."0EC" (OID,ID,COL1,COL2,COL3,COL4,COL5,COL6,COL7,COL8,COL9) VALUES('o1','1','a','b','c','d','e','f','g','h','i');

scan "_IDX_TEST_ENTITY.T_T000004"

Multiple EMPTY_COLUMNS are created with different values
\x00\x00\x00\x00\x00\x00\x00\x00o1             d\x001                   column=A:A:COL6, timestamp=1568578126086,
value=f                                                                                  
                                                                                  
 \x00\x00\x00\x00\x00\x00\x00\x00o1             d\x001                   column=A:_0, timestamp=1568578126086,
value=x                                                                                  
                                                                                      
 \x00\x00\x00\x00\x00\x00\x00\x00o1             d\x001                   column=B:_0, timestamp=1568578126086,
value=\x01                                                                               
                                                                                      
 \x00\x00\x00\x00\x00\x00\x00\x01o1             i\x001                   column=B:B:COL7,
timestamp=1568578126086, value=g                                                         
                                                                                         
                 
 \x00\x00\x00\x00\x00\x00\x00\x01o1             i\x001                   column=B:_0, timestamp=1568578126086,
value=\x01                                                                               
                                                                                      






--
This message was sent by Atlassian Jira
(v8.3.2#803003)

Mime
View raw message