Re: strange get_range_slices behaviour v0.6.1

. Can you give a little advice on the expected behaviour of get_range_slices with the RP and I'll try to write a JUnit for it. e.g. Is it essentially the same as under the OPP but order is undefined? Thanks Aaron On Mon, 3 May 2010 10:27:37 -0500, Jonathan Ellis wrote: > Util.range r

RE: read operation is slow

x27;re using is doing the right thing, just an suggestion. Aaron On Fri, 11 Jun 2010 18:49:46 -0700, "caribbean410" wrote: > Thanks for the suggestion. For the test case, it is 1 key and 1 column. I > once changed 10 to 1, as I remember there is no much difference. > >

stalled streaming

Hello,

stalled streaming

hello, I have a 4 node cassandra cluster with 0.6.1 installed. We've been running a mixed read / write workload test how it works in our environment, we run about 4M bath mutations and 40M get_range_slice requests over 6 to 8 hours that load about 10 to 15 GB of data. Yesterday while there was

Re: stalled streaming

Thanks, will move to 0.6.2. Aaron On Tue, 15 Jun 2010 15:55:46 -0700, Benjamin Black wrote: > Known bug, fixed in latest 0.6 release. > > On Tue, Jun 15, 2010 at 3:29 PM, aaron wrote: >> hello, >> >> I have a 4 node cassandra cluster with 0.6.1 installed. We&#x

strange get_range_slices behaviour v0.6.1

ormation on the sort order of keys when using key ranges? I'm guessing the hash of the keys is compared and I wondering if the hash's of the keys maintain the order of the original values? Also I assume the order is byte order, rather than ascii or utf8. I was experimenting with the difference between column slicing and key slicing. In my I could write the keys in as column names (they are in buckets) as well and slice there first, then use the results to to make a multi key get. I'm trying to support features like, get me all the data where the key starts with "foo.bar". Thanks for the fun project. Aaron

Re: strange get_range_slices behaviour v0.6.1

=[123092639156685888118746480803115294277,0], max_keys=1000} DEBUG 09:35:26,090 Adding to restricted ranges [123092639156685888118746480803115294277,0] for (75349581786326521367945210761838448174,75349581786326521367945210761838448174] DEBUG 09:35:26,090 reading RangeSliceCommand{keyspace='Keyspace1&

Re: Cassandra didn't order data according to clustering order

nt doesn't appear to be in any discernable order until you apply the token function to it. Aaron On Sun, Jul 15, 2018 at 8:05 AM, Soheil Pourbafrani wrote: > To the point, Thanks! > > On Sun, Jul 15, 2018 at 4:31 PM, shalom sagges > wrote: > >> The clustering column is or

Re: Question about hector api documentation

ava driver. Aaron On Fri, Jun 24, 2016 at 11:09 AM, Jonathan Haddad wrote: > +1, do not use Hector. It hasn't had a commit in years and uses the thrift > protocol which is now marked deprecated. The DataStax Java driver is > recommended, possibly with Achilles to make things a bit

Re: Openstack and Cassandra

r external cloud providers. Hope that helps, Aaron On Thu, Dec 22, 2016 at 9:51 AM, Shalom Sagges wrote: > Thanks Vladimir! > > I guess I'll just have to deploy and continue from there. > > > > > Shalom Sagges > DBA > T: +972-74-700-4035 <+972%2074-700-4035&g

Re: JNA on Windows

Processes start differently on windows. On windows it uses mklink to make a hard link https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/utils/CLibrary.java#L170 Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 6

Re: CQL 3 with a right API

Row keys are distinct. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 6/07/2012, at 7:30 AM, Shahryar Sedghi wrote: > Hi > > I am new to to Cassandra and we started with 1.1 and modeled everything with > Composite columns a

Re: Multiple keyspace question

ch I would take.) Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 7/07/2012, at 8:15 AM, Shahryar Sedghi wrote: > Aaron > > I am going to have many (over 50 eventually) keyspaces with limited number of > CFs (5-6) do you t

Re: Composite Slice Query returning non-sliced data

Something like: This is how I did the write in CLI and this is what it printed. and then This is how I did the read in the CLI and this is what it printed. It's hard to imagine what data is in cassandra based on code. cheers - Aaron Morton Freelance Developer @aaronm

Re: Effect of rangequeries with RandomPartitioner

