Re: CREATE COLUMNFAMILY

you do something like change a variable length integer to a fixed length one. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/11/2012, at 8:06 AM, Kevin Burton wrote: > Thank you this helps with my understanding. > > So the

Re: Strange delay in query

t know the names of the columns). Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/11/2012, at 10:51 PM, André Cruz wrote: > On Nov 11, 2012, at 12:01 AM, Binh Nguyen wrote: > >> FYI: Repair does not remove tombstones. To

Re: HugeTLB (Hugepage) Support on a Cassandra Cluster

Past discussion here http://www.mail-archive.com/user@cassandra.apache.org/msg08786.html Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/11/2012, at 4:51 PM, Jason Wee wrote: > option -XX:+UseLargePages ? > > > On Sat,

Re: CF metadata syntax for an array

This may help http://www.datastax.com/dev/blog/cql3_collections > I have gotten as far as feeling a need to understand a ‘super-column’ You can happily ignore them. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/11/2012, at 8:35

Re: Questions around the heap

is relative to the workload. Try to find things that cause a lot of columns to be read from disk. I've found the following JVM tweeks sometimes helpful: MAX_HEAP_SIZE="4G" HEAP_NEWSIZE="1200M" SurvivorRatio=4 MaxTenuringThreshold=4 Hope that helps. - Aaron

Re: Strange delay in query

> I don't think that statement is accurate. Which part ? Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/11/2012, at 6:31 AM, Binh Nguyen wrote: > I don't think that statement is accurate. The minor compaction is still

Re: removing SSTABLEs

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/11/2012, at 7:46 AM, B. Todd Burruss wrote: > thx, i was pretty sure it would be ok (from a cassandra point of view) > to remove it, but needed to check. > > voted up. i like having tools, but i

Re: CF metadata syntax for an array

oughly the same CREATE TABLE List ( list_name text, sort_key bigint, object_property_1 text, object_property_2 text, PRIMARY_KEY (list_name, sort_key) ); Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.

Re: Memory Manager

Have you tried using the defaults in cassandra-env.sh ? Your setting are very different. https://github.com/apache/cassandra/blob/cassandra-1.1/conf/cassandra-env.sh Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/11/2012, at 11:35

Re: Strange delay in query

. Assuming your data roughly follows a generational model, where newer data is written to often and older data is mostly read from. This can mean garbage hanging around in the big old file and *potentially* slowing things down. Cheers - Aaron Morton Freelance Developer @aaronmorton

Re: CF metadata syntax for an array

. > Does the array have to be a KEY? Sorry I don't understand this question. > Finally, what would be the syntax for inserting data into the CF? Depends on what you want to do. Docs are a good starting point http://www.datastax.com/docs/1.1/references/cql/index Cheers ---

Re: read request distribution

ter data stored on that node for the named KS or all keyspaces. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 14/11/2012, at 9:43 AM, Wei Zhu wrote: > I am new to Cassandra, and 1.1.6 is the only version I have tested. Not sure >

Re: Multiple Services

Not sure I understand your question. Do you have an existing schema you want some help with ? Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 14/11/2012, at 12:39 PM, jer...@simpleartmarketing.com wrote: > I h

Re: CF metadata syntax for an array

> In both cases the array is the PRIMARY_KEY. I'm not sure what you mean by the "array" The vector_name and list_name columns are used as "variable names" to identify a particular vector or list. They are the storage engine "row key". Cheers

Re: Enable compression Cassandra 1.1.2

May be https://issues.apache.org/jira/browse/CASSANDRA-4561 Can you upgrade to 1.1.6 ? Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 14/11/2012, at 11:39 PM, Alain RODRIGUEZ wrote: > Hi, I am running C* 1.

Re: describe columnfamilies?

4946 is marked as a dup of https://issues.apache.org/jira/browse/CASSANDRA-4913 Looks like it's fixed in the trunk now. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 15/11/2012, at 2:19 AM, Timmy Turner

Re: Memory Manager

S="$JVM_OPTS -XX:CMSInitiatingOccupancyFraction=75" JVM_OPTS="$JVM_OPTS -XX:+UseCMSInitiatingOccupancyOnly" Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 15/11/2012, at 2:56 AM, Everton Lima wrote: &

Re: SchemaDisagreementException

end doing that. If you are trying to do something more complicated you'll need to provide more information. Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 15/11/2012, at 3:13 AM, Everton Lima wrote: > Some

Re: Fixing / Rebuilding Secondary Index

Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 15/11/2012, at 8:50 AM, Eran Chinthaka Withana wrote: > Hi, > > I have a secondary index for a column family which is connected to a keyspace > that spa

Re: CF metadata syntax for an array

8 | this is another example 1 | 3 | 6 | this is the last example - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 15/11/2012, at 10:38 AM, Kevin Burton wrote: > An array would be a list of groups of items.

Re: CF metadata syntax for an array

value of item_id : "price" * value of item_id : "title" Hope that helps. - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 15/11/2012, at 11:35 AM, Peter Lin wrote: > it means the column family uses c

Re: CF metadata syntax for an array

ers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 15/11/2012, at 4:18 PM, Kevin Burton wrote: > In the below example I am thinking that id is the order id. Would there be > considerable duplication if there are oth

Re: unable to read saved rowcache from disk

For a row cache of 1,650,000: 16 byte token 300 byte row key ? and row data ? multiply by a java fudge factor or 5 or 10. Trying delete the saved cache and restarting. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http

Re: Upgrade 1.1.2 -> 1.1.6

Can you provide an example of the increase ? Can you provide the log from startup ? Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 16/11/2012, at 3:21 AM, Alain RODRIGUEZ wrote: > We had an issue with count

Re: unable to read saved rowcache from disk

300B. > Did I miss something? Did that take into account the token, the row key, and the row payload, and the java memory overhead ? Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 16/11/2012, at 9:35 AM, Wei Zhu

Re: Datatype Conversion in CQL-Client?

> Does the official/built-in Cassandra CQL client (in 1.2) What language ? Check the Java http://code.google.com/a/apache-extras.org/p/cassandra-jdbc/ and python http://code.google.com/a/apache-extras.org/p/cassandra-dbapi2/ drivers. Cheers ----- Aaron Morton Freelance Cassan

Re: Offsets and Range Queries

slice that starts in the middle of a row of 10 million columns just by using a start column. Having a slice operation that is constrained in size improves the overall throughout of the server and reduces the (jvm) GC churn in the server. Cheers ----- Aaron Morton Freelance Cassan

Re: huge commitlog

mn family (around 10M in data_file_directories) Can you describe how you created the 700 CF's ? > and how can we reduce the size of commitlog? As a work around nodetool flush should checkpoint the log. Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand

Re: unable to read saved rowcache from disk

> . But what is the upper bound? And rules of thumb? If you are using the off heap cache the upper bound is memory. If you are using the on head it's the JVM heap. Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.co

Re: Cassandra nodes failing with OOM

event those? As above. As a work around sometimes drastically slowing down compaction can help. For LDB try reducing in_memory_compaction_limit_in_mb and compaction_throughput_mb_per_sec Hope that helps. - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http

Re: Query regarding SSTable timestamps and counts

compaction issues you are having ? Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 18/11/2012, at 1:18 AM, Ananth Gundabattula wrote: > > We have a cluster running cassandra 1.1.4. On this cluster, > >

Re: Upgrade 1.1.2 -> 1.1.6

rations ? (I saw some dropped messages in the S1 log). S1 shows a lot of Commit Log replay going on. Reading your timeline below this sounds like the auto restart catching you out. Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelas

Re: row cache re-fill very slow

tarting > with a cold row cache ) row_cache_keys_to_save in yaml may help you find a happy half way point. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 20/11/2012, at 3:17 AM, Andras Szerdahelyi wrote: > Hey list, &g

Re: Invalid argument

Are you running a 32 bit JVM ? What is the full JVM version ? As a work around you can try disabling memory mapped access set disk_access_mode to standard. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 20/11

Re: Query regarding SSTable timestamps and counts

