示例数据

示例数据集在整个 InfluxDB 3 Core 文档中用于演示功能。使用以下示例数据集来复现提供的示例。

家庭传感器数据
家庭传感器动作数据
NOAA 旧金山湾区天气数据
比特币价格数据
随机数示例数据

家庭传感器数据

包括模拟的每小时家庭传感器数据，其中包含异常传感器读数，以演示时间序列数据的处理和告警。要自定义数据集中的时间戳，请使用页面右下角的按钮。

时间范围

2022-01-01T08:00:00Z 至 2022-01-01T20:00:00Z (可自定义)

模式

home (表)
- 标签:
  - room
    - 厨房
    - 客厅
- 字段:
  - co (整数)
  - temp (浮点数)
  - hum (浮点数)

将家庭传感器数据写入 InfluxDB

使用 influxdb3 CLI、InfluxDB v3 API、InfluxDB v2 API 或 InfluxDB v1 API 将家庭传感器示例数据写入 InfluxDB 3 Core。

influxdb3 v3 API v2 API v1 API

influxdb3 write \
  --token AUTH_TOKEN
 \
  --database DATABASE_NAME
 \
  'home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000
home,room=Kitchen temp=21.0,hum=35.9,co=0i 1641024000
home,room=Living\ Room temp=21.4,hum=35.9,co=0i 1641027600
home,room=Kitchen temp=23.0,hum=36.2,co=0i 1641027600
home,room=Living\ Room temp=21.8,hum=36.0,co=0i 1641031200
home,room=Kitchen temp=22.7,hum=36.1,co=0i 1641031200
home,room=Living\ Room temp=22.2,hum=36.0,co=0i 1641034800
home,room=Kitchen temp=22.4,hum=36.0,co=0i 1641034800
home,room=Living\ Room temp=22.2,hum=35.9,co=0i 1641038400
home,room=Kitchen temp=22.5,hum=36.0,co=0i 1641038400
home,room=Living\ Room temp=22.4,hum=36.0,co=0i 1641042000
home,room=Kitchen temp=22.8,hum=36.5,co=1i 1641042000
home,room=Living\ Room temp=22.3,hum=36.1,co=0i 1641045600
home,room=Kitchen temp=22.8,hum=36.3,co=1i 1641045600
home,room=Living\ Room temp=22.3,hum=36.1,co=1i 1641049200
home,room=Kitchen temp=22.7,hum=36.2,co=3i 1641049200
home,room=Living\ Room temp=22.4,hum=36.0,co=4i 1641052800
home,room=Kitchen temp=22.4,hum=36.0,co=7i 1641052800
home,room=Living\ Room temp=22.6,hum=35.9,co=5i 1641056400
home,room=Kitchen temp=22.7,hum=36.0,co=9i 1641056400
home,room=Living\ Room temp=22.8,hum=36.2,co=9i 1641060000
home,room=Kitchen temp=23.3,hum=36.9,co=18i 1641060000
home,room=Living\ Room temp=22.5,hum=36.3,co=14i 1641063600
home,room=Kitchen temp=23.1,hum=36.6,co=22i 1641063600
home,room=Living\ Room temp=22.2,hum=36.4,co=17i 1641067200
home,room=Kitchen temp=22.7,hum=36.5,co=26i 1641067200'

curl -v "http://localhost:8181/api/v3/write_lp?db=sensors&precision=auto&accept_partial=true" \
  --data-raw "home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1735545600
home,room=Kitchen temp=21.0,hum=35.9,co=0i 1735545600
home,room=Living\ Room temp=21.4,hum=35.9,co=0i 1735549200
home,room=Kitchen temp=23.0,hum=36.2,co=0i 1735549200
home,room=Living\ Room temp=21.8,hum=36.0,co=0i 1735552800
home,room=Kitchen temp=22.7,hum=36.1,co=0i 1735552800
home,room=Living\ Room temp=22.2,hum=36.0,co=0i 1735556400
home,room=Kitchen temp=22.4,hum=36.0,co=0i 1735556400
home,room=Living\ Room temp=22.2,hum=35.9,co=0i 1735560000
home,room=Kitchen temp=22.5,hum=36.0,co=0i 1735560000
home,room=Living\ Room temp=22.4,hum=36.0,co=0i 1735563600
home,room=Kitchen temp=22.8,hum=36.5,co=1i 1735563600
home,room=Living\ Room temp=22.3,hum=36.1,co=0i 1735567200
home,room=Kitchen temp=22.8,hum=36.3,co=1i 1735567200
home,room=Living\ Room temp=22.3,hum=36.1,co=1i 1735570800
home,room=Kitchen temp=22.7,hum=36.2,co=3i 1735570800
home,room=Living\ Room temp=22.4,hum=36.0,co=4i 1735574400
home,room=Kitchen temp=22.4,hum=36.0,co=7i 1735574400
home,room=Living\ Room temp=22.6,hum=35.9,co=5i 1735578000
home,room=Kitchen temp=22.7,hum=36.0,co=9i 1735578000
home,room=Living\ Room temp=22.8,hum=36.2,co=9i 1735581600
home,room=Kitchen temp=23.3,hum=36.9,co=18i 1735581600
home,room=Living\ Room temp=22.5,hum=36.3,co=14i 1735585200
home,room=Kitchen temp=23.1,hum=36.6,co=22i 1735585200
home,room=Living\ Room temp=22.2,hum=36.4,co=17i 1735588800
home,room=Kitchen temp=22.7,hum=36.5,co=26i 1735588800"