for background http://wiki.apache.org/cassandra/FAQ#range_rp It maps the start key to a token, and then scans X rows from their on CL number of nodes. Rows are stored in token order. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 7/07

Re: cannot build 1.1.2 from source

Did you try running ant clean first ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 8/07/2012, at 1:57 PM, Arya Goudarzi wrote: > Hi Fellows, > > I used to be able to build cassandra 1.1 up to 1.1.1 with the same set > of p

Re: Serious issue updating Cassandra version and topology

have the same version, the -h?- part of the name. Can you repair the other CF's ? If this cannot be repaired by scrub or upgradetables you may need to cut the row out of the sstables. Using sstable2json and json2sstable. Cheers - Aaron Morton Freelance Developer @aaronm

Re: Effect of rangequeries with RandomPartitioner

Index files map keys (not tokens) to offsets in the data file. A range scan uses the index file to seek to the start position in the data file and then does a partial scan of the data file. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On

Re: Setting the Memtable allocator on a per CF basis

a plan. Thanks - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 10/07/2012, at 1:47 AM, Joost van de Wijgerd wrote: > Hello Cassandra Devs, > > We are currently trying to optimize our Cassandra system with > different workloads. One of our

Re: Composite Slice Query returning non-sliced data

heers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 10/07/2012, at 12:36 PM, Sunit Randhawa wrote: > Aaron, > > Let me start from the beginning. > > 1- I have a ColumnFamily called Rollup15 with below definition: > > cre

Re: BulkLoading sstables from v1.0.3 to v1.1.1

steps to reproduce, can you raise a ticket on https://issues.apache.org/jira/browse/CASSANDRA ? Thanks - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 10/07/2012, at 7:43 PM, rubbish me wrote: > Thanks Ivo. > > We are quite close to rel

Re: Using a node in separate cluster without decommissioning.

a lot of repair activity. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/07/2012, at 6:35 AM, rohit bhatia wrote: > Hi > > I want to take out 2 nodes from a 8 node cluster and use in another > cluster, but can't

Re: failed to delete commitlog, cassandra can't accept writes

u also check if the file it tries to delete exists ? (I assume it does, otherwise it would be a different error). Thanks for digging into this. ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/07/2012, at 9:36 AM, Frank Hsueh wrote: > oops;

Re: snapshot issue

Make sure JNA is in the class path http://wiki.apache.org/cassandra/FAQ#jna Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/07/2012, at 9:38 PM, Adeel Akbar wrote: > Hi, > > I am trying to taking snapshot of my data but faced

Re: Connected file list in Cassandra

iterate over the Document CF and read from Page CF. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/07/2012, at 7:47 AM, David Brosius wrote: > > why not just hold the pages as different columns in the same row? colum

Re: Composite column/key creation via Hector

You may have better luck on the Hector Mailing list… https://groups.google.com/forum/?fromgroups#!forum/hector-users Here is something I found in the docs though http://hector-client.github.com/hector/build/html/content/composite_with_templates.html Cheers - Aaron Morton

Re: Concerns about Cassandra upgrade from 1.0.6 to 1.1.X

It's always a good idea to have a read of the NEWS.txt file https://github.com/apache/cassandra/blob/cassandra-1.1/NEWS.txt Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/07/2012, at 5:51 PM, Tyler Hobbs wrote: > On Wed, Jul

Re: How to come up with a predefined topology

lication can be tricky. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/07/2012, at 8:05 PM, prasenjit mukherjee wrote: > Thanks. Some follow up questions : > > 1. How do the reads use strategy/snitch information ? I am

Re: Increased replication factor not evident in CLI

Do multiple nodes say the RF is 2 ? Can you show the output from the CLI ? Do show schema and show keyspace say the same thing ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/07/2012, at 7:39 AM, Dustin Wenz wrote: > We recen

Re: Concerns about Cassandra upgrade from 1.0.6 to 1.1.X

gnashing of teeth. In general, node by node: * drain * snapshot * shutdown * upgrade * turn on. When they are all up I snap shot again if there is space. Then run upgradetables. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/07

Re: High RecentWriteLatencyMicro

ds(4,000-10,000) with names like > "pool-2-thread-*" These are connection threads. Use connecting pooling or try the thread pooled connection manager, see yaml for details. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/0

Re: How to come up with a predefined topology

