windows安装cassandra3.11.11

一.官网下载cassandra

https://cassandra.apache.org/_/download.html
https://www.apache.org/dyn/closer.lua/cassandra/3.11.11/apache-cassandra-3.11.11-bin.tar.gz

二.添加环境变量(sysdm.cpl)

D:\apache-cassandra-3.11.11-bin\apache-cassandra-3.11.11\bin

三.修改cassandra.yaml配置

data_file_directories:
- D:\apache-cassandra-3.11.11-bin\apache-cassandra-3.11.11\data
commitlog_directory: D:\apache-cassandra-3.11.11-bin\apache-cassandra-3.11.11\commitlog

saved_caches_directory: D:\apache-cassandra-3.11.11-bin\apache-cassandra-3.11.11\saved_caches

四.修改文件(lib\sigar-bin为sigar-bin_tmp)

五.启动

cassandra.bat

六.python操作cassandra

# -*- coding: utf-8 -*-
# @Time    : 2022/1/4 19:29
# @Author  : Cocktail_py

from cassandra import ConsistencyLevel
# 引入数据
from cassandra.cluster import Cluster
# 引入DCAwareRoundRobinPolicy模块，可用来自定义驱动程序的行为
# from cassandra.policies import DCAwareRoundRobinPolicy
from cassandra.auth import PlainTextAuthProvider
from cassandra.query import SimpleStatement
import pandas as pd

cluster = Cluster(contact_points=['127.0.0.1'],
                  port=9042)
session = cluster.connect()


# 创建keyspace和table
def createKeySpaceAndTable():
    # 创建KeySpace；使用第一个副本放置策略，即简单策略；选择复制因子为3个副本。
    session.execute("CREATE KEYSPACE IF NOT EXISTS test WITH replication = {'class':'SimpleStrategy', 'replication_factor' : 1};")

    # 选择keyspace
    session.execute('use test;')
    # 创建table
    session.execute('create table test.user(name text primary key, age int, email varchar);')
    # 删除table
    # session.execute('drop table test.user;')
    # 关闭Session
    # session.shutdown()
    # 关闭Cluster
    # cluster.shutdown()


# createKeySpaceAndTable()

'''查询keyspaces/tables/columns状态'''


def selectAllStatus():
    # 查询keyspaces/tables/columns状态
    print(cluster.metadata.keyspaces)
    print('----------')
    print(cluster.metadata.keyspaces['test'].tables)
    print('----------')
    print(cluster.metadata.keyspaces['test'].tables['user'])
    print('----------')
    print(cluster.metadata.keyspaces['test'].tables['user'].columns)
    print('----------')
    print(cluster.metadata.keyspaces['test'].tables['user'].columns['age'])
    print('----------')
    # 关闭连接
    cluster.shutdown()
    # 查看是否关闭连接
    print(cluster.is_shutdown)


'''插入和查询表中的数据'''


def testInsertAndSelectTable():
    # table中插入数据
    session.execute('insert into test.user (name, age, email) values (%s, %s, %s);', ['aaa', 21, '222@21.com'])
    session.execute('insert into test.user (name, age, email) values (%s, %s, %s);', ['bbb', 22, 'bbb@22.com'])
    session.execute('insert into test.user (name, age, email) values (%s, %s, %s);', ['ddd', 20, 'ccc@20.com'])
    # table中查询数据
    rows = session.execute('select * from test.user;')
    for row in rows:
        print(row)
    # 关闭连接
    cluster.shutdown()
    # 查看是否关闭连接
    print(cluster.is_shutdown)


'''连接远程数据库'''


def testContectRemoteDatabase():
    # 配置Cassandra集群的IP，记得改成自己的远程数据库IP哦
    # contact_points = ['1.1.1.1', '2.2.2.2', '3.3.3.3']
    contact_points = ['127.0.0.1']
    # 配置登陆Cassandra集群的账号和密码，记得改成自己知道的账号和密码
    auth_provider = PlainTextAuthProvider(username='cassandra', password='cassandra')
    # 创建一个Cassandra的cluster
    cluster = Cluster(contact_points=contact_points, auth_provider=auth_provider)
    # 连接并创建一个会话
    session = cluster.connect()
    # 定义一条cql查询语句
    cql_str = 'select * from keyspace.table limit 5;'
    simple_statement = SimpleStatement(cql_str, consistency_level=ConsistencyLevel.ONE)
    # 对语句的执行设置超时时间为None
    execute_result = session.execute(simple_statement, timeout=None)
    # 获取执行结果中的原始数据
    result = execute_result._current_rows
    # 把结果转成DataFrame格式
    result = pd.DataFrame(result)
    # 把查询结果写入csv
    result.to_csv('连接远程数据库.csv', mode='a', header=True)
    # 关闭连接
    cluster.shutdown()


if __name__ == '__main__':
    # 创建keyspace和table
    createKeySpaceAndTable()

    # 查询keyspaces/tables/columns状态
    # selectAllStatus()

    testInsertAndSelectTable()

    # 插入和查询表中的数据
    # testInsertAndSelectTable()

参考:
https://blog.csdn.net/sunxiaoju/article/details/83817586
https://blog.csdn.net/ssjq123/article/details/121893407
https://blog.csdn.net/john1337/article/details/113729549
win10 安装java8
https://www.cnblogs.com/hacke14/p/14344748.html