pt the fetch size as 500. And these are
> coming while reading rows having ~200 columns.
>
>
> On Thu, Apr 3, 2014 at 12:45 PM, Shrikar archak wrote:
>
>> Hi Apoorva,
>> As per the cfhistogram there are some rows which have more than 75k
>> columns and around 150k r
t;>select * form marks_table where studentID = ? limit 500;
>> instead of doing
>>select * form marks_table where studentID = ?;
>>
>>
>> On Sat, Mar 29, 2014 at 5:20 AM, Shrikar archak wrote:
>>
>>> Hi Apoorva,
>>>
>>>
Hi Apoorva,
I assume this is the table with studentId and subjectId as primary keys
and not other like like marks in that.
create table marks_table(studentId int, subjectId int, marks int, PRIMARY
KEY(studentId,subjectId));
Also could you give the cfhistogram stats?
nodetool cfhistograms mark
Hi All,
My Usecase
I want query result by ordered by timestamp DESC. But I don't want
timestamp to be the second column in the primary key as that will take of
my querying capability
for example
create table demo(oid int,cid int,ts timeuuid,PRIMARY KEY
(oid,cid,ts)) WITH CLUSTERING ORDER BY (ts
Hi Data Model Experts,
I have a few questions with data modelling for a particular application.
example
create table messages(
body text,
username text,
tags set
PRIMARY keys(username,tags)
)
Requirements
1) I should be able to query by username and get all the messages for a
particular usernam
