Questions tagged [cassandra-node-driver]
15 questions
7
votes
1 answer
Inserting timestamp into Cassandra
I have a table created as follows:
CREATE TABLE my_table (
date text,
id text,
time timestamp,
value text,
PRIMARY KEY (id));
CREATE INDEX recordings_date_ci ON recordings (date);
I'm able to simply add a new row to the table using the…
Lior Ohana
- 3,467
- 4
- 34
- 49
4
votes
1 answer
Node.js Streaming/Piping Error Handling (Change Response Status on Error)
I have millions of rows in my Cassandra db that I want to stream to the client in a zip file (don't want a potentially huge zip file in memory). I am using the stream() function from the Cassandra-Node driver, piping to a Transformer which extracts…
gcosta
- 55
- 5
3
votes
1 answer
Query Parameter Format for SELECT ... IN with Cassandra using Node.js Driver
I have a Cassandra SELECT query with an IN parameter that I want to run via the Node driver, but can't figure out the syntax.
On the cqlsh console, I can run this select and get a correct result:
SELECT * FROM sourcedata WHERE company_id = 4 AND…
Jason Champion
- 2,670
- 4
- 35
- 55
2
votes
1 answer
Checking health of all cassandra nodes
I am writing tests to check metadata information of cassandra keyspace and tables.
I also want to check which node is up or which is down in a cluster. how can I do it?
chetan dev
- 611
- 2
- 6
- 16
2
votes
2 answers
Cassandra query failure (Tombstones)
So this is driving me crazy. i tried querying one of my table in Cassandra and it showed query failure. i tried digging dip in to the reason behind it and found that it was because of tombstone. i changed GC_GRACE_SECONDS to Zero and triggered…
Dhaval P
- 53
- 1
- 2
- 11
1
vote
1 answer
Cassandra cluster works with 2 nodes?
I have 2 nodes with replication factor = 1, it means will have 1 set of data copy in each node.
Based on above description when i use murmur3partitioner,
Will data shared among nodes ? like 50% of data in node1 and 50% of data in node 2?
when i…
Sathish
- 69
- 8
1
vote
1 answer
Frame stream error when using medium-sized fetchSize in Cassandra node.js driver
I am having a weird issue with the Cassandra node.js driver. When I try to select data from certain partitions, I get this error.
Error: There was an problem while parsing streaming frame, opcode 8
at DriverInternalError.DriverError…
Kris Harper
- 5,672
- 8
- 51
- 96
1
vote
1 answer
cassandra lastupdated(auto_now), lastaccessed and created(auto_now_add)
Is there a way we can auto update the columns creation and last updated/accessed timestamp?
We can use toTimestamp(now()) function to store the creation time. But do we have a function like writetime(name), which is used to get the last modified…
saaia aiaas
- 51
- 1
- 6
1
vote
2 answers
Cassandra node.js driver does not accept dash separated string
I am using this driver as a bridge between cassandra and my node js app. Everything seems to work fine till now except following issue:
Issue
I have a column of type varchar, when i am inserting a string which has dash (-) in it then cassandra…
Gaurav Gupta
- 4,586
- 4
- 39
- 72
0
votes
0 answers
How do I paginate an update in Node Cassandra?
I cannot find a standard way to paginate my update in Cassandra using the Node connector. I cannot find any resource that would explain how to do it or whether it is possible at all.
My function looks like this:
async function…
papillon
- 1,807
- 2
- 19
- 39
0
votes
1 answer
Cassandra is not starting due to accessdeniedexception
I keep getting the following error when attempting to start Cassandra:
WARN [MemtableFlushWriter:1] 2019-09-23 20:52:14,452
LogReplicaSet.java:220 - Failed to add record to a replica:
java.nio.file.AccessDeniedException:
…
Siguy12
- 1
- 1
0
votes
1 answer
Bulk insert in not working in Casssandra with node.js
I am trying to insert more than 100 records using batch() method.
client.batch(batchQuery, { prepare: true }, function (err, result) {
if (err) {
res.status(404).json({ msg: err });
} else {
res.json([result.rows][0]);
…
Ajaypravin
- 27
- 1
- 10
0
votes
1 answer
dse-driver connection refused
I am trying to connect to my Datastax enterprise Cassandra install on a server. When I try to connect I receive an error:
Cassandra connection error { [Error: All host(s) tried for query failed. First host tried, XX.XX.XX.XX:9042: Error: connect…
Steven
- 19
- 1
0
votes
1 answer
Cassandra Node.js: Streaming all rows from a large table
I have a table in Cassandra which is actually not very large. Only 50k rows. I need to stream all the rows from this table and index them in Elasticsearch.
I wrote a simple script in Node.js using the following method:
var myStream =…
Mandeep Singh
- 7,674
- 19
- 62
- 104
0
votes
0 answers
Inserting boolean into Cassandra using the Nodejs driver does not work
I have set up a Cassandra 2.2 cluster of 3 nodes with replication factor of 2 and created a simple table:
CREATE TABLE store (
c_email text,
store_url text,
enabled boolean
PRIMARY KEY (c_email, store_url)
) WITH CLUSTERING ORDER BY…
Ivan Stoyanov
- 5,412
- 12
- 55
- 71