# \#schema **URL:** https://community.influxdata.com/tag/schema/20.md [Latest](https://community.influxdata.com/latest.md) · [Categories](https://community.influxdata.com/categories.md) · [Tags](https://community.influxdata.com/tags.md) --- ## [InfluxDB v2 Changing Fields Datatype](https://community.influxdata.com/t/influxdb-v2-changing-fields-datatype/58616)
**Author:** [@ticchioned](https://community.influxdata.com/u/ticchioned)\ **Replies:** 4\ **Last updated:** [June 19, 2026, 1:13pm UTC](https://community.influxdata.com/t/influxdb-v2-changing-fields-datatype/58616 "2026-06-19T13:13:20Z")
I am working on a tool to help convert datatypes in InfluxDB v2 but am running into an issue that I’m hoping someone from InfluxDB or the community is able to solve. The tool begins by reading, converting, and saving th… --- ## [Designing a Folder-Like Schema in InfluxDB for High-Volume Medical Time-Series Data, Emphasizing on Fast Read And Few Writes](https://community.influxdata.com/t/designing-a-folder-like-schema-in-influxdb-for-high-volume-medical-time-series-data-emphasizing-on-fast-read-and-few-writes/57213)
**Author:** [@Dariush\_Karamati](https://community.influxdata.com/u/Dariush_Karamati)\ **Replies:** 3\ **Last updated:** [May 30, 2025, 6:56pm UTC](https://community.influxdata.com/t/designing-a-folder-like-schema-in-influxdb-for-high-volume-medical-time-series-data-emphasizing-on-fast-read-and-few-writes/57213 "2025-05-30T18:56:28Z")
Hello :sun\_with\_face: I have around 100,000 numpy arrays each of approximate size \[3600 \* 256, 20\] which represents recordings with size around duration~3600 # one hour, and num\_channel~20, and sampling rate of Fs~256 # … --- ## [Timestamp schema for OpenTelemetry Logs to Telegraf](https://community.influxdata.com/t/timestamp-schema-for-opentelemetry-logs-to-telegraf/56935)
**Author:** [@vxmd](https://community.influxdata.com/u/vxmd)\ **Replies:** 1\ **Last updated:** [April 9, 2025, 1:48pm UTC](https://community.influxdata.com/t/timestamp-schema-for-opentelemetry-logs-to-telegraf/56935 "2025-04-09T13:48:07Z")
I’m using OpenTelemetry in Rust to write log messages to Telegraf 1.34.1 over gRPC. Log messages: \[...\] logs,host=m1,service.name=testapp body="The state of asset number 0 has been updated.",attributes="{\\"ask\\":\\"NaN\\"… --- ## [Merge fields into one row, even with different timestamps?](https://community.influxdata.com/t/merge-fields-into-one-row-even-with-different-timestamps/55980)
**Author:** [@ticchioned](https://community.influxdata.com/u/ticchioned)\ **Replies:** 0\ **Last updated:** [January 22, 2025, 3:32pm UTC](https://community.influxdata.com/t/merge-fields-into-one-row-even-with-different-timestamps/55980 "2025-01-22T15:32:44Z")
I have what is likely a rather trivial question, but for some reason it has me stuck. I am trying to add some filters to my query. I would like to essentially be able to filter on all of my fields values, sort of like … --- ## [Prefered ingest formating for performacne](https://community.influxdata.com/t/prefered-ingest-formating-for-performacne/39219)
**Author:** [@eriktar](https://community.influxdata.com/u/eriktar)\ **Replies:** 2\ **Last updated:** [November 21, 2024, 1:57pm UTC](https://community.influxdata.com/t/prefered-ingest-formating-for-performacne/39219 "2024-11-21T13:57:44Z")
Is there any performance read benefit to either of these two variants of ingesting data. Meaning will the way they are ingested impact the performance when extracting more of the data, such as “get the mean rtt for all … --- ## [Adding data into bucket with a CSV through UI](https://community.influxdata.com/t/adding-data-into-bucket-with-a-csv-through-ui/39449)
**Author:** [@ydorian](https://community.influxdata.com/u/ydorian)\ **Replies:** 0\ **Last updated:** [November 21, 2024, 11:17am UTC](https://community.influxdata.com/t/adding-data-into-bucket-with-a-csv-through-ui/39449 "2024-11-21T11:17:56Z")
I am new to Influx and am trying to add data into a database through a CSV file. When adding the data I keep getting the error: error in csv.from(): failed to read metadata: column “LapTime” has invalid datatype: unsuppo… --- ## [Schema Design & Metadata](https://community.influxdata.com/t/schema-design-metadata/38735)
**Author:** [@jsever](https://community.influxdata.com/u/jsever)\ **Replies:** 10\ **Last updated:** [October 18, 2024, 7:14pm UTC](https://community.influxdata.com/t/schema-design-metadata/38735 "2024-10-18T19:14:08Z")
I’m trying to store data from a Rockwell PLC that uses PlantPAx libraries in the PLC code that follow an S88 structure/nomenclature. This means that 95-100% of all points come from Control Modules. There are many contr… --- ## [Telegraf issue parsing child policy QoS classes data](https://community.influxdata.com/t/telegraf-issue-parsing-child-policy-qos-classes-data/38779)
**Author:** [@George\_Maged](https://community.influxdata.com/u/George_Maged)\ **Replies:** 3\ **Last updated:** [October 16, 2024, 11:35am UTC](https://community.influxdata.com/t/telegraf-issue-parsing-child-policy-qos-classes-data/38779 "2024-10-16T11:35:00Z")
Hello community, I am facing an issue of parsing the child classes QoS from the Cisco\_telemetry\_mdt input plugin. I am using embedded tags but unfortunately all what i reach is having only class-default as the only chi… --- ## [WITH MEASUREMENTS clause returns no results when named measurement is clearly there](https://community.influxdata.com/t/with-measurements-clause-returns-no-results-when-named-measurement-is-clearly-there/38677)
**Author:** [@smartcasa](https://community.influxdata.com/u/smartcasa)\ **Replies:** 2\ **Last updated:** [October 14, 2024, 10:00pm UTC](https://community.influxdata.com/t/with-measurements-clause-returns-no-results-when-named-measurement-is-clearly-there/38677 "2024-10-14T22:00:21Z")
I can’t figure out why my “WITH MEASUREMENT” clause is not working. Very simple example: This works: SHOW MEASUREMENTS When I add filter I get no results SHOW MEASUREMENTS WITH MEASUREMENT = "binary\_sensor" I… --- ## [Get shard Manifest without backup (field type conflict problem)](https://community.influxdata.com/t/get-shard-manifest-without-backup-field-type-conflict-problem/35569)
**Author:** [@DavidHy](https://community.influxdata.com/u/DavidHy)\ **Replies:** 3\ **Last updated:** [September 18, 2024, 6:20am UTC](https://community.influxdata.com/t/get-shard-manifest-without-backup-field-type-conflict-problem/35569 "2024-09-18T06:20:05Z")
Hi Running InfluxDB 2.7 in a container I’m having trouble some times getting a field type conflict when starting up. it’s an annoying problem but I’m willing to live with it by deleting and writing the data as it’s a p… --- ## [Data Storage Schema](https://community.influxdata.com/t/data-storage-schema/35390)
**Author:** [@vinh\_lee](https://community.influxdata.com/u/vinh_lee)\ **Replies:** 4\ **Last updated:** [August 26, 2024, 11:10pm UTC](https://community.influxdata.com/t/data-storage-schema/35390 "2024-08-26T23:10:59Z")
Hi alls! I have been working with influxdb for few months, and sometimes, I still find myself struggling to define which ones is tag and which ones is field. I have been reading many articles to understand it. Let say … --- ## [InfluxDB API - Http POST resquest - Timestamp precision problem](https://community.influxdata.com/t/influxdb-api-http-post-resquest-timestamp-precision-problem/34801)
**Author:** [@star\_board](https://community.influxdata.com/u/star_board)\ **Replies:** 2\ **Last updated:** [July 8, 2024, 8:14pm UTC](https://community.influxdata.com/t/influxdb-api-http-post-resquest-timestamp-precision-problem/34801 "2024-07-08T20:14:58Z")
I am trying to write data to the InfluxDB API via http POST requests. But I am having problems with the precision used for the timestamps of the data entry. Currently I have specified on the request url the precision a… --- ## [Need help with Global Server List](https://community.influxdata.com/t/need-help-with-global-server-list/34814)
**Author:** [@ozdeadmeat](https://community.influxdata.com/u/ozdeadmeat)\ **Replies:** 3\ **Last updated:** [July 8, 2024, 8:07pm UTC](https://community.influxdata.com/t/need-help-with-global-server-list/34814 "2024-07-08T20:07:10Z")
Hi all, I am looking for some help on my data structure as well as methods to get a more meaningful result on my my geomap in Grafana. I am using powershell and node-red to scrape a website for server information. I am… --- ## [Store multiple fields or store as single concatenated string?](https://community.influxdata.com/t/store-multiple-fields-or-store-as-single-concatenated-string/33896)
**Author:** [@Suvab\_Baral](https://community.influxdata.com/u/Suvab_Baral)\ **Replies:** 1\ **Last updated:** [April 12, 2024, 10:19pm UTC](https://community.influxdata.com/t/store-multiple-fields-or-store-as-single-concatenated-string/33896 "2024-04-12T22:19:37Z")
I have a requirement for storing baseband data received from UWB sensor. The data received is around 80 complex data per frame. I was analyzing the two possible schema since field values do not support array datatype i… --- ## [Schema Design for IoT Metrics](https://community.influxdata.com/t/schema-design-for-iot-metrics/2134)
**Author:** [@resteeee](https://community.influxdata.com/u/resteeee)\ **Replies:** 9\ **Last updated:** [February 12, 2024, 5:07pm UTC](https://community.influxdata.com/t/schema-design-for-iot-metrics/2134 "2024-02-12T17:07:44Z")
Hi guys, We are planning to use InfluxDB as a storage for IoT data (sensors and different measurements). We have that situation: 3000 Devices Each “typical” device has 8 sensors, (4 temperature sensors, 4 Power consu… --- ## [Filtering incomming data with JSON Schema](https://community.influxdata.com/t/filtering-incomming-data-with-json-schema/33001)
**Author:** [@bletvaska](https://community.influxdata.com/u/bletvaska)\ **Replies:** 2\ **Last updated:** [January 29, 2024, 9:19pm UTC](https://community.influxdata.com/t/filtering-incomming-data-with-json-schema/33001 "2024-01-29T21:19:05Z")
hello i am bit new to telegraf. till now i used it mostly for collecting system metrics. currently i am facing following problem: from several resources/devices i am collecting measurements in form of JSON data. these … --- ## [InfluxDB CPU Usage High with constant load](https://community.influxdata.com/t/influxdb-cpu-usage-high-with-constant-load/32938)
**Author:** [@niroshanh](https://community.influxdata.com/u/niroshanh)\ **Replies:** 0\ **Last updated:** [January 24, 2024, 3:00pm UTC](https://community.influxdata.com/t/influxdb-cpu-usage-high-with-constant-load/32938 "2024-01-24T15:00:39Z")
I have deployed an InfluxDB 1.7.9 (and has same issue with InfluxDB 1.8.5) in docker with a constant load at all times. But my CPU Usage increases suddenly after some time and remains high. The docker-compose.yml file se… --- ## [Label sensor data as fields or use tags?](https://community.influxdata.com/t/label-sensor-data-as-fields-or-use-tags/32775)
**Author:** [@tomshanley](https://community.influxdata.com/u/tomshanley)\ **Replies:** 1\ **Last updated:** [January 12, 2024, 7:40pm UTC](https://community.influxdata.com/t/label-sensor-data-as-fields-or-use-tags/32775 "2024-01-12T19:40:42Z")
I am designing a database schema for a project but I can’t chose between two different options. In short, I have 16 leaching columns setup, each with about 20 sensors for temp, pH, flow etc. Should I store each sensor… --- ## [How to document metrics output from an application?](https://community.influxdata.com/t/how-to-document-metrics-output-from-an-application/32586)
**Author:** [@DHa](https://community.influxdata.com/u/DHa)\ **Replies:** 0\ **Last updated:** [December 22, 2023, 7:59am UTC](https://community.influxdata.com/t/how-to-document-metrics-output-from-an-application/32586 "2023-12-22T07:59:46Z")
We have a number of applications, each with a medium-sized set of metrics being outputted. Some metrics are common to all applications, like ‘uptime’, while most metrics are custom. We have found it difficult to mainta… --- ## [Assess InfluxDB support for high scale](https://community.influxdata.com/t/assess-influxdb-support-for-high-scale/32550)
**Author:** [@Priyam\_Vora](https://community.influxdata.com/u/Priyam_Vora)\ **Replies:** 0\ **Last updated:** [December 19, 2023, 5:09pm UTC](https://community.influxdata.com/t/assess-influxdb-support-for-high-scale/32550 "2023-12-19T17:09:50Z")
Hello InfluxDB Support, I want to use InfluxDB for the following use-case. Please help me answers questions based on this use-case. I am planning to use InfluxDB on AWS (Probably I can use influx 3.0) “I have 3000 uniq… --- ## [Data in a Measurement](https://community.influxdata.com/t/data-in-a-measurement/32416)
**Author:** [@nicfio](https://community.influxdata.com/u/nicfio)\ **Replies:** 2\ **Last updated:** [December 12, 2023, 7:58am UTC](https://community.influxdata.com/t/data-in-a-measurement/32416 "2023-12-12T07:58:54Z")
Hello everyone, we have organized a data collection sinking into a influxdb instance. A bucket is a single source with a predefined list of columns. A measurement is a collection of data from the specified bucket: so … --- ## [Count all TagValues for each TagKey in all Measurements of a Bucket](https://community.influxdata.com/t/count-all-tagvalues-for-each-tagkey-in-all-measurements-of-a-bucket/32387)
**Author:** [@levinkerschberger](https://community.influxdata.com/u/levinkerschberger)\ **Replies:** 1\ **Last updated:** [December 5, 2023, 4:52pm UTC](https://community.influxdata.com/t/count-all-tagvalues-for-each-tagkey-in-all-measurements-of-a-bucket/32387 "2023-12-05T16:52:04Z")
Hi Flux-Forum, While creating a selfmonitoring-dashboard for the influx-instances of a customer, I stumbled across a challenging task. Because the customer can´t control how much tagValues are written into a measuremen… --- ## [Writing my first schema. Tags confuse me](https://community.influxdata.com/t/writing-my-first-schema-tags-confuse-me/32094)
**Author:** [@codejoy](https://community.influxdata.com/u/codejoy)\ **Replies:** 6\ **Last updated:** [November 17, 2023, 1:02am UTC](https://community.influxdata.com/t/writing-my-first-schema-tags-confuse-me/32094 "2023-11-17T01:02:24Z")
I am trying to wrap my head around all this newness. I see some examples like the airTemps example and I think my biggest confusion is on Tags. Are they required? For instance we have weather stations on site. They … --- ## [High memory usage on TSI mode](https://community.influxdata.com/t/high-memory-usage-on-tsi-mode/16521)
**Author:** [@kwubctdt](https://community.influxdata.com/u/kwubctdt)\ **Replies:** 5\ **Last updated:** [November 16, 2023, 5:48am UTC](https://community.influxdata.com/t/high-memory-usage-on-tsi-mode/16521 "2023-11-16T05:48:45Z")
We are running a stress test with importing certain amount of history records from scratch using InfluxDB v1.8.3 OSS. The goal of the test is to discover the needed parameters to set and the hardware spec in order to gai… --- ## [Organizing multiple-tagged data?](https://community.influxdata.com/t/organizing-multiple-tagged-data/32104)
**Author:** [@fira](https://community.influxdata.com/u/fira)\ **Replies:** 1\ **Last updated:** [November 15, 2023, 12:13am UTC](https://community.influxdata.com/t/organizing-multiple-tagged-data/32104 "2023-11-15T00:13:12Z")
Hello! Working with a small project and I’m having difficulties using the exported data, could use some advice! The usecase: we have multiple-tagged data that we want to aggregate and graph by mean/sum Picture a bakery… --- ## [Incremental Backups in 2.x OSS](https://community.influxdata.com/t/incremental-backups-in-2-x-oss/31887)
**Author:** [@ticchioned](https://community.influxdata.com/u/ticchioned)\ **Replies:** 0\ **Last updated:** [October 20, 2023, 2:38pm UTC](https://community.influxdata.com/t/incremental-backups-in-2-x-oss/31887 "2023-10-20T14:38:22Z")
I was wondering if there is anyway to do incremental backups on a 2.x OSS influx server? Even if it isn’t built into the system, would there be a way to inspect if specific shards changed and then a way to only backup t… --- ## [Yield Within a Reduce or Map Function](https://community.influxdata.com/t/yield-within-a-reduce-or-map-function/31286)
**Author:** [@ticchioned](https://community.influxdata.com/u/ticchioned)\ **Replies:** 2\ **Last updated:** [August 31, 2023, 7:10pm UTC](https://community.influxdata.com/t/yield-within-a-reduce-or-map-function/31286 "2023-08-31T19:10:01Z")
I am creating an event management system that is responsible for (1) detecting when data has arrived to Influx, (2) letting a client know there is data waiting, and (3) then allowing the client to query the data from the… --- ## [Bucket Creation for Multiple Client](https://community.influxdata.com/t/bucket-creation-for-multiple-client/31089)
**Author:** [@kushpatel](https://community.influxdata.com/u/kushpatel)\ **Replies:** 2\ **Last updated:** [August 10, 2023, 6:26am UTC](https://community.influxdata.com/t/bucket-creation-for-multiple-client/31089 "2023-08-10T06:26:26Z")
Currently I’m using community edition of influxDB. We have 2 clients whose data we are managing in influxDB. We have created 2 buckets for each client. One bucket to store Raw data and second bucket to store processed … --- ## [DROP MEASUREMENT for InfluxDB 2.x?](https://community.influxdata.com/t/drop-measurement-for-influxdb-2-x/11399)
**Author:** [@dswarbrick](https://community.influxdata.com/u/dswarbrick)\ **Replies:** 14\ **Last updated:** [July 18, 2023, 6:55pm UTC](https://community.influxdata.com/t/drop-measurement-for-influxdb-2-x/11399 "2023-07-18T18:55:44Z")
I’ve searched high and low, and I cannot find anything in InfluxDB 2.x that is equivalent to InfluxDB 1.x DROP MEASUREMENT. I realise I can drop buckets, but that seems like a fairly coarse approach if you simply want to… --- ## [Load data in influxdb and update later](https://community.influxdata.com/t/load-data-in-influxdb-and-update-later/30605)
**Author:** [@h5py](https://community.influxdata.com/u/h5py)\ **Replies:** 2\ **Last updated:** [July 14, 2023, 5:57am UTC](https://community.influxdata.com/t/load-data-in-influxdb-and-update-later/30605 "2023-07-14T05:57:49Z")
For following use case, I’m not sure about best approach: I load data from a REST-Api per minute and save them to influxdb. It’s about 99 different datapoints per minute (mixture of string, integer, float). Example: d… [Next page](https://community.influxdata.com/tag/schema/20.md?match_all_tags=true&page=1&tags%5B%5D=schema)