Re: How to create a TupleType/TupleValue in a UDF

2016-08-18 Thread Drew Kutcharian
/issues.apache.org/jira/browse/CASSANDRA-11033>, which is fixed in > 3.0.4 and 3.4. > > I'm not sure about the CodecNotFoundException, can you reproduce that one > reliably? > > On Thu, Aug 18, 2016 at 10:52 AM, Drew Kutcharian <mailto:d...@venarc.com>> wrote:

How to create a TupleType/TupleValue in a UDF

2016-08-18 Thread Drew Kutcharian
Hi All, I have a UDF/UDA that returns a map of date -> TupleValue. CREATE OR REPLACE FUNCTION min_max_by_timestamps_udf(state map>>, flake blob) RETURNS NULL ON NULL INPUT RETURNS map>> LANGUAGE java CREATE OR REPLACE AGGREGATE min_max_by_timestamps(blob) SFUNC min_max_by_timestamps_udf STYPE ma

Re: Cassandra Debian repos (Apache vs DataStax)

2016-05-17 Thread Drew Kutcharian
OK to make things even more confusing, the “Release” files in the Apache Repo say "Origin: Unofficial Cassandra Packages”!! i.e. http://dl.bintray.com/apache/cassandra/dists/35x/:Release > On May 17, 2016, at 12:11 PM, Drew Kutcharian wrote: > > BTW, the language on this page s

Re: Cassandra Debian repos (Apache vs DataStax)

2016-05-17 Thread Drew Kutcharian
BTW, the language on this page should probably change since it currently sounds like the official repo is the DataStax one and Apache is only an “alternative" http://wiki.apache.org/cassandra/DebianPackaging - Drew > On May 17, 2016, at 11:35 AM, Drew Kutcharian wrote: > &g

Re: Cassandra Debian repos (Apache vs DataStax)

