Re: Local quorum reads

2011-11-18 Thread Anthony Ikeda
No it's not just the cli tool, our app has the same issue coming back with read issues. Sent from my iPhone On 18/11/2011, at 15:04, Peter Schuller wrote: >> Keyspace: NetworkTopologyStrategy, 1DC, RF=2 >> >> 1 node goes down and we cannot read from the ring. >> >> My expectation is that LO

Local quorum reads

2011-11-18 Thread Anthony Ikeda
This is the setup: Cassandra 0.8.6 3 nodes Keyspace: NetworkTopologyStrategy, 1DC, RF=2 1 node goes down and we cannot read from the ring. My expectation is that LOCAL_QUORUM dictates that it will return a record once a majority (N/2 +1) of replicas reports back. 2/2 + 1 = 2 I originally thoug

Re: Will writes with < ALL consistency eventually propagate?

2011-11-07 Thread Anthony Ikeda
Riyad, I'm also just getting to know the different settings and values myself :) I believe, and it also depends on your config, CL.ONE Should ignore the loss of a node if your RF is 5, once you increase the CL then if you lose a node the CL is not met and you will get exceptions returned. Sent

Re: Will writes with < ALL consistency eventually propagate?

2011-11-06 Thread Anthony Ikeda
It's your replication factor that determines how many nodes contain the data. So you would set the replication factor to 5 to ensure all nodes contain the data. Your consistency level is all based on when should the server return to the client after writing. When one node has written the data

Re: Programmatically allow only one out of two types of rows in a CF to enter the CACHE

2011-10-29 Thread Anthony Ikeda
By higher level data I meant the common data. For example we plan on creating an index using Solr for search but as its lucene based you can store the common data as part of a Document. It won't be indexed but is still accessible as the document will share the same "id" as the row key. Sent f

Re: Using elasticsearch on cassandra nodes

2011-10-18 Thread Anthony Ikeda
ticipate all the columns > ahead of time). > > What are you using as your bridge between Cassandra and ES? Are you > developing a Cassandra river? > > -brian > > > > > On Mon, Oct 17, 2011 at 5:29 PM, Anthony Ikeda < > anthony.ikeda@gmail.com> wrote: > >

Using elasticsearch on cassandra nodes

2011-10-17 Thread Anthony Ikeda
I've already posted to the elasticsearch groups and thought it prudent to also ask here. We are looking at using elastic search to index our data that we currently store to Cassandra. I was wondering if there are any concerns running elastic search on the same nodes that we use for Cassandra? We h

Re: How can I check what the consistency level is?

2011-09-29 Thread Anthony Ikeda
Well I did a local test by debugging our code and the policy is set to LOCAL_QUORUM. Is there something else I'm missing? More info that would help? Or should I direct this to the hector-users group? Anthony On Thu, Sep 29, 2011 at 5:13 PM, Anthony Ikeda wrote: > RF=3 > > 2 DC&#x

Re: How can I check what the consistency level is?

2011-09-29 Thread Anthony Ikeda
RF=3 2 DC's 3 nodes each On Thu, Sep 29, 2011 at 5:08 PM, Paul Loy wrote: > What is your replication factor? > > > On Thu, Sep 29, 2011 at 5:02 PM, Anthony Ikeda < > anthony.ikeda@gmail.com> wrote: > >> We seem to be having issues with out Consistency

How can I check what the consistency level is?

2011-09-29 Thread Anthony Ikeda
We seem to be having issues with out Consistency policies. We have it configured in Spring using the following: However, in our distributed testing, bringing down a single node will cause the 'May not be enough replicas present to

Best indexing solution for Cassandra

2011-09-28 Thread Anthony Ikeda
Well, we go live with our project very soon and we are now looking into what we will be doing for the next phase. One of the enhancements we would like to consider is an indexing platform to start building searches into our application. Right now we are just using column families to index the info

Using different versions of Cassandra in production