ta files and > removed all the data files with the old timestamps. upgradetables re-writes every sstable to have the same contents in the newest format. Cheers --------- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 19/11/2

Re: row cache re-fill very slow

-Filter.db) component. Also the SSTables are opened in parallel. Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 20/11/2012, at 10:39 AM, Andras Szerdahelyi wrote: > Aaron, > >> What version are you on ?

Re: Invalid argument

> Thanks for the work around, setting disk_access_mode: standard worked. hmmm, it's only a work around. If you can reproduce the fault could you report it on https://issues.apache.org/jira/browse/CASSANDRA Cheers ----- Aaron Morton Freelance Cassandra Developer New

Re: Query regarding SSTable timestamps and counts

>> upgradetables re-writes every sstable to have the same contents in the >> newest format. Agree. In the world of compaction, and excluding upgrades, have older sstables is expected. Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaro

Re: Concurrency and secondary indexes

ommand line are built at the same time. Rebuilding any one index requires reading all the rows in the CF. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 23/11/2012, at 8:20 AM, Simon Guindon wrote: > We are impor

Re: Freeing up disk space on Cassandra 1.1.5 with Size-Tiered compaction.

en look at LDB http://www.datastax.com/dev/blog/when-to-use-leveled-compaction Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 23/11/2012, at 9:18 AM, Alain RODRIGUEZ wrote: > Hi Alexandru, > > "We ar

Re: Concurrency and secondary indexes

> Nodetool reports: 1.1.6-dse-p1 If you are using DSE the best place to get help is the support forums http://www.datastax.com/support-forums/ Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 24/11/2012, at 6:34

Re: huge commitlog

> I checked the log, and found some ERROR about network problems, > and some ERROR about "Keys must not be empty". Do you have the full error stack ? Cheers --------- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 25/

Re: Generic questions over Cassandra 1.1/1.2

however altering the schema is easier. And in 1.2 will support concurrent schema modifications. Thrift API is still schema less. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 26/11/2012, at 12:21 AM, cbert...@liber

Re: Generic questions over Cassandra 1.1/1.2

#x27;s within 5% (maybe 10%) under stress tests. See Eric's talk at the Cassandra SF conference for the exact numbers. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 26/11/2012, at 11:58 AM, cbert...@l

Re: huge commitlog

Can you please create a ticket for this on https://issues.apache.org/jira/browse/CASSANDRA Thanks - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 26/11/2012, at 1:58 PM, Chuan-Heng Hsiao wrote: > Hi Aaron, > >

Re: Changing compression_parameters of exsisting CF

> is it expectable behaviour? or it's bug? It exhibits bug like qualities. Can you create a ticket on https://issues.apache.org/jira/browse/CASSANDRA ? Thanks ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 27/11/

Re: InvalidRequestException(why:Not enough bytes to read value of component 0)

It looks like the client is not sending the correct bytes. Are you using Hector or Astyanax? It kind of looks like you are using raw thrift, using a pre-written client is much easier. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http

Re: Upgrade

Do you have the error stack ? Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 28/11/2012, at 12:28 AM, Everton Lima wrote: > Hello people. > I was using cassandra 1.1.6 and use the Object CassandraServe

Re: How to determine compaction bottlenecks

I would also check the logs for GC issues. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 28/11/2012, at 4:23 AM, Derek Bromenshenkel wrote: > Setup: C* 1.1.6, 6 node (Linux, 64GB RAM, 16 Core CPU, 2x512 SSD)

Re: Cassandra 1.1.5 - SerializingCacheProvider - possible memory leak?

esult of the configuration and the work load. Look for very big rows, very long lived rows with a lot of deletes, or very big select / get calls. Hope that helps. Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 4/12/2012

Re: Data not replicating to all datacenters

ads from another ? Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 4/12/2012, at 6:45 AM, Шамим wrote: > Yes, it's should be. dc1:3 means u have 3 copy of every piece of row, with > local quorum you alwa

Re: Row caching + Wide row column family == almost crashed?

