Documentation

influx transpile

Removed in InfluxDB OSS 2.0.5

The influx transpile command was removed in InfluxDB 2.0.5. Use InfluxQL to query InfluxDB. For information about manually converting InfluxQL queries to Flux, see:

The influx transpile command transpiles an InfluxQL query to Flux source code. The transpiled query assumes the bucket name is <database>/<retention policy> and includes absolute time ranges using the provided --now time.

Usage

influx transpile [InfluxQL query] [flags]
  • Copy
  • Fill window

The InfluxQL query must be valid and contain both a database and measurement. See the InfluxQL documentation for more information.

Flags

FlagDescription
-h--helpHelp for the transpile command
--nowRFC3339Nano timestamp to use as now() time (default is current UTC time)

Examples

Authentication credentials

The examples below assume your InfluxDB host, organization, and token are provided by either the active influx CLI configuration or by environment variables (INFLUX_HOST, INFLUX_ORG, and INFLUX_TOKEN). If you do not have a CLI configuration set up or the environment variables set, include these required credentials for each command with the following flags:

  • --host: InfluxDB host
  • -o, --org or --org-id: InfluxDB organization name or ID
  • -t, --token: InfluxDB API token
Transpile InfluxQL queries to Flux
## Transpile an InfluxQL query that specifies the database,
## retention policy, and measurement.
influx transpile 'SELECT example-field FROM db.rp.measurement'

## Transpile InfluxQL query using default retention policy
influx transpile 'SELECT example-field FROM db..measurement'
  • Copy
  • Fill window

Was this page helpful?

Thank you for your feedback!


The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more

InfluxDB 3 Core and Enterprise are now in Beta

InfluxDB 3 Core and Enterprise are now available for beta testing, available under MIT or Apache 2 license.

InfluxDB 3 Core is a high-speed, recent-data engine that collects and processes data in real-time, while persisting it to local disk or object storage. InfluxDB 3 Enterprise is a commercial product that builds on Core’s foundation, adding high availability, read replicas, enhanced security, and data compaction for faster queries. A free tier of InfluxDB 3 Enterprise will also be available for at-home, non-commercial use for hobbyists to get the full historical time series database set of capabilities.

For more information, check out: