Re: Is there a plan for Feature like this in C* ?

ship a Kafka connector but > > > > > > > certainly people have written them > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > Jeff Jirsa > > > > > > > > > > > &g

Re: Is there a plan for Feature like this in C* ?

ship a Kafka connector but > > > > > > > certainly people have written them > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > Jeff Jirsa > > > &g

Re: Is there a plan for Feature like this in C* ?

> >>> >>> -- >>> Jeff Jirsa >>> >>> >>> On Jul 2, 2018, at 6:50 PM, Kant Kodali wrote: >>> >>> Hi Justin, >>> >>> Thanks, Looks like a very early stage feature and no integration with >>> Kafka yet

Re: Is there a plan for Feature like this in C* ?

doesn’t ship a Kafka connector but >> certainly people have written them >> >> >> -- >> Jeff Jirsa >> >> >> On Jul 2, 2018, at 6:50 PM, Kant Kodali wrote: >> >> Hi Justin, >> >> Thanks, Looks like a very early stage feature an

Re: Is there a plan for Feature like this in C* ?

l 2, 2018, at 6:50 PM, Kant Kodali wrote: > > Hi Justin, > > Thanks, Looks like a very early stage feature and no integration with > Kafka yet I suppose. > > Thanks! > > On Mon, Jul 2, 2018 at 6:24 PM, Justin Cameron > wrote: > >> yes, take a look at >> h

Re: Is there a plan for Feature like this in C* ?

Its a stable API - the project doesn’t ship a Kafka connector but certainly people have written them -- Jeff Jirsa > On Jul 2, 2018, at 6:50 PM, Kant Kodali wrote: > > Hi Justin, > > Thanks, Looks like a very early stage feature and no integration with Kafka > yet I su

Re: Is there a plan for Feature like this in C* ?

Hi Justin, Thanks, Looks like a very early stage feature and no integration with Kafka yet I suppose. Thanks! On Mon, Jul 2, 2018 at 6:24 PM, Justin Cameron wrote: > yes, take a look at http://cassandra.apache.org/ > doc/latest/operating/cdc.html > > On Tue, 3 Jul 2018 at 01:20

Re: Is there a plan for Feature like this in C* ?

yes, take a look at http://cassandra.apache.org/doc/latest/operating/cdc.html On Tue, 3 Jul 2018 at 01:20 Kant Kodali wrote: > https://www.cockroachlabs.com/docs/v2.1/change-data-capture.html > -- *Justin Cameron*Senior Software Engineer This email has been

Is there a plan for Feature like this in C* ?

https://www.cockroachlabs.com/docs/v2.1/change-data-capture.html

RE: [EXTERNAL] Re: Any Cassandra Backup and Restore tool like Cassandra Reaper?

