[
https://issues.apache.org/jira/browse/CASSANDRA-7102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13983490#comment-13983490
]
Brandon Williams commented on CASSANDRA-7102:
---------------------------------------------
If upgrading C* fixed it, I'm going to notaproblem this. Could have been
CASSANDRA-5201 or something else, but either way it's fixed now.
> 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)