2011-09-21 Thread Anthony Ikeda
Okay, this is leaning more towards getting Brisk into our environment and making sure we can get it all working. We plan on deploying to production Cassandra 0.8.5/6, however, Brisk only works on 0.8.1 (in the 0.8.x release) Can we have a Brisk node operating as part of the ring to still do our d

Re: [RELEASE] Apache Cassandra 0.8.6 released

2011-09-20 Thread Anthony Ikeda
One question. I was told that Brisk was going to made compatible with this version of Cassandra, will we see a new Brisk release this week as well? Anthony On Tue, Sep 20, 2011 at 3:12 AM, Sylvain Lebresne wrote: > The Cassandra team is pleased to announce the release of Apache Cassandra > vers

Re: Configuring the keyspace correctly - NTS

2011-09-14 Thread Anthony Ikeda
l DC, see the > cassandra-topology.properties file. > > Cheers > > - > Aaron Morton > Freelance Cassandra Developer > @aaronmorton > http://www.thelastpickle.com > > On 15/09/2011, at 9:43 AM, Anthony Ikeda wrote: > > Okay, in a previous post

Re: Configuring the keyspace correctly - NTS

2011-09-14 Thread Anthony Ikeda
using the RackInferringSnitch, if you > want to use human names use either the SimpleSnitch or the > PropertyFileSnitch. Property File Snitch has a default catch all DC, see the > cassandra-topology.properties file. > > Cheers > > - > Aaron Morton > Freelance Cassa

Configuring the keyspace correctly - NTS

2011-09-14 Thread Anthony Ikeda
Okay, in a previous post, it was stated that I could use a NetworkTopologyStrategy in a singel data centre by setting up my keyspace with: create keyspace KeyspaceDEV with placement_strategy = 'org.apache.cassandra.locator.NetworkTopologyStrategy' and strategy_options=[{datacenter1:3}];

Re: Is sstable2json broken in 0.8.4+?

2011-09-09 Thread Anthony Ikeda
n-UTF8 data in it. > > On Fri, Sep 9, 2011 at 2:06 PM, Anthony Ikeda > wrote: > > I can't seem to export an sstable. The parameter flags don't work either > > (using -k and -f). > > > > sstable2json > > > /Users/X/Database/cassandra_files/data

Is sstable2json broken in 0.8.4+?

2011-09-09 Thread Anthony Ikeda
I can't seem to export an sstable. The parameter flags don't work either (using -k and -f). sstable2json /Users/X/Database/cassandra_files/data/RegistryFoundation/ServerIdentityProfiles-g-3-Data.db WARN 12:01:55,721 Invalid file '.DS_Store' in data directory /Users/X/Database/cassandra_fi

Using Brisk with the latest Cassandra Build (0.8.5)

2011-09-09 Thread Anthony Ikeda
I just wanted to confirm that we will be able to install Brisk with 0.8.5 cassandra as I am aware of some significant fixes and enhancements to the latest build of Cassandra. Anthony

Re: Anybody out there using 0.8 in production

2011-09-08 Thread Anthony Ikeda
We plan to and have been using it in Dev and QA. There are some bugs that have been fixed that we are looking forward to in 0.8.5 and probably that would be the better build for production (there is a quorum bug that we will need). Otherwise no other 0.8 issues that we are aware of. We did go thro

Re: [RELEASE] Apache Cassandra 0.8.5 released

2011-09-08 Thread Anthony Ikeda
Cool, all those fixes will be going into our prod env! Congrats! Anthony On Thu, Sep 8, 2011 at 7:51 AM, Stephen Connolly < stephen.alan.conno...@gmail.com> wrote: > can take up to 12 hours for the sync to central > > - Stephen > > --- > Sent from my Android phone, so random spelling mistakes, r

Re: UnavailableException while storing with EACH_QUORUM and RF=3

