Re: sstable2json and resurrected rows

Did you hit the bug here? https://issues.apache.org/jira/browse/CASSANDRA-4054 best regards, 坚果云 , 最简捷易用的云存储 无限空间, 文件同步, 备份和分享! 2012/3/30 Jonas Borgström > Let me rephrase my question: > > Is it true that deleted rows will still be present in the sstable after a > m

Re: Pushing through major compaction

If you are experiencing OOM related to compaction try the following: * if you have wide rows reduce the in_memory_compaction_limit_in_mb yaml setting. * uncomment concurrent_compactors so that a single compaction run at a time Hope that helps. - Aaron Morton Freelance Develo

Re: nodetool ring runs very slow

You node is under significant memory pressure. Look into: * reducing caches * reducing the JVM heap to 8GB Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/03/2012, at 6:03 AM, Feng Qu wrote: > Hi Jonathan, similar problem happens again

Re: create column family

I think the confusion here is that cassandra-cli and cqlsh have different syntaxes. On Fri, Mar 30, 2012 at 4:37 PM, aaron morton wrote: > Background: > http://www.datastax.com/docs/1.0/references/cql/CREATE_COLUMNFAMILY > > What error are you getting ? This works for me. > > cqlsh> use dev; > c

Re: create column family

Background: http://www.datastax.com/docs/1.0/references/cql/CREATE_COLUMNFAMILY What error are you getting ? This works for me. cqlsh> use dev; cqlsh:dev> create COLUMNFAMILY users ... (KEY uuid PRIMARY KEY, ... firstname text, ... lastname text, ... email text,

Re: problem in create column family

This works… create column family student with comparator = 'AsciiType' and column_metadata = [{ column_name : name, validation_class : 'AsciiType' }]; * use compatator instead of coluimn_type. * closing ' missing Cheers - Aaron Morton Freelance Developer @aaronmor

Re: Error in FAQ?

Thanks Ben. A - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 27/03/2012, at 3:08 PM, Ben McCann wrote: > I updated the FAQ to the best of my ability: > http://wiki.apache.org/cassandra/FAQ#modify_cf_config > > > On Mon, Mar 26, 2012 at 12:25

Re: Internal error processing get_slice (NullPointerException)

Fixed in 1.0.9 / 1.1 https://issues.apache.org/jira/browse/CASSANDRA-4095 Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 27/03/2012, at 12:56 PM, John Laban wrote: > Has anyone seen this particular NPE before from Cassandra? > > This is

Re: cassandra gui

If you want a REST interface and a GUI then Virgil may be interesting. I just came across it and haven't tried it myself yet. http://brianoneill.blogspot.com/2011/10/virgil-gui-and-rest-layer-for-cassandra.html On Fri, Mar 30, 2012 at 2:15 PM, John Liberty wrote: > I made some updates to a ca

Re: cassandra gui

I made some updates to a cassandra-gui project I found, which seemed to be stuck at version 0.7, and posted to github: https://github.com/libjack/cassandra-gui Besides updating to work with version 1.0+, main improvements I added were to obey validation types, including column metadata, when displ

AW: cassandra gui

Inside the webapp (f.g. webapps/apollo/WEB-INF/classes) you can find apollo.properties with the property max.number.row.keys and the default 100. Please try to change this to a higher integer. But as far as I can see it is not used for the columns … Von: Markus Wiesenbacher | Codefreun.de [m

Re: cassandra gui

Let me check that Von meinem iPhone gesendet Am 30.03.2012 um 21:46 schrieb Mohit Anchlia : > > > On Fri, Mar 30, 2012 at 8:05 AM, Markus Wiesenbacher | Codefreun.de > wrote: > If you do search without a key I just read the first 100 row-keys and return > them. I am using Thrift at the

Re: cassandra gui

On Fri, Mar 30, 2012 at 8:05 AM, Markus Wiesenbacher | Codefreun.de < m...@codefreun.de> wrote: > If you do search without a key I just read the first 100 row-keys and > return them. I am using Thrift at the moment to select the keys (subject to > change) and I haven´t found a way to do paging wi

Re: another DataStax OpsCenter question

Unfortunately at the moment OpsCenter only really supports having one instance per cluster. It may be possible to set up an instance in each datacenter, however it has not been tested and each opscenter instance would lose some functionality. On Fri, Mar 30, 2012 at 3:13 AM, Alexandru Sicoe wrote

Re: a question on cassandra data file size

Hi Ed, the "comp actions" stand for compaction or compression? Also, the size we obtained from the supercolumn schema was also taken many days after the data ingest, so it had to be after compact as well, no? In neither case we issued any nodetool compact commands. you are right that we probabl

AW: cassandra gui

If you do search without a key I just read the first 100 row-keys and return them. I am using Thrift at the moment to select the keys (subject to change) and I haven´t found a way to do paging with this API. I think, searching for a specific key is the most efficient way to get to your data, instea

Re: cassandra gui

On Thu, Mar 29, 2012 at 10:08 PM, Markus Wiesenbacher | Codefreun.de < m...@codefreun.de> wrote: > Hi, > > yes you can insert data into cassandra with apollo, just try the demo > center: http://www.codefreun.de/apolloUI/ > > You can login by just press the login-button (autologin) and play around

Re: a question on cassandra data file size

Standard columns save size over super columns. Not 50% but depending on the size of the data (3 byte values) the overhead could be significant. I have noticed that post sstable rebuild, 1.0 kicked off some comp actions behind the scenes shrinking some files significantly. On Fri, Mar 30, 2012 at 9

a question on cassandra data file size

Hi, I have a question on the size of cassandra data files. After we upgraded from cassandra 0.8 to 1.0, and changed our schema to use regular columns instead of supercolumns, the aggregated size of cassandra data files reduced by more than half. The source data set is the same, and we didn't set

Re: composite query performance depends on component ordering

When you do a query, there's a lot of comparison happening between what's queries and the column names. But the composite comparator is lazy in that when it compares two names, if the first component are not equal, it doesn't have to compare the second one. So What's likely happening is that in the

composite query performance depends on component ordering

Sender: adsi...@gmail.com Subject: composite query performance depends on component ordering Message-Id: Recipient: adam.nicho...@hl.co.uk __ This email has been scanned by the Symantec Email Security.cloud service. For more inf

Re: sstable2json and resurrected rows

Let me rephrase my question: Is it true that deleted rows will still be present in the sstable after a major compaction with 1.0.8 (not just tombstones)? Or did I mess up my test below? / Jonas On 2012-03-28 10:23 , Jonas Borgström wrote: Hi all, I've noticed a change in behavior between

composite query performance depends on component ordering

Hi guys, I am consistently seeing a 20% improvement in query retrieval times if I use the composite comparator "Timestamp:ID" instead of "ID:Timestamp" where Timestamp=Long and ID=~100 character strings. I am retrieving all columns (~1 million) from a single row. Why is this happening? Cheers, Al

Re: another DataStax OpsCenter question

Hi Nick, I forgot to say I was using 1.2.3 which I think uses different ports. So I will upgrade to 1.4.1 and open those ports across the firewall although that's kind of a pain. I already have about 320 config lines for the Cassandra cluster itself. So, just to make things clear, is it mandatory

Compression on secondary indexes

Greetings, how may I set the compression algorithm on secondary indexes? I saw that from Cassandra 1.1.0 it will be inherited from the CF, but in the previous releases I must set it explicity; I just don't know how to do that. Paolo -- @bernarpa http://paolobernardi.wordpress.com