What Happened To Alternate Storage And Rocksandra?

2021-03-12 Thread Gareth Collins
ses Cassandra)...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
ot-to-batch/ > > 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
perhaps reduce the parallelizing 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
t; 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 > wrote: >> >> Hello, >> >> When querying large w

Performance Of IN Queries On Wide Rows

2018-02-20 Thread Gareth Collins
entry? Or 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 the

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 wrote: > On Thu, Aug 1, 2013 at 12:49 PM, Gareth Collins > wrote: >> >> Would this be correct? Just making sure I understand how to best use >> secondary indexes in Cassandra with ti

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 te

Re: Coprosessors/Triggers in C*

2013-06-13 Thread Gareth Collins
stone, but I don't think it's the use case you're looking > for. > > M. > > > I do not understand what feature you suggesting. Columns can already have >> a >> ttl. Are you speaking of a ttl column that could delete something beside >> itself. >> >

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 po

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 bot

Re: CQL3 And ReversedTypes Question

2013-04-15 Thread Gareth Collins
f 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 > > O

Re: Anyway To Query Just The Partition Key?

2013-04-13 Thread Gareth Collins
say subset 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

Re: Anyway To Query Just The Partition Key?

2013-04-13 Thread Gareth Collins
gt; Eg. Select * 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" wrote: > >> Hello, >&g

Anyway To Query Just The Partition Key?

2013-04-12 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) gett

Re: CQL3 And ReversedTypes Question

2013-04-12 Thread Gareth Collins
8 cannot be passed as argument 0 of function dateof of type timeuuid Is there something I am missing here or should I open a new ticket? thanks in advance, Gareth On Tue, Mar 26, 2013 at 3:30 PM, Gareth Collins wrote: > Added: > > https://issues.apache.org/jira/browse/CASSANDRA-538

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

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 I

Re: CQL3 And ReversedTypes Question

2013-03-26 Thread Gareth Collins
ticket on https://issues.apache.org/jira/browse/CASSANDRA? > > -- > Sylvain > > > On Tue, Mar 26, 2013 at 2:48 AM, Gareth Collins > wrote: >> >> Hi, >> >> I created a table with the following structure in cqlsh (Cassandra >> 1.2.3 - cql 3): >> >>

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: in