[influxdb] Re: What is the influx query to show measurements newer than 1 day old?

[Frank Inselbuch]

Or perhaps better

show last(temp) from machines where time > now() - 1d

On Thursday, February 22, 2018 at 10:03:26 AM UTC-6, Frank Inselbuch wrote:
>
> I don't believe that can be done.
> What you can do is query the measurement for a field value with a 
> timestamp in the last day.
> For example
>
> select temp from machines where time > now() - 1d
>
> But you have to specify the measurement in the query.
>
> You could construct these queries for all measurements in a program (bash, 
> python, etc.) ... run show measurements to get the whole list of 
> measurements.
> Then construct the above query for each measurement.
>
> Not ideal, I know.
>
>
>
> On Tuesday, February 13, 2018 at 1:11:11 PM UTC-6, Travis Keep wrote:
>>
>> > show measurements
>>
>> This shows all the measurements in a database, but I am interested in 
>> only the measurements that are newer than 1 day.  If the measurement did 
>> not exist 1 day ago, I don't want it listed.  How would one write such a 
>> query?
>>
>>
>>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/647f44f8-6f0f-4b9a-9019-3b78a5d603ba%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: What is the influx query to show measurements newer than 1 day old?

[Frank Inselbuch]

I don't believe that can be done.
What you can do is query the measurement for a field value with a timestamp 
in the last day.
For example

select temp from machines where time > now() - 1d

But you have to specify the measurement in the query.

You could construct these queries for all measurements in a program (bash, 
python, etc.) ... run show measurements to get the whole list of 
measurements.
Then construct the above query for each measurement.

Not ideal, I know.



On Tuesday, February 13, 2018 at 1:11:11 PM UTC-6, Travis Keep wrote:
>
> > show measurements
>
> This shows all the measurements in a database, but I am interested in only 
> the measurements that are newer than 1 day.  If the measurement did not 
> exist 1 day ago, I don't want it listed.  How would one write such a query?
>
>
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/3e902e30-9cb3-4aba-8fa1-f669dcd1e644%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: Please help me get this right the first time

[Frank Inselbuch]

1) i would propose a single table for all your time-series values

insert tdata,id= setpoint=15.6
insert tdata,id= temp=22.5

(note that these two statements will get their own timestamps)

insert tdata,id= setpoint=12.2,temp=55.6

Also note, if you want to coerce the datatype to be an integer or a float 
you're going to want to specify that, too

insert tdata,id= temp=12i

for example

2) yes, but 200 temperature sensors storing minute values is a very small 
database
so i wouldn't worry about that
it can be added in later

this used to be done with a continuous query
but i think there is a new technique with their fancier query language
so i am going to let that stabilize for a while before i start playing with 
it

3) repeating panels... i think this is possible
what i do, however, is construct a list of "things" periodically
so within a few minutes the new sensor is populated into the list
and grafana will reflect this updated list in a drop selector
but that's not exactly your use case

good luck




On Tuesday, January 9, 2018 at 9:49:16 PM UTC-6, Dan Hoover wrote:
>
> I'm a complete and total noob to influx/grafana but I do understand SQL 
> pretty well. I'd just like to ask a few questions to make sure I'm on the 
> right track.  Thanks in advance for your help (and your patience).
>
> I have a bunch (200) of temperature sensors that all report the temp, the 
> setpoint, the state of the HVAC, and the sensor id.  They report once per 
> minute.
>
> I'm currently only saving the latest result in a SQL database. Now I'm 
> ready to begin adding this information to influx.  I've confirmed that the 
> connections are working and that I can add data properly.
>
> Here are my questions:
>
> 1.  Should each sensor be its own "table" or do I just dump all the data 
> in one table called temperatures and let the IDs sort it out?
> 2.  Is there any way to run a query once a month or so that automatically 
> averages the data over the course of an hour and stores that to keep the 
> size of the db reasonable?  That's probably far fetched, but I thought I'd 
> ask.
> 3.  Can I have something like grafana automatically detect a new sensor id 
> and create a gauge/chart for it, or do I have to do this manually every 
> time I add new sensor? I'm guessing that this could have a bearing on 
> question #1.
>
>
> I think that's a good start. I just want to get my schema right from the 
> beginning.  I'm sure I'll have a ton to learn, but I feel like playing with 
> it will be easier once I have a nice stream of data to visualize.
>
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/3e994019-e3ec-4090-a804-dc380e14a6e7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: Influx DB Client in C

[Frank Inselbuch]

There is no native API/SDK for C.
I suggest you look at libcurl and the http api:

https://docs.influxdata.com/influxdb/v1.4/guides/querying_data/
https://docs.influxdata.com/influxdb/v1.4/guides/writing_data/

