What Happened To Alternate Storage And Rocksandra?

2021-03-12 Thread Gareth Collins
)...and was wondering if there could be some important info about RocksDB I may be missing. thanks in advance, Gareth Collins

Re: Stumped By Cassandra delays

2018-07-22 Thread Gareth Collins
t; > If batches are optimally used and only one node is misbehaving, check if > NTP on the node is properly synced. > > Hope this helps! > > > On Sat, Jul 21, 2018 at 9:31 PM, Gareth Collins < > gareth.o.coll...@gmail.com> wrote: > >> Hello, >> >>

Stumped By Cassandra delays

2018-07-21 Thread Gareth Collins
arallelizing of these requests (I think the thread count was reduced in the past before the C* server upgrade and we still had problems, but I could always try again). Any ideas/suggestions are greatly appreciated. thanks in advance, Gareth Collins ---

Re: Performance Of IN Queries On Wide Rows

2018-02-21 Thread Gareth Collins
, all the reads are going to be served from > a single replica. Compared to many concurrent individual equal statements > you can get the performance gain of leaning on several replicas for > parallelism. > > On Tue, Feb 20, 2018 at 11:43 AM Gareth Collins <gareth.o.coll...@gmail.com

Performance Of IN Queries On Wide Rows

2018-02-20 Thread Gareth Collins
are there some additional caveats that I should be aware of for 'IN' query performance (e.g. ordering of 'IN' query entries, closeness of 'IN' query values in the SSTable etc.)? thanks in advance, Gareth Collins --

Weird Bootstrapping Issue

2017-05-01 Thread Gareth Collins
Hi, We are running Cassandra 2.1.14 on an IBM AIX cluster using IBM Java 7 (1.7.1.64). I am having problems adding new nodes to the cluster. I am seeing the following exception. It appears like the new node is getting stuck trying to send the magic number on the first streaming socket...whilst

Cassandra Memory Question

2014-03-09 Thread Gareth Collins
Hello, I have a question about CQL memory usage. I am currently using 1.2.9. If I have a Cassandra table like this (created using Astyanax API): CREATE TABLE table_name ( key text, column1 text, value blob, PRIMARY KEY (key, column1) ) WITH COMPACT STORAGE; and I run a query like this:

Re: Secondary Indexes On Partitioned Time Series Data Question

2013-08-02 Thread Gareth Collins
OK, thanks for the information. Gareth On Thu, Aug 1, 2013 at 3:53 PM, Robert Coli rc...@eventbrite.com wrote: On Thu, Aug 1, 2013 at 12:49 PM, Gareth Collins gareth.o.coll...@gmail.com wrote: Would this be correct? Just making sure I understand how to best use secondary indexes

Secondary Indexes On Partitioned Time Series Data Question

2013-08-01 Thread Gareth Collins
Hello, Say I have time series data for a table like this: CREATE TABLE mytimeseries ( pk_part1 text, partition bigint, e.g. partition per day or per hour pk_part2 text, this is part of the partition key so I can split write load message_id timeuuid, secondary_key1 text,

Re: Coprosessors/Triggers in C*

2013-06-13 Thread Gareth Collins
what feature you suggesting. Columns can already have a ttl. Are you speaking of a ttl column that could delete something beside itself. That does not sound easy because a ttl comment is dorment until read or compacted. On Tuesday, June 11, 2013, Gareth Collins gareth.o.coll...@gmail.com

Re: Coprosessors/Triggers in C*

2013-06-11 Thread Gareth Collins
Hello Edward, I am curious - What about triggering on a TTL timeout delete (something I am most interested in doing - perhaps it doesn't make sense?)? Would you say that is something the user should implement themselves? Would you see intravert being able to do something with this at some later

Re: Hector vs Astyanax dependency issue

2013-05-26 Thread Gareth Collins
Hi Renato, Are you sure that you don't have two copies of guava in your classpath? I don't have this problem (I was using both Hector and Astyanax for a while - now transitioned completely to Astyanax). Probably the most problematic part of using the datastax or astyanax clients is that they

Re: CQL3 And ReversedTypes Question

2013-04-15 Thread Gareth Collins
dateof of type timeuuid Is there something I am missing here or should I open a new ticket? Yes please. Cheers - Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 13/04/2013, at 4:40 PM, Gareth Collins gareth.o.coll

Anyway To Query Just The Partition Key?

2013-04-13 Thread Gareth Collins
Hello, If I have a cql3 table like this (I don't have a table with this data - this is just for example): create table ( surname text, city text, country text, event_id timeuuid, data text, PRIMARY KEY ((surname, city, country),event_id)); there is no way of (easily)

Re: Anyway To Query Just The Partition Key?

2013-04-13 Thread Gareth Collins
* from yourtable where surname=blah and city=blah blah and country in (country1, country2) Hope that helps Jabbar Azam On 13 Apr 2013 07:06, Gareth Collins gareth.o.coll...@gmail.com wrote: Hello, If I have a cql3 table like this (I don't have a table with this data - this is just

Re: Anyway To Query Just The Partition Key?

2013-04-13 Thread Gareth Collins
it implies you might want a specific range which is something this schema can not do. On Sat, Apr 13, 2013 at 2:05 AM, Gareth Collins gareth.o.coll...@gmail.com wrote: Hello, If I have a cql3 table like this (I don't have a table with this data - this is just for example): create table

CQL3 And Map Literals

2013-03-28 Thread Gareth Collins
Hello, I have been playing with map literals in CQL3 queries. I see that single-quotes work: {'foo':'bar'} but double-quotes do not: {foo:bar} I am curious. Was there a specific reason why it was decided to use single-quotes? I ask because double-quotes would make this valid json. thanks in

Re: CQL3 And ReversedTypes Question

2013-03-26 Thread Gareth Collins
://issues.apache.org/jira/browse/CASSANDRA? -- Sylvain On Tue, Mar 26, 2013 at 2:48 AM, Gareth Collins gareth.o.coll...@gmail.com wrote: Hi, I created a table with the following structure in cqlsh (Cassandra 1.2.3 - cql 3): CREATE TABLE mytable ( column1 text, column2 text

Returning A Generated Id From An Insert

2013-03-26 Thread Gareth Collins
Hi, I have a question on if I could do something in Cassandra similar to what I can do in SQL. In SQL (e.g. SQL Server), if I have a generated primary key, I can get the generated primary key back as a result for the insert statement. Is it possible to do something similar with CQL (e.g. could

CQL3 And ReversedTypes Question

2013-03-25 Thread Gareth Collins
Hi, I created a table with the following structure in cqlsh (Cassandra 1.2.3 - cql 3): CREATE TABLE mytable ( column1 text, column2 text, messageId timeuuid, message blob, PRIMARY KEY ((column1, column2), messageId)); I can quite happily add values to this table. e.g: