influx Shell command language 250724

time = ,

<> ,
 != , > , >= , <

or <=

> 
    now() -duration_unit

: w d h m s ms u ns (No month code.)
All time in InfluxDB is UTC. For EasternTime use: tz('America/New_York)

It is not necessary to include tz(…) if influx is invokled with -precision rfc3339
Example if tz is specified:
'yyyy-mm-dd[Thh:mm:ss-hh:00'

'2021-03-23T00:10:00-04:00'

'2021-03-23'

'yyyy-mm-dd[ hh:mm:ss[.thmuuunnn ^†]'

'yyyy-mm-dd[Thh:mm:ss[.thmuuunnnZ']

… time > '2019-03-26' and time  <='2019-03-26 17:01:00'

… time > '2019-03-26T17:00:08.960Z' limit 1
time                     floor
----                     -----
2019-03-26T17:00:08.964Z 44

… time > '2019-03-26T17:00:08.965Z' limit 1
time                     floor
----                     -----
2019-03-26T17:00:19.062Z 44 


… time >= now()-2h GROUP BY time(10m)   requires at least one aggregate function.

MEAN( ) from ruuvi_measurements GROUP By time … for each time(12m) interval : faster too!

SELECT MEAN(batteryVoltage) FROM ruuvi_measurements WHERE … GROUP BY *^† ,time(12m) LIMIT 2 ;


SELECT round( (32+( (9/5)*(temperature)) )*10 )/10 , mean(batteryVoltage)*100 as volts FROM ruuvi_measurements 
    WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND 
          "mac"='E4D56DEC6E29'  
            group by  *,time(6h)

now() - 7d

where does not support or for multiple time ranges.

Examples:

cURL connects to a running database engine>
Either can be run from a remote system

into

Copy data from one database to another.
The backreference syntax (:MEASUREMENT) maintains the source measurement names in the destination .
When copying large amounts of data, avoid running out of memory by running INTO queries with different measurements or time boundaries with the WHERE.

Example: SELECT "water_level" INTO "h2o_feet_copy_1" FROM "h2o_feet" WHERE "location" = 'coyote_creek'.
h2o_feet_copy_1 is a new new measurement
Result displays number of points and a meaningless timestamp.

downsampling

Aggregations With text fields (like `MAC`) returns `null`
`COUNT(` Don't use * select count(batteryVoltage) from ruuvi_measurements where time >= now()-3h name: ruuvi_measurements ------------------------ time count 2018-12-08T20:50:15.11-05:00 6125
`DISTINCT(` Cannot be combined with other functions or fields, not even another `DISTINCT` . `count(distinct( field))` is OK Will report the earliest time if a range is specified. select distinct(batteryVoltage) from ruuvi_measurements where mac = 'E49ED586E4CE' and time < '2024-08-01' and time > '2024-05-01' name: ruuvi_measurements time distinct ---- -------- 2024-08-01T00:00:00.000000001Z 2.929 202.-08-01T00:00:00.000000001Z 2.935 2024-08-01T00:00:00.000000001Z 2.917 2024-08-01T00:00:00.000000001Z 2.911
`INTEGRAL( [ * \|`	`*` average
`INTEGRAL( field_key \| /regular_expression/ ] [ , unit ]`	area under the curve for subsequent field values and converts those results into the summed area per unit.
`MEAN(` no function AVERAGE	`MEDIAN(` half data lower	`MODE(` most frequent.
`STDDEV(`	`SUM(`
`SPREAD(`	difference between the minimum and maximum