2016-05-17 Thread Drew Kutcharian
Thanks Eric. > On May 17, 2016, at 7:50 AM, Eric Evans wrote: > > On Mon, May 16, 2016 at 5:19 PM, Drew Kutcharian wrote: >> >> What’s the difference between the two “Community” repositories Apache >> (http://www.apache.org/dist/cassandra/debian) and DataStax >

Cassandra Debian repos (Apache vs DataStax)

2016-05-16 Thread Drew Kutcharian
Hi, What’s the difference between the two “Community” repositories Apache (http://www.apache.org/dist/cassandra/debian) and DataStax (http://debian.datastax.com/community/)? If they are just mirrors, then it seems like the DataStax one is a bit behind (version 3.0.6 is available on Apache but

Cassandra 3.0.6 Release?

2016-05-09 Thread Drew Kutcharian
Hi, What’s the 3.0.6 release date? Seems like the code has been frozen for a few days now. I ask because I want to install Cassandra on Ubuntu 16.04 and CASSANDRA-10853 is blocking it. Best, Drew

Re: Data partitioning and composite partition key

2014-08-29 Thread Drew Kutcharian
of Cassandra is scalability and distributed > processing, right? > > -- Jack Krupansky > > From: Drew Kutcharian > Sent: Friday, August 29, 2014 7:31 PM > To: user@cassandra.apache.org > Subject: Re: Data partitioning and composite partition key > > Hi Jack, &

Re: Data partitioning and composite partition key

2014-08-29 Thread Drew Kutcharian
just opened this JIRA https://issues.apache.org/jira/browse/CASSANDRA-7850 - Drew On Aug 29, 2014, at 4:36 PM, Robert Coli wrote: > On Fri, Aug 29, 2014 at 3:48 PM, Drew Kutcharian wrote: > AFAIK, currently Cassandra partitions (thrift) rows using the row key, > basically uses

Re: Data partitioning and composite partition key

2014-08-29 Thread Drew Kutcharian
ug 29, 2014, at 3:58 PM, Jack Krupansky wrote: > With CQL3, you, the developer, get to decide whether to place a primary key > column in the partition key or as a clustering column. So, make sensorID the > partition key and datetime as a clustering column. > > -- Jack Krupansky &

Data partitioning and composite partition key

2014-08-29 Thread Drew Kutcharian
Hey Guys, AFAIK, currently Cassandra partitions (thrift) rows using the row key, basically uses the hash(row_key) to decide what node that row needs to be stored on. Now there are times when there is a need to shard a wide row, say storing events per sensor, so you’d have sensorId-datetime row

Re: Relation between Atomic Batches and Consistency Level

2014-03-18 Thread Drew Kutcharian
) > if 1 is not successful then the batch "fails" > - this is because it couldn't make it to the batchlog table for execution > > Hope this helps. I believe this is the best i can do for you at the moment. > > Thanks, > > Jonathan Lacefield >

Re: Relation between Atomic Batches and Consistency Level

2014-03-17 Thread Drew Kutcharian
hat helps. > > Thanks, > > Jonathan > > Jonathan Lacefield > Solutions Architect, DataStax > (404) 822 3487 > > > > > > > On Mon, Mar 17, 2014 at 1:38 PM, Drew Kutcharian wrote: > Hi Jonathan, > > I’m still a bit unclear on this. Say I ha

Re: Relation between Atomic Batches and Consistency Level

2014-03-17 Thread Drew Kutcharian
than Lacefield > Solutions Architect, DataStax > (404) 822 3487 > > > > > > > On Sat, Mar 15, 2014 at 12:23 PM, Drew Kutcharian wrote: > Hi Guys, > > How do Atomic Batches and Consistency Level relate to each other? More > specifically: > > -

Relation between Atomic Batches and Consistency Level

2014-03-15 Thread Drew Kutcharian
Hi Guys, How do Atomic Batches and Consistency Level relate to each other? More specifically: - Is consistency level set/applicable per statement in the batch or the batch as a whole? - Say if I write a Logged Batch at QUORUM and read it back at QUORUM, what can I expect at normal, single nod

Re: Consistency Level One Question

2014-02-21 Thread Drew Kutcharian
LOCAL_QUORUM (failing > >>> the whole update if that doesn’t work - stale data is OK if >1 node is > >>> down), and we read at LOCAL_QUORUM, but (because stale data is better > >>> than no data), we will fall back per read request to LOCAL_ONE if we &

Consistency Level One Question

2014-02-20 Thread Drew Kutcharian
Hi Guys, I wanted to get some clarification on what happens when you write and read at consistency level 1. Say I have a keyspace with replication factor of 3 and a table which will contain write-once/read-only wide rows. If I write at consistency level 1 and the write happens on node A and I r

Re: CQL3 Custom Functions

2014-02-12 Thread Drew Kutcharian
Lebresne wrote: > >> On Mon, Feb 10, 2014 at 7:16 PM, Drew Kutcharian wrote: >> Hey Guys, >> >> How can I define custom CQL3 functions (similar to dateOf, now, etc)? > > You can't, there is currently no way to define custom functions. > > -- > Sylvain

CQL3 Custom Functions

2014-02-10 Thread Drew Kutcharian
Hey Guys, How can I define custom CQL3 functions (similar to dateOf, now, etc)? Cheers, Drew

Re: Data modeling users table with CQL

2014-01-21 Thread Drew Kutcharian
You’re right. I didn’t catch that. No need to have email in the PRIMARY KEY. On Jan 21, 2014, at 5:11 PM, Jon Ribbens wrote: > On Tue, Jan 21, 2014 at 10:40:39AM -0800, Drew Kutcharian wrote: >> Thanks, I was actually thinking of doing that. Something along the lines >>

Re: Data modeling users table with CQL

2014-01-21 Thread Drew Kutcharian
is an additional implementation detail, and could be > external to Cassandra. But the approach you describe accurately describes > what I would do as a first pass, at least. > > -Tupshin > > On Jan 21, 2014 10:41 AM, "Drew Kutcharian" wrote: > Thanks, I was actu

Re: Data modeling users table with CQL

2014-01-21 Thread Drew Kutcharian
On Jan 21, 2014 9:17 AM, "Drew Kutcharian" wrote: > A shameful bump ;) > > > On Jan 20, 2014, at 2:14 PM, Drew Kutcharian wrote: > > > > Hey Guys, > > > > I’m new to CQL (but have been using C* for a while now). What would be the > > best way to model

Re: Data modeling users table with CQL

2014-01-21 Thread Drew Kutcharian
A shameful bump ;) > On Jan 20, 2014, at 2:14 PM, Drew Kutcharian wrote: > > Hey Guys, > > I’m new to CQL (but have been using C* for a while now). What would be the > best way to model a users table using CQL/Cassandra 2.0 Lightweight > Transactions where we would like

Re: one or more nodes were unavailable.

2014-01-20 Thread Drew Kutcharian
rd into it(via cqlsh). > > Wondering why it gives "No node available" > > Even though simple insert queries(without CAS) works! > > -Vivek > > > On Tue, Jan 21, 2014 at 11:33 AM, Drew Kutcharian wrote: > If you are trying this out on a single node, make

Re: one or more nodes were unavailable.

