http://www.datastax.com/support-forums/topic/pig-error-type-mismatch-when-using-key-from-cf-in-join-or-group Software, Support, and Training for Apache Cassandra en-US Tue, 18 Jun 2013 22:52:03 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/pig-error-type-mismatch-when-using-key-from-cf-in-join-or-group#post-1831 Thu, 03 May 2012 19:42:24 +0000 Anonymous 1831@http://www.datastax.com/support-forums/ <p>Unfortunately there is no work around currently available, actually you have to options: a. you would have to wait for 2.1 release with updated CassandraStorage, b. you would have to re-compile C*, include it into DSE and use org.apache.cassandra.hadoop.pig.CassandraStorage class at your own risk. </p> http://www.datastax.com/support-forums/topic/pig-error-type-mismatch-when-using-key-from-cf-in-join-or-group#post-1787 Fri, 27 Apr 2012 16:39:00 +0000 Anonymous 1787@http://www.datastax.com/support-forums/ <p>Using DSE 1.x<br /> I have a simple CF with UTF8 key, column, &amp; value.</p> <p>I can use the column or value in a join or group by, but if I try to use the key, I get the following error:</p> <blockquote><p> Type mismatch in key from map: expected org.apache.pig.impl.io.NullableText, recieved org.apache.pig.impl.io.NullableBytesWritable </p></blockquote> <p>Simplest example:<br /> <code><br /> p1 = LOAD 'cassandra://keyspace/CF' USING CassandraStorage() AS (key:chararray, columns: bag{T: tuple(property:chararray, value:chararray)});<br /> p2 = group p1 by columns::property;<br /> dump p2;<br /> </code></p> <p>Works just fine, but changing the group by to:<br /> <code><br /> p2 = group p1 by key;<br /> dump p2;<br /> </code></p> <p>will fail with the type mismatch error.</p> <p>However, if I do a load, using the same schema, from a text file with lines of the form:</p> <blockquote><p> key {(c1,v1),(c2,v2),(c3,v3)} </p></blockquote> <p>I can group (or join) by the key successfully.</p> <p>Any suggestions for work around?</p> <p>Thanks,<br /> John </p>