135 questions
1
vote
0
answers
60
views
Python Flask app connected to Cassandra Astra DB RAM memory issue
I'm running a minimal Python Flask app with one API endpoint which make a simple call to retrieve data from the a Cassandra Datastax DB inside a for loop.
# Day-2-Day Power
@app.route("/d2d_new_2/...
- 886
0
votes
1
answer
91
views
How to Connect Cassandra Datastax in intellij idea? [closed]
I wanna know that how we can connect datastax Cassandra database into the intellij idea as a data source? i have tried several times with the Generated token but i was unable to do that.
- 47
0
votes
1
answer
104
views
error 111- Connection refused for cassandra
I am learning to use Datastax AstraDB to vector storage. I am trying to follow a tutorial. I am using cassio to connect with astraDB using the following code:
ASTRA_DB_APPLICATION_TOKEN = os.environ....
- 117
0
votes
1
answer
1k
views
Langflow file storage
I'm working on a custom component for Langflow which is going to receive an image from the chat input, modify it with the help of an API call, then pass it on to be part of the chat output from an ...
0
votes
1
answer
959
views
How do we use custom Python module in Langflow?
Ok, if we try to use the hosted version from Datastax, I don't see any way to install python modules into it and all custom components cannot be made due to the module not being installed.
Hosted by ...
- 7,550
1
vote
1
answer
230
views
How to Efficiently Combine Date Range Filtering and Vector Similarity Search in Astra DB Using _id Field's Time Dimension?
I want to limit vector similarity searches to a specific day or date range. Can I use the time dimension in Astra DB's _id field (document model) for this? Would Astra DB automatically route the query ...
- 23
2
votes
3
answers
106
views
Is it possible to identify the Cassandra engine/system via CQL?
I tried to identify the engine (Cassandra, Scylla, AstraDB, CosmosDB, Yugabyte, ...) based on Cassandra Query Language (CQL). I focused on tables system.local and system.peers, see the sample:
SELECT ...
- 1,390
0
votes
2
answers
593
views
Spring Boot Cassandra Connectivity Issue: Can't Connect to DataStax Astra DB
I'm working on a Spring Boot application that integrates with DataStax Astra DB using the Astra secure bundle. However, I’m encountering persistent issues when trying to establish a connection to the ...
1
vote
2
answers
1k
views
Cassandra Python app on Windows returns "The C extension needed to use libev was not found"
Once I saw an ad about how to make an AI generated your own adventure game in Python, so I went to YouTube and checked the video out. Even though the video was out of date, I followed along with it ...
- 11
0
votes
1
answer
52
views
Running astra-cli setup command returns "UnsatisfiedLinkError: jdk.internal.io.JdkConsoleImpl.echo(Z)Z"
I have installed Astra DB on macOS Sonoma using Homebrew
brew install datastax/astra-cli/astra-cli
I am running astra setup now but getting the following error
Exception in thread "main" ...
- 95
0
votes
2
answers
208
views
Unable to see Connect tab in Astra DB
While I am trying to connect the Document API with my database in DataStax AstraDB, there is no "Connect" tab appearing where I can link my database to the Document API. I am new to this; is ...
- 15
1
vote
1
answer
142
views
system.local table restrictions - AstraDB Serverless (Cassandra)
I'm trying to execute "toUnixTimestamp(now())" against system.local table (AstraDB Serverless).
It works fine when I execute it inside AstraDB CQL Console: SELECT toUnixTimestamp(now()) FROM ...
0
votes
2
answers
130
views
Is there a limit to the number of partition keys in a SELECT statement?
Is there a limitation in terms of the number of Cassandra partition keys when doing a select ?
SELECT * FROM series_pfc_gas
WHERE as_of='2024-07-25'
AND name IN ('ZTP_FLX_B_LUX_ALL', '...
- 886
0
votes
2
answers
318
views
AstraDBVectorStore add_documents() returns exception "'dict' object has no attribute 'page_content'"
def store_embeddings_in_astradb(embeddings,text_chunks, metadata):
vstore = AstraDBVectorStore(
collection_name="test",
embedding=embedding_model,
token=os....
- 27
0
votes
1
answer
534
views
Connecting from DBeaver using Astra JDBC driver returns "Invalid Credentials"
I need to connect to Astra using DBeaver. I'm following guide https://awesome-astra.github.io/docs/pages/data/explore/dbeaver/#astra-community-jdbc-drivers (exactly "Astra Community JDBC Drivers&...
- 945
1
vote
1
answer
145
views
RAG app fails using DataAPIClient: "Error loading the fetch-h2 client for the DataAPIClient... try setting httpOptions.client to 'fetch'"
error:
<scriptid="__NEXT_DATA__"type="application/json">{
"props": {
"pageProps": {
"statusCode": 500
}
},
...
- 13
0
votes
0
answers
138
views
Getting Error: astrapy.core.api.APIRequestError while trying to connect to astradb
I am getting astrapy.core.api.APIRequestError while trying to connect to AstraDB, I am aware what error is saying but I did not find any solution.
Complete Error:
astrapy.core.api.APIRequestError: {&...
- 47
1
vote
1
answer
94
views
Can't connect Django server to Cassandra DB (AstraDB)
I've hosted my Cassandra DB on AstraDB and am trying to connect my Django server to it. This is the first time I'm working with Django too so I'm a bit confused on how it works. In my settings.py file,...
- 11
1
vote
0
answers
60
views
AI based text game autocompletes user inputs prematurely
I am trying to write a text-based adventure game following a YouTube tutorial here. After updating the code according to the latest documentation, I've encountered a problem where the AI responds to ...
0
votes
1
answer
230
views
Unable to find Astra connection details (datastax)
im trying to establish a connection to datastax astra-db using the node module cassandra-client, as shown below
const client = new cassandra.Client({
cloud: { secureConnectBundle: 'path/to/secure-...
1
vote
1
answer
2k
views
Operation `.findOne()` buffering timed out after 10000ms - Next.js Mongoose
In my NextJS Project, I'm working on a newsletter application. My database is called Datastax Astra. I have developed the logic to save the database file. however, I continue to receive a 1000 ms ...
0
votes
1
answer
105
views
Unable to delete table from AstraDb when closing Flask app using atexit()
app = Flask(__name__)
# AstraDB connection and vector store initialization
def initialize_astra_vector_store():
cassio.init(token=ASTRA_DB_APPLICATION_TOKEN, database_id=ASTR_DB_ID)
...
-2
votes
2
answers
436
views
datastax cassandra.cluster.NoHostAvailable
I was deploying Datastax exactly as the Datastax website says and even used virtualenv but then I got an error:
cassandra.cluster.NoHostAvailable
I'm using windows 10.
I heard something about when ...
- 13
-1
votes
1
answer
95
views
Retrieving document by ID with Stargate Document API returns error 404, "A document with the id ... does not exist"
I have created a database in datastax and create a collection and its document. It gave me a documentID to list my collections or the data inside the document, now when i go to get the document by ...
1
vote
1
answer
84
views
Why am I getting this error: MissingSchemaError: Schema hasn't been registered for model "Business"
This is the error I'm getting: "MissingSchemaError: Schema hasn't been registered for model "Business"."
I'm using AstraDB vector database. I made a function to initialize a ...
- 107
2
votes
0
answers
241
views
WordPress database error Deadlock found when trying to get lock; try restarting transaction for query. . .'_transient_astra-theme-cron-test-ok'
I'm encountering a database deadlock error.
[29-Sep-2023 09:41:45 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_options ...
- 31
0
votes
1
answer
66
views
Connecting to Astra DB from pure Spring app, No Spring boot
I have a spring app (no Spring Boot) which is using spring data cassandra for data access. I want to use reactive version of spring data cassandra and connect to Data stax Astra DB. connecting to ...
- 396
0
votes
1
answer
76
views
Image Size CSS not working although it should
I am trying to adjust the image height size of the hidden cart.
I have inspected the website with Developer Tools of Firefox and Brave. It appears like this modification should do the trick:
....
- 1
0
votes
1
answer
405
views
Cassandra Driver Exception: Unable to connect to the metadata service
I am playing around with some self-paced learning for creating and configuring LLMs for personal use. In this scenario, I am trying to connect to AstraDB to store the headlines from a sample of news ...
1
vote
1
answer
130
views
How to connect a bubble.io app with Datastax AstraDB?
I am trying to connect to my DataStax AstraDB using a Bubble.io app. I am not able to do so, can someone please help me figure this out? I read through the docs and I could not find anything.
- 85
0
votes
1
answer
729
views
Unable to connect to Cassandra (AstraDB) for vector search example from LangChain docs
I'm trying to connect to AstraDB for my Python vector search project (for my GPT chatbot), but I'm getting a connection error. (I'm following the example in the LangChain Cassandra Vector store ...
- 5,144
0
votes
1
answer
89
views
Batch, delete operations are not working in NodeJS app
I am building an app using AstraDB with NodeJS. I love Cassandra and wanted to try it out for my application
Unfortunately, The Node Cassandra Driver seems not to perform well. Batch Operations are ...
1
vote
1
answer
1k
views
How to use a vector database to find matches between users?
I have an app where users can sign up and fill out a profile. This profile consists of 16 questions that can be answered using a slider. Each "answer" for a question can be between -3 and 3 (...
- 2,343
1
vote
1
answer
460
views
How are the results of a Cassandra Vector Search sorted?
I have a table of movies in Cassandra (hosted on Astra DB), with a lone primary key of movie_id. There are several columns, but for my vector search I really only care about the title. The ...
- 58k
0
votes
1
answer
104
views
Issue inserting a new record with @astrajs/rest
I'm new to astra db, and am having issues trying to insert a record into my table called 'usersnew' when using @astrajs/rest
This is the structure of my table:
CREATE TABLE mykeyspace.usersnew (
...
- 23
2
votes
1
answer
384
views
How to INSERT a vector into Cassandra with Java?
I'm having trouble mapping a Java Vector type to my Cassandra table (Astra DB) in Java. The idea is to query by an ANN with Vector Search to return movie recommendations.
Here is my table definition:
...
- 58k
0
votes
1
answer
385
views
Can't connect to Astra DB with Python driver
I believe I'm doing exactly as mentioned in the documentation Python-driver-AstraDB
cloud_config= {
'secure_connect_bundle': 'secure-connect-test-warehouse.zip'
}
logging.basicConfig(level=...
- 15
0
votes
1
answer
246
views
Can I store timestamps in Central European Time (UTC+2)?
I know Cassandra stores data in UTC time in a timestamp column but I need it to store the timestamp like the following (UTC+2, Central European Time):
2023-10-29 00:00:00.000000+0200
2023-10-29 01:00:...
- 886
0
votes
1
answer
321
views
Edit Custom Footer with Astra Theme and Beaver Builder
I am trying to access a custom footer that has been created with Astra Theme and Beaver Builder. In Astra Custom Layouts there appears to be a published Footer but when I try to access it (it says it ...
- 23
0
votes
0
answers
920
views
Astra theme is not reflecting the changes I am making
I am testing Astra Pro and on trying to configure the page layout sidebar to the left, sidebar continues to the write.
Also, I tried moving the title upwards within the banner and on doing so, the ...
0
votes
1
answer
386
views
Datastax Astra : error fetching metadata information using secure bundle
My goal is to use a Secure Connect Bundle to connect to my database on Astra. However, I'm getting This error (underlined in blue):
First I went to my server (Celestia) and went to the connect tab to ...
- 61
1
vote
1
answer
480
views
Provided value LOCAL_ONE is not allowed for Write Consistency Level
I'm trying to connect my java spring boot application to cassandra astra db with the cql proxy running with docker-compose.
I got this error :
com.datastax.oss.driver.api.core.servererrors....
- 243
1
vote
2
answers
139
views
Datastax: No file I/O Permission
I have a table called solar_system_volatiles in my Astra Datastax serverless database. I'm trying to copy data from a .csv file into a table on Astra db. The code I've tried is below in the image.
...
- 61
1
vote
1
answer
77
views
cql-proxy: error: must provide either bundle path, token, or contact points
How to resolve this error:
cql-proxy: error: must provide either bundle path, token, or contact points
This is my docker-compose.yml:
cassandra-service:
image: datastax/cql-proxy:v0.1.2
...
- 243
1
vote
2
answers
132
views
How do I start the CDC agent in a Stargate container?
I'm trying to build an integration test for Datastax CDC. I'm trying to follow the directions here to create a containerized Stargate instance running the CDC Java agent. I'm using the following ...
- 1,092
1
vote
2
answers
447
views
How do I filter with the REST API in Astra DB?
Currently, I have problem when using Rest API in DataStax Astra.
For example data:
{
"count": 2,
"Members": [
{
"created_at": "",
"...
- 13
1
vote
1
answer
353
views
Getting connection timeouts on application startup
We have a staging instance of our web app that connects to DataStax Astra PAYG using NodeJS driver.
Sometimes when the app has been idle and is first accessed we get repeated instances of this error ...
- 142
0
votes
1
answer
275
views
DataStax Astra Backups - what's the backup policy, how long are they retained, and how to restore a backup?
We're migrating a Cassandra database to Datastax Astra (serverless, PAYG service). I'm curious about how backups work. From https://docs.datastax.com/en/astra-serverless/docs/manage/db/manage-multi-...
- 142
1
vote
3
answers
452
views
How do I connect to Astra DB from my flutter application's login page?
I am currently working on a flutter application using dart language. I am trying to use AstraDB for my login page authentication of users' email and password using the http flutter package.
The ...
- 11
0
votes
1
answer
388
views
How can I pass a dynamic attribute to Nifi EvaluateJsonPath?
Currently, I'm building a 3rd party automated data collection process, through NiFi that runs automatically syncing data to datastax Astra. Here is a sample api return I got from a third party.
{
&...
- 13