To: user@cassandra.apache.org Subject: [EXTERNAL] Re: Any Cassandra Backup and Restore tool like Cassandra Reaper? Tablesnap assumes S3, and tableslurp can set up the stage for restoring by downloading the relevant SSTables (but then it's up to the operator to complete the restore from

Re: Any Cassandra Backup and Restore tool like Cassandra Reaper?

Vangapelli -T (hvangape - AKRAYA >> INC at Cisco) <hvang...@cisco.com> wrote: >> >>> Any Cassandra Backup and Restore tool like Cassandra Reaper for Repairs? >>> >>> >>> >>> [image: >>> http://wwwin.cisco.com/c/dam/cec/orga

Re: Any Cassandra Backup and Restore tool like Cassandra Reaper?

ch of those servers to tape > for offsite backup. > > > On Thu, Dec 14, 2017 at 1:30 PM Harika Vangapelli -T (hvangape - AKRAYA > INC at Cisco) <hvang...@cisco.com> wrote: > >> Any Cassandra Backup and Restore tool like Cassandra Reaper for Repairs? >> >>

Re: Any Cassandra Backup and Restore tool like Cassandra Reaper?

that one rack contains 1 replica of each keyspace and then using r1soft to image each of those servers to tape for offsite backup. On Thu, Dec 14, 2017 at 1:30 PM Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco) <hvang...@cisco.com> wrote: > Any Cassandra Backup and Restore tool like

Any Cassandra Backup and Restore tool like Cassandra Reaper?

Any Cassandra Backup and Restore tool like Cassandra Reaper for Repairs? [http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png] Harika Vangapelli Engineer - IT hvang...@cisco.com<mailto:hvang...@cisco.com> Tel: Cisco System

Re: LIKE

On 2017-06-20 23:44 (-0700), web master <socketman2...@gmail.com> wrote: > I have this table > > CREATE TABLE users_by_username ( > username text PRIMARY KEY, > email text, > age int > ) > > I want to run query like the following > > select

Re: LIKE

If you are sure , that you want to do LIKE , then you can go with SASI . https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/useSASIIndex.html Hope this will help you . On Wed, Jun 21, 2017 at 2:44 PM, web master <socketman2...@gmail.com> wrote: > I have this table > &g

LIKE

I have this table CREATE TABLE users_by_username ( username text PRIMARY KEY, email text, age int ) I want to run query like the following select username from users where username LIKE 'shl%' LIMIT 10; Always , I want to find only 10 username (Case insensitive) that start

Re: iostat -like tool to parse 'nodetool cfstats'

Hi Kevin, > nodetool cfstats has some valuable data but what I would like is a 1 > minute delta. And you are right in what you think would be useful. In many cases variation is a way more informative than an absolute value indeed. I have a doubt regarding your approach though. I want

Re: iostat -like tool to parse 'nodetool cfstats'

Anything in cfstats you should be able to retrieve through the metrics Mbeans. See https://cassandra.apache.org/doc/latest/operating/metrics.html On 20 December 2016 at 23:04, Richard L. Burton III <mrbur...@gmail.com> wrote: > I haven't seen anything like that myself. It would be nic

Re: iostat -like tool to parse 'nodetool cfstats'

I haven't seen anything like that myself. It would be nice to have nodetool cfstats to be presented in a nicier format. If you plan to work on that, let me know. I would help contribute to it next month. On Tue, Dec 20, 2016 at 5:59 PM, Kevin Burton <bur...@spinn3r.com> wrote: >

iostat -like tool to parse 'nodetool cfstats'

nodetool cfstats has some valuable data but what I would like is a 1 minute delta. Similar to iostat... It's easy to parse this but has anyone done it? I want to see IO throughput and load on C* for each table. -- We’re hiring if you know of any awesome Java Devops or Linux Operations

Re: Having Counters in a Collection, like a map<int, counter>?

The keys however are dynamic in my case. Why is it problem for you? As you said "if something related to 5 happened, then i'd get the counter for 5 and increment / decrement it." So do "UPDATE cnt SET value = value + SOMETHING where id = 5;" If counter for event 5 exists it will be changed,

Re: Having Counters in a Collection, like a map<int, counter>?

The only issue with the last 2 solutions is, they require knowing the key in advance in order to look up the counters. The keys however are dynamic in my case. On Wed, Nov 9, 2016 at 5:47 PM, DuyHai Doan wrote: > "Is there a way to do this in c* which doesn't require

Re: Having Counters in a Collection, like a map<int, counter>?

"Is there a way to do this in c* which doesn't require creating 1 table per type of map that i need?" You're lucky, it's possible with some tricks CREATE TABLE my_counters_map ( partition_key id uuid, map_name text, map_key int, count counter, PRIMARY KEY

Re: Having Counters in a Collection, like a map<int, counter>?

Unfortunately it's impossible nor to use counters inside collections neither mix them with other non-counter columns : CREATE TABLE cnt (id int PRIMARY KEY , cntmap MAPint,counter); InvalidRequest: Error from server: code=2200 [Invalid query] message="Counters are not allowed inside

Having Counters in a Collection, like a map<int, counter>?

I have a use-case where I need to have a dynamic number of counters. The easiest way to do this would be to have a map where the int is the key, and the counter is the value which is incremented / decremented. E.g if something related to 5 happened, then i'd get the counter for 5

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

> --> Yes in the current impl, it means ENDS WITH '%escape' but we want SASI to > understand the %% as an escape for % so the goal is that SASI understands > LIKE '%%escape' as EQUALS TO '%escape'. Am I correct ? I guess that the goal is to define a way to use ‘%’ as a simple cha

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

"In the current implementation (‘%’ could be a wildcard only at the start/end of a term) I guess it should be ’ENDS with ‘%escape’ ‘." --> Yes in the current impl, it means ENDS WITH '%escape' but we want SASI to understand the %% as an escape for % so the goal is that SASI und

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

> LIKE '%%%escape' --> EQUALS TO '%%escape' ??? In the current implementation (‘%’ could be a wildcard only at the start/end of a term) I guess it should be ’ENDS with ‘%escape’ ‘. Moreover all terms that contains single ‘%’ somewhere in the middle should cause an exception. BUT may b

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

Reminder, right now, the % character is only interpreted as wildcard IF AND ONLY IF it is the first/last character of the searched term LIKE '%escape' --> ENDS WITH 'escape' If we use % to escape %, LIKE '%%escape' --> EQUALS TO '%escape' LIKE '%%%escape' --> EQUALS TO

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

Hi, Jim, What pattern should be used to search “ends with ‘%escape’ “ with your conception? Thanks, Mikhail > On 22 Sep 2016, at 18:51, Jim Ancona <j...@anconafamily.com> wrote: > > To answer DuyHai's question without introducing new syntax, I'd suggest: >> LIKE '%%

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

To answer DuyHai's question without introducing new syntax, I'd suggest: LIKE '%%%escape' means STARTS WITH '%' AND ENDS WITH 'escape' So the first two %'s are translated to a literal, non-wildcard % and the third % is a wildcard because it's not doubled. Jim On Thu, Sep 22, 2016 at 11:40 AM

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

I guess that it should be similar to how it is done in SQL for LIKE patterns. You can introduce an escape character, e.g. ‘\’. Examples: ‘%’ - any string ‘\%’ - equal to ‘%’ character ‘\%foo%’ - starts from ‘%foo’ ‘%%%escape’ - ends with ’escape’ ‘\%%’ - starts from ‘%’ ‘\\\%%’ - starts from

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

Hello Mikhail It's more complicated that it seems LIKE '%%escape' means EQUAL TO '%escape' LIKE '%escape' means ENDS WITH 'escape' What's about LIKE '%%%escape' How should we treat this case ? Replace %% by % at the beginning of the searched term ?? On Thu, Sep 22, 2016 at 3:31 PM

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

Hi! We’ve talked about two items: 1) ‘%’ as a wildcard in the middle of LIKE pattern. 2) How to escape ‘%’ to be able to find strings with the ‘%’ char with help of LIKE. Item #1was resolved as CASSANDRA-12573. Regarding to item #2: you said the following: > A possible fix would be: >

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