2011-09-06 Thread Anthony Ikeda
at 5:41 PM, Anthony Ikeda > wrote: > > Do you have a link to the downloadable? > > Anthony > > > > On Tue, Sep 6, 2011 at 3:38 PM, Anthony Ikeda < > anthony.ikeda@gmail.com> > > wrote: > >> > >> Thanks Jonathan, I'll consult

Re: UnavailableException while storing with EACH_QUORUM and RF=3

2011-09-06 Thread Anthony Ikeda
Do you have a link to the downloadable? Anthony On Tue, Sep 6, 2011 at 3:38 PM, Anthony Ikeda wrote: > Thanks Jonathan, I'll consult with the team. > > Anthony > > > On Tue, Sep 6, 2011 at 3:34 PM, Jonathan Ellis wrote: > >> 0.8.5 is being voted on now on the

Re: UnavailableException while storing with EACH_QUORUM and RF=3

2011-09-06 Thread Anthony Ikeda
Thanks Jonathan, I'll consult with the team. Anthony On Tue, Sep 6, 2011 at 3:34 PM, Jonathan Ellis wrote: > 0.8.5 is being voted on now on the dev list. I'd encourage you to test it. > > I do not recommend running trunk. > > On Tue, Sep 6, 2011 at 5:32 P

Re: UnavailableException while storing with EACH_QUORUM and RF=3

2011-09-06 Thread Anthony Ikeda
Jonathan, do you know when 0.8.5 will be released? We are looking at a production deployment soon and this fix is something that we would need. Alternatively, what is the stability of the trunk for a production deployment. Anthony On Mon, Sep 5, 2011 at 3:35 PM, Evgeniy Ryabitskiy < evgeniy.ryab

Re: Limiting ColumnSlice range in second composite value

2011-09-02 Thread Anthony Ikeda
Okay, I reversed the composite and seem to have come up with a solution. Although the rows are sorted by the status, the statuses are sorted temporally which helps. I tell you this type of modeling really breaks the rules :) Anthony On Fri, Sep 2, 2011 at 3:54 PM, Anthony Ikeda wrote: > T

Re: Limiting ColumnSlice range in second composite value

2011-09-02 Thread Anthony Ikeda
se startComp = new Composite(timeUUID, "INACTIVE"); endComp = new Composite(timeUUID, ""INACTIVE_"); query.setRange(startComp, endComp, false, 10); Thing is I'm getting back all columns regardless of what I set for the second half of the composite. Is what I'm t

Re: Trying to understand QUORUM and Strategies

2011-09-02 Thread Anthony Ikeda
Okay, great I just wanted to confirm that LOCAL_QUORUM will not work with SimpleStrategy. There was somewhat of a debate amongst my devs that said it should work. Anthon On Fri, Sep 2, 2011 at 9:55 AM, Evgeniy Ryabitskiy < evgeniy.ryabits...@wikimart.ru> wrote: > So. > You have created keyspace

Limiting ColumnSlice range in second composite value

2011-09-01 Thread Anthony Ikeda
My Column name is of Composite(TimeUUIDType, UTF8Type) and I can query across the TimeUUIDs correctly, but now I want to also range across the UTF8 component. Is this possible? UUID start = uuidForDate(new Date(1979, 1, 1)); UUID end = uuidForDate(new Date(Long.MAX_VALUE)); String startState = "

Re: Trying to understand QUORUM and Strategies

2011-09-01 Thread Anthony Ikeda
Thanks Evneniy, We encountered this exception with the following settings: Caused by: InvalidRequestException(why:consistency level LOCAL_QUORUM not compatible with replication strategy (org.apache.cassandra.locator .SimpleStrategy)) at org.apache.cassandra.t

Re: hw requirements

2011-08-31 Thread Anthony Ikeda
Sorry to fork this topic, but in "composite indexes" do you mean as strings or as "Composite()". I only ask cause we have started using the Composite as rowkeys and column names to replace the use of concatenated strings mainly for lookup purposes. Anthony On Wed, Aug 31, 2011 at 10:27 AM, Maxim

Trying to understand QUORUM and Strategies

2011-08-31 Thread Anthony Ikeda
Okay, we are looking at setting up a production environment which means getting our quorum settings and strategies correct. However, we need to really understand the approach taken to get this right. So far we have been working with co-located nodes and our prod environment is going to be distribut

Re: Querying a composite key with cassandra-cli

2011-08-30 Thread Anthony Ikeda
No problems. Anthony On Tue, Aug 30, 2011 at 9:31 AM, Jonathan Ellis wrote: > Sounds like a bug. Can you create a ticket on > https://issues.apache.org/jira/browse/CASSANDRA ? > > On Tue, Aug 30, 2011 at 11:28 AM, Anthony Ikeda > wrote: > > One thing I have noticed is th

Re: Querying a composite key with cassandra-cli

2011-08-30 Thread Anthony Ikeda
29, 2011 at 2:35 PM, Anthony Ikeda wrote: > Yeah I figured out what happened. I inadvertently set the keys to utf8 on > the column family: > > assume ColumnFamily keys as utf8; > > which broke whichever default mechanism was in place to perform the colon > separated value

Re: Querying a composite key with cassandra-cli

2011-08-29 Thread Anthony Ikeda
always > ascii.) > > On Mon, Aug 29, 2011 at 4:02 PM, Anthony Ikeda > wrote: > > Is there currently a way to query a composite key in cassandra-cli? > > I was sure I used to be able to call: > > get ColumnFamily['comp1:comp2'] > > But this has recently st