Personally, I use Python (for which there is an API) for all the database 
stuff.
And I use C for interacting with the hardware.





On Wednesday, January 10, 2018 at 12:19:55 AM UTC-6, Ninad Pai wrote:
>
> Hi, We are planning to use influx db in our product.
> But we are looking for a Client in C language to write to DB, looking for 
> pointers to start on this.
>
> Thanks.
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/d28620c2-2004-425f-a7b6-a24d37852c91%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [influxdb] Re: InfluxDB Raspberry Pi installation?

[Frank Inselbuch]

After you decompress the archive, what comes out?

Can you copy the output of that command to this thread?




Frank Inselbuch
Unix Edge, Inc.
Fleet Surveillance and Analytics
713-701-5421
inselb...@unixedge.com
https://zoom.us/j/7137015421

-Original Message-
From: influxdb@googlegroups.com [mailto:influxdb@googlegroups.com] On Behalf Of 
Lucia
Sent: Saturday, November 25, 2017 2:17 AM
To: influxdb@googlegroups.com
Subject: Re: [influxdb] Re: InfluxDB Raspberry Pi installation?

Thank you, Frank.
Your assumptions are correct.
However, if I do
wget
tar
then I get:
# service influxdb start
influxdb: unrecognized service

and here I am stuck.
Thank you very much for your help,
Lucia
-
Dr. Lucia Morganti
@ INFN - CNAF (www.cnaf.infn.it)
Address:   Viale Berti Pichat 6/2, 40127 Bologna (IT)
-


