Questions tagged [azure-cosmosdb-cassandra-api]

Azure Cosmos DB databases can be configured to use the Cassandra API. This means your existing Cassandra application can now communicate with the Azure Cosmos DB Cassandra API by changing a connection string.

22 questions
3
votes
1 answer

Can I get the count of all records in a Cosmos DB table for a large amount of records?

Assuming I have approximately 10 million documents in a Cosmos DB SQL table, or 10 million collections in a Cosmos DB Cassandra table, is there any way to view the amount of documents/collections in those tables?
2
votes
1 answer

Is there a way to set Azure Cosmos DB throughput below 400 RU/s?

I tried setting the throughput for a Cassandra table in Azure Cosmos DB settings to below 400 but it does not seem to work. The save button becomes inactive, disallowing this. I'm running a test server that will never generate such a high…
Rafał Sroka
  • 39,540
  • 23
  • 113
  • 143
2
votes
2 answers

What are storage differences between Cosmosdb sql api and Cosmosdb cassandra api

It is mentioned in most of the articles that if we are using Cosmos Db and newly creating our app we should go with Cosmos db sql api . Mongo api and cassandra api can be used when u already have your app integrated with actual mongo and cassandra…
1
vote
1 answer

How do I create database users for Cassandra on CosmosDB?

I want to be able to create multiple users on my Cassandra app such that a user can only access specific databases. I've tried following the official docs of DataStax to create users. However, cosmosdB doesn't let me add users or even LIST USERS as…
1
vote
1 answer

How to define PRIMARY KEY in azure cosmosdb arm template

is it possible to define PRIMARY key in azure cosmosdb cassandra arm template ? Let's say I have next table: CREATE TABLE foo ( id text name test PRIMARY KEY (id) ) And my ARM template: "schema":{ "columns":[ { "name":"id", …
1
vote
0 answers

Cosmos db cassandra api write path

Does cosmosdb cassandra api uses same memtable , commit log, systable compaction write path to provide good performance for heavy write operations or is it same as the write operations in cosmos sql api. Will cosmos cassndra api is suppose to work…
1
vote
1 answer

Connect CosmosDB with Datastax DevCenter Cassandra

Is this possible to connect CosmosDB Account using Datastax DevCenter Cassandra. I have created 1 instance of CosmosDB using Cassandra API for this. As code need Contact Point, port, username & Password: I have these detail added in Devcenter &…
1
vote
1 answer

is Kafka Connect Cassandra compatible with Cosmos Cassandra?

I am using Kafka Connect Cassandra to read from Kafka topic and insert to Cassandra, is this compatible with Cosmos Cassandra?
1
vote
2 answers

Unable to connect Cassandra CQL shell to Azure-CosmosDB

I have entered the following command on my windows cql shell set SSL_VERSION=TLSv1_2; and got this error No viable alternative at input 'set'([set]..)
1
vote
1 answer

Existing app migrate from Cassandra DB to Cosmos DB

What types of code changes may need to be made? The documentation seems to be conflicting in this regard, and doesn't provide specifics that I can find. The documentation states: No code changes are necessary Trivial code changes may be…
0
votes
1 answer

Cosmos DB Cassandra API Indexes that span partitions

We are in the process of moving our application from on prem to Azure. We are currently using Cassandra and the plan is to use Cosmos DB Cassandra API in Azure. In Cassandra, the general rule of thumb is that an index should correspond to single…
0
votes
2 answers

Are prepared statements supported with Azure Cosmos Cassandra API?

Are prepared statements supported with Azure Cosmos Cassandra API with Python? It appears not - when I execute stmt = session.prepare("SELECT provider FROM providers WHERE country_code=?") I get the following exception: Traceback (most recent call…
Ian Goldby
  • 5,609
  • 1
  • 45
  • 81
0
votes
2 answers

Abstract Method Exception when connecting to Azure Cosmos DB Cassandra API table using Azure databricks job

I am trying to write data to Cassandra table (cosmos DB) via Azure DBR job (spark streaming). Getting below exception: Query [id = , runId = ] terminated with exception: Failed to open native connection to Cassandra at…
0
votes
1 answer

Azure CosmosDB write latencies for different APIs

We have a low-latency use case for Azure CosmosDB (eg. adding extra 100ms will be sensitive to the application). Are there any implications on write latency when choosing an Azure CosmosDB API -- Core SQL is default, but perhaps there are some…
0
votes
1 answer

NoHostAvailable connecting to Cassandra from python in Databricks environment

from cassandra.cluster import Cluster hostname = ['contact_point_name'] port = '10350' cluster = Cluster(hostname, control_connection_timeout=None, port = port) session = cluster.connect() Error: NoHostAvailable: ('Unable to connect to any…
1
2