you were using the ConcurrentLinkedHashCacheProvider that would explain the increase in GC activity. Try the SerializingCacheProvider , it will take the row cache off the JVM heap. And as Ed says, it's not always a great idea for wide rows. Cheers ----- Aaron Morton Freelance Cassandr

Re: Hadoop Integration: Limiting scan to a range of keys

is local to the node. It's not really possible to select individual rows by token. If you had a secondary index on the row you could use the setInputRange overload that takes an index expression. Or it may be easier to use hive. Hope that helps. - Aaron Morton Free

Re: Data not replicating to all datacenters

for both reads and writes. Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 4/12/2012, at 9:33

Re: strange row cache behavior

esting with a lower number of hot rows, and/or a bigger row cache. But to be honest, with rows in the 10's of MB you will probably only get good cache performance with a small set of hot rows. Hope that helps. ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaron

Re: Row caching + Wide row column family == almost crashed?

I responded on your other thread. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 4/12/2012, at 5:31 PM, Yiming Sun wrote: > I ran into a different problem with Row cache recently, sent a message to the >

Re: Having issues with node token collisions when starting up Cassandra nodes in a cluster on VMWare.

other nodes, which then gossiped it around, or by this one. When a node automatically selects a token at bootstrap it logs a message such as "New token will be {} to assume load from {}" do you see that ? If not the token has been read from the system KS. Hope that helps ---

Re: Help on MMap of SSTables

mmapping will map the entire file, but pages of data are read into memory on demand and purged when space is needed. Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 4/12/2012, at 11:59 PM, Ravikumar Govindarajan wrot

Re: Nodes not synced

ownership here. Check the schema has the RF you think it does. You can also run nodetool repair to make sure the data is fully distributed. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 5/12/2012, at 2:26 AM, Adeel

Re: strange row cache behavior

The key cache and os disk cache will help. If you find latency is an issue then start poking around. Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 5/12/2012, at 4:23 AM, Yiming Sun wrote: > Hi Aaron, >

Re: Data backup and restore

I wrote a script to sym link the snapshots together the other day https://github.com/amorton/cass_snapshot_link I've not really used it in anger yet. That is to say I wrote it for fun and it worked on my mac book. If you use it let me know if it works. Cheers A - Aaron M

Re: Diagnosing memory issues

you can turn them up. Hope that helps. A ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 5/12/2012, at 7:04 AM, Mike wrote: > Hello, > > Our Cassandra cluster has, relatively recently, started experiencing memo

Re: Loading SSTables failing via Cassandra SSTableLoader on mulit-node cluster.

Have you checked the yaml configuration for the sstableloader ? Background configuration section here http://www.datastax.com/dev/blog/bulk-loading Hope that helps. - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 5/12

Re: Help on MMap of SSTables

osix_fadvise if you want to look it up. Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 5/12/2012, at 11:04 PM, Ravikumar Govindarajan wrote: > Thanks Aaron, > > I am not quite clear on how MMap loads SS

Re: entire range of node out of sync -- out of the blue

t; - how do i clean up my stables ( grew from 6k to 20k since this started, > while i shut writes off completely ) Sounds like repair is streaming a lot of differences. If you have the space I would give Levelled compaction time to take care of it. Hope that helps. - Aaron

Re: Freeing up disk space on Cassandra 1.1.5 with Size-Tiered compaction.

ke for cassandra to stream all the data over ? (Or to rsync the data over.) How long does it take to run nodetool repair on the node ? With RF 3, if you lose a node you have lost your redundancy. It's important to have a plan about how to get it back and how long it may take. Hope that help

Re: [BETA RELEASE] Apache Cassandra 1.2.0-beta3 released

There are two thrift calls, batch_mutate and atomic_batch_mutate . Check with your favourite thrift client to see how it handles it. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 6/12/2012, at 7:31 AM, Andrey

Re: how to take consistant snapshot?

M for reads you *may* be ok (cannot work it out quickly.). If you use CL ALL for reads you will be ok. Or you can use nodetool repair to ensure the data is consistent. I doubt that even using repair would give you a provable guarantee though. Anyone ? Cheers - Aaron Morton Free