On 24 November 2017 at 20:05, Frank Inselbuch <inselb...@unixedge.com> wrote:
>
> Okay so first you have to get the installation kit which comes in the form of 
> a compressed archive, from here:
>
> https://portal.influxdata.com/downloads#influxdb
>
> I am not familiar with the board you are talking about but assuming it's an 
> arm processor and running a Debian-style Linux, you can try this one:
>
> This command will pull the kit to your machine:
> wget 
> https://dl.influxdata.com/influxdb/releases/influxdb-1.4.2_linux_armhf
> .tar.gz
>
> Then you decomparess the archive like this:
> tar xvfz influxdb-1.4.2_linux_armhf.tar.gz
>
> Then you should be able to start the database:
>
> service influxdb start
>
> or
>
> systemctl start influxdb
>
>
>
>
>
> Frank Inselbuch
> Unix Edge, Inc.
> Fleet Surveillance and Analytics
> 713-701-5421
> inselb...@unixedge.com
> https://zoom.us/j/7137015421
>
> -Original Message-
> From: influxdb@googlegroups.com [mailto:influxdb@googlegroups.com] On 
> Behalf Of lucia.morga...@gmail.com
> Sent: Friday, November 24, 2017 9:15 AM
> To: InfluxData <influxdb@googlegroups.com>
> Subject: [influxdb] Re: InfluxDB Raspberry Pi installation?
>
> Hi Frank,
> what do you mean when you say "after you tar you install it with dpkg"?
> I'm working on ARM, Invidia X1 board.
> Thanks,
> lucia
>
> On Thursday, October 13, 2016 at 11:56:15 PM UTC+2, Frank Inselbuch wrote:
>> After you tar you will install it with dpkg.
>> It will probably get started automatically at that point.
>> But if you want to start it/restart/stop just
>>
>>
>> sudo service influxd start (or restart or stop)
>>
>>
>> by default I believe the server will be available for http: requests 
>> on port 8086
>>
>>
>> i would encourage you to also install something like grafana to pull 
>> data from influxdb, but you can roll your own with http requests
>>
>>
>> to work with the database interactively, use the CLI (command line
>> interface)
>>
>>
>> just type
>>
>>
>> $ influx
>>
>>
>> here's a few commands to get you started
>>
>>
>>
>>
>> Influx> create database test1
>> Influx> insert cars,vin=3948579834 year=2015,color='Green',mileage=15
>> Influx> select * from cars
>>
>>
>> Good luck.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Thursday, October 13, 2016 at 7:39:27 AM UTC-5, EBRAddict wrote:
>> Hi,
>>
>>
>> I'd like to try InfluxDB on a Raspberry Pi 3 for a mobile sensor project. 
>> Currently it's logging ~50 data points every 200ms to a USB flash drive text 
>> file but I want to ramp that up to 200 every 10ms, or however fast I can 
>> push data from the microcontrollers to the Pi.
>>
>>
>> I downloaded and uncompressed the ARM binaries using the instructions on the 
>> InfluxDB download page:
>>
>>
>> wget
>> https://dl.influxdata.com/influxdb/releases/influxdb-1.0.2_linux_armh
>> f .tar.gz tar xvfz influxdb-1.0.2_linux_armhf.tar.gz
>>
>>
>> What are the next steps? I'm not a Linux guy but I can follow directions if 
>> someone could point me to them. I'd like to configure the service(s) to run 
>> at startup automatically and be accessible for querying by any logged in 
>> user (it's a closed system).
>>
>>
>> Thanks.
>
> --
> Remember to include the version number!
> ---
> You received this message because you are subscribed to a topic in the Google 
> Groups "InfluxData" group.
> To unsubscr

RE: [influxdb] Re: InfluxDB Raspberry Pi installation?

[Frank Inselbuch]

Okay so first you have to get the installation kit which comes in the form of a 
compressed archive, from here:

https://portal.influxdata.com/downloads#influxdb

I am not familiar with the board you are talking about but assuming it's an arm 
processor and running a Debian-style Linux, you can try this one:

This command will pull the kit to your machine:
wget 
https://dl.influxdata.com/influxdb/releases/influxdb-1.4.2_linux_armhf.tar.gz

Then you decomparess the archive like this:
tar xvfz influxdb-1.4.2_linux_armhf.tar.gz

Then you should be able to start the database:

service influxdb start

or

systemctl start influxdb





Frank Inselbuch
Unix Edge, Inc.
Fleet Surveillance and Analytics
713-701-5421
inselb...@unixedge.com
https://zoom.us/j/7137015421

-Original Message-
From: influxdb@googlegroups.com [mailto:influxdb@googlegroups.com] On Behalf Of 
lucia.morga...@gmail.com
Sent: Friday, November 24, 2017 9:15 AM
To: InfluxData <influxdb@googlegroups.com>
Subject: [influxdb] Re: InfluxDB Raspberry Pi installation?

Hi Frank,
what do you mean when you say "after you tar you install it with dpkg"?
I'm working on ARM, Invidia X1 board.
Thanks,
lucia

On Thursday, October 13, 2016 at 11:56:15 PM UTC+2, Frank Inselbuch wrote:
> After you tar you will install it with dpkg.
> It will probably get started automatically at that point.
> But if you want to start it/restart/stop just
> 
> 
> sudo service influxd start (or restart or stop)
> 
> 
> by default I believe the server will be available for http: requests 
> on port 8086
> 
> 
> i would encourage you to also install something like grafana to pull 
> data from influxdb, but you can roll your own with http requests
> 
> 
> to work with the database interactively, use the CLI (command line 
> interface)
> 
> 
> just type
> 
> 
> $ influx
> 
> 
> here's a few commands to get you started
> 
> 
> 
> 
> Influx> create database test1
> Influx> insert cars,vin=3948579834 year=2015,color='Green',mileage=15
> Influx> select * from cars
> 
> 
> Good luck.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> On Thursday, October 13, 2016 at 7:39:27 AM UTC-5, EBRAddict wrote:
> Hi,
> 
> 
> I'd like to try InfluxDB on a Raspberry Pi 3 for a mobile sensor project. 
> Currently it's logging ~50 data points every 200ms to a USB flash drive text 
> file but I want to ramp that up to 200 every 10ms, or however fast I can push 
> data from the microcontrollers to the Pi.
> 
> 
> I downloaded and uncompressed the ARM binaries using the instructions on the 
> InfluxDB download page:
> 
> 
> wget 
> https://dl.influxdata.com/influxdb/releases/influxdb-1.0.2_linux_armhf
> .tar.gz tar xvfz influxdb-1.0.2_linux_armhf.tar.gz
> 
> 
> What are the next steps? I'm not a Linux guy but I can follow directions if 
> someone could point me to them. I'd like to configure the service(s) to run 
> at startup automatically and be accessible for querying by any logged in user 
> (it's a closed system).
> 
> 
> Thanks.

--
Remember to include the version number!
---
You received this message because you are subscribed to a topic in the Google 
Groups "InfluxData" group.
To unsubscribe from this topic, visit 
https://groups.google.com/d/topic/influxdb/us4x3V2fbNk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to 
influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/d55e0819-a907-4733-9a2f-5d572686e435%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/SN1PR16MB06850CC2C148E380990CC702DD260%40SN1PR16MB0685.namprd16.prod.outlook.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: Adding a point with a different tag set and field set to an existing measurement alters the schema :

[Frank Inselbuch]

The behavior you are seeing is by design.
You can insert data with a field and a tag with the same name and that data 
is distinct.
I believe this should be prevented by IFX and result in an error.
Why don't you raise this as an issue and then the rest of us can +1 it.



On Thursday, November 9, 2017 at 3:28:28 AM UTC-6, gupta0...@gmail.com 
wrote:
>
> > insert debug,host=us,result=PASS 
> ctnrName="sakshi.ctnr.1",prj="xyz.12"
> > selec^C
> > show measurements
> name: measurements
> --
> name
> build
> create
> debug
>
> > select * from "debug"
> name: debug
> ---
> timectnrNamehostprj result
> 1510218785437764998 sakshi.ctnr.1   us  xyz.12  PASS
>
> > show tag keys from "debug"
> name: debug
> ---
> tagKey
> host
> result
>
> > show field keys from "debug"
> name: debug
> ---
> fieldKeyfieldType
> ctnrNamestring
> prj string
>
> > insert debug,host=us 
> result="PASS",ctnrName="sakshi.ctnr.1",prj="xyz.12"
> > select * from "debug"
> name: debug
> ---
> timectnrNamehostprj result  result_1
> 1510218785437764998 sakshi.ctnr.1   us  xyz.12  PASS
> 1510218845910180112 sakshi.ctnr.1   us  xyz.12  PASS
>
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/bc905693-0030-4a37-82c6-56b44b1e5fa2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: ignore last group when grouping by time

[Frank Inselbuch]

Use a where clause to restrict the values being considered... basically 2) 
... but YOU have to do it

where time < now() - (you put in the number of minutes/hours, etc. here)

When the query language is richer you will be able to do things like 
construct timestamps, round timestamps, etc. But some of those 
functions/capabilities don't exist yet. In the short term what I have been 
doing is generating the SQL programmatically in Python, then querying the 
database with constructed SQL... consider this construct

q = "select sum(foo) from bar where time > now() - {}m".format(minutes_back)
results = iclient.query(q).get_points()





On Wednesday, November 1, 2017 at 1:47:17 PM UTC-5, only...@gmail.com wrote:
>
> Whenever we do a `select sum(foo) from bar group by time(10m)`, the last 
> group reported has lower numbers because it's not complete yet. If you keep 
> running the same query over and over, the value for the last group will 
> increase until it gets to the real value, until `now()` is at a round 10 
> minute mark, and then it'll go down to 0 again.
>
> I'd like to be able to either (1) set the `group by time()` offset to the 
> interval between the last "round" time interval OR (2) just have influx 
> discard all data points between the end of the last round timestamp and 
> `now()`.
>
> I did a lot of reading of the documentation, github issues, and this 
> group, and it seems like 1 is not possible. Is there a clean way to do 2?
>
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/5ea9af8d-85ba-4089-8afe-19c8090b95cb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] Re: Influxdb using up a hell lot of RAM

