Robbie Strickland created CASSANDRA-7102: --------------------------------------------
Summary: CqlStorage loads incorrect schema Key: CASSANDRA-7102 URL: https://issues.apache.org/jira/browse/CASSANDRA-7102 Project: Cassandra Issue Type: Bug Components: Hadoop Environment: OS-X, Hadoop 1.2.1, C* 2.0.0, Pig 0.12 Reporter: Robbie Strickland When running C* 2.0.0 with Hadoop 1.2.1 and Pig 0.12, attempting to load a table using CqlStorage produces an invalid schema. Given the following table: CREATE TABLE checkins ( user text, time bigint, checkinid text, address text, geohash text, lat double, lon double, PRIMARY KEY (user, time, checkinid) ) I load my table in Pig as follows: checkins = LOAD 'cql://wxcheckin/checkins' USING CqlStorage() ... which produces the following schema: (user:chararray,time:long,checkinid:chararray,address:chararray,checkinid:chararray,geohash:chararray,lat:double,lon:double,time:long,user:chararray) As you can see it repeats the fields in the PK, and it throws an error when any field is referenced: Invalid field projection. Projected field [time] does not exist in schema: user:chararray,time:long,checkinid:chararray,address:chararray,checkinid:chararray,geohash:chararray,lat:double,lon:double,time:long,user:chararray. Simply upgrading to C* 2.0.7 fixes the issue. -- This message was sent by Atlassian JIRA (v6.2#6252)