[jira] [Resolved] (CASSANDRA-7102) CqlStorage loads incorrect schema

["Brandon Williams (JIRA)" <ji...@apache.org>]

     [ 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)