[Frank Inselbuch]

can you capture the output from

top

Sent from my iPad

On Jul 12, 2017, at 2:29 AM, sarad mohanan 
> wrote:

@Frank

$ lsb_release -a
No LSB modules are available.
Distributor ID:Ubuntu
Description:   Ubuntu 16.04.2 LTS
Release:   16.04
Codename:  xenial

- Influxdb is using up all the RAM!
- as the data started flowing in from telegraf influxdb started up using more 
ram
- no, its just a dedicated machine for influx


On Monday, 10 July 2017 17:03:43 UTC+5:30, sarad mohanan wrote:
I have a single instance influxdb installation on AWS. Initally I installed it 
on a t2.small maching (2GB ram and 1 CPU) about 5 weeks ago. Also I have some 
10-15 other machines around with telegraf reporting about some vital system 
metrics and some application metrics initially everything was fine within 3-4 
days it started up using more RAM so I changed instance type to t2.medium and 
then again everything became normal not long after that I had to change to 
t2.large and 2 days back I changed it to t2.xlarge! a machine with 16GB of RAM 
and current RAM usage is around 12GB :O. I have a total data of 2.5GB on disk 
also I have put in retention period(RP) of around 3 weeks max(I have some RPs 
of 1 week). What might be the problem here.

--
Remember to include the version number!
---
You received this message because you are subscribed to a topic in the Google 
Groups "InfluxData" group.
To unsubscribe from this topic, visit 
https://groups.google.com/d/topic/influxdb/Z6WDmK4Xb1o/unsubscribe.
To unsubscribe from this group and all its topics, send an email to 
influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to 
influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/22cdac14-de96-4a2e-a21c-38d60c5dc384%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/E33895E7-4843-44A5-B4C5-7B20A24386B2%40unixedge.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: Influxdb using up a hell lot of RAM

[Frank Inselbuch]

What operating system?
What process(es) are using a lot of memory?
Please clarify "it started up using more RAM" ... 
Is there anything else running on the machine?



On Monday, July 10, 2017 at 6:33:43 AM UTC-5, sarad mohanan wrote:
>
> I have a single instance influxdb installation on AWS. Initally I 
> installed it on a t2.small maching (2GB ram and 1 CPU) about 5 weeks ago. 
> Also I have some 10-15 other machines around with telegraf reporting about 
> some vital system metrics and some application metrics initially everything 
> was fine within 3-4 days it started up using more RAM so I changed instance 
> type to t2.medium and then again everything became normal not long after 
> that I had to change to t2.large and 2 days back I changed it to t2.xlarge! 
> a machine with 16GB of RAM and current RAM usage is around 12GB :O. I have 
> a total data of 2.5GB on disk also I have put in retention period(RP) of 
> around 3 weeks max(I have some RPs of 1 week). What might be the problem 
> here.
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/9777eaf8-200a-4468-8ba0-ca04ff22c319%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: how to committ in influxdb?

[Frank Inselbuch]

there is no commit
shut down the database
then shut down the machine


On Friday, June 30, 2017 at 10:11:45 AM UTC-5, anuj tyagi wrote:
>
> Hello Everyone,
>
> I used influxdb for a project to save realtime logs data. I need to shut 
> VM but I couldn't find any command to save that stored data in db. 
> I couldnt find anything like committ
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/c5b82b86-be4a-4ebd-8469-77f166139602%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: select substring of a tag's value, for geohash-based spatial aggregation?

[Frank Inselbuch]

It would be great if the query language would embrace more of the SQL92 
standard (which includes substring function, for example).

https://en.wikipedia.org/wiki/SQL-92



On Monday, September 26, 2016 at 4:01:38 PM UTC-5, Sam Hatchett wrote:
>
> In trying to combine InfluxDB with Grafana's World Map plugin for 
> displaying time series data spatially, I've identified the need to 
> spatially subsample because I just have too many geographical points to 
> display all at once - too much lag time to return the result set. The 
> location's geohash provides a great way to do this (encoded as a tag value, 
> so I can group-by geohash to return some aggregate of potentially hundreds 
> of location's values), and then I can select the max, mean, min, etc., for 
> each spatial region, but the level of spatial aggregation has to be decided 
> prior to writing data to Influx.
>
> What I'm wondering about are the relative merits of workarounds, or of 
> finding some way to decide on the geohash length when the query is executed.
>
> So for instance, have multiple tags: (geo8, geo9, geo10 ...) for each 
> series so that I can decide on spatial subsampling when querying and choose 
> the right length:
> select "value" from "temperature" where ... group by "geo8"
>
> But what I really want to do is store the full 12-character geohash for 
> each location and group by a substring of that geohash:
> select "value" from "temperature" where ... group by substr("geohash",0,8)
>
> It's also useful to note that I can currently limit the locations that are 
> queried by using a regex:
> select "value" from "temperature" where "geohash" =~ /^gbsuv7s/
>
> ... but can't use a substring of the hash to do the group-by, which would 
> take me the rest of the way there.
>
> Any thoughts or comments would be most appreciated. I don't think that 
> there's a really straightforward solution right now, but does using a 
> substring (or other arbitrary transformation) of a tag value for grouping 
> make sense to anyone else? Seems like there could be many more uses of this 
> type of approach.
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/7dd812f1-c1b9-4bf5-99c8-650caa0889a1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] Abridged summary of influxdb@googlegroups.com - 1 update in 1 topic

[Frank Inselbuch]

This is a well-known, oft-cited complaint.

The following InfluxDB queries are useful for templating in Grafana:

show tag values from measurement with key = 

show series from measurement where tag = 

I believe that Grafana implemented something in their latest release to 
alleviate your suffering. But I have not had a chance to test. Be sure to use 
the latest Grafana.

I agree that InfluxDB should not return data that has not been requested (e.g., 
the time).





From: "influxdb@googlegroups.com" 
>
Reply-To: "influxdb@googlegroups.com" 
>
Date: Friday, June 9, 2017 at 4:49 PM
To: Abridged recipients 
>
Subject: [influxdb] Abridged summary of 
influxdb@googlegroups.com - 1 update in 1 
topic

influxdb@googlegroups.com
   Google 
Groups
   [http://www.google.com/images/icons/product/groups-32.png] 

Today's topic summary
View all 
topics

  *   could influxdb omit time field in select statement~ - 1 Update

could influxdb omit time field in select statement~ 

leafonsw...@gmail.com: Jun 08 11:13PM -0700

when I using "select f1 from measurement", influxdb will give such result with 
a additional time field:
time f1
x x
x x

But in grafana templating, I just want to a result 
...more

Back to top
You received this digest because you're subscribed to updates for this group. 
You can change your settings on the group membership 
page.
To unsubscribe from this group and stop receiving emails from it send an email 
to 
influxdb+unsubscr...@googlegroups.com.

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/D560CE0F.8158%25inselbuch%40unixedge.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] Full Compaction taking 30s and timing out writes and queries