curl --request POST \
  http://localhost:8181/api/v2/write?bucket=DATABASE_NAME
&precision=s \
  --header "Authorization: Bearer AUTH_TOKEN
" \
  --header "Content-Type: text/plain; charset=utf-8" \
  --header "Accept: application/json" \
  --data-binary "
home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000
home,room=Kitchen temp=21.0,hum=35.9,co=0i 1641024000
home,room=Living\ Room temp=21.4,hum=35.9,co=0i 1641027600
home,room=Kitchen temp=23.0,hum=36.2,co=0i 1641027600
home,room=Living\ Room temp=21.8,hum=36.0,co=0i 1641031200
home,room=Kitchen temp=22.7,hum=36.1,co=0i 1641031200
home,room=Living\ Room temp=22.2,hum=36.0,co=0i 1641034800
home,room=Kitchen temp=22.4,hum=36.0,co=0i 1641034800
home,room=Living\ Room temp=22.2,hum=35.9,co=0i 1641038400
home,room=Kitchen temp=22.5,hum=36.0,co=0i 1641038400
home,room=Living\ Room temp=22.4,hum=36.0,co=0i 1641042000
home,room=Kitchen temp=22.8,hum=36.5,co=1i 1641042000
home,room=Living\ Room temp=22.3,hum=36.1,co=0i 1641045600
home,room=Kitchen temp=22.8,hum=36.3,co=1i 1641045600
home,room=Living\ Room temp=22.3,hum=36.1,co=1i 1641049200
home,room=Kitchen temp=22.7,hum=36.2,co=3i 1641049200
home,room=Living\ Room temp=22.4,hum=36.0,co=4i 1641052800
home,room=Kitchen temp=22.4,hum=36.0,co=7i 1641052800
home,room=Living\ Room temp=22.6,hum=35.9,co=5i 1641056400
home,room=Kitchen temp=22.7,hum=36.0,co=9i 1641056400
home,room=Living\ Room temp=22.8,hum=36.2,co=9i 1641060000
home,room=Kitchen temp=23.3,hum=36.9,co=18i 1641060000
home,room=Living\ Room temp=22.5,hum=36.3,co=14i 1641063600
home,room=Kitchen temp=23.1,hum=36.6,co=22i 1641063600
home,room=Living\ Room temp=22.2,hum=36.4,co=17i 1641067200
home,room=Kitchen temp=22.7,hum=36.5,co=26i 1641067200
"

curl --request POST \
  http://localhost:8181/write?db=DATABASE_NAME
&precision=s \
  --header "Authorization: Bearer AUTH_TOKEN
" \
  --header "Content-type: text/plain; charset=utf-8" \
  --data-binary "