Querying a composite key with cassandra-cli

2011-08-29 Thread Anthony Ikeda
Is there currently a way to query a composite key in cassandra-cli? I was sure I used to be able to call: get ColumnFamily['comp1:comp2'] But this has recently stopped working. Anthony

Re: Trying to find the problem with a broken pipe

2011-08-08 Thread Anthony Ikeda
Tim do you know if this is the actual reason that is causing the broken pipe? I'm having a hard time convincing my team that modifying this value will fix the issue. Jonathan, do you know if there is a valid explanation on why Tim no longer has the problem based on this change? Anthony

Re: Trying to find the problem with a broken pipe

2011-08-02 Thread Anthony Ikeda
al events (e.g. node > > restarts, network issues...)? > > Not that I'm aware, unless there are firewall timeouts between the > > application and the node servers. Let me find out. The cassandra log > files > > have no errors reported. > > What versions of Hec

Re: Trying to find the problem with a broken pipe

2011-08-02 Thread Anthony Ikeda
ction configuration that we are using currently in Spring 3.0: On Tue, Aug 2, 2011 at 11:13 AM, Anthony Ikeda wrote: > The link (which I may be misreading) is > http://groups.google.com/group/hector-users/browse_thread/thread/8d700

Re: Trying to find the problem with a broken pipe

2011-08-02 Thread Anthony Ikeda
ou running?* Cassandra 0.8.1, Hector 0.8.0-1 On Tue, Aug 2, 2011 at 10:37 AM, Jim Ancona wrote: > On Tue, Aug 2, 2011 at 4:36 PM, Anthony Ikeda > wrote: > > I'm not sure if this is a problem with Hector or with Cassandra. > > We seem to be seeing broken pipe issues with our con

Trying to find the problem with a broken pipe

2011-08-02 Thread Anthony Ikeda
I'm not sure if this is a problem with Hector or with Cassandra. We seem to be seeing broken pipe issues with our connections on the client side (Exception below). A bit of googling finds possibly a problem with the amount of data we are trying to store, although I'm certain our datasets are not a

Questions over the use of CQL

2011-07-27 Thread Anthony Ikeda
For our current project we have decided to use Hector as the client API, however, with the introduction of CQL I need to understand a few things. Firstly, CQL use SQL like constructs. Column names seem to be limited to the same constraints of SQL (restricted use of delimiters) and yet the strength