> Is the above understanding correct ? yes, sorry. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/07/2012, at 4:24 PM, prasenjit mukherjee wrote: > On Fri, Jul 13, 2012 at 4:04 AM, aaron morton wrote: >> The logic is h

Re: Never ending manual repair after adding second DC

txt#L5 Good luck. ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/07/2012, at 10:16 PM, Bart Swedrowski wrote: > Hello everyone, > > I'm facing quite weird problem with Cassandra since we've added > secondary DC to our c

Re: bootstrapping problem. 1.1.2 version

Check net stats a few times to look for progress, if there is none take a look at the logs on both sides for errors. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 14/07/2012, at 10:53 PM, Michael Cherkasov wrote: > Hi

Re: Cassandra occupy over 80% CPU when take a compaction

Are you able to put together a test case, maybe using the stress testing tool, that models your data layout? If so can you add it to https://issues.apache.org/jira/browse/CASSANDRA-3592 Thanks - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 16

Re: Enable CQL3 from Astyanax

Can you provide an example where you add data, run a CQL statement in cqlsh that does not work and maybe list the data in the CLI. cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 16/07/2012, at 8:25 PM, Thierry Templier wrote: > He

Re: bootstrapping problem. 1.1.2 version

> DC located in different environments one on Win7 other on Linux. Running different operating systems is not supported. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 12:30 AM, Michael Cherkasov wrote: > I foun

Re: Snapshot issue in Cassandra 0.8.1

ame Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 4:00 AM, Adeel Akbar wrote: > Hi, > > I have created snapshot with following command; > > #./nodetool -h localhost snapshot cassandra_01_bkup > >

Re: Never ending manual repair after adding second DC

heers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 4:32 AM, Bill Au wrote: > I had ran into the same problem before: > > http://comments.gmane.org/gmane.comp.db.cassandra.user/25334 > > I have not fond any solutions yet. > >

Re: high i/o usage on one node

? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 5:12 AM, feedly team wrote: > I am having an issue where one node of a 2 node cluster seems to be using > much more I/O than the other node. the cassandra read/write re

Re: Truncate failing with 1.0 client against 0.7 cluster

UnavailableException is a server side error, whats the full error message ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 5:31 AM, Guy Incognito wrote: > i'm doing an upgrade of Cassandra 0.7 to 1.0 at the moment

Re: Truncate failing with 1.0 client against 0.7 cluster

truncate requires all all nodes to be available. Let us know when you have the full error. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 10:04 AM, Guy Incognito wrote: > sorry i don't have the exact text right

Re: Cassandra 1.0 hangs during GC

; for your cf's ? I would upgrade to 1.0.10 before getting too carried away though. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 8:14 PM, Nikolay Kоvshov wrote: > > This is a cluster of 2 nodes, each hav

Re: create if not exists ? create or update ?

It's not in the language as it stands. If you would like to see it add a request to https://issues.apache.org/jira/browse/CASSANDRA and maybe help out :) Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/07/2012, at 1:14 AM, Илья Ши

Re: Presentation, CQL 3 and Paging

a way to do this with it) The only way to page is to provide a start column and get the next X columns. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/07/2012, at 3:54 AM, Bruno Di Pentima wrote: > Hello all! > > I'm new to

Re: Cassandra Evaluation/ Benchmarking: Throughput not scaling as expected neither latency showing good numbers

e the latency increase and tasks start to back up in nodetool tpstats. If you see it report dropped messages it is over loaded. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/07/2012, at 4:48 AM, Code Box wrote: > Thanks a lot

Re: Cassandra Evaluation/ Benchmarking: Throughput not scaling as expected neither latency showing good numbers

numpy for python. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/07/2012, at 11:29 PM, Manoj Mainali wrote: > How kind of client are you using in YCSB? If you want to improve latency, try > distributing the requests among n

Re: Can't change replication factor in Cassandra 1.1.2

it applies here. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/07/2012, at 5:27 AM, Douglas Muth wrote: > Hi folks, > > I have an interesting problem in Cassandra 1.1.2, a Google Search > wasn't much help, so I

Re: Cassandra startup times

the await time in iostat. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/07/2012, at 4:54 PM, Ben Kaehne wrote: > Good evening, > > I am interested in improving the startup time of our cassandra cluster. > > W

Re: Tripling size of a cluster

. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/07/2012, at 6:00 PM, Mariusz Dymarek wrote: > Hi again, > we have now moved all nodes to correct position in ring, but we can see > higher load on 2 nodes, than on other nodes: >

Re: Unreachable node, not in nodetool ring

I would: * run repair on 10.58.83.109 * run cleanup on 10.59.21.241 (I assume this was the first node). It looks like 0.56.62.211 is out of the cluster. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/07/2012, at 9:37 PM, Alain

Re: Counters values are less than expected [1.0.6 - Java/Pelops]

Nothing jumps out, can you reproduce the problem ? If you can repo it let us know and the RF / CL. Good luck. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/07/2012, at 1:07 AM, cbert...@libero.it wrote: > Hi all, I have a problem w

Re: random partitioner and key scan

range. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/07/2012, at 4:46 AM, prasenjit mukherjee wrote: > When a request for token change is issued ( via nodetool ) then on > what basis a node will move some of its rows to other no

Re: Seeing writes when only expecting reads

My first guess would be read repair, are you seeing any increase in ReadRepairStage tasks ? RR (in 1.X) is normally only enabled for 10% of the request. cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/07/2012, at 5:17 AM, jmodha wrote

Re: does secondary index get created(rebuilt?) every time Cassandra restarts?

the system reading the index meta data. Do you see any INFO level messages with "Submitting index build" ? cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/07/2012, at 5:52 AM, Feng Qu wrote: > We have a CF with 11 seconda

Re: Replication factor - Consistency Questions

> But isn't QUORUM on a 2-node cluster still 2 nodes? Yes. 3 is where you start to get some redundancy - http://thelastpickle.com/2011/06/13/Down-For-Me/ Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/07/2012, at 10:24 AM, K

Re: Batch update efficiency with composite key

I'm assuming the logical row is in a CQL 3 CF with composite PRIMARYKEY http://www.datastax.com/dev/blog/whats-new-in-cql-3-0 It will still be a no look write. The exception being secondary indexes and counters which include reads in the write path. Cheers - Aaron M

Re: 0.8 --> 1.1 Upgrade: Any Issues?

Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/07/2012, at 4:10 PM, Peter Schuller wrote: >> We currently have a 0.8 production cluster that I would like to upgrade to >> 1.1. Are there any know compatibility or upgrade issue

Re: Cassandra data model help

in the new CF and then deletes the original row. By doing this, my disk space requirements (before replication) went from over 1.1TB/year to 305GB/year. -- Aaron Turner http://synfin.net/ Twitter: @synfinatic http://tcpreplay.synfin.net/ - Pcap editing and replay tools for Unix & Windo

Re: Cassandra data model help

: > Thanks Aaron for your reply, > creating vector for raw data is good work around for decreasing disk space, > but I am not still clear tracking time for nodes, say if we want a query like > give me the list of nodes for a cluster between this period of time then how > do we ge

quick question about data layout on disk

Curious, but does cassandra store the rowkey along with every column/value pair on disk (pre-compaction) like Hbase does? If so (which makes the most sense), I assume that's something that is optimized during compaction? -- Aaron Turner http://synfin.net/ Twitter: @synfinatic

Re: quick question about data layout on disk

column to row J, how does Cassandra store the column/value pair on disk in a way to refer to row J without re-writing the row key or some representation of it? Thanks, Aaron On Fri, Aug 10, 2012 at 7:53 PM, Terje Marthinussen wrote: > Rowkey is stored only once in any sstable file. > >

Re: quick question about data layout on disk

table. > > See http://wiki.apache.org/cassandra/MemtableSSTable > > On Sat, Aug 11, 2012 at 11:03 AM, Aaron Turner wrote: >> So how does that work? An sstable is for a single CF, but it can and >> likely will have multiple rows. There is no read to write and as I >> unde

Re: DSE solr HA

You may have more luck on the DS forums http://www.datastax.com/support-forums/ Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/08/2012, at 6:00 AM, Mohit Anchlia wrote: > > Going through this page and it looks like index

Re: [gem] does "disconnect!" work properly?

://github.com/twitter/cassandra/blob/master/lib/cassandra/cassandra.rb#L1043 If you still feel there is an problem the Issue list of github is probably the place to go https://github.com/twitter/cassandra/issues Cheers - Aaron Morton Freelance Developer @aaronmorton http

Re: Problem with cassandra startup on Linux

