# \#influxql **URL:** https://community.influxdata.com/tag/influxql/28.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… --- ## [Set a tag with into command?](https://community.influxdata.com/t/set-a-tag-with-into-command/57905)
**Author:** [@itob](https://community.influxdata.com/u/itob)\ **Replies:** 7\ **Last updated:** [September 15, 2025, 2:43pm UTC](https://community.influxdata.com/t/set-a-tag-with-into-command/57905 "2025-09-15T14:43:15Z")
Hello, can I add a tag to all values in a measurement by command. I have exported all values without the tag “item” to temp: select \* into temp from hz\_mqtt\_aussentemp where item = '‘ and then wrote these values back… --- ## [What should be the strategy towards InfluxDb v3 with regards to Flux?](https://community.influxdata.com/t/what-should-be-the-strategy-towards-influxdb-v3-with-regards-to-flux/57217)
**Author:** [@donker](https://community.influxdata.com/u/donker)\ **Replies:** 3\ **Last updated:** [August 23, 2025, 7:47am UTC](https://community.influxdata.com/t/what-should-be-the-strategy-towards-influxdb-v3-with-regards-to-flux/57217 "2025-08-23T07:47:11Z")
I have convinced my client to move from MS SQL to InfluxDb for the project I am working on. This client now pays 100s per month for the cloud offering. As I am building out the project I stumble on “Flux now in maintenan… --- ## [Flux query: \_field has slash in name, cannot get value](https://community.influxdata.com/t/flux-query-field-has-slash-in-name-cannot-get-value/19996)
**Author:** [@ToWo](https://community.influxdata.com/u/ToWo)\ **Replies:** 8\ **Last updated:** [August 22, 2025, 6:20am UTC](https://community.influxdata.com/t/flux-query-field-has-slash-in-name-cannot-get-value/19996 "2025-08-22T06:20:22Z")
Hello, I am wondering how I can get the value out of a \_field which has slashes in his name, ie: r.\_field == “status\_information/last\_state\_change/days” my query looks like the following and I want to calculate a new … --- ## [Influxql DIFFERENCE wrong results](https://community.influxdata.com/t/influxql-difference-wrong-results/57610)
**Author:** [@tasoss](https://community.influxdata.com/u/tasoss)\ **Replies:** 2\ **Last updated:** [July 15, 2025, 9:12am UTC](https://community.influxdata.com/t/influxql-difference-wrong-results/57610 "2025-07-15T09:12:36Z")
Hello. I am using influxdb3 3.2.0, revision 1ca3168beee35b22fe62a3998cd3ed0d4ab65ac6 influxdb@tbsMachine:~$ influxdb3 query --database blindscanners -l influxql “SELECT pass FROM blindscannertimings order by tim… --- ## [Preferred query language moving forward](https://community.influxdata.com/t/preferred-query-language-moving-forward/57499)
**Author:** [@Adam\_Labus](https://community.influxdata.com/u/Adam_Labus)\ **Replies:** 1\ **Last updated:** [June 28, 2025, 1:08pm UTC](https://community.influxdata.com/t/preferred-query-language-moving-forward/57499 "2025-06-28T13:08:06Z")
I built my whole frontend app around Flux, thinking it to be the most future safe query language. Now with the version 3 rewrite, it’s support is dropped. Are queries better expressed in InfluxQL or in Flux? Which lang… --- ## [INFLUX Multiple Queries](https://community.influxdata.com/t/influx-multiple-queries/57427)
**Author:** [@uniquewaheed](https://community.influxdata.com/u/uniquewaheed)\ **Replies:** 1\ **Last updated:** [June 26, 2025, 9:36pm UTC](https://community.influxdata.com/t/influx-multiple-queries/57427 "2025-06-26T21:36:22Z")
Hello All, am using 4 different queries to display in table and I need to filter these queries according to my requirements to display Cisco BGP/CDP required value/fields in table. The required queries are mentioned bel… --- ## [Performance issues after migration from InfluxDB 1.8 to 2.7](https://community.influxdata.com/t/performance-issues-after-migration-from-influxdb-1-8-to-2-7/57193)
**Author:** [@davide.avella](https://community.influxdata.com/u/davide.avella)\ **Replies:** 1\ **Last updated:** [May 14, 2025, 10:22pm UTC](https://community.influxdata.com/t/performance-issues-after-migration-from-influxdb-1-8-to-2-7/57193 "2025-05-14T22:22:55Z")
Hello, through a specific procedure, I migrated data from an InfluxDB 1.8 instance deployed on a VM to an InfluxDB 2.7 instance deployed on AKS. The database has very high cardinality. The data starts from 2023 and inc… --- ## [The time window is confusing when use group by time()](https://community.influxdata.com/t/the-time-window-is-confusing-when-use-group-by-time/56937)
**Author:** [@cjx-great](https://community.influxdata.com/u/cjx-great)\ **Replies:** 1\ **Last updated:** [April 7, 2025, 4:24pm UTC](https://community.influxdata.com/t/the-time-window-is-confusing-when-use-group-by-time/56937 "2025-04-07T16:24:36Z")
Hi, I encountered some problems during the process of using InfluxDB. Could you please help me solve it? InfluxDB Version: 1.8.5 InfluxQL: Firstly, I searched a batch of data using non\_negative\_derivative: sel… --- ## [Summarize stateduration to have total "on" hours per day](https://community.influxdata.com/t/summarize-stateduration-to-have-total-on-hours-per-day/28779)
**Author:** [@Lorenzo\_Mao](https://community.influxdata.com/u/Lorenzo_Mao)\ **Replies:** 9\ **Last updated:** [March 27, 2025, 1:39am UTC](https://community.influxdata.com/t/summarize-stateduration-to-have-total-on-hours-per-day/28779 "2025-03-27T01:39:25Z")
0 i would like to write a query in flux that return the total “on” hours in each day. from(bucket: "hass") |\> range(start: v.timeRangeStart, stop: v.timeRangeStop) |\> filter(fn: (r) =\> r\["\_measurement"\] == "binary\_… --- ## [Detect constant streak of values](https://community.influxdata.com/t/detect-constant-streak-of-values/56293)
**Author:** [@Jerome](https://community.influxdata.com/u/Jerome)\ **Replies:** 3\ **Last updated:** [March 21, 2025, 4:48pm UTC](https://community.influxdata.com/t/detect-constant-streak-of-values/56293 "2025-03-21T16:48:24Z")
Hi. We use InfluxDB + Grafana to store and plot sensor values. We would like to detect when a given sensor returns a constant value, as this is typical of a faulty sensor. I’m setting a daily alert in Grafana using an … --- ## [Show amount of rain fall per hour](https://community.influxdata.com/t/show-amount-of-rain-fall-per-hour/38790)
**Author:** [@cortlieb](https://community.influxdata.com/u/cortlieb)\ **Replies:** 4\ **Last updated:** [February 19, 2025, 4:43pm UTC](https://community.influxdata.com/t/show-amount-of-rain-fall-per-hour/38790 "2025-02-19T16:43:16Z")
I already raised the question over in the Grafana community, but they recommended to ask here. Since it is mainly a question about the right query that makes probably sense. I have a rain sensor that sends every 10 minu… --- ## [InfluxDb2 on VM - 500 Internal Server Error: error calling function "limits"](https://community.influxdata.com/t/influxdb2-on-vm-500-internal-server-error-error-calling-function-limits/56221)
**Author:** [@dmorel](https://community.influxdata.com/u/dmorel)\ **Replies:** 2\ **Last updated:** [February 4, 2025, 8:36am UTC](https://community.influxdata.com/t/influxdb2-on-vm-500-internal-server-error-error-calling-function-limits/56221 "2025-02-04T08:36:44Z")
Hello, On my Ubuntu server, i have installed Influx V2 (InfluxDB v2.7.6 (git: 3c58c06206)) I have the CLI: Influx CLI dev (git: a79a2a1b825867421d320428538f76a4c90aa34c) I can run this query, i have results: influx que… --- ## [Making Grafana use influxql with InfluxDB2?](https://community.influxdata.com/t/making-grafana-use-influxql-with-influxdb2/53508)
**Author:** [@jerrac](https://community.influxdata.com/u/jerrac)\ **Replies:** 2\ **Last updated:** [January 22, 2025, 11:18pm UTC](https://community.influxdata.com/t/making-grafana-use-influxql-with-influxdb2/53508 "2025-01-22T23:18:17Z")
Hey all, I’m currently trying to get a solid test environment up for logs/metrics with InfluxDB2, telegraf, vector, and Grafana. I have been searching these forums and other locations for answers. There’s been a little… --- ## [Trying to show now and last year on the same graph](https://community.influxdata.com/t/trying-to-show-now-and-last-year-on-the-same-graph/38700)
**Author:** [@carmelo42](https://community.influxdata.com/u/carmelo42)\ **Replies:** 6\ **Last updated:** [January 21, 2025, 10:41am UTC](https://community.influxdata.com/t/trying-to-show-now-and-last-year-on-the-same-graph/38700 "2025-01-21T10:41:40Z")
Hi ! I have all my home automation data in an influx bucket. In grafana, I can show the last 24h temperatures from the “ext” sensor : from(bucket: "telegraf/autogen") |\> range(start: v.timeRangeStart, stop: … --- ## [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… --- ## [Select data within a daily time period](https://community.influxdata.com/t/select-data-within-a-daily-time-period/38648)
**Author:** [@permezel](https://community.influxdata.com/u/permezel)\ **Replies:** 4\ **Last updated:** [October 9, 2024, 6:15am UTC](https://community.influxdata.com/t/select-data-within-a-daily-time-period/38648 "2024-10-09T06:15:22Z")
Using grafana+influx in a container which collects daily info from my electrical system. I wish to select just the data between 14:00 and 21:00 for a particular month, so that I can determine the max value (amount of po… --- ## [Influxql query not working in php8.1 and influxdb2.x](https://community.influxdata.com/t/influxql-query-not-working-in-php8-1-and-influxdb2-x/37662)
**Author:** [@Dhaarini](https://community.influxdata.com/u/Dhaarini)\ **Replies:** 7\ **Last updated:** [September 25, 2024, 8:20am UTC](https://community.influxdata.com/t/influxql-query-not-working-in-php8-1-and-influxdb2-x/37662 "2024-09-25T08:20:51Z")
I’m trying to query data using influxql from influxdb 2.7 in php8.1 …while using flux query it works but when I use influxql query it throws error I have also done dbrp mapping $client = new Client(\[ “url” =\> “http:/… --- ## [I can't get rid of a ghost tag after performing a delete of records](https://community.influxdata.com/t/i-cant-get-rid-of-a-ghost-tag-after-performing-a-delete-of-records/35562)
**Author:** [@JeffAeon](https://community.influxdata.com/u/JeffAeon)\ **Replies:** 1\ **Last updated:** [September 10, 2024, 5:06pm UTC](https://community.influxdata.com/t/i-cant-get-rid-of-a-ghost-tag-after-performing-a-delete-of-records/35562 "2024-09-10T17:06:51Z")
Greetings all… I am pulling my hair out over having what appears to be a ghost tag after a purge of records where it existed. InfluxDB2 v 2.7.10 on Rocky 8.10 v2 bucket created with DBRP link created I used: influx … --- ## [Getting error connecting influxDB influxQL in Grafana](https://community.influxdata.com/t/getting-error-connecting-influxdb-influxql-in-grafana/35452)
**Author:** [@SahithiP](https://community.influxdata.com/u/SahithiP)\ **Replies:** 2\ **Last updated:** [August 29, 2024, 7:36am UTC](https://community.influxdata.com/t/getting-error-connecting-influxdb-influxql-in-grafana/35452 "2024-08-29T07:36:33Z")
Hi, I am facing below error while adding influxdb(1.8) datasource in grafana. I am not using any credentials to login to the database. i use influx command to login. Error connecting to influxdb influxdbQL. currently … --- ## [Querying multiple time points](https://community.influxdata.com/t/querying-multiple-time-points/35388)
**Author:** [@lvn2007](https://community.influxdata.com/u/lvn2007)\ **Replies:** 4\ **Last updated:** [August 20, 2024, 11:48pm UTC](https://community.influxdata.com/t/querying-multiple-time-points/35388 "2024-08-20T23:48:14Z")
Hello all, I’m currently using influxcxx client library to interact with InfluxDB v1.6.7~rc0. In my code, I have querying a single datapoint by timestamp (Target time is 946684800) as: SELECT \* FROM BENCH\_DB WHERE tim… --- ## [GROUP by time looking "backwards" from a specific timestamp](https://community.influxdata.com/t/group-by-time-looking-backwards-from-a-specific-timestamp/35211)
**Author:** [@cortlieb](https://community.influxdata.com/u/cortlieb)\ **Replies:** 5\ **Last updated:** [August 19, 2024, 12:46pm UTC](https://community.influxdata.com/t/group-by-time-looking-backwards-from-a-specific-timestamp/35211 "2024-08-19T12:46:38Z")
Dear experts, I’m storing data from a bunch of sensors in an InfluxDB database (to monitor them in Grafana). Besides the actual sensor readings I also want to monitor if the sensors are sending regularly new values, si… --- ## [How to filter on one field but include other fields in result](https://community.influxdata.com/t/how-to-filter-on-one-field-but-include-other-fields-in-result/35206)
**Author:** [@Evolutio](https://community.influxdata.com/u/Evolutio)\ **Replies:** 2\ **Last updated:** [August 7, 2024, 5:51am UTC](https://community.influxdata.com/t/how-to-filter-on-one-field-but-include-other-fields-in-result/35206 "2024-08-07T05:51:10Z")
Hello, how to filter following data where topics includes “account”: \[ { "host": "telegraf", "message": "package channel changed by winbox-3.41/mac-msg(winbox):admin@\[MAC\] (/system package update set channel=… --- ## [Getting incorrect time from InfluxQL query](https://community.influxdata.com/t/getting-incorrect-time-from-influxql-query/35136)
**Author:** [@Rishav\_Kumar\_Jha](https://community.influxdata.com/u/Rishav_Kumar_Jha)\ **Replies:** 5\ **Last updated:** [August 7, 2024, 4:50am UTC](https://community.influxdata.com/t/getting-incorrect-time-from-influxql-query/35136 "2024-08-07T04:50:28Z")
I have an influxQL query: SELECT sum(“metrics written”) FROM ( SELECT max(“metrics\_written”) - min(“metrics\_written”) as “metrics written” FROM “tsesre\_gms”.“anonymous”.“internal\_write” WHERE time \> now() - 5m AND “… --- ## [Dashboard filtering by tag when unset](https://community.influxdata.com/t/dashboard-filtering-by-tag-when-unset/35132)
**Author:** [@miogi](https://community.influxdata.com/u/miogi)\ **Replies:** 2\ **Last updated:** [August 2, 2024, 8:06am UTC](https://community.influxdata.com/t/dashboard-filtering-by-tag-when-unset/35132 "2024-08-02T08:06:22Z")
Hi, I may have kind of an impossible request here. we’ve been asked to make a dashboard that is filtered by a specific tag but sometimes as it’s a migration in progress the tag is not set. I defined a variable that ta… --- ## [Sudden 100% swap usage on influxdb](https://community.influxdata.com/t/sudden-100-swap-usage-on-influxdb/33093)
**Author:** [@vipinvkmenon](https://community.influxdata.com/u/vipinvkmenon)\ **Replies:** 3\ **Last updated:** [July 18, 2024, 4:38am UTC](https://community.influxdata.com/t/sudden-100-swap-usage-on-influxdb/33093 "2024-07-18T04:38:35Z")
We have a situation where the Swap has suddenly spiked up to 100%. When does such a situation occur and how do we debug this? During such scenario, the VM become unresponsive or slow. If I check the free -lh I see as fo… --- ## [Does telegraf - influx provide grouping?](https://community.influxdata.com/t/does-telegraf-influx-provide-grouping/34925)
**Author:** [@ukyanjo](https://community.influxdata.com/u/ukyanjo)\ **Replies:** 2\ **Last updated:** [July 12, 2024, 12:55am UTC](https://community.influxdata.com/t/does-telegraf-influx-provide-grouping/34925 "2024-07-12T00:55:48Z")
Hello, I could make tail plugin send grok patterned logs into influxDB thanks to your help. However, I came up with that I need to use grouping according to subdomains I extract from logs. request\_time="0.004",timestamp… --- ## [Logging not working properly](https://community.influxdata.com/t/logging-not-working-properly/34836)
**Author:** [@vicki](https://community.influxdata.com/u/vicki)\ **Replies:** 2\ **Last updated:** [July 9, 2024, 10:10am UTC](https://community.influxdata.com/t/logging-not-working-properly/34836 "2024-07-09T10:10:03Z")
Hi, Recently i enable logging with access-log-status-filters \[4xx and 5xx\], I received logs with 4xx and 5xx successfully, but and i receive 2xx logs also here’s my conf log-enabled = true access-log-status-filters =… --- ## [Query not giving errors, and not giving data](https://community.influxdata.com/t/query-not-giving-errors-and-not-giving-data/34617)
**Author:** [@ener](https://community.influxdata.com/u/ener)\ **Replies:** 8\ **Last updated:** [June 17, 2024, 11:44am UTC](https://community.influxdata.com/t/query-not-giving-errors-and-not-giving-data/34617 "2024-06-17T11:44:58Z")
I’m trying to gather a specific metric from InfluxDB using curl. The command I’m trying to use is curl -i -G ‘10.14.36.25:8090/query?db=netatmo’ --header “Authorization: Token MYTOKEN” --data-urlencode “q=SELECT \* FROM … --- ## [Is there somewhere an example to query data with influxql and R](https://community.influxdata.com/t/is-there-somewhere-an-example-to-query-data-with-influxql-and-r/34548)
**Author:** [@heid.tgg](https://community.influxdata.com/u/heid.tgg)\ **Replies:** 1\ **Last updated:** [June 11, 2024, 3:34pm UTC](https://community.influxdata.com/t/is-there-somewhere-an-example-to-query-data-with-influxql-and-r/34548 "2024-06-11T15:34:51Z")
I am able to use the r package influxdbclient to use flux-language. But how can I use InfluxQL? I am quite lost here. Also looking into the code did not help. There was only onw hint to influxql. Are there somewhere exa… [Next page](https://community.influxdata.com/tag/influxql/28.md?match_all_tags=true&page=1&tags%5B%5D=influxql)