Questions tagged [stargate-oss]

Stargate is an open source data gateway, originally built for use with Cassandra. It's designed with extensibility as a first-class citizen and makes it easy to use a database for any application workload by adding plugin support for new APIs, data types, and access methods.

Stargate is a data gateway deployed between client applications and a database. It's built with extensibility as a first-class citizen and makes it easy to use a database for any application workload by adding plugin support for new APIs, data types, and access methods.

This project enables customization of all aspects of data access and has modules for authentication, APIs, request handling / routing, and persistence backends. The current form is specific to the Apache Cassandra (C*) backend but there's no bounds to the databases or APIs that this framework can support.

24 questions
3
votes
1 answer

How long does stargate rest api's auth token will remain active before expiring?

We are using stargate rest api, which is a wrapper over DataStax Enterprise for Cassandra DB. For accessing the data in the DB, we had get a token from the stargate's auth service first. I wonder how long does this token remain active. Is there a…
2
votes
1 answer

Does stargate work with Materialized view?

I created a materialized view on Datastax cassandra. When I am using Stargate rest api to get the data from the view, it returns { "description": "Resource not found: table 'view_user_by_status' not found", "code": 404 }
David
  • 3,538
  • 9
  • 39
  • 50
2
votes
1 answer

Does Stargate REST API support Cassandra batch query?

Does Stargate rest api support batch query in Cassandra (DSE 6.8)? If any, can you provide me an example?
David
  • 3,538
  • 9
  • 39
  • 50
2
votes
2 answers

How to get data using Stargate on DataStax Enterprise

I have datastax cassandra 6.8 installed in dev server and i also installed Stargate newest version in another dev server. The connection is established between Stargate and Cassandra. I dont see anything error in log file. I am able to use postman…
David
  • 3,538
  • 9
  • 39
  • 50
2
votes
1 answer

Pagination of Stargate document API for Cassandra

The Stargate Document API for Cassandra provides page-size to return all documents limited by a page size. The page-size is has max value of 20. How do I get the next documents; i.e 21 to 30? Reading Documents using Stargate API for Cassandra
1
vote
1 answer

Using $in operator on Cassandra table via stargate API

I have a Cassandra table and it contains a column named 'marks'. It is not part of the primary key. Now, I wish to run something like this: select * from mytable WHERE marks in (58,88); How to achieve this? I want to run the same via Stargate API…
iamvijay
  • 21
  • 2
1
vote
1 answer

How to view Cassandra number of read/write per seconds

Previously, I deployed Cassandra with k8ssandra-operator 1.4 with kube-prometheus-stack enabled, inserting data directly to C* node via CQL. I can see k8ssandra:read/write rates when access Grafana dashboard on Web UI. But after enabling stargate,…
Thong Nguyen
  • 143
  • 3
  • 10
1
vote
2 answers

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 docker file: FROM stargateio/coordinator-4_0:v2 ENV…
1
vote
2 answers

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": "", "intfield": null, "id": "294", "role": "BA", "username": "Join" }, { …
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
1 answer

Rest API Cassandra ALLOW FILTERING

I have a DataStax Astra database and I have this example for how to get a user with a specific username: curl --request GET \ --url…
1
vote
2 answers

Unable to query with Stargate after adding custom Cql3SolrSecondaryIndex

I have stargate 1.0.38 running fine in my DEV server. I am able to use stargate rest api to get auth_token and running insert, select queries. Yesterday, I have created an index Cql3SolrSecondaryIndex for a table in my Cassandra DSE 6.8. Then I see…
David
  • 3,538
  • 9
  • 39
  • 50
1
vote
1 answer

Does Stargate REST API support LIMIT clause?

Does Stargate rest api support LIMIT query in Cassandra (DSE 6.8)? Select * from table LIMIT 100; If any, can you provide me an example?
David
  • 3,538
  • 9
  • 39
  • 50
1
vote
1 answer

How to maintain data type in respond after connecting with Datastax Astra DB?

I am using Datastax Astra database. I am uploading csv file and I am setting all the columns data type as float, as per column. I connected with my db via python http_method. res = astra_client.request( method=http_methods.GET, …
Pritam Sinha
  • 309
  • 6
  • 11
1
vote
2 answers

Can Stargate handle high traffic?

I am working on an application that have to handle over 2 million requests per day. If I have 3 Stargate apps (rest api) run on 3 different servers connect to data center with 4 nodes of Cassandra database. Do you think Stargate can handle that…
David
  • 3,538
  • 9
  • 39
  • 50
1
2