Re: Why does Cassandra recommends Oracle JVM instead of OpenJDK?

Back in the day, HotSpot was recommended because OpenJDK had some stability and performance issues. But in 2015 or maybe 2014 I heard in a presentation (don't remember by whom) that OpenJDK is pretty on par with HotSpot for C*. But I guess the documentation was never properly updated. On Tue, Jan

Re: Cassandra 2.x Stability

t; 2016-12-01 16:21 GMT+01:00 Jonathan Haddad : > >> I agree with everything you just said, Kai. I'd start a new project with >> 3.0.10. I'd stay away from MVs though. >> >> On Thu, Dec 1, 2016 at 10:19 AM Kai Wang wrote: >> >>> Just based on a

Re: Cassandra 2.x Stability

tp://twitter.com/liveperson> > <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections > > <https://engage.liveperson.com/idc-mobile-first-consumer/?utm_medium=email&utm_source=mkto&utm_campaign=idcsig> > > > On Thu, Dec 1, 2016 at 2:26 PM, Kai

Re: Cassandra 2.x Stability

I have been running 2.2.6 in production. As of today I would still pick it over 3.x for production. On Nov 30, 2016 5:42 AM, "Shalom Sagges" wrote: > Hi Everyone, > > I'm about to upgrade our 2.0.14 version to a newer 2.x version. > At first I thought of upgrading to 2.2.8, but I'm not sure how

full repair or incremental repair after scrub?

Hi, do I have to do a full repair after scrub? Is it enough to just do incremental repair? BTW I do nightly incremental repair.

Re: Storing videos in cassandra

IIRC, I watched a presentation where they said Netflix store almost everything in C* *except* video content and payment stuff. That was 1-2 years ago. Not sure if it's still the case. On Nov 14, 2016 12:03 PM, "raghavendra vutti" wrote: > Hi, > > Just wanted to know How does hulu or netflix st

Re: Introducing Cassandra 3.7 LTS

This is awesome! Stability is the king. Thank you so much! On Oct 19, 2016 2:56 PM, "Ben Bromhead" wrote: > Hi All > > I am proud to announce we are making available our production build of > Cassandra 3.7 that we run at Instaclustr (both for ourselves and our > customers). Our release of Cassa

Re: Corrupt SSTABLE over and over

This might not be good news to you. But my experience is that C* 2.X/Windows is not ready for production yet. I've seen various file system related errors. And in one of the JIRAs I was told major work (or rework) is done in 3.X to improve C* stability on Windows. On Tue, Aug 16, 2016 at 3:44 AM,

Re: sstableloader

yes, you are correct. On Tue, Aug 16, 2016 at 2:37 PM, Jean Tremblay < jean.tremb...@zen-innovations.com> wrote: > Hi, > > I’m using Cassandra 3.7. > > In the documentation for sstableloader I read the following: > > << Note: To get the best throughput from SSTable loading, you can use > multiple

Re: Cassandra monitoring

I use graphite/jmxtrans/collectd to monitor not just Cassandra but also other jvm applications as well as OS. I found it's more useful and flexible than opscenter in terms of monitoring. On Jun 14, 2016 3:10 PM, "Arun Ramakrishnan" wrote: What are the options for a very small and nimble startup t

Re: how long does "nodetool upgradesstables" take?

2.2 uses –la, and so on. You should see > files with –la in the name on 2.2.4 and 2.2.6. > > If a new format was added to 2.2, it would likely be –lb ( -l for 2.2, b > for the second format ), and it would be documented at > https://github.com/apache/cassandra/blob/cassandra-2.2/NEWS.

how long does "nodetool upgradesstables" take?

I just upgrade C* from 2.2.4 to 2.2.6. I ran "nodetool upgradesstables" and it returned within a few seconds. Does this sound right? A few questions: 1. is it possible that sstable formats are the same between those versions that's why upgradesstables took almost no time? 2. is there a way to conf

Re: Out of memory issues

Paolo, try a few things in cassandra-env.sh 1. HEAP_NEWSIZE="2G". "The 100mb/core commentary in cassandra-env.sh for setting HEAP_NEWSIZE is *wrong*" ( https://tobert.github.io/pages/als-cassandra-21-tuning-guide.html) 2. MaxTenuringThreshold=8 3. enable GC logging (under "# GC logging options --

Re: Setting bloom_filter_fp_chance < 0.01

with 50 bln rows and bloom_filter_fp_chance = 0.01, bloom filter will consume a lot of off heap memory. You may want to take that into consideration too. On Wed, May 18, 2016 at 11:53 PM, Adarsh Kumar wrote: > Hi Sai, > > We have a use case where we are designing a table that is going to have >

Re: Bloom filter memory usage disparity

e > for the 3 nodes to understand. > > It might have been a temporary situation, but in this case you would know > by now. > > C*heers, > > > 2016-05-03 18:47 GMT+02:00 Kai Wang : > >> Hi, >> >> I have a table on 3-node cluster. I notice bloom filter me

Bloom filter memory usage disparity

Hi, I have a table on 3-node cluster. I notice bloom filter memory usage are very different on one of the node. For a given table, I checked CassandraMetricsRegistry$JmxGauge.[table]_BloomFilterOffHeapMemoryUsed.Value. 2 of 3 nodes show 1.5GB while the other shows 2.5 GB. What could be the reason

Re: Cassandra table limitation

ants and how much control the >> cluster administrator has over them. >> >> Think of a Cassandra cluster as managing the data for either a single >> application or a collection of applications which share the same data. If >> there are multiple applications that don't sha

Re: Cassandra table limitation

Once a while the question about table count rises in this list. The most recent is https://groups.google.com/forum/#!topic/nosql-databases/IblAhiLUXdk In short C* is not designed to scale with the table count. For one each table/CF has some fixed memory footprint on *ALL* nodes. The consensus is y

Re: Inconsistent query results and node state

Do you have NTP setup on all nodes? On Tue, Mar 29, 2016 at 11:48 PM, Jason Kania wrote: > We have encountered a query inconsistency problem wherein the following > query returns different results sporadically with invalid values for a > timestamp field looking like the field is uninitialized (a

Re: Acceptable repair time

IIRC when we switched to LCS and ran the first full repair with 250GB/RF=3, it took at least 12 hours for the repair to finish, then another 3+ days for all the compaction to catch up. I called it "the big bang of LCS". Since then we've been running nightly incremental repair. For me as long as i

Re: Query regarding CassandraJavaRDD while running spark job on cassandra

I suggest you post this to spark-cassandra-connector list. On Sat, Mar 12, 2016 at 12:52 AM, Siddharth Verma < verma.siddha...@snapdeal.com> wrote: > In cassandra I have a table with the following schema. > > CREATE TABLE my_keyspace.my_table1 ( > col_1 text, > col_2 text, > col_3 tex

Re: Rows with same key

Are you supplying timestamps from the client side? Are clocks in sync cross your nodes? On Thu, Feb 11, 2016 at 11:52 AM, Yulian Oifa wrote: > Hello to all > I have multiple rows with same id on one of cfs, one row is completely > empty ,another one has vaues. > Values are wrotten into new row

Re: 3k sstables during a repair incremental !!

Jean, What does your cfstats look like? Especially "SSTables in each level" line. On Wed, Feb 10, 2016 at 8:33 AM, Jean Carlo wrote: > Hello guys! > > I am testing the repair inc in my custer cassandra. I am doing my test > over these tables > > *CREATE TABLE pns_nonreg_bench.cf3* ( > s tex

Re: Latest stable release

If you have to go to 3.x. Use 3.[odd number]. On Mon, Feb 8, 2016 at 4:34 PM, Ravi Krishna wrote: > We are starting a new project in Cassandra. Is 3.2 stable enough to be > used in production. If not, which is the most stable version in 2.x. > > thanks. >

Re: missing rows while importing data using sstable loader

Arindam, what's the table schema and what does your query to retrieve the rows look like? On Fri, Jan 29, 2016 at 7:33 AM, Arindam Choudhury < arindam.choudh...@ackstorm.com> wrote: > Hi, > > I am importing data to a new cassandra cluster using sstableloader. The > sstableloader runs without any

Re: Detailed info on how inter dc rep works

John, There was a thread last month about this topic. https://mail-archives.apache.org/mod_mbox/incubator-cassandra-user/201512.mbox/%3CCABWW=xw9obk+w-4efpymnpo_fy8dbilbgv2fk-9xre7ydy2...@mail.gmail.com%3E On Thu, Jan 28, 2016 at 7:51 PM, John Lonergan wrote: > If I have a single client publ

Re: Cassandra 2015 Summit videos

Check out https://vimeopro.com/user35188327/cassandra-summit-2015. Although this list is about Cassandra not Datastax. I still want to comment a little bit about 2015 summit videos. I prefer this format: https://www.youtube.com/user/PlanetCassandra/playlists but I don't know why datastax stops doi

Re: compaction throughput

ig-email&utm_content=webmail> >>> This >>> email has been sent from a virus-free computer protected by Avast. >>> www.avast.com >>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=

Re: In UJ status for over a week trying to rejoin cluster in Cassandra 3.0.1

Carlos, so you essentially replace the 33 node. Did you follow this https://docs.datastax.com/en/cassandra/2.0/cassandra/operations/ops_replace_node_t.html? The link is for 2.x not sure about 3.x. What if you change the new node to .34? On Mon, Jan 11, 2016 at 12:57 AM, Carlos A wrote: > Hell

Re: New node has high network and disk usage.

it >> integrates with your existing marketing technology to provide detailed >> customer interest profiles in real-time across all channels, and to >> personalize content into every channel for every customer. See >> http://idioplatform.com >> <https://t.yesware.com/tl

Re: endless full gc on one node

-stop full GC. The > other two nodes were totally fine" > > Just a guest, how did you insert data ? Did you use Batch statements ? > > On Sat, Jan 16, 2016 at 10:12 PM, Kai Wang wrote: > >> Hi, >> >> Recently I saw some strange behavior on one of the nodes of

endless full gc on one node

Hi, Recently I saw some strange behavior on one of the nodes of a 3-node cluster. A while ago I created a table and put some data (about 150M) in it for testing. A few days ago I started to import full data into that table using normal cql INSERT statements. As soon as inserting started, one node

Re: compaction throughput

tatistics? > > all the best, > > Sebastián > On Jan 15, 2016 6:18 PM, "Kai Wang" wrote: > >> Jeff & Sebastian, >> >> Thanks for the reply. There are 12 cores but in my case C* only uses one >> core most of the time. *nodetool compactionstats* shows t

Re: compaction throughput

nd when to block on one core. Then there's not much we can do here. Thanks. On Fri, Jan 15, 2016 at 5:23 PM, Jeff Jirsa wrote: > With SSDs, the typical recommendation is up to 0.8-1 compactor per core > (depending on other load). How many CPU cores do you have? > >

Re: compaction throughput

I forget to mention I am using C* 2.2.4 On Jan 15, 2016 3:53 PM, "Kai Wang" wrote: > Hi, > > I am trying to figure out the bottleneck of compaction on my node. The > node is CentOS 7 and has SSDs installed. The table is configured to use > LCS. Here is my comp

compaction throughput

Hi, I am trying to figure out the bottleneck of compaction on my node. The node is CentOS 7 and has SSDs installed. The table is configured to use LCS. Here is my compaction related configs in cassandra.yaml: compaction_throughput_mb_per_sec: 160 concurrent_compactors: 4 I insert about 10G of da

Re: New node has high network and disk usage.

See > http://idioplatform.com > <https://t.yesware.com/tl/0e637e4938676b6f3897def79d0810a71e59612e/10068de2036c2daf922e0a879bb2fe92/9dae8be0f7693bf2b28a88cc4b38c554?ytl=http%3A%2F%2Fidioplatform.com%2F> > for > more information. > > On 14 January 2016 at 14:22, Kai Wang wrote: > >> J

Re: New node has high network and disk usage.

James, Can you post the result of "nodetool netstats" on the bad node? On Thu, Jan 14, 2016 at 9:09 AM, James Griffin < james.grif...@idioplatform.com> wrote: > A summary of what we've done this morning: > >- Noted that there are no GCInspector lines in system.log on bad node >(there are

Re: [Off heap memory used (total)] in cfstats

to the actual data size. On Fri, Jan 8, 2016 at 6:39 PM, Kai Wang wrote: > Hi, > > When I switch a big table from STCS to LCS, I notice high off heap memory > usage using nodetool cfstats. "*Off heap memory used (total)*" shows +10G > usage. > > Eventually my n

[Off heap memory used (total)] in cfstats

Hi, When I switch a big table from STCS to LCS, I notice high off heap memory usage using nodetool cfstats. "*Off heap memory used (total)*" shows +10G usage. Eventually my nodes died because of OOM. How do I throttle off heap usage? The only thing I see in cassandra.yaml is *memtable_offheap_spa

confusion about migrating to incremental repair

Hi, I am running a cluster with 2.2.4. I have some table on LCS and plan to use incremental repair. I read the post at http://www.datastax.com/dev/blog/anticompaction-in-cassandra-2-1 and am a little confused. especially: "This means that *once you do an incremental repair you will have to contin

Re: unable to create a user on version 2.2.4

http://www.datastax.com/dev/blog/role-based-access-control-in-cassandra On Jan 2, 2016 4:13 AM, "david" wrote: > Sam Tunnicliffe beobal.com> writes: > > > > > > > If you've upgraded to 2.2.4, the full instructions necessary for > auth-enabled clusters were > unfortunately missing from NEWS.txt.

Re: Is CQLSSTableWriter tied to C* version?

27;t > think the format changed between these 2 versions, but I'm typing this on > my phone and can't verify. > > On Tue, Dec 22, 2015 at 6:36 PM Kai Wang wrote: > >> Hi, >> >> Can sstables created by CQLSSTableWriter in cassandra-all.jar 2.1.12 be >> loaded into C* 2.2.4? Or they have to be on the same version? >> >

Is CQLSSTableWriter tied to C* version?

Hi, Can sstables created by CQLSSTableWriter in cassandra-all.jar 2.1.12 be loaded into C* 2.2.4? Or they have to be on the same version?

Re: can't make any permissions change in 2.2.4

gt; >> system_auth.credentials >> system_auth.users >> system_auth.permissions >> >> Now I seem to be able to use RBAC to modify permissions. >> >> On Fri, Dec 18, 2015 at 9:23 AM, Kai Wang wrote: >> >>> Sylvain, >>> >&

Re: [Marketing Mail] Re: [Marketing Mail] can't make any permissions change in 2.2.4

. On Fri, Dec 18, 2015 at 9:23 AM, Kai Wang wrote: > Sylvain, > > Thank you very much. > > On Fri, Dec 18, 2015 at 9:20 AM, Sylvain Lebresne > wrote: > >> On Fri, Dec 18, 2015 at 3:04 PM, Kai Wang wrote: >> >>> Reynald, >>> >>> Than

Re: OpsCenter support Cassandra 3.0.x

"*Note: Future versions of OpsCenter will support Cassandra versions 2.2 and 3.0.*" http://docs.datastax.com/en/upgrade/doc/upgrade/opscenter/opscCompatibility.html On Fri, Dec 18, 2015 at 8:16 AM, Cassandramail wrote: > Hello, > > Do you know any plan to support Cassandra 3.0.x in OpsCenter by

Re: [Marketing Mail] Re: [Marketing Mail] can't make any permissions change in 2.2.4

Sylvain, Thank you very much. On Fri, Dec 18, 2015 at 9:20 AM, Sylvain Lebresne wrote: > On Fri, Dec 18, 2015 at 3:04 PM, Kai Wang wrote: > >> Reynald, >> >> Thanks for link. That explains it. >> >> Sylvain, >> >> What exactly are the &quo

Re: [Marketing Mail] Re: [Marketing Mail] can't make any permissions change in 2.2.4

Reynald, Thanks for link. That explains it. Sylvain, What exactly are the "legacy tables" I am supposed to drop? Before I drop them, is there any way I can confirm the old schema has been converted to the new one successfully? Thanks. On Fri, Dec 18, 2015 at 5:05 AM, Reynald Bourtembourg < re

can't make any permissions change in 2.2.4

I used to able to add/drop users and modify permissions in 2.1.1. After upgrading to 2.2.4, I can't modify any of those. "List all permissions" returns me all the permissions I setup before the upgrade. But I can't add new permission or add new users in cqlsh. "create user" and "grant" didn't repor

Re: Replicating Data Between Separate Data Centres

Philip, I don't see the benefit to have a multi-DC C* cluster in this case. What you need is two separate C* clusters and use Kafka record/replay writes to DR. DR only receives writes from Kafka consumer. You won't need to deal with "Removing everything from Cassandra that -isn't- in Kafka". On M

Re: [RELEASE] Apache Cassandra 3.1 released

x27;re targeting changes to CI and quality > focus going forward to greatly increase the stability of the odd releases > of major branches (3.1, 3.3, etc) so, for the 4.X releases, our > recommendation would be to run the highest # odd release for greatest > stability. > > Hope that h

Re: [RELEASE] Apache Cassandra 3.1 released

Paulo, Thank you for the examples. So if I go to download page and see 3.0.1, 3.1 and 3.2. The most stable version will be 3.1 because it includes the critical fixes in 3.0.1 and some additional bug fixes while doesn't have any new features introduced in 3.2. In that sense 3.0.1 becomes obsolete

Re: [RELEASE] Apache Cassandra 3.1 released

Janne, You are not alone. I am also confused by that "Under normal conditions ..." statement. I can really use some examples such as: 3.0.0 = ? 3.0.1 = ? 3.1.0 = ? 3.1.1 = ? (this should not happen under normal conditions because the fix should be in 3.3.0 - the next bug fix release?) On Wed, Dec

Re: lots of tombstone after compaction

ns of cassandra that will multiple tombstones during > compaction. 2.1.12 SHOULD correct that, if you’re on 2.1. > > > > From: Kai Wang > Reply-To: "user@cassandra.apache.org" > Date: Monday, December 7, 2015 at 3:46 PM > To: "user@cassandra.apache.org"

Re: Cassandra compaction stuck? Should I disable?

Thank you for the investigation. On Dec 2, 2015 5:21 AM, "PenguinWhispererThe ." < th3penguinwhispe...@gmail.com> wrote: > So it seems I found the problem. > > The node opening a stream is waiting for the other node to respond but > that node never responds due to a broken pipe which makes Cassand

lots of tombstone after compaction

I bulkloaded a few tables using CQLSStableWrite/sstableloader. The data are large amount of wide rows with lots of null's. It takes one day or two for the compaction to complete. sstable count is at single digit. Maximum partition size is ~50M and mean size is ~5M. However I am seeing frequent read

SELECT some_column vs SELECT *

Hi all, If I have the following table: CREATE TABLE t ( pk int, ck int, c1 int, c2 int, ... PRIMARY KEY (pk, ck) ) There are lots of non-clustering columns (1000+). From time to time I need to do a query like this: SELECT c1 FROM t WHERE pk = abc AND ck > xyz; How efficient is this

Re: too many full gc in one node of the cluster

What's the size of young generation (-Xmn) ? On Fri, Nov 13, 2015 at 6:38 AM, Jason Wee wrote: > Used to manage/develop for cassandra 1.0.8 for quite sometime. Although > 1.0 was rocking stable but we encountered various problems as load per node > grow beyond 500gb. upgrading is one of the solu

Re: How to organize a timeseries by device?

) for the table of the events_by_time using a timestamp or > a string? > > On Mon, Nov 9, 2015 at 5:05 PM, Kai Wang wrote: > >> it depends on the size of each event. You want to bound each partition >> under ~10MB. In system.log look for entry like: >> >

Re: How to organize a timeseries by device?

ucket), timestamp) ? >>> >>> On 2., what are the risks of timeout ? I currently have this warning: >>> "Cannot execute this query as it might involve data filtering and thus may >>> have unpredictable performance. If you want to execute this query despite >

Re: How to organize a timeseries by device?

1. Don't make your partition unbound. It's tempting to just use (device_id, timestamp). But soon or later you will have problem when time goes by. You can keep the partition bound by using (device_id, bucket, timestamp). Use hour, day, month or even year like Jack mentioned depending on the size of

Re: Can't save Opscenter Dashboard

ashboard again. On Thu, Nov 5, 2015 at 10:02 AM, Kai Wang wrote: > It happens again after I reboot another node. This time I see errors in > agent.log. It seems to be related to the previous dead node. > > INFO [clojure-agent-send-off-pool-2] 2015-11-05 09:48:41,602 Attempting >

Re: Can't save Opscenter Dashboard

ll -9 `cat /var/run/datastax-agent/datastax-agent.pid` && \ > > sudo rm -rf /var/lib/datastax-agent && \ > > sudo rm -rf /usr/share/datastax-agent > > -- > qihuang.zheng > > 原始邮件 > *发件人:* Kai Wang > *收件人:* user > *发送时间:* 2015年11

Re: Can't save Opscenter Dashboard

, 2015 at 5:36 PM, Kai Wang wrote: > Reinstalling OpsCenter didn't fix it. Previously I thought the graphs were > updated but actually they were just stalled. I need to refresh and re-add > the graph to see the new metrics. Other information such as activities and > Nodes are upda

Re: Can't save Opscenter Dashboard

Reinstalling OpsCenter didn't fix it. Previously I thought the graphs were updated but actually they were just stalled. I need to refresh and re-add the graph to see the new metrics. Other information such as activities and Nodes are updating fine. On Wed, Nov 4, 2015 at 3:58 PM, Kai Wang

Re: Can't save Opscenter Dashboard

ted database technology, > delivering Apache Cassandra to the world’s most innovative enterprises. > Datastax is built to be agile, always-on, and predictably scalable to any > size. With more than 500 customers in 45 countries, DataStax is the > database technology and transactional backbo

Re: Can't save Opscenter Dashboard

gy, > delivering Apache Cassandra to the world’s most innovative enterprises. > Datastax is built to be agile, always-on, and predictably scalable to any > size. With more than 500 customers in 45 countries, DataStax is the > database technology and transactional backbone of choice

Re: Can't save Opscenter Dashboard

Forgot to mention. I am running OpsCenter 5.2.2. On Wed, Nov 4, 2015 at 3:39 PM, Kai Wang wrote: > Hi, > > Today after one of the nodes is rebooted, OpsCenter dashboard doesn't save > anymore. It starts with an empty dashboard with no widget or graph. If I > add some gr

Can't save Opscenter Dashboard

Hi, Today after one of the nodes is rebooted, OpsCenter dashboard doesn't save anymore. It starts with an empty dashboard with no widget or graph. If I add some graph/widget, they are being updated fine. But if I refresh the browser, the dashboard became empty again. Also there's no "DEFAULT" tab

Re: Cassandra Data Model with Narrow partition

agree with Carlos, you should bucket your key, for example, into (pk, day, hour). Otherwise your partition is going to be large enough to cause problems. On Fri, Oct 30, 2015 at 8:04 AM, Carlos Alonso wrote: > Hi Chandra, > > Narrow partition is probably your best choice, but you need to bucket

Re: Error Code

https://github.com/datastax/python-driver/blob/75ddc514617304797626cc69957eb6008695be1e/cassandra/connection.py#L573 Is your error message complete? On Thu, Oct 29, 2015 at 9:45 AM, Eduardo Alfaia wrote: > Hi Guys, > > Does anyone know what error code in cassandra is? > > Error decoding respons

Re: Oracle TIMESTAMP(9) equivalent in Cassandra

If you want the timestamp to be generated on the C* side, you need to sync clocks among nodes to the nanosecond precision first. That alone might be hard or impossible already. I think the safe bet is to generate the timestamp on the client side. But depending on your data volume, if data comes fro

Re: Need company to support Cassandra on Windows

I would start with DataStax. In this year's summit keynote Jonathan Ellis said C* would start receiving production level support on Windows. On Tue, Oct 27, 2015 at 9:58 AM, Troy Collinsworth < troycollinswo...@gmail.com> wrote: > Searching for a well established company that can provide consulti

Re: how to grant permissions to OpsCenter keyspace?

Thanks Adam. On Mon, Oct 26, 2015 at 5:30 PM, Adam Holmberg wrote: > You need to quote the "OpsCenter" identifier to distinguish capital > letters: > https://cassandra.apache.org/doc/cql3/CQL.html#identifiers > > Adam > > On Mon, Oct 26, 2015 at 4:25 PM, Kai

how to grant permissions to OpsCenter keyspace?

Hi, My understanding is that if I want to enable internal authentication and authorization on C* while still keeping OpsCenter working, I should grant all to OpsCenter space and describe/select on everything else. But when I try to grant permissions to or even switch into OpsCenter, cqlsh reports

Re: timestamp as clustering key doesn't work as expected

https://issues.apache.org/jira/browse/CASSANDRA-10583 On Fri, Oct 23, 2015 at 1:26 PM, Kai Wang wrote: > Jon, > > It's 2.1.10. I will see if I can reproduce it with a simple script. > > Thanks. > > On Fri, Oct 23, 2015 at 1:05 PM, Jon Haddad wrote: > >>

Re: timestamp as clustering key doesn't work as expected

RA. > https://issues.apache.org/jira > > > > > On Oct 23, 2015, at 8:55 AM, Kai Wang wrote: > > > > Hi, > > > > I use a timestamp column as the last clustering key so that I can run > query like "timestamp > ... AND timestamp < ...". But it do

timestamp as clustering key doesn't work as expected

Hi, I use a timestamp column as the last clustering key so that I can run query like "timestamp > ... AND timestamp < ...". But it doesn't work as expected. Here is a simplified example. My table: CREATE TABLE test ( tag text, group int, timestamp timestamp, value double, PRIM

Re: C* 2.1.10 failed to start

I fixed this by deleting everything in system\compactions_in_progress- I wonder if there's any side effects by doing this. On Mon, Oct 19, 2015 at 8:56 AM, Kai Wang wrote: > It seems the same as https://issues.apache.org/jira/browse/CASSANDRA-8544. > It started to happen after

C* 2.1.10 failed to start

It seems the same as https://issues.apache.org/jira/browse/CASSANDRA-8544. It started to happen after bulkloading ~100G data and restarting. Windows 2008 R2, JVM 1.8.0_60. It feels like C* didn't shutdown cleanly. Is there any way to workaround this? Thanks.

OpsCenter issue with DCE 2.1.9

Hi, OpsCenter/Agent works sporadically for me. I am testing with DCE 2.1.9 on Win7 x64. I seem to narrow it down to the following log messages. When it works: INFO [Initialization] 2015-10-01 08:49:02,016 New JMX connection ( 127.0.0.1:7199) ERROR [Initialization] 2015-10-01 08:49:02,344 Error

Re: Timeout error in fetching million rows as results using clustering keys

With your reading path and data model, it doesn't matter how many nodes you have. All data with the same image_caseid is physically located on one node (Well, on RF nodes but only one of those will try to server your query). You are not taking advantage of Cassandra by creating hot spots on both re

Re: Downgrade Cassandra from 2.1.x to 2.0.x

AFAIK downgrading is not officially supported. how much data do you have? If all possible I would dump all my data out and bulk load them into the 2.0.x cluster. This is the only way I feel safe. On Mar 6, 2015 5:55 AM, "Roni Balthazar" wrote: > Hi there, > > What is the best way to downgrade a

Re: Composite Keys in cassandra 1.2

reate some index that will allow me to read data > based on any part. Creating index for each group of fields of course is not > an option since number of indexes will be huge , and disk usage will be too > big. > > Best regards > Yulian Oifa > > On Mon, Mar 2, 2015 at 5:33 PM,

Re: Composite Keys in cassandra 1.2

AFIK it's not possible. The fact you need to query the data by partial row key indicates your data model isn't proper. What are your typical queries on the data? On Sun, Mar 1, 2015 at 7:24 AM, Yulian Oifa wrote: > Hello to all. > Lets assume a scenario where key is compound type with 3 types in

Re: run cassandra on a small instance

One welcome change is http://cassandra.apache.org/ actually starts displaying: "Latest release *2.1.3* (Changes ), Stable release *2.0.12* (Changes

Re: Data tiered compaction and data model question

What's the typical size of the data field? Unless it's very large, I don't think table 2 is a "very" wide row (10x20x60x24=288000 events/partition at worst). Plus you only need to store 30 days of data. The over data size is 288000x30=8,640,000 events. I am not even sure if you need C* depending on

Re: How to connect to Opscenter from outside the cloud?

You can start from here: http://www.datastax.com/docs/1.1/references/firewall_ref By default ops site is hosted at port . On Tue, Feb 17, 2015 at 12:38 PM, Syed, Basit B. (NSN - FI/Espoo) < basit.b.s...@nsn.com> wrote: > Hi, > I have a two node cluster running on openstack cloud. One of th

Re: Upgrading from 1.2 to 2.1 questions

I would not use 2.1.2 for production yet. It doesn't seem stable enough based on the feedbacks I see here. The newest 2.0.12 may be a better option. On Feb 2, 2015 8:43 AM, "Sibbald, Charles" wrote: > Hi Oleg, > > What is the minor version of 1.2? I am looking to do the same for 1.2.14 > in a ver

Re: Is there a way to add a new node to a cluster but not sync old data?

In last year's summit there was a presentation from Instaclustr - https://www.instaclustr.com/meetups/presentation-by-ben-bromhead-at-cassandra-summit-2014-san-francisco/. It could be the solution you are looking for. However I don't see the code being checked in or JIRA being created. So for now y

Re: Versioning in cassandra while indexing ?

depending on your data model, static column night be useful. https://issues.apache.org/jira/plugins/servlet/mobile#issue/CASSANDRA-6561 On Jan 21, 2015 2:56 AM, "Pandian R" wrote: > Hi, > > I just wanted to know if there is any kind of versioning system in > cassandra while indexing new data(like

Re: CQL3 vs Thrift

Ryan, Can you elaborate a little on "Thrift over CQL is modeling clustering columns in different nesting between rows is trivial in Thrift and not really doable in CQL"? On Dec 24, 2014 8:30 AM, "Ryan Svihla" wrote: > I'm not entirely certain how you can't model that to solve your use case > (wo

Re: Connect to C* instance inside virtualbox

n Mon, Dec 22, 2014 at 8:15 PM, Ryan Svihla wrote: > >> right that's localhost, you have to change it to match the ip of whatever >> you changed rpc_address too >> >> On Mon, Dec 22, 2014 at 8:07 PM, Kai Wang wrote: >> >>> on the guest wher

Re: Connect to C* instance inside virtualbox

assuming you're connecting to an IP that makes sense on the guest (ie > nodetool -h 192.168.1.100 and cqlsh 192.168.1.100, replace that ip with > whatever what you expect)? > > On Mon, Dec 22, 2014 at 7:58 PM, Kai Wang wrote: > >> Ryan, >> >> Actually after I made th

Re: Connect to C* instance inside virtualbox

Ryan, Actually after I made the change, I was able to connect to C* from host but not from guest anymore. Is this expected? On Mon, Dec 22, 2014 at 8:53 PM, Kai Wang wrote: > Ryan, > > it works! I saw this new config mentioned in Cassandra summit 2014 but > didn't realize it a

Re: Connect to C* instance inside virtualbox

ommunicates between host and guest. > > On Mon, Dec 22, 2014 at 3:38 PM, Kai Wang wrote: > >> I installed C* in virtualbox via vagrant. Both 9160 and 9042 ports are >> forwarded from guest to host. I can telnet to those two ports from host to >> guest. But from my host, I can&

Connect to C* instance inside virtualbox

I installed C* in virtualbox via vagrant. Both 9160 and 9042 ports are forwarded from guest to host. I can telnet to those two ports from host to guest. But from my host, I can't connect to C* using cassandra-cli or cqlsh. My host is Windows 7 64bit and guest is CentOS 6.5. Is there anything speci

Re: Replacing nodes disks

do you have to replace those disks? can you simply add new disks to those nodes and configure C* to use JBOD? On Dec 18, 2014 10:18 AM, "Or Sher" wrote: > Hi all, > > We have a situation where some of our nodes have smaller disks and we > would like to align all nodes by replacing the smaller dis

Re: How to model data to achieve specific data locality

g able to tune locality may be worth it. > > > On Sun Dec 07 2014 at 3:12:11 PM Jonathan Haddad > wrote: > >> I think he mentioned 100MB as the max size - planning for 1mb might make >> your data model difficult to work. >> >> On Sun Dec 07 2014 at 12:07:47 P

  1   2   >