鹏程万里----阿里云服务器获取数据

最新推荐文章于 2023-03-03 09:50:28 发布

苏西守护者

最新推荐文章于 2023-03-03 09:50:28 发布

阅读量815

点赞数

本文链接：https://blog.youkuaiyun.com/u013308744/article/details/107819513

版权

本文展示了如何使用Python SDK从阿里云的表格存储(OTS)中读取指定范围的数据。通过设置起始和结束主键，可以精确地获取设备工作数据表中的记录，示例代码详细解释了如何进行数据读取并处理读取到的数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

try:
    client = OTSClient("https://hps.cn-hongkong.ots.aliyuncs.com", "LTAI4FzfwqVieWN7i1BeXNKQ",
                       "qBRQrEM69eHIn9kzQDBrufmLZcx8", "hps")
    inclusive_start_primary_key = [('sn', "S65000A119702023"), ('time', '2020-01-20 00:00:02')]
    exclusive_end_primary_key = [('sn', "S65000A119702023"), ('time', '2020-01-20 23:59:59')]
    columns_to_get = []
    limit = 1000
    consumed, next_start_primary_key, row_list, next_token = client.get_range(
        'device_workdata', Direction.FORWARD,
        inclusive_start_primary_key, exclusive_end_primary_key,
        columns_to_get,
        limit,
        max_version=1
    )

    all_rows = []
    all_rows.extend(row_list)
    while next_start_primary_key is not None:
        inclusive_start_primary_key = next_start_primary_key
        consumed, next_start_primary_key, row_list, next_token = client.get_range(
            'device_workdata', Direction.FORWARD,
            inclusive_start_primary_key, exclusive_end_primary_key,
            columns_to_get, limit,
            max_version=1
        )
        all_rows.extend(row_list)
        print('Read succeed, consume %s read cu.' % consumed.read)

    for row in all_rows:
        print(row.primary_key, row.attribute_columns)
    print('Total rows: ', len(all_rows))
except Exception as err:
    print(err)

从阿里云数据服务器上获取数据的例子