Re: Issues, understanding how CQL works

2020-04-24 Thread Marc Richter
a - comparatively - short list, from which finding the "highest" fromtime - integer is easy. Thanks for everyone who helped me! Best regards, Marc Richter On 22.04.20 17:57, Marc Richter wrote: Seems as if sstable2json is deprecated; see [1] and [2]. So, dsbulk [3] it is, I guess. I do

Re: Issues, understanding how CQL works

2020-04-22 Thread Marc Richter
e): https://pastebin.com/WpYvqxAA What are those lines supposed to tell me? Best regards, Marc Richter [1] https://docs.datastax.com/en/cassandra-oss/2.2/cassandra/tools/toolsSSTable2Json.html [2] https://issues.apache.org/jira/browse/CASSANDRA-9618 [3] https://downloads.datastax.c

Re: Issues, understanding how CQL works

2020-04-22 Thread Marc Richter
This sounds like a promising way; thank you for bringing this up! I will see if I can manage it with this approach. Best regards, Marc Richter On 22.04.20 15:38, Durity, Sean R wrote: I thought this might be a single-time use case request. I think my first approach would be to use

Re: Issues, understanding how CQL works

2020-04-22 Thread Marc Richter
tdate"? I really do not care if I need to do some expensive copy-all-data - move, but I do not know about what is possible and how to do that. Best regards, Marc Richter On 21.04.20 19:20, Jeff Jirsa wrote: On Tue, Apr 21, 2020 at 6:20 AM Marc Richter <mailto:m...@marc-richter.info>

Issues, understanding how CQL works

2020-04-21 Thread Marc Richter
le to craft that query. How can I achieve that in a reasonable way? As I said: The DB is round about 260 GB which makes it next to impossible to just "have a look" at the output of "SELECT *".. Thanks for your help! Best regards, Marc Richter - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org

Re: Unable to integrate jmx_prometheus_javaagent

2019-07-25 Thread Marc Richter
g complains about it could not find: "/etc/cassandra/prometheus/jmx_prometheus_javaagent-0.12.0.jar Note the leading double-quote here ... Removing the quotes makes it work like a charm. Sorry for bothering! BR, Marc On 25.07.19 18:02, Marc Richter wrote: Hi everyone, I have an exi

Unable to integrate jmx_prometheus_javaagent

2019-07-25 Thread Marc Richter
Hi everyone, I have an existing Cassandra node (3.7). Now, I'd like to be able to grab metrics from it for my Prometheus + Grafana based monitoring. I downloaded "jmx_prometheus_javaagent-0.12.0.jar" from [1], copied it to "/etc/cassandra/prometheus/jmx_prometheus_javaagent-0.12.0.jar". I als

Securing cluster communication

2019-06-28 Thread Marc Richter
Hi everyone, I'm completely new to Cassandra DB, so please do not roast me for asking obvious stuff. I managed to setup one Cassandra node and enter some data to it, successfully. Next, I installed a second node, which connects to that first one via port 7000 and sync all that data from it.