urce code directly. > > Here is the method where C* determines what kind of LIKE expression you're > using (LIKE_PREFIX , LIKE CONTAINS or LIKE_MATCHES) > > https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/cql3/restrictions/SingleColumnRestriction.java#L7

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

Ok I get around the issue about %w%a% So this will be interpreter first by the CQL parser as LIKE CONTAINS with searched term = w%a And then things get complicated 1) if you're using NonTokeninzingAnalyzer or NoOpAnalyzer, everything is fine, the % in 'w%a' is interpreted as simple literal

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

Currently SASI can only understand the % for the beginning (suffix) or ending (prefix) position. Any expression containing the % in the middle like %w%a% will not be interpreter by SASI as wildcard. %w%a% will translate into "Give me all results containing w%a On Thu, Sep 15, 2016 at 3:

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

il.com> wrote: > > Ok so I've found the source of the issue, it's pretty well hidden because it > is NOT in the SASI source code directly. > > Here is the method where C* determines what kind of LIKE expression you're > using (LIKE_PREFIX , LIKE CONTAINS or LIKE_MATCHES) >

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

Ok so I've found the source of the issue, it's pretty well hidden because it is NOT in the SASI source code directly. Here is the method where C* determines what kind of LIKE expression you're using (LIKE_PREFIX , LIKE CONTAINS or LIKE_MATCHES) https://github.com/apache/cassandra/blob/trunk/src

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