Re: Help on MMap of SSTables

> So for memory mapped files, compaction can do a madvise SEQUENTIAL instead of > current DONTNEED flag after detecting appropriate OS versions. Will this help? AFAIK Compaction does use memory mapped file access. Cheers - Aaron Morton Freelance Cassandra Developer New Z

Re: entire range of node out of sync -- out of the blue

The log message matches what I would expect to see for nodetool -pr Not using pr means repair all the ranges the node is a replica for. If you have RF == number of nodes, then it will repair all the data. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand

Re: Freeing up disk space on Cassandra 1.1.5 with Size-Tiered compaction.

> Meaning terabyte size databases. > Lots of people have TB sized systems. Just add more nodes. 300 to 400 Gb is just a rough guideline. The bigger picture is considering how routine and non routine maintenance tasks are going to be carried out. Cheers - Aaron

Re: JDBC, Pools and clusters ?

not appear to be in the (current) 1.1.2 branch. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 10/12/2012, at 3:23 AM, Andy Cobley wrote: > I'm starting to move to JBC for Cassandra (away from Hecto

Re: Batch mutation streaming

Hope that helps. ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 9/12/2012, at 7:18 AM, Ben Hood <0x6e6...@gmail.com> wrote: > Thanks for the clarification Andrey. If that is the case, I had better ensure > that I

Re: Multiple Data Center shows very uneven load

that helps. - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 11/12/2012, at 4:29 PM, Keith Wright wrote: > Hello, > > I have base Cassandra 1.1.7 installed in two data centers with 3 nodes each > using a Proper

Re: Multiple Data Center shows very uneven load

Hi Sergey, I think you have forgotten to include some information in your email. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 12/12/2012, at 3:00 AM, Sergey Olefir wrote: > Keith Wright wrote >> I

Re: multiget_slice SlicePredicate

hewed through. This this is more of an issue with smaller clusters. As Dean says, the client request is performed in parallel on multiple machines. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 12/12/2012, at 3:

Re: Virtual Nodes, lots of physical nodes and potentially increasing outage count?

ord :) ) Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 12/12/2012, at 6:42 AM, Eric Parusel wrote: > Ok, thanks Richard. That's good to hear. > > However, I still contend that as node count increases to

Re: Selecting rows efficiently from a Cassandra CF containing time series data

n over the dirty partitions CF to read all rows, and then reading the dirty partition for the user. You would want to look at a low GC Grace and LDB for the dirty partitions CF. Hope that helps. ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronm

Re: Slow Reads in Cassandra with Hadoop

%29 Hope that helps. - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 7/12/2012, at 4:29 AM, Ralph Romanos wrote: > Hello Cassandra users, > > I am trying to read and process data in Cassandra using Hadoop. I ha

Re: Consistency QUORUM does not work anymore (hector:Could not fullfill request on this host)

ers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 11/12/2012, at 10:13 PM, dong.yajun wrote: > hi list, > I am using Cassandra with 3 data centers, each DC has more than 10 nodes. > > the schema for a keyspace: >

Re: Cassandra on EC2 - describe_ring() is giving private IPs

the nodes. Trying setting the rpc_address to the public IP. Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 11/12/2012, at 11:32 PM, santi kumar wrote: > We have a 4 node cluster in us-east region in two different A

Re: bug with cqlsh for foreign charater

Can you please put together a test case using CQL 3 to write and read the data and create a ticket at https://issues.apache.org/jira/browse/CASSANDRA ? Thanks Aaron - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 12/12

Re: Multiple Data Center shows very uneven load

ata). Glancing at the logs it could be Hints or commit log replaying. Use nodetool cfstats to see which CF's are on the node and what their size is. If this is still a test the easiest thing to do is nuke it and start again. Cheers - Aaron Morton Freelance Cassandra Deve

Re: Consistency QUORUM does not work anymore (hector:Could not fullfill request on this host)

> sliceRangeQuery.setRange(Character.Min_Value, Character.Max_Value, false, > Integer.Max_Value); Try selecting a smaller number of rows. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com - Aaron

