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

gt; > > > > > certainly people have written them > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > Jeff Jirsa > > > > > > > > > &g

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

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

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

m >>> >>> >>> -- >>> 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 >>>

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

he 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

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

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 suppose. > > Thanks! > > On Mon, Jul 2, 2018 at 6:24 PM, Justin Cameron > wrote: > >> yes, take a look at >&

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?

: 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?

ssandra.yaml. And I'm thinking of >> setting up a replication strategy so 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

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

o 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) wrote: > >> Any Cassandra Backup and Restore tool like Cassandra Reaper for Repairs? >> >> >> &

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

trategy so 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) wrote: > Any Cassandra Backup and Restore tool like Cassandra Reape

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 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 username from users wh

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 wrote: > I have this table > > CREATE TABLE users_by_username ( >

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

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 wrote: > I haven't seen anything like that myself. It would be nice to have > nodetool

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 wrote: > nodetool cfstats has some

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 Opera

Re: Having Counters in a Collection, like a map?

"they require knowing the key in advance in order to look up the counters" --> Wrong Imagine your table partition_key uuid, first_map map, second_map map With my proposed data model: SELECT first_map FROM table would translate to SELECT map_key, count FROM my_counters_map WHERE partition_key

Re: Having Counters in a Collection, like a map?

>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, i

Re: Having Counters in a Collection, like a map?

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 creating 1 table > per type

Re: Having Counters in a Collection, like a map?

"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 ((id), map_name

Re: Having Counters in a Collection, like a map?

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 MAP); InvalidRequest: Error from server: code=2200 [Invalid query] message="Counters are not allowed inside collect

Having Counters in a Collection, like a map?

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 and increment / d

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

urrent 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 ch

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 tha

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

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 &

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 wrote: > > To answer DuyHai's question without introducing new syntax, I'd suggest: >> LIKE '%%%escape'

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 n

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 beginnin

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?

gt; > 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#L733-L778 >

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 sim

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?

gt; 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) > > http

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

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 obs

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?

;false'}; I don't see any problem in the results you got SELECT * 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%%' --> Gi

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

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> S

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

'%asd'); INSERT into kmv (id, c1, c2) values (3, 'f22', 'asd%'); INSERT into kmv (id, c1, c2) values (4, 'f22', 'asd%1'); INSERT into kmv (id, c1, c2) values (5, 'f22', 'qweasd'); SELECT c2 from kmv.kmv where c2 like ‘_pattern_&#

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

gt; > 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's why I post question and

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

nt 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

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

ompactionMetrics 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 c

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

question is about the garbage 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 on

RE: howto do sql query like in a relational database

:54 PM To: user@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 wh

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

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

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

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. E

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 --

Re: Data modeling for Pinterest-like application

plicated to denormalize in your code. "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, everyt

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: Data modeling for Pinterest-like application

e 10-20 subsequent 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 applica

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

Re: this seems like a flaw in Node Selection

On Thu, Mar 20, 2014 at 1:17 PM, Brian Tarbox wrote: > 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, obviously don't disable the

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 wrote: > Brian, > > Are you referring to Pelops? The code you mentioned doesn't exist in > Cassandra. > > > On Thu, Mar 20, 2014 at 3:07 PM, Rober

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 wrote: > On Thu, Mar 20, 2014 at 1:03 PM, Brian Tarbox wrote: > >> Does this still apply since we're using 1.2.13? (should have said that >> in the original mes

Re: this seems like a flaw in Node Selection

On Thu, Mar 20, 2014 at 1:03 PM, Brian Tarbox wrote: > 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 is. =Rob

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 wrote: > On Thu, Mar 20, 2014 at 12:31 PM, Brian Tarbox > wrote: > >> I've seen this problem with other companies and products: leastloade

Re: this seems like a flaw in Node Selection

On Thu, Mar 20, 2014 at 12:31 PM, Brian Tarbox wrote: > I've seen this problem with other companies and products: leastloaded as a > means of picking servers is almost always liable to death spirals when a > server can have a failure. > > Is there any way to configure away from this in C*? > Dis

