InfluxDB 2.x: Map unmapped buckets (DBRP / InfluxDB 1.x compatibility): Unterschied zwischen den Versionen
Aus Wiki-WebPerfect
Admin (Diskussion | Beiträge) K |
Admin (Diskussion | Beiträge) |
||
Zeile 4: | Zeile 4: | ||
'''API''' | '''API''' | ||
− | curl --request POST http://localhost:< | + | curl --request POST http://localhost:<INFLUXDB_PORT>/api/v2/dbrps \ |
--header "Authorization: Token <YOUR_TOKEN>" \ | --header "Authorization: Token <YOUR_TOKEN>" \ | ||
--header 'Content-type: application/json' \ | --header 'Content-type: application/json' \ | ||
Zeile 40: | Zeile 40: | ||
== List all retention policy mappings == | == List all retention policy mappings == | ||
'''API''' | '''API''' | ||
− | curl --request GET http://localhost: | + | curl --request GET http://localhost:<INFLUXDB_PORT>/api/v2/dbrps?orgID=<YOUR_ORGANISATION_ID> \ |
--header "Authorization: Token <YOUR_TOKEN>" \ | --header "Authorization: Token <YOUR_TOKEN>" \ | ||
Aktuelle Version vom 1. Februar 2022, 16:13 Uhr
If you want to query an InfluxDB 2.x with the query language InfluxQL you have to create a map for your bucket.
In InfluxDB 1.x, data is stored in databases and retention policies. In InfluxDB OSS 2.0, data is stored in buckets. Because InfluxQL uses the 1.x data model, before querying in InfluxQL, a bucket must be mapped to a database and retention policy (DBRP).
If you don't create this mapping, an error will occurs, because influx can't find the database.
API
curl --request POST http://localhost:<INFLUXDB_PORT>/api/v2/dbrps \ --header "Authorization: Token <YOUR_TOKEN>" \ --header 'Content-type: application/json' \ --data '{ "bucketID": "<YOUR_BUCKET_ID>", "database": "<YOUR_BUCKET_NAME>", "default": true, "orgID": "<YOUR_ORGANISATION_ID>", "retention_policy": "<YOUR_RETENTION_POLICY_FOR_MAPPING>" }'
Source: https://docs.influxdata.com/influxdb/v2.1/query-data/influxql/#map-unmapped-buckets
CLI
influx v1 dbrp create \ --db <YOUR_BUCKET_NAME> \ --rp <YOUR_RETENTION_POLICY_FOR_MAPPING> \ --bucket-id <YOUR_BUCKET_ID> \ --default
Important
Following InfluxQL queries are unsupported:
- SELECT INTO
- ALTER
- CREATE
- DROP (limited support)
- GRANT
- KILL
- REVOKE
List all retention policy mappings
API
curl --request GET http://localhost:<INFLUXDB_PORT>/api/v2/dbrps?orgID=<YOUR_ORGANISATION_ID> \ --header "Authorization: Token <YOUR_TOKEN>" \
CLI
influx v1 dbrp list --org-id <YOUR_ORGANISATION_ID> -t <YOUR_TOKEN>
Remove a retention policy mapping
CLI
influx v1 dbrp delete --id <DBRP_ID> --org-id <YOUR_ORGANISATION_ID> -t <YOUR_TOKEN>