Re: CQL 3 and wide rows

Thank you Nate - now I understand it ! This is real improvement when compared to CLI :) Regards, Maciej On 20 May 2014, at 17:16, Nate McCall wrote: > Something like this might work: > > > cqlsh:my_keyspace> CREATE TABLE my_widerow ( > ... id text, > ...

Re: CQL 3 and wide rows

n compared to CLI/Hector. > Now days you can do pretty much everything you can in cli. Provide an example > and we may be able to help. > > Cheers > Aaron > > - > Aaron Morton > New Zealand > @aaronmorton > > Co-Founder & Principal Consultant

Re: CQL 3 and wide rows

> and we may be able to help. > > Cheers > Aaron > > ----- > Aaron Morton > New Zealand > @aaronmorton > > Co-Founder & Principal Consultant > Apache Cassandra Consulting > http://www.thelastpickle.com > > On 20/05/2014, at 8:18 a

Re: CQL 3 and wide rows

w_key text, > wide_row_column text, > data_column text, > PRIMARY KEY (row_key, wide_row_column)); > > Check out, for example, > http://www.datastax.com/dev/blog/schema-in-cassandra-1-1.​ > > James > From: Maciej Miklas > Sent: Monday, May 19, 2014 11:20 AM > To

Re: CQL 3 and wide rows

/dev/blog/does-cql-support-dynamic-columns-wide-rows > > -- Jack Krupansky > > From: Maciej Miklas > Sent: Monday, May 19, 2014 11:20 AM > To: user@cassandra.apache.org > Subject: CQL 3 and wide rows > > Hi *, > > I’ve checked DataStax driver code for CQL 3, a

CQL 3 and wide rows

missing something here? Regards, Maciej Miklas

Re: Cyclop - CQL web based editor has been released!

thanks - I've fixed it. Regards, Maciej On Mon, May 12, 2014 at 2:50 AM, graham sanderson wrote: > Looks cool - giving it a try now (note FYI when building, > TestDataConverter.java line 46 assumes a specific time zone) > > On May 11, 2014, at 12:41 AM, Maciej Miklas wrote:

subscription test - please ignore

Cyclop - CQL web based editor has been released!

Hi everybody, I am aware that this mailing list is meant for Cassandra users, but I’ve developed something that is strictly related to Cassandra, so I tough that it might be interesting for some of you. I’ve already sent one email several months ago, but since then a lot of things has changed!

Re: Cassandra 1.2 : OutOfMemoryError: unable to create new native thread

the cassandra-env.sh has option JVM_OPTS="$JVM_OPTS -Xss180k" it will give this error if you start cassandra with java 7. So increase the value, or remove option. Regards, Maciej On Mon, Dec 16, 2013 at 2:37 PM, srmore wrote: > What is your thread stack size (xss) ? try increasing that, that

Cyclop - CQL3 web based editor

Hi all, This is the Cassandra mailing list, but I've developed something that is strictly related to Cassandra, and some of you might find it useful, so I've decided to send email to this group. This is web based CQL3 editor. The idea is, to deploy it once and have simple and comfortable CQL3 int

Re: Cassandra 1.1.5 - SerializingCacheProvider - possible memory leak?

Size and Capacity are in bytes. The RAM is consumed right after Cassandra start (3GB heap) - the reason for this could be 400.000.000 rows on single node, serialized bloom filters take 1,2 GB HDD space. On Mon, Dec 3, 2012 at 10:14 AM, Maciej Miklas wrote: > Hi, > > I have following

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

I'am using Java + Tomcat + Spring + Hector on Lunux - I works as always just great. It is also not bad idea to mix databases - Cassandra is not always solution for every problem, Cassandra + Mongo could be ;) On Fri, Aug 17, 2012 at 7:54 PM, Aaron Turner wrote: > My stack: > > Java + JRuby + R

Re: Understanding UnavailableException

UnavailableException is bit tricky. It means, that not all replicas required by CL received update. Actually you do not know, whenever update was stored or not, and actually what went wrong. This is the case, why writing with CL.ALL might get problematic. It is enough, that only one replica is off

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

-- > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 16/08/2012, at 7:34 PM, Maciej Miklas wrote: > > Hi all, > > bloom filter for row keys is always in RAM. What about SSTable index, and > Metadata? > > Is it cached by Cassandra, or it relays on memory mapped files? > > > Thanks, > Maciej > > >