Re: Creating comparator of (Dynamic)CompositeType with cassandra-cli

2011-07-18 Thread Anthony Ikeda
QueryResult> queryResults = transQuery.execute(); } But I'm finding I'm just getting 0 results even if I use the values of beginning of time ("----") and end of time ("ffff-ffff---") I want to slice onl

Creating comparator of (Dynamic)CompositeType with cassandra-cli

2011-07-18 Thread Anthony Ikeda
Is this possible? I'm trying to create a Column Family with a CompositeType comparator, but I keep getting an error: create column family Transactions with comparator = CompositeType(UTF8Type, UUIDType) and keys_cached=1 and rows_cached=1000; Syntax error at position 84: missing EOF at '(' Sa

Re: Node setup - recommended hardware

2011-05-04 Thread Anthony Ikeda
re metal. The node with the issue will be taken out of > service, the issue resolved and put back into a pool of spares. > > > On May 4, 2011, at 9:52 AM, Anthony Ikeda wrote: > > I wouldn't be concerned more about the performance with this configuration > I'm lookin

Re: Node setup - recommended hardware

2011-05-04 Thread Anthony Ikeda
for daily? monthly? annually? Basically how do you up-skill a technical infrastructure team to be able to maintain a Cassandra node ring? Anthony On Wed, May 4, 2011 at 9:39 AM, Eric tamme wrote: > On Wed, May 4, 2011 at 12:25 PM, Anthony Ikeda > wrote: > > I just want to ask, wh

Node setup - recommended hardware

2011-05-04 Thread Anthony Ikeda
I just want to ask, when setting up nodes in a Node ring is it worthwhile using a 2 partition setup? i.e. Cassandra on the Primary, data directories etc on the second partition or does it really not make a difference? Anthony

Upgrading 0.6.2 -> 0.6.3

2010-06-29 Thread Anthony Ikeda
o use org.apache.cassandra.dht.OrderPreservingPartitioner already. Any reason it has to find a "saved" partitioner? Anthony Ikeda Java Analyst/Programmer Cardlink Services Limited Level 4, 3 Rider Boulevard Rhodes NSW 2138 Web: www.cardlink.com.au | Tel: + 61 2 9646 9221 | F

RE: Understanding SuperColumns

2010-06-28 Thread Anthony Ikeda
org Subject: Re: Understanding SuperColumns On Sun, Jun 27, 2010 at 7:36 PM, Anthony Ikeda wrote: Say my query is: Get all Work addresses in New York and the address owner. Steps to get the data would be: If this is the query you want to run, then you probably just want to put t

RE: Understanding SuperColumns

2010-06-28 Thread Anthony Ikeda
So no one is able to help? From: Anthony Ikeda [mailto:anthony.ik...@cardlink.com.au] Sent: Monday, 28 June 2010 12:36 PM To: user@cassandra.apache.org Subject: Understanding SuperColumns I seem to be scratching my head about how to model Super Columns properly and how they relate to a 1

Understanding SuperColumns

2010-06-27 Thread Anthony Ikeda
ot; and get the primary key of the super column (returns [AddressByType][work][address2] and [AddressByType][work] [address3]) 2. Then get all the addresses located in "New York" (returns [AddressByCity][New York][address2]) 3. Then get "owner" field from my records returned in St

Reconfiguring nodes - getting bootstrap error

2010-06-22 Thread Anthony Ikeda
at org.apache.cassandra.thrift.CassandraDaemon.setup(CassandraDaemon.java:9 9) at org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java:17 7) Anthony Ikeda Java Analyst/Programmer Cardlink Services Limited Level 4, 3 Rider Boulevard Rhodes NSW 2138 Web: www.cardlink.com.au

Roadmap of Cassandra

2010-06-20 Thread Anthony Ikeda
Is there such a thing? Where might I be able to see what is planned for Cassandra. Anthony Ikeda Java Analyst/Programmer Cardlink Services Limited Level 4, 3 Rider Boulevard Rhodes NSW 2138 Web: www.cardlink.com.au | Tel: + 61 2 9646 9221 | Fax: + 61 2 9646 9283