2014-01-20 Thread Drew Kutcharian
If you are trying this out on a single node, make sure you set the replication_factor of the keyspace to one. On Jan 20, 2014, at 7:41 PM, Vivek Mishra wrote: > Single node and default consistency. Running via cqsh > > > On Tue, Jan 21, 2014 at 1:47 AM, sankalp kohli wrote: > Also do you ha

Data modeling users table with CQL

2014-01-20 Thread Drew Kutcharian
Hey Guys, I’m new to CQL (but have been using C* for a while now). What would be the best way to model a users table using CQL/Cassandra 2.0 Lightweight Transactions where we would like to have: - A unique TimeUUID as the primary key of the user - A unique email address used for logging in In t

Re: Data Modeling: How to keep track of arbitrarily inserted column names?

2013-04-05 Thread Drew Kutcharian
t will be many > extra writes but that is ok. > > Other option is turn on row cache and try read before write. It is a good > case for row cache because it is a very small data set. > > On Thursday, April 4, 2013, Drew Kutcharian wrote: > > I don't really need

Re: Data Modeling: How to keep track of arbitrarily inserted column names?

2013-04-04 Thread Drew Kutcharian
have column X that was added between time y and time > z". Remember with few distinct column names that reverse index of column to > row is going to be a very big list. > > > On Thu, Apr 4, 2013 at 5:45 PM, Drew Kutcharian wrote: > Hi Edward, > > I anticipate that the column

Re: Data Modeling: How to keep track of arbitrarily inserted column names?

2013-04-04 Thread Drew Kutcharian
pty > byte array (new byte[0]{}) as the start and finish you get back all the > columns. From there you can return only the columns to the user in a format > that you like. > > > On Thu, Apr 4, 2013 at 2:18 PM, Drew Kutcharian wrote: > Hey Guys, > > I'm worki

Data Modeling: How to keep track of arbitrarily inserted column names?

2013-04-04 Thread Drew Kutcharian
Hey Guys, I'm working on a project and one of the requirements is to have a schema free CF where end users can insert arbitrary key/value pairs per row. What would be the best way to know what are all the "keys" that were inserted (preferably w/o any locking). For example, Row1 => key1 -> XXX,

Re: Any plans for read-before-write update operations in CQL3?

2013-04-03 Thread Drew Kutcharian
Sometimes you can write the plus one into a new column and then apply the > changes in the reading client thread. > > Cheers > > - > Aaron Morton > Freelance Cassandra Consultant > New Zealand > > @aaronmorton > http://www.thelastpickle.com >

Any plans for read-before-write update operations in CQL3?

2013-04-03 Thread Drew Kutcharian
Hi Guys, Are there any short/long term plans to support UPDATE operations that require read-before-write, such as increment on a numeric non-counter column? i.e. UPDATE CF SET NON_COUNTER_NUMERIC_COLUMN = NON_COUNTER_NUMERIC_COLUMN + 1; UPDATE CF SET STRING_COLUMN = STRING_COLUMN + "postfix";

Re: Cassandra Compression and Wide Rows

2013-03-19 Thread Drew Kutcharian
gt; compression would be much of a workaround because again, that's more about > how compression is working than how Cassandra use it. > > At the end of the day, I really think the best choice is to try it and decide > for yourself if it does more good than harm or the converse.

Re: Cassandra Compression and Wide Rows

2013-03-18 Thread Drew Kutcharian
ompression was not > effective. > > On Mon, Mar 18, 2013 at 9:08 PM, Drew Kutcharian wrote: > That's what I originally thought but the OOYALA presentation from C*2012 got > me confused. Do you guys know what's going on here? > > The video: > http://www.youtub

Re: Cassandra Compression and Wide Rows

2013-03-18 Thread Drew Kutcharian
3, Sylvain Lebresne wrote: > > The way compression is implemented, it is oblivious to the CF being > > wide-row or narrow-row. There is nothing intrinsically less efficient in > > the compression for wide-rows. > > -- > > Sylvain > > > > On Fri, Mar 15, 2013

Cassandra Compression and Wide Rows

2013-03-15 Thread Drew Kutcharian
Hey Guys, I remember reading somewhere that C* compression is not very effective when most of the CFs are in wide-row format and some folks turn the compression off and use disk level compression as a workaround. Considering that wide rows with composites are "first class citizens" in CQL3, is

Re: Cassandra instead of memcached

2013-03-06 Thread Drew Kutcharian
nd OR SSD disks. > > We do not use c* as an "in-memory store". However for many of our datasets we > do not have a separate caching tier. In those cases cassandra is both our > "database" and our "in-memory store" if you want to use those terms :) >