SSTable Index and Metadata - are they cached in RAM?

Hi all, bloom filter for row keys is always in RAM. What about SSTable index, and Metadata? Is it cached by Cassandra, or it relays on memory mapped files? Thanks, Maciej

Cassandra 1.0 - is disk seek required to access SSTable metadata

Hi all, older Cassandra versions had to read columns from each SSTable with positive bloom filter in order to find recent value. This was optimized with: Improve read performance in update-intensive workload Now each SSTable has metadata - SST

CQL 3.0 - UPDATE Statement - how it works?

CQL will have UPDATE future, I am trying to understand how this could work. Every write is an append to SSTable, UPDATE would need to change data, but only if it exists, and this is problematic, since we have distributed system. Is UPDATE special kind of insert, which changes given data only if i

Cassandra 1.1 - conflict resolution - any changes ?

Hi, I've seen this blog entry: http://www.datastax.com/dev/blog/schema-in-cassandra-1-1 and I am trying to understand, how could Cassandra support PRIMARY KEY. Cassandra has silent conflict resolution, where each insert overwrites next one, and there are only inserts and deletes - no updates. The

Re: Schema advice/help

rite > etc and is a lot messier. and you will prolly need to worry about the case > where you (transiently) have more than 10 'latest' items for a single > itemType. > > On 28/03/2012 09:49, Maciej Miklas wrote: > > yes - but anyway in your example you need "

Re: Schema advice/help

yes - but anyway in your example you need "key range quey" and that requires OOP, right? On Tue, Mar 27, 2012 at 5:13 PM, Guy Incognito wrote: > multiget does not require OPP. > > On 27/03/2012 09:51, Maciej Miklas wrote: > > multiget would require Order Preserving

Re: Schema advice/help

multiget would require Order Preserving Partitioner, and this can lead to unbalanced ring and hot spots. Maybe you can use secondary index on "itemtype" - is must have small cardinality: http://pkghosh.wordpress.com/2011/03/02/cassandra-secondary-index-patterns/ On Tue, Mar 27, 2012 at 10:10 AM

Re: Cassandra - crash with “free() invalid pointer”

n Thu, Mar 22, 2012 at 8:27 PM, Benoit Perroud wrote: > Sounds like a race condition in the off heap caching while calling > Unsafe.free(). > > Do you use cache ? What is your use case when you encounter this error > ? Are you able to reproduce it ? > > > 2012/3/22 Maciej

Re: Cassandra - crash with “free() invalid pointer”

ace condition in the off heap caching while calling >> Unsafe.free(). >> >> Do you use cache ? What is your use case when you encounter this error >> ? Are you able to reproduce it ? >> >> >> 2012/3/22 Maciej Miklas : >> > Hi *, >> > >> >

Cassandra - crash with “free() invalid pointer”

Hi *, My Cassandra installation runs on flowing system: - Linux with Kernel 2.6.32.22 - jna-3.3.0 - Java 1.7.0-b147 Sometimes we are getting following error: *** glibc detected *** /var/opt/java1.7/bin/java: free(): invalid pointer: 0x7f66088a6000 *** === Backtrace: = /

Cassandra as Database for Role Based Access Control System

Hi *, I would like to know your opinion about using Cassandra to implement a RBAC-like authentication & authorization model. We have simplified the central relationship of the general model ( http://en.wikipedia.org/wiki/Role-based_access_control) to: user ---n:m--- role ---n:m--- resource user(

Re: hector connection pool

Have you tried to change: me.prettyprint.cassandra.service.CassandraHostConfigurator#retryDownedHostsDelayInSeconds ? Hector will ping down hosts every xx seconds and recover connection. Regards, Maciej On Mon, Mar 5, 2012 at 8:13 PM, Daning Wang wrote: > I just got this error ": All host pool

Cassandra cache patterns with thiny and wide rows

I've asked this question already on stackoverflow but without answer - I wll try again: My use case expects heavy read load - there are two possible model design strategies: 1. Tiny rows with row cache: In this case row is small enough to fit into RAM and all columns are being cached.

Cassandra - row range and column slice

Hallo, assuming Ordered Partitioner I would like to have possibility to find records by row key range and columns by slice - for example: Give me all rows between 2001 and 2003 and all columns between A and C. For such data: { 2001: {A:"v1", Z:"v2"}, 2002: {R:"v2", Z:"v3"}, 2003: {C:"v4",

Re: Data Model Design for Login Servie

I will follow exactly this solution - thanks :) On Fri, Nov 18, 2011 at 9:53 PM, David Jeske wrote: > On Thu, Nov 17, 2011 at 1:08 PM, Maciej Miklas > wrote: > >> A) Skinny rows >> - row key contains login name - this is the main search criteria >> - login data is

Re: Data Model Design for Login Servie

: e72c504dc16c8fcd2fe8c74bb492affa alias1: alfred.tes...@xyz.de alias2: alf...@aad.de alias3: a...@dd.de } ...and you can use secondary indexes to query on anything. Maxim On 11/17/2011 4:08 PM, Maciej Miklas wrote: Hallo all, I need your help to design structure for simple