this seems like a flaw in Node Selection

I've noticed that one of my systems is getting hammered...and that more and more traffic is being sent to the system having trouble. Looking at LeastLoadedNodeSelector.java I can see why. LoadLoadedNodeSelector finds the node in the cluster that is least loaded but its calculation of least loaded

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

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 wrote: > Hi, > > I am new to Cassan

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 wrote: > Please include the output of "nodetool ring", otherwise no one can help > you. > > > On Thu, Jan 16, 2014 at 12:45 P

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 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 Sharma" > wrote: > >> RF

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" wrote: > RF=3. > On Jan 15, 2014 1:18 PM, "Andrey Ilinykh" wrote: > >> what is the RF? What does nodetool ring show? >> >> >> On Wed, Jan 15, 2014 at 1:03 PM,

Re: Cassandra ring not behaving like a ring

RF=3. On Jan 15, 2014 1:18 PM, "Andrey Ilinykh" 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 node ri

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 wrote: > 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/NORM

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 1.

Re: BigTable-like Versioned Cells, Importing PostgreSQL Data

"""B" > b.com/1.html """""C" > > 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

Re: BigTable-like Versioned Cells, Importing PostgreSQL Data

On Thu, Sep 19, 2013 at 9:13 PM, Keith Bogs 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 ~20M rows with most

BigTable-like Versioned Cells, Importing PostgreSQL Data

just a column slice). In the previous example, I'd want to return the latest 'body' entries with timestamps for every page ("row"/"key") in the database. Some have talked of having two CFs, one for versioned data and one for current values? I've been

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 ?

RE: How does a healthy node look like?

t in batches of 100 rows at a time. Deletes: Every night we 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.apac

Re: How does a healthy node look like?

ation 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 tuning > or is simply overloaded. > If anyon

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?

data 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, M

How to limit query results like "from row 50 to 100"

With CQL or an API.

Re: Why my Cassandra is compacting like mad

Bryan , Manu Can you contribute your experience to this ticket https://issues.apache.org/jira/browse/CASSANDRA-4781 ? If you have some steps to reproduce, or any information on schema changes you have made that would be useful. The ticket is against 1.2.0b1 - so please include

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

; From: Michael Kjellman >>> Reply-To: "user@cassandra.apache.org" >>> Date: Monday, October 15, 2012 8:11 AM >>> To: "user@cassandra.apache.org" >>> Subject: Re: Why my Cassandra is compacting like mad >>> >>> I had a similar bu

Re: Why my Cassandra is compacting like mad

Michael Kjellman >> Reply-To: "user@cassandra.apache.org" >> Date: Monday, October 15, 2012 8:11 AM >> To: "user@cassandra.apache.org" >> Subject: Re: Why my Cassandra is compacting like mad >> >> I had a similar bug with 1.1.5 but I coul

Re: Why my Cassandra is compacting like mad

ober 15, 2012 8:11 AM > To: "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 to > normal

Re: Why my Cassandra is compacting like mad

onday, October 15, 2012 8:11 AM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto: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 b

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 > My Cassandra is compacting like mad (look at the following messa

Re: Why my Cassandra is compacting like mad

gt; > From: Manu Zhang > Reply-To: "user@cassandra.apache.org" > Date: Monday, October 15, 2012 8:02 AM > To: "user@cassandra.apache.org" > Subject: Why my Cassandra is compacting like mad > > My Cassandra is compacting like mad (look at the following messages) af

Re: Why my Cassandra is compacting like mad

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

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

>> On Tue, May 15, 2012 at 4:26 PM, Tamar Fraenkel wrote: >> >>> 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). >&

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

you so much man. > > Regards, > Abhijit > > > On Tue, May 15, 2012 at 4:26 PM, Tamar Fraenkel wrote: > >> 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

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

Thanks so much Guys, specially Tamar, thank you so much man. Regards, Abhijit On Tue, May 15, 2012 at 4:26 PM, Tamar Fraenkel wrote: > 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

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)

  1   2   >