http://www.datastax.com/support-forums/topic/querying-different-datatypesuuiddatetimestringlong-in-hector Software, Support, and Training for Apache Cassandra en-US Mon, 20 May 2013 05:12:25 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/querying-different-datatypesuuiddatetimestringlong-in-hector#post-8599 Wed, 23 Jan 2013 09:54:45 +0000 BharathSubash 8599@http://www.datastax.com/support-forums/ <p>These are the values of Key and Value. </p> <p>key = "user_id";<br /> Val = "1000000000000000021"; </p> http://www.datastax.com/support-forums/topic/querying-different-datatypesuuiddatetimestringlong-in-hector#post-8598 Wed, 23 Jan 2013 09:53:26 +0000 BharathSubash 8598@http://www.datastax.com/support-forums/ <p>Hi </p> <p>How can we query columns with different datatypes in Hector? The result will contain columns with datatypes datetime,String, long and UUID. </p> <p>Currently i'm using IndexedSlicesQuery, </p> <p>IndexedSlicesQuery&lt;UUID,String,ByteBuffer&gt; indexedSlicesQuery= HFactory.createIndexedSlicesQuery(keyspace, uuidSerializer, StringSerializer.get(), ByteBufferSerializer.get());</p> <p>setting the Gte parameter like</p> <p>indexedSlicesQuery.addGteExpression(Key(),ByteBuffer.wrap(val.getBytes())))</p> <p>(key,val both are string fields.)<br /> I'm getting the following exception while executing query.</p> <p>indexedSlicesQuery.execute();</p> <p>me.prettyprint.hector.api.exceptions.HInvalidRequestException: InvalidRequestException(why:[757365725f6964]=[31303030303030303030303030303030303231] failed value validation (Expected 8 or 0 byte long (19)))</p> <p>Whats the problem here? Is there any better way to get the columns with different datatypes using hector? </p>