Re: Cassandra instead of memcached

2013-03-06 Thread Drew Kutcharian
Aaron Morton > Freelance Cassandra Developer > New Zealand > > @aaronmorton > http://www.thelastpickle.com > > On 5/03/2013, at 9:51 AM, Drew Kutcharian wrote: > >> Thanks Ben, that article was actually the reason I started thinking about >> removing memcached. &

Re: Cassandra instead of memcached

2013-03-05 Thread Drew Kutcharian
012/07/benchmarking-high-performance-io-with.html > > Netflix used Cassandra with SSDs and were able to drop their memcache layer. > Mind you they were not using it purely as an in memory KV store. > > Ben > Instaclustr | www.instaclustr.com | @instaclustr > > > > On 05/

Cassandra instead of memcached

2013-03-04 Thread Drew Kutcharian
Hi Guys, I'm thinking about using Cassandra as an in-memory key/value store instead of memcached for a new project (just to get rid of a dependency if possible). I was thinking about setting the replication factor to 1, enabling off-heap row-cache and setting gc_grace_period to zero for the CF

Re: Cassandra Geospatial Search

2013-02-15 Thread Drew Kutcharian
Hey Dean, do you guys have any thoughts on how to implement it yet? On Feb 15, 2013, at 6:18 AM, "Hiller, Dean" wrote: > Yes, this is in PlayOrm's roadmap as well but not there yet. > > Dean > > On 2/13/13 6:42 PM, "Drew Kutcharian" wrote: > &g

Re: multiget_slice using CQL3

2013-02-14 Thread Drew Kutcharian
nfused what you are looking to do. >> >> CQL3 syntax (SELECT * FROM keyspace.cf WHERE user = 'cooldude') has >> nothing to do with thrift client calls (such as multiget_slice) >> >> What is your goal here? >> >> Best, >> michael >>

multiget_slice using CQL3

2013-02-14 Thread Drew Kutcharian
Hi Guys, What's the syntax for multiget_slice in CQL3? How about multiget_count? -- Drew

Cassandra Geospatial Search

2013-02-13 Thread Drew Kutcharian
Hi Guys, Has anyone on this mailing list tried to build a bounding box style (get the records inside a known bounding box) geospatial search? I've been researching this a bit and seems like the only attempt at this was by SimpleGeo guys, but there isn't much public info out there on how they di

Re: Documentation/Examples for DataStax java-driver

2013-02-13 Thread Drew Kutcharian
gt; session = cluster.connect(getInitParameter("keyspace")); > > I have queries that i have begin unlogged batch instead of begin batch > > Hopefully it helps > > > On Wed, Feb 13, 2013 at 12:23 PM, Drew Kutcharian wrote: > @Shahryar/Gabriel > I kn

Re: Documentation/Examples for DataStax java-driver

2013-02-13 Thread Drew Kutcharian
. > Occasionally a cross post makes sense. > > Edward > > On Wed, Feb 13, 2013 at 12:23 PM, Drew Kutcharian wrote: >> @Shahryar/Gabriel >> I know the source code is nicely documented, but I couldn't find much info >> on: >> 1. Creating/submitting ato

Re: Documentation/Examples for DataStax java-driver

2013-02-13 Thread Drew Kutcharian
t; >> Source code has enough documentation in it, apparently this is how they do >> it with new stuff. Start with Custer class, it tells you how to write. If >> you still had problem let me know, I can give you sample code. >> >> >> On Tue, Feb 12, 2013 at 9

Documentation/Examples for DataStax java-driver

2013-02-12 Thread Drew Kutcharian
Are there any documentation/examples available for DataStax java-driver besides what's in the GitHub repo? -- Drew

Re: Cassandra 1.2 Atomic Batches and Thrift API

2013-02-12 Thread Drew Kutcharian
ssandra client mailing list: > client-...@cassandra.apache.org. > > -- > Sylvain > > > On Tue, Feb 12, 2013 at 4:44 AM, Drew Kutcharian wrote: > Hey Guys, > > Is the new atomic batch feature in Cassandra 1.2 available via the thrift > API? If so, how can I use it? > > -- Drew > >

Re: Operation Consideration with Counter Column Families

2013-02-11 Thread Drew Kutcharian
Aaron Morton > Freelance Cassandra Developer > New Zealand > > @aaronmorton > http://www.thelastpickle.com > > On 6/02/2013, at 11:15 AM, Drew Kutcharian wrote: > >> Thanks Aaron, so will there only be one "value" for each counter column per >> sstable just li