Data Model Design for Login Servie

Hallo all, I need your help to design structure for simple login service. It contains about 100.000.000 customers and each one can have about 10 different logins - this results 1.000.000.000 different logins. Each customer contains following data: - one to many login names as string, max 20 UTF-8

Re: Off-heap caching through ByteBuffer.allocateDirect when JNA not available ?

I would like to know it also - actually is should be similar, plus there are no dependencies to sun.misc packages. Regards, Maciej On Thu, Nov 10, 2011 at 1:46 PM, Benoit Perroud wrote: > Thanks for the answer. > I saw the move to sun.misc. > In what sense allocateDirect is broken ? > > Thanks,

Re: Cassandra 1.x and proper JNA setup

e. > > We're working on https://issues.apache.org/jira/browse/CASSANDRA-3143 > to make cache sizing easier. > > On Thu, Nov 3, 2011 at 3:16 AM, Maciej Miklas > wrote: > > According to source code, JNA is being used to call malloc and free. In > this > > case

Re: Cassandra 1.x and proper JNA setup

Wed, Nov 2, 2011 at 1:53 PM, Maciej Miklas wrote: > I've just found, that JNA will be not used from 1.1 release - > https://issues.apache.org/jira/browse/CASSANDRA-3271 > I would be also nice to know what was the reason for this decision. > > Regards, > Maciej > > >

Re: Cassandra 1.x and proper JNA setup

ns the property of the sender. You must not use, > disclose, distribute, copy, print or rely on this e-mail. If you have > received this message in error, please contact the sender immediately and > irrevocably delete this message and any copies.-Original Message- > From: Maciej Mikl

Cassandra 1.x and proper JNA setup

Hi all, is there any documentation about proper JNA configuration? I do not understand few things: 1) Does JNA use JVM heap settings? 2) Do I need to decrease max heap size while using JNA? 3) How do I limit RAM allocated by JNA? 4) Where can I see / monitor row cache size? 5) I've configure

Re: Row Cache Heap Requirements (Cassandra 1.0)

this is how I tested it: 1) load cache with 1.500.000 entries 2) execute fill gc 3) mesure heap size (using visual vm) 4) execute flush row cahce over cli 5) execute full gc 6) and again mesure hap usage The difference between 6) and 3) is the heap size used by cache On Fri, Oct 28, 2011 at 3:26

Row Cache Heap Requirements (Cassandra 1.0)

Hi all, I've tested row cache, and find out, that it requires large amount of Heap - I would like to verify this theory. This is my test key space: { TestCF: { row_key_1: { { clientKey: "MyTestCluientKey" }, { tokenSecret: "kd94hf93k423kf44" }, {

Re: Cassandra as session store under heavy load

durable_writes sounds great - thank you! I really do not need commit log here. Another question: it is possible to configure live time of Tombstones? Regards, Maciej

Re: Cassandra as session store under heavy load

- RF is 1. We have few KeySpaces, only this one is not replicated - this data is not that very important. In case of error customer will have to execute process again. But again, I would like to persist it. - Serializing data is not an option, because I would like to have possibility to access data

Cassandra as session store under heavy load

Hi *, I would like to use Cassandra to store session related informations. I do not have real HTTP session - it's different protocol, but the same concept. Memcached would be fine, but I would like to additionally persist data. Cassandra setup: - non replicated Key Space - single Column F