ot; #else JVM_OPTS="$JVM_OPTS -Xss128k" #fi fi Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/08/2012, at 5:16 PM, Dwight Smith wrote: > Installed 1.1.3 on my Linux cluster – the JVM_OPTS were truncated

Re: Custom Partitioner Type

k to see if the effects you could use the BOP and format the keys as (python): str(key % 2) + "{0:0>#10}".format(key) So all keys are 11 digit strings, even keys start with 0 and odd with 1. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://w

Re: GCInspector info messages in cassandra log

down compaction. Once you have GC under control you may want to play with memory settings. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 14/08/2012, at 4:45 PM, Tamar Fraenkel wrote: > Hi! > I have 3 nodes ring runn

Re: What are the basic steps to improve Cassandra performance

or are you trying to get multiple rows ? Getting the columns from the start of row is the most efficient query, see my presentation here http://www.datastax.com/events/cassandrasummit2012/presentations Hope that helps. ----- Aaron Morton Freelance Developer @aaronmorton http://

Re: GCInspector info messages in cassandra log

s not look that way. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/08/2012, at 3:15 AM, Tamar Fraenkel wrote: > Hi! > It helps, but before I do more actions I want to give you some more info, and > ask some questions: > > Related

Re: incremental backup and Priam?

The Priam code is looking for the //backups directory created by cassandra during incremental backups. If it finds it the files are uploaded to S3. It's taking the built in incremental backups off node. (AFAIK) Cheers - Aaron Morton Freelance Developer @aaronmorton

Re: replace dead node? " token -1 "

ip) cause problems? If the nodes are bootstrapping an error is raised. Otherwise the token ownership is passed to the new node. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/08/2012, at 11:07 AM, Yang wrote: > previously when a

Re: Partial composite result limit possible?

columns reversed so you can select from (0, null) to (2, null). http://pycassa.github.com/pycassa/assorted/composite_types.html?#fetching-compositetype-data Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/08/2012, at 4:10 PM

Re: GCInspector info messages in cassandra log

ions here, which are pretty much what you have described http://www.datastax.com/docs/1.0/operations/backup_restore Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/08/2012, at 4:57 PM, Tamar Fraenkel wrote: > Aaron, > Thank you v

Re: CQL3: Do boolean values need quoting in inserts?

Quoting false is correct from my reading of the Antlr grammar. Constant terms are either strings, UUID, int or long. I'm sure someone from DS will pickup the comment you made on the post and fix the example. Cheers - Aaron Morton Freelance Developer @aaronmorton

Re: Migrating to a new cluster (using SSTableLoader or other approaches)

tool with DEBUG level logging and post the logs ? Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/08/2012, at 9:32 PM, Filippo Diotalevi wrote: > Hi, > we are trying to use SSTableLoader to bootstrap a new 7-node cassandra (v.

Re: Composite Column Slice query, wildcard first component?

> Is there a way to create a slice query that returns all columns where the > _second_ component is A? No. You can only get a contiguous slice of columns. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 16/08/2012, at 7:21 AM, Mik

Re: indexing question related to playOrm on github

es at a time. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 16/08/2012, at 12:34 PM, "Hiller, Dean" wrote: > 1. Can playOrm be listed on cassandra's list of ORMs? It supports a JQL/HQL > query on a trilli

Re: SSTable Index and Metadata - are they cached in RAM?

012-technical-deep-dive-query-performance > and Metadata? This is the meta data we hold in memory for every open sstable https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/io/sstable/SSTableMetadata.java Cheers - Aaron Morton Freelance Dev

Re: Migrating to a new cluster (using SSTableLoader or other approaches)

exception message. Also change the logging in log4j-tools.properties for get DEBUG messages so we can see what's going on. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 16/08/2012, at 8:51 PM, Filippo Diotalevi wrote: >>> ERRO

Re: wild card on query

e of weeks ago that shows denormalising data https://github.com/amorton/wdcnz-2012-site and http://www.slideshare.net/aaronmorton/hellow-world-cassandra Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 12:39 AM,

Re: indexing question related to playOrm on github

to repair it's index entries. When repairing the index entry play with the timestamp so any deletions you make only apply to the column as it was when you saw the error. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/0

Re: nodetool repair uses insane amount of disk space

What version are using ? There were issues with repair using lots-o-space in 0.8.X, it's fixed in 1.X Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 2:56 AM, Michael Morris wrote: > Occasionally as I'm doi

Re: Opscenter 2.1 vs 1.3

You may have better luck on the Data Stax forums http://www.datastax.com/support-forums/ Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 4:36 AM, Robin Verlangen wrote: > Hi there, > > I just upgraded to opsc

Re: C++ Bulk loader and Result set streaming.

ng C++ client. Is there any C++ supporting code or information on > streaming the result set into a file or something. I've not looked at the C++ client, but normally you use the last column returned as the start column for the next call. Cheers - Aaron Morton Freelance De

Re: 'WHERE' with several indexed columns

her.java > Also is index used only with an equality operator or also with greater equality Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 7:13 AM, A J wrote: > Hi > If I have a WHERE clause in CQL with several

Re: Why the StageManager thread pools have 60 seconds keepalive time?

That's some pretty old code. I would guess it was done that way to conserve resources. And _i think_ thread creation is pretty light weight. Jonathan / Brandon / others - opinions ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On

Re: nodetool repair uses insane amount of disk space

if needed. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 11:14 AM, Michael Morris wrote: > Upgraded to 1.1.3 from 1.0.8 about 2 weeks ago. > > On Thu, Aug 16, 2012 at 5:57 PM, aaron morton wrote: > What version a

Re: Cassandra 1.0 row deletion

> If you use the remove function to delete an entire row, is that an atomic > operation? Yes. Row level deletes are atomic. cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 3:39 PM, Derek Williams wrote: > On Th

Re: SSTable Index and Metadata - are they cached in RAM?

hat sorted row keys (from point 2) ) already contain bloom > filter for their columns. But bloom filter is stored together with column > index, is that correct? Yes Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, a