Cassandra 1.2 Atomic Batches and Thrift API

2013-02-11 Thread Drew Kutcharian
Hey Guys, Is the new atomic batch feature in Cassandra 1.2 available via the thrift API? If so, how can I use it? -- Drew

Re: Operation Consideration with Counter Column Families

2013-02-05 Thread Drew Kutcharian
ored on disk? > Same as regular CF's. > >> How do they effect compaction? > None. > > Cheers > > - > Aaron Morton > Freelance Cassandra Developer > New Zealand > > @aaronmorton > http://www.thelastpickle.com > > On

Operation Consideration with Counter Column Families

2013-02-05 Thread Drew Kutcharian
Hey Guys, Are there any specific operational considerations one should make when using counter columns families? How are counter column families stored on disk? How do they effect compaction? -- Drew

Re: How to show unread messages counts?

2013-01-02 Thread Drew Kutcharian
t to keep. > > Cheers > > - > Aaron Morton > Freelance Cassandra Developer > New Zealand > > @aaronmorton > http://www.thelastpickle.com > > On 3/01/2013, at 8:37 AM, Drew Kutcharian wrote: > >> Happy New Year Everyone! >> >

How to show unread messages counts?

2013-01-02 Thread Drew Kutcharian
Happy New Year Everyone! What's the best way to model "unread messages count" in Cassandra? I have a UserMessage CF where the row key is the user id and the column name is the message id (timeuuid) and I store the message and the status (READ/UNREAD) in the value column. I would like to be able

Re: State of Cassandra and Java 7

2012-12-14 Thread Drew Kutcharian
iously encourage people to try Java 7 as much as possible and report any >> problem they may run into, but I would have though this goes without saying. >> >> >> On Fri, Dec 14, 2012 at 4:05 AM, Rob Coli wrote: >>> >>> On Thu, Dec 13, 2012 at 11:43 AM, Drew Kut

State of Cassandra and Java 7

2012-12-13 Thread Drew Kutcharian
Hey Guys, With Java 6 begin EOL-ed soon (https://blogs.oracle.com/java/entry/end_of_public_updates_for), what's the status of Cassandra's Java 7 support? Anyone using it in production? Any outstanding *known* issues? -- Drew

Re: Single Node Cassandra Installation

2012-11-10 Thread Drew Kutcharian
st of keeping the property file in sync) when it comes to growth. What do you think? -- Drew On Nov 5, 2012, at 7:50 PM, Rob Coli wrote: > On Mon, Nov 5, 2012 at 12:23 PM, Drew Kutcharian wrote: >>> Switching from SimpleStrategy to RackAware can be a pain. >> >> Can yo

Re: Single Node Cassandra Installation

2012-11-05 Thread Drew Kutcharian
; On 11/5/12 9:59 AM, "zGreenfelder" wrote: > >> On Mon, Nov 5, 2012 at 12:49 PM, Drew Kutcharian wrote: >>> Hey Guys, >>> >>> What should I look out for when deploying a single node installation? >>> We want to launch a product that uses Cassand

Single Node Cassandra Installation

2012-11-05 Thread Drew Kutcharian
Hey Guys, What should I look out for when deploying a single node installation? We want to launch a product that uses Cassandra and since we are going to have very little load initially, we were thinking of just going live with one node and eventually add more nodes as the load (hopefully) grow

Re: Data Modeling: Comments with Voting

2012-09-29 Thread Drew Kutcharian
> > > Depending on your needs, you could simply duplicate the comments in two > > separate CFs with the column names including time in one and the vote in > > the other. If you allow for updates to the comments, that would pose > > some issues you'd need to solve at

Data Modeling: Comments with Voting

2012-09-26 Thread Drew Kutcharian
Hi Guys, Wondering what would be the best way to model a flat (no sub comments, i.e. twitter) comments list with support for voting (where I can sort by create time or votes) in Cassandra? To demonstrate: Sorted by create time: - comment 1 (5 votes) - comment 2 (1 votes) - comment 3 (no votes)

Re: DROP keyspace doesn't delete the files

2012-08-02 Thread Drew Kutcharian
bump On Jul 29, 2012, at 11:03 PM, Drew Kutcharian wrote: > Hi, > > What's the correct procedure to drop a keyspace? When I drop a keyspace, the > files of that keyspace don't get deleted. There is a JIRA on this: > > https://issues.apache.org/jira/browse/CASSANDR

DROP keyspace doesn't delete the files

