Time Series Database:CLI of TSDB for InfluxDB®

Run a command and exit with -execute

Use -execute to run a single InfluxQL command without entering the interactive shell.

Run a query that doesn't require a database:

$ influx -ssl -username <Username> -password <Password> -host <Endpoint> -port 3242 -execute 'SHOW DATABASES'
name: databases
---------------
name
NOAA_water_database
_internal
telegraf
pirates

Run a query against a specific database and change the timestamp precision:

$ influx -ssl -username <Username> -password <Password> -host <Endpoint> -port 3242 -execute 'SELECT * FROM "h2o_feet" LIMIT 3' -database="NOAA_water_database" -precision=rfc3339
name: h2o_feet
--------------
time                     level description     location      water_level
2015-08-18T00:00:00Z     below 3 feet          santa_monica  2.064
2015-08-18T00:00:00Z     between 6 and 9 feet  coyote_creek  8.12
2015-08-18T00:06:00Z     between 6 and 9 feet  coyote_creek  8.005

Set response format with -format

The default format is column. The following examples show all three available formats.

column (default):

$ influx -ssl -username <Username> -password <Password> -host <Endpoint> -port 3242 -format=column
[...]
> SHOW DATABASES
name: databases
---------------
name
NOAA_water_database
_internal
telegraf
pirates

csv:

$ influx -ssl -username <Username> -password <Password> -host <Endpoint> -port 3242 -format=csv
[...]
> SHOW DATABASES
name,name
databases,NOAA_water_database
databases,_internal
databases,telegraf
databases,pirates

json:

$ influx -ssl -username <Username> -password <Password> -host <Endpoint> -port 3242 -format=json
[...]
> SHOW DATABASES
{"results":[{"series":[{"name":"databases","columns":["name"],"values":[["NOAA_water_database"],["_internal"],["telegraf"],["pirates"]]}]}]}

json with `-pretty`:

$ influx -ssl -username <Username> -password <Password> -host <Endpoint> -port 3242 -format=json -pretty
[...]
> SHOW DATABASES
{
    "results": [
        {
            "series": [
                {
                    "name": "databases",
                    "columns": [
                        "name"
                    ],
                    "values": [
                        [
                            "NOAA_water_database"
                        ],
                        [
                            "_internal"
                        ],
                        [
                            "telegraf"
                        ],
                        [
                            "pirates"
                        ]
                    ]
                }
            ]
        }
    ]
}

Import data from a file with -import

Use -import to load data from a file into TSDB for InfluxDB®.

An import file has two sections:

• DDL (Data Definition Language) (optional): InfluxQL commands to create the target database and retention policy. Skip this section if the database and retention policy already exist.

• DML (Data Manipulation Language): Context metadata specifying the target database and retention policy, followed by data in line protocol format.

Example

Suppose that a database named pirates and a retention policy named oneday are created.

File datarrr.txt:

# DML
# CONTEXT-DATABASE: pirates
# CONTEXT-RETENTION-POLICY: oneday
treasures,captain_id=dread_pirate_roberts value=801 1439856000
treasures,captain_id=flint value=29 1439856000
treasures,captain_id=sparrow value=38 1439856000
treasures,captain_id=tetra value=47 1439856000
treasures,captain_id=crunch value=109 1439858880

Command:

$influx -ssl -username <Username> -password <Password> -host <Endpoint> -port 3242 -import -path=datarrr.txt -precision=s

Output:

2015/12/22 12:25:06 Processed 0 commands
2015/12/22 12:25:06 Processed 5 inserts
2015/12/22 12:25:06 Failed 0 inserts

Usage notes for `-import`

• Include timestamps in every data point. Without timestamps, TSDB for InfluxDB® assigns the same timestamp to all points in the batch, which can cause unintended data overwrites.

• To limit the import rate, use -pps to set the maximum number of data points per second. The default is 0 (no limit).

• To import a .gz compressed file, add the -compressed flag.

• For files with more than 5,000 data points, split the file into smaller batches of 5,000 to 10,000 points. Smaller batches increase the number of HTTP requests and can reduce performance. Each HTTP request has a five-second timeout; if a request times out, TSDB for InfluxDB® retries writing the points, but the write may not succeed.

Write data with insert

Use insert to write data in line protocol format. To write to a specific retention policy, use insert into <retention policy> <line protocol>.

Write to the default (DEFAULT) retention policy:

> INSERT treasures,captain_id=pirate_king value=2
>

Write to the oneday retention policy:

> INSERT INTO oneday treasures,captain_id=pirate_king value=2
Using retention policy oneday
>

Run InfluxQL queries

All InfluxQL queries are supported in the influx shell. For details, see Overview of data exploration, Schema exploration, and Database management.