influx_query()

Read(52) Label: query, influxdb,

Description:

Query InfluxDB database.

Syntax:

influx_query(hd,sql)

Note:

The external library function queries InfluxDB database.

Parameters:

hd

Connecton object

sql

The SQL query statement or database search statement

Return value:

Query result set

Example:

 

A

B

1

=influx_open("http://127.0.0.1:8086", "mydb", "autogen", "admin", "admin")

//Connect to database

2

=influx_query(A1, "SELECT * FROM instance")

//Query instance table

3

=influx_query(A1, "SELECT /l/ FROM instance LIMIT 1")

//Same as A2

4

=influx_query(A1, "SELECT MEAN(water_level) FROM h2o_feet WHERE time >= '2019-08-18T00:00:00Z' AND time <= '2019-08-18T00:42:00Z' GROUP BY *,time(12m)  SLIMIT 5")

//Query the water_level average in h2o_feet table

5

=influx_query(A1, "CREATE CONTINUOUS QUERY \"cq_basic_br\" ON \"transportation\"" +

  "BEGIN "+

  "  SELECT mean(*) INTO \"downsampled_transportation\".\"autogen\".:MEASUREMENT FROM /.*/ GROUP BY time(30m),* "+

  "END")

//Create the connection query statement

6

=influx_query(A1, "SHOW DATABASES")

//Show the database

7

=influx_query(A1, "SHOW RETENTION POLICIES")

// Show the retention policy

8

=influx_query(A1, "SHOW SHARDS")

//Show shards

9

=influx_close(A1)

//Close the database