Re: Omitting empty columns from CQL SELECT

If you specify the columns by name in the select clause the query returns them because they should be projected in the result set. Can you use a column slice instead ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 11:09

Re: What is the ideal server-side technology stack to use with Cassandra?

s (namely PHPCassa (https://github.com/thobbs/phpcassa/) and >> PDO-cassandra (http://code.google.com/a/apache-extras.org/p/cassandra-pdo/), >> and the experience hasn't been great, mainly because I can't try out >> the CQL3. >> >> Aaron Morton (aa...@thelastpickle.c

Re: Omitting empty columns from CQL SELECT

ith the amount of data pages that must be read to satisfy the query. Note though that this is better in 1.X . See slide 61 in the first link and "In Motion - Name Locality" section in the second. Hope that helps. ----- Aaron Morton Freelance Developer @aar

Re: Bad Request: Duplicate index name

Can you provide: * the CF existing schema and output from nodetool cfstats * the command you are running * the error you get Also it's handy to know what version the schema was originally created in. Cheers - Aaron Morton Freelance Developer @aaronmorton

Re: indexing question related to playOrm on github

-written with timestamp 2. Remember I said "sometimes". Playing with timestamps often leads to questions such as "why did my inserts not work". Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/08/2012, at 1:30 AM, &

Re: Why the StageManager thread pools have 60 seconds keepalive time?

that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/08/2012, at 10:01 AM, Guillermo Winkler wrote: > Aaron, thanks for your answer. > > I'm actually tracking a problem where mutations get dropped and cfstats show >

Re: What is the ideal server-side technology stack to use with Cassandra?

> Aaron Morton (aa...@thelastpickle.com) advised: > > "If possible i would avoid using PHP. The PHP story with cassandra has > not been great in the past. There is little love for it, so it takes a > while for work changes to get in the client drivers. > > AFAIK it lack

Re: Secondary index and/or row key in the read path ?

omething that is planned for CQL. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/08/2012, at 6:33 PM, Jean-Armel Luce wrote: > > Hello, > > I am using Cassandra 1.1.1 and CQL3. > > Could you tell me what is the best str

Re: Cassandra with large number of columns per row

more than say 32 or 64 MB of data. It's not a hard restriction but big rows cause issues and it's often easier to avoid them. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/08/2012, at 8:15 PM, Chuan-Heng

Re: Best strategy to increase cluster size and keep nodes balanced

that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 21/08/2012, at 12:57 AM, Filippo Diotalevi wrote: > What's the best strategy to increase the cluster size from 3 nodes to 7 > nodes, while keeping the nodes balanced?

  1   2   3   4   5   6   7   8   9   10   >