[ 
https://issues.apache.org/jira/browse/CASSANDRA-5234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13722139#comment-13722139
 ] 

Christopher Smith commented on CASSANDRA-5234:
----------------------------------------------

Just adding that I'm getting the same result as Konrad Kurdej. I'm using DSE 
3.1, but I think this is the same bug. I was able to isolate the problem 
specifically to counter fields. Here's a simple set up and test case:

cqlsh> create keyspace pigtest with REPLICATION = { 'class': 'SimpleStrategy', 
'replication_factor': 1};
cqlsh> use pigtest;
cqlsh:pigtest> create table foo ( key_1 text primary key, value_1 bigint );
cqlsh:pigtest> create table foo2 ( key_1 text primary key, value_1 counter );
cqlsh:pigtest> update foo set value_1 = 1 where key_1 = 'foo';
cqlsh:pigtest> update foo2 set value_1 = value_1 + 2 where key_1 = 'foo2';
cqlsh:pigtest> select * from foo;

 key_1 | value_1
-------+---------
   foo |       1

cqlsh:pigtest> select * from foo2;

 key_1 | value_1
-------+---------
  foo2 |       2

Now, the following grunt commands:

counts = LOAD 'cassandra://pigtest/foo' USING CassandraStorage();
dump counts;

Will work, but:

counts = LOAD 'cassandra://pigtest/foo2' USING CassandraStorage();
dump counts;

Will fail with the same stack trace that Konrad mentioned.
                
> Table created through CQL3 are not accessble to Pig 0.10
> --------------------------------------------------------
>
>                 Key: CASSANDRA-5234
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5234
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Hadoop
>    Affects Versions: 1.2.1
>         Environment: Red hat linux 5
>            Reporter: Shamim Ahmed
>            Assignee: Alex Liu
>             Fix For: 1.2.7
>
>         Attachments: 5234-1-1.2-patch.txt, 5234-1.2-patch.txt, 
> 5234-2-1.2branch.txt, 5234-3-1.2branch.txt, 5234-3-trunk.txt, 5234.tx, 
> fix_where_clause.patch
>
>
> Hi,
>   i have faced a bug when creating table through CQL3 and trying to load data 
> through pig 0.10 as follows:
> java.lang.RuntimeException: Column family 'abc' not found in keyspace 'XYZ'
>       at 
> org.apache.cassandra.hadoop.pig.CassandraStorage.initSchema(CassandraStorage.java:1112)
>       at 
> org.apache.cassandra.hadoop.pig.CassandraStorage.setLocation(CassandraStorage.java:615).
> This effects from Simple table to table with compound key. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to