[ https://issues.apache.org/jira/browse/CASSANDRA-7102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brandon Williams resolved CASSANDRA-7102. ----------------------------------------- Resolution: Not a Problem > 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)