Ok you're right, I get your point LIKE '%%esc%' --> startWith('%esc') LIKE 'escape%%' --> = 'escape%' What I strongly suspect is that in the source code of SASI, we parse the % xxx % expression BEFORE applying escape. That will explain the observed behavior. E.g: LIKE '%%esc%' parsed a

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

Looks like we have different understanding of what results are expected. I based my understanding on http://docs.datastax.com/en/cql/3.3/cql/cql_using/useSASIIndex.html <http://docs.datastax.com/en/cql/3.3/cql/cql_using/useSASIIndex.html> According to the doc ‘esc’ is a pattern for exact

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

* FROM escape WHERE val LIKE '%%esc%'; --> Give all results *containing* '%esc' so *%esc*apeme is a possible match and also escape*%esc* SELECT * FROM escape WHERE val LIKE 'escape%%' --> Give all results *starting* with 'escape%' so *escape%*me is a valid result and also *escape%*esc On Tue,

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

* FROM escape WHERE val LIKE '%%esc%'; id | val +--- 1 | %escapeme 3 | escape%esc (2 rows) Prefix search cqlsh:test> SELECT * FROM escape WHERE val LIKE 'escape%%'; id | val +--- 2 | escape%me 3 | escape%esc Thanks, Mikhail > On 13 Sep 2016, at 18:16,

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

Use % to escape % cqlsh:test> select * from escape; id | val +--- 1 | %escapeme 2 | escape%me Contains search cqlsh:test> SELECT * FROM escape WHERE val LIKE '%%esc%'; id | val +--- 1 | %escapeme (1 rows) Prefix search cqlsh:test> SELECT * FR

How to query '%' character using LIKE operator in Cassandra 3.7?

, 'f22', 'qweasd'); SELECT c2 from kmv.kmv where c2 like ‘_pattern_'; _pattern_ '%%%' finds all columns that contain %. How to find columns that start form ‘%’ or ‘%a’? How to find columns that end with ‘%’? What about more complex patterns: '%qwe%a%sd%’? How to differentiate ‘%’ char form

Re: How to print out the metrics information, like compaction and garbage collection?

ks well and > is easy to deploy. > > However, in the monitoring output figure for different metrics, the > interval is 1 minute, which is longer than I want. What I want is something > like one metric value / second and I want to have a close eye on each > metric. > > That'

RE: How to print out the metrics information, like compaction and garbage collection?

is something like one metric value / second and I want to have a close eye on each metric. That's why I post question and want to print out the metrics information in the console. I'm wondering whether you have any other solution for my question. Thanks! Jun From: otis.gospodne

Re: How to print out the metrics information, like compaction and garbage collection?

pactionMetrics metrics = new CompactionMetrics(); >System.out.println(metrics.pendingtasks); > >But it doesn't work. > > * > Another/same question is about the garbage collection, any idea on where > should I refer to and get the information about garbage collection, lik

How to print out the metrics information, like compaction and garbage collection?

collection, any idea on where should I refer to and get the information about garbage collection, like garbage collection count, collection time, etc. Any hint will be appreciated. Thanks! Jun

Re: howto do sql query like in a relational database

Hello Anton, You need to look into Datastax Entreprise (DSE) Offering. It integrates Solr search which allows you to do searches like the one you mention. There are also some opensource projects doing this kind of integration, so its up to you. And as Oded mentioned Cassandra really shines

