influxdata / influxdata/docs-v2

Document how to handle type conflicts on write with v3

Open
#5,346 0 comments 0 reactions 0 assignees View on GitHub
InfluxDB v3
Dominant language
JavaScript
Stars
82
Forks
326
Avg merge
1d 1h
Merged PRs (30d)
82

Description

With InfluxDB v3 (and all previous version of InfluxDB), if you try to write data to a column using a different type that what's already in the column, it errs. With v3, because InfluxDB v3's SQL and InfluxQL implementations are read-only, you can't write queried/manipulated data back into the database at query time so you can't just cast the column to a new type and write it back in. You have to do one of the following:

- Query your data out of InfluxDB into an external tool/runtime, then write it back in.
- Store the data of a different type in a new column.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the InfluxDB v3 write and data-type documentation in this repository, then verify the stated behavior for type conflicts and the read-only SQL and InfluxQL implementations. Done means documenting the two supported alternatives: exporting data to an external tool or storing the different type in a new column.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases, documentation
Issue type
Documentation
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.