Questions tagged [datastax-astra]

DataStax Astra is a serverless, multi-cloud database service built on Apache Cassandra.

DataStax Astra is a serverless, multi-cloud database service built on Apache Cassandra. The service allows users to deploy a scalable Cassandra cluster across multiple cloud providers.

About: https://www.datastax.com/products/datastax-astra

Main: https://astra.datastax.com

For information on how to develop and integrate with many 3rd party tools, be sure to check out: https://awesome-astra.github.io/docs/

109 questions
1
vote
0 answers

Efficient way to reduce transferred data when working with sensors data on the server?

I have a system where a sensor (owned by someone) sends the data about the outside temperature to my server (Spring Boot), then my server saves the data into Cassandra database (hosting at DataStax Astra). Now I want to implement an algorithm…
Captain Jacky
  • 888
  • 1
  • 12
  • 26
1
vote
2 answers

How do I write a CQL query for "nodetool status" on Astra DB?

I am using Astradb and want to know specific information about my database and I am unable to write a nodetool status query in astradb I tried running noodtool status query in CQL of astraDB but it is showing "no viable alternative at input…
1
vote
1 answer

Unable to create keyspace with the Python driver, getting Unauthorized error "Missing correct permission"

I am trying to create a keyspace on my `Astra' instance but I have gotten this error while trying the execute the CREATE statement: --------------------------------------------------------------------------- Unauthorized …
Ryan
  • 356
  • 1
  • 6
  • 26
1
vote
2 answers

Can't connect DataStax AstraDB with Django app on Google Cloud

I am trying to connect AstraDB with my application served by gcloud AppEngine. I am using Django and therefore have used django_cassandra_engine. I want to keep Postgres as my default DB and use cassandra as a second DB. Everything works as expected…
1
vote
2 answers

Need more than 200 Cassandra tables per keyspace

Hi I am new to Cassandra and using DataStax Astra DB on AWS. Problem I am facing is for each table we have different where clauses for different columns hence the modelling was done based upon the queries, (meaning multiple tables with same data but…
max v
  • 13
  • 2
1
vote
3 answers

Problems inserting a new entry in Astra Cassandra

I am doing a migration from Cassandra on an AWS machine to Astra Cassandra and there are some problems : I cannot insert new data in Astra Cassandra with a column which is around 2 million characters and 1.77 MB (and I have bigger data to insert -…
R13mus
  • 752
  • 11
  • 20
1
vote
2 answers

Error creating bean with name 'sessionBuilderCustomizer' defined in com.example.betterreadsDataloader.BetterreadsDataloader1Application

I am creating this spring boot with Cassandra and when trying to do a connection with Cassandra I am getting this error. Please help: org.springframework.beans.factory.BeanCreationException: Error creating bean \ with name…
1
vote
1 answer

Spring Boot Astra Cassandra - keyspace specified in application.yml but still throws error "No keyspace has been specified"

I am trying to build a very simple api connecting to an astra Cassandra nodal database with spring boot. However, even when I have specified the keyspace in application.yml, it still throws the…
Penthrite
  • 13
  • 4
1
vote
2 answers

How can I apply a schema.cql to a new DataStax Astra database keyspace?

I've got an existing Cassandra application I want to try in Datastax Astra. I've created my Astra database and am able to connect to it from NodeJS successfully. The next task I have is to apply my existing schema.cql to the keyspace. It should be…
rodneyt
  • 71
  • 7
1
vote
1 answer

cassandra ValueError: contact_points, endpoint_factory, ssl_context, and ssl_options cannot be specified with a cloud configuration

I am new to cassandra and trying to use it with celery task queue. import json from cassandra.auth import PlainTextAuthProvider from celery import Celery from config_constant import REDIS_CONNECTION app = Celery('tasks', broker=REDIS_CONNECTION, …
akram
  • 157
  • 1
  • 15
1
vote
1 answer

@SASI.StandardAnalyzed | Tables cannot have more than 0 SASI indexes, failed to create SASI index on table user

I am using the Cassandra database (via Datastax AstraDB) for a search query like SELECT * FROM userdb.users WHERE skill LIKE %jav% AND skill LIKE %node% AND updatedate BETWEEN "1641839170" AND "1641839370" AND City LIKE "Chen"; I read about SASI…
1
vote
1 answer

How do I insert data to Astra DB using GraphQL API?

I am trying to follow this youtube tutorial. I am getting stuck at inserting the first piece of data. Ania demonstrates it at 20.46 as follows: mutation insertGenres { action: insertreference_list(value: {label: "genre", value: "action"}) { …
Mel
  • 2,481
  • 26
  • 113
  • 273
1
vote
0 answers

Spring boot app getting "Error creating bean with name 'cassandraSession'"

I'm experiencing some troubles with Apache Cassandra and I think you could help me out! So, this is my pom com.inboxapp inbox-app 0.0.1-SNAPSHOT inbox-app
DiegoMG
  • 383
  • 1
  • 4
  • 18
1
vote
1 answer

Bulk Loading large dataframe into Astra DB

I'm trying to load my dataframe into AstraDB but its taking forever to load.. i was wondering if there's a faster method to do it via python? import cassandra from cassandra.cluster import Cluster from cassandra.auth import…
v_him
  • 33
  • 7
1
vote
1 answer

Which Azure Storage is used in DataStax ASTRA DB

There is little documentation on how ASTRA DB stores data. So, i could not do much research on this. I wanted to know which of the storage options do ASTRA DB use to store data in azure blob. The storage options are LRS(Locally Redundant Storage) -…
Rajib Deb
  • 1,496
  • 11
  • 30