[Frank Inselbuch]

Not sure if this is a problem, but your floating point numbers are likely a 
problem.

4389668.543785445

Is it required to store this many significant digits? Is your 
instrumentation really that accurate? My point is that in order to store 
that as a floating point number would require a large number of bytes. I do 
not know what IFX is doing under the covers to store that but if it is 
really attempting to store that as a floating point number it could be a 
problem. My2c.



On Wednesday, December 28, 2016 at 11:05:17 AM UTC-6, 
jwhe...@greensmith.us.com wrote:
>
> One other strange thing I've noticed is that I'm definitely getting 
> timeouts and slow writes less frequently if I send all 47k values in a 
> single post instead of breaking them up into 5 posts with a max of 10k 
> each. 
>
> Here's the line protocol lines when limiting to 10k values per post (this 
> would be the full data for a single post): 
>
> devices,device=52ABreaker 
> closed=true,hasAlarm=false,hasWarning=false,hasFault=false,hasCriticalFault=false,connected=true,alive=true,health="GOOD"
>  
> 14829443960 
> devices,device=52BBreaker 
> closed=true,hasAlarm=false,hasWarning=false,hasFault=false,hasCriticalFault=false,connected=true,alive=true,health="GOOD"
>  
> 14829443960 
> devices,device=BS1 
> effectiveSoc=0,averageSoc=86.2,soh=100,dcVoltage=0,dcCurrent=0,minCellTemperature=19.332,maxCellTemperature=29.62,avgCellTemperature=24.475,avgStringVoltage=1050.5,watchdogResponse=-2,dcChargedWh=9235745.453942403,dcDischargedWh=4389668.543785445,dcDischargedAh=4562.51825583337,dcChargedAh=9258.921098055504,hasAlarm=false,hasWarning=false,hasFault=false,hasCriticalFault=false,totalDischargeableEnergy=8036317.30001,dcChargeCurrentLimit=0,dcDischargeCurrentLimit=0,dcChargePowerLimit=0,dcDischargePowerLimit=0,allStringsRunning=false,allStringsStopped=true,runningStringCount=0,lockedStringCount=0,communicatingStringCount=102,stoppedStringCount=102,whCapacity=9312600,ahCapacity=9588,dcPower=0,totalChargeableEnergy=1276282.63,reservedDischargeableEnergy=8036317.30001,reservedChargeableEnergy=1276282.63,running=false,soc=0,allowedDischargeableEnergy=0,allowedChargeableEnergy=0,stopped=true,maxCellVoltage=0,avgCellVoltage=0,minCellVoltage=0,minCellVoltageStringNumber=0,maxCellVoltageStringNumber=0,connected=true,alive=true,health="GOOD"
>  
> 14829443960 
> devices,device=BS1-S001 
> running=false,maxCellVoltage=3.986,avgCellVoltage=3.979,maxVoltageCellNumber=6,minVoltageCellNumber=1,moduleFaultPosition=0,minCellVoltage=3.972,minTemperatureCellNumber=1,minCellVoltageModuleNumber=10,maxCellVoltageModuleNumber=16,maxTemperatureCellNumber=1,minCellTemperature=22.05,maxCellTemperatureModuleNumber=4,minCellTemperatureModuleNumber=23,maxCellTemperature=26.86,avgCellTemperature=24.832,soc=86.31,soh=100,dcVoltage=1050.7,dcCurrent=0,dcChargedWh=148374.25137630763,dcDischargedWh=81420.20251502485,dcChargeCurrentLimit=45,dcDischargeCurrentLimit=45,dcDischargedAh=84.6375377904,dcChargedAh=150.0611457367,hasAlarm=false,hasWarning=false,hasFault=false,hasCriticalFault=false,whCapacity=91300,ahCapacity=94,totalDischargeableEnergy=78791.901,dcChargePowerLimit=47281.5,dcDischargePowerLimit=47281.5,dcPower=0,totalChargeableEnergy=12508.0991,allowedDischargeableEnergy=78791.901,allowedChargeableEnergy=12508.0991,reservedDischargeableEnergy=0,reservedChargeableEnergy=0,connected=true,alive=true,health="GOOD"
>  
> 14829443960 
> devices,device=BS1-S002 
> running=false,maxCellVoltage=3.994,avgCellVoltage=3.979,maxVoltageCellNumber=1,minVoltageCellNumber=3,moduleFaultPosition=0,minCellVoltage=3.963,minTemperatureCellNumber=1,minCellVoltageModuleNumber=12,maxCellVoltageModuleNumber=13,maxTemperatureCellNumber=1,minCellTemperature=22.332,maxCellTemperatureModuleNumber=3,minCellTemperatureModuleNumber=24,maxCellTemperature=27.55,avgCellTemperature=25.47,soc=86.31,soh=100,dcVoltage=1050.5,dcCurrent=0,dcChargedWh=149051.0816275147,dcDischargedWh=81243.9893078503,dcChargeCurrentLimit=45,dcDischargeCurrentLimit=45,dcDischargedAh=84.448416,dcChargedAh=150.7695819074,hasAlarm=false,hasWarning=false,hasFault=false,hasCriticalFault=false,whCapacity=91300,ahCapacity=94,totalDischargeableEnergy=78791.901,dcChargePowerLimit=47272.5,dcDischargePowerLimit=47272.5,dcPower=0,totalChargeableEnergy=12508.0991,allowedDischargeableEnergy=78791.901,allowedChargeableEnergy=12508.0991,reservedDischargeableEnergy=0,reservedChargeableEnergy=0,connected=true,alive=true,health="GOOD"
>  
> 14829443960 
> devices,device=BS1-S003 
> 