Re: Null Error Running pig_cassandra

Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 13/12/2012, at 6:04 AM, James Schappet wrote: > When trying to run the example-script.pig, I get the following error, null > error. > > > > > tsunami:pig scha

Re: upgrade from 0.8.5 to 1.1.6, now it cannot find schema

> in-vm cassandra Embedded ? The location of the SSTables has changed in 1.1, they are know in /var/lib/cassandra/data/KS_NAME/CF_NAME/SSTable.data Is the data in the right place ? Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton h

Re: Multiple Data Center shows very uneven load

try nodetool drain. It will flush everything to disk and the commit log will be truncated. HH can be ignored. If you really want them gone they can be purged using the JMX interface, or you can stop the node and delete the sstables. Cheers - Aaron Morton Freelance Cassandra

Re: Why Secondary indexes is so slowly by my test?

The IndexClause for the get_indexed_slices takes a start key. You can page the results from your secondary index query by making multiple calls with a sane count and including a start key. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http

Re: Multiple Data Center shows very uneven load

d starting again will get you moving forwards again. Cheers ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 14/12/2012, at 12:50 AM, Sergey Olefir wrote: > I'll try nodetool drain, thanks. > > But more genera

Re: Does a scrub remove deleted/expired columns?

that helps. ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 14/12/2012, at 3:01 AM, Mike Smith wrote: > I'm using 1.0.12 and I find that large sstables tend to get compacted > infrequently. I've got data that gets deleted o

Re: BulkOutputFormat error - org.apache.thrift.transport.TTransportException

Looks like it cannot connect to the server >conf.set("cassandra.output.thrift.address", "localhost"); Is this the same address as the rpc_address in the cassandra config ? Cheers ----- Aaron Morton Freelance Cassandra Developer New Zea

Re: Does a scrub remove deleted/expired columns?

. Hope that helps. ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 14/12/2012, at 4:45 PM, Mike Smith wrote: > Thanks for the great explanation. > > I'd just like some clarification on the last point. Is it the case that if I >

Re: Read operations resulting in a write?

more the min compaction sstables. > 3) Is this desired behavior? Is there something else I should be looking at > that could be causing this behavior? Yes. https://issues.apache.org/jira/browse/CASSANDRA-2503 Cheers - Aaron Morton Freelance Cassandra D

Re: Adding New Node to an Existing Cluster

helps. Aaron - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 17/12/2012, at 11:53 PM, Adeel Akbar wrote: > Dear Tomas, > > I didn't use token values in configuration. A new node automatically picked a > token

Re: Read operations resulting in a write?

t. I assume it means cases where minor compaction cannot keep up. E.g. it has been throttled down, or a concurrent repair / upgradesstables is slowing things. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 18/12/201

Re: Read operations resulting in a write?

AFAIK there is no way to disable hoisting. Feel free to let your jira fingers do the talking. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 18/12/2012, at 6:10 PM, Edward Capriolo wrote: > Is there a way

Re: Data Model Review

at helps. ----- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 18/12/2012, at 4:35 AM, Adam Venturella wrote: > My use case is capturing some information about Instagram photos from the > API. I have 2 use cases. One, I need to capture all of the

Re: TTL on SecondaryIndex Columns. A bug?

Thanks for the nice steps to reproduce. I ran this on my MBP using C* 1.1.7 and got the expected results, both get's returned a row. Were you running against a single node or a cluster ? If a cluster did you change the CL, cassandra-cli defaults to ONE. Cheers -

Re: Monitoring the number of client connections

AFAIK the count connections is not exposed. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 18/12/2012, at 10:37 PM, Tomas Nunez wrote: > Hi! > > I want to know how many client connections has each

Re: cassandra-cli + secured JMX = WARNING: Could not connect to the JMX

://issues.apache.org/jira/browse/CASSANDRA Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 19/12/2012, at 2:24 AM, Sergey Olefir wrote: > Hi, > > for a number of reasons (particularly to prevent accidental access), I

<    1   2   3   4   5   6   7   8   9   10   >