RE: Get all rows back from a ColumnFamily

2010-06-17 Thread Anthony Ikeda
M, Anthony Ikeda < anthony.ik...@cardlink.com.au> wrote: Is there any way at all (In Java) to get all the data from a ColumnFamily? I've inserted data into Cassandra and I don't seem to have a way to browse what's in there. Anthony Ikeda Java Analyst/Programmer Cardli

RE: Best documentation for Java and Cassandra?

2010-06-17 Thread Anthony Ikeda
a_ instead of trying to model your _queries_. You _must_ use the tools as intended to achieve good results. b On Thu, Jun 17, 2010 at 4:12 PM, Anthony Ikeda wrote: > Okay, so that is where frameworks such as Lucene come into play. > > > > Right now we have set up Cassandra and a

Get all rows back from a ColumnFamily

2010-06-17 Thread Anthony Ikeda
Is there any way at all (In Java) to get all the data from a ColumnFamily? I've inserted data into Cassandra and I don't seem to have a way to browse what's in there. Anthony Ikeda Java Analyst/Programmer Cardlink Services Limited Level 4, 3 Rider Boulevard Rhodes N

RE: Best documentation for Java and Cassandra?

2010-06-17 Thread Anthony Ikeda
;d want a "color" ColumnFamily where the keys are the color values and the values are whatever you choose - propably keys to other ColumnFamilies that hold the relevant record data. HTH, Ezra On Jun 17, 2010, at 12:04 AM, "Anthony Ikeda" wrote: I’m wondering

RE: Some questions about using Cassandra

2010-06-17 Thread Anthony Ikeda
, Jun 17, 2010 at 1:20 AM, Anthony Ikeda wrote: > Thanks Gary, I'm looking at that plug-in feature at the moment but there > seems to be very little documentation on how to use it. There is no documentation whatsoever. This is just a feature proposition right now (it's not included

Best documentation for Java and Cassandra?

2010-06-17 Thread Anthony Ikeda
quot;color" equal to "red"). Any suggestions? Anthony Ikeda Java Analyst/Programmer Cardlink Services Limited Level 4, 3 Rider Boulevard Rhodes NSW 2138 Web: www.cardlink.com.au | Tel: + 61

RE: Some questions about using Cassandra

2010-06-16 Thread Anthony Ikeda
g, cloud, etc). Anthony From: Gary Dusbabek [mailto:gdusba...@gmail.com] Sent: Thursday, 17 June 2010 2:20 AM To: user@cassandra.apache.org Subject: Re: Some questions about using Cassandra On Tue, Jun 15, 2010 at 19:49, Anthony Ikeda wrote: Is there any concept of Listeners s

RE: Some questions about using Cassandra

2010-06-15 Thread Anthony Ikeda
Thanks Benjamin. Looking at the 'plugins' now :) -Original Message- From: Benjamin Black [mailto:b...@b3k.us] Sent: Wednesday, 16 June 2010 11:35 AM To: user@cassandra.apache.org Subject: Re: Some questions about using Cassandra On Tue, Jun 15, 2010 at 6:07 PM, Anthony Ik

RE: Some questions about using Cassandra

2010-06-15 Thread Anthony Ikeda
ckpoint, necessarily, but some cyclic rework may occur. If your storage layout includes temporal names, it should be straightforward. The details how exactly how would depend on your storage layout, but it is not unusual as far as requirements go. On Tue, Jun 15, 2010 at 7:49

Some questions about using Cassandra

2010-06-15 Thread Anthony Ikeda
actly relevant. Is there any concept of Listeners such that when data is added to Cassandra we can fire off another process to do something with that data? E.g. create a copy in a secondary database for Business Intelligence reports? Send the data to an LDAP server? Anthony Ikeda Java An