[influxdb] Re: Any Influxdb user on Windows

[Frank Inselbuch]

admin portal has been deprecated

try to connect to the database using the CLI (command line interface)

just type influx at the command prompt



On Thursday, May 11, 2017 at 7:34:21 AM UTC-5, Manish Jain wrote:
>
> Hi,
>
> I have downloaded the Windows version of InfluxDB.
> although in the config file, I have set http enable and http bound to 8083.
> But still I am unable to start the admin portal.
>
> Any help ?
>
> Manish
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/1da1cc6a-3b13-424f-a3f6-6e521d6d3c1f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] Re: how to write joins

[Frank Inselbuch]

notice that is version 0.8 documentation




Frank Inselbuch
Unix Edge, Inc.
inselb...@unixedge.com
713-701-5421 (primary)
713-240-6700 (cellular)
https://zoom.us/j/7137015421 (telecon)

From: <influxdb@googlegroups.com<mailto:influxdb@googlegroups.com>> on behalf 
of surendra matta <surendrag...@gmail.com<mailto:surendrag...@gmail.com>>
Reply-To: <influxdb@googlegroups.com<mailto:influxdb@googlegroups.com>>
Date: Friday, March 31, 2017 at 9:45 AM
To: InfluxData <influxdb@googlegroups.com<mailto:influxdb@googlegroups.com>>
Cc: 
<a.sanchez.steph...@googlemail.com<mailto:a.sanchez.steph...@googlemail.com>>
Subject: [influxdb] Re: how to write joins

i am trying to execute below query in influxdb by reference of this document 
https://docs.influxdata.com/influxdb/v0.8/api/query_language/

select table1.value,table2.value from jmeter as table1 inner join jmeter as 
table2 where table1.metric = 'avg' and table2.metric = 'pct90' and time > now() 
- 10m ;

Server returned error: error parsing query: found AS, expected ; at line 1, 
char 46


Please correct me if my query is wrong.

Regards,
Venkat
On Thursday, March 30, 2017 at 7:46:01 PM UTC-4, 
a.sanchez...@googlemail.com<mailto:a.sanchez...@googlemail.com> wrote:
I have stubbled across this: 
https://docs.influxdata.com/influxdb/v0.8/api/query_language/ which has two 
sections that might be helpful - Merging Series and Joining Series



On Thursday, March 23, 2017 at 11:24:45 AM UTC-7, surendra matta wrote:
> Hi ,
>
>
> Please let me know how to write joins in influxdb
>
>
> My req :- i have two columns name metric and value
>
>
> in metric i have the values avg and 90 % which is constant and in value i 
> have the values related to avg & 90% but i want to display  Avg and 90 % in a 
> same row instead of separate row in grafana
>
>
> regards,
> Venkat


--
Remember to include the version number!
---
You received this message because you are subscribed to a topic in the Google 
Groups "InfluxData" group.
To unsubscribe from this topic, visit 
https://groups.google.com/d/topic/influxdb/SH_0Ph1gpP4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to 
influxdb+unsubscr...@googlegroups.com<mailto:influxdb+unsubscr...@googlegroups.com>.
To post to this group, send email to 
influxdb@googlegroups.com<mailto:influxdb@googlegroups.com>.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/bed1a9ec-9d1d-4a84-b010-64bc666b6293%40googlegroups.com<https://groups.google.com/d/msgid/influxdb/bed1a9ec-9d1d-4a84-b010-64bc666b6293%40googlegroups.com?utm_medium=email_source=footer>.
For more options, visit https://groups.google.com/d/optout.

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/D503DF4A.40FB%25inselbuch%40unixedge.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: how to write joins