home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000
home,room=Kitchen temp=21.0,hum=35.9,co=0i 1641024000
home,room=Living\ Room temp=21.4,hum=35.9,co=0i 1641027600
home,room=Kitchen temp=23.0,hum=36.2,co=0i 1641027600
home,room=Living\ Room temp=21.8,hum=36.0,co=0i 1641031200
home,room=Kitchen temp=22.7,hum=36.1,co=0i 1641031200
home,room=Living\ Room temp=22.2,hum=36.0,co=0i 1641034800
home,room=Kitchen temp=22.4,hum=36.0,co=0i 1641034800
home,room=Living\ Room temp=22.2,hum=35.9,co=0i 1641038400
home,room=Kitchen temp=22.5,hum=36.0,co=0i 1641038400
home,room=Living\ Room temp=22.4,hum=36.0,co=0i 1641042000
home,room=Kitchen temp=22.8,hum=36.5,co=1i 1641042000
home,room=Living\ Room temp=22.3,hum=36.1,co=0i 1641045600
home,room=Kitchen temp=22.8,hum=36.3,co=1i 1641045600
home,room=Living\ Room temp=22.3,hum=36.1,co=1i 1641049200
home,room=Kitchen temp=22.7,hum=36.2,co=3i 1641049200
home,room=Living\ Room temp=22.4,hum=36.0,co=4i 1641052800
home,room=Kitchen temp=22.4,hum=36.0,co=7i 1641052800
home,room=Living\ Room temp=22.6,hum=35.9,co=5i 1641056400
home,room=Kitchen temp=22.7,hum=36.0,co=9i 1641056400
home,room=Living\ Room temp=22.8,hum=36.2,co=9i 1641060000
home,room=Kitchen temp=23.3,hum=36.9,co=18i 1641060000
home,room=Living\ Room temp=22.5,hum=36.3,co=14i 1641063600
home,room=Kitchen temp=23.1,hum=36.6,co=22i 1641063600
home,room=Living\ Room temp=22.2,hum=36.4,co=17i 1641067200
home,room=Kitchen temp=22.7,hum=36.5,co=26i 1641067200
"

替换示例脚本中的以下内容

DATABASE_NAME：要写入的数据库名称
AUTH_TOKEN：您的 InfluxDB 3 Core 授权令牌
在 Beta 阶段，InfluxDB 3 Core 不需要授权令牌。您可以省略 CLI --token 选项或 HTTP Authorization 标头，也可以提供任意令牌字符串。

家庭传感器动作数据

包括由快速入门家庭传感器数据中的数据触发的假设动作，并且是该示例数据集的配套数据集。要自定义数据集中的时间戳，请使用页面右下角的按钮。这使您可以修改示例数据集，使其保持在您写入的数据库的保留期内。

时间范围

2022-01-01T08:00:00Z 至 2022-01-01T20:00:00Z (可自定义)

模式

home_actions (表)
- 标签:
  - room
    - 厨房
    - 客厅
  - action
    - alert
    - cool
  - level
    - ok
    - warn
- 字段:
  - description (字符串)

将家庭传感器动作数据写入 InfluxDB

使用 influxdb3 CLI、InfluxDB v3 API、InfluxDB v2 API 或 InfluxDB v1 API 将家庭传感器动作示例数据写入 InfluxDB 3 Core。

influxdb3 v3 API v2 API v1 API

influxdb3 write \
  --token AUTH_TOKEN
 \
  --database DATABASE_NAME
 \
  'home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23°C). Cooling to 22°C." 1641027600
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.3°C). Cooling to 22°C." 1641060000
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.1°C). Cooling to 22°C." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 18 ppm." 1641060000
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 22 ppm." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 26 ppm." 1641067200
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 14 ppm." 1641063600
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 17 ppm." 1641067200'

curl -v "http://localhost:8181/api/v3/write_lp?db=sensors&precision=auto&accept_partial=true" \
  --data-raw "home_actions,room=Kitchen,action=cool,level=ok description=\"Temperature at or above 23°C (23°C). Cooling to 22°C.\" 1739437200
home_actions,room=Kitchen,action=cool,level=ok description=\"Temperature at or above 23°C (23.3°C). Cooling to 22°C.\" 1739469600
home_actions,room=Kitchen,action=cool,level=ok description=\"Temperature at or above 23°C (23.1°C). Cooling to 22°C.\" 1739473200
home_actions,room=Kitchen,action=alert,level=warn description=\"Carbon monoxide level above normal: 18 ppm.\" 1739469600
home_actions,room=Kitchen,action=alert,level=warn description=\"Carbon monoxide level above normal: 22 ppm.\" 1739473200
home_actions,room=Kitchen,action=alert,level=warn description=\"Carbon monoxide level above normal: 26 ppm.\" 1739476800
home_actions,room=Living Room,action=alert,level=warn description=\"Carbon monoxide level above normal: 14 ppm.\" 1739473200
home_actions,room=Living Room,action=alert,level=warn description=\"Carbon monoxide level above normal: 17 ppm.\" 1739476800"

curl --request POST \
  http://localhost:8181/api/v2/write?bucket=DATABASE_NAME
&precision=s \
  --header "Authorization: Bearer AUTH_TOKEN
" \
  --header "Content-Type: text/plain; charset=utf-8" \
  --header "Accept: application/json" \
  --data-binary '
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23°C). Cooling to 22°C." 1641027600
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.3°C). Cooling to 22°C." 1641060000
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.1°C). Cooling to 22°C." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 18 ppm." 1641060000
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 22 ppm." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 26 ppm." 1641067200
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 14 ppm." 1641063600
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 17 ppm." 1641067200
'

