Mailing-List: contact client-dev-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: client-dev@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of
 pushkar.prasad@airtightnetworks.net designates 64.78.61.187 as permitted
 sender)
From: "Pushkar Prasad" <pushkar.prasad@airtightnetworks.net>
To: <client-dev@cassandra.apache.org>
References: <loom.20130402T074624-135@post.gmane.org> 
In-Reply-To: 
Subject: Unable to prefix in astyanax read query
Date: Tue, 2 Apr 2013 19:41:00 +0530
Message-ID: <36D9E199AAC049EBB661CDABD7D2BB25@pune.wibhu.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: Ac4vZ0vK/3kWZaHUQmm3c6GoD+NB9AABBf7gABAW6IA=

Hi,

This is a Astyanax issue that we've encountered.

I have a scheme as follows:

 TimeStamp
 Device ID
 Device Name
 Device Owner
 Device location

I have created this column family using CQL and defined the primary key as 
(TimeStamp,Device ID, Device Name). Through a serializable object that has 
fields for DeviceID, name and a field name (which stores either Device Owner
or 
Device Location). I have inserted some records using Astyanax.

As per my understanding, the columns for a row are created by combining
Device ID, Device Name and field name as column name and the value to be the
value for that particular field. Thus for a particular timestamp and device,
the column names would be in the pattern (Device ID:Device Name: ...).

So I believe we can use these 2 fields as prefix to obtain all the entries
for a particular time-device combination.

I am using the following query to obtain the results:

  RowSliceQuery<String, ApBaseData> query = adu.keyspace
  .prepareQuery(columnFamily)
  .getKeySlice(timeStamp)
  .withColumnRange(new RangeBuilder()
   .setStart(deviceID+deviceName+"_\u00000")
   .setEnd(deviceID+deviceName+"_\uffff")
   .setLimit(batch_size)
   .build());

But on executing the above query I get the following Exception:

BadRequestException: [host=localhost(127.0.0.1):9160, latency=6(6), 
attempts=1]InvalidRequestException(why:Not enough bytes to read value of 
component 0)

Can any one help to understand where am I going wrong?