[Frank Inselbuch]

Not clear what you are trying to do.
But joins are not currently supported AFAIK.



On Thursday, March 23, 2017 at 1:24:45 PM UTC-5, surendra matta wrote:
>
> Hi ,
>
> Please let me know how to write joins in influxdb
>
> My req :- i have two columns name metric and value 
>
> in metric i have the values avg and 90 % which is constant and in value i 
> have the values related to avg & 90% but i want to display  Avg and 90 % in 
> a same row instead of separate row in grafana
>
> regards,
> Venkat
>
>
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/bd9586b9-5a90-4855-bdae-e697a9322dca%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: recording delta for same tag

[Frank Inselbuch]

By writing the same measurement, with same tag and the same timestamp, you 
can "add" data to the same recording.
The timestamp must be truly identical... to the nanosecond resolution.

insert m1,id=abc dt=0

then

insert m1,id=abc dt= 

and then you can keep doing that again and again if you like... just keep 
using the same timestamp





On Thursday, March 23, 2017 at 2:32:00 PM UTC-5, keit...@gmail.com wrote:
>
> I am writing to influx like this:
> metric id=abc
>
> sleep 10 secs
> metric id=abc
>
> This creates 2 records (10 secs apart). I would like to record that 10 
> secs onto a single row.
>
> Something like this
> metric id=abc delta=10
>
> How would I do this?
>
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/e9313da8-4c18-49da-81b9-276f3ba48a61%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: Specifying time of datapoint with influxdb-python

[Frank Inselbuch]

 

If I pull data from InfluxDB, I see this timestamp:


2017-01-20T02:20:17.972353024Z



But if I write that same timestamp back, it doesn't seem to honor the 
subseconds and I get an arbitrary timestamp, close to, but not exactly the 
original. The objective is to overwrite a piece of data. So I need the 
timestamp to be exactly the same.


What am I doing wrong?


[{'tags': {'id': '42'}, 'measurement': 'assets', 'fields': {'friendly': 
''}, 'time': '2017-01-20T02:20:17.972353024Z'}]


On Monday, November 30, 2015 at 4:32:06 PM UTC-6, Ryan January wrote:
>
> So far, the ability to supply the exact timestamp of a datapoint has 
> eluded me. 
> I'm currently using a serieshelper, however would not mind refactoring to 
> use write_points if it's required.  
>
> Is this functionality possible?  If so, could someone please point me to 
> the correct documentation/ code sample?
>
> Thank you 
>
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/c16f8e3d-182f-4b55-9f35-7f5368171290%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: InfluxDB Raspberry Pi installation?

[Frank Inselbuch]

After you tar you will install it with dpkg.
It will probably get started automatically at that point.
But if you want to start it/restart/stop just

sudo service influxd start (or restart or stop)

by default I believe the server will be available for http: requests on 
port 8086

i would encourage you to also install something like grafana to pull data 
from influxdb, but you can roll your own with http requests

to work with the database interactively, use the CLI (command line 
interface)

just type 

$ influx

here's a few commands to get you started


Influx> create database test1
Influx> insert cars,vin=3948579834 year=2015,color='Green',mileage=15
Influx> select * from cars

Good luck.








On Thursday, October 13, 2016 at 7:39:27 AM UTC-5, EBRAddict wrote:
>
> Hi,
>
> I'd like to try InfluxDB on a Raspberry Pi 3 for a mobile sensor project. 
> Currently it's logging ~50 data points every 200ms to a USB flash drive 
> text file but I want to ramp that up to 200 every 10ms, or however fast I 
> can push data from the microcontrollers to the Pi.
>
> I downloaded and uncompressed the ARM binaries using the instructions on 
> the InfluxDB download page:
>
> wget 
> https://dl.influxdata.com/influxdb/releases/influxdb-1.0.2_linux_armhf.tar.gz
> tar xvfz influxdb-1.0.2_linux_armhf.tar.gz
>
>
> What are the next steps? I'm not a Linux guy but I can follow directions 
> if someone could point me to them. I'd like to configure the service(s) to 
> run at startup automatically and be accessible for querying by any logged 
> in user (it's a closed system).
>
> Thanks.
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/6b289b57-fbc7-41e7-b33a-e4ac69d29b2f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.