curl --request POST \
  http://localhost:8181/write?db=DATABASE_NAME
&precision=s \
  --header "Authorization: Bearer AUTH_TOKEN
" \
  --header "Content-type: text/plain; charset=utf-8" \
  --data-binary '
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23°C). Cooling to 22°C." 1641027600
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.3°C). Cooling to 22°C." 1641060000
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.1°C). Cooling to 22°C." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 18 ppm." 1641060000
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 22 ppm." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 26 ppm." 1641067200
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 14 ppm." 1641063600
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 17 ppm." 1641067200
'

替换示例脚本中的以下内容

DATABASE_NAME：要写入的数据库名称
AUTH_TOKEN：您的 InfluxDB 3 Core 授权令牌
在 Beta 阶段，InfluxDB 3 Core 不需要授权令牌。您可以省略 CLI --token 选项或 HTTP Authorization 标头，也可以提供任意令牌字符串。

NOAA 旧金山湾区天气数据

包括来自旧金山湾区三个机场的每日天气指标，时间范围为 2020 年 1 月 1 日至 2022 年 12 月 31 日。此示例数据集包含季节性趋势，非常适合探索涉及季节性的时间序列用例。

时间范围

2020-01-01T00:00:00Z 至 2022-12-31T00:00:00Z

模式

weather (表)
- 标签:
  - location
    - Concord
    - Hayward
    - San Francisco
- 字段
  - precip (浮点数)
  - temp_avg (浮点数)
  - temp_max (浮点数)
  - temp_min (浮点数)
  - wind_avg (浮点数)

将 NOAA 旧金山湾区天气数据写入 InfluxDB

比特币价格数据

比特币价格示例数据集提供 2023-05-01T00:00:00Z 至 2023-05-15T00:00:00Z 的比特币价格—数据来源 CoinDesk。

时间范围

2023-05-01T00:19:00Z 至 2023-05-14T23:48:00Z

模式

bitcoin (表)
- 标签:
  - code
    - EUR
    - GBP
    - USD
  - crypto
    - bitcoin
  - description
    - Euro
    - British Pound Sterling
    - United States Dollar
  - symbol
    - € (€)
    - £ (£)
    - $ ($)
- 字段
  - price (浮点数)

将比特币示例数据写入 InfluxDB

随机数示例数据

包括两个字段，其中包含每分钟报告的随机生成的数字。每个字段都有特定范围的随机生成数字。此示例数据集用于演示数学运算和转换函数。

时间范围

2023-01-01T00:00:00Z 至 2023-01-01T12:00:00Z

模式

numbers (表)
- 字段
  - a (介于 -1 和 1 之间的浮点数)
  - b (介于 -3 和 3 之间的浮点数)

将随机数示例数据写入 InfluxDB

此页内容是否对您有帮助？

感谢您的反馈！

支持与反馈

感谢您成为我们社区的一份子！我们欢迎并鼓励您提供关于 InfluxDB 3 Core 和本文档的反馈和错误报告。要寻求支持，请使用以下资源

拥有年度或支持合同的客户 可以联系 InfluxData 支持。

编辑此页提交文档问题提交 InfluxDB 3 Core 问题

示例数据

家庭传感器数据

时间范围

模式

将家庭传感器数据写入 InfluxDB

家庭传感器动作数据

时间范围

模式

将家庭传感器动作数据写入 InfluxDB

NOAA 旧金山湾区天气数据

时间范围

模式

将 NOAA 旧金山湾区天气数据写入 InfluxDB

比特币价格数据

时间范围

模式

将比特币价格示例数据写入 InfluxDB

随机数示例数据

时间范围

模式

将随机数示例数据写入 InfluxDB

支持与反馈

Flux 的未来

InfluxDB 3 Core 和 Enterprise

示例数据

家庭传感器数据

时间范围

模式

将家庭传感器数据写入 InfluxDB

家庭传感器动作数据

时间范围

模式

将家庭传感器动作数据写入 InfluxDB

NOAA 旧金山湾区天气数据

时间范围

模式

将 NOAA 旧金山湾区天气数据写入 InfluxDB

比特币价格数据

时间范围

模式

将比特币价格示例数据写入 InfluxDB

随机数示例数据

时间范围

模式

将随机数示例数据写入 InfluxDB

支持与反馈

您的 InfluxDB 3 Core URL 是什么？

默认

自定义

感谢您的反馈！

选择新日期

Flux 的未来

InfluxDB 3 Core 和 Enterprise