Hello Mathew
Since Cassandra 2.0.6 it is possible to query over composites:
https://issues.apache.org/jira/browse/CASSANDRA-4851
For your example:
select * from skill_count where skill='Complaints' and
(interval_id,skill_level) >= (140235930,5) and interval_id <
140235990;
On Mon, Jul
Hello all
We are happy to announce the release of Achilles 3.0.4. Among the biggest
changes:
- support for static columns: http://goo.gl/o7D5yo
- dynamic statements logging & tracing at runtime: http://goo.gl/w4jlqZ
- SchemaBuilder, the mirror of QueryBuilder for creating schema
programmatica
Tommaso, looking at your description of the architecture the idea came up.
You can perform sharding on cassandra client and write to different
cassandra clusters to keep the number of column families reasonable.
With best regards,
Ilya
On Thu, Jul 3, 2014 at 10:55 PM, tommaso barbugli
wrote:
Sorry, I've just checked, the correct query should be:
select * from skill_count where skill='Complaints' and
(interval_id,skill_level) >= (140235930,5) and
(interval_id,skill_level) < (140235990,11)
On Mon, Jul 14, 2014 at 9:45 AM, DuyHai Doan wrote:
> Hello Mathew
>
> Since Cassandr
or :
select * from skill_count where skill='Complaints'
and (interval_id,skill_level) >= (140235930,5)
and (interval_id) < (140235990)
Strange enough, when starting using tuple notation you'll need to stick to
it even if there is only one element in the tuple
On Mon, Jul 14, 2014 at 1:4
I don't think your query is doing what he wants. Your query will correctly
set the starting point, but will also return larger interval_id's but with
lower skill_levels:
cqlsh:test> select * from skill_count where skill='Complaints' and
(interval_id, skill_level) >= (140235930, 5);
skill
Exact Ken, I get bitten again by the semantics of composite tuples.
This kind of query won't be possible until something like wide row end
slice predicate is available (
https://issues.apache.org/jira/browse/CASSANDRA-6167), if it will one day
On Mon, Jul 14, 2014 at 5:02 PM, Ken Hancock
wro
Hello All,
I'm trying to upgrade from a 3 node 1.1.9 cluster to a 6 node 1.2.18 cluster on
ubuntu. Can sstableloader be used to stream from the existing cluster to the
new cluster? If so, what that the suggested method? I keep getting the
following when trying this:
partitioner org.apache.cass
Mark,
Here you go:
*NodeTool status:*
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Tokens Owns Host ID
Rack
UN 10.10.20.15 1.62 TB256 8.1%
01a01f07-4df2-4c87-98e9-8dd38b3e4aee rack1
UN 10.10.20.19 1.66 TB256 8.3%
30ddf003-4d59-4a
We've struggled getting consistent write latency & linear write
scalability with a pretty heavy insert load (1000's of records/second),
and our records are about 1k-2k of data (mix of integer/string columns
and a blob). Wondering if you have any rough numbers for your "small to
medium write si
On Mon, Jul 14, 2014 at 9:54 AM, Denning, Michael <
michael.denn...@kavokerrgroup.com> wrote:
> I'm trying to upgrade from a 3 node 1.1.9 cluster to a 6 node 1.2.18
> cluster on ubuntu. Can sstableloader be used to stream from the existing
> cluster to the new cluster? If so, what that the sugges
3 node cluster is in production. It’d difficult for me to get sign off on the
change control to upgrade it. The 6 node cluster is already stood up (in
aws). In an ideal scenario I’d just be able to bring the data over to the new
cluster.
From: Robert Coli [mailto:rc...@eventbrite.com]
Sent
On Mon, Jul 14, 2014 at 11:12 AM, Denning, Michael <
michael.denn...@kavokerrgroup.com> wrote:
> 3 node cluster is in production. It’d difficult for me to get sign off
> on the change control to upgrade it. The 6 node cluster is already stood
> up (in aws). In an ideal scenario I’d just be ab
Is there a line when doing nodetool info/status like:
Datacenter: datacenter1
=
You need to make sure the Datacenter name matches the name specified in your
replication factor
Chris
On Jul 14, 2014, at 12:04 PM, Ruchir Jha wrote:
> Mark,
>
> Here you go:
>
> NodeTool s
If you list all 12 nodes in seeds list, you can try using
NodeDiscoveryType.NONE instead of RING_DESCRIBE.
Its been recommended that way by some anyway so if you add nodes to cluster
your app wont start using it until all bootstrapping and everythings settled
down.
Chris
On Jul 14, 2014, at
Yes the line is : Datacenter: datacenter1 which matches with my create
keyspace command. As for the NodeDiscoveryType, we will follow it but I
don't believe it to be the root of my issue here because the nodes start up
atleast 6 hours before the UnavailableException and as far as adding nodes
is co
Thanks for both your help, greatly appreciated.
We'll proceed down the path of putting the filtering into the application
logic for the time being.
Matt.
On Tue, Jul 15, 2014 at 1:20 AM, DuyHai Doan wrote:
> Exact Ken, I get bitten again by the semantics of composite tuples.
>
> This kind of
I'm looking into creation of monitoring thresholds for cassandra to report
on its health. Does it make sense to set an alert threshold on compaction
stats? If so, would setting it to a value equal to or greater than
concurrent compactions make sense?
Thanks,
Greg
On Mon, Jun 9, 2014 at 2:14 PM
Hi everyone,
I have some code that I've been fiddling with today that uses the
DataStax Java driver to create a table and then create a secondary
index on a column in that table. I've testing this code fairly
thoroughly on a single-node Cassandra instance on my laptop and in
unit test (using the
BTW I have seen this using versions 2.0.1 and 2.0.3 of the java driver
on a three-node cluster with DSE 4.5.
On Mon, Jul 14, 2014 at 5:51 PM, Clint Kelly wrote:
> Hi everyone,
>
> I have some code that I've been fiddling with today that uses the
> DataStax Java driver to create a table and then c
20 matches
Mail list logo