howto do sql query like in a relational database

Hi, I have a simple (perhaps stupid) question. If I want to *search* data in cassandra, how could find in a text field all records which start with 'Cas' ( in sql I do select * from table where field like 'Cas%') I know that this is not directly possible. - But how is it possible? - Do

RE: howto do sql query like in a relational database

@cassandra.apache.org Subject: howto do sql query like in a relational database Hi, I have a simple (perhaps stupid) question. If I want to *search* data in cassandra, how could find in a text field all records which start with 'Cas' ( in sql I do select * from table where field like 'Cas%') I

any nodetool-like showparameters to show loaded cassandra.yaml parameters ?

Hi, I have not seen any available cmd like nodetool showparameters to show loaded cassandra.yaml parameters of one node (to display them remotely, or to check if loaded parameters are the ones of the cassandra.yaml). Does anyone know if there is a cmd to display those parameters (I don't think

Re: any nodetool-like showparameters to show loaded cassandra.yaml parameters ?

On Wed, Apr 22, 2015 at 10:09 AM, DE VITO Dominique dominique.dev...@thalesgroup.com wrote: I have not seen any available cmd like “nodetool showparameters” to show loaded cassandra.yaml parameters of one node (to display them remotely, or to check if loaded parameters are the ones

Read 75k live rows in a query that should only return 500 (in queue-like table).

I have a queue-like table which is reading 75k Iive rows… and then only returning 500. … I'm trying to figure out why this could be. Following this: http://www.datastax.com/dev/blog/cassandra-anti-patterns-queues-and-queue-like-datasets I BELIEVE that I'm doing everything right. Essentially

Re: Data modeling for Pinterest-like application

. We will also have a like board for each user containing pins that they like, which can be somewhat private and only viewed by the owner. Since a pin can be potentially liked by thousands of user, if we also denormalize the like board, everytime that pin is liked by another user we would have

Re: Data modeling for Pinterest-like application

I was thinking to use counter type a separate pin counter table and, when I need to update the like count, I would use read-after-write to get the current value and timestamp and then denormalize into pin's detail table and board tables. Is it a viable solution in this case? Thanks -- View

Data modeling for Pinterest-like application

Hello, I'm working on data modeling for a Pinterest-like project. There are basically two main concepts: Pin and Board, just like Pinterest, where pin is an item containing an image, description and some other information such as a like count, and each board should contain a sorted list of Pins

Re: Data modeling for Pinterest-like application

reads to load the pins. Multiply it by the number of users listing boards and you'll be quickly in trouble... For the update of pins like count, you'll need to use counter type. denormalization seems to bring a lot of load on the write side as well as application code complexity -- first C* copes

Re: Data modeling for Pinterest-like application

Thanks for your answer, I really like the frequency of update vs read way of thinking. A related question is whether it is a good idea to denormalize on read-heavy part of data while normalize on other less frequently-accessed data? Our app will have a limited number of system managed boards

Re: this seems like a flaw in Node Selection

Does this still apply since we're using 1.2.13? (should have said that in the original message) Thank you. On Thu, Mar 20, 2014 at 3:57 PM, Robert Coli rc...@eventbrite.com wrote: On Thu, Mar 20, 2014 at 12:31 PM, Brian Tarbox tar...@cabotresearch.comwrote: I've seen this problem with

Re: this seems like a flaw in Node Selection

On Thu, Mar 20, 2014 at 1:03 PM, Brian Tarbox tar...@cabotresearch.comwrote: Does this still apply since we're using 1.2.13? (should have said that in the original message) I checked the cassandra-1.2 branch to verify that the dynamic_snitch config file option is still supported there; it

Re: this seems like a flaw in Node Selection

Brian, Are you referring to Pelops? The code you mentioned doesn't exist in Cassandra. On Thu, Mar 20, 2014 at 3:07 PM, Robert Coli rc...@eventbrite.com wrote: On Thu, Mar 20, 2014 at 1:03 PM, Brian Tarbox tar...@cabotresearch.comwrote: Does this still apply since we're using 1.2.13?

Re: this seems like a flaw in Node Selection

Yes, I was going to say (sorry for the brain-freeze) that this is behavior in Pelops not in C* itself. On Thu, Mar 20, 2014 at 4:15 PM, Tyler Hobbs ty...@datastax.com wrote: Brian, Are you referring to Pelops? The code you mentioned doesn't exist in Cassandra. On Thu, Mar 20, 2014 at

Re: this seems like a flaw in Node Selection

On Thu, Mar 20, 2014 at 1:17 PM, Brian Tarbox tar...@cabotresearch.comwrote: Yes, I was going to say (sorry for the brain-freeze) that this is behavior in Pelops not in C* itself. *OH* I presumed you were talking about the code in Cassandra that does the analogous thing.. :D Yes,

Re: Cassandra ring not behaving like a ring

Any pointers? I am planning to do rolling restart of the cluster nodes to see if it will help. On Jan 15, 2014 2:59 PM, Narendra Sharma narendra.sha...@gmail.com wrote: RF=3. On Jan 15, 2014 1:18 PM, Andrey Ilinykh ailin...@gmail.com wrote: what is the RF? What does nodetool ring show? On

Re: Cassandra ring not behaving like a ring

Please include the output of nodetool ring, otherwise no one can help you. On Thu, Jan 16, 2014 at 12:45 PM, Narendra Sharma narendra.sha...@gmail.com wrote: Any pointers? I am planning to do rolling restart of the cluster nodes to see if it will help. On Jan 15, 2014 2:59 PM, Narendra

Re: Cassandra ring not behaving like a ring

Hi, I am new to Cassandra Environment, does the order of the ring matter, as long as the member joins the group? Yogi On Thu, Jan 16, 2014 at 12:49 PM, Jonathan Haddad j...@jonhaddad.com wrote: Please include the output of nodetool ring, otherwise no one can help you. On Thu, Jan 16,

Re: Cassandra ring not behaving like a ring

It depends on a lot of factors. If you've got all your machines in a single rack, probably not. But if you want to spread your data across multiple racks or availability zones in AWS, it makes a huge difference. On Thu, Jan 16, 2014 at 2:05 PM, Yogi Nerella ynerella...@gmail.com wrote: Hi,

Re: Cassandra ring not behaving like a ring

Here is the nodetool ring output. Address DC RackStatus State Load Effective-Ownership Token 148873535527910577765226390751398592512 10.3.1.179 datacenter1 rack1 Up Normal 752.53 GB 37.50% 0 10.3.1.29 datacenter1 rack1

Cassandra ring not behaving like a ring

Sorry for the odd subject but something is wrong with our cassandra ring. We have a 9 node ring as below. N1 - UP/NORMAL N2 - UP/NORMAL N3 - UP/NORMAL N4 - UP/NORMAL N5 - UP/NORMAL N6 - UP/NORMAL N7 - UP/NORMAL N8 - UP/NORMAL N9 - UP/NORMAL Using random partitioner and simple snitch. Cassandra

Re: Cassandra ring not behaving like a ring

what is the RF? What does nodetool ring show? On Wed, Jan 15, 2014 at 1:03 PM, Narendra Sharma narendra.sha...@gmail.comwrote: Sorry for the odd subject but something is wrong with our cassandra ring. We have a 9 node ring as below. N1 - UP/NORMAL N2 - UP/NORMAL N3 - UP/NORMAL N4 -

Re: Cassandra ring not behaving like a ring

RF=3. On Jan 15, 2014 1:18 PM, Andrey Ilinykh ailin...@gmail.com wrote: what is the RF? What does nodetool ring show? On Wed, Jan 15, 2014 at 1:03 PM, Narendra Sharma narendra.sha...@gmail.com wrote: Sorry for the odd subject but something is wrong with our cassandra ring. We have a 9

Re: BigTable-like Versioned Cells, Importing PostgreSQL Data

b.com/1.html htmlhtmlC But CQL doesn't seem to support this. (Yes, I've read http://www.datastax.com/dev/blog/does-cql-support-dynamic-columns-wide-rows.) Once upon a time it seems Thrift and Supercolumns maybe would work? I would envision a schema something like this: CREATE

Re: BigTable-like Versioned Cells, Importing PostgreSQL Data

On Thu, Sep 19, 2013 at 9:13 PM, Keith Bogs keith.a.bo...@gmail.com wrote: I've been playing with Cassandra and have a few questions that I've been stuck on for awhile, and Googling around didn't seem to help much: 1. What's the quickest way to import a bunch of data from PostgreSQL? I have

BigTable-like Versioned Cells, Importing PostgreSQL Data

) in the database. Some have talked of having two CFs, one for versioned data and one for current values? I've been struggling because most of the documentation revolves around Java. I'm most comfortable with Ruby and (increasingly) Go. I'd appreciate any insights, would really like to get Cassandra

Re: How does a healthy node look like?

Confirm if your write timeouts are client side socket time outs or the TimedOutException from the server. Typically write latency is related to GC problems, like you are seeing. I'm unsure how much CPU resources each cassandra instance has. Is there one node on a machine with 6 cores ? How

RE: How does a healthy node look like?

delete all events that are older than 2 days. Again in batches of 100 rows. Thanks for helping! Ralf From: Alain RODRIGUEZ [arodr...@gmail.com] Sent: Thursday, May 02, 2013 09:12 To: user@cassandra.apache.org Subject: Re: How does a healthy node look like

Re: How does a healthy node look like?

should look like (CPU usage, number of flushes,SSTables, compactions, GC), given a certain hardware spec and read/write load. I have troubles gauging our first and only Cassandra node, whether it needs tuning or is simply overloaded. If anyone could point me to some data that would be very

How does a healthy node look like?

Hi, I have troubles finding some quantitative information as to how a healthy Cassandra node should look like (CPU usage, number of flushes,SSTables, compactions, GC), given a certain hardware spec and read/write load. I have troubles gauging our first and only Cassandra node, whether it needs

Using Cassandra for bittorrent-like decentralized storage application?

insertion, deletion, and updates is subject to a protocol that binds all nodes. Frequent searches and inserts, rare deletions and updates. Non-refutable timestamps. Would Cassandra lend itself to something like this? Cheers, Mihail

Re: How to limit query results like from row 50 to 100

CQL does not support offset but does have limit. See http://www.datastax.com/docs/1.2/cql_cli/cql/SELECT#specifying-rows-returned-using-limit Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 20/02/2013, at 1:47 PM,

How to limit query results like from row 50 to 100

With CQL or an API.

Re: Why my Cassandra is compacting like mad

I think I am seeing the same issue, but it doesn't seem to be related to the schema_columns. I understand that repair is supposed to be intensive, but this is bringing the associated machine to its knees, to the point that logging on the machine takes a very, very long time and requests are no

Re: Why my Cassandra is compacting like mad

Subject: Re: Why my Cassandra is compacting like mad I had a similar bug with 1.1.5 but I couldn't reproduce it so I didn't file a bug. I did a rolling restart of my nodes and things went back to normal. From: Manu Zhang owenzhang1...@gmail.com Reply-To: user@cassandra.apache.org user

Re: Why my Cassandra is compacting like mad

@cassandra.apache.orgmailto:user@cassandra.apache.org Date: Monday, October 15, 2012 8:02 AM To: user@cassandra.apache.orgmailto:user@cassandra.apache.org user@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Why my Cassandra is compacting like mad My Cassandra is compacting like mad

Re: Why my Cassandra is compacting like mad

: Manu Zhang owenzhang1...@gmail.com Reply-To: user@cassandra.apache.org user@cassandra.apache.org Date: Monday, October 15, 2012 8:02 AM To: user@cassandra.apache.org user@cassandra.apache.org Subject: Why my Cassandra is compacting like mad My Cassandra is compacting like mad (look

Re: Why my Cassandra is compacting like mad

Well I guess we will need some information to help you... At least: -Hardware ? -Version of Cassandra ? -Any specific action before restarting ? -cassandra.yaml (options about compaction) ? -... Alain 2012/10/15 Manu Zhang owenzhang1...@gmail.com My Cassandra is compacting like mad (look

Re: Why my Cassandra is compacting like mad

@cassandra.apache.org Date: Monday, October 15, 2012 8:11 AM To: user@cassandra.apache.orgmailto:user@cassandra.apache.org user@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Re: Why my Cassandra is compacting like mad I had a similar bug with 1.1.5 but I couldn't reproduce it so I didn't file a bug

Re: Why my Cassandra is compacting like mad

Date: Monday, October 15, 2012 8:11 AM To: user@cassandra.apache.org user@cassandra.apache.org Subject: Re: Why my Cassandra is compacting like mad I had a similar bug with 1.1.5 but I couldn't reproduce it so I didn't file a bug. I did a rolling restart of my nodes and things went back

Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra

that matches. I want to do similar kind of operation that LIKE operator in SQL do. Any help is highly appreciated. -- Abhijit Chanda Software Developer VeHere Interactive Pvt. Ltd. +91-974395 -- Abhijit Chanda Software Developer VeHere Interactive Pvt. Ltd. +91-974395

Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra

Chanda abhijit.chan...@gmail.com wrote: I don't know the exact value on a column, but I want to do a partial matching to know all available values that matches. I want to do similar kind of operation that LIKE operator in SQL do. Any help is highly appreciated. -- Abhijit Chanda Software

Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra

want to do similar kind of operation that LIKE operator in SQL do. Any help is highly appreciated. -- Abhijit Chanda Software Developer VeHere Interactive Pvt. Ltd. +91-974395 -- Abhijit Chanda Software Developer VeHere Interactive Pvt. Ltd. +91-974395 -- Saygılar

Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra

Do you still need the sample code? I use Hector, well here is an example: *This is the Column Family definition:* (I have a composite, but if you like you can have only the UTF8Type). CREATE COLUMN FAMILY title_indx with comparator = 'CompositeType(UTF8Type,UUIDType

Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra

, but if you like you can have only the UTF8Type). CREATE COLUMN FAMILY title_indx with comparator = 'CompositeType(UTF8Type,UUIDType)' and default_validation_class = 'UTF8Type' and key_validation_class = 'LongType'; *The Query:* SliceQueryLong, Composite, String query

Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra

, specially Tamar, thank you so much man. Regards, Abhijit On Tue, May 15, 2012 at 4:26 PM, Tamar Fraenkel ta...@tok-media.comwrote: Do you still need the sample code? I use Hector, well here is an example: *This is the Column Family definition:* (I have a composite, but if you like you can have

Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra

you still need the sample code? I use Hector, well here is an example: *This is the Column Family definition:* (I have a composite, but if you like you can have only the UTF8Type). CREATE COLUMN FAMILY title_indx with comparator = 'CompositeType(UTF8Type,UUIDType

Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra

don't know the exact value on a column, but I want to do a partial matching to know all available values that matches. I want to do similar kind of operation that LIKE operator in SQL do. Any help is highly appreciated. -- Abhijit Chanda Software Developer VeHere Interactive Pvt. Ltd. +91

Re: Any tools like phpMyAdmin to see data stored in Cassandra ?

If you want to try any others UI to browse your Cassandra data I can suggest you 2 : - https://github.com/sebgiroux/Cassandra-Cluster-Admin - http://code.google.com/p/cassui/ The first one is built to be a phpMyAdmin Like. Alain 2012/1/31 Brandon Williams dri...@gmail.com On Sun, Jan 29

  1   2   >