Advertisement

【apache ioTDB】python 写入数据集到apache ioTDB

阅读量:

首先下载安装包

复制代码
    pip install apache-iotdb
    
    
    python
在这里插入图片描述

测试例子:

复制代码
    from iotdb.Session import Session
    from iotdb.utils.IoTDBConstants import TSDataType
    from iotdb.utils.Tablet import Tablet
    
    ip = "192.168.8.161"
    port = "6667"
    username = "root"
    password = "root"
    session = Session(ip, port, username, password)
    session.open(False)
    
    measurements = ["create_time", "an_shui", "two_temperature","head_coal", "kiln_fire", "kiln_temperature"]
    data_types = [
    TSDataType.TEXT,
    TSDataType.DOUBLE,
    TSDataType.DOUBLE,
    TSDataType.DOUBLE,
    TSDataType.DOUBLE,
    TSDataType.DOUBLE,
    ]
    values = [
    ["2023-08-18 18:06:00", 10, 1101, 15.1, 121.1, 1450],
    ["2023-08-18 18:07:00", 10, 1101, 15.1, 121.1, 1450],
    ["2023-08-18 18:07:00", 10, 1101, 15.1, 121.1, 1450],
    ["2023-08-18 18:07:00", 10, 1101, 15.1, 121.1, 1450],
    ]
    timestamps = [1, 2, 3, 4]
    tablet = Tablet(
    "root.minite.tags_offline", measurements, data_types, values, timestamps
    )
    session.insert_tablet(tablet)
    
    with session.execute_statement(
        "select ** from root.minite.tags_offline"
    ) as session_data_set:
    while session_data_set.has_next():
        print(session_data_set.next())
    
    session.close()
    
    
    
    python
    
    
![](https://ad.itadn.com/c/weblog/blog-img/images/2025-08-19/nr4W10QsDcLXwR3YSxMZoqzPAkOC.png)

结合pandas 查询例子:

复制代码
    from iotdb.Session import Session
    
    ip = "192.168.8.161"
    port = "6667"
    username = "root"
    password = "root"
    session = Session(ip, port, username, password)
    session.open(False)
    
    result = session.execute_query_statement("SELECT ** FROM root.minite.tags_offline")
    
    # Transform to Pandas Dataset
    df = result.todf()
    print(df.head())
    session.close()
    
    
    
    
    
    python
    
    
![](https://ad.itadn.com/c/weblog/blog-img/images/2025-08-19/zdflYu1JrUpxBweji5Ca2VXOqPoQ.png)

全部评论 (0)

还没有任何评论哟~