Re: cass-2.2 trigger - how to get clustering columns and value?

2019-04-11 Thread Carl Mueller
; > > > public Collection augment(ByteBuffer key, ColumnFamily > update) { > > > > the names returned by the update.getColumnNames() for an update of a > table with two clustering columns and had a regular column update produced > two CellName/Cells: > > &g

Re: cass-2.2 trigger - how to get clustering columns and value?

2019-04-11 Thread Paul Chandler
g to extract all the data from the > incoming updates > > so for > > public Collection augment(ByteBuffer key, ColumnFamily update) { > > the names returned by the update.getColumnNames() for an update of a table > with two clustering columns and had a regular colum

Re: cass-2.2 trigger - how to get clustering columns and value?

2019-04-11 Thread Jacques-Henri Berthemet
without values is a delete of the Cell. Regards, Jacques-Henri Berthemet From: Carl Mueller Reply-To: "user@cassandra.apache.org" Date: Wednesday 10 April 2019 at 23:53 To: "user@cassandra.apache.org" Subject: cass-2.2 trigger - how to get clustering columns and value? We have a

cass-2.2 trigger - how to get clustering columns and value?

2019-04-10 Thread Carl Mueller
all the data from the incoming updates so for public Collection augment(ByteBuffer key, ColumnFamily update) { the names returned by the update.getColumnNames() for an update of a table with two clustering columns and had a regular column update produced two CellName/Cells: one has no name

Re: What is performance gain of clustering columns

2017-10-03 Thread kurt greaves
in a time series use case and remove the need for time buckets in your partition key. On 3 October 2017 at 15:30, eugene miretsky <eugene.miret...@gmail.com> wrote: > Hi, > > Clustering columns are used to order the data in a partition. However, > since data is split into

What is performance gain of clustering columns

2017-10-03 Thread eugene miretsky
Hi, Clustering columns are used to order the data in a partition. However, since data is split into SSTables, the rows are ordered by clustering key only within each SSTable. Cassandra still needs to check all SSTables, and merge the data if it is found in several SSTables. The only scanario

Re: Cannot restrict clustering columns by IN relations when a collection is selected by the query

2016-10-27 Thread DuyHai Doan
> > * @Query("SELECT * FROM ticket_by_member WHERE project_id = ? AND > member_id IN(?)" )* > > *Result cardsByMembers(String projectId, > List memberIds);* > > But when I call this method, I get the exception: > > java.util.concurrent.ExecutionExcept

Cannot restrict clustering columns by IN relations when a collection is selected by the query

2016-10-27 Thread Ali Akhtar
ent.ExecutionException: com.datastax.driver.core.exceptions.InvalidQueryException: Cannot restrict clustering columns by IN relations when a collection is selected by the query Any ideas on why this isn't working?

Re: is there any problem having too many clustering columns?

2016-10-23 Thread Kant Kodali
t; There is nothing wrong with your schema, but just remember that because to > set everything except one as clustering columns, updating them is no longer > possible. To "update" the value of one of those columns you'll need to do a > DELETE + INSERT. > > Example: > &g

Re: is there any problem having too many clustering columns?

2016-10-23 Thread DuyHai Doan
There is nothing wrong with your schema, but just remember that because to set everything except one as clustering columns, updating them is no longer possible. To "update" the value of one of those columns you'll need to do a DELETE + INSERT. Example: with normal schema: UPDATE h

is there any problem having too many clustering columns?

2016-10-23 Thread Kant Kodali
Hi All, Is there any problem having too many clustering columns? My goal is to store data by columns in order and for any given partition (primary key) each of its non-clustering column (columns that are not part of primary key) can lead to a new column underneath or the CQL equivalent would

Re: Cannot restrict clustering columns by IN relations when a collection is selected by the query

2016-10-23 Thread Samba
ARY KEY ((hotel_id), rate_code) >> ); >> >> When executing the query: >> >> select rates from rates_by_code where hotel_id='AZ123' and rate_code IN >> ('ABC', 'DEF', 'GHI'); >> >> I receive the response message: >> >> Cannot restrict clustering c

Re: Cannot restrict clustering columns by IN relations when a collection is selected by the query

2016-10-21 Thread DuyHai Doan
gt; > I receive the response message: > > Cannot restrict clustering columns by IN relations when a collection is > selected by the query. > > If I select a non-collection column such as "description", no error occurs. > > Why does this restriction exist? Is

Cannot restrict clustering columns by IN relations when a collection is selected by the query

2016-10-21 Thread Jeff Carpenter
'); I receive the response message: Cannot restrict clustering columns by IN relations when a collection is selected by the query. If I select a non-collection column such as "description", no error occurs. Why does this restriction exist? Is this a restriction that is still necess

'CLUSTERING' columns

2015-06-23 Thread ICHIBA Sara
Hey there, I have imported the following schema to my cassandra db

Re: cassandra-stress with clustering columns?

2014-08-19 Thread Mikhail Stepura
to use the cassandra-stress tool with clustering columns? I am trying to figure out whether an application that I'm running on is slow because of my application logic, C* data model, or underlying C* setup (e.g., I need more nodes or to tune some parameters). My application uses tables with several

Re: cassandra-stress with clustering columns?

2014-08-19 Thread Clint Kelly
://github.com/Mishail/CqlJmeter -M On 8/17/14 12:26, Clint Kelly wrote: Hi all, Is there a way to use the cassandra-stress tool with clustering columns? I am trying to figure out whether an application that I'm running on is slow because of my application logic, C* data model, or underlying

Re: cassandra-stress with clustering columns?

2014-08-19 Thread Benedict Elliott Smith
The stress tool in 2.1 also now supports clustering columns: http://www.datastax.com/dev/blog/improved-cassandra-2-1-stress-tool-benchmark-any-schema There are however some features up for revision before release in order to help generate realistic workloads. See https://issues.apache.org/jira

Re: cassandra-stress with clustering columns?

2014-08-19 Thread Clint Kelly
Thanks for the update, Benedict. We are still using 2.0.9 unfortunately. :/ I will keep that in mind for when we upgrade. On Tue, Aug 19, 2014 at 10:51 AM, Benedict Elliott Smith belliottsm...@datastax.com wrote: The stress tool in 2.1 also now supports clustering columns: http

Re: cassandra-stress with clustering columns?

2014-08-19 Thread Benedict Elliott Smith
using 2.0.9 unfortunately. :/ I will keep that in mind for when we upgrade. On Tue, Aug 19, 2014 at 10:51 AM, Benedict Elliott Smith belliottsm...@datastax.com wrote: The stress tool in 2.1 also now supports clustering columns: http://www.datastax.com/dev/blog/improved-cassandra-2-1-stress

cassandra-stress with clustering columns?

2014-08-17 Thread Clint Kelly
Hi all, Is there a way to use the cassandra-stress tool with clustering columns? I am trying to figure out whether an application that I'm running on is slow because of my application logic, C* data model, or underlying C* setup (e.g., I need more nodes or to tune some parameters). My

Re: cassandra-stress with clustering columns?

2014-08-17 Thread Clint Kelly
columns make a big difference in write performance? On Sun, Aug 17, 2014 at 12:26 PM, Clint Kelly clint.ke...@gmail.com wrote: Hi all, Is there a way to use the cassandra-stress tool with clustering columns? I am trying to figure out whether an application that I'm running on is slow because

Re: CQL: Any way to have inequalities on multiple clustering columns in a WHERE clause?

2014-02-28 Thread Clint Kelly
' ALLOW FILTERING On Fri, Feb 28, 2014 at 6:57 AM, Clint Kelly clint.ke...@gmail.comwrote: All, Is there any way to have inequalities comparisons on multiple clustering columns in a WHERE clause in CQL? For example, I'd like to do: select * from foo where fam = 'Info' and qual 'A' and qual 'D

CQL: Any way to have inequalities on multiple clustering columns in a WHERE clause?

2014-02-27 Thread Clint Kelly
All, Is there any way to have inequalities comparisons on multiple clustering columns in a WHERE clause in CQL? For example, I'd like to do: select * from foo where fam = 'Info' and qual 'A' and qual 'D' and version 2013 ALLOW FILTERING; I get an error: Bad Request: PRIMARY KEY part

Re: CQL: Any way to have inequalities on multiple clustering columns in a WHERE clause?

2014-02-27 Thread DuyHai Doan
way to have inequalities comparisons on multiple clustering columns in a WHERE clause in CQL? For example, I'd like to do: select * from foo where fam = 'Info' and qual 'A' and qual 'D' and version 2013 ALLOW FILTERING; I get an error: Bad Request: PRIMARY KEY part version cannot