TL;DR InfluxDB Tech Tips - InfluxDB Common Issues With Basic Syntax
By Regan Kuchan / Oct 27, 2016 / Tech Tips
In this weekly post we recap the most interesting InfluxDB common issues with basic syntax and TICK-stack related issues, workarounds, how-tos and Q&A from GitHub, IRC and the InfluxDB Google Group that you might have missed in the last week or so.
Configure Returned Timestamps
Q: I’m working with InfluxDB’s Command Line Interface and I’d like my timestamps to be returned in second-precision epoch time. Is there a way to do this?
> SELECT * FROM "lukes" name: lukes time coffee_sales lorelei ---- ------------ ------- 1477472400000000000 2 false 1477473300000000000 7 true > precision s <--- ? Changes the epoch precision to seconds ? > SELECT * FROM "lukes" name: lukes time coffee_sales lorelei ---- ------------ ------- 1477472400 2 false 1477473300 7 true
Backfill Results for Continuous Queries
Q: I created a continuous query (see below) and I noticed it didn’t backfill results for my older data. My data go back to 2015. Is this the expected behavior?
CREATE CONTINUOUS QUERY "clandestine_clementine" ON "oval_orange" BEGIN SELECT MEAN("melting_mandarin") INTO "tempestuous_tangerine" FROM "nebulous_navel" GROUP BY time(8m) END
Q: Is there a place where I can find documentation on errors?
A: Yes! We’ve created a new documentation page that details the different error messages and their causes. Check it out! ?
- Download and get started with InfluxDB!
- Schedule a FREE 20 minute consultation with a Solutions Architect to review your InfluxDB project.
- Attend one of our FREE virtual training seminars.
- Got a question and need an immediate answer from the InfluxData Support team? Support subscriptions with unlimited incidents start at just $399 a month. Check out all the support options here.