Selectors Selecting a field and a selected field, value for both fields will be from the row of the selected field. For example: 2023-01-13T16:48:17.121272389-05:00 21.79 3.091 2023-01-13T16:49:24.152548228-05:00 21.78 3.067 2023-01-13T16:50:27.597212999-05:00 21.8 3.079 2023-01-13T16:51:29.770300218-05:00 21.82 3.074 2023-01-13T16:52:34.458392959-05:00 21.84 3.0730000000000004 select temperature,min(batteryVoltage) from ruuvi_measurements time temperature min 2023-01-13T07:52:16.446954713-05:00 21.38 3.0730000000000004 select round(batteryVoltage100)/100 from ruuvi_measurements where mac='D5413D44ADCE' and time > '2025-05-06 10:00:01' limit 50 tz('America/New_York') When selection returns values from different rows for the different fields `1969-12-31T19:00:00-05:00` is returned as the time. select first(temperature),last(batteryVoltage) from ruuvi_measurements time first last 1969-12-31T19:00:00-05:00* 26.49 2.486
Influx Data
String Functions
`SAMPLE( field,n`	randomly select values	`TOP( field,n`	greatest `n` values cannot be used with another function (not even bottom
`PERCENTILE( field,n`	value that is larger than `n` percent of the field values	`BOTTOM( field,n`	smallest `n` values cannot be used with another function (not even top
`MIN(`		`FIRST(`	oldest
		select FIRST(temperature) from ruuvi_measurements where mac='D48B9C6C230E' name: ruuvi_measurements time first ---- ----- 2018-10-03T01:19:46.678Z 25.04
`MAX(`		`LAST(`	newest
		select LAST(temperature) from ruuvi_measurements where mac='D48B9C6C230E' name: ruuvi_measurements time last ---- ---- 2018-12-02T21:33:26.728Z 23.52

 select count(batteryVoltage),percentile(batteryVoltage,10), min(batteryVoltage),mean(batteryVoltage),max(batteryVoltage),stddev(batteryVoltage) 
    from ruuvi_measurements where  batteryVoltage<1.78 and time > '2021-01-01' and mac='E9383FDD20BC' 
name: ruuvi_measurements
time                                count percentile min   mean    max   stddev
----                                ----- ---------- ---   ----    ---   ------
2021-01-01T00:00:00.000000001-05:00 16    1.743      1.729 1.76225 1.778 0.013542525613784159

select mac,ceil(pressure/100),ceil(batteryVoltage*100)/100,ceil(temperature*9/5)+32,ceil(humidity) 
    from ruuvi_measurements  
    where time > NOW()-1m  group by mac limit 5

Transformations
`CEILING(` rounded up	`ROUND(`	`FLOOR(` rounded down
`CUMULATIVE_SUM(`
`DERIVATIVE( unit: 1s, nonNegative: true, columns: ["_value"], timeColumn: "_time") returns rate of change, N-1 values.`
`NON_NEGATIVE_DERIVATIVE(`	`[NON_]NEGATIVE_DIFFERENCE(`
`HISTOGRAM(`	`MOVING_AVERAGE(`
`ELAPSED(` measurementUpdateLimit=30000 select elapsed(humidity,1s) from ruuvi_measurements where time > now() -5m group by mac limit 3 tags: mac=C7103C6824C2 time elapsed ---- ------- 2019-12-07T18:44:12.041362137-05:00 32 2019-12-07T18:44:46.980645189-05:00 34 2019-12-07T18:45:14.355036496-05:00 27 tags: mac=D6F3DADAC85E 2019-12-07T18:44:28.991358158-05:00 36 2019-12-07T18:45:01.200742424-05:00 32 2019-12-07T18:45:33.299000051-05:00 32 tags: mac=E9383FDD20BC 2019-12-07T18:44:15.1649262-05:00 39 2019-12-07T18:44:46.980645189-05:00 31 2019-12-07T18:45:25.192936173-05:00 38

Predictors
`HOLT_WINTERS(`

sigQUIT (usually ^\) while a query is running causes influx to output partial results like:

ERR: -12-31T00:31:48.091-05:00","D3517872EC0F",33],
["2018-12-31T00:31:58.171-05:00","D3517872EC0F",33],["2018-12-31T00:32:08.251-05:00","D3517872EC0F",33],
 ["2018-12-31T00:32:18.359-05:00","D3517872EC0F",33],["2018-12-31T00:32:28.463-05:00","D3517872EC0F",33],
  ["2018-12-31T00:32:38.566-05:00","D3517872EC0F",33],["2018-12-31T00:32:48.679-05:00","D3517872EC0F",33],
    ["2018-12-31T00:34:39.727-05:00","D3517872EC0F",33],["2018-12-31T00:34:49.818-05:00","D3517872EC0F",33], 
       ["2018-12-31T00:35:00.396-05:00"…

`Retention Policy`

Unique per database, define:

duration: how long data is kept, example 4320h0m0s (180 days) must be greater than 1h
replication factor: how many copies of this data is stored in the cluster and the
shard group duration: time range covered by shard groups.
sduration must be greater than 1h, defaults to 1h if duration < 2d; 7d if duration > 6m and 1d otherwise.

When a database is created, the default is autogen with infinite duration, replication factor of 1, and shard group duration of 7 days (7*24=168h).

ALTER [CREATE] RETENTION POLICY retention_policy_name ON database_name DURATION duration REPLICATION n [SHARD DURATION sduration] [DEFAULT]

GornellVT
 SHOW RETENTION POLICIES on ruuvi
name    duration shardGroupDuration replicaN default
----    -------- ------------------ -------- -------
autogen 0s^†       168h0m0s           1        true
> alter retention policy autogen on ruuvi DURATION 18240h
> SHOW RETENTION POLICIES on ruuvi
name    duration   shardGroupDuration replicaN default
----    --------   ------------------ -------- -------
autogen 18240h0m0s 168h0m0s           1        true

> SHOW RETENTION POLICIES on ruuvi
name    duration shardGroupDuration replican default
----    -------- ------------------ -------- -------
autogen 0s       168h0m0s           1        true

alter retention policy autogen on ruuvi DURATION 4320h   # 180 days 1/2 year,  (365+25)= 9360h (365*2+30)= 18240h
autogen 4320h0m0s 168h0m0s           1        true    aka  500d  (((365+132))

SHOW DATABASES SHOW FIELD KEYS SHOW SERIES [ON database_name] [FROM_clause] [WHERE tag_key operator [ 'tag_value' | regular_expression]] [LIMIT_clause] [OFFSET_clause]

SHOW MEASUREMENTS [ON database_name] [WITH MEASUREMENT regular_expression] [WHERE tag_key operator ['tag_value' | regular_expression]] [LIMIT_clause] [OFFSET_clause

SHOW TAG KEYS [ON database_name] [FROM_clause] [WHERE tag_key operator ['tag_value' | regular_expression]] [LIMIT_clause] [OFFSET_clause]

SHOW TAG VALUES [ON database_name][FROM_clause] WITH KEY [ [operator "tag_key" | regular_expression] | [IN ("tag_key1","tag_key2")]] [WHERE tag_key operator ['tag_value' | regular_expression]] [LIMIT_clause] [OFFSET_clause]

SHOW FIELD KEYS [ON database_name] [FROM measurement_name] SHOW RETENTION POLICIES on ruuvi;

name    duration   shardGroupDuration replicaN default
----    --------   ------------------ -------- -------
autogen 18240h0m0s 168h0m0s           1        true

from pi zero 3/27/19 InfluxDB shell version: 1.7.4 , ` influx_inspect, chronograf

inport CSV data

`auth`	Prompt for username and password
`use db_name`
`format [json\| csv \| column ]`	Format of the server responses. CSV vi fixup variable for width fractional seconds:`%s/\.\d\{2,9\}-05:00//`
`precision [rfc3339\|h\|m\|s\|ms\|u\|ns]`	format of the timestamp
`pretty`	Toggle pretty print for the json format
`chunked`	Turn on chunked responses from server
`chunk size size`	0 to reset to the default.
`consistency [any\|one\|quorum\|all`	Write consistency level.
`history`	Command history.
`settings`	Example: Setting Value -------- -------- Host localhost:8086 Username Database ruuvi RetentionPolicy see SHOW RETENTION POLICIES on ruuvi Pretty false Format column Write Consistency all Chunked true Chunk Size 0 `Write Consistency` : number of nodes that must confirm the write. If the requirement is not met the return value will be either partial write if some points in the batch fail or write failure if all points in the batch fail. `$INFLUXDB_GRAPHITE_CONSISTENCY_LEVEL` see the Query String Parameters for Writes
`clear`	settings such as database or retention policy. # Clear the database context clear database clear db # Clear the retention policy context clear retention policy clear rp
`connect host:port`	Connect to another node.
`exit \|quit\|^d`
`show [databases \| series \| measurements \| tag keys \| field keys ]`
??	there dsoes not seem to be a command to source a bunch of cimmands from a flie. DGG 7/13/25

`ALTER`
`ASC`	`ALL`	`ANY`	`AS`	`BEGIN`
`CONTINUOUS`	`CREATE`	`DELETE^†`	`DESTINATIONS`	`DIAGNOSTICS`	`DATABASE`	`DATABASES`
`DISTINCT`	`DEFAULT`	`DESC`	`DROP`	`DURATION`	`END`	`EVERY`
`EXPLAIN`	`FIELD`	`FOR`	`FROM`
`GRANT`	`GRANTS`	`GROUPS`	`GROUP BY`	`IN`	`INF`	`INSERT`
`KEY`	`KEYS`	`KILL`	`LIMIT`	`MEASUREMENT`	`MEASUREMENTS`	`NAME`
`OFFSET`	`ON`	`ORDER`	`PASSWORD`	`POLICY`	`POLICIES`	`PRIVILEGES`
`QUERY`	`QUERIES`	`READ`	`REPLICATION`	`RESAMPLE`	`REVOKE`	`RETENTION`
`SELECT`	`SERIES`	`SET`	`SLIMIT`	`SHOW`	`SHARD`	`SHARDS`
`SOFFSET`	`STATS`	`SUBSCRIPTION`	`SUBSCRIPTIONS`	`TAG`	`TO`
`USER`	`USERS`	`VALUES`	`WHERE^†`	`WITH`	`WRITE`

Telegraf, InfluxDB, Chronograf and Kapacitor are known as the TICK Stack.

influx Command Language

Examples:

into

downsampling

Aggregations

Selectors

Influx Data

String Functions

Transformations

`Retention Policy`

subscriptions

influxd daemon (service)