This repository contains python code showcasing interaction with Cassandra API of Azure Cosmos DB which showcases creation, query and cleanup of data

Python 100.00%

azure-cosmos-db-cassandra-python-getting-started's Introduction

page_type

languages

products

description

urlFragment

sample

python

azure

Azure Cosmos DB is Microsoft's globally distributed multi-model database service.

azure-cosmos-db-cassandra-python-getting-started

Accessing Cassandra API on Azure Cosmos DB using Python

Azure Cosmos DB is Microsoft's globally distributed multi-model database service. You can quickly create and query document, table, key-value, and graph databases, all of which benefit from the global distribution and horizontal scale capabilities at the core of Azure Cosmos DB. This quick start demonstrates how to create an Azure Cosmos DB account for the Cassandra API by using the Azure portal. You'll then build a user profile console app, output as shown in the following image, with sample data.

Running this sample

Before you can run this sample, you must have the following perquisites:
- An active Azure Cassandra API account - If you don't have an account, refer to the Create Cassandra API account.
- [Python 2.7]
- Git.
- Python Driver

Clone this repository using git clone [email protected]:Azure-Samples/Azure-Samples/azure-cosmos-db-cassandra-python-getting-started.git cosmosdb.
Change directories to the repo using cd cosmosdb
Next, substitute the contactPoint, username, password in config.py with your Cosmos DB account's values from connectionstring panel of the portal.
```
'username': '<FILLME>',
'password': '<FILLME>',
'contactPoint': '<FILLME>',
'port':'10350'
```

Run

pip install Cassandra-driver 
pip install prettytable
pip install requests
pip install pyopenssl

in a terminal to install required python packages

Run python pyquickstart.py in a terminal to execute it.

About the code

The code included in this sample is intended to get you quickly started with a python program that connects to Azure Cosmos DB with the Cassandra API.

More information

azure-cosmos-db-cassandra-python-getting-started's People

Contributors

Stargazers

Watchers

Forkers

tottotza theovankraay spelluru isabella232 lunelsonms script-0 niteshgautam01 bobbytreed iriaosara kseniiaryuma juanbh89106 grotjohan-insurance-inc guanzhousongmicrosoft

azure-cosmos-db-cassandra-python-getting-started's Issues

Error in insert into example

Please provide us with the following information:

This issue is for a: (mark with an `x`)

- [ x] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

Example data of pyquickstart.py

Any log messages given by the failure

Traceback (most recent call last):
File "D:/Desarrollo/azure-cosmos-db-cassandra-python-getting-started/pyquickstart.py", line 38, in
insert_data = session.prepare("INSERT INTO uprofile.user (user_id, user_name , user_bcity) VALUES (?,?,?)")
File "cassandra\cluster.py", line 3069, in cassandra.cluster.Session.prepare
File "cassandra\cluster.py", line 3066, in cassandra.cluster.Session.prepare
File "cassandra\cluster.py", line 4871, in cassandra.cluster.ResponseFuture.result
File "cassandra\connection.py", line 1075, in cassandra.connection.Connection.process_msg
File "cassandra\protocol.py", line 1189, in cassandra.protocol._ProtocolHandler.decode_message
File "cassandra\protocol.py", line 740, in cassandra.protocol.ResultMessage.recv_body
File "cassandra\protocol.py", line 730, in cassandra.protocol.ResultMessage.recv
File "cassandra\protocol.py", line 771, in cassandra.protocol.ResultMessage.recv_results_prepared
File "cassandra\protocol.py", line 815, in cassandra.protocol.ResultMessage.recv_prepared_metadata
File "cassandra\protocol.py", line 1287, in cassandra.protocol.read_short
File "D:\Programas\Anaconda3\envs\tf-gpu\lib\site-packages\cassandra\marshal.py", line 22, in
unpack = lambda s: packer.unpack(s)[0]
struct.error: unpack requires a buffer of 2 bytes

Expected/desired behavior

Insert and show records in cmd

OS and Version?

Windows 10

Versions

Using PyCharm and VS Code

Thanks! We'll be in touch soon.

unpack requires a buffer of 2 bytes

Please provide us with the following information:

This issue is for a: (mark with an `x`)

- [ x] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

clone and run project

Any log messages given by the failure

Exception has occurred: error unpack requires a buffer of 2 bytes

Expected/desired behavior

No error

OS and Version?

Windows 10.

Versions

1909

Mention any other details that might be useful

Error happens on line 38 when tying to exectute this insert_data = session.prepare("INSERT INTO uprofile.user (user_id, user_name , user_bcity) VALUES (?,?,?)")

Thanks! We'll be in touch soon.

Specify Cassandra protocol to use

This issue is for a: (mark with an `x`)

- [x ] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Expected/desired behavior

The example should specify the protocol to be used. It defaults to DSE_v2, which disables client-side timestamp generation and possibly causes other confusion. The correct connection line is as follows:

cluster = Cluster([cfg.config['contactPoint']], port = cfg.config['port'], auth_provider=auth_provider,ssl_context=ssl_context,protocol_version=ProtocolVersion.V4)

azure-samples / azure-cosmos-db-cassandra-python-getting-started Goto Github PK

azure-cosmos-db-cassandra-python-getting-started's Introduction

Accessing Cassandra API on Azure Cosmos DB using Python

Running this sample

About the code

More information

azure-cosmos-db-cassandra-python-getting-started's People

Contributors

Stargazers

Watchers

Forkers

azure-cosmos-db-cassandra-python-getting-started's Issues

Please provide us with the following information:

This issue is for a: (mark with an x)

Minimal steps to reproduce

Any log messages given by the failure

Expected/desired behavior

OS and Version?

Versions

Please provide us with the following information:

This issue is for a: (mark with an x)

Minimal steps to reproduce

Any log messages given by the failure

Expected/desired behavior

OS and Version?

Versions

Mention any other details that might be useful

This issue is for a: (mark with an x)

Expected/desired behavior

Recommend Projects

Recommend Topics

Recommend Org

This issue is for a: (mark with an `x`)

This issue is for a: (mark with an `x`)

This issue is for a: (mark with an `x`)