Re: Unable to drop secondary index

Hi Aaron, Was the schema created with CQL or the CLI ? It was created using Pycassa and - as far as I know - it was managed only by CLI. > (It's not a good idea to manage one with the other) Yes, I know - I only tried using CQL after I realized that CLI is not working, as I had to make it

Re: differences between DataStax Community Edition and Cassandra package

I am sorry if this a very well know topic and I missed that. I wonder why one must use CFS. What is unavailable in Cassandra without CFS? Best, -- Goktug On Thu, Apr 18, 2013 at 9:33 PM, aaron morton wrote: > sorry to ask in this thread, but from some time I am wondering how CFS can > be insta

Prepared Statement - cache duration (CQL3 - Cassandra 1.2.4)

Hi, I am using Cassandra.Client prepare_cql3_query/execute_prepared_cql3_query to create and run some prepared statements. It is working well but I am unclear as to how long the server side 'caches' the prepared statements. Should a prepared statement be prepared for every new Cassandra.Client?

Re: Key-Token mapping in cassandra

It should be Key4 --> 123 And you store it in the Image CF or the Documents CF or the MultiMedia CF….then it ends up all on the same machine as the CF breaks the row apart. Dean From: Alicia Leong mailto:lccali...@gmail.com>> Reply-To: "user@cassandra.apache.org

Datastax Java Driver connection issue

Hi, I have downloaded the CQL driver provided by Datastax using com.datastax.cassandra cassandra-driver-core 1.0.0-beta2 Then tried a sample program to connect to the cluster Cluster cluster = Cluster.builder() .addContactPoints

Re: Datastax Java Driver connection issue

Have you started the native transport on cassandra nodes? Look into cassandra.yaml file, for native.transport. By default is disabled. Br, Gabi On 4/19/13 4:16 PM, Abhijit Chanda wrote: Hi, I have downloaded the CQL driver provided by Datastax using com.datastax.cassandra cassandra-dri

Re: Datastax Java Driver connection issue

Did you enable the binary protocol in Cassandra.yaml? Abhijit Chanda wrote: Hi, I have downloaded the CQL driver provided by Datastax using com.datastax.cassandra cassandra-driver-core 1.0.0-beta2 Then tried a sample program to connect to

Re: Datastax Java Driver connection issue

@Gabriel, @Wright: thanks, such a silly of me. On Fri, Apr 19, 2013 at 6:48 PM, Keith Wright wrote: > Did you enable the binary protocol in Cassandra.yaml? > > Abhijit Chanda wrote: > > > Hi, > > I have downloaded the CQL driver provided by Datastax using > > com.datast

Re: Unable to drop secondary index

It seems we can't update schemas at all. I tried to change read_repair_chance and it looks the same. However, in this case I'm 99% sure that some of the CFs I tried to update were NOT updated using CQL *ever* - only CLI. Not good... But, as I mentioned before - we did the same on test cluster

Advice on memory warning

Hello, We've recently upgraded from m1.large to m1.xlarge instances on AWS to handle additional load, but to also relieve memory pressure. It appears to have accomplished both, however, we are still getting a warning, 0-3 times a day, on our database nodes: WARN [ScheduledTasks:1] 2013-04-19

Re: Moving cluster

Hello and thank you for your answers. The first solution is much easier for me because I use the vnode. What is the risk of the first solution thank you, 2013/4/18 aaron morton > This is roughly the lift and shift process I use. > > Note that disabling thrift and gossip does not stop an exis

Re: differences between DataStax Community Edition and Cassandra package

On Fri, Apr 19, 2013 at 4:18 AM, Goktug YILDIRIM wrote: > > I am sorry if this a very well know topic and I missed that. I wonder why one > must use CFS. What is unavailable in Cassandra without CFS? The SOLR stuff (also only-in-DSE) uses CFS for Hadoop-like storage. This is so you can use full

Re: Key-Token mapping in cassandra

I think I have simplified my example a little too much. Lets assume that there are groups and users. Ideally a grpId becomes the key and it holds some meta-data. Lets say GroupMetaCF grpId --> key, entityId --> col-name, blobdata --> col-value Now we have a UserTimeSeriesCF grpId/userId --> k

Batch get queries

Hi all, I am using C* 1.2.4 and using CQL3 with Astyanax to consume large amount of user based data (around 50-100K / sec). Requests come in based on user cookies which I then need to link to a user (as users can change their cookies). This is done using a link table: CREATE TABLE cookie_

index filter

Guys - Quick question. The index filter file created for a sstable contains all keys/index offset for a sstable ? I know that when we bring up the node, it reads a sample of the keys from this file. So this file contains all keys and a sample is read on startup ? Thanks, Kanwar

Re: index filter

On Fri, Apr 19, 2013 at 10:38 AM, Kanwar Sangha wrote: > Guys – Quick question. The index filter file created for a sstable contains > all keys/index offset for a sstable ? I know that when we bring up the node, > it reads a sample of the keys from this file. So this file contains all keys > and a

Re: CQL

Please can any body help me to solve the above problem. I stuck with that problem in my project. help me

Re: CQL

In order to do a query like that you'll need to have a timestamp/date as the second portion of the primary key. You'll only be able to do queries where you already know the key. Unless you're using an OrderPreservingPartitioner, there is no way to get a continuous set of information back based on

Re: CQL

A lot more details on your usecase and requirements would help. You need to make specific considerations in cassandra when you have requirements around ordering. Ordering can be achieved across columns. Ordering across rows is a bit more tricky and may require the use of specific partitioners

Re: index filter

Let me rephrase. I am talking about the index file on disk created per sstable. Does that contain all key indexes? Sent from Samsung mobile Robert Coli wrote: On Fri, Apr 19, 2013 at 10:38 AM, Kanwar Sangha wrote: > Guys – Quick question. The index filter file created for a sstable contains

Re: index filter

On Fri, Apr 19, 2013 at 11:36 AM, Kanwar Sangha wrote: > Let me rephrase. I am talking about the index file on disk created per > sstable. Does that contain all key indexes? Yes. That's how sstablekeys can relatively efficiently produce a list of keys, by parsing the index file. =Rob

[RELEASE] Apache Cassandra 1.1.11

The Cassandra team is pleased to announce the release of Apache Cassandra version 1.1.11. Downloads of source and binary distributions are listed on the website: http://cassandra.apache.org/download/ As usual this release includes a Debian package, but you can expect some delay in seeing it p

Re: Datastax API which uses Binary protocol- Quick question

On Thu, Apr 18, 2013 at 9:02 PM, Techy Teck wrote: > > When I was working with Cassandra CLI using the Netflix client(Astyanax > client), then I created the column family like this- > > create column family profile > with key_validation_class = 'UTF8Type' > and comparator = 'UTF8Type'

Re: differences between DataStax Community Edition and Cassandra package

Is there alternative file systems running on top of cassandra? On Fri, Apr 19, 2013 at 7:44 PM, Robert Coli wrote: > On Fri, Apr 19, 2013 at 4:18 AM, Goktug YILDIRIM > wrote: > > > > I am sorry if this a very well know topic and I missed that. I wonder > why one must use CFS. What is unavaila

Re: Prepared Statement - cache duration (CQL3 - Cassandra 1.2.4)

On 2013-04-19 13:57, Stuart Broad wrote: Hi, I am using Cassandra.Client prepare_cql3_query/execute_prepared_cql3_query to create and run some prepared statements. It is working well but I am unclear as to how long the server side 'caches' the prepared statements. Should a prepared statement b

Re: Cassandra bulk import confusion

> On 30 Jul 2011, at 04:10, Jeff Schmidt wrote: > Hello: > I'm relatively new to Cassandra, but I've been searching around, > and it looks like Cassandra 0.8.x >has improved support for bulk importing of data.  I keep finding > references to the json2sstable >command, and I've read about that o

Re: Datastax API which uses Binary protocol- Quick question

Thanks a lot Tyler. That clears lot of my doubt. I have couple more questions related to Datastax Java Driver- 1) Firstly, is there any way to figure out what version of CQL I am running? Is it CQL 3 or something else? Is there any command that we can use to check? Abd also by default CQLish behav

Re: Datastax Java Driver connection issue

I am also running into this problem. I have already enabled *start_native_transport: true* And by this, I am trying to make a connection- private CassandraDatastaxConnection() { try{ cluster = Cluster.builder().addContactPoint("localhost").build(); session = c

Building SSTables using SSTableSimpleUnsortedWriter (v. 1.2.3)

Was trying to do a test of writing SSTs for a CQL3 table. So I created the following table: CREATE TABLE test_sst_load ( mykey1 ascii, mykey2 ascii, value1 ascii, PRIMARY KEY (mykey1, mykey2) ) I then set up my writer like so: (moved to gist: https://gist.github.com/dmcnelis/5424756 ) T