[CASSANDRA-6071] CqlStorage loading compact table adds an extraneous field to the pig schema

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 1.2.11, 2.0.2
• Severity: Low
• Since Version: 1.2.9
• Assignee: Sam Tunnicliffe
• Reporter: Sam Tunnicliffe

Authors

Sam Tunnicliffe

Reviewers

Alex Liu

• Created: 20/Sep/13 17:07
• Updated: 16/Apr/19 09:32
• Resolved: 26/Sep/13 18:54

Description

CREATE TABLE t (
  key text,
  field1 int,
  field2 int
  PRIMARY KEY (key, field1)
) WITH COMPACT STORAGE;

INSERT INTO t (key,field1,field2) VALUES ('key1',1,2);
INSERT INTO t (key,field1,field2) VALUES ('key2',1,2);
INSERT INTO t (key,field1,field2) VALUES ('key3',1,2);

grunt> t = LOAD 'cql://ks/t' USING CqlStorage();
grunt> describe t;                                 
t: {key: chararray,field1: int,field2: int,value: int}
dump t;
(key1,1,2,)
(key3,1,2,)
(key2,1,2,)