Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
T4lus
@T4lus
I'm trying to parse apache acces log, to get number of connection by IP
but I'm stuck with the query, I'm came from mysql, and how can I bypass the agregate/nonagregate query
I wan't to do that : SELECT COUNT(client_ip) AS nb, client_ip FROM apache_access_log GROUP BY client_ip
Jack Zampolin
@jackzampolin
@Seraf Sorry for not getting to you earlier! Can you post this question over on community.influxdata.com? Also it looks like you have the tags written as sensor_1 in the above example. Might be why you aren’t seeing results?
@T4lus You want count(distinct(client_ip)) AS visitors FROM apache_access_log
Also in the future if you have questions please direct them over to community.influxdata.com
MaKin211
@MaKin211
Can anyone help me with installing influxdb on Ubuntu 17.04 (Zesty)?
Vickie-c
@Vickie-c
@MaKin211 Only 2 steps.
  1. wget https://dl.influxdata.com/influxdb/releases/influxdb_1.2.4_amd64.deb
  2. sudo dpkg -i influxdb_1.2.4_amd64.deb
v-gerasimov
@v-gerasimov
Hello! Is there a way in influxdb to get moving sum like moving avg function? I have the values [1,2,3,4,5,6,7] and want something like this select moving_sum(value, 2d) that returns [1, 3, 5, 7, 9, 11, 13] (or may be [3, 5, 7, 9 , 11, 13]). Something like this https://www.mathworks.com/help/matlab/ref/movsum.html
kevinsteger
@kevinsteger
What is the best practice for downsampling to calendar month 1m? I need this for accounting.
Mukut Bhattacharjee
@mukutbhattacharjee
If i create a continuous query with groupby time interval of 5m, when will that CQ execute for the first time?
Mukut Bhattacharjee
@mukutbhattacharjee
Can anyone help me to understand how influx db chooses the default time buckets
Chris Evans
@ChrisE-UoN
Hi team! I'm currently configuring InfluxDB and Kapacitor via a script which modifies the /etc/<program>/<program.conf> files with a sed -i command. Can anybody recommend a better, more reliable, future-forward option. I looked into using the HTTP API overrides but I couldn't find any examples of how to use it to override specific lines or config directives.
Faiaz Sanaulla
@fsanaulla
Hi guys, i'm runnig show queries command, but every time it return only the last one query. I'm using influxdb 1.3.2.
Paul Puschmann
@ppuschmann
@ChrisE-UoN I suggest using Ansible, Puppet, Chef or similar to configure InfluxDB.
(or manipulating files, config and packages)
Taimoor Chatha
@taichatha
I have a feeling my question either is something that is intuitive to db masters, or it's just not possibe, but I'll try it here as well: Is there any method to get unique values in influxdb and also get the timestamp? What's the reasoning behind the timestamp being epoch 0?
Taimoor Chatha
@taichatha
Is it possible to join the results that i get back with the distinct function, with the same table to get the timestamp?
Taimoor Chatha
@taichatha
select * from <measurement> group by <field> order by time desc limit 1 does what I want.
Calem Bendell
@calben
Heya everyone, is there a binary transfer format to insert over HTML?
Chris Dibble
@chrisdibble
If a node in my DOT graph is producing errors on kapacitor show task_name, is there any way to get more debug information on that error? Right now I just see a counter of the errors.
v-gerasimov
@v-gerasimov
Hello! Is there a way to change field type of measurement? I inserted some values as integer, but now I need cast it to fload and insert float values.
Connor Peet
@connor4312
Not afaik
avimar
@avimar
I'm running a phone server with events -- how would I go about logging these things in influxdb, if possible?
I understand how to log total active calls, per second.
But I want to log calls -- carrier, destination country, destination phone type, duration, etc.
Then, I want to see concurrent calls by country, by carrier, etc -- but these have a duration. Are durations possible with influxdb?
this room looks pretty quiet -- somewhere else more active?
leo
@leo3877
support having?
Karachain
@karachainproj_twitter

"We are soon going to release Blockchain Tutorial using GOlang for Developers on our Gitter and telegram group - you can join our groups

Gitter : https://gitter.im/Karachain-Project
Telegram: https://t.me/karachain"

Ed Kim
@eddhkim_twitter
Hi. Is there a way to store aggregated data only given the time range?
Let say we have millions of data points coming in every minute
Most of the time we only use mean value per minute
So we dont really need to store per second or millisecond data
So if there is a way to insert as it update the mean value of the minute range, we would save alot more computation time as well as the storage
Vitaly Zhuravlev
@v-zhuravlev
Hi, is there any good example how to use KapacitorLoopback node? https://docs.influxdata.com/kapacitor/v1.4/nodes/kapacitor_loopback_node/
Can it be used for chaining streams from different tick scripts?
slachtar
@slachtar
Is there community/paid support? This room looks useless!!
Ed Kim
@eddhkim_twitter
Haha agree
maxp-edcast
@maxp-edcast
Hey just posting this here in case there's a chance somebody can help. I'm having trouble using GROUP BY inside subqueries. https://stackoverflow.com/questions/48653009/missing-data-using-group-by-with-influxdb-subqueries
maxp-edcast
@maxp-edcast
nvm figured it out
tosheer kalra
@tosheer22_twitter
Hey.. Have anyone tried pushing open tracing data in Jaeger or Zipkin format to influxdb and seen the traces using Jager / Zipkin as chronograf doesn't support it?
Let me know if i am missing anything
jrm
@jrm
Hi - I just posted this question on community.influxdata.com: https://community.influxdata.com/t/use-of-a-continuous-query-with-non-negative-difference-and-non-negative-derivative-functions/4024 - does anyone here have any suggestions?
SarankumarChandrasekan
@SarankumarChandrasekan
Kindly someone guide me to install collectd on Windows machine
Cayetano Soriano
@neoshadybeat
Is telegraf a drop replacement for fluentd?
Matjaž Mav
@matjazmav
Hey can I use docker input plugin for multiple docker endpoints
Erik Idland
@eaidland
Quick question: Where can I find the Influx Stress Tool V2 config file? the default
Cayetano Soriano
@neoshadybeat
any ETA FOR telegrad 1.6?
sillekyatha
@sillekyatha
Hi, I'm having an issue where I get this exception writing stats to influxdb
.server.influx.dao.InfluxDBDao - The InfluxDB test-write failed. Please check the provided credentials and user permissions.
I did check with the config file and I'm using the right username/password.
Tai Kersten
@kerstentw
Hello, new to influx and I have an issue. I recently wrote a script to bulk insert a mass of data to influx but forgot to set a precision and my seconds timestamps are being interpreted as nano-seconds resulting in all my data being set to sometime in the 1st of January 1970. Although I suspect I will have to re-grab all my data and re-insert, is there any way to convert my timestamps to an appropriate precision?
Faiaz Sanaulla
@fsanaulla
Hello, is it possible to enable UDP in influx docker image?
honnel
@honnel_twitter
hi is there a gitter for telegraf? is there an ETA for telegraf 1.8?
Patrick Callahan
@therealpxc
can I use capturing groups in InfluxDB's regexes, to put something I can use later in the query or create a virtual/temporary field or tag based on what gets captured?