2012-07-29 Thread Drew Kutcharian
Hi, What's the correct procedure to drop a keyspace? When I drop a keyspace, the files of that keyspace don't get deleted. There is a JIRA on this: https://issues.apache.org/jira/browse/CASSANDRA-4075 Is this a bug or I'm missing something? I'm using Cassandra 1.1.2 on Ubuntu Linux with Sun JV

Re: Highest and lowest valid values for UUIDs/TimeUUIDs

2012-04-24 Thread Drew Kutcharian
-1000-8080-808080808080'. > The highest is '--1fff-bf7f-7f7f7f7f7f7f'. > > On Tue, Apr 24, 2012 at 12:47 PM, Drew Kutcharian wrote: > Thanks. So looking at the code, to get the lowest possible TimeUUID value > using your function I should just call co

Re: Highest and lowest valid values for UUIDs/TimeUUIDs

2012-04-24 Thread Drew Kutcharian
Thanks. So looking at the code, to get the lowest possible TimeUUID value using your function I should just call convert_time_to_uuid(0) ? On Apr 24, 2012, at 10:15 AM, Tyler Hobbs wrote: > Yes, I have tested it. > > On Tue, Apr 24, 2012 at 12:08 PM, Drew Kutcharian wrote: > Than

Re: Highest and lowest valid values for UUIDs/TimeUUIDs

2012-04-24 Thread Drew Kutcharian
pache.org/msg00125.html > > Looking at the linked pycassa code might be the most useful thing. > > On Tue, Apr 24, 2012 at 1:46 AM, Drew Kutcharian wrote: > Hi All, > > Considering that UUIDs are compared as numbers in Java [1], what are the > lowest and highest possible values

Highest and lowest valid values for UUIDs/TimeUUIDs

2012-04-23 Thread Drew Kutcharian
Hi All, Considering that UUIDs are compared as numbers in Java [1], what are the lowest and highest possible values a valid UUID can have? How about TimeUUIDs? The reason I ask is that I would like to pick a "default" UUID value in a composite column definition like Composite(UUID1, UUID2) wher

OFF TOPIC: Anyone knows of a good mailing list for network administrators?

2012-04-13 Thread Drew Kutcharian
Hi Guys, Sorry for posting this here, but I figured there should be a lot of smart Network/System Admins on this list which can recommend a good mailing list/forum for questions related to networking and rack/datacenter setups. Best, Drew

Re: Issue with cassandra-cli "assume"

2012-03-23 Thread Drew Kutcharian
s possible with the cli. You'd have to embellish > CliClient.Function > > > > On 03/23/2012 09:59 PM, Drew Kutcharian wrote: >> I actually have a custom type, I put the BytesType in the example to >> demonstrate the issue is not with my custom type. >> &g

Re: Issue with cassandra-cli "assume"

2012-03-23 Thread Drew Kutcharian
I actually have a custom type, I put the BytesType in the example to demonstrate the issue is not with my custom type. -- Drew On Mar 23, 2012, at 6:46 PM, Dave Brosius wrote: > I think you want > > assume UserDetails validator as bytes; > > > > On 03/23/2012 08:0

Issue with cassandra-cli "assume"

2012-03-23 Thread Drew Kutcharian
Hi Everyone, I'm having an issue with cassandra-cli's assume command with a custom type. I tried it with the built-in BytesType and got the same error: [default@test] assume UserDetails validator as org.apache.cassandra.db.marshal.BytesType; Syntax error at position 35: missing EOF at '.' I al

Re: Single Node Cassandra Installation

2012-03-15 Thread Drew Kutcharian
; > One other disadvantage is the lack of "consistency level" and "replication". > Both ware part of the high availability / redundancy. So you would really > need to backup your single-node-"cluster" to some other external location. > > Good luck! >

Single Node Cassandra Installation

2012-03-15 Thread Drew Kutcharian
Hi, We are working on a project that initially is going to have very little data, but we would like to use Cassandra to ease the future scalability. Due to budget constraints, we were thinking to run a single node Cassandra for now and then add more nodes as required. I was wondering if it is

Anybody using Cassandra/DataStax Distribution with Java Service Wrapper?

2012-02-15 Thread Drew Kutcharian
Hi Everyone, I noticed that the DataStax's distribution of Cassandra uses Jsvc. There's also Tanuki Java Service Wrapper (http://wrapper.tanukisoftware.com/doc/english/download.jsp) that does a lot more than simply launching a Java process, for example it monitors the JVM and even restarts fai

Implications of length of column names

2012-02-10 Thread Drew Kutcharian
What are the implications of using short vs long column names? Is it better to use short column names or longer ones? I know for MongoDB you are better of using short field names http://www.mongodb.org/display/DOCS/Optimizing+Storage+of+Small+Objects Does this apply to Cassandra column names?

Deleting a column vs setting it's value to empty

2012-02-10 Thread Drew Kutcharian
Hi Everyone, Let's say I have the following object which I would like to save in Cassandra: class User { UUID id; //row key String name; //columnKey: "name", columnValue: the name of the user String description; //columnKey: "description", columnValue: the description of the user } Descri

Re: How to reliably achieve unique constraints with Cassandra?

2012-01-06 Thread Drew Kutcharian
> additional check if the entry for email id exists in EmailUUIDIndex then the > request for registration can be rejected right away. > > Make sense? > > -Naren > > On Fri, Jan 6, 2012 at 4:00 PM, Drew Kutcharian wrote: > So what are the common RIGHT solutions/tools fo

Re: How to reliably achieve unique constraints with Cassandra?

2012-01-06 Thread Drew Kutcharian
. > > > > On Fri, Jan 6, 2012 at 2:35 PM, Drew Kutcharian wrote: > Thanks everyone for the replies. Seems like there is no easy way to handle > this. It's very surprising that no one seems to have solved such a common use > case. > > -- Drew > > On Jan

Re: How to reliably achieve unique constraints with Cassandra?

2012-01-06 Thread Drew Kutcharian
gh, see (Locks based > on ephemeral nodes) from the zk mailing list in October: > http://mail-archives.apache.org/mod_mbox/zookeeper-user/201110.mbox/thread?0 > > -Bryce > > On Fri, 6 Jan 2012 13:36:52 -0800 > Drew Kutcharian wrote: >> Bryce, >> >> I'm no

Re: How to reliably achieve unique constraints with Cassandra?

2012-01-06 Thread Drew Kutcharian
n Fri, 6 Jan 2012 10:03:38 -0800 > Drew Kutcharian wrote: >> I know that this can be done using a lock manager such as ZooKeeper >> or HazelCast, but the issue with using either of them is that if >> ZooKeeper or HazelCast is down, then you can't be sure about the &

Re: How to reliably achieve unique constraints with Cassandra?

2012-01-06 Thread Drew Kutcharian
Yes, my issue is with handling concurrent requests. I'm not sure how your logic will work with eventual consistency. I'm going to have the same issue in the "tracker" CF too, no? On Jan 6, 2012, at 10:38 AM, Mohit Anchlia wrote: > On Fri, Jan 6, 2012 at 10:03 AM, Drew K

How to reliably achieve unique constraints with Cassandra?

2012-01-06 Thread Drew Kutcharian
Hi Everyone, What's the best way to reliably have unique constraints like functionality with Cassandra? I have the following (which I think should be very common) use case. User CF Row Key: user email Columns: userId: UUID, etc... UserAttribute1 CF: Row Key: userId (which is the uuid that's map

Choosing a Partitioner Type for Random java.util.UUID Row Keys

2011-12-19 Thread Drew Kutcharian
Hey Guys, I just came across http://wiki.apache.org/cassandra/ByteOrderedPartitioner and it got me thinking. If the row keys are java.util.UUID which are generated randomly (and securely), then what type of partitioner would be the best? Since the key values are already random, would it make a

Re: raid 0 and ssd

2011-04-13 Thread Drew Kutcharian
RAID 0 is the fastest, but you'll lose the whole array if you lose a drive. One thing to keep in mind is that SSDs get slower as they get filled up and closer to their capacity due to garbage collection. If you want more info on how SSDs perform in general, Percona guys have done extensive test

Re: Possible design flaw in "Cassandra By Example" blog

2011-04-13 Thread Drew Kutcharian
, Drew On Apr 13, 2011, at 4:51 PM, Eric Evans wrote: > On Wed, 2011-04-13 at 15:07 -0700, Drew Kutcharian wrote: >> username = 'jericevans' >> password = '**' >> useruuid = str(uuid()) >> columns = {'id': useruuid, 'user

Possible design flaw in "Cassandra By Example" blog

2011-04-13 Thread Drew Kutcharian
Hi Everyone, I was going thru Cassandra By Example Blog http://www.rackspace.com/cloud/blog/2010/05/12/cassandra-by-example/ and I had a question about the user sign up section: username = 'jericevans' password = '**' useruuid = str(uuid()) columns = {'id': useruuid, 'username': usernam

Re: Atomicity Strategies

2011-04-08 Thread Drew Kutcharian
I'm interested in this too, but I don't think this can be done with Cassandra alone. Cassandra doesn't support transactions. I think hector can retry operations, but I'm not sure about the atomicity of the whole thing. On Apr 8, 2011, at 1:26 PM, Alex Araujo wrote: > Hi, I was wondering if th

Re: Secondary Indexes

2011-04-03 Thread Drew Kutcharian
I just updated added a new page to the wiki: http://wiki.apache.org/cassandra/SecondaryIndexes On Apr 3, 2011, at 7:37 PM, Drew Kutcharian wrote: > Yea I know, I just didn't know anyone can update it. > > > On Apr 3, 2011, at 1:26 PM, Joe Stump wrote: > >> >

Re: Secondary Indexes

2011-04-03 Thread Drew Kutcharian
Yea I know, I just didn't know anyone can update it. On Apr 3, 2011, at 1:26 PM, Joe Stump wrote: > > On Apr 3, 2011, at 2:22 PM, Drew Kutcharian wrote: > >> Thanks Tyler. Can you update the wiki with these answers so they are stored >> there for others to see too? > > Dude, it's a wiki.

Re: Secondary Indexes

2011-04-03 Thread Drew Kutcharian
implemented as a slightly > special separate column family with the indexed value serving as the key; > most of the properties of secondary indexes follow from that. > > On Sun, Apr 3, 2011 at 2:28 PM, Drew Kutcharian wrote: > Hi Everyone, > > I posted the following email a co

Secondary Indexes

2011-04-03 Thread Drew Kutcharian
Hi Everyone, I posted the following email a couple of days ago and I didn't get any responses. Makes me wonder, does anyone on this list know/use Secondary Indexes? They seem to me like a pretty big feature and it's a bit disappointing to not be able to get a documentation on it. The only thin

Re: Revised: Data Modeling advise for Cassandra 0.8 (added #8)

2011-03-31 Thread Drew Kutcharian
t; - standard CF to hold the blogs for a user, key is the user id and each > column is the blog key > > Thats not a great schema but it's a simple starting point you can build on > and refine using things like secondary indexes and doing more/less in the > same

Re: Any way to get different unique time UUIDs for the same time value?

2011-03-30 Thread Drew Kutcharian
be able to have a number > of duplicate timestamps. > > On Wed, Mar 30, 2011 at 4:24 PM, Drew Kutcharian wrote: >> Hi Ed, >> >> There's no need to re-invent the wheel that's pretty much what Twitter >> Snowflake does. The way it works is it creates a

Questions about Secondary Indexes

2011-03-30 Thread Drew Kutcharian
Hi Everyone, I just read Jonathan Ellis' great post on Secondary Indexes (http://www.datastax.com/dev/blog/whats-new-cassandra-07-secondary-indexes) and I was wondering where I can find a bit more info on them. I would like to know: 1) Are there in limitations beside the hash properties (no be

Re: Any way to get different unique time UUIDs for the same time value?

2011-03-30 Thread Drew Kutcharian
leaving a certain number of low order bits of the clock > sequence empty and then incrementing those when duplicate timestamps > were generated rather than incrementing the timestamp the way UUIDGen > currently does. > > On Wed, Mar 30, 2011 at 10:08 AM, Drew Kutcharian wrote: >&

Looking for an independent consultant

2011-03-30 Thread Drew Kutcharian
Hi Everyone, Anyone on this list interested in a remote very flexible contract gig? If yes, please contact me directly. Thanks, Drew Kutcharian Chief Technology Officer Venarc Inc. www.venarc.com Phone: 818-524-2500

Re: Any way to get different unique time UUIDs for the same time value?

2011-03-30 Thread Drew Kutcharian
Hi Roshan, You probably want to look at Twitter's Snowflake: https://github.com/twitter/snowflake There's also another Java variant: https://github.com/earnstone/eid - Drew On Mar 30, 2011, at 6:08 AM, Roshan Dawrani wrote: > Hi, > > Is there any way I can get multiple unique time UUIDs for

Revised: Data Modeling advise for Cassandra 0.8 (added #8)

2011-03-29 Thread Drew Kutcharian
I'm pretty new to Cassandra and I would like to get your advice on modeling. The object model of the project that I'm working on will be pretty close to Blogger, Tumblr, etc. (or any other blogging website). Where you have Users, that each can have many Blogs and each Blog can have many comments

Data Modeling advise for Cassandra 0.8

2011-03-29 Thread Drew Kutcharian
I'm pretty new to Cassandra and I would like to get your advice on modeling. The object model of the project that I'm working on will be pretty close to Blogger, Tumblr, etc. (or any other blogging website). Where you have Users, that each can have many Blogs and each Blog can have many comments

  1   2   >